DBA Data[Home] [Help]

APPS.OE_PURGE_WF dependencies on FND_FILE

Line 439: oe_debug_pub.add(FND_FILE.OUTPUT,sqlerrm);

435: oe_debug_pub.add( 'Exiting oe_purge_wf.purge_item_type',1 ) ;
436: END IF;
437: EXCEPTION
438: WHEN OTHERS THEN
439: oe_debug_pub.add(FND_FILE.OUTPUT,sqlerrm);
440: l_purge_tbl.DELETE ;
441: IF to_purge%isopen THEN
442: CLOSE to_purge;
443: END IF ;

Line 578: fnd_file.put_line(FND_FILE.OUTPUT,'Item type cannot be null when item key is not null. ' ) ;

574: IF g_debug_level > 0 THEN
575: oe_debug_pub.add( 'item type passed is all item types');
576: END IF ;
577: IF p_item_key IS NOT NULL THEN
578: fnd_file.put_line(FND_FILE.OUTPUT,'Item type cannot be null when item key is not null. ' ) ;
579: IF g_debug_level > 0 THEN
580: oe_debug_pub.add( 'Item type cannot be null when item key is not null. ' ) ;
581: END IF;
582: ELSE

Line 617: fnd_file.put_line(FND_FILE.OUTPUT,'Number of workflow items Purged is:'|| g_purge_count);

613: END IF;
614: END IF;
615: errbuf := '';
616: retcode := '0';
617: fnd_file.put_line(FND_FILE.OUTPUT,'Number of workflow items Purged is:'|| g_purge_count);
618: EXCEPTION
619: WHEN NO_DATA_FOUND THEN
620: NULL;
621: WHEN OTHERS THEN

Line 624: oe_debug_pub.add(FND_FILE.OUTPUT,sqlerrm);

620: NULL;
621: WHEN OTHERS THEN
622: g_age :=0;
623: g_commit_frequency:=500;
624: oe_debug_pub.add(FND_FILE.OUTPUT,sqlerrm);
625: retcode := 2;
626: errbuf := sqlerrm;
627: l_purge_tbl.DELETE ;
628: IF purge_all%isopen THEN