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_QUICK_QUOTES_PVT dependencies on OKL_DEBUG_PUB

Line 74: l_debug_enabled := nvl(okl_debug_pub.check_log_enabled,'N');

70: l_api_version CONSTANT NUMBER := 1.0;
71: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
72:
73: BEGIN
74: l_debug_enabled := nvl(okl_debug_pub.check_log_enabled,'N');
75: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
76: ,fnd_log.level_procedure);
77:
78: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN

Line 75: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module

71: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
72:
73: BEGIN
74: l_debug_enabled := nvl(okl_debug_pub.check_log_enabled,'N');
75: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
76: ,fnd_log.level_procedure);
77:
78: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
79: okl_debug_pub.log_debug(fnd_log.level_procedure

Line 79: okl_debug_pub.log_debug(fnd_log.level_procedure

75: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
76: ,fnd_log.level_procedure);
77:
78: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
79: okl_debug_pub.log_debug(fnd_log.level_procedure
80: ,l_module
81: ,'begin debug OKLRQQHB.pls call create_qqh');
82: END IF;
83: -- check for logging on STATEMENT level

Line 84: is_debug_statement_on := okl_debug_pub.check_log_on(l_module

80: ,l_module
81: ,'begin debug OKLRQQHB.pls call create_qqh');
82: END IF;
83: -- check for logging on STATEMENT level
84: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
85: ,fnd_log.level_statement);
86:
87: -- call START_ACTIVITY to create savepoint, check compatibility
88: -- and initialize message list

