551: l_tab VARCHARTAB;
552:
553: BEGIN
554:
555: FND_FILE.put_line(FND_file.output,' ');
556: FND_FILE.put_line(FND_file.output,' ');
557: FND_FILE.put_line(FND_file.output,' ');
558: FND_FILE.put_line(FND_file.output,' ');
559: FND_FILE.put_line(FND_file.output,' ');
552:
553: BEGIN
554:
555: FND_FILE.put_line(FND_file.output,' ');
556: FND_FILE.put_line(FND_file.output,' ');
557: FND_FILE.put_line(FND_file.output,' ');
558: FND_FILE.put_line(FND_file.output,' ');
559: FND_FILE.put_line(FND_file.output,' ');
560: FND_FILE.put_line(FND_file.output,' ');
553: BEGIN
554:
555: FND_FILE.put_line(FND_file.output,' ');
556: FND_FILE.put_line(FND_file.output,' ');
557: FND_FILE.put_line(FND_file.output,' ');
558: FND_FILE.put_line(FND_file.output,' ');
559: FND_FILE.put_line(FND_file.output,' ');
560: FND_FILE.put_line(FND_file.output,' ');
561: FND_FILE.put_line(FND_file.output,'**************************************************************************************************');
554:
555: FND_FILE.put_line(FND_file.output,' ');
556: FND_FILE.put_line(FND_file.output,' ');
557: FND_FILE.put_line(FND_file.output,' ');
558: FND_FILE.put_line(FND_file.output,' ');
559: FND_FILE.put_line(FND_file.output,' ');
560: FND_FILE.put_line(FND_file.output,' ');
561: FND_FILE.put_line(FND_file.output,'**************************************************************************************************');
562: FND_FILE.put_line(FND_file.output,' Rollback Report ');
555: FND_FILE.put_line(FND_file.output,' ');
556: FND_FILE.put_line(FND_file.output,' ');
557: FND_FILE.put_line(FND_file.output,' ');
558: FND_FILE.put_line(FND_file.output,' ');
559: FND_FILE.put_line(FND_file.output,' ');
560: FND_FILE.put_line(FND_file.output,' ');
561: FND_FILE.put_line(FND_file.output,'**************************************************************************************************');
562: FND_FILE.put_line(FND_file.output,' Rollback Report ');
563: FND_FILE.put_line(FND_file.output,'**************************************************************************************************');
556: FND_FILE.put_line(FND_file.output,' ');
557: FND_FILE.put_line(FND_file.output,' ');
558: FND_FILE.put_line(FND_file.output,' ');
559: FND_FILE.put_line(FND_file.output,' ');
560: FND_FILE.put_line(FND_file.output,' ');
561: FND_FILE.put_line(FND_file.output,'**************************************************************************************************');
562: FND_FILE.put_line(FND_file.output,' Rollback Report ');
563: FND_FILE.put_line(FND_file.output,'**************************************************************************************************');
564: FND_FILE.put_line(FND_file.output,' ');
557: FND_FILE.put_line(FND_file.output,' ');
558: FND_FILE.put_line(FND_file.output,' ');
559: FND_FILE.put_line(FND_file.output,' ');
560: FND_FILE.put_line(FND_file.output,' ');
561: FND_FILE.put_line(FND_file.output,'**************************************************************************************************');
562: FND_FILE.put_line(FND_file.output,' Rollback Report ');
563: FND_FILE.put_line(FND_file.output,'**************************************************************************************************');
564: FND_FILE.put_line(FND_file.output,' ');
565: FND_FILE.put_line(FND_file.output,' ');
558: FND_FILE.put_line(FND_file.output,' ');
559: FND_FILE.put_line(FND_file.output,' ');
560: FND_FILE.put_line(FND_file.output,' ');
561: FND_FILE.put_line(FND_file.output,'**************************************************************************************************');
562: FND_FILE.put_line(FND_file.output,' Rollback Report ');
563: FND_FILE.put_line(FND_file.output,'**************************************************************************************************');
564: FND_FILE.put_line(FND_file.output,' ');
565: FND_FILE.put_line(FND_file.output,' ');
566: FND_FILE.put_line(FND_file.output,' ');
559: FND_FILE.put_line(FND_file.output,' ');
560: FND_FILE.put_line(FND_file.output,' ');
561: FND_FILE.put_line(FND_file.output,'**************************************************************************************************');
562: FND_FILE.put_line(FND_file.output,' Rollback Report ');
563: FND_FILE.put_line(FND_file.output,'**************************************************************************************************');
564: FND_FILE.put_line(FND_file.output,' ');
565: FND_FILE.put_line(FND_file.output,' ');
566: FND_FILE.put_line(FND_file.output,' ');
567:
560: FND_FILE.put_line(FND_file.output,' ');
561: FND_FILE.put_line(FND_file.output,'**************************************************************************************************');
562: FND_FILE.put_line(FND_file.output,' Rollback Report ');
563: FND_FILE.put_line(FND_file.output,'**************************************************************************************************');
564: FND_FILE.put_line(FND_file.output,' ');
565: FND_FILE.put_line(FND_file.output,' ');
566: FND_FILE.put_line(FND_file.output,' ');
567:
568:
561: FND_FILE.put_line(FND_file.output,'**************************************************************************************************');
562: FND_FILE.put_line(FND_file.output,' Rollback Report ');
563: FND_FILE.put_line(FND_file.output,'**************************************************************************************************');
564: FND_FILE.put_line(FND_file.output,' ');
565: FND_FILE.put_line(FND_file.output,' ');
566: FND_FILE.put_line(FND_file.output,' ');
567:
568:
569: OPEN get_log;
562: FND_FILE.put_line(FND_file.output,' Rollback Report ');
563: FND_FILE.put_line(FND_file.output,'**************************************************************************************************');
564: FND_FILE.put_line(FND_file.output,' ');
565: FND_FILE.put_line(FND_file.output,' ');
566: FND_FILE.put_line(FND_file.output,' ');
567:
568:
569: OPEN get_log;
570: LOOP
572: EXIT WHEN l_tab.COUNT = 0;
573:
574: FOR i IN l_tab.FIRST..l_tab.LAST
575: LOOP
576: FND_FILE.put_line(FND_file.output,l_tab(i));
577: END LOOP;
578: END LOOP;
579: CLOSE get_log;
580:
3488: IF g_debug
3489: THEN
3490: hr_utility.trace(p_text);
3491: END IF;
3492: FND_FILE.put_line(FND_FILE.log,p_text);
3493: --dbms_output.put_line(p_text);
3494:
3495: IF p_cache = 'Y'
3496: THEN