DBA Data[Home] [Help]

APPS.OKL_EC_UPTAKE_PVT dependencies on FND_LOG

Line 14: l_module CONSTANT fnd_log_messages.module%TYPE := 'ECUPTAKE';

10: ,x_return_status OUT NOCOPY VARCHAR2) IS
11:
12: i INTEGER;
13: l_msg_count NUMBER;
14: l_module CONSTANT fnd_log_messages.module%TYPE := 'ECUPTAKE';
15: l_debug_enabled varchar2(10);
16: is_debug_procedure_on boolean;
17: is_debug_statement_on boolean;
18: x_msg_data VARCHAR2(2000);

Line 102: ,fnd_log.level_procedure);

98: --Bug 5045505 ssdeshpa start
99: BEGIN
100: l_debug_enabled := okl_debug_pub.check_log_enabled;
101: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
102: ,fnd_log.level_procedure);
103:
104:
105: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
106: okl_debug_pub.log_debug(fnd_log.level_procedure

Line 106: okl_debug_pub.log_debug(fnd_log.level_procedure

102: ,fnd_log.level_procedure);
103:
104:
105: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
106: okl_debug_pub.log_debug(fnd_log.level_procedure
107: ,l_module
108: ,'begin debug OKLRECXB.pls call populate_lq_attributes');
109: END IF; -- check for logging on STATEMENT level
110: is_debug_statement_on := okl_debug_pub.check_log_on(l_module

Line 111: ,fnd_log.level_statement);

107: ,l_module
108: ,'begin debug OKLRECXB.pls call populate_lq_attributes');
109: END IF; -- check for logging on STATEMENT level
110: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
111: ,fnd_log.level_statement);
112: -- call START_ACTIVITY to create savepoint, check compatibility
113: -- and initialize message list
114: l_return_status := okl_api.start_activity(p_api_name => l_api_name
115: ,p_pkg_name => G_PKG_NAME

Line 180: okl_debug_pub.log_debug(fnd_log.level_statement

176: CLOSE c_lapp_rec;
177: END IF;
178:
179: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
180: okl_debug_pub.log_debug(fnd_log.level_statement
181: ,l_module
182: ,'okl_ec_uptake_pvt.populate_lq_attributes returned with status ' ||
183: l_return_status ||
184: ' x_msg_data ' ||

Line 197: okl_debug_pub.log_debug(fnd_log.level_procedure

193: okl_api.end_activity(x_msg_count => l_msg_count
194: ,x_msg_data => x_msg_data);
195:
196: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
197: okl_debug_pub.log_debug(fnd_log.level_procedure
198: ,l_module
199: ,'end debug OKL_EC_UPTAKE_PVT.pls call populate_lq_attributes');
200: END IF;
201: EXCEPTION

Line 235: l_module CONSTANT fnd_log_messages.module%TYPE := 'lrs';

231:
232: FUNCTION get_vp_id(p_target_id number) RETURN NUMBER IS
233:
234: l_vendor_prog_id NUMBER;
235: l_module CONSTANT fnd_log_messages.module%TYPE := 'lrs';
236: l_debug_enabled varchar2(10);
237: is_debug_procedure_on boolean;
238: is_debug_statement_on boolean;
239: l_api_version CONSTANT number := 1.0;

Line 317: l_module CONSTANT fnd_log_messages.module%TYPE := 'lrs1';

313: l_okl_lrs_rec okl_lease_rate_set_rec_type;
314: l_okl_ec_rec_type okl_ec_evaluate_pvt.okl_ec_rec_type;
315: l_okl_lrs_table okl_lease_rate_set_tbl_type;
316: i INTEGER;
317: l_module CONSTANT fnd_log_messages.module%TYPE := 'lrs1';
318: l_debug_enabled varchar2(10);
319: is_debug_procedure_on boolean;
320: is_debug_statement_on boolean;
321: l_api_version CONSTANT number := 1.0;

Line 352: ,fnd_log.level_procedure);

348:
349: BEGIN
350: l_debug_enabled := okl_debug_pub.check_log_enabled;
351: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
352: ,fnd_log.level_procedure);
353:
354:
355: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
356: okl_debug_pub.log_debug(fnd_log.level_procedure

Line 356: okl_debug_pub.log_debug(fnd_log.level_procedure

352: ,fnd_log.level_procedure);
353:
354:
355: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
356: okl_debug_pub.log_debug(fnd_log.level_procedure
357: ,l_module
358: ,'begin debug OKLRECXB.pls call populate_lrs1');
359: END IF; -- check for logging on STATEMENT level
360: is_debug_statement_on := okl_debug_pub.check_log_on(l_module

Line 361: ,fnd_log.level_statement);

357: ,l_module
358: ,'begin debug OKLRECXB.pls call populate_lrs1');
359: END IF; -- check for logging on STATEMENT level
360: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
361: ,fnd_log.level_statement);
362:
363: -- call START_ACTIVITY to create savepoint, check compatibility
364: -- and initialize message list
365:

Line 440: okl_debug_pub.log_debug(fnd_log.level_statement

436:
437: x_okl_lrs_table:=l_okl_lrs_table;
438:
439: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
440: okl_debug_pub.log_debug(fnd_log.level_statement
441: ,l_module
442: ,'okl_ec_uptake_pvt.populate_lease_rate_set returned with status ' ||
443: l_return_status ||
444: ' x_msg_data ' ||

Line 457: okl_debug_pub.log_debug(fnd_log.level_procedure

453: okl_api.end_activity(x_msg_count => x_msg_count
454: ,x_msg_data => x_msg_data);
455:
456: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
457: okl_debug_pub.log_debug(fnd_log.level_procedure
458: ,l_module
459: ,'end debug OKL_EC_UPTAKE_PVT.pls call populate_lease_rate_set');
460: END IF;
461: EXCEPTION

Line 524: l_module CONSTANT fnd_log_messages.module%TYPE := 'lrs';

520: l_okl_ec_rec_type okl_ec_evaluate_pvt.okl_ec_rec_type;
521: l_okl_srt_table okl_std_rate_tmpl_tbl_type;
522: l_api_version CONSTANT number := 1.0;
523: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
524: l_module CONSTANT fnd_log_messages.module%TYPE := 'lrs';
525: l_debug_enabled varchar2(10);
526: is_debug_procedure_on boolean;
527: is_debug_statement_on boolean;
528: i INTEGER;

Line 618: ,fnd_log.level_procedure);

614: BEGIN
615:
616: l_debug_enabled := okl_debug_pub.check_log_enabled;
617: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
618: ,fnd_log.level_procedure);
619:
620: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
621: okl_debug_pub.log_debug(fnd_log.level_procedure
622: ,l_module

Line 621: okl_debug_pub.log_debug(fnd_log.level_procedure

617: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
618: ,fnd_log.level_procedure);
619:
620: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
621: okl_debug_pub.log_debug(fnd_log.level_procedure
622: ,l_module
623: ,'begin debug OKLRECXB.pls call populate_srt');
624: END IF; -- check for logging on STATEMENT level
625: is_debug_statement_on := okl_debug_pub.check_log_on(l_module

Line 626: ,fnd_log.level_statement);

622: ,l_module
623: ,'begin debug OKLRECXB.pls call populate_srt');
624: END IF; -- check for logging on STATEMENT level
625: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
626: ,fnd_log.level_statement);
627: -- call START_ACTIVITY to create savepoint, check compatibility
628: -- and initialize message list
629:
630: l_return_status := okl_api.start_activity(p_api_name => l_api_name

Line 745: okl_debug_pub.log_debug(fnd_log.level_statement

741: END LOOP;
742: --Bug # 5045505 ssdeshpa end
743: x_okl_srt_table:=l_okl_srt_table;
744: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
745: okl_debug_pub.log_debug(fnd_log.level_statement
746: ,l_module
747: ,'okl_ec_uptake_pvt.populate_standard_rate_template returned with status ' ||
748: l_return_status ||
749: ' x_msg_data ' ||

Line 762: okl_debug_pub.log_debug(fnd_log.level_procedure

758: okl_api.end_activity(x_msg_count => x_msg_count
759: ,x_msg_data => x_msg_data);
760:
761: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
762: okl_debug_pub.log_debug(fnd_log.level_procedure
763: ,l_module
764: ,'end debug OKL_EC_UPTAKE_PVT.pls call populate_standard_rate_template');
765: END IF;
766: EXCEPTION

Line 816: l_module CONSTANT fnd_log_messages.module%TYPE := 'lrs';

812: l_okl_lrs_table okl_lease_rate_set_tbl_type;
813: i INTEGER;
814: x_eligible boolean;
815: l_validation_mode VARCHAR2(30);
816: l_module CONSTANT fnd_log_messages.module%TYPE := 'lrs';
817: l_debug_enabled varchar2(10);
818: is_debug_procedure_on boolean;
819: is_debug_statement_on boolean;
820: l_api_version CONSTANT number := 1.0;

Line 847: ,fnd_log.level_procedure);

843:
844: BEGIN
845: l_debug_enabled := okl_debug_pub.check_log_enabled;
846: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
847: ,fnd_log.level_procedure);
848:
849:
850: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
851: okl_debug_pub.log_debug(fnd_log.level_procedure

Line 851: okl_debug_pub.log_debug(fnd_log.level_procedure

847: ,fnd_log.level_procedure);
848:
849:
850: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
851: okl_debug_pub.log_debug(fnd_log.level_procedure
852: ,l_module
853: ,'begin debug OKLRECXB.pls.pls call populate_lease_rate_set2');
854: END IF; -- check for logging on STATEMENT level
855: is_debug_statement_on := okl_debug_pub.check_log_on(l_module

Line 856: ,fnd_log.level_statement);

852: ,l_module
853: ,'begin debug OKLRECXB.pls.pls call populate_lease_rate_set2');
854: END IF; -- check for logging on STATEMENT level
855: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
856: ,fnd_log.level_statement);
857:
858: -- call START_ACTIVITY to create savepoint, check compatibility
859: -- and initialize message list
860:

Line 925: okl_debug_pub.log_debug(fnd_log.level_statement

921: END IF;
922: END LOOP;
923: x_okl_lrs_table:=l_okl_lrs_table;
924: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
925: okl_debug_pub.log_debug(fnd_log.level_statement
926: ,l_module
927: ,'OKLRECXB.pls.pls call populate_lease_rate_set2 returned with status ' ||
928: l_return_status ||
929: ' x_msg_data ' ||

Line 942: okl_debug_pub.log_debug(fnd_log.level_procedure

938: okl_api.end_activity(x_msg_count => x_msg_count
939: ,x_msg_data => x_msg_data);
940:
941: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
942: okl_debug_pub.log_debug(fnd_log.level_procedure
943: ,l_module
944: ,'end debug OKLRECXB.pls call populate_lease_rate_set2');
945: END IF;
946: EXCEPTION

Line 995: l_module CONSTANT fnd_log_messages.module%TYPE := 'srt';

991: l_okl_srt_rec okl_std_rate_tmpl_rec_type;
992: l_okl_ec_rec_type okl_ec_evaluate_pvt.okl_ec_rec_type;
993: l_okl_srt_table okl_std_rate_tmpl_tbl_type;
994: l_validation_mode VARCHAR2(30);
995: l_module CONSTANT fnd_log_messages.module%TYPE := 'srt';
996: l_debug_enabled varchar2(10);
997: is_debug_procedure_on boolean;
998: is_debug_statement_on boolean;
999: l_api_version CONSTANT number := 1.0;

Line 1088: ,fnd_log.level_procedure);

1084:
1085: BEGIN
1086: l_debug_enabled := okl_debug_pub.check_log_enabled;
1087: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
1088: ,fnd_log.level_procedure);
1089:
1090:
1091: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1092: okl_debug_pub.log_debug(fnd_log.level_procedure

Line 1092: okl_debug_pub.log_debug(fnd_log.level_procedure

1088: ,fnd_log.level_procedure);
1089:
1090:
1091: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1092: okl_debug_pub.log_debug(fnd_log.level_procedure
1093: ,l_module
1094: ,'begin debug OKLRECXB.pls call populate_standard_rate_template2');
1095: END IF; -- check for logging on STATEMENT level
1096: is_debug_statement_on := okl_debug_pub.check_log_on(l_module

Line 1097: ,fnd_log.level_statement);

1093: ,l_module
1094: ,'begin debug OKLRECXB.pls call populate_standard_rate_template2');
1095: END IF; -- check for logging on STATEMENT level
1096: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
1097: ,fnd_log.level_statement);
1098:
1099: -- call START_ACTIVITY to create savepoint, check compatibility
1100: -- and initialize message list
1101:

Line 1213: okl_debug_pub.log_debug(fnd_log.level_statement

1209: --Bug # 5045505 ssdeshpa End;
1210: END LOOP;
1211: x_okl_srt_table:=l_okl_srt_table;
1212: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
1213: okl_debug_pub.log_debug(fnd_log.level_statement
1214: ,l_module
1215: ,'OKL_EC_UPTAKE_PVT.populate_standard_rate_template2 returned with status ' ||
1216: l_return_status ||
1217: ' x_msg_data ' ||

Line 1230: okl_debug_pub.log_debug(fnd_log.level_procedure

1226: okl_api.end_activity(x_msg_count => x_msg_count
1227: ,x_msg_data => x_msg_data);
1228:
1229: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1230: okl_debug_pub.log_debug(fnd_log.level_procedure
1231: ,l_module
1232: ,'end debug OKL_EC_UPTAKE_PVT.populate_standard_rate_template2 call create_vls');
1233: END IF;
1234: EXCEPTION

Line 1276: l_module CONSTANT fnd_log_messages.module%TYPE := 'lrs';

1272: x_msg_data OUT NOCOPY VARCHAR2) IS
1273: l_vendor_prog_id NUMBER;
1274: l_return_status VARCHAR2(1);
1275: l_program_name CONSTANT VARCHAR2(30) := 'p_pdt';
1276: l_module CONSTANT fnd_log_messages.module%TYPE := 'lrs';
1277: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;
1278: l_okl_prod_rec okl_prod_rec_type;
1279: l_okl_ec_rec_type okl_ec_evaluate_pvt.okl_ec_rec_type;
1280: l_okl_prod_table okl_prod_tbl_type;

Line 1335: ,fnd_log.level_procedure);

1331:
1332: BEGIN
1333: l_debug_enabled := okl_debug_pub.check_log_enabled;
1334: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
1335: ,fnd_log.level_procedure);
1336:
1337:
1338: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1339: okl_debug_pub.log_debug(fnd_log.level_procedure

Line 1339: okl_debug_pub.log_debug(fnd_log.level_procedure

1335: ,fnd_log.level_procedure);
1336:
1337:
1338: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1339: okl_debug_pub.log_debug(fnd_log.level_procedure
1340: ,l_module
1341: ,'begin debug OKLRECXB.pls call populate_product');
1342: END IF; -- check for logging on STATEMENT level
1343: is_debug_statement_on := okl_debug_pub.check_log_on(l_module

Line 1344: ,fnd_log.level_statement);

1340: ,l_module
1341: ,'begin debug OKLRECXB.pls call populate_product');
1342: END IF; -- check for logging on STATEMENT level
1343: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
1344: ,fnd_log.level_statement);
1345:
1346: -- call START_ACTIVITY to create savepoint, check compatibility
1347: -- and initialize message list
1348:

Line 1434: okl_debug_pub.log_debug(fnd_log.level_statement

1430: end if;
1431: x_okl_prod_table:=l_okl_prod_table;
1432:
1433: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
1434: okl_debug_pub.log_debug(fnd_log.level_statement
1435: ,l_module
1436: ,'OKL_EC_UPTAKE_PVT.populate_product returned with status ' ||
1437: l_return_status ||
1438: ' x_msg_data ' ||

Line 1451: okl_debug_pub.log_debug(fnd_log.level_procedure

1447: okl_api.end_activity(x_msg_count => x_msg_count
1448: ,x_msg_data => x_msg_data);
1449:
1450: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1451: okl_debug_pub.log_debug(fnd_log.level_procedure
1452: ,l_module
1453: ,'end debug OKL_EC_UPTAKE_PVT.populate_product ');
1454: END IF;
1455: EXCEPTION

Line 1517: l_module CONSTANT fnd_log_messages.module%TYPE := 'VPA';

1513: l_debug_enabled varchar2(10);
1514: is_debug_procedure_on boolean;
1515: is_debug_statement_on boolean;
1516:
1517: l_module CONSTANT fnd_log_messages.module%TYPE := 'VPA';
1518:
1519:
1520:
1521: CURSOR c_vp_rec(effective_start_date DATE) IS

Line 1535: ,fnd_log.level_procedure);

1531:
1532: BEGIN
1533: l_debug_enabled := okl_debug_pub.check_log_enabled;
1534: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
1535: ,fnd_log.level_procedure);
1536:
1537:
1538: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1539: okl_debug_pub.log_debug(fnd_log.level_procedure

Line 1539: okl_debug_pub.log_debug(fnd_log.level_procedure

1535: ,fnd_log.level_procedure);
1536:
1537:
1538: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1539: okl_debug_pub.log_debug(fnd_log.level_procedure
1540: ,l_module
1541: ,'begin debug OKLRECXB.pls call populate_vendor_program');
1542: END IF; -- check for logging on STATEMENT level
1543: is_debug_statement_on := okl_debug_pub.check_log_on(l_module

Line 1544: ,fnd_log.level_statement);

1540: ,l_module
1541: ,'begin debug OKLRECXB.pls call populate_vendor_program');
1542: END IF; -- check for logging on STATEMENT level
1543: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
1544: ,fnd_log.level_statement);
1545:
1546: -- call START_ACTIVITY to create savepoint, check compatibility
1547: -- and initialize message list
1548:

Line 1603: okl_debug_pub.log_debug(fnd_log.level_statement

1599: END IF;
1600: END LOOP;
1601: x_okl_vp_table:=l_okl_vp_table;
1602: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
1603: okl_debug_pub.log_debug(fnd_log.level_statement
1604: ,l_module
1605: ,'OKL_EC_UPTAKE_PVT.populate_vpa returned with status ' ||
1606: l_return_status ||
1607: ' x_msg_data ' ||

Line 1620: okl_debug_pub.log_debug(fnd_log.level_procedure

1616: okl_api.end_activity(x_msg_count => x_msg_count
1617: ,x_msg_data => x_msg_data);
1618:
1619: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1620: okl_debug_pub.log_debug(fnd_log.level_procedure
1621: ,l_module
1622: ,'end debug OKL_EC_UPTAKE_PVT.populate_vpa ');
1623: END IF;
1624: