DBA Data[Home] [Help]

APPS.OKL_PAYMENT_APPLICATION_PVT dependencies on FND_LOG

Line 110: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

106: l_flag VARCHAR2(1);
107:
108: BEGIN
109: IF (G_DEBUG_ENABLED = 'Y') THEN
110: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
111: END IF;
112: x_return_status := OKC_API.G_RET_STS_SUCCESS;
113: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
114: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);

Line 114: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);

110: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
111: END IF;
112: x_return_status := OKC_API.G_RET_STS_SUCCESS;
113: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
114: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
115: END IF;
116: OPEN lrule_csr(p_chr_id,
117: p_stream_id);
118: FETCH lrule_csr INTO l_flag;

Line 197: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

193: l_flag VARCHAR2(1);
194:
195: BEGIN
196: IF (G_DEBUG_ENABLED = 'Y') THEN
197: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
198: END IF;
199: x_return_status := OKC_API.G_RET_STS_SUCCESS;
200: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
201: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);

Line 201: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);

197: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
198: END IF;
199: x_return_status := OKC_API.G_RET_STS_SUCCESS;
200: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
201: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
202: END IF;
203: OPEN l_ro_sl_rule_csr(p_chr_id, p_cle_id,
204: p_stream_id);
205: FETCH l_ro_sl_rule_csr INTO l_flag;

Line 272: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

268: AND item2.object1_id1 = stream.id1;
269:
270: BEGIN
271: IF (G_DEBUG_ENABLED = 'Y') THEN
272: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
273: END IF;
274: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
275: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
276: END IF;

Line 275: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);

271: IF (G_DEBUG_ENABLED = 'Y') THEN
272: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
273: END IF;
274: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
275: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
276: END IF;
277: x_return_status := OKC_API.G_RET_STS_SUCCESS;
278:
279: l_cap_amount := 0;

Line 965: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

961: i NUMBER default 0;
962: l_proc_name VARCHAR2(35) := 'GET_SLL_RULES';
963: BEGIN
964: IF (G_DEBUG_ENABLED = 'Y') THEN
965: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
966: END IF;
967:
968: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
969: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);

Line 969: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);

965: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
966: END IF;
967:
968: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
969: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
970: END IF;
971: -- Get current database values
972: OPEN okc_rulv_csr (p_rgpv_rec.id,
973: p_rdf_code,

Line 1180: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

1176: rule_failed EXCEPTION;
1177:
1178: BEGIN
1179: IF (G_DEBUG_ENABLED = 'Y') THEN
1180: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
1181: END IF;
1182: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1183: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
1184: END IF;

Line 1183: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);

1179: IF (G_DEBUG_ENABLED = 'Y') THEN
1180: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
1181: END IF;
1182: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1183: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
1184: END IF;
1185:
1186: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1187:

Line 1203: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'RGP at Line: '||l_rgp_id);

1199: FETCH fee_type_csr INTO l_fee_type;
1200: CLOSE fee_type_csr;
1201:
1202: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1203: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'RGP at Line: '||l_rgp_id);
1204: END IF;
1205:
1206: IF (l_rgp_id IS NULL) THEN
1207: -- Create Rule Group for LALEVL

Line 1404: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

1400: check_header_failed EXCEPTION;
1401: l_rgpv_rec OKL_RULE_PUB.rgpv_rec_type;
1402: BEGIN
1403: IF (G_DEBUG_ENABLED = 'Y') THEN
1404: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
1405: END IF;
1406: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1407: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
1408: END IF;

Line 1407: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);

1403: IF (G_DEBUG_ENABLED = 'Y') THEN
1404: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
1405: END IF;
1406: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1407: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
1408: END IF;
1409:
1410: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1411:

Line 1493: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

1489: cap_failed EXCEPTION;
1490:
1491: BEGIN
1492: IF (G_DEBUG_ENABLED = 'Y') THEN
1493: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
1494: END IF;
1495: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1496: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
1497: END IF;

Line 1496: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);

1492: IF (G_DEBUG_ENABLED = 'Y') THEN
1493: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
1494: END IF;
1495: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1496: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
1497: END IF;
1498: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1499:
1500: OPEN fin_cap_csr(p_chr_id);

Line 1610: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

1606: l_rule_present VARCHAR2(1);
1607:
1608: BEGIN -- main process begins here
1609: IF (G_DEBUG_ENABLED = 'Y') THEN
1610: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
1611: END IF;
1612:
1613: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1614: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 1615: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);

1611: END IF;
1612:
1613: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1614: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1615: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
1616: END IF;
1617: -- call START_ACTIVITY to create savepoint, check compatibility
1618: -- and initialize message list
1619: x_return_status := OKC_API.START_ACTIVITY(

Line 1705: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'CAP :'||l_tot_capital_amount);

1701: RAISE OKC_API.G_EXCEPTION_ERROR;
1702: END IF;
1703:
1704: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1705: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'CAP :'||l_tot_capital_amount);
1706: END IF;
1707: FOR line_rec IN line_csr(p_chr_id)
1708: LOOP
1709: -- Apply Payment across Lines (Fin Asset and Fee Top Line)

Line 1738: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'SLH delete: '||x_slh_rulv_tbl_out(i).id);

1734: FOR i IN 1..x_slh_count
1735: LOOP
1736: l_slh_rulv_del_tbl(i).id := x_slh_rulv_tbl_out(i).id;
1737: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1738: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'SLH delete: '||x_slh_rulv_tbl_out(i).id);
1739: END IF;
1740: END LOOP; -- SLH
1741: okl_rule_pub.delete_rule(
1742: p_api_version => 1.0,

Line 1758: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'SLL delete: '||x_sll_rulv_tbl_out(i).id);

1754: FOR i IN 1..x_sll_count
1755: LOOP
1756: l_sll_rulv_del_tbl(i).id := x_sll_rulv_tbl_out(i).id;
1757: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1758: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'SLL delete: '||x_sll_rulv_tbl_out(i).id);
1759: END IF;
1760: END LOOP; -- SLL
1761: okl_rule_pub.delete_rule(
1762: p_api_version => 1.0,

Line 1947: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

1943: l_line_count NUMBER := 0;
1944:
1945: BEGIN -- main process begins here
1946: IF (G_DEBUG_ENABLED = 'Y') THEN
1947: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
1948: END IF;
1949:
1950: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1951: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 1952: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);

1948: END IF;
1949:
1950: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1951: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1952: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
1953: END IF;
1954: -- call START_ACTIVITY to create savepoint, check compatibility
1955: -- and initialize message list
1956: x_return_status := OKC_API.START_ACTIVITY(

Line 2032: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'CAP :'||l_tot_capital_amount);

2028: RAISE OKC_API.G_EXCEPTION_ERROR;
2029: END IF;
2030:
2031: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2032: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'CAP :'||l_tot_capital_amount);
2033: END IF;
2034:
2035: l_line_count := 0; -- number of lines eligible for Prop tax application
2036: FOR line_rec IN line_csr(p_chr_id)

Line 2075: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'SLH delete: '||x_slh_rulv_tbl_out(i).id);

2071: FOR i IN 1..x_slh_count
2072: LOOP
2073: l_slh_rulv_del_tbl(i).id := x_slh_rulv_tbl_out(i).id;
2074: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2075: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'SLH delete: '||x_slh_rulv_tbl_out(i).id);
2076: END IF;
2077: END LOOP; -- SLH
2078: okl_rule_pub.delete_rule(
2079: p_api_version => 1.0,

Line 2095: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'SLL delete: '||x_sll_rulv_tbl_out(i).id);

2091: FOR i IN 1..x_sll_count
2092: LOOP
2093: l_sll_rulv_del_tbl(i).id := x_sll_rulv_tbl_out(i).id;
2094: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2095: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'SLL delete: '||x_sll_rulv_tbl_out(i).id);
2096: END IF;
2097: END LOOP; -- SLL
2098: okl_rule_pub.delete_rule(
2099: p_api_version => 1.0,

Line 2267: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

2263: rowCnt NUMBER DEFAULT 0;
2264:
2265: BEGIN -- main process begins here
2266: IF (G_DEBUG_ENABLED = 'Y') THEN
2267: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
2268: END IF;
2269:
2270: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2271: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 2272: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);

2268: END IF;
2269:
2270: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2271: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2272: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
2273: END IF;
2274: -- call START_ACTIVITY to create savepoint, check compatibility
2275: -- and initialize message list
2276: x_return_status := OKC_API.START_ACTIVITY(

Line 2356: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'CAP :'||l_tot_fee_amount);

2352: RAISE OKC_API.G_EXCEPTION_ERROR;
2353: END IF;
2354:
2355: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2356: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'CAP :'||l_tot_fee_amount);
2357: END IF;
2358:
2359: OPEN fee_name_csr (p_kle_id);
2360: FETCH fee_name_csr INTO l_fee_name;

Line 2409: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'SLH delete: '||x_slh_rulv_tbl_out(i).id);

2405: FOR i IN 1..x_slh_count
2406: LOOP
2407: l_slh_rulv_del_tbl(i).id := x_slh_rulv_tbl_out(i).id;
2408: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2409: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'SLH delete: '||x_slh_rulv_tbl_out(i).id);
2410: END IF;
2411: END LOOP; -- SLH
2412: okl_rule_pub.delete_rule(
2413: p_api_version => 1.0,

Line 2429: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'SLL delete: '||x_sll_rulv_tbl_out(i).id);

2425: FOR i IN 1..x_sll_count
2426: LOOP
2427: l_sll_rulv_del_tbl(i).id := x_sll_rulv_tbl_out(i).id;
2428: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2429: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'SLL delete: '||x_sll_rulv_tbl_out(i).id);
2430: END IF;
2431: END LOOP; -- SLL
2432: okl_rule_pub.delete_rule(
2433: p_api_version => 1.0,

Line 2602: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

2598: rowCnt NUMBER DEFAULT 0;
2599:
2600: BEGIN -- main process begins here
2601: IF (G_DEBUG_ENABLED = 'Y') THEN
2602: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
2603: END IF;
2604:
2605: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2606: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 2607: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);

2603: END IF;
2604:
2605: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2606: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2607: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
2608: END IF;
2609: -- call START_ACTIVITY to create savepoint, check compatibility
2610: -- and initialize message list
2611: x_return_status := OKC_API.START_ACTIVITY(

Line 2691: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'CAP :'||l_tot_fee_amount);

2687: RAISE OKC_API.G_EXCEPTION_ERROR;
2688: END IF;
2689:
2690: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2691: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'CAP :'||l_tot_fee_amount);
2692: END IF;
2693:
2694: OPEN fee_name_csr (p_kle_id);
2695: FETCH fee_name_csr INTO l_fee_name;

Line 2744: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'SLH delete: '||x_slh_rulv_tbl_out(i).id);

2740: FOR i IN 1..x_slh_count
2741: LOOP
2742: l_slh_rulv_del_tbl(i).id := x_slh_rulv_tbl_out(i).id;
2743: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2744: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'SLH delete: '||x_slh_rulv_tbl_out(i).id);
2745: END IF;
2746: END LOOP; -- SLH
2747: okl_rule_pub.delete_rule(
2748: p_api_version => 1.0,

Line 2764: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'SLL delete: '||x_sll_rulv_tbl_out(i).id);

2760: FOR i IN 1..x_sll_count
2761: LOOP
2762: l_sll_rulv_del_tbl(i).id := x_sll_rulv_tbl_out(i).id;
2763: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2764: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'SLL delete: '||x_sll_rulv_tbl_out(i).id);
2765: END IF;
2766: END LOOP; -- SLL
2767: okl_rule_pub.delete_rule(
2768: p_api_version => 1.0,

Line 2900: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

2896: l_slh VARCHAR2(1);
2897:
2898: BEGIN
2899: IF (G_DEBUG_ENABLED = 'Y') THEN
2900: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
2901: END IF;
2902:
2903: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2904: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 2905: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);

2901: END IF;
2902:
2903: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2904: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2905: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
2906: END IF;
2907:
2908: -- call START_ACTIVITY to create savepoint, check compatibility
2909: -- and initialize message list