DBA Data[Home] [Help]

APPS.OKL_PAYMENT_APPLICATION_PVT dependencies on FND_LOG

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1180: rule_failed EXCEPTION;
1181:
1182: BEGIN
1183: IF (G_DEBUG_ENABLED = 'Y') THEN
1184: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
1185: END IF;
1186: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1187: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
1188: END IF;

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

1183: IF (G_DEBUG_ENABLED = 'Y') THEN
1184: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
1185: END IF;
1186: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1187: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
1188: END IF;
1189:
1190: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1191:

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

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

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

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

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

1407: IF (G_DEBUG_ENABLED = 'Y') THEN
1408: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
1409: END IF;
1410: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1411: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
1412: END IF;
1413:
1414: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1415:

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

1493: cap_failed EXCEPTION;
1494:
1495: BEGIN
1496: IF (G_DEBUG_ENABLED = 'Y') THEN
1497: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
1498: END IF;
1499: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1500: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
1501: END IF;

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

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

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

1934:
1935: l_line_csr_tbl line_csr_tbl; -- Added Bug# 7661717
1936: BEGIN -- main process begins here
1937: IF (G_DEBUG_ENABLED = 'Y') THEN
1938: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
1939: END IF;
1940:
1941: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1942: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

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

1939: END IF;
1940:
1941: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1942: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1943: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
1944: END IF;
1945: -- call START_ACTIVITY to create savepoint, check compatibility
1946: -- and initialize message list
1947: x_return_status := OKC_API.START_ACTIVITY(

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

2029: RAISE OKC_API.G_EXCEPTION_ERROR;
2030: END IF;
2031:
2032: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2033: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'CAP :'||l_tot_capital_amount);
2034: END IF;
2035: -- Bug 7661717 : Start
2036: /*
2037: FOR line_rec IN line_csr(p_chr_id)

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

2094: FOR i IN 1..x_slh_count
2095: LOOP
2096: l_slh_rulv_del_tbl(i).id := x_slh_rulv_tbl_out(i).id;
2097: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2098: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'SLH delete: '||x_slh_rulv_tbl_out(i).id);
2099: END IF;
2100: END LOOP; -- SLH
2101: okl_rule_pub.delete_rule(
2102: p_api_version => 1.0,

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

2114: FOR i IN 1..x_sll_count
2115: LOOP
2116: l_sll_rulv_del_tbl(i).id := x_sll_rulv_tbl_out(i).id;
2117: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2118: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'SLL delete: '||x_sll_rulv_tbl_out(i).id);
2119: END IF;
2120: END LOOP; -- SLL
2121: okl_rule_pub.delete_rule(
2122: p_api_version => 1.0,

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

2303: l_line_count NUMBER := 0;
2304:
2305: BEGIN -- main process begins here
2306: IF (G_DEBUG_ENABLED = 'Y') THEN
2307: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
2308: END IF;
2309:
2310: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2311: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

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

2308: END IF;
2309:
2310: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2311: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2312: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
2313: END IF;
2314: -- call START_ACTIVITY to create savepoint, check compatibility
2315: -- and initialize message list
2316: x_return_status := OKC_API.START_ACTIVITY(

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

2388: RAISE OKC_API.G_EXCEPTION_ERROR;
2389: END IF;
2390:
2391: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2392: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'CAP :'||l_tot_capital_amount);
2393: END IF;
2394:
2395: l_line_count := 0; -- number of lines eligible for Prop tax application
2396: FOR line_rec IN line_csr(p_chr_id)

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

2431: FOR i IN 1..x_slh_count
2432: LOOP
2433: l_slh_rulv_del_tbl(i).id := x_slh_rulv_tbl_out(i).id;
2434: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2435: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'SLH delete: '||x_slh_rulv_tbl_out(i).id);
2436: END IF;
2437: END LOOP; -- SLH
2438: okl_rule_pub.delete_rule(
2439: p_api_version => 1.0,

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

2451: FOR i IN 1..x_sll_count
2452: LOOP
2453: l_sll_rulv_del_tbl(i).id := x_sll_rulv_tbl_out(i).id;
2454: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2455: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'SLL delete: '||x_sll_rulv_tbl_out(i).id);
2456: END IF;
2457: END LOOP; -- SLL
2458: okl_rule_pub.delete_rule(
2459: p_api_version => 1.0,

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

2623: rowCnt NUMBER DEFAULT 0;
2624:
2625: BEGIN -- main process begins here
2626: IF (G_DEBUG_ENABLED = 'Y') THEN
2627: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
2628: END IF;
2629:
2630: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2631: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

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

2628: END IF;
2629:
2630: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2631: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2632: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
2633: END IF;
2634: -- call START_ACTIVITY to create savepoint, check compatibility
2635: -- and initialize message list
2636: x_return_status := OKC_API.START_ACTIVITY(

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

2712: RAISE OKC_API.G_EXCEPTION_ERROR;
2713: END IF;
2714:
2715: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2716: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'CAP :'||l_tot_fee_amount);
2717: END IF;
2718:
2719: OPEN fee_name_csr (p_kle_id);
2720: FETCH fee_name_csr INTO l_fee_name;

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

2765: FOR i IN 1..x_slh_count
2766: LOOP
2767: l_slh_rulv_del_tbl(i).id := x_slh_rulv_tbl_out(i).id;
2768: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2769: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'SLH delete: '||x_slh_rulv_tbl_out(i).id);
2770: END IF;
2771: END LOOP; -- SLH
2772: okl_rule_pub.delete_rule(
2773: p_api_version => 1.0,

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

2785: FOR i IN 1..x_sll_count
2786: LOOP
2787: l_sll_rulv_del_tbl(i).id := x_sll_rulv_tbl_out(i).id;
2788: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2789: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'SLL delete: '||x_sll_rulv_tbl_out(i).id);
2790: END IF;
2791: END LOOP; -- SLL
2792: okl_rule_pub.delete_rule(
2793: p_api_version => 1.0,

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

2958: rowCnt NUMBER DEFAULT 0;
2959:
2960: BEGIN -- main process begins here
2961: IF (G_DEBUG_ENABLED = 'Y') THEN
2962: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
2963: END IF;
2964:
2965: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2966: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

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

2963: END IF;
2964:
2965: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2966: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2967: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
2968: END IF;
2969: -- call START_ACTIVITY to create savepoint, check compatibility
2970: -- and initialize message list
2971: x_return_status := OKC_API.START_ACTIVITY(

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

3047: RAISE OKC_API.G_EXCEPTION_ERROR;
3048: END IF;
3049:
3050: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3051: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'CAP :'||l_tot_fee_amount);
3052: END IF;
3053:
3054: OPEN fee_name_csr (p_kle_id);
3055: FETCH fee_name_csr INTO l_fee_name;

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

3100: FOR i IN 1..x_slh_count
3101: LOOP
3102: l_slh_rulv_del_tbl(i).id := x_slh_rulv_tbl_out(i).id;
3103: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3104: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'SLH delete: '||x_slh_rulv_tbl_out(i).id);
3105: END IF;
3106: END LOOP; -- SLH
3107: okl_rule_pub.delete_rule(
3108: p_api_version => 1.0,

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

3120: FOR i IN 1..x_sll_count
3121: LOOP
3122: l_sll_rulv_del_tbl(i).id := x_sll_rulv_tbl_out(i).id;
3123: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3124: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'SLL delete: '||x_sll_rulv_tbl_out(i).id);
3125: END IF;
3126: END LOOP; -- SLL
3127: okl_rule_pub.delete_rule(
3128: p_api_version => 1.0,

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

3256: l_slh VARCHAR2(1);
3257:
3258: BEGIN
3259: IF (G_DEBUG_ENABLED = 'Y') THEN
3260: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
3261: END IF;
3262:
3263: x_return_status := OKC_API.G_RET_STS_SUCCESS;
3264: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

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

3261: END IF;
3262:
3263: x_return_status := OKC_API.G_RET_STS_SUCCESS;
3264: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3265: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
3266: END IF;
3267:
3268: -- call START_ACTIVITY to create savepoint, check compatibility
3269: -- and initialize message list