DBA Data[Home] [Help]

APPS.POR_AME_REQ_WF_PVT dependencies on WF_CORE

Line 179: wf_core.context('POR_AME_REQ_WF_PVT','Get_Next_Approvers: Unable to get the next approvers from AME.',l_progress,sqlerrm);

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);
183: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_doc_string);

Line 248: wf_core.context('POR_AME_REQ_WF_PVT','Get_Next_Approvers - Unexpected Exception: ',l_progress,sqlerrm);

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);
252: END IF;

Line 945: wf_core.context('POR_AME_REQ_WF_PVT','Launch_Parallel_Approval-NO_DATA_FOUND Exception:',l_progress,sqlerrm);

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 );
949: END IF;

Line 956: wf_core.context('POR_AME_REQ_WF_PVT','Launch_Parallel_Approval-Unexpected Exception:',l_progress,sqlerrm);

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 );
960: END IF;

Line 1587: wf_core.context('POR_AME_REQ_WF_PVT','Process_Beat_By_First',l_progress,sqlerrm);

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:
1591: end Process_Beat_By_First;

Line 2385: wf_core.context('POR_AME_REQ_WF_PVT','Insert_Action_History',l_progress,sqlerrm);

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

Line 2535: wf_core.context('POR_AME_REQ_WF_PVT','Update_Action_History_Approve',l_progress,sqlerrm);

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

Line 2685: wf_core.context('POR_AME_REQ_WF_PVT','Update_Action_History_Reject',l_progress,sqlerrm);

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

Line 2829: wf_core.context('POR_AME_REQ_WF_PVT','Update_Action_History_Timeout',l_progress,sqlerrm);

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

Line 2973: wf_core.context('POR_AME_REQ_WF_PVT','Update_Action_History_Forward',l_progress,sqlerrm);

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

Line 3077: wf_core.context('POR_AME_REQ_WF_PVT','Update_Action_History_No_Act',x_progress);

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

Line 3193: wf_core.context('POR_AME_REQ_WF_PVT','IS_AME_EXCEPTION: Unexpected Exception:',l_progress,sqlerrm);

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;
3197: raise;