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 FND_LOG

Line 65: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.CREATE_QQH';

61: ,x_qqhv_rec_type OUT NOCOPY qqhv_rec_type ) IS
62:
63: lp_qqhv_rec_type qqhv_rec_type;
64: lx_qqhv_rec_type qqhv_rec_type;
65: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.CREATE_QQH';
66: l_debug_enabled VARCHAR2(10);
67: is_debug_procedure_on BOOLEAN;
68: is_debug_statement_on BOOLEAN;
69: l_api_name CONSTANT VARCHAR2(30) := 'create_qqh';

Line 76: ,fnd_log.level_procedure);

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
80: ,l_module

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 85: ,fnd_log.level_statement);

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
89:

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 190: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.CREATE_QQL';

186: ,x_qqlv_tbl_type OUT NOCOPY qqlv_tbl_type) IS
187:
188: lp_qqlv_tbl_type qqlv_tbl_type;
189: lx_qqlv_tbl_type qqlv_tbl_type;
190: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.CREATE_QQL';
191: l_debug_enabled VARCHAR2(10);
192: is_debug_procedure_on BOOLEAN;
193: is_debug_statement_on BOOLEAN;
194: l_api_name CONSTANT VARCHAR2(30) := 'create_qql';

Line 201: ,fnd_log.level_procedure);

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
205: ,l_module

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 210: ,fnd_log.level_statement);

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
214:

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 300: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.CREATE_QUICK_QTE';

296: lp_qqhv_rec_type qqhv_rec_type;
297: lx_qqhv_rec_type qqhv_rec_type;
298: lp_qqlv_tbl_type qqlv_tbl_type;
299: lx_qqlv_tbl_type qqlv_tbl_type;
300: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.CREATE_QUICK_QTE';
301: l_debug_enabled VARCHAR2(10);
302: is_debug_procedure_on BOOLEAN;
303: is_debug_statement_on BOOLEAN;
304: l_api_name CONSTANT VARCHAR2(30) := 'create_quick_qte';

Line 312: ,fnd_log.level_procedure);

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
316: ,l_module

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 321: ,fnd_log.level_statement);

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
325:

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 435: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.UPDATE_QQH';

431: ,p_qqhv_rec_type IN qqhv_rec_type
432: ,x_qqhv_rec_type OUT NOCOPY qqhv_rec_type) IS
433: lp_qqhv_rec_type qqhv_rec_type;
434: lx_qqhv_rec_type qqhv_rec_type;
435: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.UPDATE_QQH';
436: l_debug_enabled VARCHAR2(10);
437: is_debug_procedure_on BOOLEAN;
438: is_debug_statement_on BOOLEAN;
439: l_api_name CONSTANT VARCHAR2(30) := 'update_qqh';

Line 446: ,fnd_log.level_procedure);

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
450: ,l_module

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 454: ,fnd_log.level_statement);

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
458:

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 569: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.CANCEL_QUICK_QUOTE';

565: ,p_qqhv_rec_type IN qqhv_rec_type
566: ,x_qqhv_rec_type OUT NOCOPY qqhv_rec_type) IS
567: lp_qqhv_rec_type qqhv_rec_type;
568: lx_qqhv_rec_type qqhv_rec_type;
569: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.CANCEL_QUICK_QUOTE';
570: QQ_CANCELLED CONSTANT okl_quick_quotes_b.sts_code%TYPE := 'CANCELLED';
571: l_debug_enabled VARCHAR2(10);
572: is_debug_procedure_on BOOLEAN;
573: is_debug_statement_on BOOLEAN;

Line 581: ,fnd_log.level_procedure);

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
585: ,l_module

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 589: ,fnd_log.level_statement);

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
593:

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 678: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.UPDATE_QQL';

674: ,x_qqlv_tbl_type OUT NOCOPY qqlv_tbl_type) IS
675:
676: lp_qqlv_tbl_type qqlv_tbl_type := p_qqlv_tbl_type; --dkagrawa assigned the in value
677: lx_qqlv_tbl_type qqlv_tbl_type;
678: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.UPDATE_QQL';
679: l_debug_enabled VARCHAR2(10);
680: is_debug_procedure_on BOOLEAN;
681: is_debug_statement_on BOOLEAN;
682: l_api_name CONSTANT VARCHAR2(30) := 'update_qql';

Line 689: ,fnd_log.level_procedure);

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
693: ,l_module

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 697: ,fnd_log.level_statement);

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
701:

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 786: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.UPDATE_QUICK_QTE';

782: lp_qqhv_rec_type qqhv_rec_type;
783: lx_qqhv_rec_type qqhv_rec_type;
784: lp_qqlv_tbl_type qqlv_tbl_type;
785: lx_qqlv_tbl_type qqlv_tbl_type;
786: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.UPDATE_QUICK_QTE';
787: l_debug_enabled VARCHAR2(10);
788: is_debug_procedure_on BOOLEAN;
789: is_debug_statement_on BOOLEAN;
790: l_api_name CONSTANT VARCHAR2(30) := 'update_quick_qte';

Line 797: ,fnd_log.level_procedure);

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
801: ,l_module

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 805: ,fnd_log.level_statement);

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
809:

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 918: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.DELETE_QQL';

914: l_api_name CONSTANT VARCHAR2(30) := 'delete_qql';
915: l_api_version CONSTANT NUMBER := 1.0;
916: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
917: l_qqlv_rec qqlv_rec_type := p_qqlv_rec_type;
918: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.DELETE_QQL';
919: l_debug_enabled VARCHAR2(10);
920: is_debug_procedure_on BOOLEAN;
921: is_debug_statement_on BOOLEAN;
922:

Line 926: ,fnd_log.level_procedure);

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
930: ,l_module

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 934: ,fnd_log.level_statement);

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
938:

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 1015: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.DELETE_QQL';

1011: l_api_name CONSTANT VARCHAR2(30) := 'delete_qql';
1012: l_api_version CONSTANT NUMBER := 1.0;
1013: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1014: l_qqlv_tbl qqlv_tbl_type := p_qqlv_tbl_type;
1015: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.DELETE_QQL';
1016: l_debug_enabled VARCHAR2(10);
1017: is_debug_procedure_on BOOLEAN;
1018: is_debug_statement_on BOOLEAN;
1019:

Line 1023: ,fnd_log.level_procedure);

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
1027: ,l_module

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 1031: ,fnd_log.level_statement);

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
1035:

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 1138: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.handle_quick_quote';

1134: lxx_qqlv_tbl_type qqlv_tbl_type;
1135: lp_qqlv_rec qqlv_rec_type;
1136: lx_qqlv_rec qqlv_rec_type;
1137:
1138: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.handle_quick_quote';
1139: l_debug_enabled VARCHAR2(10);
1140: is_debug_procedure_on BOOLEAN;
1141: is_debug_statement_on BOOLEAN;
1142: l_item_name VARCHAR2(240);

Line 1288: ,fnd_log.level_procedure);

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
1292: ,l_module

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 1297: ,fnd_log.level_statement);

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
1301:

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 2392: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.DUPLICATE_QUICK_QTE';

2388: l_quote_lines_tbl qqlv_tbl_type;
2389: x_quick_qte_rec qqhv_rec_type;
2390: x_quick_qte_lines_tbl qqlv_tbl_type;
2391:
2392: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.DUPLICATE_QUICK_QTE';
2393: l_debug_enabled VARCHAR2(10);
2394: is_debug_procedure_on BOOLEAN;
2395: is_debug_statement_on BOOLEAN;
2396: l_api_name CONSTANT VARCHAR2(30) := 'duplicate_quick_qte';

Line 2409: ,fnd_log.level_procedure);

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
2413: ,l_module

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 2418: ,fnd_log.level_statement);

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
2422: