APPS.QP_DEBUG_UTIL dependencies on FND_PROFILE

Line 69: G_qp_debug := FND_PROFILE.VALUE('QP_DEBUG');

65: IS
66: v_Position NUMBER := 0;
67: BEGIN
68:
69: G_qp_debug := FND_PROFILE.VALUE('QP_DEBUG');
70: G_DEBUG := OE_DEBUG_PUB.G_DEBUG;
71: G_Debug_Level := FND_PROFILE.VALUE('ONT_DEBUG_LEVEL');
72:
73: IF ISQPDebugON AND G_QP_debug = 'M' THEN

Line 71: G_Debug_Level := FND_PROFILE.VALUE('ONT_DEBUG_LEVEL');

67: BEGIN
68:
69: G_qp_debug := FND_PROFILE.VALUE('QP_DEBUG');
70: G_DEBUG := OE_DEBUG_PUB.G_DEBUG;
71: G_Debug_Level := FND_PROFILE.VALUE('ONT_DEBUG_LEVEL');
72:
73: IF ISQPDebugON AND G_QP_debug = 'M' THEN
74:
75: IF x_Accumalation THEN

Line 324: G_qp_debug := FND_PROFILE.VALUE('QP_DEBUG');

320: Function IsTimeLogDebugOn
321: Return Boolean IS
322: BEGIN
323:
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

Line 326: G_Debug_Level := FND_PROFILE.VALUE('ONT_DEBUG_LEVEL');

322: BEGIN
323:
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

Line 466: select fnd_profile.value('OE_DEBUG_LOG_DIRECTORY')

462: l_mode VARCHAR2(1);
463:
464: BEGIN
465:
466: select fnd_profile.value('OE_DEBUG_LOG_DIRECTORY')
467: into filePath
468: from dual;
469:
470: IF INSTR(G_CURR_PRICE_EVENT,',') = LENGTH(G_CURR_PRICE_EVENT)

Line 621: G_Debug_Level := FND_PROFILE.VALUE('ONT_DEBUG_LEVEL');

617:
618: BEGIN
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;

Line 676: G_Debug_Level := FND_PROFILE.VALUE('ONT_DEBUG_LEVEL');

672:
673: BEGIN
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,

Line 729: G_Debug_Level := FND_PROFILE.VALUE('ONT_DEBUG_LEVEL');

725:
726: BEGIN
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(

Line 807: G_Debug_Level := FND_PROFILE.VALUE('ONT_DEBUG_LEVEL');

803:
804: BEGIN
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:

Line 821: SELECT fnd_profile.value('OE_DEBUG_LOG_DIRECTORY')

817:
818: fileName := fileName|| '_' || p_file_id || '_' ||
819: SUBSTR(OE_DEBUG_PUB.G_FILE,1,INSTR(OE_DEBUG_PUB.G_FILE,'.dbg')-1);
820:
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 );

Line 890: G_Debug_Level := FND_PROFILE.VALUE('ONT_DEBUG_LEVEL');

886:
887: l_sql_stmt VARCHAR2(10000);
888: l_routine VARCHAR2(240):='Routine : QP_DEBUG_UTIL.print_development_csv';
889: BEGIN
890: G_Debug_Level := FND_PROFILE.VALUE('ONT_DEBUG_LEVEL');
891: IF G_DEBUG_LEVEL = 5 THEN
892: -- Printing table qp_npreq_line_patrns_tmp
893: l_sql_stmt := 'SELECT REQUEST_ID,'''
894: || REPLACE(G_CURR_PRICE_EVENT,',','-')

Line 1027: G_Debug_Level := FND_PROFILE.VALUE('ONT_DEBUG_LEVEL');

1023:
1024: l_routine VARCHAR2(240):='Routine : QP_DEBUG_UTIL.print_support_csv';
1025:
1026: begin
1027: G_Debug_Level := FND_PROFILE.VALUE('ONT_DEBUG_LEVEL');
1028: IF G_DEBUG_LEVEL = 5 THEN
1029: l_lines_stmt := 'select ' ||
1030: ' nlines.REQUEST_ID , ' ||
1031: '''' || REPLACE(G_CURR_PRICE_EVENT,',','-') || ''' PRICING_EVENT, ' ||