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

Line 27: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_values_pvt.validate_effective_dates';

23: l_api_name CONSTANT varchar2(61) := g_pkg_name || '.' || 'validate_effective_dates';
24: l_crit_cat varchar2(40);
25: l_crit_cat_name okl_fe_crit_cat_def_v.crit_cat_name%TYPE;
26: l_ecc_ac_flag okl_fe_crit_cat_def_b.ecc_ac_flag%TYPE;
27: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_values_pvt.validate_effective_dates';
28: l_debug_enabled varchar2(10);
29: is_debug_procedure_on boolean;
30: is_debug_statement_on boolean;
31:

Line 35: ,fnd_log.level_procedure);

31:
32: BEGIN
33: l_debug_enabled := okl_debug_pub.check_log_enabled;
34: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
35: ,fnd_log.level_procedure);
36:
37: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
38: okl_debug_pub.log_debug(fnd_log.level_procedure
39: ,l_module

Line 38: okl_debug_pub.log_debug(fnd_log.level_procedure

34: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
35: ,fnd_log.level_procedure);
36:
37: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
38: okl_debug_pub.log_debug(fnd_log.level_procedure
39: ,l_module
40: ,'begin debug OKLRECCB.pls call validate_effective_dates');
41: END IF;
42:

Line 46: ,fnd_log.level_statement);

42:
43: -- check for logging on STATEMENT level
44:
45: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
46: ,fnd_log.level_statement);
47: i := p_ecl_tbl.FIRST;
48:
49: WHILE(i <= p_ecl_tbl.LAST) LOOP
50:

Line 196: okl_debug_pub.log_debug(fnd_log.level_procedure

192: i := i + 1;
193: END LOOP;
194:
195: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
196: okl_debug_pub.log_debug(fnd_log.level_procedure
197: ,l_module
198: ,'end debug OKLRECVB.pls.pls call validate_effective_dates');
199: END IF;
200: RETURN okl_api.g_ret_sts_success;

Line 258: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_values_pvt.delete_eligibility_criteria';

254: l_api_name CONSTANT varchar2(30) := 'DELETE_ELIG_CRITERIA';
255: l_api_version CONSTANT number := 1.0;
256: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
257: l_ec_found boolean;
258: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_values_pvt.delete_eligibility_criteria';
259: l_debug_enabled varchar2(10);
260: is_debug_procedure_on boolean;
261: is_debug_statement_on boolean;
262:

Line 266: ,fnd_log.level_procedure);

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

Line 269: okl_debug_pub.log_debug(fnd_log.level_procedure

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

Line 277: ,fnd_log.level_statement);

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

Line 328: okl_debug_pub.log_debug(fnd_log.level_statement

324:
325: -- write to log
326:
327: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
328: okl_debug_pub.log_debug(fnd_log.level_statement
329: ,l_module
330: ,'Procedure okl_ech_pvt.delete_row returned with status ' ||
331: l_return_status);
332: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 352: okl_debug_pub.log_debug(fnd_log.level_statement

348:
349: -- write to log
350:
351: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
352: okl_debug_pub.log_debug(fnd_log.level_statement
353: ,l_module
354: ,'Procedure okl_ecl_pvt.delete_row returned with status ' ||
355: l_return_status);
356: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 376: okl_debug_pub.log_debug(fnd_log.level_statement

372:
373: -- write to log
374:
375: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
376: okl_debug_pub.log_debug(fnd_log.level_statement
377: ,l_module
378: ,'Procedure okl_ecv_pvt.delete_row returned with status ' ||
379: l_return_status);
380: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 395: okl_debug_pub.log_debug(fnd_log.level_procedure

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

Line 479: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_values_pvt.handle_eligibility_criteria';

475: l_child_ec_exists boolean;
476: l_api_name CONSTANT varchar2(30) := 'HANDLE_ELIG_CRITERIA';
477: l_api_version CONSTANT number := 1.0;
478: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
479: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_values_pvt.handle_eligibility_criteria';
480: l_debug_enabled varchar2(10);
481: is_debug_procedure_on boolean;
482: is_debug_statement_on boolean;
483:

Line 487: ,fnd_log.level_procedure);

483:
484: BEGIN
485: l_debug_enabled := okl_debug_pub.check_log_enabled;
486: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
487: ,fnd_log.level_procedure);
488:
489: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
490: okl_debug_pub.log_debug(fnd_log.level_procedure
491: ,l_module

Line 490: okl_debug_pub.log_debug(fnd_log.level_procedure

486: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
487: ,fnd_log.level_procedure);
488:
489: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
490: okl_debug_pub.log_debug(fnd_log.level_procedure
491: ,l_module
492: ,'begin debug OKLRECCB.pls call handle_eligibility_criteria');
493: END IF;
494:

Line 498: ,fnd_log.level_statement);

494:
495: -- check for logging on STATEMENT level
496:
497: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
498: ,fnd_log.level_statement);
499:
500: -- call START_ACTIVITY to create savepoint, check compatibility
501: -- and initialize message list
502:

Line 553: okl_debug_pub.log_debug(fnd_log.level_statement

549:
550: -- write to log
551:
552: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
553: okl_debug_pub.log_debug(fnd_log.level_statement
554: ,l_module
555: ,'Procedure okl_ech_pvt.insert_row returned with status ' ||
556: l_return_status);
557: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 578: okl_debug_pub.log_debug(fnd_log.level_statement

574:
575: -- write to log
576:
577: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
578: okl_debug_pub.log_debug(fnd_log.level_statement
579: ,l_module
580: ,'Procedure okl_ech_pvt.update_row returned with status ' ||
581: l_return_status);
582: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 616: okl_debug_pub.log_debug(fnd_log.level_statement

612:
613: -- write to log
614:
615: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
616: okl_debug_pub.log_debug(fnd_log.level_statement
617: ,l_module
618: ,'Procedure okl_ecl_pvt.insert_row returned with status ' ||
619: l_return_status);
620: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 656: okl_debug_pub.log_debug(fnd_log.level_statement

652:
653: -- write to log
654:
655: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
656: okl_debug_pub.log_debug(fnd_log.level_statement
657: ,l_module
658: ,'Procedure okl_ecv_pvt.insert_row returned with status ' ||
659: l_return_status);
660: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 678: okl_debug_pub.log_debug(fnd_log.level_statement

674:
675: -- write to log
676:
677: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
678: okl_debug_pub.log_debug(fnd_log.level_statement
679: ,l_module
680: ,'Procedure okl_ecv_pvt.update_row returned with status ' ||
681: l_return_status);
682: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 705: okl_debug_pub.log_debug(fnd_log.level_statement

701:
702: -- write to log
703:
704: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
705: okl_debug_pub.log_debug(fnd_log.level_statement
706: ,l_module
707: ,'Procedure okl_ecl_pvt.update_row returned with status ' ||
708: l_return_status);
709: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 745: okl_debug_pub.log_debug(fnd_log.level_statement

741:
742: -- write to log
743:
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: ,'Procedure okl_ecv_pvt.insert_row returned with status ' ||
748: l_return_status);
749: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 767: okl_debug_pub.log_debug(fnd_log.level_statement

763:
764: -- write to log
765:
766: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
767: okl_debug_pub.log_debug(fnd_log.level_statement
768: ,l_module
769: ,'Procedure okl_ecv_pvt.update_row returned with status ' ||
770: l_return_status);
771: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 803: okl_debug_pub.log_debug(fnd_log.level_statement

799:
800: -- write to log
801:
802: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
803: okl_debug_pub.log_debug(fnd_log.level_statement
804: ,l_module
805: ,'Procedure okl_ech_pvt.delete_row returned with status ' ||
806: l_return_status);
807: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 827: okl_debug_pub.log_debug(fnd_log.level_procedure

823: okl_api.end_activity(x_msg_count => x_msg_count
824: ,x_msg_data => x_msg_data);
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: ,'end debug OKLRECVB.pls.pls call handle_eligibility_criteria');
830: END IF;
831:

Line 875: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_values_pvt.remove_ec_line';

871: WHERE okl_fe_criterion_values.criteria_id = p_line_id;
872: l_api_name CONSTANT varchar2(30) := 'REMOVE_EC_LINE(REC)';
873: l_api_version CONSTANT number := 1.0;
874: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
875: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_values_pvt.remove_ec_line';
876: l_debug_enabled varchar2(10);
877: is_debug_procedure_on boolean;
878: is_debug_statement_on boolean;
879:

Line 883: ,fnd_log.level_procedure);

879:
880: BEGIN
881: l_debug_enabled := okl_debug_pub.check_log_enabled;
882: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
883: ,fnd_log.level_procedure);
884:
885: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
886: okl_debug_pub.log_debug(fnd_log.level_procedure
887: ,l_module

Line 886: okl_debug_pub.log_debug(fnd_log.level_procedure

882: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
883: ,fnd_log.level_procedure);
884:
885: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
886: okl_debug_pub.log_debug(fnd_log.level_procedure
887: ,l_module
888: ,'begin debug OKLRECCB.pls call remove_ec_line');
889: END IF;
890:

Line 894: ,fnd_log.level_statement);

890:
891: -- check for logging on STATEMENT level
892:
893: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
894: ,fnd_log.level_statement);
895:
896: -- call START_ACTIVITY to create savepoint, check compatibility
897: -- and initialize message list
898:

Line 957: okl_debug_pub.log_debug(fnd_log.level_procedure

953: okl_api.end_activity(x_msg_count => x_msg_count
954: ,x_msg_data => x_msg_data);
955:
956: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
957: okl_debug_pub.log_debug(fnd_log.level_procedure
958: ,l_module
959: ,'end debug OKLRECVB.pls.pls call remove_ec_line');
960: END IF;
961:

Line 1045: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_values_pvt.get_eligibility_criteria';

1041: l_api_name CONSTANT varchar2(30) := 'GET_ELIG_CRIT_DT';
1042: l_api_version CONSTANT number := 1.0;
1043: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
1044: l_ec_found boolean;
1045: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_values_pvt.get_eligibility_criteria';
1046: l_debug_enabled varchar2(10);
1047: is_debug_procedure_on boolean;
1048: is_debug_statement_on boolean;
1049:

Line 1053: ,fnd_log.level_procedure);

1049:
1050: BEGIN
1051: l_debug_enabled := okl_debug_pub.check_log_enabled;
1052: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
1053: ,fnd_log.level_procedure);
1054:
1055: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1056: okl_debug_pub.log_debug(fnd_log.level_procedure
1057: ,l_module

Line 1056: okl_debug_pub.log_debug(fnd_log.level_procedure

1052: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
1053: ,fnd_log.level_procedure);
1054:
1055: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1056: okl_debug_pub.log_debug(fnd_log.level_procedure
1057: ,l_module
1058: ,'begin debug OKLRECCB.pls call get_eligibility_criteria');
1059: END IF;
1060:

Line 1064: ,fnd_log.level_statement);

1060:
1061: -- check for logging on STATEMENT level
1062:
1063: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
1064: ,fnd_log.level_statement);
1065:
1066: -- call START_ACTIVITY to create savepoint, check compatibility
1067: -- and initialize message list
1068:

Line 1169: okl_debug_pub.log_debug(fnd_log.level_procedure

1165: okl_api.end_activity(x_msg_count => x_msg_count
1166: ,x_msg_data => x_msg_data);
1167:
1168: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1169: okl_debug_pub.log_debug(fnd_log.level_procedure
1170: ,l_module
1171: ,'end debug OKLRECVB.pls.pls call get_eligibility_criteria');
1172: END IF;
1173:

Line 1251: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_values_pvt.get_eligibility_criteria';

1247: l_api_name CONSTANT varchar2(30) := 'GET_ELIG_CRITERIA';
1248: l_api_version CONSTANT number := 1.0;
1249: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
1250: l_ec_found boolean;
1251: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_values_pvt.get_eligibility_criteria';
1252: l_debug_enabled varchar2(10);
1253: is_debug_procedure_on boolean;
1254: is_debug_statement_on boolean;
1255:

Line 1259: ,fnd_log.level_procedure);

1255:
1256: BEGIN
1257: l_debug_enabled := okl_debug_pub.check_log_enabled;
1258: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
1259: ,fnd_log.level_procedure);
1260:
1261: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1262: okl_debug_pub.log_debug(fnd_log.level_procedure
1263: ,l_module

Line 1262: okl_debug_pub.log_debug(fnd_log.level_procedure

1258: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
1259: ,fnd_log.level_procedure);
1260:
1261: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1262: okl_debug_pub.log_debug(fnd_log.level_procedure
1263: ,l_module
1264: ,'begin debug OKLRECCB.pls call get_eligibility_criteria');
1265: END IF;
1266:

Line 1270: ,fnd_log.level_statement);

1266:
1267: -- check for logging on STATEMENT level
1268:
1269: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
1270: ,fnd_log.level_statement);
1271:
1272: -- call START_ACTIVITY to create savepoint, check compatibility
1273: -- and initialize message list
1274:

Line 1334: okl_debug_pub.log_debug(fnd_log.level_procedure

1330: okl_api.end_activity(x_msg_count => x_msg_count
1331: ,x_msg_data => x_msg_data);
1332:
1333: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1334: okl_debug_pub.log_debug(fnd_log.level_procedure
1335: ,l_module
1336: ,'end debug OKLRECVB.pls.pls call get_eligibility_criteria');
1337: END IF;
1338:

Line 1399: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_values_pvt.end_date_eligibility_criteria';

1395: lx_ecl_tbl okl_ecl_tbl;
1396: l_api_name CONSTANT varchar2(30) := 'END_DT_ELIG_CRIT';
1397: l_api_version CONSTANT number := 1.0;
1398: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
1399: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_values_pvt.end_date_eligibility_criteria';
1400: l_debug_enabled varchar2(10);
1401: is_debug_procedure_on boolean;
1402: is_debug_statement_on boolean;
1403:

Line 1407: ,fnd_log.level_procedure);

1403:
1404: BEGIN
1405: l_debug_enabled := okl_debug_pub.check_log_enabled;
1406: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
1407: ,fnd_log.level_procedure);
1408:
1409: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1410: okl_debug_pub.log_debug(fnd_log.level_procedure
1411: ,l_module

Line 1410: okl_debug_pub.log_debug(fnd_log.level_procedure

1406: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
1407: ,fnd_log.level_procedure);
1408:
1409: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1410: okl_debug_pub.log_debug(fnd_log.level_procedure
1411: ,l_module
1412: ,'begin debug OKLRECCB.pls call end_date_eligibility_criteria');
1413: END IF;
1414:

Line 1418: ,fnd_log.level_statement);

1414:
1415: -- check for logging on STATEMENT level
1416:
1417: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
1418: ,fnd_log.level_statement);
1419:
1420: -- call START_ACTIVITY to create savepoint, check compatibility
1421: -- and initialize message list
1422:

Line 1473: okl_debug_pub.log_debug(fnd_log.level_statement

1469:
1470: -- write to log
1471:
1472: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
1473: okl_debug_pub.log_debug(fnd_log.level_statement
1474: ,l_module
1475: ,'Procedure okl_ecl_pvt.update_row returned with status ' ||
1476: l_return_status);
1477: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 1490: okl_debug_pub.log_debug(fnd_log.level_procedure

1486: okl_api.end_activity(x_msg_count => x_msg_count
1487: ,x_msg_data => x_msg_data);
1488:
1489: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1490: okl_debug_pub.log_debug(fnd_log.level_procedure
1491: ,l_module
1492: ,'end debug OKLRECVB.pls.pls call end_date_eligibility_criteria');
1493: END IF;
1494: