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.35.12020000.6 2013/03/22 06:47:06 kuichen 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 87: x_progress := 'PO_POAPPROVAL_INIT1.Get_PO_Attributes: 01';

83:
84:
85: BEGIN
86:
87: x_progress := 'PO_POAPPROVAL_INIT1.Get_PO_Attributes: 01';
88: IF (g_po_wf_debug = 'Y') THEN
89: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
90: END IF;
91:

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

193:
194: --
195: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
196: --
197: x_progress := 'PO_POAPPROVAL_INIT1.Get_PO_Attributes: 02';
198: IF (g_po_wf_debug = 'Y') THEN
199: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
200: END IF;
201:

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

204:
205: WHEN OTHERS THEN
206: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
207: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
208: wf_core.context('PO_POAPPROVAL_INIT1','Get_PO_Attributes',x_progress);
209: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_POAPPROVAL_INIT1.GET_PO_ATTRIBUTES');
210: raise;
211:
212: END Get_PO_Attributes;

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

205: WHEN OTHERS THEN
206: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
207: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
208: wf_core.context('PO_POAPPROVAL_INIT1','Get_PO_Attributes',x_progress);
209: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_POAPPROVAL_INIT1.GET_PO_ATTRIBUTES');
210: raise;
211:
212: END Get_PO_Attributes;
213:

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

236: l_return_status VARCHAR2(1); --< Bug 3554754 >
237:
238: BEGIN
239:
240: x_progress := 'PO_POAPPROVAL_INIT1.Is_this_new_doc: 01';
241: IF (g_po_wf_debug = 'Y') THEN
242: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
243: END IF;
244:

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

298:
299: resultout := wf_engine.eng_completed || ':' || l_is_new_document;
300: --
301:
302: x_progress := 'PO_POAPPROVAL_INIT1.Is_this_new_doc: 02: ' || l_is_new_document;
303: IF (g_po_wf_debug = 'Y') THEN
304: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
305: END IF;
306:

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

309:
310: WHEN OTHERS THEN
311: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
312: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
313: wf_core.context('PO_POAPPROVAL_INIT1','Is_this_new_doc',x_progress);
314: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_POAPPROVAL_INIT1.IS_THIS_NEW_DOC');
315: raise;
316:
317: END Is_this_new_doc;

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

310: WHEN OTHERS THEN
311: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
312: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
313: wf_core.context('PO_POAPPROVAL_INIT1','Is_this_new_doc',x_progress);
314: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_POAPPROVAL_INIT1.IS_THIS_NEW_DOC');
315: raise;
316:
317: END Is_this_new_doc;
318:

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

344: l_preparer_user_name varchar2(100);
345:
346: BEGIN
347:
348: x_progress := 'PO_POAPPROVAL_INIT1.Is_Acceptance_Required: 01';
349: IF (g_po_wf_debug = 'Y') THEN
350: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
351: END IF;
352:

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

404: resultout := wf_engine.eng_completed || ':' || 'N';
405:
406: END IF;
407:
408: x_progress := 'PO_POAPPROVAL_INIT1.Is_Acceptance_Required: 02';
409: IF (g_po_wf_debug = 'Y') THEN
410: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
411: END IF;
412:

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

413: EXCEPTION
414: WHEN OTHERS THEN
415: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
416: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
417: wf_core.context('PO_POAPPROVAL_INIT1','Is_Acceptance_Required',x_progress);
418: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_POAPPROVAL_INIT1.IS_ACCEPTANCE_REQUIRED');
419: raise;
420:
421: END Is_Acceptance_Required;

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

414: WHEN OTHERS THEN
415: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
416: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
417: wf_core.context('PO_POAPPROVAL_INIT1','Is_Acceptance_Required',x_progress);
418: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_POAPPROVAL_INIT1.IS_ACCEPTANCE_REQUIRED');
419: raise;
420:
421: END Is_Acceptance_Required;
422:

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

434:
435: counter NUMBER:=0;
436: BEGIN
437:
438: x_progress := 'PO_POAPPROVAL_INIT1.GetPOAttributes: 01';
439: IF (g_po_wf_debug = 'Y') THEN
440: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
441: END IF;
442:

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

462:
463: End If;
464: -- CLM Aprvl
465:
466: x_progress := 'PO_POAPPROVAL_INIT1.GetPOAttributes: 02';
467: IF (g_po_wf_debug = 'Y') THEN
468: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
469: END IF;
470:

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

469: END IF;
470:
471: SetPOHdrAttributes(itemtype, itemkey);
472:
473: x_progress := 'PO_POAPPROVAL_INIT1.GetPOAttributes: 03';
474: IF (g_po_wf_debug = 'Y') THEN
475: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
476: END IF;
477:

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

476: END IF;
477:
478: EXCEPTION
479: WHEN OTHERS THEN
480: wf_core.context('PO_POAPPROVAL_INIT1','GetPOAttributes',x_progress);
481: raise;
482:
483: end GetPOAttributes;
484: --

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

548:
549:
550: BEGIN
551:
552: x_progress := 'PO_POAPPROVAL_INIT1.SetPOHdrAttributes: 01';
553: IF (g_po_wf_debug = 'Y') THEN
554: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
555: END IF;
556: -- CLM Apprvl. The document_number has to be set to draft_id in case of modifications

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

869:
870:
871: EXCEPTION
872: WHEN OTHERS THEN
873: wf_core.context('PO_POAPPROVAL_INIT1','SetPOHdrAttributes',x_progress);
874: raise;
875:
876:
877: end SetPOHdrAttributes;

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

886: counter NUMBER:=0;
887: BEGIN
888:
889:
890: x_progress := 'PO_POAPPROVAL_INIT1.GetRelAttributes: 01';
891: IF (g_po_wf_debug = 'Y') THEN
892: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
893: END IF;
894:

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

896: open GetRelHdr_csr(p_rel_header_id);
897: FETCH GetRelHdr_csr into RelHdr_rec;
898: close GetRelHdr_csr;
899:
900: x_progress := 'PO_POAPPROVAL_INIT1.GetRelAttributes: 02';
901: IF (g_po_wf_debug = 'Y') THEN
902: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
903: END IF;
904:

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

903: END IF;
904:
905: SetRelHdrAttributes(itemtype, itemkey);
906:
907: x_progress := 'PO_POAPPROVAL_INIT1.GetReLattributes: 03';
908: IF (g_po_wf_debug = 'Y') THEN
909: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
910: END IF;
911:

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

912: EXCEPTION
913: WHEN OTHERS THEN
914: CLOSE GetRelHdr_csr;
915:
916: wf_core.context('PO_POAPPROVAL_INIT1','GetRelAttributes',x_progress);
917: raise;
918:
919: end GetRelAttributes;
920:

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

989: */
990:
991: BEGIN
992:
993: x_progress := 'PO_POAPPROVAL_INIT1.SetPOHdrAttributes : 01';
994: IF (g_po_wf_debug = 'Y') THEN
995: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
996: END IF;
997:

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

1201: avalue => l_total_amount_disp);
1202:
1203: EXCEPTION
1204: WHEN OTHERS THEN
1205: wf_core.context('PO_POAPPROVAL_INIT1','SetRelHdrAttributes',x_progress);
1206: raise;
1207:
1208:
1209: end SetRelHdrAttributes;

Line 1277: wf_core.context('PO_POAPPROVAL_INIT1',

1273: FROM po_requisition_headers
1274: WHERE requisition_header_id = doc_header_id;
1275:
1276: ELSE
1277: wf_core.context('PO_POAPPROVAL_INIT1',
1278: 'Reserve_Unreserve_Check - Invalid doctype', '004');
1279: app_exception.Raise_Exception;
1280:
1281: END IF;

Line 1338: wf_core.context('PO_POAPPROVAL_INIT1',

1334: RETURN FALSE;
1335: END IF;
1336:
1337: ELSE
1338: wf_core.context('PO_POAPPROVAL_INIT1',
1339: 'Reserve_Unreserve_Check - Invalid action', '004');
1340: app_exception.Raise_Exception;
1341:
1342: END IF;

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

1344: l_progress := '100';
1345:
1346: EXCEPTION
1347: WHEN OTHERS THEN
1348: wf_core.context('PO_POAPPROVAL_INIT1','Reserve_Unreserve_Check',l_progress);
1349: raise;
1350:
1351: end Reserve_Unreserve_Check;
1352:

Line 2069: end PO_POAPPROVAL_INIT1;

2065: END get_approved_date;
2066: --< Bug 3554754 End >
2067:
2068: --
2069: end PO_POAPPROVAL_INIT1;