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 QP_PREQ_GRP

Line 416: IF qp_preq_grp.G_DEBUG_ENGINE = FND_API.G_TRUE THEN

412:
413: EXCEPTION
414: WHEN OTHERS THEN
415:
416: IF qp_preq_grp.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
417: qp_preq_grp.engine_debug('Exception occured - '||l_routine);
418: qp_preq_grp.engine_debug('Error Message - '||SQLERRM);
419: END IF;
420:

Line 417: qp_preq_grp.engine_debug('Exception occured - '||l_routine);

413: EXCEPTION
414: WHEN OTHERS THEN
415:
416: IF qp_preq_grp.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
417: qp_preq_grp.engine_debug('Exception occured - '||l_routine);
418: qp_preq_grp.engine_debug('Error Message - '||SQLERRM);
419: END IF;
420:
421: END print_cursor_data_csv_pvt;

Line 418: qp_preq_grp.engine_debug('Error Message - '||SQLERRM);

414: WHEN OTHERS THEN
415:
416: IF qp_preq_grp.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
417: qp_preq_grp.engine_debug('Exception occured - '||l_routine);
418: qp_preq_grp.engine_debug('Error Message - '||SQLERRM);
419: END IF;
420:
421: END print_cursor_data_csv_pvt;
422:

Line 480: qp_preq_grp.engine_debug('file id'||p_file_id||' exist');

476:
477: IF p_append THEN
478:
479: IF g_file_ids_tbl.EXISTS(p_file_id) THEN
480: qp_preq_grp.engine_debug('file id'||p_file_id||' exist');
481: l_first_time := FALSE;
482: l_csv_count := g_file_ids_tbl(p_file_id);
483: ELSE
484: qp_preq_grp.engine_debug('file id '||p_file_id||' does not exist');

Line 484: qp_preq_grp.engine_debug('file id '||p_file_id||' does not exist');

480: qp_preq_grp.engine_debug('file id'||p_file_id||' exist');
481: l_first_time := FALSE;
482: l_csv_count := g_file_ids_tbl(p_file_id);
483: ELSE
484: qp_preq_grp.engine_debug('file id '||p_file_id||' does not exist');
485: g_csv_count := g_csv_count+1;
486: l_csv_count := g_csv_count;
487: g_file_ids_tbl(p_file_id) := l_csv_count;
488: END IF;

Line 501: qp_preq_grp.engine_debug('l_csv_count-'||l_csv_count);

497: l_mode := 'w';
498:
499: END IF;
500:
501: qp_preq_grp.engine_debug('l_csv_count-'||l_csv_count);
502: qp_preq_grp.engine_debug('l_mode-'||l_mode);
503:
504: fileName := l_csv_count;
505:

Line 502: qp_preq_grp.engine_debug('l_mode-'||l_mode);

498:
499: END IF;
500:
501: qp_preq_grp.engine_debug('l_csv_count-'||l_csv_count);
502: qp_preq_grp.engine_debug('l_mode-'||l_mode);
503:
504: fileName := l_csv_count;
505:
506: IF p_append = FALSE

Line 516: qp_preq_grp.engine_debug('Dumping data in file - ' || filePath || '/' ||fileName||'.csv');

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:
519:
520: --getting column details in l_cols_desc

Line 589: IF qp_preq_grp.G_DEBUG_ENGINE = FND_API.G_TRUE THEN

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);
591: qp_preq_grp.engine_debug('Error Message - '||SQLERRM);
592: END IF;
593:

Line 590: qp_preq_grp.engine_debug('Exception occured - '||l_routine);

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);
591: qp_preq_grp.engine_debug('Error Message - '||SQLERRM);
592: END IF;
593:
594: END print_cursor_data_csv_pvt;

Line 591: qp_preq_grp.engine_debug('Error Message - '||SQLERRM);

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);
591: qp_preq_grp.engine_debug('Error Message - '||SQLERRM);
592: END IF;
593:
594: END print_cursor_data_csv_pvt;
595:

Line 632: qp_preq_grp.engine_debug(' p_file_id - ' || p_file_id);

628: THEN
629: l_query := l_query || ' where ' || p_where_clause;
630: END IF;
631:
632: qp_preq_grp.engine_debug(' p_file_id - ' || p_file_id);
633: qp_preq_grp.engine_debug(' l_query - ' || l_query);
634:
635:
636: dbms_sql.parse( l_cursor,

Line 633: qp_preq_grp.engine_debug(' l_query - ' || l_query);

629: l_query := l_query || ' where ' || p_where_clause;
630: END IF;
631:
632: qp_preq_grp.engine_debug(' p_file_id - ' || p_file_id);
633: qp_preq_grp.engine_debug(' l_query - ' || l_query);
634:
635:
636: dbms_sql.parse( l_cursor,
637: l_query

Line 657: IF qp_preq_grp.G_DEBUG_ENGINE = FND_API.G_TRUE THEN

653: IF DBMS_SQL.IS_OPEN (l_cursor) THEN
654: dbms_sql.close_cursor( l_cursor );
655: END IF;
656:
657: IF qp_preq_grp.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
658: qp_preq_grp.engine_debug('Exception occured - '||l_routine);
659: qp_preq_grp.engine_debug('Error Message - '||SQLERRM);
660: END IF;
661: END print_table_data_csv;

Line 658: qp_preq_grp.engine_debug('Exception occured - '||l_routine);

654: dbms_sql.close_cursor( l_cursor );
655: END IF;
656:
657: IF qp_preq_grp.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
658: qp_preq_grp.engine_debug('Exception occured - '||l_routine);
659: qp_preq_grp.engine_debug('Error Message - '||SQLERRM);
660: END IF;
661: END print_table_data_csv;
662:

Line 659: qp_preq_grp.engine_debug('Error Message - '||SQLERRM);

655: END IF;
656:
657: IF qp_preq_grp.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
658: qp_preq_grp.engine_debug('Exception occured - '||l_routine);
659: qp_preq_grp.engine_debug('Error Message - '||SQLERRM);
660: END IF;
661: END print_table_data_csv;
662:
663: Procedure print_query_data_csv (

Line 702: IF qp_preq_grp.G_DEBUG_ENGINE = FND_API.G_TRUE THEN

698: IF DBMS_SQL.IS_OPEN (l_cursor) THEN
699: dbms_sql.close_cursor( l_cursor );
700: END IF;
701:
702: IF qp_preq_grp.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
703: qp_preq_grp.engine_debug('Exception occured - '||l_routine);
704: qp_preq_grp.engine_debug('Error Message - '||SQLERRM);
705: END IF;
706:

Line 703: qp_preq_grp.engine_debug('Exception occured - '||l_routine);

699: dbms_sql.close_cursor( l_cursor );
700: END IF;
701:
702: IF qp_preq_grp.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
703: qp_preq_grp.engine_debug('Exception occured - '||l_routine);
704: qp_preq_grp.engine_debug('Error Message - '||SQLERRM);
705: END IF;
706:
707: END print_query_data_csv;

Line 704: qp_preq_grp.engine_debug('Error Message - '||SQLERRM);

700: END IF;
701:
702: IF qp_preq_grp.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
703: qp_preq_grp.engine_debug('Exception occured - '||l_routine);
704: qp_preq_grp.engine_debug('Error Message - '||SQLERRM);
705: END IF;
706:
707: END print_query_data_csv;
708:

Line 741: IF qp_preq_grp.G_DEBUG_ENGINE = FND_API.G_TRUE THEN

737: END IF;
738:
739: EXCEPTION
740: WHEN OTHERS THEN
741: IF qp_preq_grp.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
742: qp_preq_grp.engine_debug('Exception occured - '||l_routine);
743: qp_preq_grp.engine_debug('Error Message - '||SQLERRM);
744: END IF;
745:

Line 742: qp_preq_grp.engine_debug('Exception occured - '||l_routine);

738:
739: EXCEPTION
740: WHEN OTHERS THEN
741: IF qp_preq_grp.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
742: qp_preq_grp.engine_debug('Exception occured - '||l_routine);
743: qp_preq_grp.engine_debug('Error Message - '||SQLERRM);
744: END IF;
745:
746: END print_cursor_data_csv;

Line 743: qp_preq_grp.engine_debug('Error Message - '||SQLERRM);

739: EXCEPTION
740: WHEN OTHERS THEN
741: IF qp_preq_grp.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
742: qp_preq_grp.engine_debug('Exception occured - '||l_routine);
743: qp_preq_grp.engine_debug('Error Message - '||SQLERRM);
744: END IF;
745:
746: END print_cursor_data_csv;
747:

Line 773: IF qp_preq_grp.G_DEBUG_ENGINE = FND_API.G_TRUE THEN

769:
770: EXCEPTION
771: WHEN OTHERS THEN
772:
773: IF qp_preq_grp.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
774: qp_preq_grp.engine_debug('Exception occured - '||l_routine);
775: qp_preq_grp.engine_debug('Error Message - '||SQLERRM);
776: END IF;
777:

Line 774: qp_preq_grp.engine_debug('Exception occured - '||l_routine);

770: EXCEPTION
771: WHEN OTHERS THEN
772:
773: IF qp_preq_grp.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
774: qp_preq_grp.engine_debug('Exception occured - '||l_routine);
775: qp_preq_grp.engine_debug('Error Message - '||SQLERRM);
776: END IF;
777:
778: END print_blank_rows_csv;

Line 775: qp_preq_grp.engine_debug('Error Message - '||SQLERRM);

771: WHEN OTHERS THEN
772:
773: IF qp_preq_grp.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
774: qp_preq_grp.engine_debug('Exception occured - '||l_routine);
775: qp_preq_grp.engine_debug('Error Message - '||SQLERRM);
776: END IF;
777:
778: END print_blank_rows_csv;
779:

Line 827: qp_preq_grp.engine_debug('Dumping data in file - ' || filePath || '/' ||fileName||'.csv');

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
830: LOOP
831:

Line 863: IF qp_preq_grp.G_DEBUG_ENGINE = FND_API.G_TRUE THEN

859: IF DBMS_SQL.IS_OPEN (l_cursor) THEN
860: dbms_sql.close_cursor( l_cursor );
861: END IF;
862:
863: IF qp_preq_grp.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
864: qp_preq_grp.engine_debug('Exception occured - '||l_routine);
865: qp_preq_grp.engine_debug('Error Message - '||SQLERRM);
866: END IF;
867:

Line 864: qp_preq_grp.engine_debug('Exception occured - '||l_routine);

860: dbms_sql.close_cursor( l_cursor );
861: END IF;
862:
863: IF qp_preq_grp.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
864: qp_preq_grp.engine_debug('Exception occured - '||l_routine);
865: qp_preq_grp.engine_debug('Error Message - '||SQLERRM);
866: END IF;
867:
868:

Line 865: qp_preq_grp.engine_debug('Error Message - '||SQLERRM);

861: END IF;
862:
863: IF qp_preq_grp.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
864: qp_preq_grp.engine_debug('Exception occured - '||l_routine);
865: qp_preq_grp.engine_debug('Error Message - '||SQLERRM);
866: END IF;
867:
868:
869: END print_querylist_data_csv;

Line 989: ||QP_PREQ_GRP.G_OPERATOR_BETWEEN ||''','''

985: ||' FROM qp_npreq_line_attrs_tmp ';
986: /*||' WHERE ( '
987: ||' LINE_DETAIL_INDEX IS NULL AND '
988: || 'COMPARISON_OPERATOR_TYPE_CODE IN ('''
989: ||QP_PREQ_GRP.G_OPERATOR_BETWEEN ||''','''
990: ||G_OPERATOR_NOT_EQL ||''')) ';*/
991:
992: qp_debug_util.print_query_data_csv (p_query => l_sql_stmt,
993: p_file_id => 'LINE_ATTRS_TMP',

Line 998: qp_preq_grp.engine_debug('Profile OM:debug level should be set to 5 to print csv files');

994: p_append => TRUE,
995: p_prefix_event => FALSE
996: );
997: ELSE
998: qp_preq_grp.engine_debug('Profile OM:debug level should be set to 5 to print csv files');
999: END IF;
1000: EXCEPTION
1001: WHEN OTHERS THEN
1002: qp_preq_grp.engine_debug('Exception occured - '||l_routine);

Line 1002: qp_preq_grp.engine_debug('Exception occured - '||l_routine);

998: qp_preq_grp.engine_debug('Profile OM:debug level should be set to 5 to print csv files');
999: END IF;
1000: EXCEPTION
1001: WHEN OTHERS THEN
1002: qp_preq_grp.engine_debug('Exception occured - '||l_routine);
1003: qp_preq_grp.engine_debug('Error Message - '||SQLERRM);
1004: END print_development_csv;
1005:
1006: /*

Line 1003: qp_preq_grp.engine_debug('Error Message - '||SQLERRM);

999: END IF;
1000: EXCEPTION
1001: WHEN OTHERS THEN
1002: qp_preq_grp.engine_debug('Exception occured - '||l_routine);
1003: qp_preq_grp.engine_debug('Error Message - '||SQLERRM);
1004: END print_development_csv;
1005:
1006: /*
1007: Description :

Line 1231: qp_preq_grp.engine_debug('Profile OM:debug level should be set to 5 to print csv files');

1227: print_query_data_csv(l_ldets_stmt,'PUB_QP_LDETS_END',TRUE,FALSE);
1228: end if;
1229:
1230: ELSE
1231: qp_preq_grp.engine_debug('Profile OM:debug level should be set to 5 to print csv files');
1232: END IF;
1233:
1234: EXCEPTION
1235: WHEN OTHERS THEN

Line 1236: qp_preq_grp.engine_debug('Exception occured - '||l_routine);

1232: END IF;
1233:
1234: EXCEPTION
1235: WHEN OTHERS THEN
1236: qp_preq_grp.engine_debug('Exception occured - '||l_routine);
1237: qp_preq_grp.engine_debug('Error Message - '||SQLERRM);
1238: END print_support_csv;
1239:
1240: /*

Line 1237: qp_preq_grp.engine_debug('Error Message - '||SQLERRM);

1233:
1234: EXCEPTION
1235: WHEN OTHERS THEN
1236: qp_preq_grp.engine_debug('Exception occured - '||l_routine);
1237: qp_preq_grp.engine_debug('Error Message - '||SQLERRM);
1238: END print_support_csv;
1239:
1240: /*
1241: Description :