DBA Data[Home] [Help]

APPS.PO_REQAPPROVAL_ACTION dependencies on PO_REQAPPROVAL_INIT1

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

442: EXCEPTION
443: WHEN doc_manager_exception THEN
444: raise;
445: WHEN OTHERS THEN
446: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
447: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
448: WF_CORE.context('PO_REQAPPROVAL_ACTION' , 'state_check_approve', itemtype, itemkey, x_progress);
449: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.STATE_CHECK_APPROVE');
450: RAISE;

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

443: WHEN doc_manager_exception THEN
444: raise;
445: WHEN OTHERS THEN
446: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
447: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
448: WF_CORE.context('PO_REQAPPROVAL_ACTION' , 'state_check_approve', itemtype, itemkey, x_progress);
449: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.STATE_CHECK_APPROVE');
450: RAISE;
451:

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

445: WHEN OTHERS THEN
446: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
447: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
448: WF_CORE.context('PO_REQAPPROVAL_ACTION' , 'state_check_approve', itemtype, itemkey, x_progress);
449: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.STATE_CHECK_APPROVE');
450: RAISE;
451:
452:
453: END State_Check_approve;

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

523:
524: WHEN doc_manager_exception THEN
525: raise;
526: WHEN OTHERS THEN
527: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
528: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
529: WF_CORE.context('PO_REQAPPROVAL_ACTION', 'State_Check_reject', itemtype, itemkey, x_progress);
530: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.STATE_CHECK_REJECT');
531: RAISE;

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

524: WHEN doc_manager_exception THEN
525: raise;
526: WHEN OTHERS THEN
527: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
528: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
529: WF_CORE.context('PO_REQAPPROVAL_ACTION', 'State_Check_reject', itemtype, itemkey, x_progress);
530: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.STATE_CHECK_REJECT');
531: RAISE;
532:

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

526: WHEN OTHERS THEN
527: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
528: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
529: WF_CORE.context('PO_REQAPPROVAL_ACTION', 'State_Check_reject', itemtype, itemkey, x_progress);
530: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.STATE_CHECK_REJECT');
531: RAISE;
532:
533: END State_Check_reject;
534:

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

640:
641: WHEN doc_manager_exception THEN
642: raise;
643: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
644: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
645: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
646: WF_CORE.context('PO_REQAPPROVAL_ACTION', 'Doc_complete_check', itemtype, itemkey, x_progress);
647: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.DOC_COMPLETE_CHECK');
648: RAISE;

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

641: WHEN doc_manager_exception THEN
642: raise;
643: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
644: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
645: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
646: WF_CORE.context('PO_REQAPPROVAL_ACTION', 'Doc_complete_check', itemtype, itemkey, x_progress);
647: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.DOC_COMPLETE_CHECK');
648: RAISE;
649:

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

643: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
644: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
645: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
646: WF_CORE.context('PO_REQAPPROVAL_ACTION', 'Doc_complete_check', itemtype, itemkey, x_progress);
647: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.DOC_COMPLETE_CHECK');
648: RAISE;
649:
650: WHEN OTHERS THEN
651: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

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

647: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.DOC_COMPLETE_CHECK');
648: RAISE;
649:
650: WHEN OTHERS THEN
651: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
652: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
653: WF_CORE.context('PO_REQAPPROVAL_ACTION', 'Doc_complete_check', itemtype, itemkey, x_progress);
654: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.DOC_COMPLETE_CHECK');
655: RAISE;

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

648: RAISE;
649:
650: WHEN OTHERS THEN
651: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
652: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
653: WF_CORE.context('PO_REQAPPROVAL_ACTION', 'Doc_complete_check', itemtype, itemkey, x_progress);
654: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.DOC_COMPLETE_CHECK');
655: RAISE;
656:

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

650: WHEN OTHERS THEN
651: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
652: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
653: WF_CORE.context('PO_REQAPPROVAL_ACTION', 'Doc_complete_check', itemtype, itemkey, x_progress);
654: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.DOC_COMPLETE_CHECK');
655: RAISE;
656:
657: END Doc_complete_check;
658:

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

791:
792: WHEN doc_manager_exception THEN
793: raise;
794: WHEN OTHERS THEN
795: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
796: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
797: WF_CORE.context('PO_REQAPPROVAL_ACTION' , 'Approve_doc', itemtype, itemkey, x_progress);
798: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.APPROVE_DOC');
799: RAISE;

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

792: WHEN doc_manager_exception THEN
793: raise;
794: WHEN OTHERS THEN
795: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
796: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
797: WF_CORE.context('PO_REQAPPROVAL_ACTION' , 'Approve_doc', itemtype, itemkey, x_progress);
798: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.APPROVE_DOC');
799: RAISE;
800:

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

794: WHEN OTHERS THEN
795: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
796: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
797: WF_CORE.context('PO_REQAPPROVAL_ACTION' , 'Approve_doc', itemtype, itemkey, x_progress);
798: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.APPROVE_DOC');
799: RAISE;
800:
801:
802: END Approve_doc;

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

906:
907: WHEN doc_manager_exception THEN
908: raise;
909: WHEN OTHERS THEN
910: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
911: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
912: WF_CORE.context('PO_REQAPPROVAL_ACTION', 'Approve_and_forward_doc', itemtype, itemkey,x_progress);
913: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.APPROVE_AND_FORWARD_DOC');
914: RAISE;

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

907: WHEN doc_manager_exception THEN
908: raise;
909: WHEN OTHERS THEN
910: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
911: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
912: WF_CORE.context('PO_REQAPPROVAL_ACTION', 'Approve_and_forward_doc', itemtype, itemkey,x_progress);
913: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.APPROVE_AND_FORWARD_DOC');
914: RAISE;
915:

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

909: WHEN OTHERS THEN
910: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
911: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
912: WF_CORE.context('PO_REQAPPROVAL_ACTION', 'Approve_and_forward_doc', itemtype, itemkey,x_progress);
913: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.APPROVE_AND_FORWARD_DOC');
914: RAISE;
915:
916: END Approve_and_forward_doc;
917:

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

1025: EXCEPTION
1026: WHEN doc_manager_exception THEN
1027: raise;
1028: WHEN OTHERS THEN
1029: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1030: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1031: WF_CORE.context('PO_REQAPPROVAL_ACTION' , 'Forward_doc_inprocess', itemtype, itemkey,x_progress);
1032: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.FORWARD_DOC_INPROCESS');
1033: RAISE;

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

1026: WHEN doc_manager_exception THEN
1027: raise;
1028: WHEN OTHERS THEN
1029: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1030: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1031: WF_CORE.context('PO_REQAPPROVAL_ACTION' , 'Forward_doc_inprocess', itemtype, itemkey,x_progress);
1032: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.FORWARD_DOC_INPROCESS');
1033: RAISE;
1034:

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

1028: WHEN OTHERS THEN
1029: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1030: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1031: WF_CORE.context('PO_REQAPPROVAL_ACTION' , 'Forward_doc_inprocess', itemtype, itemkey,x_progress);
1032: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.FORWARD_DOC_INPROCESS');
1033: RAISE;
1034:
1035: END Forward_doc_inprocess;
1036:

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

1138: EXCEPTION
1139: WHEN doc_manager_exception THEN
1140: raise;
1141: WHEN OTHERS THEN
1142: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1143: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1144: WF_CORE.context('PO_REQAPPROVAL_ACTION' , 'Forward_doc_preapproved', itemtype, itemkey,x_progress);
1145: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.FORWARD_DOC_PREAPPROVED');
1146: RAISE;

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

1139: WHEN doc_manager_exception THEN
1140: raise;
1141: WHEN OTHERS THEN
1142: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1143: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1144: WF_CORE.context('PO_REQAPPROVAL_ACTION' , 'Forward_doc_preapproved', itemtype, itemkey,x_progress);
1145: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.FORWARD_DOC_PREAPPROVED');
1146: RAISE;
1147:

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

1141: WHEN OTHERS THEN
1142: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1143: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1144: WF_CORE.context('PO_REQAPPROVAL_ACTION' , 'Forward_doc_preapproved', itemtype, itemkey,x_progress);
1145: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.FORWARD_DOC_PREAPPROVED');
1146: RAISE;
1147:
1148:
1149: END Forward_doc_preapproved;

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

1228:
1229: WHEN doc_manager_exception THEN
1230: raise;
1231: WHEN OTHERS THEN
1232: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1233: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1234: WF_CORE.context('PO_REQAPPROVAL_ACTION' , 'Reject_doc', itemtype, itemkey,x_progress);
1235: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.REJECT_DOC');
1236: RAISE;

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

1229: WHEN doc_manager_exception THEN
1230: raise;
1231: WHEN OTHERS THEN
1232: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1233: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1234: WF_CORE.context('PO_REQAPPROVAL_ACTION' , 'Reject_doc', itemtype, itemkey,x_progress);
1235: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.REJECT_DOC');
1236: RAISE;
1237:

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

1231: WHEN OTHERS THEN
1232: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1233: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1234: WF_CORE.context('PO_REQAPPROVAL_ACTION' , 'Reject_doc', itemtype, itemkey,x_progress);
1235: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.REJECT_DOC');
1236: RAISE;
1237:
1238:
1239: END Reject_Doc;

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

1299: EXCEPTION
1300: WHEN doc_manager_exception THEN
1301: raise;
1302: WHEN OTHERS THEN
1303: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1304: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1305: WF_CORE.context('PO_REQAPPROVAL_ACTION' , 'Verify_authority', itemtype, itemkey, x_progress);
1306: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.VERIFY_AUTHORITY');
1307: RAISE;

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

1300: WHEN doc_manager_exception THEN
1301: raise;
1302: WHEN OTHERS THEN
1303: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1304: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1305: WF_CORE.context('PO_REQAPPROVAL_ACTION' , 'Verify_authority', itemtype, itemkey, x_progress);
1306: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.VERIFY_AUTHORITY');
1307: RAISE;
1308:

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

1302: WHEN OTHERS THEN
1303: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1304: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1305: WF_CORE.context('PO_REQAPPROVAL_ACTION' , 'Verify_authority', itemtype, itemkey, x_progress);
1306: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.VERIFY_AUTHORITY');
1307: RAISE;
1308:
1309:
1310: END Verify_authority;

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

1372:
1373: WHEN doc_manager_exception THEN
1374: raise;
1375: WHEN OTHERS THEN
1376: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1377: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1378: WF_CORE.context('PO_REQAPPROVAL_ACTION', 'Open_Doc_State', itemtype, itemkey, x_progress);
1379: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.OPEN_DOC_STATE');
1380: RAISE;

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

1373: WHEN doc_manager_exception THEN
1374: raise;
1375: WHEN OTHERS THEN
1376: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1377: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1378: WF_CORE.context('PO_REQAPPROVAL_ACTION', 'Open_Doc_State', itemtype, itemkey, x_progress);
1379: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.OPEN_DOC_STATE');
1380: RAISE;
1381:

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

1375: WHEN OTHERS THEN
1376: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1377: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1378: WF_CORE.context('PO_REQAPPROVAL_ACTION', 'Open_Doc_State', itemtype, itemkey, x_progress);
1379: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.OPEN_DOC_STATE');
1380: RAISE;
1381:
1382: END Open_Doc_State;
1383:

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

1497: -- WHEN doc_manager_exception THEN
1498: -- raise;
1499:
1500: WHEN OTHERS THEN
1501: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1502: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
1503: itemType, itemkey);
1504: WF_CORE.context('PO_REQAPPROVAL_ACTION', 'Reserve_Doc', itemtype, itemkey,
1505: x_progress);

Line 1502: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(

1498: -- raise;
1499:
1500: WHEN OTHERS THEN
1501: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1502: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
1503: itemType, itemkey);
1504: WF_CORE.context('PO_REQAPPROVAL_ACTION', 'Reserve_Doc', itemtype, itemkey,
1505: x_progress);
1506: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

Line 1506: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

1502: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
1503: itemType, itemkey);
1504: WF_CORE.context('PO_REQAPPROVAL_ACTION', 'Reserve_Doc', itemtype, itemkey,
1505: x_progress);
1506: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,
1507: l_preparer_user_name, l_doc_string, sqlerrm,
1508: 'PO_REQAPPROVAL_ACTION.RESERVE_DOC');
1509: RAISE;
1510: END Reserve_Doc;

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

3361:
3362: BEGIN
3363:
3364: -- Bug 4290541, replaced call to set apps init context with
3365: -- po reqapproval init1 set doc mgr context
3366: --
3367: po_reqapproval_init1.set_doc_mgr_context(itemtype,itemkey);
3368:
3369: x_progress := 'PO_REQAPPROVAL_ACTION.set_doc_mgr_context. USER_ID= ' || to_char(l_user_id)

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

3363:
3364: -- Bug 4290541, replaced call to set apps init context with
3365: -- po reqapproval init1 set doc mgr context
3366: --
3367: po_reqapproval_init1.set_doc_mgr_context(itemtype,itemkey);
3368:
3369: x_progress := 'PO_REQAPPROVAL_ACTION.set_doc_mgr_context. USER_ID= ' || to_char(l_user_id)
3370: || ' APPLICATION_ID= ' || to_char(l_application_id) ||
3371: 'RESPONSIBILITY_ID= ' || to_char(l_responsibility_id);

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

3563: EXCEPTION
3564: -- WHEN doc_manager_exception THEN
3565: -- raise;
3566: WHEN OTHERS THEN
3567: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
3568: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
3569: itemType, itemkey);
3570: WF_CORE.context('PO_REQAPPROVAL_ACTION', 'Reserve_doc_Override',
3571: itemtype, itemkey, x_progress);

Line 3568: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(

3564: -- WHEN doc_manager_exception THEN
3565: -- raise;
3566: WHEN OTHERS THEN
3567: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
3568: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
3569: itemType, itemkey);
3570: WF_CORE.context('PO_REQAPPROVAL_ACTION', 'Reserve_doc_Override',
3571: itemtype, itemkey, x_progress);
3572: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

Line 3572: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

3568: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
3569: itemType, itemkey);
3570: WF_CORE.context('PO_REQAPPROVAL_ACTION', 'Reserve_doc_Override',
3571: itemtype, itemkey, x_progress);
3572: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,
3573: l_preparer_user_name, l_doc_string, sqlerrm,
3574: 'PO_REQAPPROVAL_ACTION.RESERVE_DOC');
3575: RAISE;
3576: END Reserve_doc_Override;