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.

[Home] [Help]

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.27.12020000.2 2013/05/09 15:26:56 rparise 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 2045: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),

2041: /*Modified as part of bug 7554321 changing date format*/
2042: if (FND_RELEASE.MAJOR_VERSION = 12 and FND_RELEASE.minor_version >= 1 and FND_RELEASE.POINT_VERSION >= 1 )
2043: or (FND_RELEASE.MAJOR_VERSION > 12) then
2044: l_date_text := nvl(to_char(l_history.action_date,
2045: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
2046: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN' ) || ''''),' ') ;
2047: else
2048: l_date_text := nvl(to_char(l_history.action_date), ' ') ;
2049: end if;

Line 2046: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN' ) || ''''),' ') ;

2042: if (FND_RELEASE.MAJOR_VERSION = 12 and FND_RELEASE.minor_version >= 1 and FND_RELEASE.POINT_VERSION >= 1 )
2043: or (FND_RELEASE.MAJOR_VERSION > 12) then
2044: l_date_text := nvl(to_char(l_history.action_date,
2045: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
2046: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN' ) || ''''),' ') ;
2047: else
2048: l_date_text := nvl(to_char(l_history.action_date), ' ') ;
2049: end if;
2050:

Line 2097: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),

2093: /*Modified as part of bug 7554321 changing date format*/
2094: if (FND_RELEASE.MAJOR_VERSION = 12 and FND_RELEASE.minor_version >= 1 and FND_RELEASE.POINT_VERSION >= 1 )
2095: or (FND_RELEASE.MAJOR_VERSION > 12) then
2096: l_date_text := nvl(to_char(l_history.action_date,
2097: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
2098: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN' ) || ''''),' ') ;
2099: else
2100: l_date_text := nvl(to_char(l_history.action_date), ' ') ;
2101: end if;

Line 2098: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN' ) || ''''),' ') ;

2094: if (FND_RELEASE.MAJOR_VERSION = 12 and FND_RELEASE.minor_version >= 1 and FND_RELEASE.POINT_VERSION >= 1 )
2095: or (FND_RELEASE.MAJOR_VERSION > 12) then
2096: l_date_text := nvl(to_char(l_history.action_date,
2097: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
2098: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN' ) || ''''),' ') ;
2099: else
2100: l_date_text := nvl(to_char(l_history.action_date), ' ') ;
2101: end if;
2102:

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

2391: l_document VARCHAR2(32000) := '';
2392:
2393: NL VARCHAR2(1) := fnd_global.newline;
2394:
2395: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');
2396: l_type WF_MESSAGE_ATTRIBUTES.TYPE%TYPE;
2397: l_subtype WF_MESSAGE_ATTRIBUTES.SUBTYPE%TYPE;
2398: l_format WF_MESSAGE_ATTRIBUTES.FORMAT%TYPE;
2399:

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

2487:
2488: l_document varchar2(1000) := '';
2489:
2490: NL VARCHAR2(1) := fnd_global.newline;
2491: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');
2492:
2493: begin
2494:
2495: l_document := '';
Line 2874: --Fnd_Profile.Get('USER_ID',l_session_user_id);

2870: END IF;
2871: --
2872:
2873: --Bug 5389914
2874: --Fnd_Profile.Get('USER_ID',l_session_user_id);
2875: --Fnd_Profile.Get('RESP_ID',l_session_resp_id);
2876: --Fnd_Profile.Get('RESP_APPL_ID',l_session_appl_id);
2877: l_session_user_id := fnd_global.user_id;
2878: l_session_resp_id := fnd_global.resp_id;

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

2871: --
2872:
2873: --Bug 5389914
2874: --Fnd_Profile.Get('USER_ID',l_session_user_id);
2875: --Fnd_Profile.Get('RESP_ID',l_session_resp_id);
2876: --Fnd_Profile.Get('RESP_APPL_ID',l_session_appl_id);
2877: l_session_user_id := fnd_global.user_id;
2878: l_session_resp_id := fnd_global.resp_id;
2879: l_session_appl_id := fnd_global.resp_appl_id;

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

2872:
2873: --Bug 5389914
2874: --Fnd_Profile.Get('USER_ID',l_session_user_id);
2875: --Fnd_Profile.Get('RESP_ID',l_session_resp_id);
2876: --Fnd_Profile.Get('RESP_APPL_ID',l_session_appl_id);
2877: l_session_user_id := fnd_global.user_id;
2878: l_session_resp_id := fnd_global.resp_id;
2879: l_session_appl_id := fnd_global.resp_appl_id;
2880:

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

3532: l_allowed VARCHAR2(1) := 'Y';
3533:
3534: begin
3535:
3536: FND_PROFILE.GET('PO_ALLOW_REQ_APPRV_FORWARD', l_allowed);
3537:
3538: resultout := wf_engine.eng_completed || ':' || l_allowed;
3539:
3540: exception

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

3616: l_max_lines number := 0;
3617: l_currency_code po_requisition_lines.currency_code%TYPE;
3618:
3619: begin
3620: l_max_lines := to_number(fnd_profile.value('PO_NOTIF_LINES_LIMIT'));
3621:
3622: -- SQL What: checking for any requisition line that has foreign currency
3623: -- SQL Why: need to check if need to display foregin currency column
3624: select currency_code into l_currency_code from