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 FND_LOG

Line 12: p_module IN fnd_log_messages.module%TYPE,

8: PROCEDURE put_in_log(
9: p_debug_enabled IN VARCHAR2,
10: is_debug_procedure_on IN BOOLEAN,
11: is_debug_statement_on IN BOOLEAN,
12: p_module IN fnd_log_messages.module%TYPE,
13: p_level IN VARCHAR2,
14: msg IN VARCHAR2 )
15: AS
16: -- l_level: S - Statement, P- Procedure, B - Both

Line 21: FND_LOG.LEVEL_PROCEDURE,

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
25: (p_level = 'S' OR p_level = 'B' ))

Line 28: FND_LOG.LEVEL_STATEMENT,

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;
32: END put_in_log;

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 280: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.OKL_PRICING_UTILS_PVT.get_so_hdr';

276: -- Local Variables
277: l_api_version CONSTANT NUMBER DEFAULT 1.0;
278: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'get_so_hdr';
279: l_return_status VARCHAR2(1);
280: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.OKL_PRICING_UTILS_PVT.get_so_hdr';
281: l_debug_enabled VARCHAR2(10);
282: is_debug_procedure_on BOOLEAN;
283: is_debug_statement_on BOOLEAN;
284: BEGIN

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 482: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'

478: -- Local Variables
479: l_api_version CONSTANT NUMBER DEFAULT 1.0;
480: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'get_qq_item_cat_details';
481: l_return_status VARCHAR2(1);
482: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'
483: || G_PKG_NAME || '.' || UPPER(l_api_name);
484: l_debug_enabled VARCHAR2(10);
485: is_debug_procedure_on BOOLEAN;
486: is_debug_statement_on BOOLEAN;

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 607: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'

603: l_api_version CONSTANT NUMBER DEFAULT 1.0;
604: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'get_qq_asset_oec';
605: l_return_status VARCHAR2(1);
606:
607: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'
608: || G_PKG_NAME || '.' || UPPER(l_api_name);
609: l_debug_enabled VARCHAR2(10);
610: is_debug_procedure_on BOOLEAN;
611: is_debug_statement_on BOOLEAN;

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 770: l_module CONSTANT fnd_log_messages.module%TYPE

766: l_all_amounts_rec so_amt_details_rec_type;
767: l_api_version CONSTANT NUMBER DEFAULT 1.0;
768: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'get_qq_fin_adj_details';
769: l_return_status VARCHAR2(1);
770: l_module CONSTANT fnd_log_messages.module%TYPE
771: := 'LEASE.ACCOUNTING.PRICING.OKL_PRICING_UTILS_PVT.get_qq_fin_adjustments';
772: l_debug_enabled VARCHAR2(10);
773: is_debug_procedure_on BOOLEAN;
774: is_debug_statement_on BOOLEAN;

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 943: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'

939: -- Local Variables
940: l_api_version CONSTANT NUMBER DEFAULT 1.0;
941: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'get_qq_sgt_day_convention';
942: l_return_status VARCHAR2(1);
943: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'
944: || G_PKG_NAME || '.' || UPPER(l_api_name);
945: l_debug_enabled VARCHAR2(10);
946: is_debug_procedure_on BOOLEAN;
947: is_debug_statement_on BOOLEAN;

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 1056: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'

1052: -- Local Variables
1053: l_api_version CONSTANT NUMBER DEFAULT 1.0;
1054: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'get_lq_sgt_day_convention';
1055: l_return_status VARCHAR2(1);
1056: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'
1057: || G_PKG_NAME || '.' || UPPER(l_api_name);
1058: l_debug_enabled VARCHAR2(10);
1059: is_debug_procedure_on BOOLEAN;
1060: is_debug_statement_on BOOLEAN;

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 1218: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'

1214: -- Local Variables
1215: l_api_version CONSTANT NUMBER DEFAULT 1.0;
1216: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'get_qq_cash_flows';
1217: l_return_status VARCHAR2(1);
1218: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'
1219: || G_PKG_NAME || '.' || UPPER(l_api_name);
1220: l_debug_enabled VARCHAR2(10);
1221: is_debug_procedure_on BOOLEAN;
1222: is_debug_statement_on BOOLEAN;

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 1462: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'

1458: -- Local Variables
1459: l_api_version CONSTANT NUMBER DEFAULT 1.0;
1460: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'get_fee_srvc_cash_flows';
1461: l_return_status VARCHAR2(1);
1462: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'
1463: || G_PKG_NAME || '.' || UPPER(l_api_name);
1464: l_debug_enabled VARCHAR2(10);
1465: is_debug_procedure_on BOOLEAN;
1466: is_debug_statement_on BOOLEAN;

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 1732: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.OKL_PRICING_UTILS_PVT.gen_so_cf_strm_elements';

1728: -- Local Variables
1729: l_api_version CONSTANT NUMBER DEFAULT 1.0;
1730: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'gen_so_cf_strm_elements';
1731: l_return_status VARCHAR2(1);
1732: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.OKL_PRICING_UTILS_PVT.gen_so_cf_strm_elements';
1733: l_debug_enabled VARCHAR2(10);
1734: is_debug_procedure_on BOOLEAN;
1735: is_debug_statement_on BOOLEAN;
1736: l_period_start_date DATE;

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 1894: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.OKL_PRICING_UTILS_PVT.GEN_SO_CF_STRMS';

1890: l_temp_cf_strms_tbl cash_inflows_tbl_type;
1891: l_api_version CONSTANT NUMBER DEFAULT 1.0;
1892: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'gen_so_cf_strms';
1893: l_return_status VARCHAR2(1);
1894: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.OKL_PRICING_UTILS_PVT.GEN_SO_CF_STRMS';
1895: l_debug_enabled VARCHAR2(10);
1896: is_debug_procedure_on BOOLEAN;
1897: is_debug_statement_on BOOLEAN;
1898: -- Local Variables

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 2375: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'

2371: -- Local Variables
2372: l_api_version CONSTANT NUMBER DEFAULT 1.0;
2373: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'compute_irr';
2374: l_return_status VARCHAR2(1);
2375: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'
2376: || G_PKG_NAME || '.' || UPPER(l_api_name);
2377: l_debug_enabled VARCHAR2(10);
2378: is_debug_procedure_on BOOLEAN;
2379: is_debug_statement_on BOOLEAN;

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

2428: l_period_end_date DATE;
2429: BEGIN
2430: l_return_status := OKL_API.G_RET_STS_SUCCESS;
2431: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
2432: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
2433:
2434: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
2435: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
2436: -- check for logging on STATEMENT level

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

