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 98: l_debug_enabled := okl_debug_pub.check_log_enabled;

94: AND lsm.receivables_invoice_id = aps.customer_trx_id
95: AND TRUNC(aps.trx_date) BETWEEN TRUNC(NVL(cp_from_date, khr.start_date)) AND TRUNC(NVL(cp_to_date, SYSDATE)));
96: */
97: BEGIN
98: l_debug_enabled := okl_debug_pub.check_log_enabled;
99: IF(NVL(l_debug_enabled,'N')='Y') THEN
100: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_interest_billed');
101: END IF;
102:

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

96: */
97: BEGIN
98: l_debug_enabled := okl_debug_pub.check_log_enabled;
99: IF(NVL(l_debug_enabled,'N')='Y') THEN
100: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_interest_billed');
101: END IF;
102:
103: l_interest_billed := 0;
104: x_return_status := OKL_API.G_RET_STS_SUCCESS;

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

110: FETCH l_interest_billed_csr INTO l_interest_billed;
111: CLOSE l_interest_billed_csr;
112:
113: IF(NVL(l_debug_enabled,'N')='Y') THEN
114: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVIUB.pls call get_interest_billed');
115: END IF;
116:
117: RETURN l_interest_billed;
118: EXCEPTION

Line 244: l_debug_enabled := okl_debug_pub.check_log_enabled;

240:
241: -- End bug 6456733
242:
243: BEGIN
244: l_debug_enabled := okl_debug_pub.check_log_enabled;
245: IF(NVL(l_debug_enabled,'N')='Y') THEN
246: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_interest_paid');
247: END IF;
248:

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

242:
243: BEGIN
244: l_debug_enabled := okl_debug_pub.check_log_enabled;
245: IF(NVL(l_debug_enabled,'N')='Y') THEN
246: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_interest_paid');
247: END IF;
248:
249: l_interest_paid := 0;
250: x_return_status := OKL_API.G_RET_STS_SUCCESS;

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

256: FETCH l_interest_paid_csr INTO l_interest_paid;
257: CLOSE l_interest_paid_csr;
258:
259: IF(NVL(l_debug_enabled,'N')='Y') THEN
260: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_interest_paid');
261: END IF;
262:
263: RETURN l_interest_paid;
264: EXCEPTION

Line 360: l_debug_enabled := okl_debug_pub.check_log_enabled;

356:
357: l_contract_info_rec l_contract_info_csr%ROWTYPE;
358:
359: BEGIN
360: l_debug_enabled := okl_debug_pub.check_log_enabled;
361: IF(NVL(l_debug_enabled,'N')='Y') THEN
362: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_interest_due');
363: END IF;
364:

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

358:
359: BEGIN
360: l_debug_enabled := okl_debug_pub.check_log_enabled;
361: IF(NVL(l_debug_enabled,'N')='Y') THEN
362: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_interest_due');
363: END IF;
364:
365: l_interest_amt := 0;
366: l_interest_due := 0;

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

495: END IF;
496: END IF;
497: END IF;
498: IF(NVL(l_debug_enabled,'N')='Y') THEN
499: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVIUB.pls call get_interest_due');
500: END IF;
501:
502: RETURN l_interest_due;
503: EXCEPTION

Line 625: l_debug_enabled := okl_debug_pub.check_log_enabled;

621: l_int_calc_basis OKL_PRODUCT_PARAMETERS_V.interest_calculation_basis%TYPE;
622: l_rev_rec_mthd OKL_PRODUCT_PARAMETERS_V.revenue_recognition_method%TYPE;
623:
624: BEGIN
625: l_debug_enabled := okl_debug_pub.check_log_enabled;
626: IF(NVL(l_debug_enabled,'N')='Y') THEN
627: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_principal_bal');
628: END IF;
629:

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

623:
624: BEGIN
625: l_debug_enabled := okl_debug_pub.check_log_enabled;
626: IF(NVL(l_debug_enabled,'N')='Y') THEN
627: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_principal_bal');
628: END IF;
629:
630: l_principal_bal := 0;
631: x_return_status := OKL_API.G_RET_STS_SUCCESS;

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

717: l_principal_bal := l_principal_balance_tbl(l_principal_balance_tbl.COUNT).principal_balance;
718: END IF;
719:
720: IF(NVL(l_debug_enabled,'N')='Y') THEN
721: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVIUB.pls call get_principal_bal');
722: END IF;
723:
724: RETURN l_principal_bal;
725: EXCEPTION

Line 878: l_debug_enabled := okl_debug_pub.check_log_enabled;

874: -- End - Billing Inline changes - Bug#5898792 - varangan - 23/2/2007
875:
876:
877: BEGIN
878: l_debug_enabled := okl_debug_pub.check_log_enabled;
879: IF(NVL(l_debug_enabled,'N')='Y') THEN
880: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_principal_paid');
881: END IF;
882:

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

876:
877: BEGIN
878: l_debug_enabled := okl_debug_pub.check_log_enabled;
879: IF(NVL(l_debug_enabled,'N')='Y') THEN
880: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_principal_paid');
881: END IF;
882:
883: l_principal_paid := 0;
884: x_return_status := OKL_API.G_RET_STS_SUCCESS;

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

891: -- End bug 6456733
892: FETCH l_principal_paid_csr INTO l_principal_paid;
893: CLOSE l_principal_paid_csr;
894: IF(NVL(l_debug_enabled,'N')='Y') THEN
895: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVIUB.pls call get_principal_paid');
896: END IF;
897:
898: RETURN l_principal_paid;
899: EXCEPTION

Line 952: l_debug_enabled := okl_debug_pub.check_log_enabled;

948: ORDER BY interest_calc_end_date DESC;
949:
950: l_var_int_params_rec l_var_int_params_csr%ROWTYPE;
951: BEGIN
952: l_debug_enabled := okl_debug_pub.check_log_enabled;
953: IF(NVL(l_debug_enabled,'N')='Y') THEN
954: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_interest_rate_change_flag');
955: END IF;
956:

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

950: l_var_int_params_rec l_var_int_params_csr%ROWTYPE;
951: BEGIN
952: l_debug_enabled := okl_debug_pub.check_log_enabled;
953: IF(NVL(l_debug_enabled,'N')='Y') THEN
954: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_interest_rate_change_flag');
955: END IF;
956:
957: l_interest_rate_change_flag := 'N';
958: IF ( p_khr_id IS NULL ) THEN

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

976: l_interest_rate_change_flag := 'Y';
977: END IF;
978:
979: IF(NVL(l_debug_enabled,'N')='Y') THEN
980: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVIUB.pls call get_interest_rate_change_flag');
981: END IF;
982:
983: RETURN l_interest_rate_change_flag;
984: EXCEPTION

Line 1047: l_debug_enabled := okl_debug_pub.check_log_enabled;

1043: l_end_date okl_k_headers_full_v.end_date%TYPE;
1044: l_effective_date DATE := NULL;
1045:
1046: BEGIN
1047: l_debug_enabled := okl_debug_pub.check_log_enabled;
1048: IF(NVL(l_debug_enabled,'N')='Y') THEN
1049: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_effective_int_rate');
1050: END IF;
1051:

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

1045:
1046: BEGIN
1047: l_debug_enabled := okl_debug_pub.check_log_enabled;
1048: IF(NVL(l_debug_enabled,'N')='Y') THEN
1049: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_effective_int_rate');
1050: END IF;
1051:
1052: l_effective_int_rate := 0;
1053: x_return_status := OKL_API.G_RET_STS_SUCCESS;

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

1086: l_effective_int_rate := l_interest_rate_tbl(l_interest_rate_tbl.COUNT).rate;
1087: END IF;
1088:
1089: IF(NVL(l_debug_enabled,'N')='Y') THEN
1090: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVIUB.pls call get_effective_int_rate');
1091: END IF;
1092:
1093: RETURN l_effective_int_rate;
1094: EXCEPTION

Line 1152: l_debug_enabled := okl_debug_pub.check_log_enabled;

1148: OKL_K_HEADERS khr
1149: WHERE chr.id = khr.id
1150: AND khr.id = cp_khr_id;
1151: BEGIN
1152: l_debug_enabled := okl_debug_pub.check_log_enabled;
1153: IF(NVL(l_debug_enabled,'N')='Y') THEN
1154: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_interest_due_unbilled');
1155: END IF;
1156:

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

1150: AND khr.id = cp_khr_id;
1151: BEGIN
1152: l_debug_enabled := okl_debug_pub.check_log_enabled;
1153: IF(NVL(l_debug_enabled,'N')='Y') THEN
1154: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_interest_due_unbilled');
1155: END IF;
1156:
1157: l_interest_billed := 0;
1158: l_interest_due := 0;

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

1186: END IF;
1187: l_interest_due_unbilled := l_interest_due - l_interest_billed;
1188:
1189: IF(NVL(l_debug_enabled,'N')='Y') THEN
1190: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVIUB.pls call get_interest_due_unbilled');
1191: END IF;
1192:
1193: RETURN l_interest_due_unbilled;
1194: EXCEPTION

Line 1293: l_debug_enabled := okl_debug_pub.check_log_enabled;

1289: --AND TRUNC(aps.trx_date) BETWEEN TRUNC(NVL(cp_from_date, khr.start_date)) AND TRUNC(NVL(cp_to_date, SYSDATE));
1290: ---- End - Billing Inline changes - Bug#5898792 - varangan - 23/2/2007
1291:
1292: BEGIN
1293: l_debug_enabled := okl_debug_pub.check_log_enabled;
1294: IF(NVL(l_debug_enabled,'N')='Y') THEN
1295: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_principal_billed');
1296: END IF;
1297:

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

1291:
1292: BEGIN
1293: l_debug_enabled := okl_debug_pub.check_log_enabled;
1294: IF(NVL(l_debug_enabled,'N')='Y') THEN
1295: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_principal_billed');
1296: END IF;
1297:
1298: l_principal_billed := 0;
1299: x_return_status := OKL_API.G_RET_STS_SUCCESS;

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

1308: FETCH l_principal_billed_csr INTO l_principal_billed;
1309: CLOSE l_principal_billed_csr;
1310:
1311: IF(NVL(l_debug_enabled,'N')='Y') THEN
1312: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVIUB.pls call get_principal_billed');
1313: END IF;
1314:
1315: RETURN l_principal_billed;
1316: EXCEPTION

Line 1397: l_debug_enabled := okl_debug_pub.check_log_enabled;

1393:
1394: -- End bug 6456733
1395: -- End - Billing Inline changes - Bug#5898792 - varangan - 23/2/2007
1396: BEGIN
1397: l_debug_enabled := okl_debug_pub.check_log_enabled;
1398: IF(NVL(l_debug_enabled,'N')='Y') THEN
1399: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_float_factor_billed');
1400: END IF;
1401:

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

1395: -- End - Billing Inline changes - Bug#5898792 - varangan - 23/2/2007
1396: BEGIN
1397: l_debug_enabled := okl_debug_pub.check_log_enabled;
1398: IF(NVL(l_debug_enabled,'N')='Y') THEN
1399: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_float_factor_billed');
1400: END IF;
1401:
1402: l_float_factor_billed := 0;
1403: x_return_status := OKL_API.G_RET_STS_SUCCESS;

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

1409: FETCH l_float_billed_csr INTO l_float_factor_billed;
1410: CLOSE l_float_billed_csr;
1411:
1412: IF(NVL(l_debug_enabled,'N')='Y') THEN
1413: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVIUB.pls call get_float_factor_billed');
1414: END IF;
1415:
1416: RETURN l_float_factor_billed;
1417: EXCEPTION

Line 1499: l_debug_enabled := okl_debug_pub.check_log_enabled;

1495: --End bug 6456733
1496: -- End - Billing Inline changes - Bug#5898792 - varangan - 23/2/2007
1497:
1498: BEGIN
1499: l_debug_enabled := okl_debug_pub.check_log_enabled;
1500: IF(NVL(l_debug_enabled,'N')='Y') THEN
1501: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_loan_payment_billed');
1502: END IF;
1503:

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

1497:
1498: BEGIN
1499: l_debug_enabled := okl_debug_pub.check_log_enabled;
1500: IF(NVL(l_debug_enabled,'N')='Y') THEN
1501: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_loan_payment_billed');
1502: END IF;
1503:
1504: l_loan_payment_billed := 0;
1505: x_return_status := OKL_API.G_RET_STS_SUCCESS;

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

1511: FETCH l_loan_payment_billed_csr INTO l_loan_payment_billed;
1512: CLOSE l_loan_payment_billed_csr;
1513:
1514: IF(NVL(l_debug_enabled,'N')='Y') THEN
1515: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVIUB.pls call get_loan_payment_billed');
1516: END IF;
1517:
1518: RETURN l_loan_payment_billed;
1519: EXCEPTION

Line 1608: l_debug_enabled := okl_debug_pub.check_log_enabled;

1604:
1605: -- End - Billing Inline changes - Bug#5898792 - varangan - 23/2/2007
1606:
1607: BEGIN
1608: l_debug_enabled := okl_debug_pub.check_log_enabled;
1609: IF(NVL(l_debug_enabled,'N')='Y') THEN
1610: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_loan_payment_paid');
1611: END IF;
1612:

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

1606:
1607: BEGIN
1608: l_debug_enabled := okl_debug_pub.check_log_enabled;
1609: IF(NVL(l_debug_enabled,'N')='Y') THEN
1610: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_loan_payment_paid');
1611: END IF;
1612:
1613: l_loan_payment_paid := 0;
1614: x_return_status := OKL_API.G_RET_STS_SUCCESS;

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

1620: FETCH l_laon_payment_csr INTO l_loan_payment_paid;
1621: CLOSE l_laon_payment_csr;
1622:
1623: IF(NVL(l_debug_enabled,'N')='Y') THEN
1624: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVIUB.pls call get_loan_payment_paid');
1625: END IF;
1626:
1627: RETURN l_loan_payment_paid;
1628: EXCEPTION

Line 1683: l_debug_enabled := okl_debug_pub.check_log_enabled;

1679: AND stm.sty_id = sty.id
1680: AND sty.stream_type_purpose = 'EXCESS_LOAN_PAYMENT_PAID';
1681:
1682: BEGIN
1683: l_debug_enabled := okl_debug_pub.check_log_enabled;
1684: IF(NVL(l_debug_enabled,'N')='Y') THEN
1685: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_excess_loan_payment');
1686: END IF;
1687:

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

1681:
1682: BEGIN
1683: l_debug_enabled := okl_debug_pub.check_log_enabled;
1684: IF(NVL(l_debug_enabled,'N')='Y') THEN
1685: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_excess_loan_payment');
1686: END IF;
1687:
1688: l_excess_loan_payment := 0;
1689: x_return_status := OKL_API.G_RET_STS_SUCCESS;

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

1695: FETCH l_laon_payment_csr INTO l_excess_loan_payment;
1696: CLOSE l_laon_payment_csr;
1697:
1698: IF(NVL(l_debug_enabled,'N')='Y') THEN
1699: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVIUB.pls call get_excess_loan_payment');
1700: END IF;
1701:
1702: RETURN l_excess_loan_payment;
1703: EXCEPTION

Line 1751: l_debug_enabled := okl_debug_pub.check_log_enabled;

1747: SELECT date_last_interim_interest_cal
1748: FROM okl_k_headers
1749: WHERE id = cp_khr_id;
1750: BEGIN
1751: l_debug_enabled := okl_debug_pub.check_log_enabled;
1752: IF(NVL(l_debug_enabled,'N')='Y') THEN
1753: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_last_interim_int_calc_date');
1754: END IF;
1755:

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

1749: WHERE id = cp_khr_id;
1750: BEGIN
1751: l_debug_enabled := okl_debug_pub.check_log_enabled;
1752: IF(NVL(l_debug_enabled,'N')='Y') THEN
1753: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_last_interim_int_calc_date');
1754: END IF;
1755:
1756: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1757: IF ( p_khr_id IS NULL ) THEN

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

1761: OPEN l_interest_calc_date_csr(p_khr_id);
1762: FETCH l_interest_calc_date_csr INTO l_last_interest_date;
1763: CLOSE l_interest_calc_date_csr;
1764: IF(NVL(l_debug_enabled,'N')='Y') THEN
1765: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVIUB.pls call get_last_interim_int_calc_date');
1766: END IF;
1767: RETURN l_last_interest_date;
1768: EXCEPTION
1769: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1874: l_debug_enabled := okl_debug_pub.check_log_enabled;

1870: FROM okl_k_rate_params
1871: WHERE khr_id = cp_khr_id;
1872:
1873: BEGIN
1874: l_debug_enabled := okl_debug_pub.check_log_enabled;
1875: IF(NVL(l_debug_enabled,'N')='Y') THEN
1876: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_last_sch_int_calc_date');
1877: END IF;
1878: x_return_status := OKL_API.G_RET_STS_SUCCESS;

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

1872:
1873: BEGIN
1874: l_debug_enabled := okl_debug_pub.check_log_enabled;
1875: IF(NVL(l_debug_enabled,'N')='Y') THEN
1876: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_last_sch_int_calc_date');
1877: END IF;
1878: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1879: IF ( p_khr_id IS NULL ) THEN
1880: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

1972: END IF;
1973: END IF;
1974:
1975: IF(NVL(l_debug_enabled,'N')='Y') THEN
1976: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVIUB.pls call get_last_sch_int_calc_date');
1977: END IF;
1978:
1979: RETURN l_last_interest_date;
1980:

Line 2084: l_debug_enabled := okl_debug_pub.check_log_enabled;

2080:
2081: -- End - Billing Inline changes - Bug#5898792 - varangan - 23/2/2007
2082:
2083: BEGIN
2084: l_debug_enabled := okl_debug_pub.check_log_enabled;
2085: IF(NVL(l_debug_enabled,'N')='Y') THEN
2086: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_open_invoices');
2087: END IF;
2088: x_return_status := OKL_API.G_RET_STS_SUCCESS;

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

2082:
2083: BEGIN
2084: l_debug_enabled := okl_debug_pub.check_log_enabled;
2085: IF(NVL(l_debug_enabled,'N')='Y') THEN
2086: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_open_invoices');
2087: END IF;
2088: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2089: IF ( p_khr_id IS NULL ) THEN
2090: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

2093: OPEN l_invoice_info_csr(p_khr_id);
2094: FETCH l_invoice_info_csr BULK COLLECT INTO x_invoice_tbl;
2095: CLOSE l_invoice_info_csr;
2096: IF(NVL(l_debug_enabled,'N')='Y') THEN
2097: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVIUB.pls call get_open_invoices');
2098: END IF;
2099:
2100: EXCEPTION
2101: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN