eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_APPROVAL_LIST_WF1S dependencies on PO_REQAPPROVAL_INIT1

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

124: END IF; --run mode
125:
126: EXCEPTION
127: WHEN OTHERS THEN
128: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
129: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
130: WF_CORE.context('PO_APPROVAL_LIST_WF1S' , 'Does_Approval_List_Exist', itemtype, itemkey, l_progress);
131: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.DOES_APPROVAL_LIST_EXIST');
132: RAISE;

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

125:
126: EXCEPTION
127: WHEN OTHERS THEN
128: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
129: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
130: WF_CORE.context('PO_APPROVAL_LIST_WF1S' , 'Does_Approval_List_Exist', itemtype, itemkey, l_progress);
131: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.DOES_APPROVAL_LIST_EXIST');
132: RAISE;
133:

Line 131: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.DOES_APPROVAL_LIST_EXIST');

127: WHEN OTHERS THEN
128: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
129: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
130: WF_CORE.context('PO_APPROVAL_LIST_WF1S' , 'Does_Approval_List_Exist', itemtype, itemkey, l_progress);
131: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.DOES_APPROVAL_LIST_EXIST');
132: RAISE;
133:
134: END Does_Approval_List_Exist;
135:

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

259:
260: EXCEPTION
261:
262: WHEN E_FAILURE THEN
263: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
264: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
265: wf_core.context('PO_APPROVAL_LIST_WF1S',
266: 'Find_Approval_list E_FAILURE',
267: l_progress,l_return_code,sqlerrm);

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

260: EXCEPTION
261:
262: WHEN E_FAILURE THEN
263: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
264: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
265: wf_core.context('PO_APPROVAL_LIST_WF1S',
266: 'Find_Approval_list E_FAILURE',
267: l_progress,l_return_code,sqlerrm);
268: -- wf_core.raise('Find_Approval_list E_FAILURE' || l_progress||sqlerrm);

Line 269: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.FIND_APPROVAL_LIST');

265: wf_core.context('PO_APPROVAL_LIST_WF1S',
266: 'Find_Approval_list E_FAILURE',
267: l_progress,l_return_code,sqlerrm);
268: -- wf_core.raise('Find_Approval_list E_FAILURE' || l_progress||sqlerrm);
269: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.FIND_APPROVAL_LIST');
270:
271: RAISE;
272:
273: WHEN OTHERS THEN

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

270:
271: RAISE;
272:
273: WHEN OTHERS THEN
274: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
275: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
276: wf_core.context('PO_APPROVAL_LIST_WF1S',
277: 'Find_Approval_list',l_progress,l_return_code,sqlerrm);
278:

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

271: RAISE;
272:
273: WHEN OTHERS THEN
274: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
275: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
276: wf_core.context('PO_APPROVAL_LIST_WF1S',
277: 'Find_Approval_list',l_progress,l_return_code,sqlerrm);
278:
279: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.FIND_APPROVAL_LIST');

Line 279: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.FIND_APPROVAL_LIST');

275: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
276: wf_core.context('PO_APPROVAL_LIST_WF1S',
277: 'Find_Approval_list',l_progress,l_return_code,sqlerrm);
278:
279: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.FIND_APPROVAL_LIST');
280:
281: RAISE;
282:
283:

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

516: WHEN doc_manager_exception THEN
517: raise;
518:
519: WHEN OTHERS THEN
520: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
521: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
522: WF_CORE.context('PO_APPROVAL_LIST_WF1S' , 'Build_Default_Approval_list', itemtype, itemkey, l_progress);
523: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.Build_Default_Approval_list');
524: RAISE;

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

517: raise;
518:
519: WHEN OTHERS THEN
520: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
521: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
522: WF_CORE.context('PO_APPROVAL_LIST_WF1S' , 'Build_Default_Approval_list', itemtype, itemkey, l_progress);
523: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.Build_Default_Approval_list');
524: RAISE;
525:

Line 523: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.Build_Default_Approval_list');

519: WHEN OTHERS THEN
520: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
521: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
522: WF_CORE.context('PO_APPROVAL_LIST_WF1S' , 'Build_Default_Approval_list', itemtype, itemkey, l_progress);
523: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.Build_Default_Approval_list');
524: RAISE;
525:
526: END Build_Default_Approval_list;
527:

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