2433:
2434: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
2435: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
2436: -- check for logging on STATEMENT level
2437: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
2438: -- Call START_ACTIVITY to create savepoint, check compatibility and initialize message list
2439: l_return_status := OKL_API.START_ACTIVITY(
2440: p_api_name => l_api_name,
2441: p_pkg_name => G_PKG_NAME,

Line 3442: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'

3438: l_api_version CONSTANT NUMBER DEFAULT 1.0;
3439: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'compute_iir_sfp';
3440: l_return_status VARCHAR2(1);
3441:
3442: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'
3443: || G_PKG_NAME || '.' || UPPER(l_api_name);
3444: l_debug_enabled VARCHAR2(10);
3445: is_debug_procedure_on BOOLEAN;
3446: is_debug_statement_on BOOLEAN;

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

3464: l_residual_percent NUMBER;
3465: BEGIN
3466: l_return_status := OKL_API.G_RET_STS_SUCCESS;
3467: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
3468: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
3469:
3470: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
3471: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
3472: -- check for logging on STATEMENT level

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

3469:
3470: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
3471: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
3472: -- check for logging on STATEMENT level
3473: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
3474: -- Call START_ACTIVITY to create savepoint, check compatibility
3475: -- and initialize message list
3476: l_return_status := OKL_API.START_ACTIVITY(
3477: p_api_name => l_api_name,

Line 3777: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'

3773: l_api_version CONSTANT NUMBER DEFAULT 1.0;
3774: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'compute_iir';
3775: l_return_status VARCHAR2(1);
3776:
3777: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'
3778: || G_PKG_NAME || '.' || UPPER(l_api_name);
3779: l_debug_enabled VARCHAR2(10);
3780: is_debug_procedure_on BOOLEAN;
3781: is_debug_statement_on BOOLEAN;

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

3825: l_residual_percent NUMBER;
3826: BEGIN
3827: l_return_status := OKL_API.G_RET_STS_SUCCESS;
3828: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
3829: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
3830:
3831: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
3832: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
3833: -- check for logging on STATEMENT level

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

3830:
3831: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
3832: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
3833: -- check for logging on STATEMENT level
3834: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
3835: -- Call START_ACTIVITY to create savepoint, check compatibility
3836: -- and initialize message list
3837: l_return_status := OKL_API.START_ACTIVITY(
3838: p_api_name => l_api_name,

Line 4713: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'

4709: -- Local Variables
4710: l_api_version CONSTANT NUMBER DEFAULT 1.0;
4711: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'get_lease_rate_factors';
4712: l_return_status VARCHAR2(1);
4713: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'
4714: || G_PKG_NAME || '.' || UPPER(l_api_name);
4715: l_debug_enabled VARCHAR2(10);
4716: is_debug_procedure_on BOOLEAN;
4717: is_debug_statement_on BOOLEAN;

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

4722: lvl_index NUMBER;
4723: BEGIN
4724: l_return_status := OKL_API.G_RET_STS_SUCCESS;
4725: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
4726: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
4727: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
4728: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
4729: -- check for logging on STATEMENT level
4730: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

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

4726: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
4727: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
4728: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
4729: -- check for logging on STATEMENT level
4730: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
4731: -- Call START_ACTIVITY to create savepoint, check compatibility
4732: -- and initialize message list
4733: l_return_status := OKL_API.START_ACTIVITY(
4734: p_api_name => l_api_name,

Line 4925: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'

4921: -- Local Variables
4922: l_api_version CONSTANT NUMBER DEFAULT 1.0;
4923: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'get_standard_rates';
4924: l_return_status VARCHAR2(1);
4925: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'
4926: || G_PKG_NAME || '.' || UPPER(l_api_name);
4927: l_debug_enabled VARCHAR2(10);
4928: is_debug_procedure_on BOOLEAN;
4929: is_debug_statement_on BOOLEAN;

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

4930: srt_details srt_details_rec_type;
4931: BEGIN
4932: l_return_status := OKL_API.G_RET_STS_SUCCESS;
4933: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
4934: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
4935:
4936: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
4937: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
4938: -- check for logging on STATEMENT level

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

4935:
4936: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
4937: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
4938: -- check for logging on STATEMENT level
4939: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
4940: -- Call START_ACTIVITY to create savepoint, check compatibility
4941: -- and initialize message list
4942: l_return_status := OKL_API.START_ACTIVITY(
4943: p_api_name => l_api_name,

Line 5103: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'

5099: -- Local Variables
5100: l_api_version CONSTANT NUMBER DEFAULT 1.0;
5101: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'compute_bk_yield';
5102: l_return_status VARCHAR2(1);
5103: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'
5104: || G_PKG_NAME || '.' || UPPER(l_api_name);
5105: l_debug_enabled VARCHAR2(10);
5106: is_debug_procedure_on BOOLEAN;
5107: is_debug_statement_on BOOLEAN;

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

5147: l_days_per_annum NUMBER := 0;
5148: BEGIN
5149: l_return_status := OKL_API.G_RET_STS_SUCCESS;
5150: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
5151: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
5152: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
5153: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
5154: -- check for logging on STATEMENT level
5155: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

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

5151: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
5152: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
5153: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
5154: -- check for logging on STATEMENT level
5155: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
5156: -- Call START_ACTIVITY to create savepoint, check compatibility
5157: -- and initialize message list
5158: l_return_status := OKL_API.START_ACTIVITY(
5159: p_api_name => l_api_name,

Line 5641: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'

5637: IS
5638: l_api_version CONSTANT NUMBER DEFAULT 1.0;
5639: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'get_qq_rc_cash_flows';
5640: l_return_status VARCHAR2(1);
5641: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'
5642: || G_PKG_NAME || '.' || UPPER(l_api_name);
5643: l_debug_enabled VARCHAR2(10);
5644: is_debug_procedure_on BOOLEAN;
5645: is_debug_statement_on BOOLEAN;

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

5716: l_eot_type_code VARCHAR2(30);
5717: BEGIN
5718: l_return_status := OKL_API.G_RET_STS_SUCCESS;
5719: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
5720: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
5721: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
5722: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
5723: -- check for logging on STATEMENT level
5724: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

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

5720: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
5721: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
5722: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
5723: -- check for logging on STATEMENT level
5724: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
5725: l_return_status := OKL_API.START_ACTIVITY(
5726: p_api_name => l_api_name,
5727: p_pkg_name => G_PKG_NAME,
5728: p_init_msg_list => p_init_msg_list,

Line 6069: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'

6065: l_api_version CONSTANT NUMBER DEFAULT 1.0;
6066: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'get_qq_cash_flows (QQ)';
6067: l_return_status VARCHAR2(1);
6068:
6069: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'
6070: || G_PKG_NAME || '.' || UPPER(l_api_name);
6071: l_debug_enabled VARCHAR2(10);
6072: is_debug_procedure_on BOOLEAN;
6073: is_debug_statement_on BOOLEAN;

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

6097: l_months_factor NUMBER;
6098: BEGIN
6099: l_return_status := OKL_API.G_RET_STS_SUCCESS;
6100: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
6101: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
6102: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
6103: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
6104: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
6105: l_return_status := OKL_API.START_ACTIVITY(

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

6100: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
6101: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
6102: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
6103: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
6104: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
6105: l_return_status := OKL_API.START_ACTIVITY(
6106: p_api_name => l_api_name,
6107: p_pkg_name => G_PKG_NAME,
6108: p_init_msg_list => p_init_msg_list,

Line 6363: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'

6359: l_api_version CONSTANT NUMBER DEFAULT 1.0;
6360: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'get_lq_cash_flows';
6361: l_return_status VARCHAR2(1);
6362:
6363: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'
6364: || G_PKG_NAME || '.' || UPPER(l_api_name);
6365: l_debug_enabled VARCHAR2(10);
6366: is_debug_procedure_on BOOLEAN;
6367: is_debug_statement_on BOOLEAN;

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

6464: cfl_index BINARY_INTEGER;
6465: BEGIN
6466: l_return_status := OKL_API.G_RET_STS_SUCCESS;
6467: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
6468: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
6469: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
6470: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
6471: -- check for logging on STATEMENT level
6472: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

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

6468: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
6469: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
6470: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
6471: -- check for logging on STATEMENT level
6472: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
6473: l_return_status := OKL_API.START_ACTIVITY(
6474: p_api_name => l_api_name,
6475: p_pkg_name => G_PKG_NAME,
6476: p_init_msg_list => p_init_msg_list,

Line 6877: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'

6873: l_product_name okl_products.NAME%TYPE;--Bug 5884825 PAGARG
6874: l_api_version CONSTANT NUMBER DEFAULT 1.0;
6875: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'price_quick_quote';
6876: l_return_status VARCHAR2(1);
6877: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'
6878: || G_PKG_NAME || '.' || UPPER(l_api_name);
6879: l_debug_enabled VARCHAR2(10);
6880: is_debug_procedure_on BOOLEAN;
6881: is_debug_statement_on BOOLEAN;

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

6933: l_net_adj_amt NUMBER;
6934: BEGIN
6935: l_return_status := OKL_API.G_RET_STS_SUCCESS;
6936: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
6937: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
6938: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
6939: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
6940: -- check for logging on STATEMENT level
6941: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

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

6937: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
6938: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
6939: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
6940: -- check for logging on STATEMENT level
6941: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
6942: -- Call START_ACTIVITY to create savepoint, check compatibility
6943: -- and initialize message list
6944: l_return_status := OKL_API.START_ACTIVITY(
6945: p_api_name => l_api_name,

Line 8265: l_module CONSTANT fnd_log_messages.module%TYPE :=

8261: -- Local Variables
8262: l_api_version CONSTANT NUMBER DEFAULT 1.0;
8263: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'distribute_fin_amount_lq';
8264: l_return_status VARCHAR2(1);
8265: l_module CONSTANT fnd_log_messages.module%TYPE :=
8266: 'LEASE.ACCOUNTING.PRICING.OKL_PRICING_UTILS_PVT.distribute_fin_amount_lq';
8267: l_debug_enabled VARCHAR2(10);
8268: is_debug_procedure_on BOOLEAN;
8269: is_debug_statement_on BOOLEAN;

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

8315: l_cf_level_tbl OKL_LEASE_QUOTE_ASSET_PVT.cashflow_level_tbl_type;
8316: BEGIN
8317: l_return_status := OKL_API.G_RET_STS_SUCCESS;
8318: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
8319: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
8320: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
8321: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
8322: -- check for logging on STATEMENT level
8323: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

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

8319: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
8320: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
8321: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
8322: -- check for logging on STATEMENT level
8323: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
8324: l_return_status := OKL_API.START_ACTIVITY(
8325: p_api_name => l_api_name,
8326: p_pkg_name => G_PKG_NAME,
8327: p_init_msg_list => p_init_msg_list,

Line 8503: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'

8499: IS
8500: l_api_version CONSTANT NUMBER DEFAULT 1.0;
8501: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'price_standard_quote_asset';
8502: l_return_status VARCHAR2(1);
8503: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'
8504: || G_PKG_NAME || '.' || UPPER(l_api_name);
8505:
8506: l_debug_enabled VARCHAR2(10);
8507: is_debug_procedure_on BOOLEAN;

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

8826: l_fee_name VARCHAR2(150);
8827: BEGIN
8828: l_return_status := OKL_API.G_RET_STS_SUCCESS;
8829: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
8830: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
8831: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
8832: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
8833: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
8834: l_return_status := OKL_API.START_ACTIVITY(

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

8829: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
8830: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
8831: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
8832: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
8833: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
8834: l_return_status := OKL_API.START_ACTIVITY(
8835: p_api_name => l_api_name,
8836: p_pkg_name => G_PKG_NAME,
8837: p_init_msg_list => p_init_msg_list,

Line 10082: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'

10078:
10079: l_api_version CONSTANT NUMBER DEFAULT 1.0;
10080: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'get_lq_fee_cash_flows';
10081: l_return_status VARCHAR2(1);
10082: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'
10083: || G_PKG_NAME || '.' || UPPER(l_api_name);
10084:
10085: l_debug_enabled VARCHAR2(10);
10086: is_debug_procedure_on BOOLEAN;

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

10088: cfl_index NUMBER;
10089: BEGIN
10090: l_return_status := OKL_API.G_RET_STS_SUCCESS;
10091: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
10092: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
10093: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
10094: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
10095: -- check for logging on STATEMENT level
10096: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

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

10092: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
10093: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
10094: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
10095: -- check for logging on STATEMENT level
10096: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
10097: l_return_status := OKL_API.START_ACTIVITY(
10098: p_api_name => l_api_name,
10099: p_pkg_name => G_PKG_NAME,
10100: p_init_msg_list => p_init_msg_list,

Line 10345: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'

10341: -- Local Variables Declaration
10342: l_api_version CONSTANT NUMBER DEFAULT 1.0;
10343: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'solve_pmnts_at_lq';
10344: l_return_status VARCHAR2(1);
10345: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'
10346: || G_PKG_NAME || '.' || UPPER(l_api_name);
10347:
10348: l_debug_enabled VARCHAR2(10);
10349: is_debug_procedure_on BOOLEAN;

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

10355: l_solved VARCHAR2(30);
10356: BEGIN
10357: l_return_status := OKL_API.G_RET_STS_SUCCESS;
10358: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
10359: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
10360: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
10361: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
10362: -- check for logging on STATEMENT level
10363: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

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

10359: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
10360: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
10361: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
10362: -- check for logging on STATEMENT level
10363: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
10364: l_return_status := OKL_API.START_ACTIVITY(
10365: p_api_name => l_api_name,
10366: p_pkg_name => G_PKG_NAME,
10367: p_init_msg_list => p_init_msg_list,

Line 10493: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'

10489: IS
10490: l_api_version CONSTANT NUMBER DEFAULT 1.0;
10491: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'price_standard_quote';
10492: l_return_status VARCHAR2(1);
10493: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'
10494: || G_PKG_NAME || '.' || UPPER(l_api_name);
10495:
10496: l_debug_enabled VARCHAR2(10);
10497: is_debug_procedure_on BOOLEAN;

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

10805: -- Bug 6622178 : End
10806: BEGIN
10807: l_return_status := OKL_API.G_RET_STS_SUCCESS;
10808: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
10809: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
10810: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
10811: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
10812: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
10813: l_return_status := OKL_API.START_ACTIVITY(

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

10808: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
10809: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
10810: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
10811: 'begin debug OKLRPIUB.pls call '|| lower(l_api_name));
10812: is_debug_statement_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
10813: l_return_status := OKL_API.START_ACTIVITY(
10814: p_api_name => l_api_name,
10815: p_pkg_name => G_PKG_NAME,
10816: p_init_msg_list => p_init_msg_list,