10904: l_receipts_status VARCHAR2(30);
10905:
10906: l_entered_by NUMBER := fnd_global.user_id;
10907: l_note varchar2(2000);
10908: l_message_name fnd_new_messages.message_name%type := 'OIE_WITHDRAWN_NOTE';
10909:
10910: l_orig_language_code ap_expense_params.note_language_code%type := null;
10911: l_orig_language fnd_languages.nls_language%type := null;
10912: l_new_language_code ap_expense_params.note_language_code%type := null;
11142: -- fnd_global.set_nls_context() seems to work for WF but not FND_MESSAGES
11143: -------------------------------------------------------------------
11144: select message_text
11145: into l_note
11146: from fnd_new_messages
11147: where application_id = 200
11148: and message_name = l_message_name
11149: and language_code = l_new_language_code;
11150:
14326: ----------------------------------------------------------------------
14327: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
14328: l_debug_info VARCHAR2(200);
14329:
14330: l_message_name fnd_new_messages.message_name%type;
14331: l_result_type varchar2(80);
14332: l_result_code varchar2(80);
14333: l_response varchar2(80);
14334: l_type_display_name varchar2(80);
14460: -- fnd_global.set_nls_context() seems to work for WF but not FND_MESSAGES
14461: -------------------------------------------------------------------
14462: select message_text
14463: into l_note_prefix
14464: from fnd_new_messages
14465: where application_id = 200
14466: and message_name = l_message_name
14467: and language_code = l_new_language_code;
14468:
15213: l_master_report_id number;
15214:
15215: fixable_exception EXCEPTION;
15216: l_error_message VARCHAR2(2000);
15217: l_instructions fnd_new_messages.message_text%type;
15218: l_special_instr fnd_new_messages.message_text%type;
15219: BEGIN
15220:
15221: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start AMERequestApproval');
15214:
15215: fixable_exception EXCEPTION;
15216: l_error_message VARCHAR2(2000);
15217: l_instructions fnd_new_messages.message_text%type;
15218: l_special_instr fnd_new_messages.message_text%type;
15219: BEGIN
15220:
15221: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start AMERequestApproval');
15222: