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

Line 5: G_DEBUG_ENABLED CONSTANT VARCHAR2(10) := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;

1: PACKAGE BODY OKL_PRICING_UTILS_PVT AS
2: /* $Header: OKLRPIUB.pls 120.80.12020000.5 2012/11/24 04:22:54 rpillay ship $ */
3:
4: G_MODULE VARCHAR2(255) := 'okl.stream.esg.okl_esg_transport_pvt';
5: G_DEBUG_ENABLED CONSTANT VARCHAR2(10) := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;
6: G_IS_DEBUG_STATEMENT_ON BOOLEAN;
7:
8: PROCEDURE put_in_log(
9: p_debug_enabled IN VARCHAR2,

Line 20: okl_debug_pub.log_debug(

16: -- l_level: S - Statement, P- Procedure, B - Both
17: BEGIN
18: IF(p_debug_enabled='Y' AND is_debug_procedure_on AND p_level = 'P')
19: THEN
20: okl_debug_pub.log_debug(
21: FND_LOG.LEVEL_PROCEDURE,
22: p_module,
23: msg);
24: ELSIF (p_debug_enabled='Y' AND is_debug_statement_on AND

Line 27: okl_debug_pub.log_debug(

23: msg);
24: ELSIF (p_debug_enabled='Y' AND is_debug_statement_on AND
25: (p_level = 'S' OR p_level = 'B' ))
26: THEN
27: okl_debug_pub.log_debug(
28: FND_LOG.LEVEL_STATEMENT,
29: p_module,
30: msg);
31: END IF;

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

163: l_days_in_month VARCHAR2(30);
164: l_days_in_year VARCHAR2(30);
165: BEGIN
166: IF (G_DEBUG_ENABLED = 'Y') THEN
167: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
168: END IF;
169: l_return_status := G_RET_STS_ERROR;
170: FOR t_rec IN day_conv_csr(p_id)
171: LOOP

Line 192: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_api_name || 'Tried fetching the day convention from OKL_K_RATE_PARAMS ' || l_return_status );

188: l_return_status := G_RET_STS_ERROR;
189: END IF;
190: -- Bug 4960625: End
191: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
192: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_api_name || 'Tried fetching the day convention from OKL_K_RATE_PARAMS ' || l_return_status );
193: END IF;
194: IF l_return_status <> G_RET_STS_SUCCESS
195: THEN
196: -- Fetch the day convention from the SGT assosiated to the contract

Line 209: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_api_name || 'Tried fetching the day convention from SGT ' || l_return_status );

205: l_days_in_year := t_rec.days_in_a_year_code;
206: l_return_status := G_RET_STS_SUCCESS;
207: END LOOP;
208: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
209: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_api_name || 'Tried fetching the day convention from SGT ' || l_return_status );
210: END IF;
211: END IF;
212: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
213: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_api_name || 'Month / Year = ' || l_days_in_month || '/' || l_days_in_year );

Line 213: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_api_name || 'Month / Year = ' || l_days_in_month || '/' || l_days_in_year );

209: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_api_name || 'Tried fetching the day convention from SGT ' || l_return_status );
210: END IF;
211: END IF;
212: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
213: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_api_name || 'Month / Year = ' || l_days_in_month || '/' || l_days_in_year );
214: END IF;
215: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
216: RAISE OKL_API.G_EXCEPTION_ERROR;
217: END IF;

Line 286: l_debug_enabled := okl_debug_pub.check_log_enabled;

282: is_debug_procedure_on BOOLEAN;
283: is_debug_statement_on BOOLEAN;
284: BEGIN
285: l_return_status := OKL_API.G_RET_STS_SUCCESS;
286: l_debug_enabled := okl_debug_pub.check_log_enabled;
287: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
288: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
289: 'begin debug OKLRPIUB.pls call get_so_hdr');
290: -- check for logging on STATEMENT level

Line 287: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

283: is_debug_statement_on BOOLEAN;
284: BEGIN
285: l_return_status := OKL_API.G_RET_STS_SUCCESS;
286: l_debug_enabled := okl_debug_pub.check_log_enabled;
287: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
288: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
289: 'begin debug OKLRPIUB.pls call get_so_hdr');
290: -- check for logging on STATEMENT level
291: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

Line 291: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

287: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
288: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
289: 'begin debug OKLRPIUB.pls call get_so_hdr');
290: -- check for logging on STATEMENT level
291: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
292: -- Call START_ACTIVITY to create savepoint, check compatibility
293: -- and initialize message list
294: l_return_status := OKL_API.START_ACTIVITY(
295: p_api_name => l_api_name,

Line 494: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;

490: l_eot_type_code VARCHAR2(30);
491: BEGIN
492: l_return_status := OKL_API.G_RET_STS_SUCCESS;
493:
494: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
495: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
496:
497: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
498: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));

Line 495: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

491: BEGIN
492: l_return_status := OKL_API.G_RET_STS_SUCCESS;
493:
494: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
495: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
496:
497: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
498: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
499: -- check for logging on STATEMENT level

Line 500: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

496:
497: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
498: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
499: -- check for logging on STATEMENT level
500: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
501: l_return_status := OKL_API.START_ACTIVITY(
502: p_api_name => l_api_name,
503: p_pkg_name => G_PKG_NAME,
504: p_init_msg_list => p_init_msg_list,

Line 617: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;

613: l_oec NUMBER;
614: l_item_cat_percent NUMBER;
615: BEGIN
616: l_return_status := OKL_API.G_RET_STS_SUCCESS;
617: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
618: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
619: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
620: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
621: -- check for logging on STATEMENT level

Line 618: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

614: l_item_cat_percent NUMBER;
615: BEGIN
616: l_return_status := OKL_API.G_RET_STS_SUCCESS;
617: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
618: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
619: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
620: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
621: -- check for logging on STATEMENT level
622: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

Line 622: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

618: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
619: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
620: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
621: -- check for logging on STATEMENT level
622: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
623: l_return_status := OKL_API.START_ACTIVITY(
624: p_api_name => l_api_name,
625: p_pkg_name => G_PKG_NAME,
626: p_init_msg_list => p_init_msg_list,

Line 779: l_debug_enabled := okl_debug_pub.check_log_enabled;

775:
776: sub_index NUMBER;
777: BEGIN
778: l_return_status := OKL_API.G_RET_STS_SUCCESS;
779: l_debug_enabled := okl_debug_pub.check_log_enabled;
780: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
781: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
782: 'begin debug OKLRPIUB.pls call get_qq_fin_adjustments');
783: -- check for logging on STATEMENT level

Line 780: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

776: sub_index NUMBER;
777: BEGIN
778: l_return_status := OKL_API.G_RET_STS_SUCCESS;
779: l_debug_enabled := okl_debug_pub.check_log_enabled;
780: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
781: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
782: 'begin debug OKLRPIUB.pls call get_qq_fin_adjustments');
783: -- check for logging on STATEMENT level
784: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

Line 784: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

780: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
781: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
782: 'begin debug OKLRPIUB.pls call get_qq_fin_adjustments');
783: -- check for logging on STATEMENT level
784: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
785: -- Call START_ACTIVITY to create savepoint, check compatibility
786: -- and initialize message list
787: l_return_status := OKL_API.START_ACTIVITY(
788: p_api_name => l_api_name,

Line 971: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;

967: get_sgt_day_convention_rec get_sgt_day_convention_csr%ROWTYPE;
968:
969: BEGIN
970: l_return_status := OKL_API.G_RET_STS_SUCCESS;
971: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
972: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
973: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
974: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
975: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

Line 972: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

968:
969: BEGIN
970: l_return_status := OKL_API.G_RET_STS_SUCCESS;
971: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
972: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
973: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
974: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
975: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
976: l_return_status := OKL_API.START_ACTIVITY(

Line 975: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

971: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
972: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
973: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
974: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
975: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
976: l_return_status := OKL_API.START_ACTIVITY(
977: p_api_name => l_api_name,
978: p_pkg_name => G_PKG_NAME,
979: p_init_msg_list => p_init_msg_list,

Line 1080: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;

1076: get_sgt_day_convention_rec get_sgt_day_convention_csr%ROWTYPE;
1077:
1078: BEGIN
1079: l_return_status := OKL_API.G_RET_STS_SUCCESS;
1080: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
1081: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
1082: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
1083: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
1084: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

Line 1081: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

1077:
1078: BEGIN
1079: l_return_status := OKL_API.G_RET_STS_SUCCESS;
1080: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
1081: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
1082: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
1083: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
1084: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
1085: l_return_status := OKL_API.START_ACTIVITY(

Line 1084: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

1080: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
1081: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
1082: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
1083: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
1084: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
1085: l_return_status := OKL_API.START_ACTIVITY(
1086: p_api_name => l_api_name,
1087: p_pkg_name => G_PKG_NAME,
1088: p_init_msg_list => p_init_msg_list,

Line 1230: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;

1226: cfl_index NUMBER;
1227: l_qq_id NUMBER;
1228: BEGIN
1229: l_return_status := OKL_API.G_RET_STS_SUCCESS;
1230: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
1231: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
1232: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
1233: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
1234: -- check for logging on STATEMENT level

Line 1231: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

1227: l_qq_id NUMBER;
1228: BEGIN
1229: l_return_status := OKL_API.G_RET_STS_SUCCESS;
1230: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
1231: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
1232: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
1233: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
1234: -- check for logging on STATEMENT level
1235: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

Line 1235: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

1231: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
1232: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
1233: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
1234: -- check for logging on STATEMENT level
1235: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
1236: -- Call START_ACTIVITY to create savepoint, check compatibility
1237: -- and initialize message list
1238: l_return_status := OKL_API.START_ACTIVITY(
1239: p_api_name => l_api_name,

Line 1482: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;

1478: l_tot_periods NUMBER;
1479: l_periodic_amt NUMBER;
1480: BEGIN
1481: l_return_status := OKL_API.G_RET_STS_SUCCESS;
1482: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
1483: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
1484: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
1485: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
1486: -- check for logging on STATEMENT level

Line 1483: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

1479: l_periodic_amt NUMBER;
1480: BEGIN
1481: l_return_status := OKL_API.G_RET_STS_SUCCESS;
1482: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
1483: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
1484: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
1485: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
1486: -- check for logging on STATEMENT level
1487: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

Line 1487: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

1483: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
1484: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
1485: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
1486: -- check for logging on STATEMENT level
1487: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
1488: -- Call START_ACTIVITY to create savepoint, check compatibility
1489: -- and initialize message list
1490: l_return_status := OKL_API.START_ACTIVITY(
1491: p_api_name => l_api_name,

Line 1740: l_debug_enabled := okl_debug_pub.check_log_enabled;

1736: l_period_start_date DATE;
1737: l_period_end_date DATE;
1738: BEGIN
1739: l_return_status := OKL_API.G_RET_STS_SUCCESS;
1740: l_debug_enabled := okl_debug_pub.check_log_enabled;
1741: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
1742: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
1743: 'begin debug OKLRPIUB.pls call gen_so_cf_strm_elements');
1744: -- check for logging on STATEMENT level

Line 1741: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

1737: l_period_end_date DATE;
1738: BEGIN
1739: l_return_status := OKL_API.G_RET_STS_SUCCESS;
1740: l_debug_enabled := okl_debug_pub.check_log_enabled;
1741: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
1742: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
1743: 'begin debug OKLRPIUB.pls call gen_so_cf_strm_elements');
1744: -- check for logging on STATEMENT level
1745: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

Line 1745: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

1741: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
1742: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
1743: 'begin debug OKLRPIUB.pls call gen_so_cf_strm_elements');
1744: -- check for logging on STATEMENT level
1745: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
1746: -- If its a stub payment only one cash_inflows will be returned
1747: IF p_stub_flag = 'Y'
1748: OR ( p_periods IS NULL AND p_stub_days IS NOT NULL )
1749: THEN

Line 1910: l_debug_enabled := okl_debug_pub.check_log_enabled;

1906: --end DJANASWA
1907:
1908: BEGIN
1909: l_return_status := OKL_API.G_RET_STS_SUCCESS;
1910: l_debug_enabled := okl_debug_pub.check_log_enabled;
1911: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
1912: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
1913: 'begin debug OKLRPIUB.pls call gen_so_cf_strms');
1914: -- check for logging on STATEMENT level

Line 1911: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

1907:
1908: BEGIN
1909: l_return_status := OKL_API.G_RET_STS_SUCCESS;
1910: l_debug_enabled := okl_debug_pub.check_log_enabled;
1911: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
1912: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
1913: 'begin debug OKLRPIUB.pls call gen_so_cf_strms');
1914: -- check for logging on STATEMENT level
1915: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

Line 1915: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

1911: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
1912: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
1913: 'begin debug OKLRPIUB.pls call gen_so_cf_strms');
1914: -- check for logging on STATEMENT level
1915: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
1916: -- Call START_ACTIVITY to create savepoint, check compatibility
1917: -- and initialize message list
1918: l_return_status := OKL_API.START_ACTIVITY(
1919: p_api_name => l_api_name,

Line 2453: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;

2449: l_period_start_date DATE;
2450: l_period_end_date DATE;
2451: BEGIN
2452: l_return_status := OKL_API.G_RET_STS_SUCCESS;
2453: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
2454: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
2455:
2456: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
2457: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));

Line 2454: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

2450: l_period_end_date DATE;
2451: BEGIN
2452: l_return_status := OKL_API.G_RET_STS_SUCCESS;
2453: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
2454: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
2455:
2456: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
2457: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
2458: -- check for logging on STATEMENT level

Line 2459: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

2455:
2456: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
2457: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
2458: -- check for logging on STATEMENT level
2459: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
2460: -- Call START_ACTIVITY to create savepoint, check compatibility and initialize message list
2461: l_return_status := OKL_API.START_ACTIVITY(
2462: p_api_name => l_api_name,
2463: p_pkg_name => G_PKG_NAME,

Line 3489: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;

3485: l_interest_factor NUMBER;
3486: l_residual_percent NUMBER;
3487: BEGIN
3488: l_return_status := OKL_API.G_RET_STS_SUCCESS;
3489: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
3490: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
3491:
3492: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
3493: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));

Line 3490: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

3486: l_residual_percent NUMBER;
3487: BEGIN
3488: l_return_status := OKL_API.G_RET_STS_SUCCESS;
3489: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
3490: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
3491:
3492: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
3493: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
3494: -- check for logging on STATEMENT level

Line 3495: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

3491:
3492: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
3493: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
3494: -- check for logging on STATEMENT level
3495: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
3496: -- Call START_ACTIVITY to create savepoint, check compatibility
3497: -- and initialize message list
3498: l_return_status := OKL_API.START_ACTIVITY(
3499: p_api_name => l_api_name,

Line 3850: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;

3846: l_interest_factor NUMBER;
3847: l_residual_percent NUMBER;
3848: BEGIN
3849: l_return_status := OKL_API.G_RET_STS_SUCCESS;
3850: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
3851: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
3852:
3853: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
3854: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));

Line 3851: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

3847: l_residual_percent NUMBER;
3848: BEGIN
3849: l_return_status := OKL_API.G_RET_STS_SUCCESS;
3850: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
3851: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
3852:
3853: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
3854: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
3855: -- check for logging on STATEMENT level

Line 3856: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

3852:
3853: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
3854: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
3855: -- check for logging on STATEMENT level
3856: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
3857: -- Call START_ACTIVITY to create savepoint, check compatibility
3858: -- and initialize message list
3859: l_return_status := OKL_API.START_ACTIVITY(
3860: p_api_name => l_api_name,

Line 4747: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;

4743: lrs_levels lrs_levels_tbl_type;
4744: lvl_index NUMBER;
4745: BEGIN
4746: l_return_status := OKL_API.G_RET_STS_SUCCESS;
4747: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
4748: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
4749: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
4750: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
4751: -- check for logging on STATEMENT level

Line 4748: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

4744: lvl_index NUMBER;
4745: BEGIN
4746: l_return_status := OKL_API.G_RET_STS_SUCCESS;
4747: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
4748: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
4749: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
4750: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
4751: -- check for logging on STATEMENT level
4752: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

Line 4752: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

4748: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
4749: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
4750: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
4751: -- check for logging on STATEMENT level
4752: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
4753: -- Call START_ACTIVITY to create savepoint, check compatibility
4754: -- and initialize message list
4755: l_return_status := OKL_API.START_ACTIVITY(
4756: p_api_name => l_api_name,

Line 4955: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;

4951: is_debug_statement_on BOOLEAN;
4952: srt_details srt_details_rec_type;
4953: BEGIN
4954: l_return_status := OKL_API.G_RET_STS_SUCCESS;
4955: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
4956: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
4957:
4958: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
4959: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));

