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.

[Home] [Help]

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

2393: -- Local Variables
2394: l_api_version CONSTANT NUMBER DEFAULT 1.0;
2395: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'compute_irr';
2396: l_return_status VARCHAR2(1);
2397: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'
2398: || G_PKG_NAME || '.' || UPPER(l_api_name);
2399: l_debug_enabled VARCHAR2(10);
2400: is_debug_procedure_on BOOLEAN;
2401: is_debug_statement_on BOOLEAN;

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

3460: l_api_version CONSTANT NUMBER DEFAULT 1.0;
3461: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'compute_iir_sfp';
3462: l_return_status VARCHAR2(1);
3463:
3464: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'
3465: || G_PKG_NAME || '.' || UPPER(l_api_name);
3466: l_debug_enabled VARCHAR2(10);
3467: is_debug_procedure_on BOOLEAN;
3468: is_debug_statement_on BOOLEAN;

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

3795: l_api_version CONSTANT NUMBER DEFAULT 1.0;
3796: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'compute_iir';
3797: l_return_status VARCHAR2(1);
3798:
3799: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'
3800: || G_PKG_NAME || '.' || UPPER(l_api_name);
3801: l_debug_enabled VARCHAR2(10);
3802: is_debug_procedure_on BOOLEAN;
3803: is_debug_statement_on BOOLEAN;

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

4731: -- Local Variables
4732: l_api_version CONSTANT NUMBER DEFAULT 1.0;
4733: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'get_lease_rate_factors';
4734: l_return_status VARCHAR2(1);
4735: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'
4736: || G_PKG_NAME || '.' || UPPER(l_api_name);
4737: l_debug_enabled VARCHAR2(10);
4738: is_debug_procedure_on BOOLEAN;
4739: is_debug_statement_on BOOLEAN;

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

4943: -- Local Variables
4944: l_api_version CONSTANT NUMBER DEFAULT 1.0;
4945: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'get_standard_rates';
4946: l_return_status VARCHAR2(1);
4947: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'
4948: || G_PKG_NAME || '.' || UPPER(l_api_name);
4949: l_debug_enabled VARCHAR2(10);
4950: is_debug_procedure_on BOOLEAN;
4951: is_debug_statement_on BOOLEAN;

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

5126: -- Local Variables
5127: l_api_version CONSTANT NUMBER DEFAULT 1.0;
5128: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'compute_bk_yield';
5129: l_return_status VARCHAR2(1);
5130: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'
5131: || G_PKG_NAME || '.' || UPPER(l_api_name);
5132: l_debug_enabled VARCHAR2(10);
5133: is_debug_procedure_on BOOLEAN;
5134: is_debug_statement_on BOOLEAN;

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

5970: IS
5971: l_api_version CONSTANT NUMBER DEFAULT 1.0;
5972: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'get_qq_rc_cash_flows';
5973: l_return_status VARCHAR2(1);
5974: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'
5975: || G_PKG_NAME || '.' || UPPER(l_api_name);
5976: l_debug_enabled VARCHAR2(10);
5977: is_debug_procedure_on BOOLEAN;
5978: is_debug_statement_on BOOLEAN;

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

6398: l_api_version CONSTANT NUMBER DEFAULT 1.0;
6399: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'get_qq_cash_flows (QQ)';
6400: l_return_status VARCHAR2(1);
6401:
6402: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'
6403: || G_PKG_NAME || '.' || UPPER(l_api_name);
6404: l_debug_enabled VARCHAR2(10);
6405: is_debug_procedure_on BOOLEAN;
6406: is_debug_statement_on BOOLEAN;

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

6692: l_api_version CONSTANT NUMBER DEFAULT 1.0;
6693: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'get_lq_cash_flows';
6694: l_return_status VARCHAR2(1);
6695:
6696: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'
6697: || G_PKG_NAME || '.' || UPPER(l_api_name);
6698: l_debug_enabled VARCHAR2(10);
6699: is_debug_procedure_on BOOLEAN;
6700: is_debug_statement_on BOOLEAN;

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

7207: l_product_name okl_products.NAME%TYPE;--Bug 5884825 PAGARG
7208: l_api_version CONSTANT NUMBER DEFAULT 1.0;
7209: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'price_quick_quote';
7210: l_return_status VARCHAR2(1);
7211: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'
7212: || G_PKG_NAME || '.' || UPPER(l_api_name);
7213: l_debug_enabled VARCHAR2(10);
7214: is_debug_procedure_on BOOLEAN;
7215: is_debug_statement_on BOOLEAN;

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

8595: -- Local Variables
8596: l_api_version CONSTANT NUMBER DEFAULT 1.0;
8597: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'distribute_fin_amount_lq';
8598: l_return_status VARCHAR2(1);
8599: l_module CONSTANT fnd_log_messages.module%TYPE :=
8600: 'LEASE.ACCOUNTING.PRICING.OKL_PRICING_UTILS_PVT.distribute_fin_amount_lq';
8601: l_debug_enabled VARCHAR2(10);
8602: is_debug_procedure_on BOOLEAN;
8603: is_debug_statement_on BOOLEAN;

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

8837: IS
8838: l_api_version CONSTANT NUMBER DEFAULT 1.0;
8839: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'price_standard_quote_asset';
8840: l_return_status VARCHAR2(1);
8841: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'
8842: || G_PKG_NAME || '.' || UPPER(l_api_name);
8843:
8844: l_debug_enabled VARCHAR2(10);
8845: is_debug_procedure_on BOOLEAN;

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

10424:
10425: l_api_version CONSTANT NUMBER DEFAULT 1.0;
10426: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'get_lq_srvc_cash_flows';
10427: l_return_status VARCHAR2(1);
10428: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'
10429: || G_PKG_NAME || '.' || UPPER(l_api_name);
10430:
10431: l_debug_enabled VARCHAR2(10);
10432: is_debug_procedure_on BOOLEAN;

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

10618:
10619: l_api_version CONSTANT NUMBER DEFAULT 1.0;
10620: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'get_lq_fee_cash_flows';
10621: l_return_status VARCHAR2(1);
10622: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'
10623: || G_PKG_NAME || '.' || UPPER(l_api_name);
10624:
10625: l_debug_enabled VARCHAR2(10);
10626: is_debug_procedure_on BOOLEAN;

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

10881: -- Local Variables Declaration
10882: l_api_version CONSTANT NUMBER DEFAULT 1.0;
10883: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'solve_pmnts_at_lq';
10884: l_return_status VARCHAR2(1);
10885: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'
10886: || G_PKG_NAME || '.' || UPPER(l_api_name);
10887:
10888: l_debug_enabled VARCHAR2(10);
10889: is_debug_procedure_on BOOLEAN;

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

11209: AND STL.PDT_ID = l_product_id
11210: AND (STL.START_DATE <= l_start_date)
11211: AND (STL.END_DATE >= l_start_date OR STL.END_DATE IS NULL)
11212: AND PRIMARY_STY_PURPOSE = 'RESIDUAL_VALUE';
11213: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'
11214: || G_PKG_NAME || '.' || UPPER(l_api_name);
11215: l_debug_enabled VARCHAR2(10);
11216: is_debug_procedure_on BOOLEAN;
11217: is_debug_statement_on BOOLEAN;

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

11469: IS
11470: l_api_version CONSTANT NUMBER DEFAULT 1.0;
11471: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'price_standard_quote';
11472: l_return_status VARCHAR2(1);
11473: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'
11474: || G_PKG_NAME || '.' || UPPER(l_api_name);
11475:
11476: l_debug_enabled VARCHAR2(10);
11477: is_debug_procedure_on BOOLEAN;

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,