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_GLOBAL

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

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,
16: p_release_id in number,

Line 154: where user_id = fnd_global.user_id;

150: -- Get Supplier User Name
151: select user_name
152: into l_supplier_username
153: from fnd_user
154: where user_id = fnd_global.user_id;
155:
156: n_varname(1) := 'PO_HEADER_ID';
157: n_varval(1) := p_header_id;
158: n_varname(2) := 'PO_RELEASE_ID';

Line 248: where user_id = fnd_global.user_id;

244: -- Get Supplier User Name
245: select user_name
246: into l_supplier_username
247: from fnd_user
248: where user_id = fnd_global.user_id;
249:
250:
251: n_varname(1) := 'PO_HEADER_ID';
252: n_varval(1) := p_header_id;

Line 422: nvl(fnd_global.user_id, 1),

418: p_doc_type,
419: p_doc_subtype,
420: l_sequence_num,
421: sysdate,
422: nvl(fnd_global.user_id, 1),
423: sysdate,
424: nvl(fnd_global.user_id, 1),
425: p_action,
426: decode(p_action, '',to_date(null,'DD/MM/YYYY'), sysdate),

Line 424: nvl(fnd_global.user_id, 1),

420: l_sequence_num,
421: sysdate,
422: nvl(fnd_global.user_id, 1),
423: sysdate,
424: nvl(fnd_global.user_id, 1),
425: p_action,
426: decode(p_action, '',to_date(null,'DD/MM/YYYY'), sysdate),
427: p_employee_id,
428: p_note,

Line 430: nvl(fnd_global.login_id, 1),

426: decode(p_action, '',to_date(null,'DD/MM/YYYY'), sysdate),
427: p_employee_id,
428: p_note,
429: l_revision_num,
430: nvl(fnd_global.login_id, 1),
431: 0,
432: 0,
433: 0,
434: '',

Line 448: last_updated_by = nvl(fnd_global.user_id, 1),

444: object_type_code = p_doc_type,
445: object_sub_type_code = p_doc_subtype,
446: sequence_num = l_sequence_num,
447: last_update_date = sysdate,
448: last_updated_by = nvl(fnd_global.user_id, 1),
449: creation_date = sysdate,
450: created_by = nvl(fnd_global.user_id, 1),
451: action_code = p_action,
452: action_date = decode(p_action, '',to_date(null,'DD/MM/YYYY'), sysdate),

Line 450: created_by = nvl(fnd_global.user_id, 1),

446: sequence_num = l_sequence_num,
447: last_update_date = sysdate,
448: last_updated_by = nvl(fnd_global.user_id, 1),
449: creation_date = sysdate,
450: created_by = nvl(fnd_global.user_id, 1),
451: action_code = p_action,
452: action_date = decode(p_action, '',to_date(null,'DD/MM/YYYY'), sysdate),
453: employee_id = p_employee_id,
454: note = p_note,

Line 456: last_update_login = nvl(fnd_global.login_id, 1),

452: action_date = decode(p_action, '',to_date(null,'DD/MM/YYYY'), sysdate),
453: employee_id = p_employee_id,
454: note = p_note,
455: object_revision_num = l_revision_num,
456: last_update_login = nvl(fnd_global.login_id, 1),
457: request_id = 0,
458: program_application_id = 0,
459: program_id = 0,
460: program_update_date = '',

Line 925: l_Created_By number := fnd_global.user_id;

921: -- End of Bug 2850566
922: l_Last_Update_Date date;
923: l_Last_Updated_By number;
924: l_Creation_Date date := TRUNC(SYSDATE);
925: l_Created_By number := fnd_global.user_id;
926: l_Po_Header_Id number;
927: l_Po_Release_Id number;
928: l_Action varchar2(240) := 'NEW';
929: l_Action_Date date := TRUNC(SYSDATE);

Line 1372: fnd_global.APPS_INITIALIZE(l_user_id, l_resp_id, l_appl_id);

1368: if (l_user_id is not null and
1369: l_resp_id is not null and
1370: l_appl_id is not null )then
1371:
1372: fnd_global.APPS_INITIALIZE(l_user_id, l_resp_id, l_appl_id);
1373:
1374: else
1375:
1376: initialize (l_agent_id, l_org_id);

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 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 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 6527: l_user_id := FND_GLOBAL.USER_ID;

6523:
6524: -- fix for bug 4946410 added signature flag check( these po's are blocked and changed to 'APPROVED' after background process is run
6525: if((l_authorization_status = 'APPROVED') OR (l_authorization_status = 'PRE-APPROVED' AND l_acceptance_required_flag = 'S')) then
6526: resultout := 'Y';
6527: l_user_id := FND_GLOBAL.USER_ID;
6528: -- For those records which has been approved default the promised date
6529: if(l_authorization_status = 'APPROVED' AND l_acceptance_required_flag = 'Y' AND g_default_promise_date = 'Y') THEN
6530: OPEN getLineLocID(l_change_request_group_id);
6531: LOOP

Line 7736: l_revision_num, l_chg_req_grp_id, fnd_global.user_id, l_err_msg,

7732: aname => 'CHANGE_REQUEST_GROUP_ID');
7733:
7734: x_progress := '001';
7735: ProcessResponse(1.0, l_return_status, l_header_id, l_release_id,
7736: l_revision_num, l_chg_req_grp_id, fnd_global.user_id, l_err_msg,
7737: l_return_code,l_doc_check_rec_type, 'Y', 'Y');
7738:
7739: exception when others then
7740: wf_core.context('PO_ChangeOrderWF_PVT','PROCESS_RESPONSE',x_progress);

Line 7768: l_responded_by :=fnd_global.user_id;

7764:
7765: IF( l_notif_usage = 'BUYER_AUTO_FYI') THEN
7766: l_responded_by :=null;
7767: ELSE
7768: l_responded_by :=fnd_global.user_id;
7769: END IF;
7770:
7771: update po_change_requests
7772: set request_status ='BUYER_APP',

Line 7844: responded_by = fnd_global.user_id,

7840:
7841: update po_change_requests
7842: set request_status ='REJECTED',
7843: change_active_flag = 'N',
7844: responded_by = fnd_global.user_id,
7845: response_date = sysdate
7846: where change_request_group_id = l_chg_req_grp_id
7847: and request_status in ('PENDING','REQ_APP'); -- RDP ( Update records lying in REQ_APP status too)
7848: exception when others then

Line 7916: where user_id = fnd_global.user_id;

7912: -- Get Supplier User Name
7913: select user_name
7914: into l_supplier_username
7915: from fnd_user
7916: where user_id = fnd_global.user_id;
7917:
7918: wf_engine.SetItemAttrText(itemtype => 'POSCHORD',
7919: itemkey => l_item_key,
7920: aname => 'RESP_ID',

Line 7921: avalue => fnd_global.RESP_ID);

7917:
7918: wf_engine.SetItemAttrText(itemtype => 'POSCHORD',
7919: itemkey => l_item_key,
7920: aname => 'RESP_ID',
7921: avalue => fnd_global.RESP_ID);
7922:
7923: wf_engine.SetItemAttrText(itemtype => 'POSCHORD',
7924: itemkey => l_item_key,
7925: aname => 'APPL_RESP_ID',

Line 7926: avalue => fnd_global.RESP_APPL_ID);

7922:
7923: wf_engine.SetItemAttrText(itemtype => 'POSCHORD',
7924: itemkey => l_item_key,
7925: aname => 'APPL_RESP_ID',
7926: avalue => fnd_global.RESP_APPL_ID);
7927:
7928: if(p_release_id is null) then
7929: select agent_id
7930: into l_buyer_agent_id

Line 8053: Fetching application id from fnd_global resolves the issue. */

8049:
8050: /* bug 9672656 : application id is hard coded to 201. In case of custom application with custom reponsibilities,
8051: when requistion is changed (which is on an approved PO), and the eventual PO Change Request fires, the
8052: resulting POAPPRV process errors.
8053: Fetching application id from fnd_global resolves the issue. */
8054: -- Bug 13915321 reverting the fix
8055: l_resp_appl_id NUMBER := 201;
8056:
8057: --l_resp_appl_id NUMBER := fnd_global.resp_appl_id;

Line 8057: --l_resp_appl_id NUMBER := fnd_global.resp_appl_id;

8053: Fetching application id from fnd_global resolves the issue. */
8054: -- Bug 13915321 reverting the fix
8055: l_resp_appl_id NUMBER := 201;
8056:
8057: --l_resp_appl_id NUMBER := fnd_global.resp_appl_id;
8058:
8059:
8060: l_api_name varchar2(50) := 'initialize';
8061: l_progress varchar2(5) := '000';

Line 8182: l_resp_appl_id := fnd_global.resp_appl_id;

8178: document manager can proceed only on
8179: purchasing responsibility
8180: But retaining the fix for avoiding regressions after discussion with Raja*/
8181: if (l_resp_id = -1 OR l_resp_id is null) then
8182: l_resp_appl_id := fnd_global.resp_appl_id;
8183: if(l_user_id <>-1) then
8184: l_progress := '004';
8185: BEGIN
8186:

Line 8269: FND_GLOBAL.APPS_INITIALIZE(l_user_id,l_resp_id,l_resp_appl_id);

8265: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8266: FND_LOG.string(FND_LOG.level_procedure, g_module_prefix ||
8267: l_api_name || '.intialize parameters',l_user_id||'*'||l_resp_id||'*'||l_resp_appl_id );
8268: END IF;
8269: FND_GLOBAL.APPS_INITIALIZE(l_user_id,l_resp_id,l_resp_appl_id);
8270: exception when others then
8271: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8272: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
8273: l_api_name || '.others_exception', sqlerrm);

Line 8645: fnd_global.APPS_INITIALIZE(p_supplier_user_id, p_resp_id, p_appl_resp_id);

8641: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8642: FND_LOG.string(FND_LOG.level_procedure, g_module_prefix || '.SET_SUPPLIER_CONTEXT', 'user_id:'||p_supplier_user_id||'resp:'||p_resp_id||'appl id:'||p_appl_resp_id );
8643: END IF;
8644:
8645: fnd_global.APPS_INITIALIZE(p_supplier_user_id, p_resp_id, p_appl_resp_id);
8646:
8647: EXCEPTION
8648: WHEN OTHERS THEN
8649: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 8798: l_session_user_id := fnd_global.user_id;

8794: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,l_api_name,'l_progress ' ||l_progress);
8795: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,l_api_name,'l_responder_id ' ||l_responder_id);
8796: END IF;
8797: --
8798: l_session_user_id := fnd_global.user_id;
8799: l_session_resp_id := fnd_global.resp_id;
8800: l_session_appl_id := fnd_global.resp_appl_id;
8801:
8802: --

Line 8799: l_session_resp_id := fnd_global.resp_id;

8795: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,l_api_name,'l_responder_id ' ||l_responder_id);
8796: END IF;
8797: --
8798: l_session_user_id := fnd_global.user_id;
8799: l_session_resp_id := fnd_global.resp_id;
8800: l_session_appl_id := fnd_global.resp_appl_id;
8801:
8802: --
8803: IF (g_fnd_debug = 'Y') THEN

Line 8800: l_session_appl_id := fnd_global.resp_appl_id;

8796: END IF;
8797: --
8798: l_session_user_id := fnd_global.user_id;
8799: l_session_resp_id := fnd_global.resp_id;
8800: l_session_appl_id := fnd_global.resp_appl_id;
8801:
8802: --
8803: IF (g_fnd_debug = 'Y') THEN
8804: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,l_api_name,'l_session_user_id ' ||l_session_user_id);

Line 9045: l_session_user_id := fnd_global.user_id;

9041:
9042: l_org_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
9043: itemkey => p_itemkey,
9044: aname => 'ORG_ID');
9045: l_session_user_id := fnd_global.user_id;
9046: l_session_resp_id := fnd_global.resp_id;
9047:
9048: IF (l_session_user_id = -1) THEN
9049: l_session_user_id := NULL;

Line 9046: l_session_resp_id := fnd_global.resp_id;

9042: l_org_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
9043: itemkey => p_itemkey,
9044: aname => 'ORG_ID');
9045: l_session_user_id := fnd_global.user_id;
9046: l_session_resp_id := fnd_global.resp_id;
9047:
9048: IF (l_session_user_id = -1) THEN
9049: l_session_user_id := NULL;
9050: END IF;

Line 9162: fnd_global.apps_initialize(l_user_id_to_set, l_resp_id_to_set,l_appl_id_to_set);

9158: END IF;
9159: --
9160: end if;
9161:
9162: fnd_global.apps_initialize(l_user_id_to_set, l_resp_id_to_set,l_appl_id_to_set);
9163:
9164: -- obvious place to make such a call, since we are using an apps_initialize,
9165: -- this is required since the responsibility might have a different OU attached
9166: -- than what is required.