Line 4956: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

4952: srt_details srt_details_rec_type;
4953: BEGIN
4954: l_return_status := OKL_API.G_RET_STS_SUCCESS;
4955: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
4956: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
4957:
4958: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
4959: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
4960: -- check for logging on STATEMENT level

Line 4961: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

4957:
4958: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
4959: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
4960: -- check for logging on STATEMENT level
4961: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
4962: -- Call START_ACTIVITY to create savepoint, check compatibility
4963: -- and initialize message list
4964: l_return_status := OKL_API.START_ACTIVITY(
4965: p_api_name => l_api_name,

Line 5191: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;

5187: l_sum_rent_in_curr_month NUMBER;
5188: l_orig_income_in_curr_month NUMBER;
5189: BEGIN
5190: l_return_status := OKL_API.G_RET_STS_SUCCESS;
5191: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
5192: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
5193: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
5194: 'begin debug OKLRPIUB.pls call '|| LOWER(l_api_name));
5195: -- check for logging on STATEMENT level

Line 5192: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

5188: l_orig_income_in_curr_month NUMBER;
5189: BEGIN
5190: l_return_status := OKL_API.G_RET_STS_SUCCESS;
5191: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
5192: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
5193: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
5194: 'begin debug OKLRPIUB.pls call '|| LOWER(l_api_name));
5195: -- check for logging on STATEMENT level
5196: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

Line 5196: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

