DBA Data[Home] [Help]

APPS.OE_PURGE_WF dependencies on WF_ENGINE

Line 73: wf_engine.abortprocess(itemtype =>l_errors_tbl(i).ITEM_TYPE, itemkey=>l_errors_tbl(i).item_key);

69: IF g_debug_level > 0 THEN
70: oe_debug_pub.add( 'Setting the error parent to null and aborting the flow',5);
71: END IF ;
72: WF_ITEM.Set_Item_Parent(l_errors_tbl(i).ITEM_TYPE,l_errors_tbl(i).ITEM_KEY,NULL,NULL,NULL);
73: wf_engine.abortprocess(itemtype =>l_errors_tbl(i).ITEM_TYPE, itemkey=>l_errors_tbl(i).item_key);
74: EXCEPTION
75: WHEN OTHERS THEN
76: UPDATE wf_items
77: SET end_date = sysdate

Line 109: wf_engine.abortprocess(itemtype =>l_errors_tbl(i).ITEM_TYPE, itemkey=>l_errors_tbl(i).item_key);

105: IF g_debug_level > 0 THEN
106: oe_debug_pub.add( 'Setting the error parent to null and aborting the flow for the specific key',5);
107: END IF ;
108: WF_ITEM.Set_Item_Parent(l_errors_tbl(i).ITEM_TYPE,l_errors_tbl(i).ITEM_KEY,NULL,NULL,NULL);
109: wf_engine.abortprocess(itemtype =>l_errors_tbl(i).ITEM_TYPE, itemkey=>l_errors_tbl(i).item_key);
110: EXCEPTION
111: WHEN OTHERS THEN
112: UPDATE wf_items
113: SET end_date = sysdate

Line 247: WF_ENGINE.ABORTPROCESS(ITEMTYPE =>l_error_tbl(j).ITEM_TYPE, ITEMKEY=>l_error_tbl(j).ITEM_KEY);

243: IF g_debug_level > 0 THEN
244: oe_debug_pub.ADD('Clearing the parent info from the error and aborting the error flow.',1 ) ;
245: END IF;
246: WF_ITEM.Set_Item_Parent(l_error_tbl(j).ITEM_TYPE,l_error_tbl(j).ITEM_KEY,NULL,NULL,NULL);
247: WF_ENGINE.ABORTPROCESS(ITEMTYPE =>l_error_tbl(j).ITEM_TYPE, ITEMKEY=>l_error_tbl(j).ITEM_KEY);
248: EXCEPTION
249: WHEN OTHERS THEN
250: UPDATE WF_ITEMS
251: SET END_DATE = SYSDATE

Line 280: WF_ENGINE.HANDLEERROR('OEOH', l_wf_details_tbl(i).item_key, l_wf_details_tbl(i).INSTANCE_LABEL, 'RETRY',NULL);

276: END;
277: IF g_debug_level > 0 THEN
278: oe_debug_pub.ADD('Retrying the close_wait_for_l activity',2 ) ;
279: END IF;
280: WF_ENGINE.HANDLEERROR('OEOH', l_wf_details_tbl(i).item_key, l_wf_details_tbl(i).INSTANCE_LABEL, 'RETRY',NULL);
281: EXCEPTION
282: WHEN OTHERS THEN
283: NULL;
284: END;

Line 320: WF_ENGINE.ABORTPROCESS(ITEMTYPE =>l_error_tbl(j).ITEM_TYPE, ITEMKEY=>l_error_tbl(j).ITEM_KEY);

316: IF g_debug_level > 0 THEN
317: oe_debug_pub.ADD('Removing the parent reference and aborting the error flow',1 ) ;
318: END IF;
319: WF_ITEM.Set_Item_Parent(l_error_tbl(j).ITEM_TYPE,l_error_tbl(j).ITEM_KEY,NULL,NULL,NULL);
320: WF_ENGINE.ABORTPROCESS(ITEMTYPE =>l_error_tbl(j).ITEM_TYPE, ITEMKEY=>l_error_tbl(j).ITEM_KEY);
321: EXCEPTION
322: WHEN OTHERS THEN
323: UPDATE WF_ITEMS
324: SET END_DATE = SYSDATE

Line 353: WF_ENGINE.HANDLEERROR('OEOH', l_wf_details_tbl(i).item_key, l_wf_details_tbl(i).INSTANCE_LABEL, 'RETRY',NULL);

349: END;
350: IF g_debug_level > 0 THEN
351: oe_debug_pub.ADD('Retrying close_wait_for_l activity for the header',2) ;
352: END IF;
353: WF_ENGINE.HANDLEERROR('OEOH', l_wf_details_tbl(i).item_key, l_wf_details_tbl(i).INSTANCE_LABEL, 'RETRY',NULL);
354: EXCEPTION
355: WHEN OTHERS THEN
356: NULL;
357: END;