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