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

Line 109: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VALIDATION_SET_PVT.create_vls';

105: lx_vlsv_rec vlsv_rec_type;
106: lp_vldv_tbl vldv_tbl_type;
107: lx_vldv_tbl vldv_tbl_type;
108: i number;
109: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VALIDATION_SET_PVT.create_vls';
110: l_debug_enabled varchar2(10);
111: is_debug_procedure_on boolean;
112: is_debug_statement_on boolean;
113: l_api_name CONSTANT varchar2(30) := 'create_vls';

Line 121: ,fnd_log.level_procedure);

117: BEGIN
118:
119: l_debug_enabled := okl_debug_pub.check_log_enabled;
120: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
121: ,fnd_log.level_procedure);
122:
123:
124: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
125: okl_debug_pub.log_debug(fnd_log.level_procedure

Line 125: okl_debug_pub.log_debug(fnd_log.level_procedure

121: ,fnd_log.level_procedure);
122:
123:
124: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
125: okl_debug_pub.log_debug(fnd_log.level_procedure
126: ,l_module
127: ,'begin debug OKLRVLSB.pls call create_vls');
128: END IF; -- check for logging on STATEMENT level
129: is_debug_statement_on := okl_debug_pub.check_log_on(l_module

Line 130: ,fnd_log.level_statement);

126: ,l_module
127: ,'begin debug OKLRVLSB.pls call create_vls');
128: END IF; -- check for logging on STATEMENT level
129: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
130: ,fnd_log.level_statement);
131:
132: -- call START_ACTIVITY to create savepoint, check compatibility
133: -- and initialize message list
134:

Line 153: okl_debug_pub.log_debug(fnd_log.level_statement

149: lp_vldv_tbl := p_vldv_tbl; --validate header
150: l_return_status := validate_header(lp_vlsv_rec); -- write to log
151:
152: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
153: okl_debug_pub.log_debug(fnd_log.level_statement
154: ,l_module
155: ,'Function okl_ecc_def_pvt.validate_header returned with status ' ||
156: l_return_status);
157: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 168: okl_debug_pub.log_debug(fnd_log.level_statement

164:
165: l_return_status := validate_duplicates(lp_vldv_tbl); -- write to log
166:
167: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
168: okl_debug_pub.log_debug(fnd_log.level_statement
169: ,l_module
170: ,'Function okl_ecc_def_pvt.validate_duplicates returned with status ' ||
171: l_return_status);
172: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 189: okl_debug_pub.log_debug(fnd_log.level_statement

185: ,lp_vlsv_rec
186: ,lx_vlsv_rec); -- write to log
187:
188: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
189: okl_debug_pub.log_debug(fnd_log.level_statement
190: ,l_module
191: ,'okl_vls_pvt.insert_row returned with status ' ||
192: l_return_status ||
193: ' x_msg_data ' ||

Line 219: okl_debug_pub.log_debug(fnd_log.level_statement

215: ,lp_vldv_tbl
216: ,lx_vldv_tbl); -- write to log
217:
218: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
219: okl_debug_pub.log_debug(fnd_log.level_statement
220: ,l_module
221: ,'okl_vld_pvt.insert_row returned with status ' ||
222: l_return_status ||
223: ' x_msg_data ' ||

Line 239: okl_debug_pub.log_debug(fnd_log.level_procedure

235: okl_api.end_activity(x_msg_count => x_msg_count
236: ,x_msg_data => x_msg_data);
237:
238: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
239: okl_debug_pub.log_debug(fnd_log.level_procedure
240: ,l_module
241: ,'end debug OKL_VALIDATION_SET_PVT.pls call create_vls');
242: END IF;
243:

Line 294: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VALIDATION_SET_PVT.update_vls';

290: lx_vldv_tbl vldv_tbl_type;
291: i number;
292: j number;
293: l number;
294: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VALIDATION_SET_PVT.update_vls';
295: l_debug_enabled varchar2(10);
296: is_debug_procedure_on boolean;
297: is_debug_statement_on boolean;
298: l_api_name CONSTANT varchar2(30) := 'update_vls';

Line 305: ,fnd_log.level_procedure);

301:
302: BEGIN
303: l_debug_enabled := okl_debug_pub.check_log_enabled;
304: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
305: ,fnd_log.level_procedure);
306:
307: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
308: okl_debug_pub.log_debug(fnd_log.level_procedure
309: ,l_module

Line 308: okl_debug_pub.log_debug(fnd_log.level_procedure

304: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
305: ,fnd_log.level_procedure);
306:
307: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
308: okl_debug_pub.log_debug(fnd_log.level_procedure
309: ,l_module
310: ,'begin debug OKL_VALIDATION_SET_PVT.pls call update_vls');
311: END IF; -- check for logging on STATEMENT level
312: is_debug_statement_on := okl_debug_pub.check_log_on(l_module

Line 313: ,fnd_log.level_statement);

309: ,l_module
310: ,'begin debug OKL_VALIDATION_SET_PVT.pls call update_vls');
311: END IF; -- check for logging on STATEMENT level
312: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
313: ,fnd_log.level_statement);
314:
315: -- call START_ACTIVITY to create savepoint, check compatibility
316: -- and initialize message list
317:

Line 345: okl_debug_pub.log_debug(fnd_log.level_statement

341:
342: l_return_status :=validate_duplicates(lp_vldv_tbl); -- write to log
343:
344: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
345: okl_debug_pub.log_debug(fnd_log.level_statement
346: ,l_module
347: ,'Function okl_ecc_def_pvt.validate_header returned with status ' ||
348: l_return_status);
349: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 365: okl_debug_pub.log_debug(fnd_log.level_statement

361: ,lp_vlsv_rec
362: ,lx_vlsv_rec); -- write to log
363:
364: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
365: okl_debug_pub.log_debug(fnd_log.level_statement
366: ,l_module
367: ,'okl_vls_pvt.update_row returned with status ' ||
368: l_return_status ||
369: ' x_msg_data ' ||

Line 410: okl_debug_pub.log_debug(fnd_log.level_statement

406: ,x_msg_data
407: ,lp_vldv_crt_tbl
408: ,lx_vldv_crt_tbl); -- write to log
409: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
410: okl_debug_pub.log_debug(fnd_log.level_statement
411: ,l_module
412: ,'okl_vld_pvt.insert_row returned with status ' ||
413: l_return_status ||
414: ' x_msg_data ' ||

Line 432: okl_debug_pub.log_debug(fnd_log.level_statement

428: ,x_msg_data
429: ,lp_vldv_rmv_tbl
430: ,lx_vldv_rmv_tbl); -- write to log
431: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
432: okl_debug_pub.log_debug(fnd_log.level_statement
433: ,l_module
434: ,'okl_vld_pvt.delete_row returned with status ' ||
435: l_return_status ||
436: ' x_msg_data ' ||

Line 454: okl_debug_pub.log_debug(fnd_log.level_procedure

450: okl_api.end_activity(x_msg_count => x_msg_count
451: ,x_msg_data => x_msg_data);
452:
453: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
454: okl_debug_pub.log_debug(fnd_log.level_procedure
455: ,l_module
456: ,'end debug OKLRvlsB.pls call update_vls');
457: END IF;
458:

Line 522: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VALIDATION_SET_PVT.delete_vls';

518: lp_vlsv_rec vlsv_rec_type;
519: lx_vlsv_rec vlsv_rec_type;
520: lx_vldv_rec vldv_rec_type;
521: lx_vldv_tbl vldv_tbl_type;
522: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VALIDATION_SET_PVT.delete_vls';
523: l_debug_enabled varchar2(10);
524: is_debug_procedure_on boolean;
525: is_debug_statement_on boolean;
526: l_api_name CONSTANT varchar2(30) := 'delete_vls';

Line 533: ,fnd_log.level_procedure);

529:
530: BEGIN
531: l_debug_enabled := okl_debug_pub.check_log_enabled;
532: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
533: ,fnd_log.level_procedure);
534:
535: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
536: okl_debug_pub.log_debug(fnd_log.level_procedure
537: ,l_module

Line 536: okl_debug_pub.log_debug(fnd_log.level_procedure

532: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
533: ,fnd_log.level_procedure);
534:
535: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
536: okl_debug_pub.log_debug(fnd_log.level_procedure
537: ,l_module
538: ,'begin debug OKL_VALIDATION_SET_PVT.pls call delete_vls');
539: END IF; -- check for logging on STATEMENT level
540: is_debug_statement_on := okl_debug_pub.check_log_on(l_module

Line 541: ,fnd_log.level_statement);

537: ,l_module
538: ,'begin debug OKL_VALIDATION_SET_PVT.pls call delete_vls');
539: END IF; -- check for logging on STATEMENT level
540: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
541: ,fnd_log.level_statement);
542:
543: -- call START_ACTIVITY to create savepoint, check compatibility
544: -- and initialize message list
545:

Line 564: okl_debug_pub.log_debug(fnd_log.level_statement

560:
561: l_return_status := OKL_VALIDATION_SET_PVT.validate_header(lp_vlsv_rec); -- write to log
562:
563: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
564: okl_debug_pub.log_debug(fnd_log.level_statement
565: ,l_module
566: ,'Function okl_ecc_def_pvt.validate_header returned with status ' ||
567: l_return_status);
568: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 592: okl_debug_pub.log_debug(fnd_log.level_statement

588: ,x_msg_data
589: ,lx_vldv_tbl); -- write to log
590:
591: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
592: okl_debug_pub.log_debug(fnd_log.level_statement
593: ,l_module
594: ,'okl_vls_pvt.delete_row returned with status ' ||
595: l_return_status ||
596: ' x_msg_data ' ||

Line 614: okl_debug_pub.log_debug(fnd_log.level_statement

610: ,x_msg_data
611: ,lp_vlsv_rec); -- write to log
612:
613: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
614: okl_debug_pub.log_debug(fnd_log.level_statement
615: ,l_module
616: ,'okl_vls_pvt.delete_row returned with status ' ||
617: l_return_status ||
618: ' x_msg_data ' ||

Line 631: okl_debug_pub.log_debug(fnd_log.level_procedure

627: okl_api.end_activity(x_msg_count => x_msg_count
628: ,x_msg_data => x_msg_data);
629:
630: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
631: okl_debug_pub.log_debug(fnd_log.level_procedure
632: ,l_module
633: ,'end debug OKL_VALIDATION_SET_PVT.pls call delete_vls');
634: END IF;
635:

Line 676: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VALIDATION_SET_PVT.delete_vld';

672: lx_vldv_rec vldv_rec_type;
673: i number;
674: j number;
675: l number;
676: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VALIDATION_SET_PVT.delete_vld';
677: l_debug_enabled varchar2(10);
678: is_debug_procedure_on boolean;
679: is_debug_statement_on boolean;
680: l_api_name CONSTANT varchar2(30) := 'delete_vld';

Line 686: ,fnd_log.level_procedure);

682: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
683: BEGIN
684: l_debug_enabled := okl_debug_pub.check_log_enabled;
685: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
686: ,fnd_log.level_procedure);
687:
688: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
689: okl_debug_pub.log_debug(fnd_log.level_procedure
690: ,l_module

Line 689: okl_debug_pub.log_debug(fnd_log.level_procedure

685: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
686: ,fnd_log.level_procedure);
687:
688: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
689: okl_debug_pub.log_debug(fnd_log.level_procedure
690: ,l_module
691: ,'begin debug OKL_VALIDATION_SET_PVT.pls call delete_vls');
692: END IF; -- check for logging on STATEMENT level
693: is_debug_statement_on := okl_debug_pub.check_log_on(l_module

Line 694: ,fnd_log.level_statement);

690: ,l_module
691: ,'begin debug OKL_VALIDATION_SET_PVT.pls call delete_vls');
692: END IF; -- check for logging on STATEMENT level
693: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
694: ,fnd_log.level_statement);
695:
696: -- call START_ACTIVITY to create savepoint, check compatibility
697: -- and initialize message list
698:

Line 722: okl_debug_pub.log_debug(fnd_log.level_statement

718: ,x_msg_data
719: ,lp_vldv_rec); -- write to log
720:
721: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
722: okl_debug_pub.log_debug(fnd_log.level_statement
723: ,l_module
724: ,'okl_vls_pvt.delete_row returned with status ' ||
725: l_return_status ||
726: ' x_msg_data ' ||

Line 741: okl_debug_pub.log_debug(fnd_log.level_procedure

737: okl_api.end_activity(x_msg_count => x_msg_count
738: ,x_msg_data => x_msg_data);
739:
740: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
741: okl_debug_pub.log_debug(fnd_log.level_procedure
742: ,l_module
743: ,'end debug OKL_VALIDATION_SET_PVT.pls call create_vls');
744: END IF;
745: