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_CREATE_SR_ASL dependencies on PO_CREATE_SR_ASL

Line 1: PACKAGE BODY PO_CREATE_SR_ASL AS

1: PACKAGE BODY PO_CREATE_SR_ASL AS
2: /* $Header: POXWSRAB.pls 120.6.12020000.2 2013/02/10 20:19:22 vegajula ship $ */
3:
4: -- Read the profile option that enables/disables the debug log
5: g_po_wf_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_WORKFLOW_ON'),'N');

Line 8: g_PKG_NAME CONSTANT varchar2(30) := 'PO_CREATE_SR_ASL.';

4: -- Read the profile option that enables/disables the debug log
5: g_po_wf_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_WORKFLOW_ON'),'N');
6:
7: --
8: g_PKG_NAME CONSTANT varchar2(30) := 'PO_CREATE_SR_ASL.';
9: g_po_pdoi_write_to_file VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_PDOI_WRITE_TO_FILE'),'N');
10: --
11:
12: /*=======================================================================+

Line 17: | PL/SQL body for package: PO_CREATE_SR_ASL

Line 51: x_progress := 'PO_CREATE_SR_ASL:PROCESS_PO_LINES_FOR_SR_ASL: 01';

47: l_interface_line_id NUMBER;
48: l_org_assign_change VARCHAR2(1);
49:
50: BEGIN
51: x_progress := 'PO_CREATE_SR_ASL:PROCESS_PO_LINES_FOR_SR_ASL: 01';
52: IF (g_po_wf_debug = 'Y') THEN
53: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
54: END IF;
55:

Line 266: x_progress := 'PO_CREATE_SR_ASL:Create_ASL: 01';

262: and enabled_flag = 'Y';
263:
264: BEGIN
265:
266: x_progress := 'PO_CREATE_SR_ASL:Create_ASL: 01';
267: IF (g_po_wf_debug = 'Y') THEN
268: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
269: END IF;
270:

Line 389: x_progress := 'PO_CREATE_SR_ASL:Create_Sourcing_Rule: 01';

385: l_update_sourcing_rule_flag varchar2(1);
386: l_return_status varchar2(1); --
387:
388: BEGIN
389: x_progress := 'PO_CREATE_SR_ASL:Create_Sourcing_Rule: 01';
390: IF (g_po_wf_debug = 'Y') THEN
391: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
392: END IF;
393:

Line 1228: -- This procedure is a wrapper around the call to PO_CREATE_SR_ASL.create_autosource_rules.

1224: -------------------------------------------------------------------------------
1225: --Bug 10417292 - Launching Conucrrent Request for Creating ASL and SR
1226: --Instead of doing it in workflow
1227: --Name: create_autosource_rules
1228: -- This procedure is a wrapper around the call to PO_CREATE_SR_ASL.create_autosource_rules.
1229: -- This will be used in poapparv.wft to create AR and ASL in one go without iterating for each line.
1230: --End of Comments
1231: -------------------------------------------------------------------------------
1232: procedure CREATE_SR_ASL (itemtype in varchar2,

Line 1258: x_progress := 'PO_CREATE_SR_ASL.Create_SR_ASL: 01';

1254:
1255:
1256: BEGIN
1257:
1258: x_progress := 'PO_CREATE_SR_ASL.Create_SR_ASL: 01';
1259: IF (g_po_wf_debug = 'Y') THEN
1260: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1261: END IF;
1262:

Line 1279: x_progress := 'PO_CREATE_SR_ASL.Create_SR_ASL: l_vendor_id: '||l_vendor_id||', l_vendor_site_id: '||l_vendor_site_id||', l_document_id: '||l_document_id||', l_release_generation_method: '||l_release_generation_method;

1275: end;
1276:
1277: l_release_generation_method := wf_engine.GetItemAttrText ( itemtype, itemkey, 'RELEASE_GENERATION_METHOD');
1278:
1279: x_progress := 'PO_CREATE_SR_ASL.Create_SR_ASL: l_vendor_id: '||l_vendor_id||', l_vendor_site_id: '||l_vendor_site_id||', l_document_id: '||l_document_id||', l_release_generation_method: '||l_release_generation_method;
1280:
1281: IF (g_po_wf_debug = 'Y') THEN
1282: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1283: END IF;

Line 1318: x_progress := 'PO_CREATE_SR_ASL.Create_SR_ASL: : Request id is - '|| l_request_id;

1314: ,null -- sourcing rule name
1315: ,l_release_generation_method -- Release generation method
1316: );
1317:
1318: x_progress := 'PO_CREATE_SR_ASL.Create_SR_ASL: : Request id is - '|| l_request_id;
1319: IF (g_po_wf_debug = 'Y') THEN
1320: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1321: END IF;
1322:

Line 1333: x_progress := 'PO_CREATE_SR_ASL.Create_SR_ASL: Error: '||sqlerrm;

1329:
1330:
1331: EXCEPTION
1332: WHEN OTHERS THEN
1333: x_progress := 'PO_CREATE_SR_ASL.Create_SR_ASL: Error: '||sqlerrm;
1334: IF (g_po_wf_debug = 'Y') THEN
1335: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1336: END IF;
1337: resultout := wf_engine.eng_completed || ':' || '';

Line 1344: END PO_CREATE_SR_ASL;

1340: END Create_SR_ASL;
1341:
1342:
1343:
1344: END PO_CREATE_SR_ASL;