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