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.PO_WF_REQ_NOTIFICATION dependencies on FND_PROFILE

Line 5: g_po_wf_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_WORKFLOW_ON'),'N');

1: PACKAGE BODY PO_WF_REQ_NOTIFICATION AS
2: /* $Header: POXWPA6B.pls 120.14.12000000.3 2007/05/04 00:01:49 lswamy ship $ */
3:
4: -- Read the profile option that enables/disables the debug log
5: g_po_wf_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_WORKFLOW_ON'),'N');
6:
7: g_req_line_allowed_length number := 32000; -- Bug 3592883
8: -- Local procedure
9:

Line 230: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');

226:
227:
228: NL VARCHAR2(1) := fnd_global.newline;
229:
230: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');
231:
232: l_notification_id number;
233:
234: BEGIN

Line 477: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');

473: l_document_3 VARCHAR2(32000) := '';
474:
475: NL VARCHAR2(1) := fnd_global.newline;
476:
477: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');
478: l_notification_id number;
479:
480: BEGIN
481:

Line 744: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');

740: l_document_3 VARCHAR2(32000) := '';
741:
742: NL VARCHAR2(1) := fnd_global.newline;
743:
744: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');
745: l_notification_id number;
746:
747: BEGIN
748:

Line 969: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');

965: l_document_3 VARCHAR2(32000) := '';
966:
967: NL VARCHAR2(1) := fnd_global.newline;
968:
969: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');
970: l_notification_id number;
971:
972: BEGIN
973:

Line 1262: --FND_PROFILE.GET('USER_ID', l_user_id);

1258: /* Bug 2606838
1259: ** Set the context only if it is not set already
1260: */
1261:
1262: --FND_PROFILE.GET('USER_ID', l_user_id);
1263: --FND_PROFILE.GET('RESP_ID', l_responsibility_id);
1264: --FND_PROFILE.GET('RESP_APPL_ID', l_application_id);
1265: l_user_id := fnd_global.user_id;
1266: l_responsibility_id := fnd_global.resp_id;

Line 1263: --FND_PROFILE.GET('RESP_ID', l_responsibility_id);

1259: ** Set the context only if it is not set already
1260: */
1261:
1262: --FND_PROFILE.GET('USER_ID', l_user_id);
1263: --FND_PROFILE.GET('RESP_ID', l_responsibility_id);
1264: --FND_PROFILE.GET('RESP_APPL_ID', l_application_id);
1265: l_user_id := fnd_global.user_id;
1266: l_responsibility_id := fnd_global.resp_id;
1267: l_application_id := fnd_global.resp_appl_id;

Line 1264: --FND_PROFILE.GET('RESP_APPL_ID', l_application_id);

1260: */
1261:
1262: --FND_PROFILE.GET('USER_ID', l_user_id);
1263: --FND_PROFILE.GET('RESP_ID', l_responsibility_id);
1264: --FND_PROFILE.GET('RESP_APPL_ID', l_application_id);
1265: l_user_id := fnd_global.user_id;
1266: l_responsibility_id := fnd_global.resp_id;
1267: l_application_id := fnd_global.resp_appl_id;
1268:

Line 1300: display_txn_curr := FND_PROFILE.value('POR_DEFAULT_DISP_TRANS_CURRENCY');

1296: (itemtype => l_item_type,
1297: itemkey => l_item_key,
1298: aname => 'ORG_ID');
1299:
1300: display_txn_curr := FND_PROFILE.value('POR_DEFAULT_DISP_TRANS_CURRENCY');
1301:
1302: PO_MOAC_UTILS_PVT.set_org_context(l_org_id) ; --
1303:
1304: l_currency_code := PO_CORE_S2.get_base_currency;

Line 1430: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');

1426:
1427: i number := 0;
1428:
1429: display_txn_curr VARCHAR2(30);
1430: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');
1431:
1432: /* this variable is true when
1433: 1) display_txn_curr is 'Y'
1434: 2) there is at least a line has foreign currency

Line 1540: --FND_PROFILE.GET('USER_ID', l_user_id);

1536:
1537: /* Bug 2606838
1538: ** Set the context only if it is not set already
1539: */
1540: --FND_PROFILE.GET('USER_ID', l_user_id);
1541: --FND_PROFILE.GET('RESP_ID', l_responsibility_id);
1542: --FND_PROFILE.GET('RESP_APPL_ID', l_application_id);
1543: l_user_id := fnd_global.user_id;
1544: l_responsibility_id := fnd_global.resp_id;

Line 1541: --FND_PROFILE.GET('RESP_ID', l_responsibility_id);

1537: /* Bug 2606838
1538: ** Set the context only if it is not set already
1539: */
1540: --FND_PROFILE.GET('USER_ID', l_user_id);
1541: --FND_PROFILE.GET('RESP_ID', l_responsibility_id);
1542: --FND_PROFILE.GET('RESP_APPL_ID', l_application_id);
1543: l_user_id := fnd_global.user_id;
1544: l_responsibility_id := fnd_global.resp_id;
1545: l_application_id := fnd_global.resp_appl_id;

Line 1542: --FND_PROFILE.GET('RESP_APPL_ID', l_application_id);

1538: ** Set the context only if it is not set already
1539: */
1540: --FND_PROFILE.GET('USER_ID', l_user_id);
1541: --FND_PROFILE.GET('RESP_ID', l_responsibility_id);
1542: --FND_PROFILE.GET('RESP_APPL_ID', l_application_id);
1543: l_user_id := fnd_global.user_id;
1544: l_responsibility_id := fnd_global.resp_id;
1545: l_application_id := fnd_global.resp_appl_id;
1546:

Line 1567: display_txn_curr := FND_PROFILE.value('POR_DEFAULT_DISP_TRANS_CURRENCY');

1563: set_doc_mgr_context(l_item_type, l_item_key);
1564:
1565: END IF; */
1566:
1567: display_txn_curr := FND_PROFILE.value('POR_DEFAULT_DISP_TRANS_CURRENCY');
1568:
1569: PO_MOAC_UTILS_PVT.set_org_context(l_org_id) ; --
1570:
1571:

Line 1620: l_max_lines := to_number(fnd_profile.value('PO_NOTIF_LINES_LIMIT'));

1616: l_document_pre_lmt := l_document;
1617: l_document := null;
1618: g_req_line_allowed_length := g_req_line_allowed_length - nvl(lengthb(l_document_pre_lmt),0);
1619:
1620: l_max_lines := to_number(fnd_profile.value('PO_NOTIF_LINES_LIMIT'));
1621:
1622: /* Bug# 2720551: kagarwal
1623: ** Desc: Modified the select to only count lines that are not cancelled
1624: */

Line 2336: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');

2332: l_document VARCHAR2(32000) := '';
2333:
2334: NL VARCHAR2(1) := fnd_global.newline;
2335:
2336: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');
2337: l_type WF_MESSAGE_ATTRIBUTES.TYPE%TYPE;
2338: l_subtype WF_MESSAGE_ATTRIBUTES.SUBTYPE%TYPE;
2339: l_format WF_MESSAGE_ATTRIBUTES.FORMAT%TYPE;
2340:

Line 2432: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');

2428:
2429: l_document varchar2(1000) := '';
2430:
2431: NL VARCHAR2(1) := fnd_global.newline;
2432: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');
2433:
2434: begin
2435:
2436: l_document := '';
Line 2722: --Fnd_Profile.Get('USER_ID',l_session_user_id);

2718: END IF;
2719: --
2720:
2721: --Bug 5389914
2722: --Fnd_Profile.Get('USER_ID',l_session_user_id);
2723: --Fnd_Profile.Get('RESP_ID',l_session_resp_id);
2724: --Fnd_Profile.Get('RESP_APPL_ID',l_session_appl_id);
2725: l_session_user_id := fnd_global.user_id;
2726: l_session_resp_id := fnd_global.resp_id;

Line 2723: --Fnd_Profile.Get('RESP_ID',l_session_resp_id);

2719: --
2720:
2721: --Bug 5389914
2722: --Fnd_Profile.Get('USER_ID',l_session_user_id);
2723: --Fnd_Profile.Get('RESP_ID',l_session_resp_id);
2724: --Fnd_Profile.Get('RESP_APPL_ID',l_session_appl_id);
2725: l_session_user_id := fnd_global.user_id;
2726: l_session_resp_id := fnd_global.resp_id;
2727: l_session_appl_id := fnd_global.resp_appl_id;

Line 2724: --Fnd_Profile.Get('RESP_APPL_ID',l_session_appl_id);

2720:
2721: --Bug 5389914
2722: --Fnd_Profile.Get('USER_ID',l_session_user_id);
2723: --Fnd_Profile.Get('RESP_ID',l_session_resp_id);
2724: --Fnd_Profile.Get('RESP_APPL_ID',l_session_appl_id);
2725: l_session_user_id := fnd_global.user_id;
2726: l_session_resp_id := fnd_global.resp_id;
2727: l_session_appl_id := fnd_global.resp_appl_id;
2728:

Line 3223: FND_PROFILE.GET('PO_ALLOW_REQ_APPRV_FORWARD', l_allowed);

3219: l_allowed VARCHAR2(1) := 'Y';
3220:
3221: begin
3222:
3223: FND_PROFILE.GET('PO_ALLOW_REQ_APPRV_FORWARD', l_allowed);
3224:
3225: resultout := wf_engine.eng_completed || ':' || l_allowed;
3226:
3227: exception

Line 3307: l_max_lines := to_number(fnd_profile.value('PO_NOTIF_LINES_LIMIT'));

3303: l_max_lines number := 0;
3304: l_currency_code po_requisition_lines.currency_code%TYPE;
3305:
3306: begin
3307: l_max_lines := to_number(fnd_profile.value('PO_NOTIF_LINES_LIMIT'));
3308:
3309: -- SQL What: checking for any requisition line that has foreign currency
3310: -- SQL Why: need to check if need to display foregin currency column
3311: select currency_code into l_currency_code from