Line 108: okl_debug_pub.log_debug(fnd_log.level_statement

104: RAISE okl_api.g_exception_error;
105: END IF;
106:
107: IF (l_debug_enabled = 'Y' AND is_debug_statement_on) THEN -- write to log
108: okl_debug_pub.log_debug(fnd_log.level_statement
109: ,l_module
110: ,'Function okl_quick_quotes_pvt.validate_header returned with status ' ||
111: l_return_status);
112: END IF; -- end of l_debug_enabled ='Y'

Line 129: okl_debug_pub.log_debug(fnd_log.level_statement

125: ,lp_qqhv_rec_type
126: ,lx_qqhv_rec_type); -- write to log
127:
128: IF (l_debug_enabled = 'Y' AND is_debug_statement_on) THEN
129: okl_debug_pub.log_debug(fnd_log.level_statement
130: ,l_module
131: ,'okl_qqh_pvt.insert_row returned with status ' ||
132: l_return_status ||
133: ' x_msg_data ' ||

Line 151: okl_debug_pub.log_debug(fnd_log.level_procedure

147: okl_api.end_activity(x_msg_count => x_msg_count
148: ,x_msg_data => x_msg_data);
149:
150: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
151: okl_debug_pub.log_debug(fnd_log.level_procedure
152: ,l_module
153: ,'end debug OKLRQQHB.pls call create_qqh');
154: END IF;
155:

Line 199: l_debug_enabled := nvl(okl_debug_pub.check_log_enabled,'N');

195: l_api_version CONSTANT NUMBER := 1.0;
196: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
197:
198: BEGIN
199: l_debug_enabled := nvl(okl_debug_pub.check_log_enabled,'N');
200: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
201: ,fnd_log.level_procedure);
202:
203: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN

Line 200: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module

196: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
197:
198: BEGIN
199: l_debug_enabled := nvl(okl_debug_pub.check_log_enabled,'N');
200: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
201: ,fnd_log.level_procedure);
202:
203: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
204: okl_debug_pub.log_debug(fnd_log.level_procedure

Line 204: okl_debug_pub.log_debug(fnd_log.level_procedure

200: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
201: ,fnd_log.level_procedure);
202:
203: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
204: okl_debug_pub.log_debug(fnd_log.level_procedure
205: ,l_module
206: ,'begin debug OKLRQQHB.pls call create_qql');
207: END IF;
208: -- check for logging on STATEMENT level

Line 209: is_debug_statement_on := okl_debug_pub.check_log_on(l_module

205: ,l_module
206: ,'begin debug OKLRQQHB.pls call create_qql');
207: END IF;
208: -- check for logging on STATEMENT level
209: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
210: ,fnd_log.level_statement);
211:
212: -- call START_ACTIVITY to create savepoint, check compatibility
213: -- and initialize message list

Line 234: okl_debug_pub.log_debug(fnd_log.level_statement

230: ,lp_qqlv_tbl_type
231: ,lx_qqlv_tbl_type); -- write to log
232:
233: IF (l_debug_enabled = 'Y' AND is_debug_statement_on) THEN
234: okl_debug_pub.log_debug(fnd_log.level_statement
235: ,l_module
236: ,'okl_qql_pvt.insert_row returned with status ' ||
237: l_return_status ||
238: ' x_msg_data ' ||

Line 257: okl_debug_pub.log_debug(fnd_log.level_procedure

253: okl_api.end_activity(x_msg_count => x_msg_count
254: ,x_msg_data => x_msg_data);
255:
256: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
257: okl_debug_pub.log_debug(fnd_log.level_procedure
258: ,l_module
259: ,'end debug OKLRQQHB.pls call create_qql');
260: END IF;
261:

Line 310: l_debug_enabled := nvl(okl_debug_pub.check_log_enabled,'N');

306: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
307: i NUMBER;
308:
309: BEGIN
310: l_debug_enabled := nvl(okl_debug_pub.check_log_enabled,'N');
311: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
312: ,fnd_log.level_procedure);
313:
314: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN

Line 311: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module

307: i NUMBER;
308:
309: BEGIN
310: l_debug_enabled := nvl(okl_debug_pub.check_log_enabled,'N');
311: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
312: ,fnd_log.level_procedure);
313:
314: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
315: okl_debug_pub.log_debug(fnd_log.level_procedure

Line 315: okl_debug_pub.log_debug(fnd_log.level_procedure

311: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
312: ,fnd_log.level_procedure);
313:
314: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
315: okl_debug_pub.log_debug(fnd_log.level_procedure
316: ,l_module
317: ,'begin debug OKLRQQHB.pls call create_quick_qte');
318: END IF;
319: -- check for logging on STATEMENT level

Line 320: is_debug_statement_on := okl_debug_pub.check_log_on(l_module

316: ,l_module
317: ,'begin debug OKLRQQHB.pls call create_quick_qte');
318: END IF;
319: -- check for logging on STATEMENT level
320: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
321: ,fnd_log.level_statement);
322:
323: -- call START_ACTIVITY to create savepoint, check compatibility
324: -- and initialize message list

Line 348: okl_debug_pub.log_debug(fnd_log.level_statement

344: ,x_qqhv_rec_type => lx_qqhv_rec_type);
345:
346:
347: IF (l_debug_enabled = 'Y' AND is_debug_statement_on) THEN
348: okl_debug_pub.log_debug(fnd_log.level_statement
349: ,l_module
350: ,'okl_quick_quotes_pvt.create_qqh returned with status ' ||
351: l_return_status ||
352: ' x_msg_data ' ||

Line 376: okl_debug_pub.log_debug(fnd_log.level_statement

372: ,p_qqlv_tbl_type => lp_qqlv_tbl_type
373: ,x_qqlv_tbl_type => lx_qqlv_tbl_type);
374:
375: IF (l_debug_enabled = 'Y' AND is_debug_statement_on) THEN
376: okl_debug_pub.log_debug(fnd_log.level_statement
377: ,l_module
378: ,'okl_quick_quotes_pvt.create_qql returned with status ' ||
379: l_return_status ||
380: ' x_msg_data ' ||

Line 397: okl_debug_pub.log_debug(fnd_log.level_procedure

393: okl_api.end_activity(x_msg_count => x_msg_count
394: ,x_msg_data => x_msg_data);
395:
396: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
397: okl_debug_pub.log_debug(fnd_log.level_procedure
398: ,l_module
399: ,'end debug OKLRQQHB.pls call create_qq');
400: END IF;
401:

Line 444: l_debug_enabled := NVL(okl_debug_pub.check_log_enabled,'N');

440: l_api_version CONSTANT NUMBER := 1.0;
441: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
442:
443: BEGIN
444: l_debug_enabled := NVL(okl_debug_pub.check_log_enabled,'N');
445: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
446: ,fnd_log.level_procedure);
447:
448: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN

Line 445: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module

441: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
442:
443: BEGIN
444: l_debug_enabled := NVL(okl_debug_pub.check_log_enabled,'N');
445: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
446: ,fnd_log.level_procedure);
447:
448: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
449: okl_debug_pub.log_debug(fnd_log.level_procedure

Line 449: okl_debug_pub.log_debug(fnd_log.level_procedure

445: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
446: ,fnd_log.level_procedure);
447:
448: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
449: okl_debug_pub.log_debug(fnd_log.level_procedure
450: ,l_module
451: ,'begin debug OKLRQQHB.pls call update_qqh');
452: END IF; -- check for logging at STATEMENT level
453: is_debug_statement_on := okl_debug_pub.check_log_on(l_module

Line 453: is_debug_statement_on := okl_debug_pub.check_log_on(l_module

449: okl_debug_pub.log_debug(fnd_log.level_procedure
450: ,l_module
451: ,'begin debug OKLRQQHB.pls call update_qqh');
452: END IF; -- check for logging at STATEMENT level
453: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
454: ,fnd_log.level_statement);
455:
456: -- call START_ACTIVITY to create savepoint, check compatibility
457: -- and initialize message list

Line 498: okl_debug_pub.log_debug(fnd_log.level_statement

494: ,lp_qqhv_rec_type
495: ,lx_qqhv_rec_type); -- write to log
496:
497: IF (l_debug_enabled = 'Y' AND is_debug_statement_on) THEN
498: okl_debug_pub.log_debug(fnd_log.level_statement
499: ,l_module
500: ,'okl_qqh_pvt.update_row returned with status ' ||
501: l_return_status ||
502: ' x_msg_data ' ||

Line 519: okl_debug_pub.log_debug(fnd_log.level_procedure

515: okl_api.end_activity(x_msg_count => x_msg_count
516: ,x_msg_data => x_msg_data);
517:
518: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
519: okl_debug_pub.log_debug(fnd_log.level_procedure
520: ,l_module
521: ,'end debug OKLRQQHB.pls call update_qqh');
522: END IF;
523:

Line 579: l_debug_enabled := NVL(okl_debug_pub.check_log_enabled,'N');

575: l_api_version CONSTANT NUMBER := 1.0;
576: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
577:
578: BEGIN
579: l_debug_enabled := NVL(okl_debug_pub.check_log_enabled,'N');
580: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
581: ,fnd_log.level_procedure);
582:
583: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN

Line 580: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module

576: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
577:
578: BEGIN
579: l_debug_enabled := NVL(okl_debug_pub.check_log_enabled,'N');
580: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
581: ,fnd_log.level_procedure);
582:
583: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
584: okl_debug_pub.log_debug(fnd_log.level_procedure

Line 584: okl_debug_pub.log_debug(fnd_log.level_procedure

580: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
581: ,fnd_log.level_procedure);
582:
583: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
584: okl_debug_pub.log_debug(fnd_log.level_procedure
585: ,l_module
586: ,'begin debug OKLRQQHB.pls call cancel_quick_quote');
587: END IF; -- check for logging at STATEMENT level
588: is_debug_statement_on := okl_debug_pub.check_log_on(l_module

Line 588: is_debug_statement_on := okl_debug_pub.check_log_on(l_module

584: okl_debug_pub.log_debug(fnd_log.level_procedure
585: ,l_module
586: ,'begin debug OKLRQQHB.pls call cancel_quick_quote');
587: END IF; -- check for logging at STATEMENT level
588: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
589: ,fnd_log.level_statement);
590:
591: -- call START_ACTIVITY to create savepoint, check compatibility
592: -- and initialize message list

Line 613: okl_debug_pub.log_debug(fnd_log.level_statement

609: ,lp_qqhv_rec_type
610: ,lx_qqhv_rec_type); -- write to log
611:
612: IF (l_debug_enabled = 'Y' AND is_debug_statement_on) THEN
613: okl_debug_pub.log_debug(fnd_log.level_statement
614: ,l_module
615: ,'okl_qqh_pvt.update_row returned with status ' ||
616: l_return_status ||
617: ' x_msg_data ' ||

Line 634: okl_debug_pub.log_debug(fnd_log.level_procedure

630: okl_api.end_activity(x_msg_count => x_msg_count
631: ,x_msg_data => x_msg_data);
632:
633: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
634: okl_debug_pub.log_debug(fnd_log.level_procedure
635: ,l_module
636: ,'end debug OKLRQQHB.pls call cancel_quick_quote');
637: END IF;
638:

Line 687: l_debug_enabled := NVL(okl_debug_pub.check_log_enabled,'N');

683: l_api_version CONSTANT NUMBER := 1.0;
684: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
685:
686: BEGIN
687: l_debug_enabled := NVL(okl_debug_pub.check_log_enabled,'N');
688: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
689: ,fnd_log.level_procedure);
690:
691: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN

Line 688: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module

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

Line 692: okl_debug_pub.log_debug(fnd_log.level_procedure

688: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
689: ,fnd_log.level_procedure);
690:
691: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
692: okl_debug_pub.log_debug(fnd_log.level_procedure
693: ,l_module
694: ,'begin debug OKLRQQHB.pls call update_qql');
695: END IF; -- check for logging at STATEMENT level
696: is_debug_statement_on := okl_debug_pub.check_log_on(l_module

Line 696: is_debug_statement_on := okl_debug_pub.check_log_on(l_module

692: okl_debug_pub.log_debug(fnd_log.level_procedure
693: ,l_module
694: ,'begin debug OKLRQQHB.pls call update_qql');
695: END IF; -- check for logging at STATEMENT level
696: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
697: ,fnd_log.level_statement);
698:
699: -- call START_ACTIVITY to create savepoint, check compatibility
700: -- and initialize message list

Line 720: okl_debug_pub.log_debug(fnd_log.level_statement

716: ,x_msg_data
717: ,lp_qqlv_tbl_type
718: ,lx_qqlv_tbl_type); -- write to log
719: IF (l_debug_enabled = 'Y' AND is_debug_statement_on) THEN
720: okl_debug_pub.log_debug(fnd_log.level_statement
721: ,l_module
722: ,'okl_qql_pvt.update_row returned with status ' ||
723: l_return_status ||
724: ' x_msg_data ' ||

Line 743: okl_debug_pub.log_debug(fnd_log.level_procedure

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

Line 795: l_debug_enabled := NVL(okl_debug_pub.check_log_enabled,'N');

791: l_api_version CONSTANT NUMBER := 1.0;
792: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
793:
794: BEGIN
795: l_debug_enabled := NVL(okl_debug_pub.check_log_enabled,'N');
796: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
797: ,fnd_log.level_procedure);
798:
799: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN

Line 796: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module

792: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
793:
794: BEGIN
795: l_debug_enabled := NVL(okl_debug_pub.check_log_enabled,'N');
796: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
797: ,fnd_log.level_procedure);
798:
799: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
800: okl_debug_pub.log_debug(fnd_log.level_procedure

Line 800: okl_debug_pub.log_debug(fnd_log.level_procedure

796: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
797: ,fnd_log.level_procedure);
798:
799: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
800: okl_debug_pub.log_debug(fnd_log.level_procedure
801: ,l_module
802: ,'begin debug OKLRQQHB.pls call update_quick_qte');
803: END IF; -- check for logging at STATEMENT level
804: is_debug_statement_on := okl_debug_pub.check_log_on(l_module

Line 804: is_debug_statement_on := okl_debug_pub.check_log_on(l_module

800: okl_debug_pub.log_debug(fnd_log.level_procedure
801: ,l_module
802: ,'begin debug OKLRQQHB.pls call update_quick_qte');
803: END IF; -- check for logging at STATEMENT level
804: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
805: ,fnd_log.level_statement);
806:
807: -- call START_ACTIVITY to create savepoint, check compatibility
808: -- and initialize message list

Line 832: okl_debug_pub.log_debug(fnd_log.level_statement

828: ,x_qqhv_rec_type => lx_qqhv_rec_type
829: );
830:
831: IF (l_debug_enabled = 'Y' AND is_debug_statement_on) THEN
832: okl_debug_pub.log_debug(fnd_log.level_statement
833: ,l_module
834: ,'okl_quick_quotes_pvt.update_qqh returned with status ' ||
835: l_return_status ||
836: ' x_msg_data ' ||

Line 857: okl_debug_pub.log_debug(fnd_log.level_statement

853: ,x_qqlv_tbl_type => lx_qqlv_tbl_type
854: );
855:
856: IF (l_debug_enabled = 'Y' AND is_debug_statement_on) THEN
857: okl_debug_pub.log_debug(fnd_log.level_statement
858: ,l_module
859: ,'okl_quick_quotes_pvt.update_qql returned with status ' ||
860: l_return_status ||
861: ' x_msg_data ' ||

Line 878: okl_debug_pub.log_debug(fnd_log.level_procedure

874: okl_api.end_activity(x_msg_count => x_msg_count
875: ,x_msg_data => x_msg_data);
876:
877: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
878: okl_debug_pub.log_debug(fnd_log.level_procedure
879: ,l_module
880: ,'end debug OKLRQQHB.pls call update_quick_qte');
881: END IF;
882:

Line 924: l_debug_enabled := NVL(okl_debug_pub.check_log_enabled,'N');

920: is_debug_procedure_on BOOLEAN;
921: is_debug_statement_on BOOLEAN;
922:
923: BEGIN
924: l_debug_enabled := NVL(okl_debug_pub.check_log_enabled,'N');
925: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
926: ,fnd_log.level_procedure);
927:
928: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN

Line 925: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module

921: is_debug_statement_on BOOLEAN;
922:
923: BEGIN
924: l_debug_enabled := NVL(okl_debug_pub.check_log_enabled,'N');
925: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
926: ,fnd_log.level_procedure);
927:
928: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
929: okl_debug_pub.log_debug(fnd_log.level_procedure

Line 929: okl_debug_pub.log_debug(fnd_log.level_procedure

925: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
926: ,fnd_log.level_procedure);
927:
928: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
929: okl_debug_pub.log_debug(fnd_log.level_procedure
930: ,l_module
931: ,'begin debug OKLRQQHB.pls call delete_qql');
932: END IF; -- check for logging at STATEMENT level
933: is_debug_statement_on := okl_debug_pub.check_log_on(l_module

Line 933: is_debug_statement_on := okl_debug_pub.check_log_on(l_module

929: okl_debug_pub.log_debug(fnd_log.level_procedure
930: ,l_module
931: ,'begin debug OKLRQQHB.pls call delete_qql');
932: END IF; -- check for logging at STATEMENT level
933: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
934: ,fnd_log.level_statement);
935:
936: -- call START_ACTIVITY to create savepoint, check compatibility
937: -- and initialize message list

Line 956: okl_debug_pub.log_debug(fnd_log.level_statement

952: x_msg_data => x_msg_data,
953: p_qqlv_rec => l_qqlv_rec);
954:
955: IF (l_debug_enabled = 'Y' AND is_debug_statement_on) THEN
956: okl_debug_pub.log_debug(fnd_log.level_statement
957: ,l_module
958: ,'okl_qql_pvt.delete_row returned with status ' ||
959: l_return_status ||
960: ' x_msg_data ' ||

Line 975: okl_debug_pub.log_debug(fnd_log.level_procedure

971: ,x_msg_data => x_msg_data);
972:
973: x_return_status := l_return_status;
974: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
975: okl_debug_pub.log_debug(fnd_log.level_procedure
976: ,l_module
977: ,'end debug OKLRQQHB.pls call delete_qql');
978: END IF;
979:

Line 1021: l_debug_enabled := NVL(okl_debug_pub.check_log_enabled,'N');

1017: is_debug_procedure_on BOOLEAN;
1018: is_debug_statement_on BOOLEAN;
1019:
1020: BEGIN
1021: l_debug_enabled := NVL(okl_debug_pub.check_log_enabled,'N');
1022: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
1023: ,fnd_log.level_procedure);
1024:
1025: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN

Line 1022: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module

1018: is_debug_statement_on BOOLEAN;
1019:
1020: BEGIN
1021: l_debug_enabled := NVL(okl_debug_pub.check_log_enabled,'N');
1022: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
1023: ,fnd_log.level_procedure);
1024:
1025: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1026: okl_debug_pub.log_debug(fnd_log.level_procedure

Line 1026: okl_debug_pub.log_debug(fnd_log.level_procedure

1022: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
1023: ,fnd_log.level_procedure);
1024:
1025: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1026: okl_debug_pub.log_debug(fnd_log.level_procedure
1027: ,l_module
1028: ,'begin debug OKLRQQHB.pls call delete_qql');
1029: END IF; -- check for logging at STATEMENT level
1030: is_debug_statement_on := okl_debug_pub.check_log_on(l_module

Line 1030: is_debug_statement_on := okl_debug_pub.check_log_on(l_module

1026: okl_debug_pub.log_debug(fnd_log.level_procedure
1027: ,l_module
1028: ,'begin debug OKLRQQHB.pls call delete_qql');
1029: END IF; -- check for logging at STATEMENT level
1030: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
1031: ,fnd_log.level_statement);
1032:
1033: -- call START_ACTIVITY to create savepoint, check compatibility
1034: -- and initialize message list

Line 1053: okl_debug_pub.log_debug(fnd_log.level_statement

1049: x_msg_data => x_msg_data,
1050: p_qqlv_tbl => l_qqlv_tbl);
1051:
1052: IF (l_debug_enabled = 'Y' AND is_debug_statement_on) THEN
1053: okl_debug_pub.log_debug(fnd_log.level_statement
1054: ,l_module
1055: ,'okl_qql_pvt.delete_row returned with status ' ||
1056: l_return_status ||
1057: ' x_msg_data ' ||

Line 1072: okl_debug_pub.log_debug(fnd_log.level_procedure

1068: ,x_msg_data => x_msg_data);
1069:
1070: x_return_status := l_return_status;
1071: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1072: okl_debug_pub.log_debug(fnd_log.level_procedure
1073: ,l_module
1074: ,'end debug OKLRQQHB.pls call delete_qql');
1075: END IF;
1076:

Line 1286: l_debug_enabled := NVL(okl_debug_pub.check_log_enabled,'N');

1282: /* sosharma end changes */
1283:
1284:
1285: BEGIN
1286: l_debug_enabled := NVL(okl_debug_pub.check_log_enabled,'N');
1287: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
1288: ,fnd_log.level_procedure);
1289:
1290: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN

Line 1287: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module

1283:
1284:
1285: BEGIN
1286: l_debug_enabled := NVL(okl_debug_pub.check_log_enabled,'N');
1287: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
1288: ,fnd_log.level_procedure);
1289:
1290: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1291: okl_debug_pub.log_debug(fnd_log.level_procedure

Line 1291: okl_debug_pub.log_debug(fnd_log.level_procedure

1287: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
1288: ,fnd_log.level_procedure);
1289:
1290: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1291: okl_debug_pub.log_debug(fnd_log.level_procedure
1292: ,l_module
1293: ,'begin debug OKLRQQHB.pls call handle_quick_quote');
1294: END IF;
1295: -- check for logging at STATEMENT level

Line 1296: is_debug_statement_on := okl_debug_pub.check_log_on(l_module

1292: ,l_module
1293: ,'begin debug OKLRQQHB.pls call handle_quick_quote');
1294: END IF;
1295: -- check for logging at STATEMENT level
1296: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
1297: ,fnd_log.level_statement);
1298:
1299: -- call START_ACTIVITY to create savepoint, check compatibility
1300: -- and initialize message list

Line 2124: okl_debug_pub.log_debug(fnd_log.level_procedure

2120: COMMIT;
2121: END IF;
2122:
2123: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2124: okl_debug_pub.log_debug(fnd_log.level_procedure
2125: ,l_module
2126: ,'end debug OKLRQQHB.pls call handle_quick_quote');
2127: END IF;
2128: EXCEPTION

Line 2407: l_debug_enabled := nvl(okl_debug_pub.check_log_enabled,'N');

2403: WHERE LEASE_OPPORTUNITY_ID = l_lopp_id;
2404:
2405: BEGIN
2406:
2407: l_debug_enabled := nvl(okl_debug_pub.check_log_enabled,'N');
2408: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
2409: ,fnd_log.level_procedure);
2410:
2411: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN

Line 2408: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module

2404:
2405: BEGIN
2406:
2407: l_debug_enabled := nvl(okl_debug_pub.check_log_enabled,'N');
2408: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
2409: ,fnd_log.level_procedure);
2410:
2411: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2412: okl_debug_pub.log_debug(fnd_log.level_procedure

Line 2412: okl_debug_pub.log_debug(fnd_log.level_procedure

2408: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
2409: ,fnd_log.level_procedure);
2410:
2411: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2412: okl_debug_pub.log_debug(fnd_log.level_procedure
2413: ,l_module
2414: ,'begin debug OKLRQQHB.pls call duplicate_quick_qte');
2415: END IF;
2416: -- check for logging on STATEMENT level

Line 2417: is_debug_statement_on := okl_debug_pub.check_log_on(l_module

2413: ,l_module
2414: ,'begin debug OKLRQQHB.pls call duplicate_quick_qte');
2415: END IF;
2416: -- check for logging on STATEMENT level
2417: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
2418: ,fnd_log.level_statement);
2419:
2420: -- call START_ACTIVITY to create savepoint, check compatibility
2421: -- and initialize message list