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

Line 53: NL VARCHAR2(1) := fnd_global.newline;

49: X_min_acct_unit number;
50: /* End Bug# 3972475*/
51: l_supplier po_vendors.vendor_name%type; --Bug 4254468
52: l_supplier_site po_vendor_sites_all.vendor_site_code%type; --Bug 4254468
53: NL VARCHAR2(1) := fnd_global.newline;
54:
55: --Added by Eric Ma for IL PO Notification on Apr-13,2009 ,Begin
56: -------------------------------------------------------------------------------------
57: lv_tax_region varchar2(30); --tax region code

Line 324: NL VARCHAR2(1) := fnd_global.newline;

320: l_open_form_command VARCHAR2(200);
321: l_view_po_url varchar2(1000); -- HTML Orders R12
322: l_edit_po_url varchar2(1000); -- HTML Orders R12
323:
324: NL VARCHAR2(1) := fnd_global.newline;
325:
326: i NUMBER := 0;
327: max_lines_dsp NUMBER ; --
328: l_line_count NUMBER := 0; -- # lines/shipments on document

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 1238: NL VARCHAR2(1) := fnd_global.newline;

1234:
1235: l_view_po_url varchar2(1000); -- HTML Orders R12
1236: l_edit_po_url varchar2(1000); -- HTML Orders R12
1237:
1238: NL VARCHAR2(1) := fnd_global.newline;
1239:
1240: -- Declare TABLEs for each column that is selected
1241: -- from history_csr cursor.
1242: --

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 2229: l_session_user_id := fnd_global.user_id;

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:
2233: IF (l_session_user_id = -1) THEN

Line 2230: l_session_resp_id := fnd_global.resp_id;

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:
2233: IF (l_session_user_id = -1) THEN
2234: l_session_user_id := NULL;

Line 2231: l_session_appl_id := fnd_global.resp_appl_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:
2233: IF (l_session_user_id = -1) THEN
2234: l_session_user_id := NULL;
2235: END IF;

Line 3013: last_updated_by = fnd_global.user_id,

3009:
3010: -- Update action history with the action details
3011: UPDATE PO_ACTION_HISTORY
3012: SET last_update_date = sysdate,
3013: last_updated_by = fnd_global.user_id,
3014: last_update_login = fnd_global.login_id ,
3015: action_date = sysdate,
3016: action_code = p_action_code,
3017: note = p_note,

Line 3014: last_update_login = fnd_global.login_id ,

3010: -- Update action history with the action details
3011: UPDATE PO_ACTION_HISTORY
3012: SET last_update_date = sysdate,
3013: last_updated_by = fnd_global.user_id,
3014: last_update_login = fnd_global.login_id ,
3015: action_date = sysdate,
3016: action_code = p_action_code,
3017: note = p_note,
3018: approval_path_id = nvl(p_approval_path_id, l_approval_path_id), --

Line 3057: fnd_global.user_id,

3053: p_doc_type,
3054: l_doc_sub_type,
3055: l_sequence_num + 1,
3056: sysdate,
3057: fnd_global.user_id,
3058: p_recipient_id,
3059: NULL,
3060: NULL,
3061: NULL,

Line 3063: fnd_global.login_id,

3059: NULL,
3060: NULL,
3061: NULL,
3062: l_object_revision_num,
3063: fnd_global.login_id,
3064: sysdate,
3065: fnd_global.user_id,
3066: l_request_id,
3067: l_program_application_id,

Line 3065: fnd_global.user_id,

3061: NULL,
3062: l_object_revision_num,
3063: fnd_global.login_id,
3064: sysdate,
3065: fnd_global.user_id,
3066: l_request_id,
3067: l_program_application_id,
3068: l_program_id,
3069: l_program_date,