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

Line 36: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_lease_rate_sets_pvt.create_lease_rate_set';

32: l_dummy_var varchar2(1) := '?';
33: l_api_name CONSTANT varchar2(30) := 'create_lrs';
34: l_api_version CONSTANT number := 1.0;
35: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
36: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_lease_rate_sets_pvt.create_lease_rate_set';
37: l_debug_enabled varchar2(10);
38: is_debug_procedure_on boolean;
39: is_debug_statement_on boolean;
40:

Line 44: ,fnd_log.level_procedure);

40:
41: BEGIN
42: l_debug_enabled := okl_debug_pub.check_log_enabled;
43: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
44: ,fnd_log.level_procedure);
45:
46: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
47: okl_debug_pub.log_debug(fnd_log.level_procedure
48: ,l_module

Line 47: okl_debug_pub.log_debug(fnd_log.level_procedure

43: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
44: ,fnd_log.level_procedure);
45:
46: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
47: okl_debug_pub.log_debug(fnd_log.level_procedure
48: ,l_module
49: ,'begin debug OKLRECCB.pls call create_lease_rate_set');
50: END IF;
51:

Line 55: ,fnd_log.level_statement);

51:
52: -- check for logging on STATEMENT level
53:
54: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
55: ,fnd_log.level_statement);
56:
57: -- call START_ACTIVITY to create savepoint, check compatibility
58: -- and initialize message list
59:

Line 205: okl_debug_pub.log_debug(fnd_log.level_procedure

201: okl_api.end_activity(x_msg_count => x_msg_count
202: ,x_msg_data => x_msg_data);
203:
204: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
205: okl_debug_pub.log_debug(fnd_log.level_procedure
206: ,l_module
207: ,'end debug OKLPLRTB.pls.pls call create_lease_rate_set');
208: END IF;
209:

Line 259: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_lease_rate_sets_pvt.update_lease_rate_set';

255: l_min_end_date date;
256: l_api_name CONSTANT varchar2(30) := 'update_lrs';
257: l_api_version CONSTANT number := 1.0;
258: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
259: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_lease_rate_sets_pvt.update_lease_rate_set';
260: l_debug_enabled varchar2(10);
261: is_debug_procedure_on boolean;
262: is_debug_statement_on boolean;
263: l_end_date_ec boolean;

Line 268: ,fnd_log.level_procedure);

264:
265: BEGIN
266: l_debug_enabled := okl_debug_pub.check_log_enabled;
267: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
268: ,fnd_log.level_procedure);
269:
270: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
271: okl_debug_pub.log_debug(fnd_log.level_procedure
272: ,l_module

Line 271: okl_debug_pub.log_debug(fnd_log.level_procedure

267: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
268: ,fnd_log.level_procedure);
269:
270: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
271: okl_debug_pub.log_debug(fnd_log.level_procedure
272: ,l_module
273: ,'begin debug OKLRECCB.pls call update_lease_rate_set');
274: END IF;
275:

Line 279: ,fnd_log.level_statement);

275:
276: -- check for logging on STATEMENT level
277:
278: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
279: ,fnd_log.level_statement);
280:
281: -- call START_ACTIVITY to create savepoint, check compatibility
282: -- and initialize message list
283:

Line 461: okl_debug_pub.log_debug(fnd_log.level_statement

457:
458: -- write to log
459:
460: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
461: okl_debug_pub.log_debug(fnd_log.level_statement
462: ,l_module
463: ,'Procedure okl_ecc_values_pvt.end_date_eligibility_criteria returned with status ' ||
464: l_return_status);
465: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 477: okl_debug_pub.log_debug(fnd_log.level_procedure

473: okl_api.end_activity(x_msg_count => x_msg_count
474: ,x_msg_data => x_msg_data);
475:
476: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
477: okl_debug_pub.log_debug(fnd_log.level_procedure
478: ,l_module
479: ,'end debug OKLPLRTB.pls.pls call update_lease_rate_set');
480: END IF;
481:

Line 552: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_lease_rate_sets_pvt.get_newversion_effective_from';

548: l_calculated_eff_to date := NULL;
549: l_std_qte_eff_from date := NULL;
550: l_qk_qte_eff_from date := NULL;
551: l_ec_start_date date := NULL;
552: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_lease_rate_sets_pvt.get_newversion_effective_from';
553: l_debug_enabled varchar2(10);
554: is_debug_procedure_on boolean;
555: is_debug_statement_on boolean;
556:

Line 560: ,fnd_log.level_procedure);

556:
557: BEGIN
558: l_debug_enabled := okl_debug_pub.check_log_enabled;
559: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
560: ,fnd_log.level_procedure);
561:
562: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
563: okl_debug_pub.log_debug(fnd_log.level_procedure
564: ,l_module

Line 563: okl_debug_pub.log_debug(fnd_log.level_procedure

559: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
560: ,fnd_log.level_procedure);
561:
562: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
563: okl_debug_pub.log_debug(fnd_log.level_procedure
564: ,l_module
565: ,'begin debug OKLRECCB.pls call get_newversion_effective_from');
566: END IF;
567:

Line 571: ,fnd_log.level_statement);

567:
568: -- check for logging on STATEMENT level
569:
570: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
571: ,fnd_log.level_statement);
572:
573: --get the previous version effective from and to
574:
575: OPEN get_prev_ver_eff_to;

Line 584: okl_debug_pub.log_debug(fnd_log.level_procedure

580: --if previous version has effective to date then return new version effective from as this date+1
581:
582: IF l_prev_ver_eff_to IS NOT NULL THEN
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: ,'end debug OKLPLRTB.pls.pls call get_newversion_effective_from');
587: END IF;
588: RETURN l_prev_ver_eff_to + 1;

Line 636: okl_debug_pub.log_debug(fnd_log.level_procedure

632: --if calculated eff to date and prev version eff to date are null return prev ver eff from +1
633:
634: IF l_calculated_eff_to IS NULL AND l_prev_ver_eff_to IS NULL THEN
635: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
636: okl_debug_pub.log_debug(fnd_log.level_procedure
637: ,l_module
638: ,'end debug OKLPLRTB.pls.pls call get_newversion_effective_from');
639: END IF;
640: RETURN l_prev_ver_eff_from + 1;

Line 647: okl_debug_pub.log_debug(fnd_log.level_procedure

643: --if calculated eff to date is not null and prev version eff to date is null return calculated eff to date +1
644:
645: IF l_calculated_eff_to IS NOT NULL AND l_prev_ver_eff_to IS NULL THEN
646: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
647: okl_debug_pub.log_debug(fnd_log.level_procedure
648: ,l_module
649: ,'end debug OKLPLRTB.pls.pls call get_newversion_effective_from');
650: END IF;
651: RETURN l_calculated_eff_to + 1;

Line 701: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_lease_rate_sets_pvt.get_lrtv_rec';

697: ,end_of_term_id
698: FROM okl_ls_rt_fctr_sets_v lrtv
699: WHERE id = p_id;
700: l_lrtv_rec lrtv_rec_type;
701: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_lease_rate_sets_pvt.get_lrtv_rec';
702: l_debug_enabled varchar2(10);
703: is_debug_procedure_on boolean;
704: is_debug_statement_on boolean;
705:

Line 709: ,fnd_log.level_procedure);

705:
706: BEGIN
707: l_debug_enabled := okl_debug_pub.check_log_enabled;
708: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
709: ,fnd_log.level_procedure);
710:
711: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
712: okl_debug_pub.log_debug(fnd_log.level_procedure
713: ,l_module

Line 712: okl_debug_pub.log_debug(fnd_log.level_procedure

708: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
709: ,fnd_log.level_procedure);
710:
711: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
712: okl_debug_pub.log_debug(fnd_log.level_procedure
713: ,l_module
714: ,'begin debug OKLRECCB.pls call get_lrtv_rec');
715: END IF;
716:

Line 720: ,fnd_log.level_statement);

716:
717: -- check for logging on STATEMENT level
718:
719: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
720: ,fnd_log.level_statement);
721: x_no_data_found := true;
722: OPEN lrtv_pk_csr(p_rate_set_id);
723: FETCH lrtv_pk_csr INTO l_lrtv_rec.id
724: ,l_lrtv_rec.object_version_number

Line 765: okl_debug_pub.log_debug(fnd_log.level_procedure

761: x_no_data_found := lrtv_pk_csr%NOTFOUND;
762: CLOSE lrtv_pk_csr;
763:
764: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
765: okl_debug_pub.log_debug(fnd_log.level_procedure
766: ,l_module
767: ,'end debug OKLPLRTB.pls.pls call get_lrtv_rec');
768: END IF;
769: RETURN(l_lrtv_rec);

Line 816: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_lease_rate_sets_pvt.get_lrvv_rec';

812: FROM okl_fe_rate_set_versions_v
813: WHERE rate_set_version_id = p_id;
814: l_lrvv_pk lrvv_pk_csr%ROWTYPE;
815: l_lrvv_rec okl_lrvv_rec;
816: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_lease_rate_sets_pvt.get_lrvv_rec';
817: l_debug_enabled varchar2(10);
818: is_debug_procedure_on boolean;
819: is_debug_statement_on boolean;
820:

Line 824: ,fnd_log.level_procedure);

820:
821: BEGIN
822: l_debug_enabled := okl_debug_pub.check_log_enabled;
823: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
824: ,fnd_log.level_procedure);
825:
826: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
827: okl_debug_pub.log_debug(fnd_log.level_procedure
828: ,l_module

Line 827: okl_debug_pub.log_debug(fnd_log.level_procedure

823: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
824: ,fnd_log.level_procedure);
825:
826: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
827: okl_debug_pub.log_debug(fnd_log.level_procedure
828: ,l_module
829: ,'begin debug OKLRECCB.pls call get_lrvv_rec');
830: END IF;
831:

Line 835: ,fnd_log.level_statement);

831:
832: -- check for logging on STATEMENT level
833:
834: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
835: ,fnd_log.level_statement);
836: x_no_data_found := true;
837:
838: --Get current data base values
839:

Line 881: okl_debug_pub.log_debug(fnd_log.level_procedure

877: x_no_data_found := lrvv_pk_csr%NOTFOUND;
878: CLOSE lrvv_pk_csr;
879:
880: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
881: okl_debug_pub.log_debug(fnd_log.level_procedure
882: ,l_module
883: ,'end debug OKLPLRTB.pls.pls call get_lrvv_rec');
884: END IF;
885: RETURN(l_lrvv_rec);

Line 923: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_lease_rate_sets_pvt.version_lease_rate_set';

919: l_new_ver_eff_from date;
920: l_api_name CONSTANT varchar2(30) := 'version_lrs';
921: l_api_version CONSTANT number := 1.0;
922: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
923: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_lease_rate_sets_pvt.version_lease_rate_set';
924: l_debug_enabled varchar2(10);
925: is_debug_procedure_on boolean;
926: is_debug_statement_on boolean;
927:

Line 931: ,fnd_log.level_procedure);

927:
928: BEGIN
929: l_debug_enabled := okl_debug_pub.check_log_enabled;
930: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
931: ,fnd_log.level_procedure);
932:
933: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
934: okl_debug_pub.log_debug(fnd_log.level_procedure
935: ,l_module

Line 934: okl_debug_pub.log_debug(fnd_log.level_procedure

930: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
931: ,fnd_log.level_procedure);
932:
933: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
934: okl_debug_pub.log_debug(fnd_log.level_procedure
935: ,l_module
936: ,'begin debug OKLRECCB.pls call version_lease_rate_set');
937: END IF;
938:

Line 942: ,fnd_log.level_statement);

938:
939: -- check for logging on STATEMENT level
940:
941: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
942: ,fnd_log.level_statement);
943:
944: -- call START_ACTIVITY to create savepoint, check compatibility
945: -- and initialize message list
946:

Line 1077: okl_debug_pub.log_debug(fnd_log.level_procedure

1073: okl_api.end_activity(x_msg_count => x_msg_count
1074: ,x_msg_data => x_msg_data);
1075:
1076: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1077: okl_debug_pub.log_debug(fnd_log.level_procedure
1078: ,l_module
1079: ,'end debug OKLPLRTB.pls.pls call version_lease_rate_set');
1080: END IF;
1081:

Line 1145: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_lease_rate_sets_pvt.submit_lease_rate_set';

1141: l_api_name CONSTANT varchar2(30) := 'submit_lrs';
1142: l_api_version CONSTANT number := 1.0;
1143: x_no_data_found boolean;
1144: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
1145: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_lease_rate_sets_pvt.submit_lease_rate_set';
1146: l_debug_enabled varchar2(10);
1147: is_debug_procedure_on boolean;
1148: is_debug_statement_on boolean;
1149:

Line 1153: ,fnd_log.level_procedure);

1149:
1150: BEGIN
1151: l_debug_enabled := okl_debug_pub.check_log_enabled;
1152: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
1153: ,fnd_log.level_procedure);
1154:
1155: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1156: okl_debug_pub.log_debug(fnd_log.level_procedure
1157: ,l_module

Line 1156: okl_debug_pub.log_debug(fnd_log.level_procedure

1152: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
1153: ,fnd_log.level_procedure);
1154:
1155: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1156: okl_debug_pub.log_debug(fnd_log.level_procedure
1157: ,l_module
1158: ,'begin debug OKLRECCB.pls call submit_lease_rate_set');
1159: END IF;
1160:

Line 1164: ,fnd_log.level_statement);

1160:
1161: -- check for logging on STATEMENT level
1162:
1163: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
1164: ,fnd_log.level_statement);
1165:
1166: -- call START_ACTIVITY to create savepoint, check compatibility
1167: -- and initialize message list
1168:

Line 1248: okl_debug_pub.log_debug(fnd_log.level_statement

1244:
1245: -- write to log
1246:
1247: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
1248: okl_debug_pub.log_debug(fnd_log.level_statement
1249: ,l_module
1250: ,'Procedure okl_lrv_pvt.update_row returned with status ' ||
1251: l_return_status);
1252: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 1314: okl_debug_pub.log_debug(fnd_log.level_procedure

1310: okl_api.end_activity(x_msg_count => x_msg_count
1311: ,x_msg_data => x_msg_data);
1312:
1313: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1314: okl_debug_pub.log_debug(fnd_log.level_procedure
1315: ,l_module
1316: ,'end debug OKLPLRTB.pls.pls call submit_lease_rate_set');
1317: END IF;
1318:

Line 1387: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_lease_rate_sets_pvt.activate_lease_rate_set';

1383: lx_ecv_tbl okl_ecv_tbl;
1384: l_api_name CONSTANT varchar2(30) := 'activate_lrs';
1385: l_api_version CONSTANT number := 1.0;
1386: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
1387: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_lease_rate_sets_pvt.activate_lease_rate_set';
1388: l_debug_enabled varchar2(10);
1389: is_debug_procedure_on boolean;
1390: is_debug_statement_on boolean;
1391:

Line 1395: ,fnd_log.level_procedure);

1391:
1392: BEGIN
1393: l_debug_enabled := okl_debug_pub.check_log_enabled;
1394: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
1395: ,fnd_log.level_procedure);
1396:
1397: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1398: okl_debug_pub.log_debug(fnd_log.level_procedure
1399: ,l_module

Line 1398: okl_debug_pub.log_debug(fnd_log.level_procedure

1394: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
1395: ,fnd_log.level_procedure);
1396:
1397: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1398: okl_debug_pub.log_debug(fnd_log.level_procedure
1399: ,l_module
1400: ,'begin debug OKLPLRTB.pls call activate_lease_rate_set');
1401: END IF;
1402:

Line 1406: ,fnd_log.level_statement);

1402:
1403: -- check for logging on STATEMENT level
1404:
1405: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
1406: ,fnd_log.level_statement);
1407:
1408: -- call START_ACTIVITY to create savepoint, check compatibility
1409: -- and initialize message list
1410:

Line 1534: okl_debug_pub.log_debug(fnd_log.level_statement

1530:
1531: -- write to log
1532:
1533: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
1534: okl_debug_pub.log_debug(fnd_log.level_statement
1535: ,l_module
1536: ,'Procedure okl_ecc_values_pvt.get_eligibility_criteria returned with status ' ||
1537: l_return_status);
1538: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 1559: okl_debug_pub.log_debug(fnd_log.level_statement

1555:
1556: -- write to log
1557:
1558: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
1559: okl_debug_pub.log_debug(fnd_log.level_statement
1560: ,l_module
1561: ,'Procedure okl_ecc_values_pvt.delete_eligibility_criteria returned with status ' ||
1562: l_return_status);
1563: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 1612: okl_debug_pub.log_debug(fnd_log.level_statement

1608:
1609: -- write to log
1610:
1611: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
1612: okl_debug_pub.log_debug(fnd_log.level_statement
1613: ,l_module
1614: ,'Procedure okl_ecc_values_pvt.handle_eligibility_criteria returned with status ' ||
1615: l_return_status);
1616: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 1641: okl_debug_pub.log_debug(fnd_log.level_statement

1637:
1638: -- write to log
1639:
1640: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
1641: okl_debug_pub.log_debug(fnd_log.level_statement
1642: ,l_module
1643: ,'Procedure okl_lrv_pvt.update_row returned with status ' ||
1644: l_return_status);
1645: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 1669: okl_debug_pub.log_debug(fnd_log.level_statement

1665:
1666: -- write to log
1667:
1668: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
1669: okl_debug_pub.log_debug(fnd_log.level_statement
1670: ,l_module
1671: ,'Procedure okl_ecc_values_pvt.end_date_eligibility_criteria returned with status ' ||
1672: l_return_status);
1673: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 1695: okl_debug_pub.log_debug(fnd_log.level_statement

1691:
1692: -- write to log
1693:
1694: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
1695: okl_debug_pub.log_debug(fnd_log.level_statement
1696: ,l_module
1697: ,'Procedure okl_lrt_pvt.update_row returned with status ' ||
1698: l_return_status);
1699: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 1720: okl_debug_pub.log_debug(fnd_log.level_statement

1716:
1717: -- write to log
1718:
1719: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
1720: okl_debug_pub.log_debug(fnd_log.level_statement
1721: ,l_module
1722: ,'Procedure okl_lrv_pvt.update_row returned with status ' ||
1723: l_return_status);
1724: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 1736: okl_debug_pub.log_debug(fnd_log.level_procedure

1732: okl_api.end_activity(x_msg_count => x_msg_count
1733: ,x_msg_data => x_msg_data);
1734:
1735: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1736: okl_debug_pub.log_debug(fnd_log.level_procedure
1737: ,l_module
1738: ,'end debug OKLPLRTB.pls.pls call activate_lease_rate_set');
1739: END IF;
1740:

Line 1786: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_lease_rate_sets_pvt.create_lrs_gen_lrf';

1782: lp_lrtv_rec lrtv_rec_type;
1783: l_api_name CONSTANT varchar2(30) := 'create_lrs_gen';
1784: l_api_version CONSTANT number := 1.0;
1785: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
1786: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_lease_rate_sets_pvt.create_lrs_gen_lrf';
1787: l_debug_enabled varchar2(10);
1788: is_debug_procedure_on boolean;
1789: is_debug_statement_on boolean;
1790:

Line 1794: ,fnd_log.level_procedure);

1790:
1791: BEGIN
1792: l_debug_enabled := okl_debug_pub.check_log_enabled;
1793: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
1794: ,fnd_log.level_procedure);
1795:
1796: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1797: okl_debug_pub.log_debug(fnd_log.level_procedure
1798: ,l_module

Line 1797: okl_debug_pub.log_debug(fnd_log.level_procedure

1793: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
1794: ,fnd_log.level_procedure);
1795:
1796: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1797: okl_debug_pub.log_debug(fnd_log.level_procedure
1798: ,l_module
1799: ,'begin debug OKLRECCB.pls call create_lrs_gen_lrf');
1800: END IF;
1801:

Line 1805: ,fnd_log.level_statement);

1801:
1802: -- check for logging on STATEMENT level
1803:
1804: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
1805: ,fnd_log.level_statement);
1806:
1807: -- call START_ACTIVITY to create savepoint, check compatibility
1808: -- and initialize message list
1809:

Line 1865: okl_debug_pub.log_debug(fnd_log.level_procedure

1861: okl_api.end_activity(x_msg_count => x_msg_count
1862: ,x_msg_data => x_msg_data);
1863:
1864: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1865: okl_debug_pub.log_debug(fnd_log.level_procedure
1866: ,l_module
1867: ,'end debug OKLPLRTB.pls.pls call create_lrs_gen_lrf');
1868: END IF;
1869:

Line 1908: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_lease_rate_sets_pvt.update_lrs_gen_lrf';

1904: lp_lrtv_rec lrtv_rec_type;
1905: l_api_name CONSTANT varchar2(30) := 'update_lrs_gen';
1906: l_api_version CONSTANT number := 1.0;
1907: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
1908: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_lease_rate_sets_pvt.update_lrs_gen_lrf';
1909: l_debug_enabled varchar2(10);
1910: is_debug_procedure_on boolean;
1911: is_debug_statement_on boolean;
1912:

Line 1916: ,fnd_log.level_procedure);

1912:
1913: BEGIN
1914: l_debug_enabled := okl_debug_pub.check_log_enabled;
1915: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
1916: ,fnd_log.level_procedure);
1917:
1918: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1919: okl_debug_pub.log_debug(fnd_log.level_procedure
1920: ,l_module

Line 1919: okl_debug_pub.log_debug(fnd_log.level_procedure

1915: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
1916: ,fnd_log.level_procedure);
1917:
1918: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1919: okl_debug_pub.log_debug(fnd_log.level_procedure
1920: ,l_module
1921: ,'begin debug OKLRECCB.pls call update_lrs_gen_lrf');
1922: END IF;
1923:

Line 1927: ,fnd_log.level_statement);

1923:
1924: -- check for logging on STATEMENT level
1925:
1926: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
1927: ,fnd_log.level_statement);
1928:
1929: -- call START_ACTIVITY to create savepoint, check compatibility
1930: -- and initialize message list
1931:

Line 1987: okl_debug_pub.log_debug(fnd_log.level_procedure

1983: okl_api.end_activity(x_msg_count => x_msg_count
1984: ,x_msg_data => x_msg_data);
1985:
1986: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1987: okl_debug_pub.log_debug(fnd_log.level_procedure
1988: ,l_module
1989: ,'end debug OKLPLRTB.pls.pls call update_lrs_gen_lrf');
1990: END IF;
1991:

Line 2030: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_lease_rate_sets_pvt.version_lrs_gen_lrf';

2026: lp_lrtv_rec lrtv_rec_type;
2027: l_api_name CONSTANT varchar2(30) := 'version_lrs_gen';
2028: l_api_version CONSTANT number := 1.0;
2029: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
2030: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_lease_rate_sets_pvt.version_lrs_gen_lrf';
2031: l_debug_enabled varchar2(10);
2032: is_debug_procedure_on boolean;
2033: is_debug_statement_on boolean;
2034:

Line 2038: ,fnd_log.level_procedure);

2034:
2035: BEGIN
2036: l_debug_enabled := okl_debug_pub.check_log_enabled;
2037: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
2038: ,fnd_log.level_procedure);
2039:
2040: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2041: okl_debug_pub.log_debug(fnd_log.level_procedure
2042: ,l_module

Line 2041: okl_debug_pub.log_debug(fnd_log.level_procedure

2037: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
2038: ,fnd_log.level_procedure);
2039:
2040: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2041: okl_debug_pub.log_debug(fnd_log.level_procedure
2042: ,l_module
2043: ,'begin debug OKLRECCB.pls call version_lrs_gen_lrf');
2044: END IF;
2045:

Line 2049: ,fnd_log.level_statement);

2045:
2046: -- check for logging on STATEMENT level
2047:
2048: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
2049: ,fnd_log.level_statement);
2050:
2051: -- call START_ACTIVITY to create savepoint, check compatibility
2052: -- and initialize message list
2053:

Line 2109: okl_debug_pub.log_debug(fnd_log.level_procedure

2105: okl_api.end_activity(x_msg_count => x_msg_count
2106: ,x_msg_data => x_msg_data);
2107:
2108: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2109: okl_debug_pub.log_debug(fnd_log.level_procedure
2110: ,l_module
2111: ,'end debug OKLPLRTB.pls.pls call version_lrs_gen_lrf');
2112: END IF;
2113:

Line 2152: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_lease_rate_sets_pvt.create_lrs_gen_lrf_submit';

2148: lp_lrtv_rec lrtv_rec_type;
2149: l_api_name CONSTANT varchar2(30) := 'crt_lrs_gen_sub';
2150: l_api_version CONSTANT number := 1.0;
2151: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
2152: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_lease_rate_sets_pvt.create_lrs_gen_lrf_submit';
2153: l_debug_enabled varchar2(10);
2154: is_debug_procedure_on boolean;
2155: is_debug_statement_on boolean;
2156:

Line 2160: ,fnd_log.level_procedure);

2156:
2157: BEGIN
2158: l_debug_enabled := okl_debug_pub.check_log_enabled;
2159: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
2160: ,fnd_log.level_procedure);
2161:
2162: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2163: okl_debug_pub.log_debug(fnd_log.level_procedure
2164: ,l_module

Line 2163: okl_debug_pub.log_debug(fnd_log.level_procedure

2159: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
2160: ,fnd_log.level_procedure);
2161:
2162: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2163: okl_debug_pub.log_debug(fnd_log.level_procedure
2164: ,l_module
2165: ,'begin debug OKLRECCB.pls call create_lrs_gen_lrf_submit');
2166: END IF;
2167:

Line 2171: ,fnd_log.level_statement);

2167:
2168: -- check for logging on STATEMENT level
2169:
2170: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
2171: ,fnd_log.level_statement);
2172:
2173: -- call START_ACTIVITY to create savepoint, check compatibility
2174: -- and initialize message list
2175:

Line 2246: okl_debug_pub.log_debug(fnd_log.level_procedure

2242: okl_api.end_activity(x_msg_count => x_msg_count
2243: ,x_msg_data => x_msg_data);
2244:
2245: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2246: okl_debug_pub.log_debug(fnd_log.level_procedure
2247: ,l_module
2248: ,'end debug OKLPLRTB.pls.pls call create_lrs_gen_lrf_submit');
2249: END IF;
2250:

Line 2289: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_lease_rate_sets_pvt.update_lrs_gen_lrf_submit';

2285: lp_lrtv_rec lrtv_rec_type;
2286: l_api_name CONSTANT varchar2(30) := 'upd_lrs_gen_sub';
2287: l_api_version CONSTANT number := 1.0;
2288: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
2289: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_lease_rate_sets_pvt.update_lrs_gen_lrf_submit';
2290: l_debug_enabled varchar2(10);
2291: is_debug_procedure_on boolean;
2292: is_debug_statement_on boolean;
2293:

Line 2297: ,fnd_log.level_procedure);

2293:
2294: BEGIN
2295: l_debug_enabled := okl_debug_pub.check_log_enabled;
2296: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
2297: ,fnd_log.level_procedure);
2298:
2299: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2300: okl_debug_pub.log_debug(fnd_log.level_procedure
2301: ,l_module

Line 2300: okl_debug_pub.log_debug(fnd_log.level_procedure

2296: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
2297: ,fnd_log.level_procedure);
2298:
2299: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2300: okl_debug_pub.log_debug(fnd_log.level_procedure
2301: ,l_module
2302: ,'begin debug OKLRECCB.pls call update_lrs_gen_lrf_submit');
2303: END IF;
2304:

Line 2308: ,fnd_log.level_statement);

2304:
2305: -- check for logging on STATEMENT level
2306:
2307: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
2308: ,fnd_log.level_statement);
2309:
2310: -- call START_ACTIVITY to create savepoint, check compatibility
2311: -- and initialize message list
2312:

Line 2383: okl_debug_pub.log_debug(fnd_log.level_procedure

2379: okl_api.end_activity(x_msg_count => x_msg_count
2380: ,x_msg_data => x_msg_data);
2381:
2382: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2383: okl_debug_pub.log_debug(fnd_log.level_procedure
2384: ,l_module
2385: ,'end debug OKLPLRTB.pls.pls call update_lrs_gen_lrf_submit');
2386: END IF;
2387:

Line 2426: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_lease_rate_sets_pvt.version_lrs_gen_lrf_submit';

2422: lp_lrtv_rec lrtv_rec_type;
2423: l_api_name CONSTANT varchar2(30) := 'HANDLE_ELIG_CRITERIA';
2424: l_api_version CONSTANT number := 1.0;
2425: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
2426: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_lease_rate_sets_pvt.version_lrs_gen_lrf_submit';
2427: l_debug_enabled varchar2(10);
2428: is_debug_procedure_on boolean;
2429: is_debug_statement_on boolean;
2430:

Line 2434: ,fnd_log.level_procedure);

2430:
2431: BEGIN
2432: l_debug_enabled := okl_debug_pub.check_log_enabled;
2433: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
2434: ,fnd_log.level_procedure);
2435:
2436: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2437: okl_debug_pub.log_debug(fnd_log.level_procedure
2438: ,l_module

Line 2437: okl_debug_pub.log_debug(fnd_log.level_procedure

2433: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
2434: ,fnd_log.level_procedure);
2435:
2436: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2437: okl_debug_pub.log_debug(fnd_log.level_procedure
2438: ,l_module
2439: ,'begin debug OKLRECCB.pls call version_lrs_gen_lrf_submit');
2440: END IF;
2441:

Line 2445: ,fnd_log.level_statement);

2441:
2442: -- check for logging on STATEMENT level
2443:
2444: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
2445: ,fnd_log.level_statement);
2446:
2447: -- call START_ACTIVITY to create savepoint, check compatibility
2448: -- and initialize message list
2449:

