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

Line 7: g_fnd_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');

3:
4:
5: g_pkg_name CONSTANT VARCHAR2(50) := 'PO_ChangeOrderWF_PVT';
6: g_module_prefix CONSTANT VARCHAR2(50) := 'po.plsql.' || g_pkg_name || '.';
7: g_fnd_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
8: g_po_wf_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_WORKFLOW_ON'),'N');
9:
10: -- Read the profile option that determines whether the promise date will be defaulted with need-by date or not
11: g_default_promise_date VARCHAR2(1) := NVL(FND_PROFILE.VALUE('POS_DEFAULT_PROMISE_DATE_ACK'),'N');

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

4:
5: g_pkg_name CONSTANT VARCHAR2(50) := 'PO_ChangeOrderWF_PVT';
6: g_module_prefix CONSTANT VARCHAR2(50) := 'po.plsql.' || g_pkg_name || '.';
7: g_fnd_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
8: g_po_wf_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_WORKFLOW_ON'),'N');
9:
10: -- Read the profile option that determines whether the promise date will be defaulted with need-by date or not
11: g_default_promise_date VARCHAR2(1) := NVL(FND_PROFILE.VALUE('POS_DEFAULT_PROMISE_DATE_ACK'),'N');
12: NL VARCHAR2(1) := fnd_global.newline;

Line 11: g_default_promise_date VARCHAR2(1) := NVL(FND_PROFILE.VALUE('POS_DEFAULT_PROMISE_DATE_ACK'),'N');

7: g_fnd_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
8: g_po_wf_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_WORKFLOW_ON'),'N');
9:
10: -- Read the profile option that determines whether the promise date will be defaulted with need-by date or not
11: g_default_promise_date VARCHAR2(1) := NVL(FND_PROFILE.VALUE('POS_DEFAULT_PROMISE_DATE_ACK'),'N');
12: NL VARCHAR2(1) := fnd_global.newline;
13:
14: /*Initializing Private Procedures/Functions*/
15: PROCEDURE Notify_Requester_Sup_Change( p_header_id in number,

Line 1683: to_char(OLD_PROM_DATE,FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),

1679: to_char(SHIPMENT_NUM),
1680: BUYER_PT_NUM,
1681: OLD_SUP_PT_NUM,
1682: NEW_SUP_PT_NUM,
1683: to_char(OLD_PROM_DATE,FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
1684: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN' ) || ''''),
1685: to_char(NEW_PROM_DATE, FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
1686: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN' ) || ''''),
1687: to_char(OLD_QTY),

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

1680: BUYER_PT_NUM,
1681: OLD_SUP_PT_NUM,
1682: NEW_SUP_PT_NUM,
1683: to_char(OLD_PROM_DATE,FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
1684: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN' ) || ''''),
1685: to_char(NEW_PROM_DATE, FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
1686: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN' ) || ''''),
1687: to_char(OLD_QTY),
1688: to_char(NEW_QTY),

Line 1685: to_char(NEW_PROM_DATE, FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),

1681: OLD_SUP_PT_NUM,
1682: NEW_SUP_PT_NUM,
1683: to_char(OLD_PROM_DATE,FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
1684: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN' ) || ''''),
1685: to_char(NEW_PROM_DATE, FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
1686: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN' ) || ''''),
1687: to_char(OLD_QTY),
1688: to_char(NEW_QTY),
1689: to_char(OLD_PRICE),

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

1682: NEW_SUP_PT_NUM,
1683: to_char(OLD_PROM_DATE,FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
1684: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN' ) || ''''),
1685: to_char(NEW_PROM_DATE, FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
1686: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN' ) || ''''),
1687: to_char(OLD_QTY),
1688: to_char(NEW_QTY),
1689: to_char(OLD_PRICE),
1690: to_char(NEW_PRICE),

Line 1861: l_base_url := fnd_profile.value('APPS_WEB_AGENT');

1857: l_grp_id := to_number(substr(p_code,instr(p_code,'$')+1, instr(p_code,'%')-instr(p_code,'$')-1));
1858: l_requester_id := substr(p_code,instr(p_code,'%')+1, instr(p_code,'^')-instr(p_code,'%')-1);
1859:
1860: l_progress := '001';
1861: l_base_url := fnd_profile.value('APPS_WEB_AGENT');
1862: l_base_url := substr(
1863: l_base_url,
1864: 0,
1865: instr(rtrim(l_base_url,'/'),'/',-1,2)-1

Line 1891: to_char(creation_date, FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),

1887: pos_totals_po_sv.get_po_total(po_header_id),
1888: currency_code,
1889: vendor_id,
1890: vendor_site_id,
1891: to_char(creation_date, FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
1892: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) , 'GREGORIAN' ) || ''''),
1893: fob_lookup_code,
1894: ship_via_lookup_code,
1895: ship_to_location_id,

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

1888: currency_code,
1889: vendor_id,
1890: vendor_site_id,
1891: to_char(creation_date, FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
1892: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) , 'GREGORIAN' ) || ''''),
1893: fob_lookup_code,
1894: ship_via_lookup_code,
1895: ship_to_location_id,
1896: type_lookup_code,

Line 1938: to_char(pr.creation_date,FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),

1934: pos_totals_po_sv.get_release_total(pr.po_release_id),
1935: ph.currency_code,
1936: ph.vendor_id,
1937: ph.vendor_site_id,
1938: to_char(pr.creation_date,FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
1939: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN' ) || ''''),
1940: ph.fob_lookup_code,
1941: ph.ship_via_lookup_code,
1942: ph.ship_to_location_id,

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

1935: ph.currency_code,
1936: ph.vendor_id,
1937: ph.vendor_site_id,
1938: to_char(pr.creation_date,FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
1939: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN' ) || ''''),
1940: ph.fob_lookup_code,
1941: ph.ship_via_lookup_code,
1942: ph.ship_to_location_id,
1943: ph.type_lookup_code

Line 2515: to_char(OLD_PROM_DATE, FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),

2511: to_char(SHIPMENT_NUM),
2512: BUYER_PT_NUM,
2513: OLD_SUP_PT_NUM,
2514: NEW_SUP_PT_NUM,
2515: to_char(OLD_PROM_DATE, FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
2516: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN' ) || ''''),
2517: to_char(NEW_PROM_DATE, FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
2518: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN' ) || ''''),
2519: to_char(OLD_QTY),

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

2512: BUYER_PT_NUM,
2513: OLD_SUP_PT_NUM,
2514: NEW_SUP_PT_NUM,
2515: to_char(OLD_PROM_DATE, FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
2516: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN' ) || ''''),
2517: to_char(NEW_PROM_DATE, FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
2518: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN' ) || ''''),
2519: to_char(OLD_QTY),
2520: to_char(NEW_QTY),

Line 2517: to_char(NEW_PROM_DATE, FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),

2513: OLD_SUP_PT_NUM,
2514: NEW_SUP_PT_NUM,
2515: to_char(OLD_PROM_DATE, FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
2516: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN' ) || ''''),
2517: to_char(NEW_PROM_DATE, FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
2518: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN' ) || ''''),
2519: to_char(OLD_QTY),
2520: to_char(NEW_QTY),
2521: to_char(OLD_PRICE),

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

2514: NEW_SUP_PT_NUM,
2515: to_char(OLD_PROM_DATE, FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
2516: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN' ) || ''''),
2517: to_char(NEW_PROM_DATE, FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
2518: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN' ) || ''''),
2519: to_char(OLD_QTY),
2520: to_char(NEW_QTY),
2521: to_char(OLD_PRICE),
2522: to_char(NEW_PRICE),

Line 2700: l_base_url := fnd_profile.value('APPS_WEB_AGENT');

2696: l_grp_id := to_number(substr(p_code,instr(p_code,'$')+1, instr(p_code,'%')-instr(p_code,'$')-1));
2697: l_planner_id := substr(p_code,instr(p_code,'%')+1, instr(p_code,'^')-instr(p_code,'%')-1);
2698:
2699: l_progress := '001';
2700: l_base_url := fnd_profile.value('APPS_WEB_AGENT');
2701: l_base_url := substr(
2702: l_base_url,
2703: 0,
2704: instr(rtrim(l_base_url,'/'),'/',-1,2)-1

Line 2729: to_char(creation_date, FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),

2725: pos_totals_po_sv.get_po_total(po_header_id),
2726: currency_code,
2727: vendor_id,
2728: vendor_site_id,
2729: to_char(creation_date, FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
2730: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN' ) || ''''),
2731: fob_lookup_code,
2732: ship_via_lookup_code,
2733: ship_to_location_id,

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

2726: currency_code,
2727: vendor_id,
2728: vendor_site_id,
2729: to_char(creation_date, FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
2730: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN' ) || ''''),
2731: fob_lookup_code,
2732: ship_via_lookup_code,
2733: ship_to_location_id,
2734: type_lookup_code,

Line 2776: to_char(pr.creation_date, FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),

2772: pos_totals_po_sv.get_release_total(pr.po_release_id),
2773: ph.currency_code,
2774: ph.vendor_id,
2775: ph.vendor_site_id,
2776: to_char(pr.creation_date, FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
2777: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN' ) || ''''),
2778: ph.fob_lookup_code,
2779: ph.ship_via_lookup_code,
2780: ph.ship_to_location_id,

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

2773: ph.currency_code,
2774: ph.vendor_id,
2775: ph.vendor_site_id,
2776: to_char(pr.creation_date, FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
2777: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN' ) || ''''),
2778: ph.fob_lookup_code,
2779: ph.ship_via_lookup_code,
2780: ph.ship_to_location_id,
2781: ph.type_lookup_code

Line 3620: l_base_url := fnd_profile.value('APPS_WEB_AGENT');

3616: l_acc_req_flag := substr(p_code,instr(p_code,'%')+1, instr(p_code,'^')-instr(p_code,'%')-1);
3617:
3618:
3619: l_progress := '001';
3620: l_base_url := fnd_profile.value('APPS_WEB_AGENT');
3621: l_base_url := substr(
3622: l_base_url,
3623: 0,
3624: instr(rtrim(l_base_url,'/'),'/',-1,2)-1

Line 3648: to_char(creation_date, fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS'),

3644: pos_totals_po_sv.get_po_total(po_header_id),
3645: currency_code,
3646: vendor_id,
3647: vendor_site_id,
3648: to_char(creation_date, fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS'),
3649: fob_lookup_code,
3650: ship_via_lookup_code,
3651: ship_to_location_id,
3652: type_lookup_code,

Line 3700: to_char(pr.creation_date, fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS'),

3696: pos_totals_po_sv.get_release_total(pr.po_release_id),
3697: ph.currency_code,
3698: ph.vendor_id,
3699: ph.vendor_site_id,
3700: to_char(pr.creation_date, fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS'),
3701: ph.fob_lookup_code,
3702: ph.ship_via_lookup_code,
3703: ph.ship_to_location_id,
3704: ph.type_lookup_code

Line 3945: l_old_prom_date := to_char(lc_old_prom_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS');

3941: lc_ship_to_location,
3942: lc_reason;
3943: EXIT when l_po_ack_csr%NOTFOUND;
3944:
3945: l_old_prom_date := to_char(lc_old_prom_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS');
3946: l_new_prom_date := to_char(lc_new_prom_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS');
3947: lc_line_num := nvl(lc_line_num,'` ');
3948: lc_ship_num:= nvl(lc_ship_num,'` ');
3949: lc_buyer_pt_num := nvl(lc_buyer_pt_num,'` ');

Line 3946: l_new_prom_date := to_char(lc_new_prom_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS');

3942: lc_reason;
3943: EXIT when l_po_ack_csr%NOTFOUND;
3944:
3945: l_old_prom_date := to_char(lc_old_prom_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS');
3946: l_new_prom_date := to_char(lc_new_prom_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS');
3947: lc_line_num := nvl(lc_line_num,'` ');
3948: lc_ship_num:= nvl(lc_ship_num,'` ');
3949: lc_buyer_pt_num := nvl(lc_buyer_pt_num,'` ');
3950: lc_old_sup_pt_num:= nvl(lc_old_sup_pt_num,'` ');

Line 4107: l_old_prom_date := to_char(lc_old_prom_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS');

4103: fnd_date_tz.init_timezones_for_fnd_date(true);
4104: l_old_prom_date := fnd_date.date_to_displayDT(lc_old_prom_date);
4105: l_new_prom_date := fnd_date.date_to_displayDT(lc_new_prom_date);
4106: else
4107: l_old_prom_date := to_char(lc_old_prom_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS');
4108: l_new_prom_date := to_char(lc_new_prom_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS');
4109: end if;
4110:
4111:

Line 4108: l_new_prom_date := to_char(lc_new_prom_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS');

4104: l_old_prom_date := fnd_date.date_to_displayDT(lc_old_prom_date);
4105: l_new_prom_date := fnd_date.date_to_displayDT(lc_new_prom_date);
4106: else
4107: l_old_prom_date := to_char(lc_old_prom_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS');
4108: l_new_prom_date := to_char(lc_new_prom_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS');
4109: end if;
4110:
4111:
4112: lc_line_num := nvl(lc_line_num,'` ');

Line 4586: to_char(creation_date, fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS'),

4582: pos_totals_po_sv.get_po_total(po_header_id),
4583: currency_code,
4584: vendor_id,
4585: vendor_site_id,
4586: to_char(creation_date, fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS'),
4587: fob_lookup_code,
4588: ship_via_lookup_code,
4589: ship_to_location_id,
4590: type_lookup_code,

Line 4615: to_char(pr.creation_date, fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS'),

4611: pos_totals_po_sv.get_release_total(pr.po_release_id),
4612: ph.currency_code,
4613: ph.vendor_id,
4614: ph.vendor_site_id,
4615: to_char(pr.creation_date, fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS'),
4616: ph.fob_lookup_code,
4617: ph.ship_via_lookup_code,
4618: ph.ship_to_location_id,
4619: ph.type_lookup_code,

Line 4861: l_old_prom_date := to_char(lc_old_prom_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS');

4857: fnd_date_tz.init_timezones_for_fnd_date(true);
4858: l_old_prom_date := fnd_date.date_to_displayDT(lc_old_prom_date);
4859: l_new_prom_date := fnd_date.date_to_displayDT(lc_new_prom_date);
4860: else
4861: l_old_prom_date := to_char(lc_old_prom_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS');
4862: l_new_prom_date := to_char(lc_new_prom_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS');
4863: end if;
4864:
4865:

Line 4862: l_new_prom_date := to_char(lc_new_prom_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS');

4858: l_old_prom_date := fnd_date.date_to_displayDT(lc_old_prom_date);
4859: l_new_prom_date := fnd_date.date_to_displayDT(lc_new_prom_date);
4860: else
4861: l_old_prom_date := to_char(lc_old_prom_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS');
4862: l_new_prom_date := to_char(lc_new_prom_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS');
4863: end if;
4864:
4865:
4866: lc_line_num := nvl(lc_line_num,'` ');

Line 7181: t_varval(7) := fnd_profile.value('POS_EXTERNAL_URL');

7177: t_varval(5) := 'BUYER_RESP';
7178: t_varname(6) := 'PO_STYLE_TYPE';
7179: t_varval(6) := l_po_style;
7180: t_varname(7) := '#WFM_HTMLAGENT';
7181: t_varval(7) := fnd_profile.value('POS_EXTERNAL_URL');
7182:
7183:
7184: Wf_Engine.SetItemAttrNumberArray('POSCHORD', l_item_key,n_varname,n_varval);
7185: Wf_Engine.SetItemAttrTextArray('POSCHORD', l_item_key,t_varname,t_varval);

Line 8089: and nvl(fsp.business_group_id,-1) = nvl(fnd_profile.value_specific('PER_BUSINESS_GROUP_ID', NULL, fr.responsibility_id, fr.application_id),-1);

8085: and fr.application_id = 201
8086: and fr.start_date < sysdate
8087: and nvl(fr.end_date, sysdate +1) >= sysdate
8088: and nvl(fsp.org_id,-1) = nvl(p_org_id,-1)
8089: and nvl(fsp.business_group_id,-1) = nvl(fnd_profile.value_specific('PER_BUSINESS_GROUP_ID', NULL, fr.responsibility_id, fr.application_id),-1);
8090:
8091:
8092: BEGIN
8093: /* bug 13915321 begin Moving the block here*/

Line 8214: /* and nvl(fsp.business_group_id,-1) = nvl(fnd_profile.value_specific('PER_BUSINESS_GROUP_ID', NULL, fr.responsibility_id, fr.application_id),-1); */

8210: and fr.application_id = l_resp_appl_id
8211: and fr.start_date < sysdate
8212: and nvl(fr.end_date, sysdate +1) >= sysdate
8213: and nvl(fsp.org_id,-1) = nvl(p_org_id,-1);
8214: /* and nvl(fsp.business_group_id,-1) = nvl(fnd_profile.value_specific('PER_BUSINESS_GROUP_ID', NULL, fr.responsibility_id, fr.application_id),-1); */
8215: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8216: FND_LOG.string(FND_LOG.level_procedure, g_module_prefix ||
8217: l_api_name || '.intialize parameters',l_progress||' '||l_user_id||'*'||l_resp_id||'*'||l_resp_appl_id );
8218: END IF;

Line 8252: /* and nvl(fsp.business_group_id,-1) = nvl(fnd_profile.value_specific('PER_BUSINESS_GROUP_ID', NULL, fr.responsibility_id, fr.application_id),-1); */

8248: and fr.application_id = l_resp_appl_id
8249: and fr.start_date < sysdate
8250: and nvl(fr.end_date, sysdate +1) >= sysdate
8251: and nvl(fsp.org_id,-1) = nvl(p_org_id,-1);
8252: /* and nvl(fsp.business_group_id,-1) = nvl(fnd_profile.value_specific('PER_BUSINESS_GROUP_ID', NULL, fr.responsibility_id, fr.application_id),-1); */
8253: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8254: FND_LOG.string(FND_LOG.level_procedure, g_module_prefix ||
8255: l_api_name || '.intialize parameters',l_progress||' '||l_user_id||'*'||l_resp_id||'*'||l_resp_appl_id );
8256: END IF;

Line 8667: l_external_url := fnd_profile.value('POS_EXTERNAL_URL');

8663: l_api_name varchar2(50) := 'CHECK_POS_EXTERNAL_URL';
8664: l_external_url varchar2(500);
8665: begin
8666:
8667: l_external_url := fnd_profile.value('POS_EXTERNAL_URL');
8668: IF (g_fnd_debug = 'Y' AND FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8669: FND_LOG.string(FND_LOG.level_procedure, g_module_prefix ||
8670: l_api_name || '.start', 'POS_EXTERNAL_URL=' || l_external_url);
8671: END IF;