APPS.AP_WEB_EXPENSE_WF dependencies on FND_NEW_MESSAGES

Line 11662: l_message_name fnd_new_messages.message_name%type := 'OIE_WITHDRAWN_NOTE';

11658: l_receipts_status VARCHAR2(30);
11659:
11660: l_entered_by NUMBER := fnd_global.user_id;
11661: l_note varchar2(2000);
11662: l_message_name fnd_new_messages.message_name%type := 'OIE_WITHDRAWN_NOTE';
11663:
11664: l_orig_language_code ap_expense_params.note_language_code%type := null;
11665: l_orig_language fnd_languages.nls_language%type := null;
11666: l_new_language_code ap_expense_params.note_language_code%type := null;

Line 11909: from fnd_new_messages

11905: -- fnd_global.set_nls_context() seems to work for WF but not FND_MESSAGES
11906: -------------------------------------------------------------------
11907: select message_text
11908: into l_note
11909: from fnd_new_messages
11910: where application_id = 200
11911: and message_name = l_message_name
11912: and language_code = l_new_language_code;
11913:

Line 15218: l_message_name fnd_new_messages.message_name%type;

15214: ----------------------------------------------------------------------
15215: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
15216: l_debug_info VARCHAR2(200);
15217:
15218: l_message_name fnd_new_messages.message_name%type;
15219: l_result_type varchar2(80);
15220: l_result_code varchar2(80);
15221: l_response varchar2(80);
15222: l_type_display_name varchar2(80);

Line 15396: from fnd_new_messages

15392: -- fnd_global.set_nls_context() seems to work for WF but not FND_MESSAGES
15393: -------------------------------------------------------------------
15394: select message_text
15395: into l_note_prefix
15396: from fnd_new_messages
15397: where application_id = 200
15398: and message_name = l_message_name
15399: and language_code = l_new_language_code;
15400:

Line 16185: l_instructions fnd_new_messages.message_text%type;

16181:
16182: fixable_exception EXCEPTION;
16183: continue_exception EXCEPTION;
16184: l_error_message VARCHAR2(2000);
16185: l_instructions fnd_new_messages.message_text%type;
16186: l_special_instr fnd_new_messages.message_text%type;
16187: l_no_notif CONSTANT VARCHAR2(20) := 'NO_NOTIFICATION';
16188: l_payment VARCHAR2(20);
16189: l_num_personal_lines NUMBER := 0;

Line 16186: l_special_instr fnd_new_messages.message_text%type;

16182: fixable_exception EXCEPTION;
16183: continue_exception EXCEPTION;
16184: l_error_message VARCHAR2(2000);
16185: l_instructions fnd_new_messages.message_text%type;
16186: l_special_instr fnd_new_messages.message_text%type;
16187: l_no_notif CONSTANT VARCHAR2(20) := 'NO_NOTIFICATION';
16188: l_payment VARCHAR2(20);
16189: l_num_personal_lines NUMBER := 0;
16190: l_employee_id NUMBER;