Line 2520: okl_debug_pub.log_debug(fnd_log.level_procedure

2516: okl_api.end_activity(x_msg_count => x_msg_count
2517: ,x_msg_data => x_msg_data);
2518:
2519: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2520: okl_debug_pub.log_debug(fnd_log.level_procedure
2521: ,l_module
2522: ,'end debug OKLPLRTB.pls.pls call version_lrs_gen_lrf_submit');
2523: END IF;
2524:

Line 2573: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_lease_rate_sets_pvt.validate_eot_version';

2569: l_version_number varchar2(40);
2570: l_api_name CONSTANT varchar2(30) := 'get_eot_ver';
2571: l_api_version CONSTANT number := 1.0;
2572: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
2573: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_lease_rate_sets_pvt.validate_eot_version';
2574: l_debug_enabled varchar2(10);
2575: is_debug_procedure_on boolean;
2576: is_debug_statement_on boolean;
2577:

Line 2581: ,fnd_log.level_procedure);

2577:
2578: BEGIN
2579: l_debug_enabled := okl_debug_pub.check_log_enabled;
2580: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
2581: ,fnd_log.level_procedure);
2582:
2583: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2584: okl_debug_pub.log_debug(fnd_log.level_procedure
2585: ,l_module

Line 2584: okl_debug_pub.log_debug(fnd_log.level_procedure

2580: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
2581: ,fnd_log.level_procedure);
2582:
2583: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2584: okl_debug_pub.log_debug(fnd_log.level_procedure
2585: ,l_module
2586: ,'begin debug OKLRECCB.pls call validate_eot_version');
2587: END IF;
2588:

Line 2592: ,fnd_log.level_statement);

2588:
2589: -- check for logging on STATEMENT level
2590:
2591: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
2592: ,fnd_log.level_statement);
2593:
2594: -- call START_ACTIVITY to create savepoint, check compatibility
2595: -- and initialize message list
2596:

Line 2652: okl_debug_pub.log_debug(fnd_log.level_procedure

2648: okl_api.end_activity(x_msg_count => x_msg_count
2649: ,x_msg_data => x_msg_data);
2650:
2651: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2652: okl_debug_pub.log_debug(fnd_log.level_procedure
2653: ,l_module
2654: ,'end debug OKLPLRTB.pls.pls call validate_eot_version');
2655: END IF;
2656:

Line 2719: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_lease_rate_sets_pvt.enddate_lease_rate_set';

2715: l_api_name CONSTANT varchar2(30) := 'enddate_lrs';
2716: l_api_version CONSTANT number := 1.0;
2717: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
2718: l_dummy varchar2(1) := '?';
2719: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_lease_rate_sets_pvt.enddate_lease_rate_set';
2720: l_debug_enabled varchar2(10);
2721: is_debug_procedure_on boolean;
2722: is_debug_statement_on boolean;
2723:

Line 2727: ,fnd_log.level_procedure);

2723:
2724: BEGIN
2725: l_debug_enabled := okl_debug_pub.check_log_enabled;
2726: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
2727: ,fnd_log.level_procedure);
2728:
2729: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2730: okl_debug_pub.log_debug(fnd_log.level_procedure
2731: ,l_module

Line 2730: okl_debug_pub.log_debug(fnd_log.level_procedure

2726: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
2727: ,fnd_log.level_procedure);
2728:
2729: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2730: okl_debug_pub.log_debug(fnd_log.level_procedure
2731: ,l_module
2732: ,'begin debug OKLRECCB.pls call enddate_lease_rate_set');
2733: END IF;
2734:

Line 2738: ,fnd_log.level_statement);

2734:
2735: -- check for logging on STATEMENT level
2736:
2737: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
2738: ,fnd_log.level_statement);
2739:
2740: -- call START_ACTIVITY to create savepoint, check compatibility
2741: -- and initialize message list
2742:

Line 2888: okl_debug_pub.log_debug(fnd_log.level_procedure

2884: okl_api.end_activity(x_msg_count => x_msg_count
2885: ,x_msg_data => x_msg_data);
2886:
2887: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2888: okl_debug_pub.log_debug(fnd_log.level_procedure
2889: ,l_module
2890: ,'end debug OKLPLRTB.pls.pls call enddate_lease_rate_set');
2891: END IF;
2892: