DBA Data[Home] [Help]

APPS.POR_AME_REQ_WF_PVT dependencies on PO_REQAPPROVAL_INIT1

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

173:
174: EXCEPTION
175: WHEN OTHERS THEN
176:
177: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
178: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
179: wf_core.context('POR_AME_REQ_WF_PVT','Get_Next_Approvers: Unable to get the next approvers from AME.',l_progress,sqlerrm);
180:
181: IF (g_po_wf_debug = 'Y') THEN

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

174: EXCEPTION
175: WHEN OTHERS THEN
176:
177: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
178: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
179: wf_core.context('POR_AME_REQ_WF_PVT','Get_Next_Approvers: Unable to get the next approvers from AME.',l_progress,sqlerrm);
180:
181: IF (g_po_wf_debug = 'Y') THEN
182: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,'POR_AME_REQ_WF_PVT Get_Next_Approvers: Unable to get the next approvers from AME.'||l_progress||sqlerrm);

Line 186: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.GET_NEXT_APPROVERS',l_document_id);

182: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,'POR_AME_REQ_WF_PVT Get_Next_Approvers: Unable to get the next approvers from AME.'||l_progress||sqlerrm);
183: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_doc_string);
184: END IF;
185:
186: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.GET_NEXT_APPROVERS',l_document_id);
187:
188: resultout:='COMPLETE:'||'INVALID_APPROVER';
189: return;
190: END;

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

242: end if;
243: EXCEPTION
244: WHEN OTHERS THEN
245:
246: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
247: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
248: wf_core.context('POR_AME_REQ_WF_PVT','Get_Next_Approvers - Unexpected Exception: ',l_progress,sqlerrm);
249:
250: IF (g_po_wf_debug = 'Y') THEN

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

243: EXCEPTION
244: WHEN OTHERS THEN
245:
246: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
247: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
248: wf_core.context('POR_AME_REQ_WF_PVT','Get_Next_Approvers - Unexpected Exception: ',l_progress,sqlerrm);
249:
250: IF (g_po_wf_debug = 'Y') THEN
251: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_doc_string);

Line 254: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.GET_NEXT_APPROVERS');

250: IF (g_po_wf_debug = 'Y') THEN
251: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_doc_string);
252: END IF;
253:
254: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.GET_NEXT_APPROVERS');
255: resultout:='COMPLETE:'||'INVALID_APPROVER';
256: return;
257: END Get_Next_Approvers;
258:

Line 943: l_doc_string := l_progress || PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

939:
940: exception
941: when NO_DATA_FOUND then
942: l_progress:= '50: start_wf_line_process: NO_DATA_FOUND -- EXCEPTION';
943: l_doc_string := l_progress || PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
944: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
945: wf_core.context('POR_AME_REQ_WF_PVT','Launch_Parallel_Approval-NO_DATA_FOUND Exception:',l_progress,sqlerrm);
946:
947: IF (g_po_wf_debug = 'Y') THEN

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

940: exception
941: when NO_DATA_FOUND then
942: l_progress:= '50: start_wf_line_process: NO_DATA_FOUND -- EXCEPTION';
943: l_doc_string := l_progress || PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
944: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
945: wf_core.context('POR_AME_REQ_WF_PVT','Launch_Parallel_Approval-NO_DATA_FOUND Exception:',l_progress,sqlerrm);
946:
947: IF (g_po_wf_debug = 'Y') THEN
948: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_doc_string );

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

946:
947: IF (g_po_wf_debug = 'Y') THEN
948: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_doc_string );
949: END IF;
950: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.GET_NEXT_APPROVER');
951: raise;
952: when others then
953: l_progress:= '50: start_wf_line_process: IN EXCEPTION';
954: l_doc_string := l_progress || PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

Line 954: l_doc_string := l_progress || PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

950: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.GET_NEXT_APPROVER');
951: raise;
952: when others then
953: l_progress:= '50: start_wf_line_process: IN EXCEPTION';
954: l_doc_string := l_progress || PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
955: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
956: wf_core.context('POR_AME_REQ_WF_PVT','Launch_Parallel_Approval-Unexpected Exception:',l_progress,sqlerrm);
957:
958: IF (g_po_wf_debug = 'Y') THEN

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

951: raise;
952: when others then
953: l_progress:= '50: start_wf_line_process: IN EXCEPTION';
954: l_doc_string := l_progress || PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
955: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
956: wf_core.context('POR_AME_REQ_WF_PVT','Launch_Parallel_Approval-Unexpected Exception:',l_progress,sqlerrm);
957:
958: IF (g_po_wf_debug = 'Y') THEN
959: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_doc_string );

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

958: IF (g_po_wf_debug = 'Y') THEN
959: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_doc_string );
960: END IF;
961:
962: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.GET_NEXT_APPROVER');
963: raise;
964:
965: end Launch_Parallel_Approval;
966:

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

1581: RETURN;
1582:
1583: exception
1584: when others then
1585: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1586: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1587: wf_core.context('POR_AME_REQ_WF_PVT','Process_Beat_By_First',l_progress,sqlerrm);
1588: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.Process_Beat_By_First');
1589: RAISE;

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

1582:
1583: exception
1584: when others then
1585: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1586: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1587: wf_core.context('POR_AME_REQ_WF_PVT','Process_Beat_By_First',l_progress,sqlerrm);
1588: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.Process_Beat_By_First');
1589: RAISE;
1590:

Line 1588: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.Process_Beat_By_First');

1584: when others then
1585: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1586: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1587: wf_core.context('POR_AME_REQ_WF_PVT','Process_Beat_By_First',l_progress,sqlerrm);
1588: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.Process_Beat_By_First');
1589: RAISE;
1590:
1591: end Process_Beat_By_First;
1592:

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

2379: END IF;
2380:
2381: EXCEPTION
2382: WHEN OTHERS THEN
2383: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2384: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2385: wf_core.context('POR_AME_REQ_WF_PVT','Insert_Action_History',l_progress,sqlerrm);
2386: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.INSERT_ACTION_HISTORY');
2387: RAISE;

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

2380:
2381: EXCEPTION
2382: WHEN OTHERS THEN
2383: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2384: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2385: wf_core.context('POR_AME_REQ_WF_PVT','Insert_Action_History',l_progress,sqlerrm);
2386: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.INSERT_ACTION_HISTORY');
2387: RAISE;
2388: END Insert_Action_History;

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

2382: WHEN OTHERS THEN
2383: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2384: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2385: wf_core.context('POR_AME_REQ_WF_PVT','Insert_Action_History',l_progress,sqlerrm);
2386: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.INSERT_ACTION_HISTORY');
2387: RAISE;
2388: END Insert_Action_History;
2389:
2390:

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

2529:
2530:
2531: EXCEPTION
2532: WHEN OTHERS THEN
2533: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2534: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2535: wf_core.context('POR_AME_REQ_WF_PVT','Update_Action_History_Approve',l_progress,sqlerrm);
2536: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.UPDATE_ACTION_HISTORY_APPROVE');
2537: RAISE;

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

2530:
2531: EXCEPTION
2532: WHEN OTHERS THEN
2533: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2534: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2535: wf_core.context('POR_AME_REQ_WF_PVT','Update_Action_History_Approve',l_progress,sqlerrm);
2536: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.UPDATE_ACTION_HISTORY_APPROVE');
2537: RAISE;
2538:

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

2532: WHEN OTHERS THEN
2533: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2534: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2535: wf_core.context('POR_AME_REQ_WF_PVT','Update_Action_History_Approve',l_progress,sqlerrm);
2536: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.UPDATE_ACTION_HISTORY_APPROVE');
2537: RAISE;
2538:
2539: END Update_Action_History_Approve;
2540:

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

2679: END IF;
2680:
2681: EXCEPTION
2682: WHEN OTHERS THEN
2683: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2684: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2685: wf_core.context('POR_AME_REQ_WF_PVT','Update_Action_History_Reject',l_progress,sqlerrm);
2686: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.Update_Action_History_Reject');
2687: RAISE;

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