5192: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
5193: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
5194: 'begin debug OKLRPIUB.pls call '|| LOWER(l_api_name));
5195: -- check for logging on STATEMENT level
5196: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
5197: -- Call START_ACTIVITY to create savepoint, check compatibility
5198: -- and initialize message list
5199: l_return_status := OKL_API.START_ACTIVITY(
5200: p_api_name => l_api_name,

Line 6052: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;

6048: l_tot_subsidy NUMBER;
6049: l_eot_type_code VARCHAR2(30);
6050: BEGIN
6051: l_return_status := OKL_API.G_RET_STS_SUCCESS;
6052: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
6053: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
6054: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
6055: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
6056: -- check for logging on STATEMENT level

Line 6053: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

6049: l_eot_type_code VARCHAR2(30);
6050: BEGIN
6051: l_return_status := OKL_API.G_RET_STS_SUCCESS;
6052: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
6053: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
6054: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
6055: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
6056: -- check for logging on STATEMENT level
6057: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

Line 6057: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

6053: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
6054: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
6055: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
6056: -- check for logging on STATEMENT level
6057: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
6058: l_return_status := OKL_API.START_ACTIVITY(
6059: p_api_name => l_api_name,
6060: p_pkg_name => G_PKG_NAME,
6061: p_init_msg_list => p_init_msg_list,

Line 6433: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;

6429: l_deal_size NUMBER;
6430: l_months_factor NUMBER;
6431: BEGIN
6432: l_return_status := OKL_API.G_RET_STS_SUCCESS;
6433: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
6434: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
6435: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
6436: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
6437: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

Line 6434: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

6430: l_months_factor NUMBER;
6431: BEGIN
6432: l_return_status := OKL_API.G_RET_STS_SUCCESS;
6433: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
6434: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
6435: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
6436: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
6437: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
6438: l_return_status := OKL_API.START_ACTIVITY(

Line 6437: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

6433: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
6434: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
6435: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
6436: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
6437: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
6438: l_return_status := OKL_API.START_ACTIVITY(
6439: p_api_name => l_api_name,
6440: p_pkg_name => G_PKG_NAME,
6441: p_init_msg_list => p_init_msg_list,

Line 6800: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;

6796: l_target_arrears NUMBER;
6797: cfl_index BINARY_INTEGER;
6798: BEGIN
6799: l_return_status := OKL_API.G_RET_STS_SUCCESS;
6800: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
6801: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
6802: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
6803: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
6804: -- check for logging on STATEMENT level

Line 6801: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

6797: cfl_index BINARY_INTEGER;
6798: BEGIN
6799: l_return_status := OKL_API.G_RET_STS_SUCCESS;
6800: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
6801: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
6802: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
6803: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
6804: -- check for logging on STATEMENT level
6805: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

Line 6805: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

6801: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
6802: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
6803: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
6804: -- check for logging on STATEMENT level
6805: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
6806: l_return_status := OKL_API.START_ACTIVITY(
6807: p_api_name => l_api_name,
6808: p_pkg_name => G_PKG_NAME,
6809: p_init_msg_list => p_init_msg_list,

Line 7270: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;

7266: l_residual_int_factor NUMBER;
7267: l_net_adj_amt NUMBER;
7268: BEGIN
7269: l_return_status := OKL_API.G_RET_STS_SUCCESS;
7270: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
7271: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
7272: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
7273: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
7274: -- check for logging on STATEMENT level

Line 7271: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

7267: l_net_adj_amt NUMBER;
7268: BEGIN
7269: l_return_status := OKL_API.G_RET_STS_SUCCESS;
7270: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
7271: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
7272: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
7273: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
7274: -- check for logging on STATEMENT level
7275: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

Line 7275: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

7271: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
7272: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
7273: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
7274: -- check for logging on STATEMENT level
7275: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
7276: -- Call START_ACTIVITY to create savepoint, check compatibility
7277: -- and initialize message list
7278: l_return_status := OKL_API.START_ACTIVITY(
7279: p_api_name => l_api_name,

Line 8652: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;

8648: l_cf_hdr_rec OKL_LEASE_QUOTE_ASSET_PVT.cashflow_hdr_rec_type;
8649: l_cf_level_tbl OKL_LEASE_QUOTE_ASSET_PVT.cashflow_level_tbl_type;
8650: BEGIN
8651: l_return_status := OKL_API.G_RET_STS_SUCCESS;
8652: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
8653: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
8654: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
8655: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
8656: -- check for logging on STATEMENT level

Line 8653: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

8649: l_cf_level_tbl OKL_LEASE_QUOTE_ASSET_PVT.cashflow_level_tbl_type;
8650: BEGIN
8651: l_return_status := OKL_API.G_RET_STS_SUCCESS;
8652: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
8653: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
8654: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
8655: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
8656: -- check for logging on STATEMENT level
8657: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

Line 8657: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

8653: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
8654: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
8655: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
8656: -- check for logging on STATEMENT level
8657: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
8658: l_return_status := OKL_API.START_ACTIVITY(
8659: p_api_name => l_api_name,
8660: p_pkg_name => G_PKG_NAME,
8661: p_init_msg_list => p_init_msg_list,

Line 9169: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;

9165: l_asset_number VARCHAR2(15);
9166: l_fee_name VARCHAR2(150);
9167: BEGIN
9168: l_return_status := OKL_API.G_RET_STS_SUCCESS;
9169: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
9170: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
9171: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
9172: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
9173: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

Line 9170: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

9166: l_fee_name VARCHAR2(150);
9167: BEGIN
9168: l_return_status := OKL_API.G_RET_STS_SUCCESS;
9169: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
9170: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
9171: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
9172: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
9173: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
9174: l_return_status := OKL_API.START_ACTIVITY(

Line 9173: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

9169: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
9170: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
9171: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
9172: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
9173: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
9174: l_return_status := OKL_API.START_ACTIVITY(
9175: p_api_name => l_api_name,
9176: p_pkg_name => G_PKG_NAME,
9177: p_init_msg_list => p_init_msg_list,

Line 10437: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;

10433: is_debug_statement_on BOOLEAN;
10434: cfl_index NUMBER;
10435: BEGIN
10436: l_return_status := OKL_API.G_RET_STS_SUCCESS;
10437: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
10438: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
10439: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
10440: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
10441: -- check for logging on STATEMENT level

Line 10438: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

10434: cfl_index NUMBER;
10435: BEGIN
10436: l_return_status := OKL_API.G_RET_STS_SUCCESS;
10437: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
10438: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
10439: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
10440: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
10441: -- check for logging on STATEMENT level
10442: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

Line 10442: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

10438: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
10439: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
10440: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
10441: -- check for logging on STATEMENT level
10442: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
10443: l_return_status := OKL_API.START_ACTIVITY(
10444: p_api_name => l_api_name,
10445: p_pkg_name => G_PKG_NAME,
10446: p_init_msg_list => p_init_msg_list,

Line 10631: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;

10627: is_debug_statement_on BOOLEAN;
10628: cfl_index NUMBER;
10629: BEGIN
10630: l_return_status := OKL_API.G_RET_STS_SUCCESS;
10631: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
10632: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
10633: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
10634: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
10635: -- check for logging on STATEMENT level

Line 10632: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

10628: cfl_index NUMBER;
10629: BEGIN
10630: l_return_status := OKL_API.G_RET_STS_SUCCESS;
10631: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
10632: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
10633: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
10634: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
10635: -- check for logging on STATEMENT level
10636: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

Line 10636: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

10632: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
10633: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
10634: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
10635: -- check for logging on STATEMENT level
10636: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
10637: l_return_status := OKL_API.START_ACTIVITY(
10638: p_api_name => l_api_name,
10639: p_pkg_name => G_PKG_NAME,
10640: p_init_msg_list => p_init_msg_list,

Line 10898: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;

10894: l_cfl_tbl OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_level_tbl_type;
10895: l_solved VARCHAR2(30);
10896: BEGIN
10897: l_return_status := OKL_API.G_RET_STS_SUCCESS;
10898: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
10899: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
10900: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
10901: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
10902: -- check for logging on STATEMENT level

Line 10899: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

10895: l_solved VARCHAR2(30);
10896: BEGIN
10897: l_return_status := OKL_API.G_RET_STS_SUCCESS;
10898: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
10899: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
10900: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
10901: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
10902: -- check for logging on STATEMENT level
10903: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

Line 10903: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

10899: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
10900: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
10901: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
10902: -- check for logging on STATEMENT level
10903: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
10904: l_return_status := OKL_API.START_ACTIVITY(
10905: p_api_name => l_api_name,
10906: p_pkg_name => G_PKG_NAME,
10907: p_init_msg_list => p_init_msg_list,

Line 11219: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;

11215: l_debug_enabled VARCHAR2(10);
11216: is_debug_procedure_on BOOLEAN;
11217: is_debug_statement_on BOOLEAN;
11218: BEGIN
11219: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
11220: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
11221: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
11222: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
11223: -- check for logging on STATEMENT level

Line 11220: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

11216: is_debug_procedure_on BOOLEAN;
11217: is_debug_statement_on BOOLEAN;
11218: BEGIN
11219: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
11220: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
11221: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
11222: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
11223: -- check for logging on STATEMENT level
11224: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

Line 11224: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

11220: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
11221: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
11222: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
11223: -- check for logging on STATEMENT level
11224: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
11225: l_return_status := OKL_API.START_ACTIVITY(
11226: p_api_name => l_api_name,
11227: p_pkg_name => G_PKG_NAME,
11228: p_init_msg_list => p_init_msg_list,

Line 11837: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;

11833: WHERE ID = P_CFO_ID;
11834: -- Bug 7440199: Quote Streams ER: RGOOTY: End
11835: BEGIN
11836: l_return_status := OKL_API.G_RET_STS_SUCCESS;
11837: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
11838: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
11839: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
11840: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
11841: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

Line 11838: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

11834: -- Bug 7440199: Quote Streams ER: RGOOTY: End
11835: BEGIN
11836: l_return_status := OKL_API.G_RET_STS_SUCCESS;
11837: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
11838: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
11839: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
11840: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
11841: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
11842: l_return_status := OKL_API.START_ACTIVITY(

Line 11841: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

11837: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
11838: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
11839: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
11840: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
11841: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
11842: l_return_status := OKL_API.START_ACTIVITY(
11843: p_api_name => l_api_name,
11844: p_pkg_name => G_PKG_NAME,
11845: p_init_msg_list => p_init_msg_list,