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.AHL_OSP_UTIL_PKG dependencies on FND_LOG

Line 149: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

145: -- dbms_output.put_line('Conditions Table Count = ' || p_conditions_tbl.COUNT);
146: -- FOR i in 1 .. p_conditions_tbl.count LOOP
147: -- dbms_output.put_line('Condition ' || i || ': ' || p_conditions_tbl(i));
148: -- END LOOP;
149: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
150: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
151: END IF;
152:
153: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 150: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');

146: -- FOR i in 1 .. p_conditions_tbl.count LOOP
147: -- dbms_output.put_line('Condition ' || i || ': ' || p_conditions_tbl(i));
148: -- END LOOP;
149: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
150: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
151: END IF;
152:
153: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
154: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Conditions Table Count = ' || p_conditions_tbl.COUNT);

Line 153: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

149: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
150: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
151: END IF;
152:
153: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
154: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Conditions Table Count = ' || p_conditions_tbl.COUNT);
155: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'SEARCH_SQL: ' || p_sql_str);
156: FOR i in 1 .. p_conditions_tbl.count LOOP
157: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Condition ' || i || ': ' || p_conditions_tbl(i));

Line 154: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Conditions Table Count = ' || p_conditions_tbl.COUNT);

150: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
151: END IF;
152:
153: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
154: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Conditions Table Count = ' || p_conditions_tbl.COUNT);
155: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'SEARCH_SQL: ' || p_sql_str);
156: FOR i in 1 .. p_conditions_tbl.count LOOP
157: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Condition ' || i || ': ' || p_conditions_tbl(i));
158: END LOOP;

Line 155: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'SEARCH_SQL: ' || p_sql_str);

151: END IF;
152:
153: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
154: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Conditions Table Count = ' || p_conditions_tbl.COUNT);
155: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'SEARCH_SQL: ' || p_sql_str);
156: FOR i in 1 .. p_conditions_tbl.count LOOP
157: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Condition ' || i || ': ' || p_conditions_tbl(i));
158: END LOOP;
159: END IF;

Line 157: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Condition ' || i || ': ' || p_conditions_tbl(i));

153: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
154: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Conditions Table Count = ' || p_conditions_tbl.COUNT);
155: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'SEARCH_SQL: ' || p_sql_str);
156: FOR i in 1 .. p_conditions_tbl.count LOOP
157: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Condition ' || i || ': ' || p_conditions_tbl(i));
158: END LOOP;
159: END IF;
160:
161: IF p_conditions_tbl.COUNT = 0 THEN

Line 355: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

351: p_conditions_tbl(18);
352: ELSE
353: -- Error: Too many bind values
354: -- dbms_output.put_line('Error: Too many bind variables');
355: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
356: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Error: Too many bind variables');
357: END IF;
358: null;
359: END IF;

Line 356: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Error: Too many bind variables');

352: ELSE
353: -- Error: Too many bind values
354: -- dbms_output.put_line('Error: Too many bind variables');
355: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
356: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Error: Too many bind variables');
357: END IF;
358: null;
359: END IF;
360: -- dbms_output.put_line('*****Exiting OPEN_SEARCH_CURSOR**********');

Line 361: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

357: END IF;
358: null;
359: END IF;
360: -- dbms_output.put_line('*****Exiting OPEN_SEARCH_CURSOR**********');
361: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
362: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'Exiting Procedure');
363: END IF;
364:
365: END OPEN_SEARCH_CURSOR;

Line 362: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'Exiting Procedure');

358: null;
359: END IF;
360: -- dbms_output.put_line('*****Exiting OPEN_SEARCH_CURSOR**********');
361: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
362: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'Exiting Procedure');
363: END IF;
364:
365: END OPEN_SEARCH_CURSOR;
366:

Line 400: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

396: -- FOR i in 1 .. p_conditions_tbl.count LOOP
397: -- dbms_output.put_line('Condition ' || i || ': ' || p_conditions_tbl(i));
398: -- END LOOP;
399:
400: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
401: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
402: END IF;
403:
404: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 401: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');

397: -- dbms_output.put_line('Condition ' || i || ': ' || p_conditions_tbl(i));
398: -- END LOOP;
399:
400: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
401: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
402: END IF;
403:
404: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
405: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Conditions Table Count = ' || p_conditions_tbl.COUNT);

Line 404: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

400: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
401: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
402: END IF;
403:
404: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
405: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Conditions Table Count = ' || p_conditions_tbl.COUNT);
406: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'SEARCH_SQL: ' || p_sql_str);
407: FOR i in 1 .. p_conditions_tbl.count LOOP
408: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Condition ' || i || ': ' || p_conditions_tbl(i));

Line 405: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Conditions Table Count = ' || p_conditions_tbl.COUNT);

401: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
402: END IF;
403:
404: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
405: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Conditions Table Count = ' || p_conditions_tbl.COUNT);
406: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'SEARCH_SQL: ' || p_sql_str);
407: FOR i in 1 .. p_conditions_tbl.count LOOP
408: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Condition ' || i || ': ' || p_conditions_tbl(i));
409: END LOOP;

Line 406: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'SEARCH_SQL: ' || p_sql_str);

402: END IF;
403:
404: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
405: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Conditions Table Count = ' || p_conditions_tbl.COUNT);
406: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'SEARCH_SQL: ' || p_sql_str);
407: FOR i in 1 .. p_conditions_tbl.count LOOP
408: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Condition ' || i || ': ' || p_conditions_tbl(i));
409: END LOOP;
410: END IF;

Line 408: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Condition ' || i || ': ' || p_conditions_tbl(i));

404: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
405: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Conditions Table Count = ' || p_conditions_tbl.COUNT);
406: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'SEARCH_SQL: ' || p_sql_str);
407: FOR i in 1 .. p_conditions_tbl.count LOOP
408: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Condition ' || i || ': ' || p_conditions_tbl(i));
409: END LOOP;
410: END IF;
411:
412: IF p_conditions_tbl.COUNT = 0 THEN

Line 570: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

566: ELSE
567: -- Error: Too many bind values
568: -- dbms_output.put_line('Error: Too many bind variables');
569:
570: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
571: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Error: Too many bind variables');
572: END IF;
573: null;
574: END IF;

Line 571: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Error: Too many bind variables');

567: -- Error: Too many bind values
568: -- dbms_output.put_line('Error: Too many bind variables');
569:
570: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
571: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Error: Too many bind variables');
572: END IF;
573: null;
574: END IF;
575: -- dbms_output.put_line('*****Exiting EXEC_IMMEDIATE, x_results_count = ' || x_results_count || '**********');

Line 577: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

573: null;
574: END IF;
575: -- dbms_output.put_line('*****Exiting EXEC_IMMEDIATE, x_results_count = ' || x_results_count || '**********');
576:
577: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
578: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
579: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'x_results_count = ' || x_results_count);
580: END IF;
581: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'Exiting Procedure');

Line 578: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

574: END IF;
575: -- dbms_output.put_line('*****Exiting EXEC_IMMEDIATE, x_results_count = ' || x_results_count || '**********');
576:
577: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
578: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
579: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'x_results_count = ' || x_results_count);
580: END IF;
581: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'Exiting Procedure');
582: END IF;

Line 579: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'x_results_count = ' || x_results_count);

575: -- dbms_output.put_line('*****Exiting EXEC_IMMEDIATE, x_results_count = ' || x_results_count || '**********');
576:
577: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
578: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
579: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'x_results_count = ' || x_results_count);
580: END IF;
581: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'Exiting Procedure');
582: END IF;
583:

Line 581: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'Exiting Procedure');

577: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
578: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
579: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'x_results_count = ' || x_results_count);
580: END IF;
581: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'Exiting Procedure');
582: END IF;
583:
584: END EXEC_IMMEDIATE;
585: