eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_DEBUG_UTIL dependencies on UTL_FILE

Line 347: p_output_file IN utl_file.file_type,

343: None
344: */
345:
346: PROCEDURE print_cursor_data_csv_pvt(
347: p_output_file IN utl_file.file_type,
348: p_cursor in INTEGER
349: )
350: IS
351: l_routine VARCHAR2(240):='Routine : QP_DEBUG_UTIL.PRINT_CURSOR_DATA_CSV_PVT';

Line 359: l_output_file utl_file.file_type;

355: l_col_val varchar2(32767);
356: l_hdr_string VARCHAR2(32767);
357: l_row_string VARCHAR2(32767);
358:
359: l_output_file utl_file.file_type;
360: filePath varchar2(1000);
361: fileName varchar2(1000);
362:
363: BEGIN

Line 385: utl_file.put_line(l_output_file,l_hdr_string);

381: END IF;
382:
383: end loop;
384:
385: utl_file.put_line(l_output_file,l_hdr_string);
386:
387: --printing rows
388:
389: l_status := dbms_sql.execute(p_cursor);

Line 409: utl_file.put_line(l_output_file,l_row_string);

405: END IF;
406:
407: end loop;
408:
409: utl_file.put_line(l_output_file,l_row_string);
410:
411: END LOOP;
412:
413: EXCEPTION

Line 454: l_output_file utl_file.file_type;

450: l_first_time BOOLEAN := TRUE;
451:
452: --l_prcng_event VARCHAR2(30);
453:
454: l_output_file utl_file.file_type;
455: filePath varchar2(1000);
456: fileName varchar2(1000);
457:
458: l_file_ids_tbl file_id_list_tbl;

Line 514: l_output_file := utl_file.fopen( filePath, fileName||'.csv', l_mode ,32000 );

510:
511: fileName := fileName|| '_' || p_file_id || '_' ||
512: SUBSTR(OE_DEBUG_PUB.G_FILE,1,INSTR(OE_DEBUG_PUB.G_FILE,'.dbg')-1);
513:
514: l_output_file := utl_file.fopen( filePath, fileName||'.csv', l_mode ,32000 );
515:
516: qp_preq_grp.engine_debug('Dumping data in file - ' || filePath || '/' ||fileName||'.csv');
517:
518:

Line 545: utl_file.put_line(l_output_file,l_hdr_string);

541:
542: end loop;
543:
544: IF l_first_time THEN
545: utl_file.put_line(l_output_file,l_hdr_string);
546: END IF;
547:
548: --printing rows
549:

Line 576: utl_file.put_line(l_output_file,l_row_string);

572: END IF;
573:
574: end loop;
575:
576: utl_file.put_line(l_output_file,l_row_string);
577:
578: END LOOP;
579:
580: utl_file.fclose( l_output_file );

Line 580: utl_file.fclose( l_output_file );

576: utl_file.put_line(l_output_file,l_row_string);
577:
578: END LOOP;
579:
580: utl_file.fclose( l_output_file );
581:
582: EXCEPTION
583: WHEN OTHERS THEN
584:

Line 585: IF utl_file.is_open(l_output_file) THEN

581:
582: EXCEPTION
583: WHEN OTHERS THEN
584:
585: IF utl_file.is_open(l_output_file) THEN
586: utl_file.fclose( l_output_file );
587: END IF;
588:
589: IF qp_preq_grp.G_DEBUG_ENGINE = FND_API.G_TRUE THEN

Line 586: utl_file.fclose( l_output_file );

582: EXCEPTION
583: WHEN OTHERS THEN
584:
585: IF utl_file.is_open(l_output_file) THEN
586: utl_file.fclose( l_output_file );
587: END IF;
588:
589: IF qp_preq_grp.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
590: qp_preq_grp.engine_debug('Exception occured - '||l_routine);

Line 759: p_outputfile_id utl_file.file_type,

755: None
756: */
757:
758: PROCEDURE print_blank_rows_csv (
759: p_outputfile_id utl_file.file_type,
760: p_row_count number
761: )
762: IS
763: l_routine VARCHAR2(240):='Routine : QP_DEBUG_UTIL.PRINT_BLANK_ROWS_CSV';

Line 767: utl_file.put_line(p_outputfile_id,' ');

763: l_routine VARCHAR2(240):='Routine : QP_DEBUG_UTIL.PRINT_BLANK_ROWS_CSV';
764: BEGIN
765: FOR i IN 1..p_row_count
766: LOOP
767: utl_file.put_line(p_outputfile_id,' ');
768: END LOOP;
769:
770: EXCEPTION
771: WHEN OTHERS THEN

Line 796: l_output_file utl_file.file_type;

792: PROCEDURE print_querylist_data_csv (
793: p_query_list IN query_list,
794: p_file_id IN VARCHAR2 )
795: IS
796: l_output_file utl_file.file_type;
797: filePath varchar2(1000);
798: fileName varchar2(1000);
799:
800: l_routine VARCHAR2(240):='Routine : QP_DEBUG_UTIL.PRINT_QUERYLIST_DATA_CSV';

Line 825: l_output_file := utl_file.fopen( filePath, fileName||'.csv', 'w',32000 );

821: SELECT fnd_profile.value('OE_DEBUG_LOG_DIRECTORY')
822: INTO filePath
823: FROM dual;
824:
825: l_output_file := utl_file.fopen( filePath, fileName||'.csv', 'w',32000 );
826:
827: qp_preq_grp.engine_debug('Dumping data in file - ' || filePath || '/' ||fileName||'.csv');
828:
829: FOR i IN p_query_list.first..p_query_list.last

Line 848: utl_file.fclose( l_output_file );

844: dbms_sql.close_cursor( l_cursor );
845:
846: END LOOP;
847:
848: utl_file.fclose( l_output_file );
849:
850: END IF;
851:
852: EXCEPTION

Line 855: IF utl_file.is_open(l_output_file) THEN

851:
852: EXCEPTION
853: WHEN OTHERS THEN
854:
855: IF utl_file.is_open(l_output_file) THEN
856: utl_file.fclose( l_output_file );
857: END IF;
858:
859: IF DBMS_SQL.IS_OPEN (l_cursor) THEN

Line 856: utl_file.fclose( l_output_file );

852: EXCEPTION
853: WHEN OTHERS THEN
854:
855: IF utl_file.is_open(l_output_file) THEN
856: utl_file.fclose( l_output_file );
857: END IF;
858:
859: IF DBMS_SQL.IS_OPEN (l_cursor) THEN
860: dbms_sql.close_cursor( l_cursor );