2680:
2681: EXCEPTION
2682: WHEN OTHERS THEN
2683: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2684: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2685: wf_core.context('POR_AME_REQ_WF_PVT','Update_Action_History_Reject',l_progress,sqlerrm);
2686: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.Update_Action_History_Reject');
2687: RAISE;
2688:

Line 2686: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.Update_Action_History_Reject');

2682: WHEN OTHERS THEN
2683: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2684: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2685: wf_core.context('POR_AME_REQ_WF_PVT','Update_Action_History_Reject',l_progress,sqlerrm);
2686: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.Update_Action_History_Reject');
2687: RAISE;
2688:
2689: END Update_Action_History_Reject;
2690:

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

2823: END IF;
2824:
2825: EXCEPTION
2826: WHEN OTHERS THEN
2827: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2828: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2829: wf_core.context('POR_AME_REQ_WF_PVT','Update_Action_History_Timeout',l_progress,sqlerrm);
2830: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.Update_Action_History_Timeout');
2831: RAISE;

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

2824:
2825: EXCEPTION
2826: WHEN OTHERS THEN
2827: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2828: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2829: wf_core.context('POR_AME_REQ_WF_PVT','Update_Action_History_Timeout',l_progress,sqlerrm);
2830: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.Update_Action_History_Timeout');
2831: RAISE;
2832:

Line 2830: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.Update_Action_History_Timeout');

2826: WHEN OTHERS THEN
2827: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2828: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2829: wf_core.context('POR_AME_REQ_WF_PVT','Update_Action_History_Timeout',l_progress,sqlerrm);
2830: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.Update_Action_History_Timeout');
2831: RAISE;
2832:
2833: END Update_Action_History_Timeout;
2834:

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

2967:
2968:
2969: EXCEPTION
2970: WHEN OTHERS THEN
2971: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2972: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2973: wf_core.context('POR_AME_REQ_WF_PVT','Update_Action_History_Forward',l_progress,sqlerrm);
2974: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.UPDATE_ACTION_HISTORY_FORWARD');
2975: RAISE;

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

2968:
2969: EXCEPTION
2970: WHEN OTHERS THEN
2971: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2972: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2973: wf_core.context('POR_AME_REQ_WF_PVT','Update_Action_History_Forward',l_progress,sqlerrm);
2974: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.UPDATE_ACTION_HISTORY_FORWARD');
2975: RAISE;
2976:

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

2970: WHEN OTHERS THEN
2971: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2972: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2973: wf_core.context('POR_AME_REQ_WF_PVT','Update_Action_History_Forward',l_progress,sqlerrm);
2974: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.UPDATE_ACTION_HISTORY_FORWARD');
2975: RAISE;
2976:
2977: END Update_Action_History_Forward;
2978:

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

3071: END IF;
3072:
3073: EXCEPTION
3074: WHEN OTHERS THEN
3075: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
3076: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
3077: wf_core.context('POR_AME_REQ_WF_PVT','Update_Action_History_No_Act',x_progress);
3078: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.Update_Action_History_No_Act');
3079: raise;

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

3072:
3073: EXCEPTION
3074: WHEN OTHERS THEN
3075: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
3076: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
3077: wf_core.context('POR_AME_REQ_WF_PVT','Update_Action_History_No_Act',x_progress);
3078: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.Update_Action_History_No_Act');
3079: raise;
3080: END Update_Action_History_No_Act;

Line 3078: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.Update_Action_History_No_Act');

3074: WHEN OTHERS THEN
3075: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
3076: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
3077: wf_core.context('POR_AME_REQ_WF_PVT','Update_Action_History_No_Act',x_progress);
3078: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.Update_Action_History_No_Act');
3079: raise;
3080: END Update_Action_History_No_Act;
3081:
3082: --------------------------------------------------------------------------------

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

3188: end if;
3189: END IF;
3190: EXCEPTION
3191: when others then
3192: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
3193: wf_core.context('POR_AME_REQ_WF_PVT','IS_AME_EXCEPTION: Unexpected Exception:',l_progress,sqlerrm);
3194: IF (g_po_wf_debug = 'Y') THEN
3195: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_doc_string );
3196: END IF;