eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_WEB_EXPENSE_WF dependencies on FND_GLOBAL

Line 3965: --last_updated_by = Decode(Nvl(fnd_global.user_id,-1),-1,last_updated_by,fnd_global.user_id)

3961: -------------------------------------------------------------------
3962: UPDATE ap_expense_report_headers_all
3963: SET expense_status_code = 'INVOICED',
3964: last_update_date = SYSDATE
3965: --last_updated_by = Decode(Nvl(fnd_global.user_id,-1),-1,last_updated_by,fnd_global.user_id)
3966: WHERE report_header_id = l_report_header_id;
3967: END IF;
3968:
3969: ----------------------------------------------------------------------

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

10115:
10116: IF (p_s_command = 'SET_CTX') THEN
10117:
10118: -- Set the context
10119: FND_GLOBAL.APPS_INITIALIZE( USER_ID => l_n_user_id,
10120: RESP_ID => l_n_resp_id,
10121: RESP_APPL_ID => l_n_resp_appl_id
10122: );
10123:

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

10121: RESP_APPL_ID => l_n_resp_appl_id
10122: );
10123:
10124: -- Set Org context
10125: -- Needs to be after FND_GLOBAL.APPS_INITIALIZE because
10126: -- user_id, resp_id, and appl_id may be null because
10127: -- the attributes don't exist or because they are not set
10128: if (l_n_org_id is not null) then
10129: mo_global.set_policy_context(p_access_mode => 'S',

Line 10198: l_entered_by NUMBER := fnd_global.user_id;

10194:
10195: l_debug_info VARCHAR2(1000);
10196:
10197: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
10198: l_entered_by NUMBER := fnd_global.user_id;
10199: l_role_info_tbl wf_directory.wf_local_roles_tbl_type;
10200:
10201: l_orig_language_code ap_expense_params.note_language_code%type := null;
10202: l_orig_language fnd_languages.nls_language%type := null;

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

10252: into l_new_language
10253: from fnd_languages
10254: where language_code = l_new_language_code;
10255:
10256: fnd_global.set_nls_context(p_nls_language => l_new_language);
10257:
10258: ------------------------------------------------------------
10259: l_debug_info := 'Retrieve Expense_Report_ID Item Attribute';
10260: ------------------------------------------------------------

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

10288:
10289: -------------------------------------------------------------------
10290: l_debug_info := 'Restore nls context to original language';
10291: -------------------------------------------------------------------
10292: fnd_global.set_nls_context(p_nls_language => l_orig_language);
10293: END IF;
10294:
10295: EXCEPTION
10296: WHEN OTHERS THEN

Line 10334: l_entered_by NUMBER := fnd_global.user_id;

10330: l_approverResponse varchar2(80);
10331: l_approvalStatusIn varchar2(20);
10332:
10333: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
10334: l_entered_by NUMBER := fnd_global.user_id;
10335: l_role_info_tbl wf_directory.wf_local_roles_tbl_type;
10336:
10337: l_orig_language_code ap_expense_params.note_language_code%type := null;
10338: l_orig_language fnd_languages.nls_language%type := null;

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

10498: into l_new_language
10499: from fnd_languages
10500: where language_code = l_new_language_code;
10501:
10502: fnd_global.set_nls_context(p_nls_language => l_new_language);
10503:
10504: -----------------------------------------
10505: l_debug_info := 'Get the Notification ID';
10506: -----------------------------------------

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

10554:
10555: -------------------------------------------------------------------
10556: l_debug_info := 'Restore nls context to original language';
10557: -------------------------------------------------------------------
10558: fnd_global.set_nls_context(p_nls_language => l_orig_language);
10559:
10560: elsif (p_funmode in ('TRANSFER','FORWARD')) then
10561: -----------------------------------------
10562: l_debug_info := 'Get the Notification ID';

Line 11550: --last_updated_by = Decode(Nvl(fnd_global.user_id,-1),-1,last_updated_by,fnd_global.user_id)

11546: expense_current_approver_id = l_current_approver_id,
11547: expense_last_status_date=sysdate,
11548: source = nvl(l_source, source),
11549: last_update_date = sysdate
11550: --last_updated_by = Decode(Nvl(fnd_global.user_id,-1),-1,last_updated_by,fnd_global.user_id)
11551: WHERE report_header_id = l_report_header_id
11552: and nvl(expense_status_code, 'NULL') <> 'PAID'; -- Bug: 13482337, 13870204
11553:
11554: p_result := 'COMPLETE:Y';

Line 11660: l_entered_by NUMBER := fnd_global.user_id;

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

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

11897: into l_new_language
11898: from fnd_languages
11899: where language_code = l_new_language_code;
11900:
11901: fnd_global.set_nls_context(p_nls_language => l_new_language);
11902:
11903: begin
11904: -------------------------------------------------------------------
11905: -- fnd_global.set_nls_context() seems to work for WF but not FND_MESSAGES

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

11901: fnd_global.set_nls_context(p_nls_language => l_new_language);
11902:
11903: begin
11904: -------------------------------------------------------------------
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

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

11928:
11929: -------------------------------------------------------------------
11930: l_debug_info := 'Restore nls context to original language';
11931: -------------------------------------------------------------------
11932: fnd_global.set_nls_context(p_nls_language => l_orig_language);
11933:
11934: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF',
11935: 'end WF WithdrawExpenseRep');
11936: COMMIT;

