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

Line 53: l_debug_enabled := okl_debug_pub.check_log_enabled;

49: --dcshanmu bug 6734738 end
50: -- End bug 6456733
51:
52: BEGIN
53: l_debug_enabled := okl_debug_pub.check_log_enabled;
54: IF(NVL(l_debug_enabled,'N')='Y') THEN
55: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_interest_billed');
56: END IF;
57:

Line 55: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_interest_billed');

51:
52: BEGIN
53: l_debug_enabled := okl_debug_pub.check_log_enabled;
54: IF(NVL(l_debug_enabled,'N')='Y') THEN
55: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_interest_billed');
56: END IF;
57:
58: l_interest_billed := 0;
59: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 70: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVIUB.pls call get_interest_billed');

66: FETCH l_interest_billed_csr INTO l_interest_billed;
67: CLOSE l_interest_billed_csr;
68:
69: IF(NVL(l_debug_enabled,'N')='Y') THEN
70: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVIUB.pls call get_interest_billed');
71: END IF;
72:
73: RETURN l_interest_billed;
74: EXCEPTION

Line 157: l_debug_enabled := okl_debug_pub.check_log_enabled;

153: );
154: --End bug# 13893142
155:
156: BEGIN
157: l_debug_enabled := okl_debug_pub.check_log_enabled;
158: IF(NVL(l_debug_enabled,'N')='Y') THEN
159: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_interest_paid');
160: END IF;
161:

Line 159: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_interest_paid');

155:
156: BEGIN
157: l_debug_enabled := okl_debug_pub.check_log_enabled;
158: IF(NVL(l_debug_enabled,'N')='Y') THEN
159: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_interest_paid');
160: END IF;
161:
162: l_interest_paid := 0;
163: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 174: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_interest_paid');

170: FETCH l_interest_paid_csr INTO l_interest_paid;
171: CLOSE l_interest_paid_csr;
172:
173: IF(NVL(l_debug_enabled,'N')='Y') THEN
174: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_interest_paid');
175: END IF;
176:
177: RETURN l_interest_paid;
178: EXCEPTION

Line 274: l_debug_enabled := okl_debug_pub.check_log_enabled;

270:
271: l_contract_info_rec l_contract_info_csr%ROWTYPE;
272:
273: BEGIN
274: l_debug_enabled := okl_debug_pub.check_log_enabled;
275: IF(NVL(l_debug_enabled,'N')='Y') THEN
276: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_interest_due');
277: END IF;
278:

Line 276: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_interest_due');

272:
273: BEGIN
274: l_debug_enabled := okl_debug_pub.check_log_enabled;
275: IF(NVL(l_debug_enabled,'N')='Y') THEN
276: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_interest_due');
277: END IF;
278:
279: l_interest_amt := 0;
280: l_interest_due := 0;

Line 413: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVIUB.pls call get_interest_due');

409: END IF;
410: END IF;
411: END IF;
412: IF(NVL(l_debug_enabled,'N')='Y') THEN
413: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVIUB.pls call get_interest_due');
414: END IF;
415:
416: RETURN l_interest_due;
417: EXCEPTION

Line 539: l_debug_enabled := okl_debug_pub.check_log_enabled;

535: l_int_calc_basis OKL_PRODUCT_PARAMETERS_V.interest_calculation_basis%TYPE;
536: l_rev_rec_mthd OKL_PRODUCT_PARAMETERS_V.revenue_recognition_method%TYPE;
537:
538: BEGIN
539: l_debug_enabled := okl_debug_pub.check_log_enabled;
540: IF(NVL(l_debug_enabled,'N')='Y') THEN
541: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_principal_bal');
542: END IF;
543:

Line 541: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_principal_bal');

537:
538: BEGIN
539: l_debug_enabled := okl_debug_pub.check_log_enabled;
540: IF(NVL(l_debug_enabled,'N')='Y') THEN
541: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_principal_bal');
542: END IF;
543:
544: l_principal_bal := 0;
545: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 635: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVIUB.pls call get_principal_bal');

631: l_principal_bal := l_principal_balance_tbl(l_principal_balance_tbl.COUNT).principal_balance;
632: END IF;
633:
634: IF(NVL(l_debug_enabled,'N')='Y') THEN
635: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVIUB.pls call get_principal_bal');
636: END IF;
637:
638: RETURN l_principal_bal;
639: EXCEPTION

Line 831: l_debug_enabled := okl_debug_pub.check_log_enabled;

827: -- End - Billing Inline changes - Bug#5898792 - varangan - 23/2/2007
828:
829:
830: BEGIN
831: l_debug_enabled := okl_debug_pub.check_log_enabled;
832: IF(NVL(l_debug_enabled,'N')='Y') THEN
833: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_principal_paid');
834: END IF;
835:

Line 833: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_principal_paid');

829:
830: BEGIN
831: l_debug_enabled := okl_debug_pub.check_log_enabled;
832: IF(NVL(l_debug_enabled,'N')='Y') THEN
833: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_principal_paid');
834: END IF;
835:
836: l_principal_paid := 0;
837: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 848: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVIUB.pls call get_principal_paid');

844: -- End bug 6456733
845: FETCH l_principal_paid_csr INTO l_principal_paid;
846: CLOSE l_principal_paid_csr;
847: IF(NVL(l_debug_enabled,'N')='Y') THEN
848: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVIUB.pls call get_principal_paid');
849: END IF;
850:
851: RETURN l_principal_paid;
852: EXCEPTION

Line 905: l_debug_enabled := okl_debug_pub.check_log_enabled;

901: ORDER BY interest_calc_end_date DESC;
902:
903: l_var_int_params_rec l_var_int_params_csr%ROWTYPE;
904: BEGIN
905: l_debug_enabled := okl_debug_pub.check_log_enabled;
906: IF(NVL(l_debug_enabled,'N')='Y') THEN
907: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_interest_rate_change_flag');
908: END IF;
909:

Line 907: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_interest_rate_change_flag');

903: l_var_int_params_rec l_var_int_params_csr%ROWTYPE;
904: BEGIN
905: l_debug_enabled := okl_debug_pub.check_log_enabled;
906: IF(NVL(l_debug_enabled,'N')='Y') THEN
907: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_interest_rate_change_flag');
908: END IF;
909:
910: l_interest_rate_change_flag := 'N';
911: IF ( p_khr_id IS NULL ) THEN

Line 933: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVIUB.pls call get_interest_rate_change_flag');

929: l_interest_rate_change_flag := 'Y';
930: END IF;
931:
932: IF(NVL(l_debug_enabled,'N')='Y') THEN
933: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVIUB.pls call get_interest_rate_change_flag');
934: END IF;
935:
936: RETURN l_interest_rate_change_flag;
937: EXCEPTION

Line 1000: l_debug_enabled := okl_debug_pub.check_log_enabled;

996: l_end_date okl_k_headers_full_v.end_date%TYPE;
997: l_effective_date DATE := NULL;
998:
999: BEGIN
1000: l_debug_enabled := okl_debug_pub.check_log_enabled;
1001: IF(NVL(l_debug_enabled,'N')='Y') THEN
1002: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_effective_int_rate');
1003: END IF;
1004:

Line 1002: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_effective_int_rate');

998:
999: BEGIN
1000: l_debug_enabled := okl_debug_pub.check_log_enabled;
1001: IF(NVL(l_debug_enabled,'N')='Y') THEN
1002: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_effective_int_rate');
1003: END IF;
1004:
1005: l_effective_int_rate := 0;
1006: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 1043: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVIUB.pls call get_effective_int_rate');

1039: l_effective_int_rate := l_interest_rate_tbl(l_interest_rate_tbl.COUNT).rate;
1040: END IF;
1041:
1042: IF(NVL(l_debug_enabled,'N')='Y') THEN
1043: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVIUB.pls call get_effective_int_rate');
1044: END IF;
1045:
1046: RETURN l_effective_int_rate;
1047: EXCEPTION

Line 1105: l_debug_enabled := okl_debug_pub.check_log_enabled;

1101: OKL_K_HEADERS khr
1102: WHERE chr.id = khr.id
1103: AND khr.id = cp_khr_id;
1104: BEGIN
1105: l_debug_enabled := okl_debug_pub.check_log_enabled;
1106: IF(NVL(l_debug_enabled,'N')='Y') THEN
1107: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_interest_due_unbilled');
1108: END IF;
1109:

Line 1107: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_interest_due_unbilled');

1103: AND khr.id = cp_khr_id;
1104: BEGIN
1105: l_debug_enabled := okl_debug_pub.check_log_enabled;
1106: IF(NVL(l_debug_enabled,'N')='Y') THEN
1107: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_interest_due_unbilled');
1108: END IF;
1109:
1110: l_interest_billed := 0;
1111: l_interest_due := 0;

Line 1143: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVIUB.pls call get_interest_due_unbilled');

1139: END IF;
1140: l_interest_due_unbilled := l_interest_due - l_interest_billed;
1141:
1142: IF(NVL(l_debug_enabled,'N')='Y') THEN
1143: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVIUB.pls call get_interest_due_unbilled');
1144: END IF;
1145:
1146: RETURN l_interest_due_unbilled;
1147: EXCEPTION

Line 1246: l_debug_enabled := okl_debug_pub.check_log_enabled;

1242: --AND TRUNC(aps.trx_date) BETWEEN TRUNC(NVL(cp_from_date, khr.start_date)) AND TRUNC(NVL(cp_to_date, SYSDATE));
1243: ---- End - Billing Inline changes - Bug#5898792 - varangan - 23/2/2007
1244:
1245: BEGIN
1246: l_debug_enabled := okl_debug_pub.check_log_enabled;
1247: IF(NVL(l_debug_enabled,'N')='Y') THEN
1248: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_principal_billed');
1249: END IF;
1250:

Line 1248: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_principal_billed');

1244:
1245: BEGIN
1246: l_debug_enabled := okl_debug_pub.check_log_enabled;
1247: IF(NVL(l_debug_enabled,'N')='Y') THEN
1248: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_principal_billed');
1249: END IF;
1250:
1251: l_principal_billed := 0;
1252: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 1265: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVIUB.pls call get_principal_billed');

1261: FETCH l_principal_billed_csr INTO l_principal_billed;
1262: CLOSE l_principal_billed_csr;
1263:
1264: IF(NVL(l_debug_enabled,'N')='Y') THEN
1265: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVIUB.pls call get_principal_billed');
1266: END IF;
1267:
1268: RETURN l_principal_billed;
1269: EXCEPTION

Line 1350: l_debug_enabled := okl_debug_pub.check_log_enabled;

1346:
1347: -- End bug 6456733
1348: -- End - Billing Inline changes - Bug#5898792 - varangan - 23/2/2007
1349: BEGIN
1350: l_debug_enabled := okl_debug_pub.check_log_enabled;
1351: IF(NVL(l_debug_enabled,'N')='Y') THEN
1352: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_float_factor_billed');
1353: END IF;
1354:

Line 1352: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_float_factor_billed');

1348: -- End - Billing Inline changes - Bug#5898792 - varangan - 23/2/2007
1349: BEGIN
1350: l_debug_enabled := okl_debug_pub.check_log_enabled;
1351: IF(NVL(l_debug_enabled,'N')='Y') THEN
1352: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_float_factor_billed');
1353: END IF;
1354:
1355: l_float_factor_billed := 0;
1356: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 1366: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVIUB.pls call get_float_factor_billed');

1362: FETCH l_float_billed_csr INTO l_float_factor_billed;
1363: CLOSE l_float_billed_csr;
1364:
1365: IF(NVL(l_debug_enabled,'N')='Y') THEN
1366: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVIUB.pls call get_float_factor_billed');
1367: END IF;
1368:
1369: RETURN l_float_factor_billed;
1370: EXCEPTION

Line 1452: l_debug_enabled := okl_debug_pub.check_log_enabled;

1448: --End bug 6456733
1449: -- End - Billing Inline changes - Bug#5898792 - varangan - 23/2/2007
1450:
1451: BEGIN
1452: l_debug_enabled := okl_debug_pub.check_log_enabled;
1453: IF(NVL(l_debug_enabled,'N')='Y') THEN
1454: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_loan_payment_billed');
1455: END IF;
1456:

Line 1454: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_loan_payment_billed');

1450:
1451: BEGIN
1452: l_debug_enabled := okl_debug_pub.check_log_enabled;
1453: IF(NVL(l_debug_enabled,'N')='Y') THEN
1454: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_loan_payment_billed');
1455: END IF;
1456:
1457: l_loan_payment_billed := 0;
1458: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 1468: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVIUB.pls call get_loan_payment_billed');

1464: FETCH l_loan_payment_billed_csr INTO l_loan_payment_billed;
1465: CLOSE l_loan_payment_billed_csr;
1466:
1467: IF(NVL(l_debug_enabled,'N')='Y') THEN
1468: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVIUB.pls call get_loan_payment_billed');
1469: END IF;
1470:
1471: RETURN l_loan_payment_billed;
1472: EXCEPTION

Line 1561: l_debug_enabled := okl_debug_pub.check_log_enabled;

1557:
1558: -- End - Billing Inline changes - Bug#5898792 - varangan - 23/2/2007
1559:
1560: BEGIN
1561: l_debug_enabled := okl_debug_pub.check_log_enabled;
1562: IF(NVL(l_debug_enabled,'N')='Y') THEN
1563: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_loan_payment_paid');
1564: END IF;
1565:

Line 1563: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_loan_payment_paid');

1559:
1560: BEGIN
1561: l_debug_enabled := okl_debug_pub.check_log_enabled;
1562: IF(NVL(l_debug_enabled,'N')='Y') THEN
1563: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_loan_payment_paid');
1564: END IF;
1565:
1566: l_loan_payment_paid := 0;
1567: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 1577: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVIUB.pls call get_loan_payment_paid');

1573: FETCH l_laon_payment_csr INTO l_loan_payment_paid;
1574: CLOSE l_laon_payment_csr;
1575:
1576: IF(NVL(l_debug_enabled,'N')='Y') THEN
1577: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVIUB.pls call get_loan_payment_paid');
1578: END IF;
1579:
1580: RETURN l_loan_payment_paid;
1581: EXCEPTION

Line 1636: l_debug_enabled := okl_debug_pub.check_log_enabled;

1632: AND stm.sty_id = sty.id
1633: AND sty.stream_type_purpose = 'EXCESS_LOAN_PAYMENT_PAID';
1634:
1635: BEGIN
1636: l_debug_enabled := okl_debug_pub.check_log_enabled;
1637: IF(NVL(l_debug_enabled,'N')='Y') THEN
1638: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_excess_loan_payment');
1639: END IF;
1640:

Line 1638: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_excess_loan_payment');

1634:
1635: BEGIN
1636: l_debug_enabled := okl_debug_pub.check_log_enabled;
1637: IF(NVL(l_debug_enabled,'N')='Y') THEN
1638: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_excess_loan_payment');
1639: END IF;
1640:
1641: l_excess_loan_payment := 0;
1642: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 1652: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVIUB.pls call get_excess_loan_payment');

1648: FETCH l_laon_payment_csr INTO l_excess_loan_payment;
1649: CLOSE l_laon_payment_csr;
1650:
1651: IF(NVL(l_debug_enabled,'N')='Y') THEN
1652: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVIUB.pls call get_excess_loan_payment');
1653: END IF;
1654:
1655: RETURN l_excess_loan_payment;
1656: EXCEPTION

Line 1704: l_debug_enabled := okl_debug_pub.check_log_enabled;

1700: SELECT date_last_interim_interest_cal
1701: FROM okl_k_headers
1702: WHERE id = cp_khr_id;
1703: BEGIN
1704: l_debug_enabled := okl_debug_pub.check_log_enabled;
1705: IF(NVL(l_debug_enabled,'N')='Y') THEN
1706: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_last_interim_int_calc_date');
1707: END IF;
1708:

Line 1706: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_last_interim_int_calc_date');

1702: WHERE id = cp_khr_id;
1703: BEGIN
1704: l_debug_enabled := okl_debug_pub.check_log_enabled;
1705: IF(NVL(l_debug_enabled,'N')='Y') THEN
1706: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_last_interim_int_calc_date');
1707: END IF;
1708:
1709: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1710: IF ( p_khr_id IS NULL ) THEN

Line 1718: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVIUB.pls call get_last_interim_int_calc_date');

1714: OPEN l_interest_calc_date_csr(p_khr_id);
1715: FETCH l_interest_calc_date_csr INTO l_last_interest_date;
1716: CLOSE l_interest_calc_date_csr;
1717: IF(NVL(l_debug_enabled,'N')='Y') THEN
1718: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVIUB.pls call get_last_interim_int_calc_date');
1719: END IF;
1720: RETURN l_last_interest_date;
1721: EXCEPTION
1722: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1860: l_debug_enabled := okl_debug_pub.check_log_enabled;

1856: l_contract_start_date DATE;
1857: --Bug# 14049528
1858:
1859: BEGIN
1860: l_debug_enabled := okl_debug_pub.check_log_enabled;
1861: IF(NVL(l_debug_enabled,'N')='Y') THEN
1862: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_last_sch_int_calc_date');
1863: END IF;
1864: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 1862: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_last_sch_int_calc_date');

1858:
1859: BEGIN
1860: l_debug_enabled := okl_debug_pub.check_log_enabled;
1861: IF(NVL(l_debug_enabled,'N')='Y') THEN
1862: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_last_sch_int_calc_date');
1863: END IF;
1864: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1865: IF ( p_khr_id IS NULL ) THEN
1866: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2052: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVIUB.pls call get_last_sch_int_calc_date');

2048:
2049: END IF;
2050:
2051: IF(NVL(l_debug_enabled,'N')='Y') THEN
2052: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVIUB.pls call get_last_sch_int_calc_date');
2053: END IF;
2054:
2055: RETURN l_last_interest_date;
2056:

Line 2160: l_debug_enabled := okl_debug_pub.check_log_enabled;

2156:
2157: -- End - Billing Inline changes - Bug#5898792 - varangan - 23/2/2007
2158:
2159: BEGIN
2160: l_debug_enabled := okl_debug_pub.check_log_enabled;
2161: IF(NVL(l_debug_enabled,'N')='Y') THEN
2162: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_open_invoices');
2163: END IF;
2164: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 2162: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_open_invoices');

2158:
2159: BEGIN
2160: l_debug_enabled := okl_debug_pub.check_log_enabled;
2161: IF(NVL(l_debug_enabled,'N')='Y') THEN
2162: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_open_invoices');
2163: END IF;
2164: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2165: IF ( p_khr_id IS NULL ) THEN
2166: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2173: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVIUB.pls call get_open_invoices');

2169: OPEN l_invoice_info_csr(p_khr_id);
2170: FETCH l_invoice_info_csr BULK COLLECT INTO x_invoice_tbl;
2171: CLOSE l_invoice_info_csr;
2172: IF(NVL(l_debug_enabled,'N')='Y') THEN
2173: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVIUB.pls call get_open_invoices');
2174: END IF;
2175:
2176: EXCEPTION
2177: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN