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_POAPPROVAL_INIT1 dependencies on PO_POAPPROVAL_INIT1

Line 1: PACKAGE BODY PO_POAPPROVAL_INIT1 AS

1: PACKAGE BODY PO_POAPPROVAL_INIT1 AS
2: /* $Header: POXWPA2B.pls 120.7.12010000.2 2008/08/04 08:35:46 rramasam 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_POAPPROVAL_INIT1';

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: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on; --< Bug 3554754 >
7:
8: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_POAPPROVAL_INIT1';
9: g_module_prefix CONSTANT VARCHAR2(40) := 'po.plsql.' || g_pkg_name || '.';
10:
11: /*=======================================================================+
12: | FILENAME

Line 16: | PL/SQL body for package: PO_POAPPROVAL_INIT1

Line 72: x_progress := 'PO_POAPPROVAL_INIT1.Get_PO_Attributes: 01';

68: l_preparer_user_name varchar2(100);
69:
70: BEGIN
71:
72: x_progress := 'PO_POAPPROVAL_INIT1.Get_PO_Attributes: 01';
73: IF (g_po_wf_debug = 'Y') THEN
74: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
75: END IF;
76:

Line 128: x_progress := 'PO_POAPPROVAL_INIT1.Get_PO_Attributes: 02';

124:
125: --
126: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
127: --
128: x_progress := 'PO_POAPPROVAL_INIT1.Get_PO_Attributes: 02';
129: IF (g_po_wf_debug = 'Y') THEN
130: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
131: END IF;
132:

Line 139: wf_core.context('PO_POAPPROVAL_INIT1','Get_PO_Attributes',x_progress);

135:
136: WHEN OTHERS THEN
137: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
138: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
139: wf_core.context('PO_POAPPROVAL_INIT1','Get_PO_Attributes',x_progress);
140: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_POAPPROVAL_INIT1.GET_PO_ATTRIBUTES');
141: raise;
142:
143: END Get_PO_Attributes;

Line 140: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_POAPPROVAL_INIT1.GET_PO_ATTRIBUTES');

136: WHEN OTHERS THEN
137: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
138: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
139: wf_core.context('PO_POAPPROVAL_INIT1','Get_PO_Attributes',x_progress);
140: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_POAPPROVAL_INIT1.GET_PO_ATTRIBUTES');
141: raise;
142:
143: END Get_PO_Attributes;
144:

Line 171: x_progress := 'PO_POAPPROVAL_INIT1.Is_this_new_doc: 01';

167: l_return_status VARCHAR2(1); --< Bug 3554754 >
168:
169: BEGIN
170:
171: x_progress := 'PO_POAPPROVAL_INIT1.Is_this_new_doc: 01';
172: IF (g_po_wf_debug = 'Y') THEN
173: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
174: END IF;
175:

Line 233: x_progress := 'PO_POAPPROVAL_INIT1.Is_this_new_doc: 02: ' || l_is_new_document;

229:
230: resultout := wf_engine.eng_completed || ':' || l_is_new_document;
231: --
232:
233: x_progress := 'PO_POAPPROVAL_INIT1.Is_this_new_doc: 02: ' || l_is_new_document;
234: IF (g_po_wf_debug = 'Y') THEN
235: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
236: END IF;
237:

Line 244: wf_core.context('PO_POAPPROVAL_INIT1','Is_this_new_doc',x_progress);

240:
241: WHEN OTHERS THEN
242: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
243: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
244: wf_core.context('PO_POAPPROVAL_INIT1','Is_this_new_doc',x_progress);
245: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_POAPPROVAL_INIT1.IS_THIS_NEW_DOC');
246: raise;
247:
248: END Is_this_new_doc;

Line 245: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_POAPPROVAL_INIT1.IS_THIS_NEW_DOC');

241: WHEN OTHERS THEN
242: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
243: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
244: wf_core.context('PO_POAPPROVAL_INIT1','Is_this_new_doc',x_progress);
245: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_POAPPROVAL_INIT1.IS_THIS_NEW_DOC');
246: raise;
247:
248: END Is_this_new_doc;
249:

Line 279: x_progress := 'PO_POAPPROVAL_INIT1.Is_Acceptance_Required: 01';

275: l_preparer_user_name varchar2(100);
276:
277: BEGIN
278:
279: x_progress := 'PO_POAPPROVAL_INIT1.Is_Acceptance_Required: 01';
280: IF (g_po_wf_debug = 'Y') THEN
281: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
282: END IF;
283:

Line 339: x_progress := 'PO_POAPPROVAL_INIT1.Is_Acceptance_Required: 02';

335: resultout := wf_engine.eng_completed || ':' || 'N';
336:
337: END IF;
338:
339: x_progress := 'PO_POAPPROVAL_INIT1.Is_Acceptance_Required: 02';
340: IF (g_po_wf_debug = 'Y') THEN
341: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
342: END IF;
343:

Line 348: wf_core.context('PO_POAPPROVAL_INIT1','Is_Acceptance_Required',x_progress);

344: EXCEPTION
345: WHEN OTHERS THEN
346: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
347: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
348: wf_core.context('PO_POAPPROVAL_INIT1','Is_Acceptance_Required',x_progress);
349: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_POAPPROVAL_INIT1.IS_ACCEPTANCE_REQUIRED');
350: raise;
351:
352: END Is_Acceptance_Required;

Line 349: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_POAPPROVAL_INIT1.IS_ACCEPTANCE_REQUIRED');

345: WHEN OTHERS THEN
346: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
347: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
348: wf_core.context('PO_POAPPROVAL_INIT1','Is_Acceptance_Required',x_progress);
349: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_POAPPROVAL_INIT1.IS_ACCEPTANCE_REQUIRED');
350: raise;
351:
352: END Is_Acceptance_Required;
353:

Line 368: x_progress := 'PO_POAPPROVAL_INIT1.GetPOAttributes: 01';

364:
365: counter NUMBER:=0;
366: BEGIN
367:
368: x_progress := 'PO_POAPPROVAL_INIT1.GetPOAttributes: 01';
369: IF (g_po_wf_debug = 'Y') THEN
370: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
371: END IF;
372:

Line 378: x_progress := 'PO_POAPPROVAL_INIT1.GetPOAttributes: 02';

374: open GetPOHdr_csr(p_po_header_id);
375: FETCH GetPOHdr_csr into POHdr_rec;
376: close GetPOHdr_csr;
377:
378: x_progress := 'PO_POAPPROVAL_INIT1.GetPOAttributes: 02';
379: IF (g_po_wf_debug = 'Y') THEN
380: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
381: END IF;
382:

Line 385: x_progress := 'PO_POAPPROVAL_INIT1.GetPOAttributes: 03';

381: END IF;
382:
383: SetPOHdrAttributes(itemtype, itemkey);
384:
385: x_progress := 'PO_POAPPROVAL_INIT1.GetPOAttributes: 03';
386: IF (g_po_wf_debug = 'Y') THEN
387: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
388: END IF;
389:

Line 392: wf_core.context('PO_POAPPROVAL_INIT1','GetPOAttributes',x_progress);

388: END IF;
389:
390: EXCEPTION
391: WHEN OTHERS THEN
392: wf_core.context('PO_POAPPROVAL_INIT1','GetPOAttributes',x_progress);
393: raise;
394:
395: end GetPOAttributes;
396: --

Line 461: x_progress := 'PO_POAPPROVAL_INIT1.SetPOHdrAttributes: 01';

457: */
458:
459: BEGIN
460:
461: x_progress := 'PO_POAPPROVAL_INIT1.SetPOHdrAttributes: 01';
462: IF (g_po_wf_debug = 'Y') THEN
463: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
464: END IF;
465:

Line 673: wf_core.context('PO_POAPPROVAL_INIT1','SetPOHdrAttributes',x_progress);

669: avalue => l_total_amount_disp);
670:
671: EXCEPTION
672: WHEN OTHERS THEN
673: wf_core.context('PO_POAPPROVAL_INIT1','SetPOHdrAttributes',x_progress);
674: raise;
675:
676:
677: end SetPOHdrAttributes;

Line 690: x_progress := 'PO_POAPPROVAL_INIT1.GetRelAttributes: 01';

686: counter NUMBER:=0;
687: BEGIN
688:
689:
690: x_progress := 'PO_POAPPROVAL_INIT1.GetRelAttributes: 01';
691: IF (g_po_wf_debug = 'Y') THEN
692: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
693: END IF;
694:

Line 700: x_progress := 'PO_POAPPROVAL_INIT1.GetRelAttributes: 02';

696: open GetRelHdr_csr(p_rel_header_id);
697: FETCH GetRelHdr_csr into RelHdr_rec;
698: close GetRelHdr_csr;
699:
700: x_progress := 'PO_POAPPROVAL_INIT1.GetRelAttributes: 02';
701: IF (g_po_wf_debug = 'Y') THEN
702: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
703: END IF;
704:

Line 707: x_progress := 'PO_POAPPROVAL_INIT1.GetReLattributes: 03';

703: END IF;
704:
705: SetRelHdrAttributes(itemtype, itemkey);
706:
707: x_progress := 'PO_POAPPROVAL_INIT1.GetReLattributes: 03';
708: IF (g_po_wf_debug = 'Y') THEN
709: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
710: END IF;
711:

Line 716: wf_core.context('PO_POAPPROVAL_INIT1','GetRelAttributes',x_progress);

712: EXCEPTION
713: WHEN OTHERS THEN
714: CLOSE GetRelHdr_csr;
715:
716: wf_core.context('PO_POAPPROVAL_INIT1','GetRelAttributes',x_progress);
717: raise;
718:
719: end GetRelAttributes;
720:

Line 787: x_progress := 'PO_POAPPROVAL_INIT1.SetPOHdrAttributes : 01';

783: */
784:
785: BEGIN
786:
787: x_progress := 'PO_POAPPROVAL_INIT1.SetPOHdrAttributes : 01';
788: IF (g_po_wf_debug = 'Y') THEN
789: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
790: END IF;
791:

Line 973: wf_core.context('PO_POAPPROVAL_INIT1','SetRelHdrAttributes',x_progress);

969: avalue => l_total_amount_disp);
970:
971: EXCEPTION
972: WHEN OTHERS THEN
973: wf_core.context('PO_POAPPROVAL_INIT1','SetRelHdrAttributes',x_progress);
974: raise;
975:
976:
977: end SetRelHdrAttributes;

Line 1045: wf_core.context('PO_POAPPROVAL_INIT1',

1041: FROM po_requisition_headers
1042: WHERE requisition_header_id = doc_header_id;
1043:
1044: ELSE
1045: wf_core.context('PO_POAPPROVAL_INIT1',
1046: 'Reserve_Unreserve_Check - Invalid doctype', '004');
1047: app_exception.Raise_Exception;
1048:
1049: END IF;

Line 1106: wf_core.context('PO_POAPPROVAL_INIT1',

1102: RETURN FALSE;
1103: END IF;
1104:
1105: ELSE
1106: wf_core.context('PO_POAPPROVAL_INIT1',
1107: 'Reserve_Unreserve_Check - Invalid action', '004');
1108: app_exception.Raise_Exception;
1109:
1110: END IF;

Line 1116: wf_core.context('PO_POAPPROVAL_INIT1','Reserve_Unreserve_Check',l_progress);

1112: l_progress := '100';
1113:
1114: EXCEPTION
1115: WHEN OTHERS THEN
1116: wf_core.context('PO_POAPPROVAL_INIT1','Reserve_Unreserve_Check',l_progress);
1117: raise;
1118:
1119: end Reserve_Unreserve_Check;
1120:

Line 1817: end PO_POAPPROVAL_INIT1;

1813: END get_approved_date;
1814: --< Bug 3554754 End >
1815:
1816: --
1817: end PO_POAPPROVAL_INIT1;