DBA Data[Home] [Help]

APPS.OE_ORDER_IMPORT_WF dependencies on WF_PURGE

Line 310: PROCEDURE CALL_WF_PURGE

306:
307: END OEOA_SELECTOR;
308:
309:
310: PROCEDURE CALL_WF_PURGE
311: ( p_itemtype in varchar2,
312: p_itemkey in varchar2
313: )
314: IS

Line 326: WF_PURGE.ITEMS(p_itemtype, p_itemkey, sysdate, TRUE);

322: Where ITEM_TYPE = p_itemtype
323: And ITEM_KEY = p_itemkey;
324:
325: if sql%rowcount > 0 then
326: WF_PURGE.ITEMS(p_itemtype, p_itemkey, sysdate, TRUE);
327: end if;
328:
329: EXCEPTION
330: WHEN OTHERS THEN

Line 332: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'CALL_WF_PURGE');

328:
329: EXCEPTION
330: WHEN OTHERS THEN
331: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
332: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'CALL_WF_PURGE');
333: END IF;
334: IF l_debug_level > 0 THEN
335: oe_debug_pub.add( 'OTHERS IN CALL_WF_PURGE MESSAGE : '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
336: END IF;

Line 335: oe_debug_pub.add( 'OTHERS IN CALL_WF_PURGE MESSAGE : '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;

331: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
332: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'CALL_WF_PURGE');
333: END IF;
334: IF l_debug_level > 0 THEN
335: oe_debug_pub.add( 'OTHERS IN CALL_WF_PURGE MESSAGE : '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
336: END IF;
337: END CALL_WF_PURGE;
338:
339: PROCEDURE START_ORDER_IMPORT

Line 337: END CALL_WF_PURGE;

333: END IF;
334: IF l_debug_level > 0 THEN
335: oe_debug_pub.add( 'OTHERS IN CALL_WF_PURGE MESSAGE : '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
336: END IF;
337: END CALL_WF_PURGE;
338:
339: PROCEDURE START_ORDER_IMPORT
340: ( p_itemtype in varchar2,
341: p_itemkey in varchar2,