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_RESI_CAT_SETS_PVT dependencies on FND_LOG

Line 77: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_RESI_CAT_SETS_PVT.check_update_status';

73: */
74: FUNCTION check_update_status(
75: p_source_code IN VARCHAR2
76: , p_res_upd_tbl IN okl_res_tbl) RETURN VARCHAR2 IS
77: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_RESI_CAT_SETS_PVT.check_update_status';
78: l_debug_enabled VARCHAR2(10);
79: is_debug_procedure_on BOOLEAN;
80: is_debug_statement_on BOOLEAN;
81:

Line 88: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

84: l_temp_cnt NUMBER :=0;
85: BEGIN
86:
87: l_debug_enabled := okl_debug_pub.check_log_enabled;
88: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
89: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
90: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRRCSB.pls call check_update_status');
91: END IF;
92:

Line 90: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRRCSB.pls call check_update_status');

86:
87: l_debug_enabled := okl_debug_pub.check_log_enabled;
88: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
89: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
90: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRRCSB.pls call check_update_status');
91: END IF;
92:
93:
94: IF p_source_code = G_CAT_ITEM THEN

Line 140: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRRCSB.pls call check_update_status');

136:
137:
138:
139: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
140: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRRCSB.pls call check_update_status');
141: END IF;
142:
143: RETURN l_make_inactive;
144:

Line 173: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_RESI_CAT_SETS_PVT.create_rcs';

169: , p_res_tbl IN okl_res_tbl
170: , x_rcsv_rec OUT NOCOPY okl_rcsv_rec
171: , x_res_tbl OUT NOCOPY okl_res_tbl
172: ) IS
173: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_RESI_CAT_SETS_PVT.create_rcs';
174: l_debug_enabled VARCHAR2(10);
175: is_debug_procedure_on BOOLEAN;
176: is_debug_statement_on BOOLEAN;
177:

Line 191: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

187:
188: i NUMBER :=0;
189: begin
190: l_debug_enabled := okl_debug_pub.check_log_enabled;
191: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
192: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
193: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRRCSB.pls call create_rcs');
194: END IF;
195:

Line 193: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRRCSB.pls call create_rcs');

189: begin
190: l_debug_enabled := okl_debug_pub.check_log_enabled;
191: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
192: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
193: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRRCSB.pls call create_rcs');
194: END IF;
195:
196: l_return_status := OKL_API.start_activity(l_api_name
197: ,G_PKG_NAME

Line 264: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRRCSB.pls call create_rcs');

260: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
261:
262:
263: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
264: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRRCSB.pls call create_rcs');
265: END IF;
266:
267: EXCEPTION
268: WHEN G_EXCEPTION_HALT_VALIDATION then

Line 324: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_RESI_CAT_SETS_PVT.update_rcs';

320: , p_rcsv_rec IN okl_rcsv_rec
321: , p_res_tbl IN okl_res_tbl
322: , x_rcsv_rec OUT NOCOPY okl_rcsv_rec
323: ) IS
324: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_RESI_CAT_SETS_PVT.update_rcs';
325: l_debug_enabled VARCHAR2(10);
326: is_debug_procedure_on BOOLEAN;
327: is_debug_statement_on BOOLEAN;
328:

Line 346: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

342: k NUMBER;
343: BEGIN
344:
345: l_debug_enabled := okl_debug_pub.check_log_enabled;
346: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
347: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
348: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRRCSB.pls call update_rcs');
349: END IF;
350: l_return_status := OKL_API.start_activity(l_api_name

Line 348: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRRCSB.pls call update_rcs');

344:
345: l_debug_enabled := okl_debug_pub.check_log_enabled;
346: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
347: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
348: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRRCSB.pls call update_rcs');
349: END IF;
350: l_return_status := OKL_API.start_activity(l_api_name
351: ,G_PKG_NAME
352: ,p_init_msg_list

Line 453: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRRCSB.pls call update_rcs');

449: x_return_status := l_return_status;
450: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
451:
452: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
453: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRRCSB.pls call update_rcs');
454: END IF;
455: EXCEPTION
456: WHEN G_EXCEPTION_HALT_VALIDATION then
457: -- No action necessary.

Line 512: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_RESI_CAT_SETS_PVT.activate_rcs';

508: , p_rcsv_rec IN okl_rcsv_rec
509: , p_res_tbl IN okl_res_tbl
510: , x_rcsv_rec OUT NOCOPY okl_rcsv_rec
511: ) IS
512: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_RESI_CAT_SETS_PVT.activate_rcs';
513: l_debug_enabled VARCHAR2(10);
514: is_debug_procedure_on BOOLEAN;
515: is_debug_statement_on BOOLEAN;
516:

Line 526: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

522:
523: l_make_inactive VARCHAR2(3) := 'no';
524: BEGIN
525: l_debug_enabled := okl_debug_pub.check_log_enabled;
526: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
527: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
528: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRRCSB.pls call activate_rcs');
529: END IF;
530:

Line 528: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRRCSB.pls call activate_rcs');

524: BEGIN
525: l_debug_enabled := okl_debug_pub.check_log_enabled;
526: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
527: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
528: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRRCSB.pls call activate_rcs');
529: END IF;
530:
531: l_return_status := OKL_API.start_activity(l_api_name
532: ,G_PKG_NAME

Line 579: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRRCSB.pls call update_rcs');

575: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
576:
577:
578: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
579: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRRCSB.pls call update_rcs');
580: END IF;
581: EXCEPTION
582: WHEN G_EXCEPTION_HALT_VALIDATION then
583: -- No action necessary.

Line 636: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_RESI_CAT_SETS_PVT.Inactivate_rcs';

632: , x_msg_data OUT NOCOPY VARCHAR2
633: , p_rcs_id IN NUMBER
634: , p_obj_ver_number IN NUMBER
635: ) IS
636: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_RESI_CAT_SETS_PVT.Inactivate_rcs';
637: l_debug_enabled VARCHAR2(10);
638: is_debug_procedure_on BOOLEAN;
639: is_debug_statement_on BOOLEAN;
640:

Line 649: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

645: lp_rcsv_rec okl_rcsv_rec;
646: x_rcsv_rec okl_rcsv_rec ;
647: BEGIN
648: l_debug_enabled := okl_debug_pub.check_log_enabled;
649: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
650: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
651: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRRCSB.pls call Inactivate_rcs');
652: END IF;
653: l_return_status := OKL_API.start_activity(l_api_name

Line 651: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRRCSB.pls call Inactivate_rcs');

647: BEGIN
648: l_debug_enabled := okl_debug_pub.check_log_enabled;
649: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
650: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
651: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRRCSB.pls call Inactivate_rcs');
652: END IF;
653: l_return_status := OKL_API.start_activity(l_api_name
654: ,G_PKG_NAME
655: ,p_init_msg_list

Line 689: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRRCSB.pls call Inactivate_rcs');

685: x_return_status := l_return_status;
686: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
687:
688: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
689: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRRCSB.pls call Inactivate_rcs');
690: END IF;
691: EXCEPTION
692: WHEN G_EXCEPTION_HALT_VALIDATION then
693: -- No action necessary.

Line 740: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_RESI_CAT_SETS_PVT.delete_objects';

736: , x_return_status OUT NOCOPY VARCHAR2
737: , x_msg_count OUT NOCOPY NUMBER
738: , x_msg_data OUT NOCOPY VARCHAR2
739: , p_res_tbl IN okl_res_tbl) IS
740: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_RESI_CAT_SETS_PVT.delete_objects';
741: l_debug_enabled VARCHAR2(10);
742: is_debug_procedure_on BOOLEAN;
743: is_debug_statement_on BOOLEAN;
744:

Line 753: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

749: BEGIN
750:
751:
752: l_debug_enabled := okl_debug_pub.check_log_enabled;
753: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
754: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
755: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRRCSB.pls call delete_objects');
756: END IF;
757: l_return_status := OKL_API.start_activity(l_api_name

Line 755: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRRCSB.pls call delete_objects');

751:
752: l_debug_enabled := okl_debug_pub.check_log_enabled;
753: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
754: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
755: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRRCSB.pls call delete_objects');
756: END IF;
757: l_return_status := OKL_API.start_activity(l_api_name
758: ,G_PKG_NAME
759: ,p_init_msg_list

Line 789: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRRCSB.pls call delete_objects');

785:
786: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
787:
788: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
789: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRRCSB.pls call delete_objects');
790: END IF;
791: EXCEPTION
792: WHEN OKL_API.G_EXCEPTION_ERROR THEN
793: x_return_status := OKL_API.HANDLE_EXCEPTIONS