WHENEVER SQLERROR EXIT FAILURE ROLLBACK; 
WHENEVER OSERROR  EXIT FAILURE ROLLBACK;
spool SYS_MESSAGES.sql.log 
set feedback off
set define off 

Insert into SYS_MESSAGES (MESSAGE_CODE,LANGUAGE,MESSAGE_NAME,MODULE_ID,MESSAGE,CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY) values ('FND_LANGUAGE_CODE_UNIQUE_ERROR','ZHS','错误',null,'语言代码重复，请重新输入!',to_date('2012-06-12 13:45:43','YYYY-MM-DD HH24:MI:SS'),1,to_date('2012-06-12 13:45:43','YYYY-MM-DD HH24:MI:SS'),1);
Insert into SYS_MESSAGES (MESSAGE_CODE,LANGUAGE,MESSAGE_NAME,MODULE_ID,MESSAGE,CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY) values ('FND_LANGUAGE_CODE_UNIQUE_ERROR','US','ERROR',null,'Code must be Unique,Please enter again !',to_date('2012-06-12 13:45:43','YYYY-MM-DD HH24:MI:SS'),1,to_date('2012-06-12 13:45:43','YYYY-MM-DD HH24:MI:SS'),1);
Insert into SYS_MESSAGES (MESSAGE_CODE,LANGUAGE,MESSAGE_NAME,MODULE_ID,MESSAGE,CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY) values ('SYS_PASSWORD_FAILURE','ZHS','错误',null,'密码错误，请重新输入!',to_date('2012-06-19 16:05:48','YYYY-MM-DD HH24:MI:SS'),1,to_date('2012-06-19 16:05:48','YYYY-MM-DD HH24:MI:SS'),1);
Insert into SYS_MESSAGES (MESSAGE_CODE,LANGUAGE,MESSAGE_NAME,MODULE_ID,MESSAGE,CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY) values ('SYS_PASSWORD_FAILURE','US','ERROR',null,'password failure, please re-enter!',to_date('2012-06-19 16:05:48','YYYY-MM-DD HH24:MI:SS'),1,to_date('2012-06-19 16:05:48','YYYY-MM-DD HH24:MI:SS'),1);
Insert into SYS_MESSAGES (MESSAGE_CODE,LANGUAGE,MESSAGE_NAME,MODULE_ID,MESSAGE,CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY) values ('SYS_PASSWORD_NULL','ZHS','错误',null,'密码为空，请输入!',to_date('2012-06-19 16:05:48','YYYY-MM-DD HH24:MI:SS'),1,to_date('2012-06-19 16:05:48','YYYY-MM-DD HH24:MI:SS'),1);
Insert into SYS_MESSAGES (MESSAGE_CODE,LANGUAGE,MESSAGE_NAME,MODULE_ID,MESSAGE,CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY) values ('SYS_PASSWORD_NULL','US','ERROR',null,'password null, please re-enter!',to_date('2012-06-19 16:05:48','YYYY-MM-DD HH24:MI:SS'),1,to_date('2012-06-19 16:05:48','YYYY-MM-DD HH24:MI:SS'),1);
Insert into SYS_MESSAGES (MESSAGE_CODE,LANGUAGE,MESSAGE_NAME,MODULE_ID,MESSAGE,CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY) values ('SYS_USER_FAILURE','ZHS','错误',null,'用户无效，请重新输入!',to_date('2012-06-19 16:05:48','YYYY-MM-DD HH24:MI:SS'),1,to_date('2012-06-19 16:05:48','YYYY-MM-DD HH24:MI:SS'),1);
Insert into SYS_MESSAGES (MESSAGE_CODE,LANGUAGE,MESSAGE_NAME,MODULE_ID,MESSAGE,CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY) values ('SYS_USER_FAILURE','US','ERROR',null,'user failure, please re-enter!',to_date('2012-06-19 16:05:48','YYYY-MM-DD HH24:MI:SS'),1,to_date('2012-06-19 16:05:48','YYYY-MM-DD HH24:MI:SS'),1);
Insert into SYS_MESSAGES (MESSAGE_CODE,LANGUAGE,MESSAGE_NAME,MODULE_ID,MESSAGE,CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY) values ('SYS_USER_NULL','ZHS','错误',null,'用户不存在，请重新输入!',to_date('2012-06-19 16:05:48','YYYY-MM-DD HH24:MI:SS'),1,to_date('2012-06-19 16:05:48','YYYY-MM-DD HH24:MI:SS'),1);
Insert into SYS_MESSAGES (MESSAGE_CODE,LANGUAGE,MESSAGE_NAME,MODULE_ID,MESSAGE,CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY) values ('SYS_USER_NULL','US','ERROR',null,'user is null, please re-enter!',to_date('2012-06-19 16:05:48','YYYY-MM-DD HH24:MI:SS'),1,to_date('2012-06-19 16:05:48','YYYY-MM-DD HH24:MI:SS'),1);
Insert into SYS_MESSAGES (MESSAGE_CODE,LANGUAGE,MESSAGE_NAME,MODULE_ID,MESSAGE,CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY) values ('SYS_LANGUAGE_NULL','ZHS','错误',null,'语言环境不存在，请重新选择!',to_date('2012-06-19 16:05:48','YYYY-MM-DD HH24:MI:SS'),1,to_date('2012-06-19 16:05:48','YYYY-MM-DD HH24:MI:SS'),1);
Insert into SYS_MESSAGES (MESSAGE_CODE,LANGUAGE,MESSAGE_NAME,MODULE_ID,MESSAGE,CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY) values ('SYS_LANGUAGE_NULL','US','ERROR',null,'language is null, please re-enter!',to_date('2012-06-19 16:05:48','YYYY-MM-DD HH24:MI:SS'),1,to_date('2012-06-19 16:05:48','YYYY-MM-DD HH24:MI:SS'),1);
Insert into SYS_MESSAGES (MESSAGE_CODE,LANGUAGE,MESSAGE_NAME,MODULE_ID,MESSAGE,CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY) values ('SYS_FROZEN_FAILURE','ZHS','错误',null,'用户被冻结，请联系系统管理员!',to_date('2012-06-19 16:05:48','YYYY-MM-DD HH24:MI:SS'),1,to_date('2012-06-19 16:05:48','YYYY-MM-DD HH24:MI:SS'),1);
Insert into SYS_MESSAGES (MESSAGE_CODE,LANGUAGE,MESSAGE_NAME,MODULE_ID,MESSAGE,CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY) values ('SYS_FROZEN_FAILURE','US','ERROR',null,'frozen_failure,please contact the system administrator!',to_date('2012-06-19 16:05:48','YYYY-MM-DD HH24:MI:SS'),1,to_date('2012-06-19 16:05:48','YYYY-MM-DD HH24:MI:SS'),1);
Insert into SYS_MESSAGES (MESSAGE_CODE,LANGUAGE,MESSAGE_NAME,MODULE_ID,MESSAGE,CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY) values ('SYS_PASSWORD_EXPIRED','ZHS','错误',null,'密码已过期，请重新设定密码！',to_date('2012-06-19 16:05:48','YYYY-MM-DD HH24:MI:SS'),1,to_date('2012-06-19 16:05:48','YYYY-MM-DD HH24:MI:SS'),1);
Insert into SYS_MESSAGES (MESSAGE_CODE,LANGUAGE,MESSAGE_NAME,MODULE_ID,MESSAGE,CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY) values ('SYS_PASSWORD_EXPIRED','US','ERROR',null,'Password has expired, please reset your password!',to_date('2012-06-19 16:05:48','YYYY-MM-DD HH24:MI:SS'),1,to_date('2012-06-19 16:05:48','YYYY-MM-DD HH24:MI:SS'),1);
Insert into SYS_MESSAGES (MESSAGE_CODE,LANGUAGE,MESSAGE_NAME,MODULE_ID,MESSAGE,CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY) values ('SYS_FIRST_LOGIN_CHANGE_PASSWORD','ZHS','错误',null,'您尚未修改初始密码，请重新设定密码！',to_date('2012-06-19 16:05:48','YYYY-MM-DD HH24:MI:SS'),1,to_date('2012-06-19 16:05:48','YYYY-MM-DD HH24:MI:SS'),1);
Insert into SYS_MESSAGES (MESSAGE_CODE,LANGUAGE,MESSAGE_NAME,MODULE_ID,MESSAGE,CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY) values ('SYS_FIRST_LOGIN_CHANGE_PASSWORD','US','ERROR',null,'First login must change password, please reset your password!',to_date('2012-06-19 16:05:48','YYYY-MM-DD HH24:MI:SS'),1,to_date('2012-06-19 16:05:48','YYYY-MM-DD HH24:MI:SS'),1);
Insert into SYS_MESSAGES (MESSAGE_CODE,LANGUAGE,MESSAGE_NAME,MODULE_ID,MESSAGE,CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY) values ('SYS_USER_ROLE_NULL','ZHS','错误',null,'该用户没有被分配合适的角色，或者角色已失效！',to_date('2012-06-19 16:05:48','YYYY-MM-DD HH24:MI:SS'),1,to_date('2012-06-19 16:05:48','YYYY-MM-DD HH24:MI:SS'),1);
Insert into SYS_MESSAGES (MESSAGE_CODE,LANGUAGE,MESSAGE_NAME,MODULE_ID,MESSAGE,CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY) values ('SYS_USER_ROLE_NULL','US','ERROR',null,'User role check error!',to_date('2012-06-19 16:05:48','YYYY-MM-DD HH24:MI:SS'),1,to_date('2012-06-19 16:05:48','YYYY-MM-DD HH24:MI:SS'),1);
Insert into SYS_MESSAGES (MESSAGE_CODE,LANGUAGE,MESSAGE_NAME,MODULE_ID,MESSAGE,CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY) values ('SYS_USER_PASSWORD_EXPIRED','ZHS','错误',null,'你的密码已经过期，请修改密码!',to_date('2012-06-19 16:05:48','YYYY-MM-DD HH24:MI:SS'),1,to_date('2012-06-19 16:05:48','YYYY-MM-DD HH24:MI:SS'),1);
Insert into SYS_MESSAGES (MESSAGE_CODE,LANGUAGE,MESSAGE_NAME,MODULE_ID,MESSAGE,CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY) values ('SYS_USER_PASSWORD_EXPIRED','US','ERROR',null,'Password has expired, please reset your password!',to_date('2012-06-19 16:05:48','YYYY-MM-DD HH24:MI:SS'),1,to_date('2012-06-19 16:05:48','YYYY-MM-DD HH24:MI:SS'),1);
Insert into SYS_MESSAGES (MESSAGE_CODE,LANGUAGE,MESSAGE_NAME,MODULE_ID,MESSAGE,CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY) values ('SYS_USER_PASSWORD_RULE_CHECK_INVALID','ZHS','错误',null,'你的密码不符合系统设定的密码规则定义，请重新修改密码!',to_date('2012-06-19 16:05:48','YYYY-MM-DD HH24:MI:SS'),1,to_date('2012-06-19 16:05:48','YYYY-MM-DD HH24:MI:SS'),1);
Insert into SYS_MESSAGES (MESSAGE_CODE,LANGUAGE,MESSAGE_NAME,MODULE_ID,MESSAGE,CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY) values ('SYS_USER_PASSWORD_RULE_CHECK_INVALID','US','ERROR',null,'Password has invalid, please reset your password!',to_date('2012-06-19 16:05:48','YYYY-MM-DD HH24:MI:SS'),1,to_date('2012-06-19 16:05:48','YYYY-MM-DD HH24:MI:SS'),1);
Insert into SYS_MESSAGES (MESSAGE_CODE,LANGUAGE,MESSAGE_NAME,MODULE_ID,MESSAGE,CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY) values ('FND2040_COMPANY_LEVELS_CODE_DUPLICATE','ZHS','错误',null,'公司级别代码不能重复，请重新输入！',to_date('2012-06-18 10:49:22','YYYY-MM-DD HH24:MI:SS'),1,to_date('2012-07-03 14:44:42','YYYY-MM-DD HH24:MI:SS'),21);
Insert into SYS_MESSAGES (MESSAGE_CODE,LANGUAGE,MESSAGE_NAME,MODULE_ID,MESSAGE,CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY) values ('FND2040_COMPANY_LEVELS_CODE_DUPLICATE','US','Error',null,'Company level code must be unique!',to_date('2012-06-18 10:49:22','YYYY-MM-DD HH24:MI:SS'),1,to_date('2012-06-18 10:49:22','YYYY-MM-DD HH24:MI:SS'),1);

commit; 
set feedback on  
set define on 
spool off 
exit 
 