637: WHEN doc_manager_exception THEN
638: raise;
639:
640: WHEN OTHERS THEN
641: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
642: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
643: wf_core.context('PO_APPROVAL_LIST_WF1S','Rebuild_List_Forward',l_progress,sqlerrm);
644: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.REBUILD_LIST_FORWARD');
645: RAISE;

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

638: raise;
639:
640: WHEN OTHERS THEN
641: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
642: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
643: wf_core.context('PO_APPROVAL_LIST_WF1S','Rebuild_List_Forward',l_progress,sqlerrm);
644: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.REBUILD_LIST_FORWARD');
645: RAISE;
646:

Line 644: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.REBUILD_LIST_FORWARD');

640: WHEN OTHERS THEN
641: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
642: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
643: wf_core.context('PO_APPROVAL_LIST_WF1S','Rebuild_List_Forward',l_progress,sqlerrm);
644: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.REBUILD_LIST_FORWARD');
645: RAISE;
646:
647: END Rebuild_List_Forward;
648:

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

752: WHEN doc_manager_exception THEN
753: raise;
754:
755: WHEN OTHERS THEN
756: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
757: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
758: wf_core.context('PO_APPROVAL_LIST_WF1S','Rebuild_List_Doc_Changed',l_progress,sqlerrm);
759: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.REBUILD_LIST_DOC_CHANGED');
760: RAISE;

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

753: raise;
754:
755: WHEN OTHERS THEN
756: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
757: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
758: wf_core.context('PO_APPROVAL_LIST_WF1S','Rebuild_List_Doc_Changed',l_progress,sqlerrm);
759: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.REBUILD_LIST_DOC_CHANGED');
760: RAISE;
761:

Line 759: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.REBUILD_LIST_DOC_CHANGED');

755: WHEN OTHERS THEN
756: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
757: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
758: wf_core.context('PO_APPROVAL_LIST_WF1S','Rebuild_List_Doc_Changed',l_progress,sqlerrm);
759: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.REBUILD_LIST_DOC_CHANGED');
760: RAISE;
761:
762: END Rebuild_List_Doc_Changed;
763:

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

868: WHEN doc_manager_exception THEN
869: raise;
870:
871: WHEN OTHERS THEN
872: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
873: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
874: wf_core.context('PO_APPROVAL_LIST_WF1S','Rebuild_List_Invalid_Approver',l_progress,sqlerrm);
875: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.REBUILD_LIST_INVALID_APPROVER');
876: RAISE;

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

869: raise;
870:
871: WHEN OTHERS THEN
872: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
873: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
874: wf_core.context('PO_APPROVAL_LIST_WF1S','Rebuild_List_Invalid_Approver',l_progress,sqlerrm);
875: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.REBUILD_LIST_INVALID_APPROVER');
876: RAISE;
877:

Line 875: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.REBUILD_LIST_INVALID_APPROVER');

871: WHEN OTHERS THEN
872: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
873: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
874: wf_core.context('PO_APPROVAL_LIST_WF1S','Rebuild_List_Invalid_Approver',l_progress,sqlerrm);
875: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.REBUILD_LIST_INVALID_APPROVER');
876: RAISE;
877:
878: END Rebuild_List_Invalid_Approver;
879:

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

1018: END IF;
1019: END IF;
1020: EXCEPTION
1021: WHEN E_FAILURE THEN
1022: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1023: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1024: wf_core.context('PO_APPROVAL_LIST_WF1S',
1025: 'Get_Next_Approver E_FAILURE',
1026: l_progress,l_return_code,sqlerrm);

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

1019: END IF;
1020: EXCEPTION
1021: WHEN E_FAILURE THEN
1022: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1023: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1024: wf_core.context('PO_APPROVAL_LIST_WF1S',
1025: 'Get_Next_Approver E_FAILURE',
1026: l_progress,l_return_code,sqlerrm);
1027: -- wf_core.raise('Get_Next_Approver E_FAILURE' || l_progress||sqlerrm);

Line 1029: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.GET_NEXT_APPROVER');

1025: 'Get_Next_Approver E_FAILURE',
1026: l_progress,l_return_code,sqlerrm);
1027: -- wf_core.raise('Get_Next_Approver E_FAILURE' || l_progress||sqlerrm);
1028:
1029: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.GET_NEXT_APPROVER');
1030:
1031: RAISE;
1032: WHEN OTHERS THEN
1033: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

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

1029: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.GET_NEXT_APPROVER');
1030:
1031: RAISE;
1032: WHEN OTHERS THEN
1033: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1034: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1035: wf_core.context('PO_APPROVAL_LIST_WF1S','Get_Next_Approver',l_progress,sqlerrm);
1036:
1037: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.GET_NEXT_APPROVER');

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

1030:
1031: RAISE;
1032: WHEN OTHERS THEN
1033: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1034: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1035: wf_core.context('PO_APPROVAL_LIST_WF1S','Get_Next_Approver',l_progress,sqlerrm);
1036:
1037: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.GET_NEXT_APPROVER');
1038:

Line 1037: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.GET_NEXT_APPROVER');

1033: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1034: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1035: wf_core.context('PO_APPROVAL_LIST_WF1S','Get_Next_Approver',l_progress,sqlerrm);
1036:
1037: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.GET_NEXT_APPROVER');
1038:
1039: RAISE;
1040:
1041: END Get_Next_Approver;

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

1137: END IF; -- run mode
1138:
1139: EXCEPTION
1140: WHEN OTHERS THEN
1141: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1142: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1143: wf_core.context('PO_APPROVAL_LIST_WF1S','Is_Approver_List_Empty',l_progress,sqlerrm);
1144: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.IS_APPROVAL_LIST_EMPTY');
1145: RAISE;

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

1138:
1139: EXCEPTION
1140: WHEN OTHERS THEN
1141: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1142: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1143: wf_core.context('PO_APPROVAL_LIST_WF1S','Is_Approver_List_Empty',l_progress,sqlerrm);
1144: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.IS_APPROVAL_LIST_EMPTY');
1145: RAISE;
1146:

Line 1144: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.IS_APPROVAL_LIST_EMPTY');

1140: WHEN OTHERS THEN
1141: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1142: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1143: wf_core.context('PO_APPROVAL_LIST_WF1S','Is_Approver_List_Empty',l_progress,sqlerrm);
1144: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.IS_APPROVAL_LIST_EMPTY');
1145: RAISE;
1146:
1147: END Is_Approval_List_Empty;
1148:

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

1232: END IF;
1233:
1234: EXCEPTION
1235: WHEN OTHERS THEN
1236: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1237: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1238: wf_core.context('PO_APPROVAL_LIST_WF1S','Insert_Action_History',l_progress,sqlerrm);
1239: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.INSERT_ACTION_HISTORY');
1240: RAISE;

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

1233:
1234: EXCEPTION
1235: WHEN OTHERS THEN
1236: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1237: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1238: wf_core.context('PO_APPROVAL_LIST_WF1S','Insert_Action_History',l_progress,sqlerrm);
1239: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.INSERT_ACTION_HISTORY');
1240: RAISE;
1241:

Line 1239: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.INSERT_ACTION_HISTORY');

1235: WHEN OTHERS THEN
1236: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1237: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1238: wf_core.context('PO_APPROVAL_LIST_WF1S','Insert_Action_History',l_progress,sqlerrm);
1239: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.INSERT_ACTION_HISTORY');
1240: RAISE;
1241:
1242: END Insert_Action_History;
1243:

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

1339:
1340:
1341: EXCEPTION
1342: WHEN OTHERS THEN
1343: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1344: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1345: wf_core.context('PO_APPROVAL_LIST_WF1S','Update_Action_History_Approve',l_progress,sqlerrm);
1346: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.UPDATE_ACTION_HISTORY_APPROVE');
1347: RAISE;

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

1340:
1341: EXCEPTION
1342: WHEN OTHERS THEN
1343: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1344: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1345: wf_core.context('PO_APPROVAL_LIST_WF1S','Update_Action_History_Approve',l_progress,sqlerrm);
1346: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.UPDATE_ACTION_HISTORY_APPROVE');
1347: RAISE;
1348:

Line 1346: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.UPDATE_ACTION_HISTORY_APPROVE');

1342: WHEN OTHERS THEN
1343: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1344: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1345: wf_core.context('PO_APPROVAL_LIST_WF1S','Update_Action_History_Approve',l_progress,sqlerrm);
1346: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.UPDATE_ACTION_HISTORY_APPROVE');
1347: RAISE;
1348:
1349: END Update_Action_History_Approve;
1350:

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

1441: END IF;
1442:
1443: EXCEPTION
1444: WHEN OTHERS THEN
1445: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1446: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1447: wf_core.context('PO_APPROVAL_LIST_WF1S','Update_Action_History_Timeout',l_progress,sqlerrm);
1448: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.UPDATE_ACTION_HISTORY_TIMEOUT');
1449: RAISE;

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

1442:
1443: EXCEPTION
1444: WHEN OTHERS THEN
1445: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1446: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1447: wf_core.context('PO_APPROVAL_LIST_WF1S','Update_Action_History_Timeout',l_progress,sqlerrm);
1448: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.UPDATE_ACTION_HISTORY_TIMEOUT');
1449: RAISE;
1450:

Line 1448: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.UPDATE_ACTION_HISTORY_TIMEOUT');

1444: WHEN OTHERS THEN
1445: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1446: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1447: wf_core.context('PO_APPROVAL_LIST_WF1S','Update_Action_History_Timeout',l_progress,sqlerrm);
1448: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.UPDATE_ACTION_HISTORY_TIMEOUT');
1449: RAISE;
1450:
1451: END Update_Action_History_Timeout;
1452:

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

1547: END IF;
1548:
1549: EXCEPTION
1550: WHEN OTHERS THEN
1551: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1552: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1553: wf_core.context('PO_APPROVAL_LIST_WF1S','Update_Action_History_App_Fwd',l_progress,sqlerrm);
1554: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.UPDATE_ACTION_HISTORY_APP_FWD');
1555: RAISE;

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

1548:
1549: EXCEPTION
1550: WHEN OTHERS THEN
1551: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1552: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1553: wf_core.context('PO_APPROVAL_LIST_WF1S','Update_Action_History_App_Fwd',l_progress,sqlerrm);
1554: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.UPDATE_ACTION_HISTORY_APP_FWD');
1555: RAISE;
1556:

Line 1554: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.UPDATE_ACTION_HISTORY_APP_FWD');

1550: WHEN OTHERS THEN
1551: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1552: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1553: wf_core.context('PO_APPROVAL_LIST_WF1S','Update_Action_History_App_Fwd',l_progress,sqlerrm);
1554: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.UPDATE_ACTION_HISTORY_APP_FWD');
1555: RAISE;
1556:
1557: END Update_Action_History_App_Fwd;
1558:

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

1651: END IF;
1652:
1653: EXCEPTION
1654: WHEN OTHERS THEN
1655: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1656: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1657: wf_core.context('PO_APPROVAL_LIST_WF1S','Update_Action_History_Forward',l_progress,sqlerrm);
1658: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.UPDATE_ACTION_HISTORY_FORWARD');
1659: RAISE;

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

1652:
1653: EXCEPTION
1654: WHEN OTHERS THEN
1655: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1656: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1657: wf_core.context('PO_APPROVAL_LIST_WF1S','Update_Action_History_Forward',l_progress,sqlerrm);
1658: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.UPDATE_ACTION_HISTORY_FORWARD');
1659: RAISE;
1660:

Line 1658: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.UPDATE_ACTION_HISTORY_FORWARD');

1654: WHEN OTHERS THEN
1655: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1656: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1657: wf_core.context('PO_APPROVAL_LIST_WF1S','Update_Action_History_Forward',l_progress,sqlerrm);
1658: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.UPDATE_ACTION_HISTORY_FORWARD');
1659: RAISE;
1660:
1661: END Update_Action_History_Forward;
1662:

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

1755: END IF;
1756:
1757: EXCEPTION
1758: WHEN OTHERS THEN
1759: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1760: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1761: wf_core.context('PO_APPROVAL_LIST_WF1S','Update_Action_History_Reject',l_progress,sqlerrm);
1762: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.UPDATE_ACTION_HISTORY_REJECT');
1763: RAISE;

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

1756:
1757: EXCEPTION
1758: WHEN OTHERS THEN
1759: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1760: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1761: wf_core.context('PO_APPROVAL_LIST_WF1S','Update_Action_History_Reject',l_progress,sqlerrm);
1762: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.UPDATE_ACTION_HISTORY_REJECT');
1763: RAISE;
1764:

Line 1762: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.UPDATE_ACTION_HISTORY_REJECT');

1758: WHEN OTHERS THEN
1759: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1760: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1761: wf_core.context('PO_APPROVAL_LIST_WF1S','Update_Action_History_Reject',l_progress,sqlerrm);
1762: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.UPDATE_ACTION_HISTORY_REJECT');
1763: RAISE;
1764:
1765: END Update_Action_History_Reject;
1766:

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

2280: IF (c_response%ISOPEN) THEN
2281: CLOSE c_response;
2282: END IF;
2283:
2284: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2285: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2286: wf_core.context('PO_APPROVAL_LIST_WF1S',
2287: 'Update_Approval_List_Response E_FAILURE',
2288: l_progress,l_return_code,sqlerrm);

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

2281: CLOSE c_response;
2282: END IF;
2283:
2284: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2285: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2286: wf_core.context('PO_APPROVAL_LIST_WF1S',
2287: 'Update_Approval_List_Response E_FAILURE',
2288: l_progress,l_return_code,sqlerrm);
2289: -- wf_core.raise('Find_Approval_list E_FAILURE' || l_progress||sqlerrm);

Line 2291: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.UPDATE_APPROVAL_LIST_RESPONSE');

2287: 'Update_Approval_List_Response E_FAILURE',
2288: l_progress,l_return_code,sqlerrm);
2289: -- wf_core.raise('Find_Approval_list E_FAILURE' || l_progress||sqlerrm);
2290:
2291: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.UPDATE_APPROVAL_LIST_RESPONSE');
2292:
2293: RAISE;
2294:
2295: WHEN OTHERS THEN

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

2299: IF (c_response%ISOPEN) THEN
2300: CLOSE c_response;
2301: END IF;
2302:
2303: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2304: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2305: wf_core.context('PO_APPROVAL_LIST_WF1S',
2306: 'Update_Approval_List_Response',l_progress,sqlerrm);
2307:

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

2300: CLOSE c_response;
2301: END IF;
2302:
2303: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2304: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2305: wf_core.context('PO_APPROVAL_LIST_WF1S',
2306: 'Update_Approval_List_Response',l_progress,sqlerrm);
2307:
2308: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.UPDATE_APPROVAL_LIST_RESPONSE');

Line 2308: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.UPDATE_APPROVAL_LIST_RESPONSE');

2304: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2305: wf_core.context('PO_APPROVAL_LIST_WF1S',
2306: 'Update_Approval_List_Response',l_progress,sqlerrm);
2307:
2308: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.UPDATE_APPROVAL_LIST_RESPONSE');
2309:
2310: RAISE;
2311:
2312: END Update_Approval_List_Response;

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

2853: raise;
2854:
2855: WHEN E_UPDATE_RESPONSE_FAIL THEN
2856:
2857: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2858: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2859: wf_core.context('PO_APPROVAL_LIST_WF1S',
2860: 'Update_App_List_Resp_Success E_FAILURE',
2861: l_progress,l_return_code,sqlerrm);

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

2854:
2855: WHEN E_UPDATE_RESPONSE_FAIL THEN
2856:
2857: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2858: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2859: wf_core.context('PO_APPROVAL_LIST_WF1S',
2860: 'Update_App_List_Resp_Success E_FAILURE',
2861: l_progress,l_return_code,sqlerrm);
2862: -- wf_core.raise('Find_Approval_list E_FAILURE' || l_progress||sqlerrm);

Line 2864: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string,

2860: 'Update_App_List_Resp_Success E_FAILURE',
2861: l_progress,l_return_code,sqlerrm);
2862: -- wf_core.raise('Find_Approval_list E_FAILURE' || l_progress||sqlerrm);
2863:
2864: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string,
2865: sqlerrm, 'PO_APPROVAL_LIST_WF1S.UPDATE_APP_LIST_RESP_SUCCESS');
2866:
2867: RAISE;
2868:

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

2867: RAISE;
2868:
2869: WHEN OTHERS THEN
2870:
2871: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2872: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2873: wf_core.context('PO_APPROVAL_LIST_WF1S',
2874: 'Update_App_List_Resp_Success',l_progress,sqlerrm);
2875:

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

2868:
2869: WHEN OTHERS THEN
2870:
2871: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2872: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2873: wf_core.context('PO_APPROVAL_LIST_WF1S',
2874: 'Update_App_List_Resp_Success',l_progress,sqlerrm);
2875:
2876: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string,

Line 2876: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string,

2872: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2873: wf_core.context('PO_APPROVAL_LIST_WF1S',
2874: 'Update_App_List_Resp_Success',l_progress,sqlerrm);
2875:
2876: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string,
2877: sqlerrm, 'PO_APPROVAL_LIST_WF1S.UPDATE_APP_LIST_RESP_SUCCESS');
2878:
2879: RAISE;
2880:

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

2939: l_progress := '999';
2940:
2941: EXCEPTION
2942: WHEN OTHERS THEN
2943: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2944: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2945: wf_core.context('PO_APPROVAL_LIST_WF1S','Create_Attach_Info_Temp',l_progress,sqlerrm);
2946: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.CREATE_ATTACH_INFO_TEMP');
2947: RAISE;

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

2940:
2941: EXCEPTION
2942: WHEN OTHERS THEN
2943: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2944: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2945: wf_core.context('PO_APPROVAL_LIST_WF1S','Create_Attach_Info_Temp',l_progress,sqlerrm);
2946: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.CREATE_ATTACH_INFO_TEMP');
2947: RAISE;
2948:

Line 2946: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.CREATE_ATTACH_INFO_TEMP');

2942: WHEN OTHERS THEN
2943: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2944: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2945: wf_core.context('PO_APPROVAL_LIST_WF1S','Create_Attach_Info_Temp',l_progress,sqlerrm);
2946: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.CREATE_ATTACH_INFO_TEMP');
2947: RAISE;
2948:
2949: END Create_Attach_Info_Temp;
2950:

Line 2977: -- PO_REQAPPROVAL_INIT1.Set_doc_mgr_context(itemtype, itemkey);

2973:
2974: /* Set the context for the doc manager */
2975: -- Bug 4290541, replace apps init with set doc mgr context
2976: -- Context Setting revamp
2977: -- PO_REQAPPROVAL_INIT1.Set_doc_mgr_context(itemtype, itemkey);
2978:
2979: l_progress := 'set_doc_mgr_context. USER_ID= ' || to_char(l_user_id)
2980: || ' APPLICATION_ID= ' || to_char(l_application_id) ||
2981: 'RESPONSIBILITY_ID= ' || to_char(l_responsibility_id);

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

3133: END IF;
3134:
3135: EXCEPTION
3136: WHEN OTHERS THEN
3137: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
3138: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType,itemkey);
3139: wf_core.context('PO_APPROVAL_LIST_WF1S','Insert_Res_Action_History',
3140: l_progress,sqlerrm);
3141: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,

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

3134:
3135: EXCEPTION
3136: WHEN OTHERS THEN
3137: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
3138: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType,itemkey);
3139: wf_core.context('PO_APPROVAL_LIST_WF1S','Insert_Res_Action_History',
3140: l_progress,sqlerrm);
3141: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
3142: l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.INSERT_ACTION_HISTORY');

Line 3141: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,

3137: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
3138: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType,itemkey);
3139: wf_core.context('PO_APPROVAL_LIST_WF1S','Insert_Res_Action_History',
3140: l_progress,sqlerrm);
3141: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
3142: l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.INSERT_ACTION_HISTORY');
3143: RAISE;
3144:
3145: END Insert_Res_Action_History;