DBA Data[Home] [Help]

APPS.POR_AME_APPROVAL_LIST_WF1S dependencies on PO_REQAPPROVAL_INIT1

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

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

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

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;

Line 199: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_APPROVAL_LIST_WF1S.setAmeAttributes');

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:

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

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

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

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;

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

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:

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

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

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

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;

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

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:

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

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

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

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:

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

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;

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

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:

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

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

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

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

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:

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

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

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

Line 965: PO_REQAPPROVAL_INIT1.get_user_name

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

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

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:

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

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

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