DBA Data[Home] [Help]

APPS.AP_WEB_EXPENSE_WF dependencies on FND_GLOBAL

Line 9673: FND_GLOBAL.APPS_INITIALIZE( USER_ID => l_n_user_id,

9669:
9670: IF (p_s_command = 'SET_CTX') THEN
9671:
9672: -- Set the context
9673: FND_GLOBAL.APPS_INITIALIZE( USER_ID => l_n_user_id,
9674: RESP_ID => l_n_resp_id,
9675: RESP_APPL_ID => l_n_resp_appl_id
9676: );
9677:

Line 9679: -- Needs to be after FND_GLOBAL.APPS_INITIALIZE because

9675: RESP_APPL_ID => l_n_resp_appl_id
9676: );
9677:
9678: -- Set Org context
9679: -- Needs to be after FND_GLOBAL.APPS_INITIALIZE because
9680: -- user_id, resp_id, and appl_id may be null because
9681: -- the attributes don't exist or because they are not set
9682: if (l_n_org_id is not null) then
9683: mo_global.set_policy_context(p_access_mode => 'S',

Line 9752: l_entered_by NUMBER := fnd_global.user_id;

9748:
9749: l_debug_info VARCHAR2(1000);
9750:
9751: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
9752: l_entered_by NUMBER := fnd_global.user_id;
9753: l_role_info_tbl wf_directory.wf_local_roles_tbl_type;
9754:
9755: l_orig_language_code ap_expense_params.note_language_code%type := null;
9756: l_orig_language fnd_languages.nls_language%type := null;

Line 9810: fnd_global.set_nls_context(p_nls_language => l_new_language);

9806: into l_new_language
9807: from fnd_languages
9808: where language_code = l_new_language_code;
9809:
9810: fnd_global.set_nls_context(p_nls_language => l_new_language);
9811:
9812: ------------------------------------------------------------
9813: l_debug_info := 'Retrieve Expense_Report_ID Item Attribute';
9814: ------------------------------------------------------------

Line 9846: fnd_global.set_nls_context(p_nls_language => l_orig_language);

9842:
9843: -------------------------------------------------------------------
9844: l_debug_info := 'Restore nls context to original language';
9845: -------------------------------------------------------------------
9846: fnd_global.set_nls_context(p_nls_language => l_orig_language);
9847: END IF;
9848:
9849: EXCEPTION
9850: WHEN OTHERS THEN

Line 9883: l_entered_by NUMBER := fnd_global.user_id;

9879: l_approver_id NUMBER;
9880: l_approver_name varchar2(240);
9881:
9882: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
9883: l_entered_by NUMBER := fnd_global.user_id;
9884: l_role_info_tbl wf_directory.wf_local_roles_tbl_type;
9885:
9886: l_orig_language_code ap_expense_params.note_language_code%type := null;
9887: l_orig_language fnd_languages.nls_language%type := null;

Line 9955: fnd_global.set_nls_context(p_nls_language => l_new_language);

9951: into l_new_language
9952: from fnd_languages
9953: where language_code = l_new_language_code;
9954:
9955: fnd_global.set_nls_context(p_nls_language => l_new_language);
9956:
9957: -----------------------------------------
9958: l_debug_info := 'Get the Notification ID';
9959: -----------------------------------------

Line 9996: fnd_global.set_nls_context(p_nls_language => l_orig_language);

9992:
9993: -------------------------------------------------------------------
9994: l_debug_info := 'Restore nls context to original language';
9995: -------------------------------------------------------------------
9996: fnd_global.set_nls_context(p_nls_language => l_orig_language);
9997:
9998: elsif (p_funmode in ('TRANSFER','FORWARD')) then
9999: -----------------------------------------
10000: l_debug_info := 'Get the Notification ID';

Line 10906: l_entered_by NUMBER := fnd_global.user_id;

10902: l_end_date wf_items.end_date%TYPE;
10903: l_AMEEnabled VARCHAR2(1);
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;

Line 11138: fnd_global.set_nls_context(p_nls_language => l_new_language);

11134: into l_new_language
11135: from fnd_languages
11136: where language_code = l_new_language_code;
11137:
11138: fnd_global.set_nls_context(p_nls_language => l_new_language);
11139:
11140: begin
11141: -------------------------------------------------------------------
11142: -- fnd_global.set_nls_context() seems to work for WF but not FND_MESSAGES

Line 11142: -- fnd_global.set_nls_context() seems to work for WF but not FND_MESSAGES

11138: fnd_global.set_nls_context(p_nls_language => l_new_language);
11139:
11140: begin
11141: -------------------------------------------------------------------
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

Line 11169: fnd_global.set_nls_context(p_nls_language => l_orig_language);

11165:
11166: -------------------------------------------------------------------
11167: l_debug_info := 'Restore nls context to original language';
11168: -------------------------------------------------------------------
11169: fnd_global.set_nls_context(p_nls_language => l_orig_language);
11170:
11171: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF',
11172: 'end WF WithdrawExpenseRep');
11173: COMMIT;

Line 14343: l_entered_by NUMBER := fnd_global.user_id;

14339: l_orig_language fnd_languages.nls_language%type := null;
14340: l_new_language_code ap_expense_params.note_language_code%type := null;
14341: l_new_language fnd_languages.nls_language%type := null;
14342:
14343: l_entered_by NUMBER := fnd_global.user_id;
14344: l_user_name fnd_user.user_name%TYPE := null;
14345: l_ame_enabled varchar2(1) := 'N';
14346:
14347: BEGIN

Line 14397: fnd_global.set_nls_context(p_nls_language => l_new_language);

14393: into l_new_language
14394: from fnd_languages
14395: where language_code = l_new_language_code;
14396:
14397: fnd_global.set_nls_context(p_nls_language => l_new_language);
14398:
14399: -------------------------------------------------------------------
14400: l_debug_info := 'Retrieve Activity Result Type';
14401: -------------------------------------------------------------------

Line 14460: -- fnd_global.set_nls_context() seems to work for WF but not FND_MESSAGES

14456: end if;
14457:
14458: begin
14459: -------------------------------------------------------------------
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

Line 14520: fnd_global.set_nls_context(p_nls_language => l_orig_language);

14516:
14517: -------------------------------------------------------------------
14518: l_debug_info := 'Restore nls context to original language';
14519: -------------------------------------------------------------------
14520: fnd_global.set_nls_context(p_nls_language => l_orig_language);
14521:
14522: -------------------------------------------------------------------
14523: -- only clear audit issues if it is a preparer response
14524: -------------------------------------------------------------------