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_PO_NOTIFICATION dependencies on FND_PROFILE

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

1: PACKAGE BODY PO_WF_PO_NOTIFICATION AS
2: /* $Header: POXWPA7B.pls 120.30.12020000.6 2013/03/16 14:04:59 inagdeo ship $ */
3:
4: g_po_wf_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_WORKFLOW_ON'),'N');
5: g_pkg_name VARCHAR2(30) := 'PO_WF_PO_NOTIFICATION'; --
6:
7: --Added this private procedure as part of bug 13951919 fix
8: PROCEDURE update_action_history (p_action_code IN VARCHAR2,

Line 644: -- max_lines_dsp:= to_number(fnd_profile.value('PO_NOTIF_LINES_LIMIT'));

640: ** number of PO lines to be displayed in Approval notification.
641: ** The same profile is also used for Requisitions.
642: */
643: --
644: -- max_lines_dsp:= to_number(fnd_profile.value('PO_NOTIF_LINES_LIMIT'));
645:
646: -- if max_lines_dsp is NULL then
647: -- max_lines_dsp := 20;
648: -- end if;

Line 720: max_lines_dsp:= to_number(fnd_profile.value('PO_NOTIF_LINES_LIMIT'));

716: END IF;
717: --
718: --
719:
720: max_lines_dsp:= to_number(fnd_profile.value('PO_NOTIF_LINES_LIMIT'));
721:
722: IF max_lines_dsp IS NULL THEN
723:
724: max_lines_dsp := l_line_count;

Line 1012: || to_char(l_need_by_date_tbl(i) ,FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),

1008: || nvl(l_location_tbl(i), ' ') || '' || NL;
1009: l_document := l_document || ''
1010: || nvl(l_org_name_tbl(i), ' ') || '' || NL;
1011: l_document := l_document || ''
1012: || to_char(l_need_by_date_tbl(i) ,FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
1013: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN' ) || '''') || '' || NL;
1014: /* bug 4950850 */
1015: l_document := l_document || '' ||
1016: nvl(TO_CHAR(l_amount_tbl(i), FND_CURRENCY.GET_FORMAT_MASK(

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

1009: l_document := l_document || ''
1010: || nvl(l_org_name_tbl(i), ' ') || '' || NL;
1011: l_document := l_document || ''
1012: || to_char(l_need_by_date_tbl(i) ,FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
1013: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN' ) || '''') || '' || NL;
1014: /* bug 4950850 */
1015: l_document := l_document || '' ||
1016: nvl(TO_CHAR(l_amount_tbl(i), FND_CURRENCY.GET_FORMAT_MASK(
1017: l_currency_code, 30)),' ') || '' || NL;

Line 1187: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEED_BY_DATE') || ': ' || to_char(l_need_by_date_tbl(i),FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),

1183: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_AMOUNT') || ': '
1184: || to_char(l_amount_tbl(i), FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || NL;
1185: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LOCATION') || ': ' || l_location_tbl(i) || NL;
1186: l_document := l_document || fnd_message.get_string('PO', 'POA_SHIP_TO_ORG') || ': ' || l_org_name_tbl(i) || NL;
1187: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEED_BY_DATE') || ': ' || to_char(l_need_by_date_tbl(i),FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
1188: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN') || '''') || NL || NL;
1189:
1190: --
1191: -- curr_len := lengthb(l_document);

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

1184: || to_char(l_amount_tbl(i), FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || NL;
1185: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LOCATION') || ': ' || l_location_tbl(i) || NL;
1186: l_document := l_document || fnd_message.get_string('PO', 'POA_SHIP_TO_ORG') || ': ' || l_org_name_tbl(i) || NL;
1187: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEED_BY_DATE') || ': ' || to_char(l_need_by_date_tbl(i),FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
1188: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN') || '''') || NL || NL;
1189:
1190: --
1191: -- curr_len := lengthb(l_document);
1192:

Line 1565: || nvl(to_char(l_action_date_tbl(i),FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),

1561:
1562: l_document := l_document || ''
1563: || nvl(l_action_tbl(i), ' ') || '' || NL;
1564: l_document := l_document || ''
1565: || nvl(to_char(l_action_date_tbl(i),FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
1566: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN' ) || ''''), ' ') || '' || NL;
1567: /* Bug 11825584 removing nowrap and adding align=left*/
1568: l_document := l_document || ''
1569: || nvl(l_note_tbl(i), ' ') || '' || NL;

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

1562: l_document := l_document || ''
1563: || nvl(l_action_tbl(i), ' ') || '' || NL;
1564: l_document := l_document || ''
1565: || nvl(to_char(l_action_date_tbl(i),FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
1566: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN' ) || ''''), ' ') || '' || NL;
1567: /* Bug 11825584 removing nowrap and adding align=left*/
1568: l_document := l_document || ''
1569: || nvl(l_note_tbl(i), ' ') || '' || NL;
1570:

Line 1656: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_DATE') || ': ' || to_char(l_action_date_tbl(i),FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),

1652: END IF;
1653: /* Bug 2788683 end */
1654:
1655: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION') || ': ' || l_action_tbl(i) || NL;
1656: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_DATE') || ': ' || to_char(l_action_date_tbl(i),FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
1657: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN' ) || '''') || NL;
1658: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION_NOTE') || ': ' || l_note_tbl(i) || NL;
1659:
1660: l_document := l_document || NL;

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

1653: /* Bug 2788683 end */
1654:
1655: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION') || ': ' || l_action_tbl(i) || NL;
1656: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_DATE') || ': ' || to_char(l_action_date_tbl(i),FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
1657: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN' ) || '''') || NL;
1658: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION_NOTE') || ': ' || l_note_tbl(i) || NL;
1659:
1660: l_document := l_document || NL;
1661:

Line 2226: --Fnd_Profile.Get('USER_ID',l_session_user_id);

2222: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2223: END IF;
2224: --
2225: --Bug 5389914
2226: --Fnd_Profile.Get('USER_ID',l_session_user_id);
2227: --Fnd_Profile.Get('RESP_ID',l_session_resp_id);
2228: --Fnd_Profile.Get('RESP_APPL_ID',l_session_appl_id);
2229: l_session_user_id := fnd_global.user_id;
2230: l_session_resp_id := fnd_global.resp_id;

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

2223: END IF;
2224: --
2225: --Bug 5389914
2226: --Fnd_Profile.Get('USER_ID',l_session_user_id);
2227: --Fnd_Profile.Get('RESP_ID',l_session_resp_id);
2228: --Fnd_Profile.Get('RESP_APPL_ID',l_session_appl_id);
2229: l_session_user_id := fnd_global.user_id;
2230: l_session_resp_id := fnd_global.resp_id;
2231: l_session_appl_id := fnd_global.resp_appl_id;

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

2224: --
2225: --Bug 5389914
2226: --Fnd_Profile.Get('USER_ID',l_session_user_id);
2227: --Fnd_Profile.Get('RESP_ID',l_session_resp_id);
2228: --Fnd_Profile.Get('RESP_APPL_ID',l_session_appl_id);
2229: l_session_user_id := fnd_global.user_id;
2230: l_session_resp_id := fnd_global.resp_id;
2231: l_session_appl_id := fnd_global.resp_appl_id;
2232: