DBA Data[Home] [Help]

APPS.OKL_RESI_CAT_SETS_PVT dependencies on OKL_DEBUG_PUB

Line 87: l_debug_enabled := okl_debug_pub.check_log_enabled;

83: l_make_inactive VARCHAR2(3) := 'no';
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;

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 190: l_debug_enabled := okl_debug_pub.check_log_enabled;

186: l_res_tbl okl_res_tbl := p_res_tbl;
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;

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 345: l_debug_enabled := okl_debug_pub.check_log_enabled;

341: j NUMBER;
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;

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 525: l_debug_enabled := okl_debug_pub.check_log_enabled;

521: lp_rcsv_rec okl_rcsv_rec := p_rcsv_rec;
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;

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 648: l_debug_enabled := okl_debug_pub.check_log_enabled;

644: l_return_status VARCHAR2(1) := x_return_status;
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;

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 752: l_debug_enabled := okl_debug_pub.check_log_enabled;

748: l_return_status VARCHAR2(1) := x_return_status;
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;

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