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_REQAPPROVAL_ACTION dependencies on PO_REQAPPROVAL_ACTION

Line 1: PACKAGE BODY PO_REQAPPROVAL_ACTION AS

1: PACKAGE BODY PO_REQAPPROVAL_ACTION AS
2: /* $Header: POXWPA4B.pls 120.8.12000000.3 2007/10/09 17:15:41 cvardia 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 12: | PL/SQL body for package: PO_REQAPPROVAL_ACTION

Line 298: WF_CORE.context('PO_REQAPPROVAL_ACTION' , 'Invoke_Acknowledge_PO_WF', itemtype, itemkey, x_progress);

294:
295: EXCEPTION
296:
297: WHEN OTHERS THEN
298: WF_CORE.context('PO_REQAPPROVAL_ACTION' , 'Invoke_Acknowledge_PO_WF', itemtype, itemkey, x_progress);
299: RAISE;
300:
301: end;
302:

Line 326: x_progress := 'PO_REQAPPROVAL_ACTION.State_Check_approve: 01';

322:
323:
324: BEGIN
325:
326: x_progress := 'PO_REQAPPROVAL_ACTION.State_Check_approve: 01';
327: IF (g_po_wf_debug = 'Y') THEN
328: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
329: END IF;
330:

Line 395: x_progress := 'PO_REQAPPROVAL_ACTION.State_Check_approve: 02. RESULT= ' || x_resultout;

391:
392: END IF;
393:
394:
395: x_progress := 'PO_REQAPPROVAL_ACTION.State_Check_approve: 02. RESULT= ' || x_resultout;
396: IF (g_po_wf_debug = 'Y') THEN
397: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
398: END IF;
399:

Line 407: WF_CORE.context('PO_REQAPPROVAL_ACTION' , 'state_check_approve', itemtype, itemkey, x_progress);

403: raise;
404: WHEN OTHERS THEN
405: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
406: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
407: WF_CORE.context('PO_REQAPPROVAL_ACTION' , 'state_check_approve', itemtype, itemkey, x_progress);
408: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.STATE_CHECK_APPROVE');
409: RAISE;
410:
411:

Line 408: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.STATE_CHECK_APPROVE');

404: WHEN OTHERS THEN
405: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
406: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
407: WF_CORE.context('PO_REQAPPROVAL_ACTION' , 'state_check_approve', itemtype, itemkey, x_progress);
408: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.STATE_CHECK_APPROVE');
409: RAISE;
410:
411:
412: END State_Check_approve;

Line 435: x_progress := 'PO_REQAPPROVAL_ACTION.State_Check_reject: 01';

431: doc_manager_exception exception;
432:
433: BEGIN
434:
435: x_progress := 'PO_REQAPPROVAL_ACTION.State_Check_reject: 01';
436: IF (g_po_wf_debug = 'Y') THEN
437: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
438: END IF;
439:

Line 475: x_progress := 'PO_REQAPPROVAL_ACTION.State_Check_reject: 02. RESULT= ' || x_resultout;

471:
472: END IF;
473:
474:
475: x_progress := 'PO_REQAPPROVAL_ACTION.State_Check_reject: 02. RESULT= ' || x_resultout;
476: IF (g_po_wf_debug = 'Y') THEN
477: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
478: END IF;
479:

Line 488: WF_CORE.context('PO_REQAPPROVAL_ACTION', 'State_Check_reject', itemtype, itemkey, x_progress);

484: raise;
485: WHEN OTHERS THEN
486: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
487: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
488: WF_CORE.context('PO_REQAPPROVAL_ACTION', 'State_Check_reject', itemtype, itemkey, x_progress);
489: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.STATE_CHECK_REJECT');
490: RAISE;
491:
492: END State_Check_reject;

Line 489: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.STATE_CHECK_REJECT');

485: WHEN OTHERS THEN
486: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
487: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
488: WF_CORE.context('PO_REQAPPROVAL_ACTION', 'State_Check_reject', itemtype, itemkey, x_progress);
489: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.STATE_CHECK_REJECT');
490: RAISE;
491:
492: END State_Check_reject;
493:

Line 520: x_progress := 'PO_REQAPPROVAL_ACTION.Doc_complete_check: 01';

516: l_sub_check_status varchar2(1);
517:
518: BEGIN
519:
520: x_progress := 'PO_REQAPPROVAL_ACTION.Doc_complete_check: 01';
521: IF (g_po_wf_debug = 'Y') THEN
522: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
523: END IF;
524:

Line 611: x_progress := 'PO_REQAPPROVAL_ACTION.Doc_complete_check: 02. RESULT= ' || x_resultout;

607: raise FND_API.G_EXC_UNEXPECTED_ERROR;
608: END IF;
609: --
610:
611: x_progress := 'PO_REQAPPROVAL_ACTION.Doc_complete_check: 02. RESULT= ' || x_resultout;
612: IF (g_po_wf_debug = 'Y') THEN
613: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
614: END IF;
615:

Line 624: WF_CORE.context('PO_REQAPPROVAL_ACTION', 'Doc_complete_check', itemtype, itemkey, x_progress);

620: raise;
621: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
622: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
623: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
624: WF_CORE.context('PO_REQAPPROVAL_ACTION', 'Doc_complete_check', itemtype, itemkey, x_progress);
625: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.DOC_COMPLETE_CHECK');
626: RAISE;
627:
628: WHEN OTHERS THEN

Line 625: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.DOC_COMPLETE_CHECK');

621: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
622: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
623: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
624: WF_CORE.context('PO_REQAPPROVAL_ACTION', 'Doc_complete_check', itemtype, itemkey, x_progress);
625: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.DOC_COMPLETE_CHECK');
626: RAISE;
627:
628: WHEN OTHERS THEN
629: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

Line 631: WF_CORE.context('PO_REQAPPROVAL_ACTION', 'Doc_complete_check', itemtype, itemkey, x_progress);

627:
628: WHEN OTHERS THEN
629: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
630: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
631: WF_CORE.context('PO_REQAPPROVAL_ACTION', 'Doc_complete_check', itemtype, itemkey, x_progress);
632: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.DOC_COMPLETE_CHECK');
633: RAISE;
634:
635: END Doc_complete_check;

Line 632: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.DOC_COMPLETE_CHECK');

628: WHEN OTHERS THEN
629: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
630: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
631: WF_CORE.context('PO_REQAPPROVAL_ACTION', 'Doc_complete_check', itemtype, itemkey, x_progress);
632: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.DOC_COMPLETE_CHECK');
633: RAISE;
634:
635: END Doc_complete_check;
636:

Line 664: x_progress := 'PO_REQAPPROVAL_ACTION.Approve_doc: 01';

660: l_document_id NUMBER;
661:
662: BEGIN
663:
664: x_progress := 'PO_REQAPPROVAL_ACTION.Approve_doc: 01';
665: IF (g_po_wf_debug = 'Y') THEN
666: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
667: END IF;
668:

Line 732: x_progress := 'PO_REQAPPROVAL_ACTION.Approve_doc: 02. RESULT= ' || x_resultout;

728: raise doc_manager_exception;
729:
730: END IF;
731:
732: x_progress := 'PO_REQAPPROVAL_ACTION.Approve_doc: 02. RESULT= ' || x_resultout;
733: IF (g_po_wf_debug = 'Y') THEN
734: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
735: END IF;
736:

Line 745: WF_CORE.context('PO_REQAPPROVAL_ACTION' , 'Approve_doc', itemtype, itemkey, x_progress);

741: raise;
742: WHEN OTHERS THEN
743: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
744: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
745: WF_CORE.context('PO_REQAPPROVAL_ACTION' , 'Approve_doc', itemtype, itemkey, x_progress);
746: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.APPROVE_DOC');
747: RAISE;
748:
749:

Line 746: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.APPROVE_DOC');

742: WHEN OTHERS THEN
743: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
744: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
745: WF_CORE.context('PO_REQAPPROVAL_ACTION' , 'Approve_doc', itemtype, itemkey, x_progress);
746: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.APPROVE_DOC');
747: RAISE;
748:
749:
750: END Approve_doc;

Line 777: x_progress := 'PO_REQAPPROVAL_ACTION.Approve_and_forward_doc: 01';

773:
774:
775: BEGIN
776:
777: x_progress := 'PO_REQAPPROVAL_ACTION.Approve_and_forward_doc: 01';
778: IF (g_po_wf_debug = 'Y') THEN
779: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
780: END IF;
781:

Line 842: x_progress := 'PO_REQAPPROVAL_ACTION.Approve_and_forward_doc: 02. RESULT= ' || x_resultout;

838:
839:
840: END IF;
841:
842: x_progress := 'PO_REQAPPROVAL_ACTION.Approve_and_forward_doc: 02. RESULT= ' || x_resultout;
843: IF (g_po_wf_debug = 'Y') THEN
844: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
845: END IF;
846:

Line 854: WF_CORE.context('PO_REQAPPROVAL_ACTION', 'Approve_and_forward_doc', itemtype, itemkey,x_progress);

850: raise;
851: WHEN OTHERS THEN
852: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
853: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
854: WF_CORE.context('PO_REQAPPROVAL_ACTION', 'Approve_and_forward_doc', itemtype, itemkey,x_progress);
855: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.APPROVE_AND_FORWARD_DOC');
856: RAISE;
857:
858: END Approve_and_forward_doc;

Line 855: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.APPROVE_AND_FORWARD_DOC');

851: WHEN OTHERS THEN
852: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
853: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
854: WF_CORE.context('PO_REQAPPROVAL_ACTION', 'Approve_and_forward_doc', itemtype, itemkey,x_progress);
855: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.APPROVE_AND_FORWARD_DOC');
856: RAISE;
857:
858: END Approve_and_forward_doc;
859:

Line 889: x_progress := 'PO_REQAPPROVAL_ACTION.Forward_doc_inprocess: 01';

885: doc_manager_exception exception;
886:
887: BEGIN
888:
889: x_progress := 'PO_REQAPPROVAL_ACTION.Forward_doc_inprocess: 01';
890: IF (g_po_wf_debug = 'Y') THEN
891: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
892: END IF;
893:

Line 956: x_progress := 'PO_REQAPPROVAL_ACTION.Forward_doc_inprocess: 02. RESULT= ' || x_resultout;

952: raise doc_manager_exception;
953:
954: END IF;
955:
956: x_progress := 'PO_REQAPPROVAL_ACTION.Forward_doc_inprocess: 02. RESULT= ' || x_resultout;
957: IF (g_po_wf_debug = 'Y') THEN
958: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
959: END IF;
960:

Line 967: WF_CORE.context('PO_REQAPPROVAL_ACTION' , 'Forward_doc_inprocess', itemtype, itemkey,x_progress);

963: raise;
964: WHEN OTHERS THEN
965: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
966: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
967: WF_CORE.context('PO_REQAPPROVAL_ACTION' , 'Forward_doc_inprocess', itemtype, itemkey,x_progress);
968: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.FORWARD_DOC_INPROCESS');
969: RAISE;
970:
971: END Forward_doc_inprocess;

Line 968: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.FORWARD_DOC_INPROCESS');

964: WHEN OTHERS THEN
965: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
966: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
967: WF_CORE.context('PO_REQAPPROVAL_ACTION' , 'Forward_doc_inprocess', itemtype, itemkey,x_progress);
968: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.FORWARD_DOC_INPROCESS');
969: RAISE;
970:
971: END Forward_doc_inprocess;
972:

Line 1000: x_progress := 'PO_REQAPPROVAL_ACTION.Forward_doc_preapproved: 01';

996:
997:
998: BEGIN
999:
1000: x_progress := 'PO_REQAPPROVAL_ACTION.Forward_doc_preapproved: 01';
1001: IF (g_po_wf_debug = 'Y') THEN
1002: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1003: END IF;
1004:

Line 1064: x_progress := 'PO_REQAPPROVAL_ACTION.Forward_doc_preapproved: 02. RESULT= ' || x_resultout;

1060: raise doc_manager_exception;
1061:
1062: END IF;
1063:
1064: x_progress := 'PO_REQAPPROVAL_ACTION.Forward_doc_preapproved: 02. RESULT= ' || x_resultout;
1065: IF (g_po_wf_debug = 'Y') THEN
1066: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1067: END IF;
1068:

Line 1075: WF_CORE.context('PO_REQAPPROVAL_ACTION' , 'Forward_doc_preapproved', itemtype, itemkey,x_progress);

1071: raise;
1072: WHEN OTHERS THEN
1073: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1074: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1075: WF_CORE.context('PO_REQAPPROVAL_ACTION' , 'Forward_doc_preapproved', itemtype, itemkey,x_progress);
1076: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.FORWARD_DOC_PREAPPROVED');
1077: RAISE;
1078:
1079:

Line 1076: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.FORWARD_DOC_PREAPPROVED');

1072: WHEN OTHERS THEN
1073: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1074: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1075: WF_CORE.context('PO_REQAPPROVAL_ACTION' , 'Forward_doc_preapproved', itemtype, itemkey,x_progress);
1076: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.FORWARD_DOC_PREAPPROVED');
1077: RAISE;
1078:
1079:
1080: END Forward_doc_preapproved;

Line 1100: x_progress := 'PO_REQAPPROVAL_ACTION.Reject_Doc: 01';

1096: doc_manager_exception exception;
1097:
1098: BEGIN
1099:
1100: x_progress := 'PO_REQAPPROVAL_ACTION.Reject_Doc: 01';
1101: IF (g_po_wf_debug = 'Y') THEN
1102: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1103: END IF;
1104:

Line 1127: x_progress := 'PO_REQAPPROVAL_ACTION.Reject_Doc: 02. RESULT= ' || l_doc_mgr_return_val;

1123:
1124: END IF;
1125: resultout := wf_engine.eng_completed || ':' || l_doc_mgr_return_val;
1126:
1127: x_progress := 'PO_REQAPPROVAL_ACTION.Reject_Doc: 02. RESULT= ' || l_doc_mgr_return_val;
1128: IF (g_po_wf_debug = 'Y') THEN
1129: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1130: END IF;
1131:

Line 1139: WF_CORE.context('PO_REQAPPROVAL_ACTION' , 'Reject_doc', itemtype, itemkey,x_progress);

1135: raise;
1136: WHEN OTHERS THEN
1137: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1138: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1139: WF_CORE.context('PO_REQAPPROVAL_ACTION' , 'Reject_doc', itemtype, itemkey,x_progress);
1140: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.REJECT_DOC');
1141: RAISE;
1142:
1143:

Line 1140: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.REJECT_DOC');

1136: WHEN OTHERS THEN
1137: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1138: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1139: WF_CORE.context('PO_REQAPPROVAL_ACTION' , 'Reject_doc', itemtype, itemkey,x_progress);
1140: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.REJECT_DOC');
1141: RAISE;
1142:
1143:
1144: END Reject_Doc;

Line 1167: x_progress := 'PO_REQAPPROVAL_ACTION.Verify_authority: 01';

1163: doc_manager_exception exception;
1164:
1165: BEGIN
1166:
1167: x_progress := 'PO_REQAPPROVAL_ACTION.Verify_authority: 01';
1168: IF (g_po_wf_debug = 'Y') THEN
1169: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1170: END IF;
1171:

Line 1199: x_progress := 'PO_REQAPPROVAL_ACTION.Verify_authority: 02. RESULT= ' || x_resultout;

1195: resultout := wf_engine.eng_completed || ':' || l_doc_mgr_return_val;
1196: x_resultout := l_doc_mgr_return_val;
1197:
1198:
1199: x_progress := 'PO_REQAPPROVAL_ACTION.Verify_authority: 02. RESULT= ' || x_resultout;
1200: IF (g_po_wf_debug = 'Y') THEN
1201: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1202: END IF;
1203:

Line 1210: WF_CORE.context('PO_REQAPPROVAL_ACTION' , 'Verify_authority', itemtype, itemkey, x_progress);

1206: raise;
1207: WHEN OTHERS THEN
1208: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1209: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1210: WF_CORE.context('PO_REQAPPROVAL_ACTION' , 'Verify_authority', itemtype, itemkey, x_progress);
1211: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.VERIFY_AUTHORITY');
1212: RAISE;
1213:
1214:

Line 1211: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.VERIFY_AUTHORITY');

1207: WHEN OTHERS THEN
1208: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1209: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1210: WF_CORE.context('PO_REQAPPROVAL_ACTION' , 'Verify_authority', itemtype, itemkey, x_progress);
1211: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.VERIFY_AUTHORITY');
1212: RAISE;
1213:
1214:
1215: END Verify_authority;

Line 1238: x_progress := 'PO_REQAPPROVAL_ACTION.Open_Doc_State: 01';

1234: doc_manager_exception exception;
1235:
1236: BEGIN
1237:
1238: x_progress := 'PO_REQAPPROVAL_ACTION.Open_Doc_State: 01';
1239: IF (g_po_wf_debug = 'Y') THEN
1240: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1241: END IF;
1242:

Line 1271: x_progress := 'PO_REQAPPROVAL_ACTION.Open_Doc_State 02. RESULT= ' || x_resultout;

1267: raise doc_manager_exception;
1268:
1269: END IF;
1270:
1271: x_progress := 'PO_REQAPPROVAL_ACTION.Open_Doc_State 02. RESULT= ' || x_resultout;
1272: IF (g_po_wf_debug = 'Y') THEN
1273: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1274: END IF;
1275:

Line 1283: WF_CORE.context('PO_REQAPPROVAL_ACTION', 'Open_Doc_State', itemtype, itemkey, x_progress);

1279: raise;
1280: WHEN OTHERS THEN
1281: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1282: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1283: WF_CORE.context('PO_REQAPPROVAL_ACTION', 'Open_Doc_State', itemtype, itemkey, x_progress);
1284: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.OPEN_DOC_STATE');
1285: RAISE;
1286:
1287: END Open_Doc_State;

Line 1284: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.OPEN_DOC_STATE');

1280: WHEN OTHERS THEN
1281: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1282: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1283: WF_CORE.context('PO_REQAPPROVAL_ACTION', 'Open_Doc_State', itemtype, itemkey, x_progress);
1284: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.OPEN_DOC_STATE');
1285: RAISE;
1286:
1287: END Open_Doc_State;
1288:

Line 1314: x_progress := 'PO_REQAPPROVAL_ACTION.Reserve_Doc: 01';

1310: l_org_id number; -- Bug 3426272
1311:
1312: BEGIN
1313:
1314: x_progress := 'PO_REQAPPROVAL_ACTION.Reserve_Doc: 01';
1315: IF (g_po_wf_debug = 'Y') THEN
1316: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1317: END IF;
1318:

Line 1396: x_progress := 'PO_REQAPPROVAL_ACTION.Reserve_Doc 02. RESULT= ' || x_resultout;

1392:
1393: resultout := wf_engine.eng_completed || ':' || l_doc_mgr_return_val;
1394: x_resultout := l_doc_mgr_return_val;
1395:
1396: x_progress := 'PO_REQAPPROVAL_ACTION.Reserve_Doc 02. RESULT= ' || x_resultout;
1397: IF (g_po_wf_debug = 'Y') THEN
1398: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1399: END IF;
1400:

Line 1409: WF_CORE.context('PO_REQAPPROVAL_ACTION', 'Reserve_Doc', itemtype, itemkey,

1405: WHEN OTHERS THEN
1406: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1407: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
1408: itemType, itemkey);
1409: WF_CORE.context('PO_REQAPPROVAL_ACTION', 'Reserve_Doc', itemtype, itemkey,
1410: x_progress);
1411: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,
1412: l_preparer_user_name, l_doc_string, sqlerrm,
1413: 'PO_REQAPPROVAL_ACTION.RESERVE_DOC');

Line 1413: 'PO_REQAPPROVAL_ACTION.RESERVE_DOC');

1409: WF_CORE.context('PO_REQAPPROVAL_ACTION', 'Reserve_Doc', itemtype, itemkey,
1410: x_progress);
1411: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,
1412: l_preparer_user_name, l_doc_string, sqlerrm,
1413: 'PO_REQAPPROVAL_ACTION.RESERVE_DOC');
1414: RAISE;
1415: END Reserve_Doc;
1416: --
1417:

Line 1485: x_progress := 'PO_REQAPPROVAL_ACTION.StateCheckApprove: Returned_code= ' || l_ret_code;

1481: return('Y');
1482:
1483: ELSE
1484:
1485: x_progress := 'PO_REQAPPROVAL_ACTION.StateCheckApprove: Returned_code= ' || l_ret_code;
1486: IF (g_po_wf_debug = 'Y') THEN
1487: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1488: END IF;
1489:

Line 1496: x_progress := 'PO_REQAPPROVAL_ACTION.StateCheckApprove: action call returned with: ' || l_ret_sts;

1492: END IF; -- l_ret_code IS NULL
1493:
1494: ELSE
1495:
1496: x_progress := 'PO_REQAPPROVAL_ACTION.StateCheckApprove: action call returned with: ' || l_ret_sts;
1497: IF (g_po_wf_debug = 'Y') THEN
1498: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1499: END IF;
1500:

Line 1513: wf_core.context('PO_REQAPPROVAL_ACTION','StateCheckApprove',x_progress);

1509:
1510: EXCEPTION
1511:
1512: WHEN OTHERS THEN
1513: wf_core.context('PO_REQAPPROVAL_ACTION','StateCheckApprove',x_progress);
1514: raise;
1515:
1516: END StateCheckApprove;
1517:

Line 1582: x_progress := 'PO_REQAPPROVAL_ACTION.StateCheckReject: Returned_code= ' || l_ret_code;

1578: return('Y');
1579:
1580: ELSE
1581:
1582: x_progress := 'PO_REQAPPROVAL_ACTION.StateCheckReject: Returned_code= ' || l_ret_code;
1583: IF (g_po_wf_debug = 'Y') THEN
1584: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1585: END IF;
1586:

Line 1593: x_progress := 'PO_REQAPPROVAL_ACTION.StateCheckReject: action call returned with: ' || l_ret_sts;

1589: END IF; -- l_ret_code IS NULL
1590:
1591: ELSE
1592:
1593: x_progress := 'PO_REQAPPROVAL_ACTION.StateCheckReject: action call returned with: ' || l_ret_sts;
1594: IF (g_po_wf_debug = 'Y') THEN
1595: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1596: END IF;
1597:

Line 1610: wf_core.context('PO_REQAPPROVAL_ACTION','StateCheckReject',x_progress);

1606:
1607: EXCEPTION
1608:
1609: WHEN OTHERS THEN
1610: wf_core.context('PO_REQAPPROVAL_ACTION','StateCheckReject',x_progress);
1611: raise;
1612:
1613: END StateCheckReject;
1614:

Line 1715: x_progress := 'PO_REQAPPROVAL_ACTION.DocCompleteCheck: x_sub_check_status= ' ||

1711: IF x_sub_check_status = FND_API.G_RET_STS_SUCCESS THEN
1712: return(FND_API.G_RET_STS_SUCCESS);
1713: ELSE
1714:
1715: x_progress := 'PO_REQAPPROVAL_ACTION.DocCompleteCheck: x_sub_check_status= ' ||
1716: x_sub_check_status || ' On_Line_Report_id= ' ||
1717: to_char(x_online_report_id);
1718:
1719:

Line 1748: x_progress := 'PO_REQAPPROVAL_ACTION.DocCompleteCheck: Only Warnings found. Return success';

1744: WHEN NO_DATA_FOUND THEN
1745: l_error:='W';
1746: END;
1747: IF (l_error = 'W') then
1748: x_progress := 'PO_REQAPPROVAL_ACTION.DocCompleteCheck: Only Warnings found. Return success';
1749:
1750: IF (g_po_wf_debug = 'Y') THEN
1751: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1752: END IF;

Line 1776: x_progress := 'PO_REQAPPROVAL_ACTION.DocCompleteCheck: po_submission_check returned with: ' ||

1772: /* something went wrong with Submission Check API call. Send notification to Sys Admin.
1773: ** The error message is kept in Item Attribute SYSADMIN_ERROR_MSG */
1774:
1775:
1776: x_progress := 'PO_REQAPPROVAL_ACTION.DocCompleteCheck: po_submission_check returned with: ' ||
1777: x_return_status ;
1778:
1779: IF (g_po_wf_debug = 'Y') THEN
1780: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

Line 1785: x_progress := 'PO_REQAPPROVAL_ACTION.DocCompleteCheck: po_submission_check error msg is: ' ||

1781: END IF;
1782:
1783: sysadmin_err_msg := x_msg_data;
1784:
1785: x_progress := 'PO_REQAPPROVAL_ACTION.DocCompleteCheck: po_submission_check error msg is: ' ||
1786: x_msg_data;
1787:
1788: IF (g_po_wf_debug = 'Y') THEN
1789: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

Line 1800: wf_core.context('PO_REQAPPROVAL_ACTION','DocCompleteCheck',x_progress);

1796:
1797: EXCEPTION
1798:
1799: WHEN OTHERS THEN
1800: wf_core.context('PO_REQAPPROVAL_ACTION','DocCompleteCheck',x_progress);
1801: raise;
1802:
1803: END DocCompleteCheck;
1804:

Line 1826: x_progress := 'PO_REQAPPROVAL_ACTION.InsertHistForOwnerApprove begin';

1822: x_progress varchar2(200);
1823:
1824: BEGIN
1825:
1826: x_progress := 'PO_REQAPPROVAL_ACTION.InsertHistForOwnerApprove begin';
1827:
1828: IF (g_po_wf_debug = 'Y') THEN
1829: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1830: END IF;

Line 1849: x_progress := 'PO_REQAPPROVAL_ACTION.InsertHistForOwnerApprove action_code: ' || l_action_code;

1845: from po_action_history
1846: where object_id = p_document_id
1847: and object_type_code = p_document_type);
1848:
1849: x_progress := 'PO_REQAPPROVAL_ACTION.InsertHistForOwnerApprove action_code: ' || l_action_code;
1850:
1851: IF (g_po_wf_debug = 'Y') THEN
1852: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, x_progress);
1853: END IF;

Line 1871: x_progress := 'PO_REQAPPROVAL_ACTION.InsertHistForOwnerApprove employee_id: ' || l_employee_id;

1867: where object_id = p_document_id
1868: and action_code = 'SUBMIT'
1869: and object_type_code = p_document_type);
1870:
1871: x_progress := 'PO_REQAPPROVAL_ACTION.InsertHistForOwnerApprove employee_id: ' || l_employee_id;
1872:
1873: IF (g_po_wf_debug = 'Y') THEN
1874: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, x_progress);
1875: END IF;

Line 1922: x_progress := 'PO_REQAPPROVAL_ACTION.InsertHistForOwnerApprove inserted';

1918: '' );
1919:
1920: commit;
1921:
1922: x_progress := 'PO_REQAPPROVAL_ACTION.InsertHistForOwnerApprove inserted';
1923:
1924: END IF;
1925:
1926: x_progress := 'PO_REQAPPROVAL_ACTION.InsertHistForOwnerApprove end';

Line 1926: x_progress := 'PO_REQAPPROVAL_ACTION.InsertHistForOwnerApprove end';

1922: x_progress := 'PO_REQAPPROVAL_ACTION.InsertHistForOwnerApprove inserted';
1923:
1924: END IF;
1925:
1926: x_progress := 'PO_REQAPPROVAL_ACTION.InsertHistForOwnerApprove end';
1927:
1928: IF (g_po_wf_debug = 'Y') THEN
1929: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1930: END IF;

Line 1935: wf_core.context('PO_REQAPPROVAL_ACTION','ApproveDoc',x_progress || ', ' || sqlerrm);

1931:
1932: EXCEPTION
1933:
1934: WHEN OTHERS THEN
1935: wf_core.context('PO_REQAPPROVAL_ACTION','ApproveDoc',x_progress || ', ' || sqlerrm);
1936: raise;
1937:
1938: END InsertHistForOwnerApprove;
1939:

Line 2034: x_progress := 'PO_REQAPPROVAL_ACTION.ApproveDoc: ApproveAutonomous returned with: '

2030: return('Y');
2031:
2032: ELSE
2033:
2034: x_progress := 'PO_REQAPPROVAL_ACTION.ApproveDoc: ApproveAutonomous returned with: '
2035: || l_ret_sts;
2036:
2037: IF (g_po_wf_debug = 'Y') THEN
2038: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

Line 2053: wf_core.context('PO_REQAPPROVAL_ACTION','ApproveDoc',x_progress);

2049:
2050: EXCEPTION
2051:
2052: WHEN OTHERS THEN
2053: wf_core.context('PO_REQAPPROVAL_ACTION','ApproveDoc',x_progress);
2054: raise;
2055:
2056: END ApproveDoc;
2057:

Line 2146: x_progress := 'PO_REQAPPROVAL_ACTION.ApproveAndForward: ForwardAutonomous returned with: ' || l_ret_sts;

2142: ELSE
2143:
2144: -- fatal exception, l_ret_sts = 'U'
2145:
2146: x_progress := 'PO_REQAPPROVAL_ACTION.ApproveAndForward: ForwardAutonomous returned with: ' || l_ret_sts;
2147: IF (g_po_wf_debug = 'Y') THEN
2148: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2149: END IF;
2150:

Line 2163: wf_core.context('PO_REQAPPROVAL_ACTION','ApproveAndForward',x_progress);

2159:
2160: EXCEPTION
2161:
2162: WHEN OTHERS THEN
2163: wf_core.context('PO_REQAPPROVAL_ACTION','ApproveAndForward',x_progress);
2164: raise;
2165:
2166: END ApproveAndForward;
2167:

Line 2256: x_progress := 'PO_REQAPPROVAL_ACTION.ForwardDocInProcess: ForwardAutonomous returned with: ' || l_ret_sts;

2252: ELSE
2253:
2254: -- fatal exception, l_ret_sts = 'U'
2255:
2256: x_progress := 'PO_REQAPPROVAL_ACTION.ForwardDocInProcess: ForwardAutonomous returned with: ' || l_ret_sts;
2257: IF (g_po_wf_debug = 'Y') THEN
2258: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2259: END IF;
2260:

Line 2273: wf_core.context('PO_REQAPPROVAL_ACTION','ForwardDocInProcess',x_progress);

2269:
2270: EXCEPTION
2271:
2272: WHEN OTHERS THEN
2273: wf_core.context('PO_REQAPPROVAL_ACTION','ForwardDocInProcess',x_progress);
2274: raise;
2275:
2276: END ForwardDocInProcess;
2277:

Line 2367: x_progress := 'PO_REQAPPROVAL_ACTION.ForwardDocPreApproved: ForwardAutonomous returned with: ' || l_ret_sts;

2363: ELSE
2364:
2365: -- fatal exception, l_ret_sts = 'U'
2366:
2367: x_progress := 'PO_REQAPPROVAL_ACTION.ForwardDocPreApproved: ForwardAutonomous returned with: ' || l_ret_sts;
2368: IF (g_po_wf_debug = 'Y') THEN
2369: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2370: END IF;
2371:

Line 2384: wf_core.context('PO_REQAPPROVAL_ACTION','ForwardDocPreApproved',x_progress);

2380:
2381: EXCEPTION
2382:
2383: WHEN OTHERS THEN
2384: wf_core.context('PO_REQAPPROVAL_ACTION','ForwardDocPreApproved',x_progress);
2385: raise;
2386:
2387:
2388: END ForwardDocPreApproved;

Line 2503: x_progress := 'PO_REQAPPROVAL_ACTION.RejectDoc: Returned_code= ' ||

2499: ELSE
2500:
2501: -- Reject Failed
2502:
2503: x_progress := 'PO_REQAPPROVAL_ACTION.RejectDoc: Returned_code= ' ||
2504: l_ret_code ;
2505: IF (g_po_wf_debug = 'Y') THEN
2506: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2507: END IF;

Line 2517: x_progress := 'PO_REQAPPROVAL_ACTION.RejectDoc: RejectAutonomous returned with: ' || l_ret_sts;

2513: ELSE
2514:
2515: -- Fatal Error: l_ret_sts := 'U';
2516:
2517: x_progress := 'PO_REQAPPROVAL_ACTION.RejectDoc: RejectAutonomous returned with: ' || l_ret_sts;
2518:
2519: IF (g_po_wf_debug = 'Y') THEN
2520: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2521: END IF;

Line 2536: wf_core.context('PO_REQAPPROVAL_ACTION','RejectDoc',x_progress);

2532:
2533: EXCEPTION
2534:
2535: WHEN OTHERS THEN
2536: wf_core.context('PO_REQAPPROVAL_ACTION','RejectDoc',x_progress);
2537: raise;
2538:
2539: END RejectDoc;
2540:

Line 2617: x_progress := 'PO_REQAPPROVAL_ACTION.VerifyAuthority: action call returned with: ' || l_ret_sts;

2613: ELSE
2614:
2615: -- fatal exceptionl; l_ret_sts := 'U';
2616:
2617: x_progress := 'PO_REQAPPROVAL_ACTION.VerifyAuthority: action call returned with: ' || l_ret_sts;
2618: IF (g_po_wf_debug = 'Y') THEN
2619: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2620: END IF;
2621:

Line 2634: wf_core.context('PO_REQAPPROVAL_ACTION','VerifyAuthority',x_progress);

2630:
2631: EXCEPTION
2632:
2633: WHEN OTHERS THEN
2634: wf_core.context('PO_REQAPPROVAL_ACTION','VerifyAuthority',x_progress);
2635: raise;
2636:
2637: END VerifyAuthority;
2638:

Line 2698: x_progress := 'PO_REQAPPROVAL_ACTION.OpenDocumentState: Returned_code= ' ||

2694: return('Y');
2695:
2696: ELSE
2697:
2698: x_progress := 'PO_REQAPPROVAL_ACTION.OpenDocumentState: Returned_code= ' ||
2699: l_ret_code ;
2700: IF (g_po_wf_debug = 'Y') THEN
2701: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2702: END IF;

Line 2715: x_progress := 'PO_REQAPPROVAL_ACTION.OpenDocumentState: auto_close_update_autonomous returned with: ' ||

2711:
2712: /* something went wrong with Doc Action. Send notification to Sys Admin.
2713: ** The error message is kept in Item Attribute SYSADMIN_ERROR_MSG */
2714:
2715: x_progress := 'PO_REQAPPROVAL_ACTION.OpenDocumentState: auto_close_update_autonomous returned with: ' ||
2716: l_ret_sts;
2717: IF (g_po_wf_debug = 'Y') THEN
2718: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2719: END IF;

Line 2731: wf_core.context('PO_REQAPPROVAL_ACTION','OpenDocumentState',x_progress);

2727:
2728: EXCEPTION
2729:
2730: WHEN OTHERS THEN
2731: wf_core.context('PO_REQAPPROVAL_ACTION','OpenDocumentState',x_progress);
2732: raise;
2733:
2734: END OpenDocumentState;
2735:

Line 2913: wf_core.context('PO_REQAPPROVAL_ACTION','ReserveDoc',x_progress);

2909:
2910: EXCEPTION
2911:
2912: WHEN OTHERS THEN
2913: wf_core.context('PO_REQAPPROVAL_ACTION','ReserveDoc',x_progress);
2914: raise;
2915:
2916: END ReserveDoc;
2917:

Line 2931: x_progress := 'PO_REQAPPROVAL_ACTION.get_online_report_text.010.ON_LINE_REPORT_ID= '

2927: BEGIN
2928:
2929: -- Bug 3536831: get_online_report_text is refactored to call new set_report_text_attr.
2930:
2931: x_progress := 'PO_REQAPPROVAL_ACTION.get_online_report_text.010.ON_LINE_REPORT_ID= '
2932: || to_char(p_online_report_id);
2933:
2934:
2935: set_report_text_attr( itemtype => itemtype

Line 2941: x_progress := 'PO_REQAPPROVAL_ACTION.get_online_report_text.020.ON_LINE_REPORT_ID= '

2937: , p_online_report_id => p_online_report_id
2938: , p_attribute => 'ONLINE_REPORT_TEXT'
2939: );
2940:
2941: x_progress := 'PO_REQAPPROVAL_ACTION.get_online_report_text.020.ON_LINE_REPORT_ID= '
2942: || to_char(p_online_report_id);
2943:
2944: EXCEPTION
2945: WHEN OTHERS THEN

Line 2946: wf_core.context('PO_REQAPPROVAL_ACTION','get_online_report_text',x_progress);

2942: || to_char(p_online_report_id);
2943:
2944: EXCEPTION
2945: WHEN OTHERS THEN
2946: wf_core.context('PO_REQAPPROVAL_ACTION','get_online_report_text',x_progress);
2947: raise;
2948: END get_online_report_text;
2949:
2950:

Line 2985: x_progress := 'PO_REQAPPROVAL_ACTION.get_advisory_warning.010.ON_LINE_REPORT_ID= '

2981: x_progress varchar2(400);
2982:
2983: BEGIN
2984:
2985: x_progress := 'PO_REQAPPROVAL_ACTION.get_advisory_warning.010.ON_LINE_REPORT_ID= '
2986: || to_char(p_online_report_id);
2987:
2988:
2989: set_report_text_attr( itemtype => itemtype

Line 3004: x_progress := 'PO_REQAPPROVAL_ACTION.get_advisory_warning.020.ON_LINE_REPORT_ID= '

3000: aname => 'ADVISORY_WARNING_CHECK',
3001: avalue => 'Y'
3002: );
3003:
3004: x_progress := 'PO_REQAPPROVAL_ACTION.get_advisory_warning.020.ON_LINE_REPORT_ID= '
3005: || to_char(p_online_report_id);
3006:
3007: EXCEPTION
3008: WHEN OTHERS THEN

Line 3009: wf_core.context('PO_REQAPPROVAL_ACTION','get_advisory_warning',x_progress);

3005: || to_char(p_online_report_id);
3006:
3007: EXCEPTION
3008: WHEN OTHERS THEN
3009: wf_core.context('PO_REQAPPROVAL_ACTION','get_advisory_warning',x_progress);
3010: raise;
3011: END get_advisory_warning;
3012:
3013:

Line 3061: x_progress := 'PO_REQAPPROVAL_ACTION.set_report_attr_text.010.ON_LINE_REPORT_ID= '

3057:
3058: BEGIN
3059:
3060:
3061: x_progress := 'PO_REQAPPROVAL_ACTION.set_report_attr_text.010.ON_LINE_REPORT_ID= '
3062: || to_char(p_online_report_id);
3063:
3064:
3065: -- Add header text to beginning of attribute string.

Line 3079: x_progress := 'PO_REQAPPROVAL_ACTION.set_report_attr_text.020.ON_LINE_REPORT_ID= '

3075: FROM po_online_report_text
3076: WHERE online_report_id = p_online_report_id
3077: ORDER BY sequence;
3078:
3079: x_progress := 'PO_REQAPPROVAL_ACTION.set_report_attr_text.020.ON_LINE_REPORT_ID= '
3080: || to_char(p_online_report_id);
3081:
3082: -- Loop through the plsql table, and concatenate each of the lines.
3083: -- Exit the loop if we run out of lines, or the string exceeds 2000 characters.

Line 3101: x_progress := 'PO_REQAPPROVAL_ACTION.set_report_attr_text.030.ON_LINE_REPORT_ID= '

3097: aname => p_attribute,
3098: avalue => substr(l_attribute_text, 1, 2000)
3099: );
3100:
3101: x_progress := 'PO_REQAPPROVAL_ACTION.set_report_attr_text.030.ON_LINE_REPORT_ID= '
3102: || to_char(p_online_report_id);
3103:
3104: IF (g_po_wf_debug = 'Y') THEN
3105: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

Line 3110: wf_core.context('PO_REQAPPROVAL_ACTION','set_report_attr_text',x_progress);

3106: END IF;
3107:
3108: EXCEPTION
3109: WHEN OTHERS THEN
3110: wf_core.context('PO_REQAPPROVAL_ACTION','set_report_attr_text',x_progress);
3111: raise;
3112: END set_report_text_attr;
3113:
3114: --

Line 3134: x_progress := 'PO_REQAPPROVAL_ACTION.set_doc_mgr_context. USER_ID= ' || to_char(l_user_id)

3130: -- po reqapproval init1 set doc mgr context
3131: --
3132: po_reqapproval_init1.set_doc_mgr_context(itemtype,itemkey);
3133:
3134: x_progress := 'PO_REQAPPROVAL_ACTION.set_doc_mgr_context. USER_ID= ' || to_char(l_user_id)
3135: || ' APPLICATION_ID= ' || to_char(l_application_id) ||
3136: 'RESPONSIBILITY_ID= ' || to_char(l_responsibility_id);
3137: IF (g_po_wf_debug = 'Y') THEN
3138: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

Line 3144: wf_core.context('PO_REQAPPROVAL_ACTION','set_doc_mgr_context',x_progress);

3140:
3141: EXCEPTION
3142:
3143: WHEN OTHERS THEN
3144: wf_core.context('PO_REQAPPROVAL_ACTION','set_doc_mgr_context',x_progress);
3145: raise;
3146:
3147:
3148: END set_doc_mgr_context;

Line 3223: x_progress := 'PO_REQAPPROVAL_ACTION.set_responder_doc_mgr_context. USER_ID= ' || to_char(l_user_id)

3219: END IF;
3220: -- Bug 4290541 End
3221: END IF;
3222:
3223: x_progress := 'PO_REQAPPROVAL_ACTION.set_responder_doc_mgr_context. USER_ID= ' || to_char(l_user_id)
3224: || ' APPLICATION_ID= ' || to_char(l_application_id) ||
3225: 'RESPONSIBILITY_ID= ' || to_char(l_responsibility_id);
3226: IF (g_po_wf_debug = 'Y') THEN
3227: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

Line 3233: wf_core.context('PO_REQAPPROVAL_ACTION','set_responder_doc_mgr_context',x_progress);

3229:
3230: EXCEPTION
3231:
3232: WHEN OTHERS THEN
3233: wf_core.context('PO_REQAPPROVAL_ACTION','set_responder_doc_mgr_context',x_progress);
3234: raise;
3235:
3236:
3237: END set_responder_doc_mgr_context;

Line 3264: x_progress := 'PO_REQAPPROVAL_ACTION.Reserve_doc_Override: 01';

3260: doc_manager_exception exception;
3261:
3262: BEGIN
3263:
3264: x_progress := 'PO_REQAPPROVAL_ACTION.Reserve_doc_Override: 01';
3265: IF (g_po_wf_debug = 'Y') THEN
3266: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
3267: END IF;
3268:

Line 3306: x_progress := 'PO_REQAPPROVAL_ACTION.Reserve_doc_Override 10. RESULT= ' || x_resultout;

3302: */
3303:
3304: l_doc_mgr_return_val := ReserveDoc(itemtype, itemkey, 'Y');
3305:
3306: x_progress := 'PO_REQAPPROVAL_ACTION.Reserve_doc_Override 10. RESULT= ' || x_resultout;
3307: IF (g_po_wf_debug = 'Y') THEN
3308: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
3309: END IF;
3310:

Line 3323: x_progress := 'PO_REQAPPROVAL_ACTION.Reserve_doc_Override 99';

3319:
3320: resultout := wf_engine.eng_completed || ':' || l_doc_mgr_return_val;
3321: x_resultout := l_doc_mgr_return_val;
3322:
3323: x_progress := 'PO_REQAPPROVAL_ACTION.Reserve_doc_Override 99';
3324: IF (g_po_wf_debug = 'Y') THEN
3325: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
3326: END IF;
3327:

Line 3335: WF_CORE.context('PO_REQAPPROVAL_ACTION', 'Reserve_doc_Override',

3331: WHEN OTHERS THEN
3332: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
3333: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
3334: itemType, itemkey);
3335: WF_CORE.context('PO_REQAPPROVAL_ACTION', 'Reserve_doc_Override',
3336: itemtype, itemkey, x_progress);
3337: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,
3338: l_preparer_user_name, l_doc_string, sqlerrm,
3339: 'PO_REQAPPROVAL_ACTION.RESERVE_DOC');

Line 3339: 'PO_REQAPPROVAL_ACTION.RESERVE_DOC');

3335: WF_CORE.context('PO_REQAPPROVAL_ACTION', 'Reserve_doc_Override',
3336: itemtype, itemkey, x_progress);
3337: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,
3338: l_preparer_user_name, l_doc_string, sqlerrm,
3339: 'PO_REQAPPROVAL_ACTION.RESERVE_DOC');
3340: RAISE;
3341: END Reserve_doc_Override;
3342:
3343: --

Line 3441: wf_core.context('PO_REQAPPROVAL_ACTION','ReserveAutonomous',

3437: EXCEPTION
3438: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3439: ROLLBACK TO ReserveAutonomous_SP;
3440: /* Bug 3293107: removed to_char() around l_progress */
3441: wf_core.context('PO_REQAPPROVAL_ACTION','ReserveAutonomous',
3442: l_progress);
3443: RAISE;
3444:
3445: WHEN OTHERS THEN

Line 3448: wf_core.context('PO_REQAPPROVAL_ACTION','ReserveAutonomous',

3444:
3445: WHEN OTHERS THEN
3446: ROLLBACK TO ReserveAutonomous_SP;
3447: /* Bug 3293107: removed to_char() around l_progress */
3448: wf_core.context('PO_REQAPPROVAL_ACTION','ReserveAutonomous',
3449: l_progress);
3450: RAISE;
3451:
3452: END ReserveAutonomous;

Line 3501: wf_core.context('PO_REQAPPROVAL_ACTION', 'ApproveAutonomous', to_char(d_progress));

3497:
3498: EXCEPTION
3499: WHEN others THEN
3500: ROLLBACK;
3501: wf_core.context('PO_REQAPPROVAL_ACTION', 'ApproveAutonomous', to_char(d_progress));
3502: x_return_status := 'U';
3503:
3504: END ApproveAutonomous;
3505:

Line 3553: wf_core.context('PO_REQAPPROVAL_ACTION', 'RejectAutonomous', to_char(d_progress));

3549:
3550: EXCEPTION
3551: WHEN others THEN
3552: ROLLBACK;
3553: wf_core.context('PO_REQAPPROVAL_ACTION', 'RejectAutonomous', to_char(d_progress));
3554: x_return_status := 'U';
3555: END RejectAutonomous;
3556:
3557:

Line 3605: wf_core.context('PO_REQAPPROVAL_ACTION', 'ForwardAutonomous', to_char(d_progress));

3601:
3602: EXCEPTION
3603: WHEN others THEN
3604: ROLLBACK;
3605: wf_core.context('PO_REQAPPROVAL_ACTION', 'ForwardAutonomous', to_char(d_progress));
3606: x_return_status := 'U';
3607:
3608: END ForwardAutonomous;
3609:

Line 3655: wf_core.context('PO_REQAPPROVAL_ACTION', 'AutoUpdateCloseAutonomous', to_char(d_progress));

3651:
3652: EXCEPTION
3653: WHEN others THEN
3654: ROLLBACK;
3655: wf_core.context('PO_REQAPPROVAL_ACTION', 'AutoUpdateCloseAutonomous', to_char(d_progress));
3656: x_return_status := 'U';
3657:
3658: END AutoUpdateCloseAutonomous;
3659: --

Line 3722: end PO_REQAPPROVAL_ACTION;

3718:
3719:
3720:
3721:
3722: end PO_REQAPPROVAL_ACTION;