DBA Data[Home] [Help]

APPS.QP_DEBUG_UTIL dependencies on FND_API

Line 313: if G_DEBUG = FND_API.G_TRUE AND G_DEBUG_LEVEL = 1 AND G_qp_debug IN ('P','S','M') then

309: Function ISQPDebugOn
310: Return Boolean IS
311: BEGIN
312:
313: if G_DEBUG = FND_API.G_TRUE AND G_DEBUG_LEVEL = 1 AND G_qp_debug IN ('P','S','M') then
314: RETURN(TRUE);
315: else
316: RETURN(FALSE);
317: end if;

Line 328: if G_DEBUG = FND_API.G_TRUE AND G_DEBUG_LEVEL = 1 AND G_QP_debug = 'M' then

324: G_qp_debug := FND_PROFILE.VALUE('QP_DEBUG');
325: G_DEBUG := OE_DEBUG_PUB.G_DEBUG;
326: G_Debug_Level := FND_PROFILE.VALUE('ONT_DEBUG_LEVEL');
327:
328: if G_DEBUG = FND_API.G_TRUE AND G_DEBUG_LEVEL = 1 AND G_QP_debug = 'M' then
329: RETURN(TRUE);
330: else
331: RETURN(FALSE);
332: end if;

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 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 623: IF G_DEBUG = FND_API.G_TRUE AND G_DEBUG_LEVEL = 5 THEN

619:
620: G_DEBUG := OE_DEBUG_PUB.G_DEBUG;
621: G_Debug_Level := FND_PROFILE.VALUE('ONT_DEBUG_LEVEL');
622:
623: IF G_DEBUG = FND_API.G_TRUE AND G_DEBUG_LEVEL = 5 THEN
624:
625: l_query := 'select * from ' || p_table_name;
626:
627: IF p_where_clause IS NOT NULL

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 678: IF G_DEBUG = FND_API.G_TRUE AND G_DEBUG_LEVEL = 5 THEN

674:
675: G_DEBUG := OE_DEBUG_PUB.G_DEBUG;
676: G_Debug_Level := FND_PROFILE.VALUE('ONT_DEBUG_LEVEL');
677:
678: IF G_DEBUG = FND_API.G_TRUE AND G_DEBUG_LEVEL = 5 THEN
679:
680: dbms_sql.parse( l_cursor,
681: p_query,
682: dbms_sql.native );

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 731: IF G_DEBUG = FND_API.G_TRUE AND G_DEBUG_LEVEL = 5 THEN

727:
728: G_DEBUG := OE_DEBUG_PUB.G_DEBUG;
729: G_Debug_Level := FND_PROFILE.VALUE('ONT_DEBUG_LEVEL');
730:
731: IF G_DEBUG = FND_API.G_TRUE AND G_DEBUG_LEVEL = 5 THEN
732:
733: print_cursor_data_csv_pvt(
734: p_file_id => p_file_id ,
735: p_cursor => p_cursor_id);

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 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 809: IF G_DEBUG = FND_API.G_TRUE AND G_DEBUG_LEVEL = 5 THEN

805:
806: G_DEBUG := OE_DEBUG_PUB.G_DEBUG;
807: G_Debug_Level := FND_PROFILE.VALUE('ONT_DEBUG_LEVEL');
808:
809: IF G_DEBUG = FND_API.G_TRUE AND G_DEBUG_LEVEL = 5 THEN
810: g_csv_count := g_csv_count+1;
811:
812: fileName := g_csv_count;
813:

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: