DBA Data[Home] [Help]

APPS.AP_WEB_EXPENSE_WF dependencies on FND_NEW_MESSAGES

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

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;

Line 11146: from fnd_new_messages

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:

Line 14330: l_message_name fnd_new_messages.message_name%type;

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);

Line 14464: from fnd_new_messages

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:

Line 15217: l_instructions fnd_new_messages.message_text%type;

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');

Line 15218: l_special_instr fnd_new_messages.message_text%type;

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: