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_GENERATE_PV_RENT_PVT dependencies on FND_LOG

Line 4: l_debug_level NUMBER :=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1: PACKAGE BODY OKL_GENERATE_PV_RENT_PVT AS
2: /* $Header: OKLRTPVB.pls 120.1.12020000.2 2012/08/07 13:42:13 rpillay ship $ */
3:
4: l_debug_level NUMBER :=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: l_proc_level NUMBER :=FND_LOG.LEVEL_PROCEDURE;
6: l_stat_level NUMBER :=FND_LOG.LEVEL_STATEMENT;
7:
8: -- Start of comments

Line 5: l_proc_level NUMBER :=FND_LOG.LEVEL_PROCEDURE;

1: PACKAGE BODY OKL_GENERATE_PV_RENT_PVT AS
2: /* $Header: OKLRTPVB.pls 120.1.12020000.2 2012/08/07 13:42:13 rpillay ship $ */
3:
4: l_debug_level NUMBER :=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: l_proc_level NUMBER :=FND_LOG.LEVEL_PROCEDURE;
6: l_stat_level NUMBER :=FND_LOG.LEVEL_STATEMENT;
7:
8: -- Start of comments
9: -- API name : generate_total_pv_rent

Line 6: l_stat_level NUMBER :=FND_LOG.LEVEL_STATEMENT;

2: /* $Header: OKLRTPVB.pls 120.1.12020000.2 2012/08/07 13:42:13 rpillay ship $ */
3:
4: l_debug_level NUMBER :=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: l_proc_level NUMBER :=FND_LOG.LEVEL_PROCEDURE;
6: l_stat_level NUMBER :=FND_LOG.LEVEL_STATEMENT;
7:
8: -- Start of comments
9: -- API name : generate_total_pv_rent
10: -- Pre-reqs : None

Line 129: FND_LOG.STRING(l_proc_level,'OKL_GENERATE_PV_RENT_PVT','Begin(+)');

125:
126: x_return_status := OKL_API.G_RET_STS_SUCCESS;
127:
128: IF (l_proc_level >= l_debug_level) THEN
129: FND_LOG.STRING(l_proc_level,'OKL_GENERATE_PV_RENT_PVT','Begin(+)');
130: END IF;
131:
132: l_return_status := OKL_API.START_ACTIVITY(
133: p_api_name => l_api_name,

Line 152: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent','khr_id:'||to_char(p_khr_id));

148: FETCH c_hdr_csr INTO l_hdr_csr_rec;
149: CLOSE c_hdr_csr;
150:
151: IF l_stat_level >= l_debug_level THEN
152: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent','khr_id:'||to_char(p_khr_id));
153: END IF;
154:
155: l_guess_iir := l_hdr_csr_rec.base_rate / 100.0;
156:

Line 188: fnd_log.STRING(l_stat_level,

184: RAISE OKL_API.G_EXCEPTION_ERROR;
185: END IF;
186:
187: IF l_stat_level >= l_debug_level THEN
188: fnd_log.STRING(l_stat_level,
189: 'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent','Month / Year = '||to_char(l_day_convention_month) || '/' || to_char(l_day_convention_year));
190: END IF;
191:
192: IF l_pricing_engine = 'INTERNAL' THEN

Line 207: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent','l_arrears_pay_dates_option :'||l_arrears_pay_dates_option);

203: l_arrears_pay_dates_option := 'LAST_DAY_OF_PERIOD';
204: END IF;
205:
206: IF l_stat_level >= l_debug_level THEN
207: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent','l_arrears_pay_dates_option :'||l_arrears_pay_dates_option);
208: END IF;
209:
210: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
211: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 230: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent','Number of records in l_asset_id_tbl :'||to_char(l_asset_id_tbl.COUNT));

226: OPEN c_asset_id_csr (p_khr_id);
227: FETCH c_asset_id_csr BULK COLLECT INTO l_asset_id_tbl;
228:
229: IF l_stat_level >= l_debug_level THEN
230: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent','Number of records in l_asset_id_tbl :'||to_char(l_asset_id_tbl.COUNT));
231: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent','Calling procedure generate_asset_rent.');
232: END IF;
233:
234: --Bug 7015073: Start

Line 231: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent','Calling procedure generate_asset_rent.');

227: FETCH c_asset_id_csr BULK COLLECT INTO l_asset_id_tbl;
228:
229: IF l_stat_level >= l_debug_level THEN
230: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent','Number of records in l_asset_id_tbl :'||to_char(l_asset_id_tbl.COUNT));
231: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent','Calling procedure generate_asset_rent.');
232: END IF;
233:
234: --Bug 7015073: Start
235: IF l_asset_id_tbl.COUNT > 0 THEN

Line 239: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent','l_asset_id_tbl(i).id :'||to_char(l_asset_id_tbl(i).id));

235: IF l_asset_id_tbl.COUNT > 0 THEN
236: FOR a in l_asset_id_tbl.FIRST..l_asset_id_tbl.LAST LOOP
237: i := i + 1;
238: IF l_stat_level >= l_debug_level THEN
239: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent','l_asset_id_tbl(i).id :'||to_char(l_asset_id_tbl(i).id));
240: END IF;
241:
242: -- generating the cash inflows
243: OKL_GENERATE_PV_RENT_PVT.generate_asset_rent

Line 286: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent','l_residual_value:'||to_char(l_residual_value));

282:
283: l_end_date := (ADD_MONTHS(l_hdr_csr_rec.start_date,l_hdr_csr_rec.term_duration) - 1);
284:
285: IF l_stat_level >= l_debug_level THEN
286: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent','l_residual_value:'||to_char(l_residual_value));
287: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent','l_time_zero_cost:'||to_char(l_time_zero_cost));
288: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent','l_end_date :'||to_char(l_end_date));
289: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent','Total_rent_inflow_tbl_count :'||to_char(l_total_rent_inflow_tbl.COUNT));
290: END IF;

Line 287: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent','l_time_zero_cost:'||to_char(l_time_zero_cost));

283: l_end_date := (ADD_MONTHS(l_hdr_csr_rec.start_date,l_hdr_csr_rec.term_duration) - 1);
284:
285: IF l_stat_level >= l_debug_level THEN
286: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent','l_residual_value:'||to_char(l_residual_value));
287: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent','l_time_zero_cost:'||to_char(l_time_zero_cost));
288: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent','l_end_date :'||to_char(l_end_date));
289: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent','Total_rent_inflow_tbl_count :'||to_char(l_total_rent_inflow_tbl.COUNT));
290: END IF;
291:

Line 288: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent','l_end_date :'||to_char(l_end_date));

284:
285: IF l_stat_level >= l_debug_level THEN
286: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent','l_residual_value:'||to_char(l_residual_value));
287: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent','l_time_zero_cost:'||to_char(l_time_zero_cost));
288: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent','l_end_date :'||to_char(l_end_date));
289: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent','Total_rent_inflow_tbl_count :'||to_char(l_total_rent_inflow_tbl.COUNT));
290: END IF;
291:
292: -- l_total_cash_inflow_tbl = lx_total_rent_inflow_tbl + residual value

Line 289: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent','Total_rent_inflow_tbl_count :'||to_char(l_total_rent_inflow_tbl.COUNT));

285: IF l_stat_level >= l_debug_level THEN
286: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent','l_residual_value:'||to_char(l_residual_value));
287: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent','l_time_zero_cost:'||to_char(l_time_zero_cost));
288: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent','l_end_date :'||to_char(l_end_date));
289: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent','Total_rent_inflow_tbl_count :'||to_char(l_total_rent_inflow_tbl.COUNT));
290: END IF;
291:
292: -- l_total_cash_inflow_tbl = lx_total_rent_inflow_tbl + residual value
293:

Line 301: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent','l_dpp:'||to_char(l_dpp));

297:
298:
299: IF l_residual_value > 0 THEN
300: IF l_stat_level >= l_debug_level THEN
301: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent','l_dpp:'||to_char(l_dpp));
302: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent','l_ppy:'||to_char(l_ppy));
303: END IF;
304:
305: l_total_cash_inflow_tbl(lx_total_rent_inflow_tbl_count + 1).cf_amount := l_residual_value;

Line 302: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent','l_ppy:'||to_char(l_ppy));

298:
299: IF l_residual_value > 0 THEN
300: IF l_stat_level >= l_debug_level THEN
301: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent','l_dpp:'||to_char(l_dpp));
302: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent','l_ppy:'||to_char(l_ppy));
303: END IF;
304:
305: l_total_cash_inflow_tbl(lx_total_rent_inflow_tbl_count + 1).cf_amount := l_residual_value;
306: l_total_cash_inflow_tbl(lx_total_rent_inflow_tbl_count + 1).cf_number := lx_total_rent_inflow_tbl_count+1; -- TBD

Line 336: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent',

332: IF l_stat_level >= l_debug_level THEN
333: IF l_total_rent_inflow_tbl.COUNT > 0 THEN
334: FOR j IN l_total_rent_inflow_tbl.FIRST .. l_total_rent_inflow_tbl.LAST
335: LOOP
336: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent',
337: TO_CHAR(l_total_rent_inflow_tbl(j).cf_number||' '||l_total_rent_inflow_tbl(j).cf_date || ' ' || l_total_rent_inflow_tbl(j).cf_amount));
338: END LOOP;
339: END IF;
340: END IF;

Line 343: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent','Total_cash_inflow_tbl_count:'||to_char(l_total_cash_inflow_tbl.count));

339: END IF;
340: END IF;
341:
342: IF l_stat_level >= l_debug_level THEN
343: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent','Total_cash_inflow_tbl_count:'||to_char(l_total_cash_inflow_tbl.count));
344: END IF;
345:
346: IF l_stat_level >= l_debug_level THEN
347: IF l_total_cash_inflow_tbl.COUNT > 0 THEN

Line 350: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent',

346: IF l_stat_level >= l_debug_level THEN
347: IF l_total_cash_inflow_tbl.COUNT > 0 THEN
348: FOR j IN l_total_cash_inflow_tbl.FIRST .. l_total_cash_inflow_tbl.LAST
349: LOOP
350: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent',
351: TO_CHAR(l_total_cash_inflow_tbl(j).cf_number||' '||l_total_cash_inflow_tbl(j).cf_date || ' ' || l_total_cash_inflow_tbl(j).cf_amount));
352: END LOOP;
353: END IF;
354: END IF;

