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 1541: to_char(OLD_PROM_DATE,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS'),

1537: to_char(SHIPMENT_NUM),
1538: BUYER_PT_NUM,
1539: OLD_SUP_PT_NUM,
1540: NEW_SUP_PT_NUM,
1541: to_char(OLD_PROM_DATE,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS'),
1542: to_char(NEW_PROM_DATE,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS'),
1543: to_char(OLD_QTY),
1544: to_char(NEW_QTY),
1545: to_char(OLD_PRICE),

Line 1542: to_char(NEW_PROM_DATE,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS'),

1538: BUYER_PT_NUM,
1539: OLD_SUP_PT_NUM,
1540: NEW_SUP_PT_NUM,
1541: to_char(OLD_PROM_DATE,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS'),
1542: to_char(NEW_PROM_DATE,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS'),
1543: to_char(OLD_QTY),
1544: to_char(NEW_QTY),
1545: to_char(OLD_PRICE),
1546: to_char(NEW_PRICE),

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

1713: l_grp_id := to_number(substr(p_code,instr(p_code,'$')+1, instr(p_code,'%')-instr(p_code,'$')-1));
1714: l_requester_id := substr(p_code,instr(p_code,'%')+1, instr(p_code,'^')-instr(p_code,'%')-1);
1715:
1716: l_progress := '001';
1717: l_base_url := fnd_profile.value('APPS_WEB_AGENT');
1718: l_base_url := substr(
1719: l_base_url,
1720: 0,
1721: instr(rtrim(l_base_url,'/'),'/',-1,2)-1

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

1742: pos_totals_po_sv.get_po_total(po_header_id),
1743: currency_code,
1744: vendor_id,
1745: vendor_site_id,
1746: to_char(creation_date, fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS'),
1747: fob_lookup_code,
1748: ship_via_lookup_code,
1749: ship_to_location_id,
1750: type_lookup_code,

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

1788: pos_totals_po_sv.get_release_total(pr.po_release_id),
1789: ph.currency_code,
1790: ph.vendor_id,
1791: ph.vendor_site_id,
1792: to_char(pr.creation_date, fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS'),
1793: ph.fob_lookup_code,
1794: ph.ship_via_lookup_code,
1795: ph.ship_to_location_id,
1796: ph.type_lookup_code

Line 2367: to_char(OLD_PROM_DATE,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS'),

2363: to_char(SHIPMENT_NUM),
2364: BUYER_PT_NUM,
2365: OLD_SUP_PT_NUM,
2366: NEW_SUP_PT_NUM,
2367: to_char(OLD_PROM_DATE,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS'),
2368: to_char(NEW_PROM_DATE,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS'),
2369: to_char(OLD_QTY),
2370: to_char(NEW_QTY),
2371: to_char(OLD_PRICE),

Line 2368: to_char(NEW_PROM_DATE,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS'),

2364: BUYER_PT_NUM,
2365: OLD_SUP_PT_NUM,
2366: NEW_SUP_PT_NUM,
2367: to_char(OLD_PROM_DATE,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS'),
2368: to_char(NEW_PROM_DATE,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS'),
2369: to_char(OLD_QTY),
2370: to_char(NEW_QTY),
2371: to_char(OLD_PRICE),
2372: to_char(NEW_PRICE),

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

2546: l_grp_id := to_number(substr(p_code,instr(p_code,'$')+1, instr(p_code,'%')-instr(p_code,'$')-1));
2547: l_planner_id := substr(p_code,instr(p_code,'%')+1, instr(p_code,'^')-instr(p_code,'%')-1);
2548:
2549: l_progress := '001';
2550: l_base_url := fnd_profile.value('APPS_WEB_AGENT');
2551: l_base_url := substr(
2552: l_base_url,
2553: 0,
2554: instr(rtrim(l_base_url,'/'),'/',-1,2)-1

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

2575: pos_totals_po_sv.get_po_total(po_header_id),
2576: currency_code,
2577: vendor_id,
2578: vendor_site_id,
2579: to_char(creation_date, fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS'),
2580: fob_lookup_code,
2581: ship_via_lookup_code,
2582: ship_to_location_id,
2583: type_lookup_code,

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

2621: pos_totals_po_sv.get_release_total(pr.po_release_id),
2622: ph.currency_code,
2623: ph.vendor_id,
2624: ph.vendor_site_id,
2625: to_char(pr.creation_date, fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS'),
2626: ph.fob_lookup_code,
2627: ph.ship_via_lookup_code,
2628: ph.ship_to_location_id,
2629: ph.type_lookup_code

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

3464: l_acc_req_flag := substr(p_code,instr(p_code,'%')+1, instr(p_code,'^')-instr(p_code,'%')-1);
3465:
3466:
3467: l_progress := '001';
3468: l_base_url := fnd_profile.value('APPS_WEB_AGENT');
3469: l_base_url := substr(
3470: l_base_url,
3471: 0,
3472: instr(rtrim(l_base_url,'/'),'/',-1,2)-1

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

3492: pos_totals_po_sv.get_po_total(po_header_id),
3493: currency_code,
3494: vendor_id,
3495: vendor_site_id,
3496: to_char(creation_date, fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS'),
3497: fob_lookup_code,
3498: ship_via_lookup_code,
3499: ship_to_location_id,
3500: type_lookup_code,

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

3544: pos_totals_po_sv.get_release_total(pr.po_release_id),
3545: ph.currency_code,
3546: ph.vendor_id,
3547: ph.vendor_site_id,
3548: to_char(pr.creation_date, fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS'),
3549: ph.fob_lookup_code,
3550: ph.ship_via_lookup_code,
3551: ph.ship_to_location_id,
3552: ph.type_lookup_code

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

3789: lc_ship_to_location,
3790: lc_reason;
3791: EXIT when l_po_ack_csr%NOTFOUND;
3792:
3793: l_old_prom_date := to_char(lc_old_prom_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS');
3794: l_new_prom_date := to_char(lc_new_prom_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS');
3795: lc_line_num := nvl(lc_line_num,'` ');
3796: lc_ship_num:= nvl(lc_ship_num,'` ');
3797: lc_buyer_pt_num := nvl(lc_buyer_pt_num,'` ');

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

3790: lc_reason;
3791: EXIT when l_po_ack_csr%NOTFOUND;
3792:
3793: l_old_prom_date := to_char(lc_old_prom_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS');
3794: l_new_prom_date := to_char(lc_new_prom_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS');
3795: lc_line_num := nvl(lc_line_num,'` ');
3796: lc_ship_num:= nvl(lc_ship_num,'` ');
3797: lc_buyer_pt_num := nvl(lc_buyer_pt_num,'` ');
3798: lc_old_sup_pt_num:= nvl(lc_old_sup_pt_num,'` ');

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

3951: fnd_date_tz.init_timezones_for_fnd_date(true);
3952: l_old_prom_date := fnd_date.date_to_displayDT(lc_old_prom_date);
3953: l_new_prom_date := fnd_date.date_to_displayDT(lc_new_prom_date);
3954: else
3955: l_old_prom_date := to_char(lc_old_prom_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS');
3956: l_new_prom_date := to_char(lc_new_prom_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS');
3957: end if;
3958:
3959:

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

3952: l_old_prom_date := fnd_date.date_to_displayDT(lc_old_prom_date);
3953: l_new_prom_date := fnd_date.date_to_displayDT(lc_new_prom_date);
3954: else
3955: l_old_prom_date := to_char(lc_old_prom_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS');
3956: l_new_prom_date := to_char(lc_new_prom_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS');
3957: end if;
3958:
3959:
3960: lc_line_num := nvl(lc_line_num,'` ');

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

4430: pos_totals_po_sv.get_po_total(po_header_id),
4431: currency_code,
4432: vendor_id,
4433: vendor_site_id,
4434: to_char(creation_date, fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS'),
4435: fob_lookup_code,
4436: ship_via_lookup_code,
4437: ship_to_location_id,
4438: type_lookup_code,

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

4459: pos_totals_po_sv.get_release_total(pr.po_release_id),
4460: ph.currency_code,
4461: ph.vendor_id,
4462: ph.vendor_site_id,
4463: to_char(pr.creation_date, fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS'),
4464: ph.fob_lookup_code,
4465: ph.ship_via_lookup_code,
4466: ph.ship_to_location_id,
4467: ph.type_lookup_code,

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

4705: fnd_date_tz.init_timezones_for_fnd_date(true);
4706: l_old_prom_date := fnd_date.date_to_displayDT(lc_old_prom_date);
4707: l_new_prom_date := fnd_date.date_to_displayDT(lc_new_prom_date);
4708: else
4709: l_old_prom_date := to_char(lc_old_prom_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS');
4710: l_new_prom_date := to_char(lc_new_prom_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS');
4711: end if;
4712:
4713:

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

4706: l_old_prom_date := fnd_date.date_to_displayDT(lc_old_prom_date);
4707: l_new_prom_date := fnd_date.date_to_displayDT(lc_new_prom_date);
4708: else
4709: l_old_prom_date := to_char(lc_old_prom_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS');
4710: l_new_prom_date := to_char(lc_new_prom_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS');
4711: end if;
4712:
4713:
4714: lc_line_num := nvl(lc_line_num,'` ');

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

7019: t_varval(5) := 'BUYER_RESP';
7020: t_varname(6) := 'PO_STYLE_TYPE';
7021: t_varval(6) := l_po_style;
7022: t_varname(7) := '#WFM_HTMLAGENT';
7023: t_varval(7) := fnd_profile.value('POS_EXTERNAL_URL');
7024:
7025:
7026: Wf_Engine.SetItemAttrNumberArray('POSCHORD', l_item_key,n_varname,n_varval);
7027: Wf_Engine.SetItemAttrTextArray('POSCHORD', l_item_key,t_varname,t_varval);

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

7917: and fr.application_id = 201
7918: and fr.start_date < sysdate
7919: and nvl(fr.end_date, sysdate +1) >= sysdate
7920: and nvl(fsp.org_id,-1) = nvl(p_org_id,-1)
7921: and nvl(fsp.business_group_id,-1) = nvl(fnd_profile.value_specific('PER_BUSINESS_GROUP_ID', NULL, fr.responsibility_id, fr.application_id),-1);
7922:
7923:
7924: BEGIN
7925: begin

Line 7943: FND_PROFILE.GET('RESP_ID', l_resp_id);

7939:
7940: if (l_user_id <> -1) then
7941: BEGIN
7942:
7943: FND_PROFILE.GET('RESP_ID', l_resp_id);
7944:
7945: select MIN(fr.responsibility_id)
7946: into l_resp_id
7947: from wf_local_user_roles wur,

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

7967: and fr.application_id = l_resp_appl_id
7968: and fr.start_date < sysdate
7969: and nvl(fr.end_date, sysdate +1) >= sysdate
7970: and nvl(fsp.org_id,-1) = nvl(p_org_id,-1)
7971: and nvl(fsp.business_group_id,-1) = nvl(fnd_profile.value_specific('PER_BUSINESS_GROUP_ID', NULL, fr.responsibility_id, fr.application_id),-1);
7972:
7973: EXCEPTION
7974: when others then
7975: l_resp_id := -1;

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

8388: l_api_name varchar2(50) := 'CHECK_POS_EXTERNAL_URL';
8389: l_external_url varchar2(500);
8390: begin
8391:
8392: l_external_url := fnd_profile.value('POS_EXTERNAL_URL');
8393: IF (g_fnd_debug = 'Y' AND FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8394: FND_LOG.string(FND_LOG.level_procedure, g_module_prefix ||
8395: l_api_name || '.start', 'POS_EXTERNAL_URL=' || l_external_url);
8396: END IF;