191: END IF; -- FOR 'RUN' MODE
192:
193: EXCEPTION
194: WHEN OTHERS THEN
195: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
196: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
197: wf_core.context('POR_AME_APPROVAL_LIST_WF1S','setAmeAttributes',l_progress,sqlerrm);
198:
199: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_APPROVAL_LIST_WF1S.setAmeAttributes');
192:
193: EXCEPTION
194: WHEN OTHERS THEN
195: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
196: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
197: wf_core.context('POR_AME_APPROVAL_LIST_WF1S','setAmeAttributes',l_progress,sqlerrm);
198:
199: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_APPROVAL_LIST_WF1S.setAmeAttributes');
200: RAISE;
195: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
196: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
197: wf_core.context('POR_AME_APPROVAL_LIST_WF1S','setAmeAttributes',l_progress,sqlerrm);
198:
199: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_APPROVAL_LIST_WF1S.setAmeAttributes');
200: RAISE;
201:
202: end;
203:
291: END IF;
292:
293: EXCEPTION
294: WHEN OTHERS THEN
295: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
296: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
297: wf_core.context('POR_AME_APPROVAL_LIST_WF1S','Is_Ame_For_Approval',l_progress,sqlerrm);
298:
299: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_APPROVAL_LIST_WF1S.Is_Ame_For_Approval');
292:
293: EXCEPTION
294: WHEN OTHERS THEN
295: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
296: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
297: wf_core.context('POR_AME_APPROVAL_LIST_WF1S','Is_Ame_For_Approval',l_progress,sqlerrm);
298:
299: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_APPROVAL_LIST_WF1S.Is_Ame_For_Approval');
300: RAISE;
295: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
296: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
297: wf_core.context('POR_AME_APPROVAL_LIST_WF1S','Is_Ame_For_Approval',l_progress,sqlerrm);
298:
299: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_APPROVAL_LIST_WF1S.Is_Ame_For_Approval');
300: RAISE;
301:
302: END Is_Ame_For_Approval;
303:
392: END IF;
393:
394: EXCEPTION
395: WHEN OTHERS THEN
396: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
397: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
398: wf_core.context('POR_AME_APPROVAL_LIST_WF1S','Is_Ame_For_Rco_Approval',l_progress,sqlerrm);
399:
400: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_APPROVAL_LIST_WF1S.Is_Ame_For_Rco_Approval');
393:
394: EXCEPTION
395: WHEN OTHERS THEN
396: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
397: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
398: wf_core.context('POR_AME_APPROVAL_LIST_WF1S','Is_Ame_For_Rco_Approval',l_progress,sqlerrm);
399:
400: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_APPROVAL_LIST_WF1S.Is_Ame_For_Rco_Approval');
401: RAISE;
396: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
397: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
398: wf_core.context('POR_AME_APPROVAL_LIST_WF1S','Is_Ame_For_Rco_Approval',l_progress,sqlerrm);
399:
400: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_APPROVAL_LIST_WF1S.Is_Ame_For_Rco_Approval');
401: RAISE;
402:
403: END Is_Ame_For_Rco_Approval;
404:
574: END IF;
575:
576: EXCEPTION
577: WHEN OTHERS THEN
578: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
579: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
580: wf_core.context('POR_AME_APPROVAL_LIST_WF1S','Get_Next_Approver',l_progress,sqlerrm);
581:
582: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_APPROVAL_LIST_WF1S.GET_NEXT_APPROVER');
575:
576: EXCEPTION
577: WHEN OTHERS THEN
578: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
579: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
580: wf_core.context('POR_AME_APPROVAL_LIST_WF1S','Get_Next_Approver',l_progress,sqlerrm);
581:
582: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_APPROVAL_LIST_WF1S.GET_NEXT_APPROVER');
583:
578: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
579: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
580: wf_core.context('POR_AME_APPROVAL_LIST_WF1S','Get_Next_Approver',l_progress,sqlerrm);
581:
582: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_APPROVAL_LIST_WF1S.GET_NEXT_APPROVER');
583:
584: RAISE;
585:
586: END Get_Next_Approver;
709: EXCEPTION
710:
711: WHEN OTHERS THEN
712:
713: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
714: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
715: wf_core.context('POR_AME_APPROVAL_LIST_WF1S',
716: 'Update_Approval_List_Response',l_progress,sqlerrm);
717:
710:
711: WHEN OTHERS THEN
712:
713: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
714: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
715: wf_core.context('POR_AME_APPROVAL_LIST_WF1S',
716: 'Update_Approval_List_Response',l_progress,sqlerrm);
717:
718: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQAPPRV_PVT.UPDATE_APPROVAL_LIST_RESPONSE');
714: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
715: wf_core.context('POR_AME_APPROVAL_LIST_WF1S',
716: 'Update_Approval_List_Response',l_progress,sqlerrm);
717:
718: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQAPPRV_PVT.UPDATE_APPROVAL_LIST_RESPONSE');
719:
720: RAISE;
721:
722: END Update_Approval_List_Response;
804: EXCEPTION
805:
806: WHEN OTHERS THEN
807:
808: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
809: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
810: wf_core.context('POR_AME_APPROVAL_LIST_WF1S',
811: 'Update_Approval_List_Response',l_progress,sqlerrm);
812:
805:
806: WHEN OTHERS THEN
807:
808: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
809: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
810: wf_core.context('POR_AME_APPROVAL_LIST_WF1S',
811: 'Update_Approval_List_Response',l_progress,sqlerrm);
812:
813: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQAPPRV_PVT.UPDATE_APPROVAL_LIST_RESPONSE');
809: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
810: wf_core.context('POR_AME_APPROVAL_LIST_WF1S',
811: 'Update_Approval_List_Response',l_progress,sqlerrm);
812:
813: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQAPPRV_PVT.UPDATE_APPROVAL_LIST_RESPONSE');
814:
815: RAISE;
816:
817: END Update_Approver_Timeout;
961: );
962:
963:
964:
965: PO_REQAPPROVAL_INIT1.get_user_name
966: (
967: p_employee_id =>l_forward_to_id,
968: x_username =>l_user_name,
969: x_user_display_name => l_disp_user_name);
989: EXCEPTION
990:
991: WHEN OTHERS THEN
992:
993: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
994: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
995: wf_core.context('POR_AME_APPROVAL_LIST_WF1S',
996: 'SET_FORWARD_RESERVE_APPROVER',l_progress,sqlerrm);
997:
990:
991: WHEN OTHERS THEN
992:
993: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
994: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
995: wf_core.context('POR_AME_APPROVAL_LIST_WF1S',
996: 'SET_FORWARD_RESERVE_APPROVER',l_progress,sqlerrm);
997:
998: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQAPPRV_PVT.SET_FORWARD_RESERVE_APPROVER');
994: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
995: wf_core.context('POR_AME_APPROVAL_LIST_WF1S',
996: 'SET_FORWARD_RESERVE_APPROVER',l_progress,sqlerrm);
997:
998: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQAPPRV_PVT.SET_FORWARD_RESERVE_APPROVER');
999:
1000: RAISE;
1001:
1002: END SET_FORWARD_RESERVE_APPROVER;