Line 359: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent','Calling procedure compute_iir');

355:
356:
357: -- calculating IIR
358: IF l_stat_level >= l_debug_level THEN
359: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent','Calling procedure compute_iir');
360: END IF;
361:
362: IF NVL(l_time_zero_cost,0) = 0
363: THEN

Line 386: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent','l_iir: '||TO_CHAR(l_iir));

382: RAISE OKL_API.G_EXCEPTION_ERROR;
383: END IF;
384:
385: IF l_stat_level >= l_debug_level THEN
386: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent','l_iir: '||TO_CHAR(l_iir));
387: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent','calculating the PV rent');
388: END IF;
389:
390: -- calculating the PV rent

Line 387: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent','calculating the PV rent');

383: END IF;
384:
385: IF l_stat_level >= l_debug_level THEN
386: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent','l_iir: '||TO_CHAR(l_iir));
387: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent','calculating the PV rent');
388: END IF;
389:
390: -- calculating the PV rent
391:

Line 394: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent','calculating the PV of residual value');

390: -- calculating the PV rent
391:
392: IF l_residual_value > 0 THEN
393: IF l_stat_level >= l_debug_level THEN
394: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent','calculating the PV of residual value');
395: END IF;
396:
397: l_period_residual_value := l_total_cash_inflow_tbl(lx_total_rent_inflow_tbl_count + 1).cf_days/l_dpp;
398:

Line 402: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent',

398:
399: l_pv_residual_value := l_residual_value / POWER( 1 + (l_iir/(l_ppy)), l_period_residual_value);
400:
401: IF l_stat_level >= l_debug_level THEN
402: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent',
403: 'PV of residual value: '||TO_CHAR(l_pv_residual_value));
404: END IF;
405: END IF;
406:

Line 414: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent','x_total_pv_rent: '||TO_CHAR(x_total_pv_rent));

410:
411: x_total_pv_rent := ROUND(l_pv_rent,l_precision);
412:
413: IF l_stat_level >= l_debug_level THEN
414: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_total_pv_rent','x_total_pv_rent: '||TO_CHAR(x_total_pv_rent));
415: END IF;
416:
417:
418: IF (l_proc_level >= l_debug_level) THEN

Line 419: FND_LOG.STRING(l_proc_level,'OKL_GENERATE_PV_RENT_PVT','End(-)');

415: END IF;
416:
417:
418: IF (l_proc_level >= l_debug_level) THEN
419: FND_LOG.STRING(l_proc_level,'OKL_GENERATE_PV_RENT_PVT','End(-)');
420: END IF;
421:
422: okl_api.end_activity(x_msg_count => x_msg_count
423: ,x_msg_data => x_msg_data);

Line 567: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_asset_rent','Begin(+)');

563:
564: x_return_status := OKL_API.G_RET_STS_SUCCESS;
565:
566: IF l_stat_level >= l_debug_level THEN
567: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_asset_rent','Begin(+)');
568: END IF;
569:
570: l_return_status := OKL_API.START_ACTIVITY(
571: p_api_name => l_api_name,

Line 662: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_asset_rent',

658: x_ppy := l_ppy;
659:
660:
661: IF l_stat_level >= l_debug_level THEN
662: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_asset_rent',
663: 'x_total_rent_inflow_tbl.count :'||TO_CHAR(x_total_rent_inflow_tbl.count));
664: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_asset_rent','End(-)');
665: END IF;
666:

Line 664: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_asset_rent','End(-)');

660:
661: IF l_stat_level >= l_debug_level THEN
662: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_asset_rent',
663: 'x_total_rent_inflow_tbl.count :'||TO_CHAR(x_total_rent_inflow_tbl.count));
664: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_asset_rent','End(-)');
665: END IF;
666:
667:
668: okl_api.end_activity(x_msg_count => x_msg_count

Line 785: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_stream_elements','Begin(+)');

781: BEGIN
782:
783:
784: IF l_stat_level >= l_debug_level THEN
785: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_stream_elements','Begin(+)');
786: END IF;
787:
788: x_rent_inflow_tbl := p_rent_inflow_tbl;
789:

Line 840: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_stream_elements',

836:
837:
838: l_element_count := p_periods;
839: IF l_stat_level >= l_debug_level THEN
840: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_stream_elements',
841: 'creating elements:'||TO_CHAR(l_element_count));
842: END IF;
843:
844: FOR i IN (l_rent_inflow_tbl_count+1) .. (l_rent_inflow_tbl_count+l_element_count)

Line 860: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_stream_elements',

856: p_recurrence_date => p_recurrence_date,
857: p_arrears_pay_dates_option => p_arrears_pay_dates_option);
858:
859: IF l_stat_level >= l_debug_level THEN
860: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_stream_elements',
861: 'get_sel_date-p_start_date:'||to_char(p_start_date)||' p_arrears_yn:'||p_arrears_yn||' i:'||i||' p_months_factor:'||p_months_factor||
862: ' cf_date:'|| x_rent_inflow_tbl(i).cf_date||' p_recurrence_date:'||
863: p_recurrence_date||' p_arrears_pay_dates_option:'||p_arrears_pay_dates_option);
864:

Line 902: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_stream_elements',

898: END LOOP;
899: END IF;
900:
901: IF l_stat_level >= l_debug_level THEN
902: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_stream_elements',
903: 'x_rent_inflow_tbl.count :'||TO_CHAR(x_rent_inflow_tbl.count));
904: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_stream_elements','End(-)');
905: END IF;
906:

Line 904: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_stream_elements','End(-)');

900:
901: IF l_stat_level >= l_debug_level THEN
902: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_stream_elements',
903: 'x_rent_inflow_tbl.count :'||TO_CHAR(x_rent_inflow_tbl.count));
904: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.generate_stream_elements','End(-)');
905: END IF;
906:
907:
908:

Line 1038: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.compute_iir','Begin(+)');

1034: RAISE OKL_API.G_EXCEPTION_ERROR;
1035: END IF;
1036:
1037: IF l_stat_level >= l_debug_level THEN
1038: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.compute_iir','Begin(+)');
1039: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.compute_iir','Initial iir estimated ' || TO_CHAR(l_iir));
1040: END IF;
1041:
1042:

Line 1039: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.compute_iir','Initial iir estimated ' || TO_CHAR(l_iir));

1035: END IF;
1036:
1037: IF l_stat_level >= l_debug_level THEN
1038: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.compute_iir','Begin(+)');
1039: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.compute_iir','Initial iir estimated ' || TO_CHAR(l_iir));
1040: END IF;
1041:
1042:
1043: l_initial_incr := nvl(l_increment, 0);

Line 1050: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.compute_iir','ITERATION # '||i||' IIR Guess '||l_iir||' starting l_npv'||l_npv);

1046: i := i + 1;
1047: l_npv := -(p_cash_out_flows);
1048:
1049: IF l_stat_level >= l_debug_level THEN
1050: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.compute_iir','ITERATION # '||i||' IIR Guess '||l_iir||' starting l_npv'||l_npv);
1051: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.compute_iir','p_cash_in_flows_tbl.count ' || TO_CHAR(p_cash_in_flows_tbl.count));
1052: END IF;
1053:
1054: IF p_cash_in_flows_tbl.count > 0 THEN

Line 1051: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.compute_iir','p_cash_in_flows_tbl.count ' || TO_CHAR(p_cash_in_flows_tbl.count));

1047: l_npv := -(p_cash_out_flows);
1048:
1049: IF l_stat_level >= l_debug_level THEN
1050: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.compute_iir','ITERATION # '||i||' IIR Guess '||l_iir||' starting l_npv'||l_npv);
1051: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.compute_iir','p_cash_in_flows_tbl.count ' || TO_CHAR(p_cash_in_flows_tbl.count));
1052: END IF;
1053:
1054: IF p_cash_in_flows_tbl.count > 0 THEN
1055:

Line 1086: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.compute_iir',

1082: l_npv := l_npv + (l_cf_amount / POWER((1 + l_iir/l_cf_ppy), l_periods));
1083:
1084:
1085: IF l_stat_level >= l_debug_level THEN
1086: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.compute_iir',
1087: TO_CHAR(a, '99')||' '||TO_CHAR(l_cf_date, 'DD-MON-YYYY')||' '||TO_CHAR(l_days_in_future, '9999')||' '||TO_CHAR(l_periods, '99.999')||' '||TO_CHAR(l_cf_amount, '999.999')||
1088: ' '||TO_CHAR((l_cf_amount / POWER((1 + l_iir/l_cf_ppy), l_periods)), '999.990'));
1089: END IF;
1090:

Line 1096: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.compute_iir','NPV ' || TO_CHAR(L_NPV));

1092:
1093: END IF;
1094:
1095: IF l_stat_level >= l_debug_level THEN
1096: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.compute_iir','NPV ' || TO_CHAR(L_NPV));
1097: END IF;
1098:
1099: IF ROUND(l_npv, p_precision+1) = 0 THEN
1100: x_iir := l_iir; -- LLA API multiples by 100 before updating KHR implicit_interest_rate column

Line 1102: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.compute_iir','final l_iir : ' || TO_CHAR(l_iir));

1098:
1099: IF ROUND(l_npv, p_precision+1) = 0 THEN
1100: x_iir := l_iir; -- LLA API multiples by 100 before updating KHR implicit_interest_rate column
1101: IF l_stat_level >= l_debug_level THEN
1102: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.compute_iir','final l_iir : ' || TO_CHAR(l_iir));
1103: END IF;
1104: RETURN;
1105: END IF;
1106:

Line 1205: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.compute_iir',

1201: l_iir_decided := 'F';
1202: END IF;
1203:
1204: IF l_stat_level >= l_debug_level THEN
1205: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.compute_iir',
1206: i || '-Loop l_npv ' || to_char(l_npv) );
1207: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.compute_iir',
1208: i || '-Loop l_increment ' || to_char(l_increment) );
1209: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.compute_iir',

Line 1207: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.compute_iir',

1203:
1204: IF l_stat_level >= l_debug_level THEN
1205: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.compute_iir',
1206: i || '-Loop l_npv ' || to_char(l_npv) );
1207: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.compute_iir',
1208: i || '-Loop l_increment ' || to_char(l_increment) );
1209: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.compute_iir',
1210: i || '-Loop iir ' || to_char(l_iir) );
1211: END IF;

Line 1209: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.compute_iir',

1205: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.compute_iir',
1206: i || '-Loop l_npv ' || to_char(l_npv) );
1207: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.compute_iir',
1208: i || '-Loop l_increment ' || to_char(l_increment) );
1209: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.compute_iir',
1210: i || '-Loop iir ' || to_char(l_iir) );
1211: END IF;
1212:
1213:

Line 1222: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.compute_iir','End(-)');

1218:
1219: END LOOP; -- first
1220:
1221: IF l_stat_level >= l_debug_level THEN
1222: fnd_log.STRING(l_stat_level,'OKL_GENERATE_PV_RENT_PVT.compute_iir','End(-)');
1223: END IF;
1224:
1225:
1226: EXCEPTION