DBA Data[Home] [Help]

APPS.PO_REQAPPROVAL_ACTION dependencies on PO_REQAPPROVAL_INIT1

Line 405: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

401: EXCEPTION
402: WHEN doc_manager_exception THEN
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;

Line 406: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

402: WHEN doc_manager_exception THEN
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:

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 486: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

482:
483: WHEN doc_manager_exception THEN
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;

Line 487: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

483: WHEN doc_manager_exception THEN
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:

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 622: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

618:
619: WHEN doc_manager_exception THEN
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;

Line 623: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

619: WHEN doc_manager_exception THEN
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:

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 629: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

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);
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;

Line 630: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

626: RAISE;
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:

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 743: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

739:
740: WHEN doc_manager_exception THEN
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;

Line 744: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

740: WHEN doc_manager_exception THEN
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:

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 852: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

848:
849: WHEN doc_manager_exception THEN
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;

Line 853: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

849: WHEN doc_manager_exception THEN
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:

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 965: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

961: EXCEPTION
962: WHEN doc_manager_exception THEN
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;

Line 966: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

962: WHEN doc_manager_exception THEN
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:

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 1073: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

1069: EXCEPTION
1070: WHEN doc_manager_exception THEN
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;

Line 1074: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

1070: WHEN doc_manager_exception THEN
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:

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 1137: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

1133:
1134: WHEN doc_manager_exception THEN
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;

Line 1138: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

1134: WHEN doc_manager_exception THEN
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:

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 1208: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

1204: EXCEPTION
1205: WHEN doc_manager_exception THEN
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;

Line 1209: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

1205: WHEN doc_manager_exception THEN
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:

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 1281: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

1277:
1278: WHEN doc_manager_exception THEN
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;

Line 1282: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

1278: WHEN doc_manager_exception THEN
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:

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 1406: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

1402: -- WHEN doc_manager_exception THEN
1403: -- raise;
1404:
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);

Line 1407: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(

1403: -- raise;
1404:
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,

Line 1411: PO_REQAPPROVAL_INIT1.send_error_notif(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');
1414: RAISE;
1415: END Reserve_Doc;

Line 3130: -- po reqapproval init1 set doc mgr context

3126:
3127: BEGIN
3128:
3129: -- Bug 4290541, replaced call to set apps init context with
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)

Line 3132: po_reqapproval_init1.set_doc_mgr_context(itemtype,itemkey);

3128:
3129: -- Bug 4290541, replaced call to set apps init context with
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);

Line 3332: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

3328: EXCEPTION
3329: -- WHEN doc_manager_exception THEN
3330: -- raise;
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);

Line 3333: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(

3329: -- WHEN doc_manager_exception THEN
3330: -- raise;
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,

Line 3337: PO_REQAPPROVAL_INIT1.send_error_notif(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');
3340: RAISE;
3341: END Reserve_doc_Override;