DBA Data[Home] [Help]

APPS.PO_APPROVAL_LIST_WF1S dependencies on WF_CORE

Line 67: WF_CORE.context('PO_APPROVAL_LIST_WF1S' , 'Is_Document_Manager_Error_1_2', itemtype, itemkey, l_progress);

63: END IF; --run mode
64:
65: EXCEPTION
66: WHEN OTHERS THEN
67: WF_CORE.context('PO_APPROVAL_LIST_WF1S' , 'Is_Document_Manager_Error_1_2', itemtype, itemkey, l_progress);
68: resultout:='COMPLETE:'||'N';
69:
70: END Is_Document_Manager_Error_1_2;
71:

Line 130: WF_CORE.context('PO_APPROVAL_LIST_WF1S' , 'Does_Approval_List_Exist', itemtype, itemkey, l_progress);

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:
134: END Does_Approval_List_Exist;

Line 265: wf_core.context('PO_APPROVAL_LIST_WF1S',

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);
269: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_APPROVAL_LIST_WF1S.FIND_APPROVAL_LIST');

Line 268: -- wf_core.raise('Find_Approval_list E_FAILURE' || l_progress||sqlerrm);

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

Line 276: wf_core.context('PO_APPROVAL_LIST_WF1S',

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

Line 522: WF_CORE.context('PO_APPROVAL_LIST_WF1S' , 'Build_Default_Approval_list', itemtype, itemkey, l_progress);

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:
526: END Build_Default_Approval_list;

Line 643: wf_core.context('PO_APPROVAL_LIST_WF1S','Rebuild_List_Forward',l_progress,sqlerrm);

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:
647: END Rebuild_List_Forward;

Line 758: wf_core.context('PO_APPROVAL_LIST_WF1S','Rebuild_List_Doc_Changed',l_progress,sqlerrm);

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:
762: END Rebuild_List_Doc_Changed;

Line 874: wf_core.context('PO_APPROVAL_LIST_WF1S','Rebuild_List_Invalid_Approver',l_progress,sqlerrm);

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:
878: END Rebuild_List_Invalid_Approver;

Line 1024: wf_core.context('PO_APPROVAL_LIST_WF1S',

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

Line 1027: -- wf_core.raise('Get_Next_Approver E_FAILURE' || l_progress||sqlerrm);

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

Line 1035: wf_core.context('PO_APPROVAL_LIST_WF1S','Get_Next_Approver',l_progress,sqlerrm);

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:
1039: RAISE;

Line 1143: wf_core.context('PO_APPROVAL_LIST_WF1S','Is_Approver_List_Empty',l_progress,sqlerrm);

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:
1147: END Is_Approval_List_Empty;

Line 1238: wf_core.context('PO_APPROVAL_LIST_WF1S','Insert_Action_History',l_progress,sqlerrm);

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:
1242: END Insert_Action_History;

Line 1345: wf_core.context('PO_APPROVAL_LIST_WF1S','Update_Action_History_Approve',l_progress,sqlerrm);

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:
1349: END Update_Action_History_Approve;

Line 1447: wf_core.context('PO_APPROVAL_LIST_WF1S','Update_Action_History_Timeout',l_progress,sqlerrm);

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:
1451: END Update_Action_History_Timeout;

Line 1553: wf_core.context('PO_APPROVAL_LIST_WF1S','Update_Action_History_App_Fwd',l_progress,sqlerrm);

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:
1557: END Update_Action_History_App_Fwd;

Line 1657: wf_core.context('PO_APPROVAL_LIST_WF1S','Update_Action_History_Forward',l_progress,sqlerrm);

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:
1661: END Update_Action_History_Forward;

Line 1761: wf_core.context('PO_APPROVAL_LIST_WF1S','Update_Action_History_Reject',l_progress,sqlerrm);

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:
1765: END Update_Action_History_Reject;

Line 2286: wf_core.context('PO_APPROVAL_LIST_WF1S',

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

Line 2289: -- wf_core.raise('Find_Approval_list E_FAILURE' || l_progress||sqlerrm);

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

Line 2305: wf_core.context('PO_APPROVAL_LIST_WF1S',

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

Line 2633: wf_core.context('PO_APPROVAL_LIST_WF1S',

2629: IF (c_response%ISOPEN) THEN
2630: CLOSE c_response;
2631: END IF;
2632:
2633: wf_core.context('PO_APPROVAL_LIST_WF1S',
2634: 'Update_App_List_Resp_Success',l_progress,sqlerrm);
2635:
2636: RAISE;
2637: end;

Line 2859: wf_core.context('PO_APPROVAL_LIST_WF1S',

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

Line 2862: -- wf_core.raise('Find_Approval_list E_FAILURE' || l_progress||sqlerrm);

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

Line 2873: wf_core.context('PO_APPROVAL_LIST_WF1S',

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,
2877: sqlerrm, 'PO_APPROVAL_LIST_WF1S.UPDATE_APP_LIST_RESP_SUCCESS');

Line 2945: wf_core.context('PO_APPROVAL_LIST_WF1S','Create_Attach_Info_Temp',l_progress,sqlerrm);

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:
2949: END Create_Attach_Info_Temp;

Line 2986: wf_core.context('PO_APPROVAL_LIST_WFS1','set_doc_mgr_context',l_progress);

2982:
2983: EXCEPTION
2984:
2985: WHEN OTHERS THEN
2986: wf_core.context('PO_APPROVAL_LIST_WFS1','set_doc_mgr_context',l_progress);
2987: raise;
2988:
2989: END set_doc_mgr_context;
2990: --

Line 3058: wf_core.context('PO_APPROVAL_LIST_WFS1','set_doc_mgr_err',l_progress);

3054: END IF;
3055:
3056: EXCEPTION
3057: WHEN OTHERS THEN
3058: wf_core.context('PO_APPROVAL_LIST_WFS1','set_doc_mgr_err',l_progress);
3059: raise;
3060: END;
3061:
3062: /* Bug# 2684757: kagarwal

Line 3139: wf_core.context('PO_APPROVAL_LIST_WF1S','Insert_Res_Action_History',

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');
3143: RAISE;