Line 15231: l_entered_by NUMBER := fnd_global.user_id;

15227: l_orig_language fnd_languages.nls_language%type := null;
15228: l_new_language_code ap_expense_params.note_language_code%type := null;
15229: l_new_language fnd_languages.nls_language%type := null;
15230:
15231: l_entered_by NUMBER := fnd_global.user_id;
15232: l_user_name fnd_user.user_name%TYPE := null;
15233: l_ame_enabled varchar2(1) := 'N';
15234:
15235: l_approval_type AP_EXPENSE_REPORT_HEADERS_ALL.APPROVAL_TYPE%TYPE;

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

15284: into l_new_language
15285: from fnd_languages
15286: where language_code = l_new_language_code;
15287:
15288: fnd_global.set_nls_context(p_nls_language => l_new_language);
15289:
15290: -------------------------------------------------------------------
15291: l_debug_info := 'Retrieve Activity Result Type';
15292: -------------------------------------------------------------------

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

15388: end if;
15389:
15390: begin
15391: -------------------------------------------------------------------
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

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

15456:
15457: -------------------------------------------------------------------
15458: l_debug_info := 'Restore nls context to original language';
15459: -------------------------------------------------------------------
15460: fnd_global.set_nls_context(p_nls_language => l_orig_language);
15461:
15462: -------------------------------------------------------------------
15463: -- only clear audit issues if it is a preparer response
15464: -------------------------------------------------------------------

Line 17440: last_updated_by = Decode(Nvl(fnd_global.user_id,-1),-1,last_updated_by,fnd_global.user_id)

17436:
17437: UPDATE ap_expense_report_headers
17438: SET image_receipts_status = l_image_receipts_status,
17439: last_update_date = sysdate,
17440: last_updated_by = Decode(Nvl(fnd_global.user_id,-1),-1,last_updated_by,fnd_global.user_id)
17441: WHERE report_header_id = l_report_header_id;
17442:
17443:
17444:

Line 17476: last_updated_by = Decode(Nvl(fnd_global.user_id,-1),-1,last_updated_by,fnd_global.user_id)

17472:
17473: UPDATE ap_expense_report_headers
17474: SET receipts_status = l_orig_receipts_status,
17475: last_update_date = sysdate,
17476: last_updated_by = Decode(Nvl(fnd_global.user_id,-1),-1,last_updated_by,fnd_global.user_id)
17477: WHERE report_header_id = l_report_header_id;
17478:
17479:
17480:

Line 17512: last_updated_by = Decode(Nvl(fnd_global.user_id,-1),-1,last_updated_by,fnd_global.user_id)

17508:
17509: UPDATE ap_expense_report_headers
17510: SET expense_status_code = l_expense_status_code,
17511: last_update_date = sysdate,
17512: last_updated_by = Decode(Nvl(fnd_global.user_id,-1),-1,last_updated_by,fnd_global.user_id)
17513: WHERE report_header_id = l_report_header_id;
17514:
17515:
17516: