WHENEVER SQLERROR EXIT FAILURE ROLLBACK;
WHENEVER OSERROR  EXIT FAILURE ROLLBACK;

spool CSH_TRANSACTION_PROMPT.log

set feedback off
set define off
begin
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH511.CSH_TRANSACTION.RETURNED_AMOUNT',
                                  p_language => 'ZHS',
                                  p_description => '已退款金额',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.TRANSACTION_AMOUNT_FROM',
                                  p_language => 'ZHS',
                                  p_description => '收款金额从',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.TRANSACTION_AMOUNT_TO',
                                  p_language => 'ZHS',
                                  p_description => '收款金额到',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.MY_ACCOUNT_NAME',
                                  p_language => 'ZHS',
                                  p_description => '我方账户户名',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.MY_BANK_NAME',
                                  p_language => 'ZHS',
                                  p_description => '我方银行名称',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.MY_ACCOUNT_USERNAME',
                                  p_language => 'ZHS',
                                  p_description => '我方账户账号',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.BANK_CASH_CODE',
                                  p_language => 'ZHS',
                                  p_description => '银行流水号',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.YOUR_ACCOUNT_NAME',
                                  p_language => 'ZHS',
                                  p_description => '对方账户户名',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.YOUR_BANK_NAME',
                                  p_language => 'ZHS',
                                  p_description => '对方银行名称',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.YOUR_ACCOUNT_USERNAME',
                                  p_language => 'ZHS',
                                  p_description => '对方账户账号',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.BUSINESS_PARTNER',
                                  p_language => 'ZHS',
                                  p_description => '商业伙伴',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.BILL_STATUS',
                                  p_language => 'ZHS',
                                  p_description => '单据状态',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.WRITTEN_OFF_STATUS',
                                  p_language => 'ZHS',
                                  p_description => '核销状态',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.PURPOSE_OF_FUNDS',
                                  p_language => 'ZHS',
                                  p_description => '款项用途',
                                  p_created_by => 1);
  sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.RECEIVE_MONEY_IMPORT_BTN',
                                  p_language => 'ZHS',
                                  p_description => '收款导入',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.MONEY_HAND_ADD_BTN',
                                  p_language => 'ZHS',
                                  p_description => '收款手动新增',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.APPLY_NEW_BTN',
                                  p_language => 'ZHS',
                                  p_description => '新增申请',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.DROP_BTN',
                                  p_language => 'ZHS',
                                  p_description => '作废',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'HLS.DOCUMENT_CONFIRMED_BY',
                                  p_language => 'ZHS',
                                  p_description => '确认人',
                                  p_created_by => 1);
 sys_message_pkg.delete_message('E_NO_THIS_ACCOUNT');
  sys_message_pkg.insert_message('E_NO_THIS_ACCOUNT',
                                 '错误',
                                 '我方没有此银行账号!','ZHS');
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.CSH_TRANSACTION_NUM',
                                  p_language => 'ZHS',
                                  p_description => '现金事务编号',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.RECEIPT_TYPE',
                                  p_language => 'ZHS',
                                  p_description => '收款类型',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.RECEIPT_AMOUNT',
                                  p_language => 'ZHS',
                                  p_description => '收款金额',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.RETURN_AMOUNT',
                                  p_language => 'ZHS',
                                  p_description => '退款金额',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.USEFUL_AMOUNT',
                                  p_language => 'ZHS',
                                  p_description => '可用金额',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.DESCRIPTION',
                                  p_language => 'ZHS',
                                  p_description => '摘要',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.MY_ACCOUNT',
                                  p_language => 'ZHS',
                                  p_description => '我方账户',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.YOUR_ACCOUNT',
                                  p_language => 'ZHS',
                                  p_description => '对方账户',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.ACCOUNT_NAME',
                                  p_language => 'ZHS',
                                  p_description => '户名',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.ACCOUNT_BANK',
                                  p_language => 'ZHS',
                                  p_description => '银行',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.ACCOUNT_NUM',
                                  p_language => 'ZHS',
                                  p_description => '账号',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.DEPT_CONFIRMER',
                                  p_language => 'ZHS',
                                  p_description => '债权确认人',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH510.CSH_TRANSACTION.ACCT_CONFIRMER',
                                  p_language => 'ZHS',
                                  p_description => '会计确认人',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH509.CSH_RECEIPT_CONFIRM.NEW_APPLY_BTN',
                                  p_language => 'ZHS',
                                  p_description => '新增确认',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH509.CSH_RECEIPT_CONFIRM.REFUSE_BTN',
                                  p_language => 'ZHS',
                                  p_description => '新增驳回',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH509.CSH_RECEIPT_CONFIRM.DROP_BTN',
                                  p_language => 'ZHS',
                                  p_description => '作废',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH509.CSH_RECEIPT_CONFIRM.QUERY_BTN',
                                  p_language => 'ZHS',
                                  p_description => '查询',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH511.CSH_TRANSACTION.MANUAL_ADD',
                                  p_language => 'ZHS',
                                  p_description => '收款手动新增',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH511.CSH_TRANSACTION.CLASS_DESC',
                                  p_language => 'ZHS',
                                  p_description => '款项分类',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH511.CSH_TRANSACTION.STATEMENT',
                                  p_language => 'ZHS',
                                  p_description => '备注',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH511.CSH_TRANSACTION.BANK_INFO',
                                  p_language => 'ZHS',
                                  p_description => '账户信息',
                                  p_created_by => 1);
sys_prompt_pkg.sys_prompts_load(p_prompt_code => 'CSH511.CSH_TRANSACTION.ATTACHMENT',
                                  p_language => 'ZHS',
                                  p_description => '附件',
                                  p_created_by => 1);

end;
/
commit;
set feedback on
set define on

spool off

exit