[Home] [Help]
788: l_amort_tbl(i).NORMAL_INT_AMOUNT := 0;
789: l_amort_tbl(i).ADD_PRIN_INT_AMOUNT := 0;
790: l_amort_tbl(i).ADD_INT_INT_AMOUNT := 0;
791: l_amort_tbl(i).PENAL_INT_AMOUNT := 0;
792: l_amort_tbl(i).PERIOD := FND_DATE.DATE_TO_DISPLAYDATE(l_loan_details.loan_start_date, 1) || ' - ' || FND_DATE.DATE_TO_DISPLAYDATE(l_loan_details.loan_start_date, 1);
793: l_amort_tbl(i).DISBURSEMENT_AMOUNT := l_original_loan_amount;
794: l_amort_tbl(i).FUNDED_AMOUNT := l_original_loan_amount;
795: l_amort_tbl(i).PREV_DEFERRED_INT_AMOUNT := 0;
796: l_amort_tbl(i).DEFERRED_INT_AMOUNT := 0;
848: l_amort_tbl(i).ADD_PRIN_INT_DETAILS := l_custom_tbl(p).ADD_PRIN_INT_DETAILS;
849: l_amort_tbl(i).ADD_INT_INT_DETAILS := l_custom_tbl(p).ADD_INT_INT_DETAILS;
850: l_amort_tbl(i).PENAL_INT_DETAILS := l_custom_tbl(p).PENAL_INT_DETAILS;
851: l_amort_tbl(i).FUNDED_AMOUNT := l_custom_tbl(p).FUNDED_AMOUNT;
852: l_amort_tbl(i).PERIOD := FND_DATE.DATE_TO_DISPLAYDATE(l_custom_tbl(p).PERIOD_START_DATE, 1) || ' - ' || FND_DATE.DATE_TO_DISPLAYDATE((l_custom_tbl(p).PERIOD_END_DATE-1), 1);
853: l_amort_tbl(i).DISBURSEMENT_AMOUNT := l_custom_tbl(p).DISBURSEMENT_AMOUNT;
854: l_amort_tbl(i).PREV_DEFERRED_INT_AMOUNT := l_custom_tbl(p).PREV_DEFERRED_INT_AMOUNT;
855: l_amort_tbl(i).DEFERRED_INT_AMOUNT := l_custom_tbl(p).DEFERRED_INT_AMOUNT;
856: l_amort_tbl(i).DEFERRED_INT_DETAILS := l_custom_tbl(p).DEFERRED_INT_DETAILS;
1712: l_amortization_rec.ADD_PRIN_INT_AMOUNT := l_custom_tbl(p).ADD_PRIN_INT_AMOUNT;
1713: l_amortization_rec.ADD_INT_INT_AMOUNT := l_custom_tbl(p).ADD_INT_INT_AMOUNT;
1714: l_amortization_rec.PENAL_INT_AMOUNT := l_custom_tbl(p).PENAL_INT_AMOUNT;
1715: l_amortization_rec.FUNDED_AMOUNT := l_custom_tbl(p).FUNDED_AMOUNT;
1716: l_amortization_rec.PERIOD := FND_DATE.DATE_TO_DISPLAYDATE(l_custom_tbl(p).PERIOD_START_DATE, 1) || ' - ' || FND_DATE.DATE_TO_DISPLAYDATE((l_custom_tbl(p).PERIOD_END_DATE-1), 1);
1717: l_amortization_rec.DISBURSEMENT_AMOUNT := l_custom_tbl(p).DISBURSEMENT_AMOUNT;
1718: l_amortization_rec.PREV_DEFERRED_INT_AMOUNT := l_custom_tbl(p).PREV_DEFERRED_INT_AMOUNT;
1719: l_amortization_rec.DEFERRED_INT_AMOUNT := l_custom_tbl(p).DEFERRED_INT_AMOUNT;
1720: l_amortization_rec.DEFERRED_INT_DETAILS := l_custom_tbl(p).DEFERRED_INT_DETAILS;
2748: l_amortization_rec.ADD_PRIN_INT_AMOUNT := 0;
2749: l_amortization_rec.ADD_INT_INT_AMOUNT := 0;
2750: l_amortization_rec.PENAL_INT_AMOUNT := 0;
2751: l_amortization_rec.FUNDED_AMOUNT := l_original_loan_amount;
2752: l_amortization_rec.PERIOD := FND_DATE.DATE_TO_DISPLAYDATE(l_loan_start_date, 1) || ' - ' || FND_DATE.DATE_TO_DISPLAYDATE(l_loan_start_date, 1);
2753: l_amortization_rec.DISBURSEMENT_AMOUNT := l_original_loan_amount;
2754: l_amortization_rec.PREV_DEFERRED_INT_AMOUNT := 0;
2755: l_amortization_rec.DEFERRED_INT_AMOUNT := 0;
2756: l_amortization_rec.PREV_CAP_INT_AMOUNT := 0;
3265: ,p_compounding_period => null);
3266: l_norm_interest := round(l_norm_interest, l_precision);
3267:
3268: l_norm_int_detail_str := l_norm_interest || ' (' ||
3269: 'Period ' || FND_DATE.DATE_TO_DISPLAYDATE(l_payment_tbl(l_installment_number).period_begin_date, 1) || ' - ' || FND_DATE.DATE_TO_DISPLAYDATE((l_payment_tbl(l_installment_number).period_end_date-1), 1) ||
3270: ' * Balance ' || l_wtd_balance ||
3271: ' * Rate ' || l_annualized_rate || '%)';
3272: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_norm_int_detail_str);
3273:
3304: ,p_compounding_period => null);
3305: l_norm_interest := round(l_norm_interest, l_precision);
3306:
3307: l_norm_int_detail_str := l_norm_interest || ' (' ||
3308: 'Period ' || FND_DATE.DATE_TO_DISPLAYDATE(l_payment_tbl(l_installment_number).period_begin_date, 1) || ' - ' || FND_DATE.DATE_TO_DISPLAYDATE((l_payment_tbl(l_installment_number).period_end_date-1), 1) ||
3309: ' * Balance ' || l_remaining_balance_theory1 ||
3310: ' * Rate ' || l_annualized_rate || '%)';
3311: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_norm_int_detail_str);
3312:
3463: l_amortization_rec.NORMAL_INT_AMOUNT := l_periodic_norm_int;
3464: l_amortization_rec.ADD_PRIN_INT_AMOUNT := l_periodic_add_prin_int;
3465: l_amortization_rec.ADD_INT_INT_AMOUNT := l_periodic_add_int_int;
3466: l_amortization_rec.PENAL_INT_AMOUNT := l_periodic_penal_int;
3467: l_amortization_rec.PERIOD := FND_DATE.DATE_TO_DISPLAYDATE(l_payment_tbl(l_installment_number).period_begin_date, 1) || ' - ' || FND_DATE.DATE_TO_DISPLAYDATE((l_payment_tbl(l_installment_number).period_end_date-1), 1);
3468: l_amortization_rec.DISBURSEMENT_AMOUNT := l_increased_amount;
3469: l_amortization_rec.FUNDED_AMOUNT := l_end_funded_amount;
3470: l_amortization_rec.PREV_DEFERRED_INT_AMOUNT := 0;
3471: l_amortization_rec.DEFERRED_INT_AMOUNT := 0;
4113: l_amortization_rec.ADD_PRIN_INT_AMOUNT := 0;
4114: l_amortization_rec.ADD_INT_INT_AMOUNT := 0;
4115: l_amortization_rec.PENAL_INT_AMOUNT := 0;
4116: l_amortization_rec.FUNDED_AMOUNT := l_original_loan_amount;
4117: l_amortization_rec.PERIOD := FND_DATE.DATE_TO_DISPLAYDATE(l_loan_start_date, 1) || ' - ' || FND_DATE.DATE_TO_DISPLAYDATE(l_loan_start_date, 1);
4118: l_amortization_rec.DISBURSEMENT_AMOUNT := l_original_loan_amount;
4119: l_amortization_rec.PREV_DEFERRED_INT_AMOUNT := 0;
4120: l_amortization_rec.DEFERRED_INT_AMOUNT := 0;
4121: l_amortization_rec.PREV_CAP_INT_AMOUNT := 0;
4580: ,p_compounding_period => null);
4581: l_norm_interest := round(l_norm_interest, l_precision);
4582:
4583: l_norm_int_detail_str := l_norm_interest || ' (' ||
4584: 'Period ' || FND_DATE.DATE_TO_DISPLAYDATE(l_payment_tbl(l_installment_number).period_begin_date, 1) || ' - ' || FND_DATE.DATE_TO_DISPLAYDATE((l_payment_tbl(l_installment_number).period_end_date-1), 1) ||
4585: ' * Balance ' || l_wtd_balance ||
4586: ' * Rate ' || l_annualized_rate || '%)';
4587: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_norm_int_detail_str);
4588:
4618: ,p_compounding_period => null);
4619: l_norm_interest := round(l_norm_interest, l_precision);
4620:
4621: l_norm_int_detail_str := l_norm_interest || ' (' ||
4622: 'Period ' || FND_DATE.DATE_TO_DISPLAYDATE(l_payment_tbl(l_installment_number).period_begin_date, 1) || ' - ' || FND_DATE.DATE_TO_DISPLAYDATE((l_payment_tbl(l_installment_number).period_end_date-1), 1) ||
4623: ' * Balance ' || l_remaining_balance_theory1 ||
4624: ' * Rate ' || l_annualized_rate || '%)';
4625: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_norm_int_detail_str);
4626:
4676: l_amortization_rec.NORMAL_INT_AMOUNT := l_norm_interest;
4677: l_amortization_rec.ADD_PRIN_INT_AMOUNT := l_add_prin_interest;
4678: l_amortization_rec.ADD_INT_INT_AMOUNT := l_add_int_interest;
4679: l_amortization_rec.PENAL_INT_AMOUNT := l_penal_interest;
4680: l_amortization_rec.PERIOD := FND_DATE.DATE_TO_DISPLAYDATE(l_payment_tbl(l_installment_number).period_begin_date, 1) || ' - ' || FND_DATE.DATE_TO_DISPLAYDATE((l_payment_tbl(l_installment_number).period_end_date-1), 1);
4681: l_amortization_rec.DISBURSEMENT_AMOUNT := l_increased_amount;
4682: l_amortization_rec.FUNDED_AMOUNT := l_end_funded_amount;
4683: l_amortization_rec.PREV_DEFERRED_INT_AMOUNT := 0;
4684: l_amortization_rec.DEFERRED_INT_AMOUNT := 0;
5369: l_amortization_rec.ADD_PRIN_INT_AMOUNT := 0;
5370: l_amortization_rec.ADD_INT_INT_AMOUNT := 0;
5371: l_amortization_rec.PENAL_INT_AMOUNT := 0;
5372: l_amortization_rec.FUNDED_AMOUNT := l_original_loan_amount;
5373: l_amortization_rec.PERIOD := FND_DATE.DATE_TO_DISPLAYDATE(l_loan_start_date, 1) || ' - ' || FND_DATE.DATE_TO_DISPLAYDATE(l_loan_start_date, 1);
5374: l_amortization_rec.DISBURSEMENT_AMOUNT := l_original_loan_amount;
5375: l_amortization_rec.PREV_DEFERRED_INT_AMOUNT := 0;
5376: l_amortization_rec.DEFERRED_INT_AMOUNT := 0;
5377: l_amortization_rec.PREV_CAP_INT_AMOUNT := 0;
5878: ,p_compounding_period => null);
5879: l_norm_interest := round(l_norm_interest, l_precision);
5880:
5881: l_norm_int_detail_str := l_norm_interest || ' (' ||
5882: 'Period ' || FND_DATE.DATE_TO_DISPLAYDATE(l_payment_tbl(l_installment_number).period_begin_date, 1) || ' - ' || FND_DATE.DATE_TO_DISPLAYDATE((l_payment_tbl(l_installment_number).period_end_date-1), 1) ||
5883: ' * Balance ' || l_wtd_balance ||
5884: ' * Rate ' || l_annualized_rate || '%)';
5885: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_norm_int_detail_str);
5886:
5917:
5918: l_norm_interest := round(l_norm_interest, l_precision);
5919:
5920: l_norm_int_detail_str := l_norm_interest || ' (' ||
5921: 'Period ' || FND_DATE.DATE_TO_DISPLAYDATE(l_payment_tbl(l_installment_number).period_begin_date, 1) || ' - ' || FND_DATE.DATE_TO_DISPLAYDATE((l_payment_tbl(l_installment_number).period_end_date-1), 1) ||
5922: ' * Balance ' || l_remaining_balance_theory1 ||
5923: ' * Rate ' || l_annualized_rate || '%)';
5924: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_norm_int_detail_str);
5925:
6009: l_amortization_rec.NORMAL_INT_AMOUNT := l_norm_interest;
6010: l_amortization_rec.ADD_PRIN_INT_AMOUNT := l_add_prin_interest;
6011: l_amortization_rec.ADD_INT_INT_AMOUNT := l_add_int_interest;
6012: l_amortization_rec.PENAL_INT_AMOUNT := l_penal_interest;
6013: l_amortization_rec.PERIOD := FND_DATE.DATE_TO_DISPLAYDATE(l_payment_tbl(l_installment_number).period_begin_date, 1) || ' - ' || FND_DATE.DATE_TO_DISPLAYDATE((l_payment_tbl(l_installment_number).period_end_date-1), 1);
6014: l_amortization_rec.DISBURSEMENT_AMOUNT := l_increased_amount;
6015: l_amortization_rec.FUNDED_AMOUNT := l_end_funded_amount;
6016: l_amortization_rec.PREV_DEFERRED_INT_AMOUNT := 0;
6017: l_amortization_rec.DEFERRED_INT_AMOUNT := 0;
6622: l_amortization_rec.NORMAL_INT_DETAILS := null;
6623: l_amortization_rec.ADD_PRIN_INT_DETAILS := null;
6624: l_amortization_rec.ADD_INT_INT_DETAILS := null;
6625: l_amortization_rec.PENAL_INT_DETAILS := null;
6626: l_amortization_rec.PERIOD := FND_DATE.DATE_TO_DISPLAYDATE(l_loan_start_date, 1) || ' - ' || FND_DATE.DATE_TO_DISPLAYDATE(l_loan_start_date, 1);
6627: l_amortization_rec.DISBURSEMENT_AMOUNT := l_end_balance;
6628: l_amortization_rec.FUNDED_AMOUNT := l_end_balance;
6629: l_amortization_rec.PREV_DEFERRED_INT_AMOUNT := 0;
6630: l_amortization_rec.DEFERRED_INT_AMOUNT := 0;
6734: l_periodic_interest := round(l_periodic_interest, l_precision);
6735: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': l_periodic_interest = ' || l_periodic_interest);
6736:
6737: l_norm_int_detail_str :=
6738: 'Period ' || FND_DATE.DATE_TO_DISPLAYDATE(l_payment_tbl(l_installment_number).period_begin_date, 1) || ' - ' || FND_DATE.DATE_TO_DISPLAYDATE((l_payment_tbl(l_installment_number).period_end_date-1), 1) ||
6739: ' * Balance ' || l_wtd_balance ||
6740: ' * Rate ' || l_annualized_rate || '%';
6741: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_norm_int_detail_str);
6742:
6768: l_amortization_rec.NORMAL_INT_DETAILS := l_norm_int_detail_str;
6769: l_amortization_rec.ADD_PRIN_INT_DETAILS := null;
6770: l_amortization_rec.ADD_INT_INT_DETAILS := null;
6771: l_amortization_rec.PENAL_INT_DETAILS := null;
6772: l_amortization_rec.PERIOD := FND_DATE.DATE_TO_DISPLAYDATE(l_payment_tbl(l_installment_number).period_begin_date, 1) || ' - ' || FND_DATE.DATE_TO_DISPLAYDATE((l_payment_tbl(l_installment_number).period_end_date-1), 1);
6773: l_amortization_rec.DISBURSEMENT_AMOUNT := l_end_balance - l_prev_end_balance;
6774: l_amortization_rec.FUNDED_AMOUNT := l_end_balance;
6775: l_amortization_rec.PREV_DEFERRED_INT_AMOUNT := 0;
6776: l_amortization_rec.DEFERRED_INT_AMOUNT := 0;
8902:
8903: if p_payoff_date < p_loan_details.last_interest_accrual then
8904: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - payoff too early');
8905: FND_MESSAGE.Set_Name('LNS', 'LNS_PAYOFF_TOO_EARLY');
8906: FND_MESSAGE.SET_TOKEN('PAYOFF_DATE', fnd_date.date_to_displaydate(p_loan_details.last_interest_accrual));
8907: FND_MSG_PUB.Add;
8908: RAISE FND_API.G_EXC_ERROR;
8909: end if;
8910:
8911: if p_payoff_date < p_loan_details.last_activity_date then
8912: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - payoff too early');
8913: FND_MESSAGE.Set_Name('LNS', 'LNS_PAYOFF_TOO_EARLY2');
8914: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LAST_ACTIVITY_DATE');
8915: FND_MESSAGE.SET_TOKEN('VALUE', fnd_date.date_to_displaydate(p_loan_details.last_activity_date));
8916: FND_MSG_PUB.Add;
8917: RAISE FND_API.G_EXC_ERROR;
8918: end if;
8919:
11168: if l_norm_int_detail_str is not null then
11169: l_norm_int_detail_str := l_norm_int_detail_str || ' +
';
11170: end if;
11171: l_norm_int_detail_str := l_norm_int_detail_str ||
11172: 'Period ' || FND_DATE.DATE_TO_DISPLAYDATE(l_norm_prev_act_date, 1) || ' - ' || FND_DATE.DATE_TO_DISPLAYDATE((l_activity_date-1), 1) ||
11173: ' * Balance ' || round(l_norm_prev_amount, l_precision) ||
11174: ' * Rate ' || p_interest_rate || '%';
11175: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_norm_int_detail_str);
11176: end if;
11237: if l_norm_int_detail_str is not null then
11238: l_norm_int_detail_str := l_norm_int_detail_str || ' +
';
11239: end if;
11240: l_norm_int_detail_str := l_norm_int_detail_str ||
11241: 'Period ' || FND_DATE.DATE_TO_DISPLAYDATE(l_norm_prev_act_date, 1) || ' - ' || FND_DATE.DATE_TO_DISPLAYDATE((l_activity_date-1), 1) ||
11242: ' * Balance ' || round(l_norm_prev_amount, l_precision) ||
11243: ' * Rate ' || p_interest_rate || '%';
11244: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_norm_int_detail_str);
11245: end if;
11497: if l_add_int_detail_str is not null then
11498: l_add_int_detail_str := l_add_int_detail_str || ' +
';
11499: end if;
11500: l_add_int_detail_str := l_add_int_detail_str ||
11501: 'Period ' || FND_DATE.DATE_TO_DISPLAYDATE(l_add_prev_act_date, 1) || ' - ' || FND_DATE.DATE_TO_DISPLAYDATE((l_activity_date-1), 1) ||
11502: ' * Balance ' || round(l_add_prev_amount, l_precision) ||
11503: ' * Rate ' || p_interest_rate || '%';
11504: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_add_int_detail_str);
11505: end if;
11567: if l_penal_int_detail_str is not null then
11568: l_penal_int_detail_str := l_penal_int_detail_str || ' +
';
11569: end if;
11570: l_penal_int_detail_str := l_penal_int_detail_str ||
11571: 'Period ' || FND_DATE.DATE_TO_DISPLAYDATE(l_add_prev_act_date, 1) || ' - ' || FND_DATE.DATE_TO_DISPLAYDATE((l_activity_date-1), 1) ||
11572: ' * Balance ' || round(l_add_prev_amount, l_precision) ||
11573: ' * Rate ' || p_penal_int_rate || '%';
11574: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_penal_int_detail_str);
11575: end if;
11659: if l_add_int_detail_str is not null then
11660: l_add_int_detail_str := l_add_int_detail_str || ' +
';
11661: end if;
11662: l_add_int_detail_str := l_add_int_detail_str ||
11663: 'Period ' || FND_DATE.DATE_TO_DISPLAYDATE(l_add_prev_act_date, 1) || ' - ' || FND_DATE.DATE_TO_DISPLAYDATE((l_activity_date-1), 1) ||
11664: ' * Balance ' || round(l_add_prev_amount, l_precision) ||
11665: ' * Rate ' || p_interest_rate || '%';
11666: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_add_int_detail_str);
11667: end if;
11729: if l_penal_int_detail_str is not null then
11730: l_penal_int_detail_str := l_penal_int_detail_str || ' +
';
11731: end if;
11732: l_penal_int_detail_str := l_penal_int_detail_str ||
11733: 'Period ' || FND_DATE.DATE_TO_DISPLAYDATE(l_add_prev_act_date, 1) || ' - ' || FND_DATE.DATE_TO_DISPLAYDATE((l_activity_date-1), 1) ||
11734: ' * Balance ' || round(l_add_prev_amount, l_precision) ||
11735: ' * Rate ' || p_penal_int_rate || '%';
11736: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_penal_int_detail_str);
11737: end if;
11921: -- 1. trying 11i format DD-MON-RRRR
11922: -- 2. trying old R12 format MM/DD/YYYY
11923: -- 3. trying new R12 format YYYY-MM-DD
11924: BEGIN
11925: l_date_format := 'DD-MON-RRRR'; -- 11i code used fnd_date.date_to_chardate api which used this hardcoded date format
11926: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Trying to convert using 11i format ' || l_date_format || '...');
11927: l_amort_tbl(i).DUE_DATE := to_date(l_data, l_date_format);
11928: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Success!');
11929: EXCEPTION
12115: l_amort_tbl(i).EARLY_PAY_CR_AMOUNT := 0;
12116:
12117: if l_amort_tbl(i).INSTALLMENT_NUMBER = 0 then
12118: l_amort_tbl(i).INTEREST_RATE := l_rate_schedule(1).ANNUAL_RATE;
12119: l_amort_tbl(i).PERIOD := FND_DATE.DATE_TO_DISPLAYDATE(l_amort_tbl(i).PERIOD_START_DATE, 1) || ' - ' || FND_DATE.DATE_TO_DISPLAYDATE(l_amort_tbl(i).PERIOD_START_DATE, 1);
12120: else
12121: l_amort_tbl(i).PERIOD := FND_DATE.DATE_TO_DISPLAYDATE(l_amort_tbl(i).PERIOD_START_DATE, 1) || ' - ' || FND_DATE.DATE_TO_DISPLAYDATE((l_amort_tbl(i).DUE_DATE-1), 1);
12122: end if;
12123:
12117: if l_amort_tbl(i).INSTALLMENT_NUMBER = 0 then
12118: l_amort_tbl(i).INTEREST_RATE := l_rate_schedule(1).ANNUAL_RATE;
12119: l_amort_tbl(i).PERIOD := FND_DATE.DATE_TO_DISPLAYDATE(l_amort_tbl(i).PERIOD_START_DATE, 1) || ' - ' || FND_DATE.DATE_TO_DISPLAYDATE(l_amort_tbl(i).PERIOD_START_DATE, 1);
12120: else
12121: l_amort_tbl(i).PERIOD := FND_DATE.DATE_TO_DISPLAYDATE(l_amort_tbl(i).PERIOD_START_DATE, 1) || ' - ' || FND_DATE.DATE_TO_DISPLAYDATE((l_amort_tbl(i).DUE_DATE-1), 1);
12122: end if;
12123:
12124: l_amort_tbl(i).FUNDED_AMOUNT := l_FUNDED_AMOUNT + l_amort_tbl(i).DISBURSEMENT_AMOUNT;
12125: l_FUNDED_AMOUNT := l_amort_tbl(i).FUNDED_AMOUNT;
12322: if l_cr_detail_str is not null then
12323: l_cr_detail_str := l_cr_detail_str || ' +
';
12324: end if;
12325: l_cr_detail_str := l_cr_detail_str ||
12326: 'Period ' || FND_DATE.DATE_TO_DISPLAYDATE(l_from_date, 1) || ' - ' || FND_DATE.DATE_TO_DISPLAYDATE((l_to_date-1), 1) ||
12327: ' * Balance ' || round(l_amount, l_precision) ||
12328: ' * Rate ' || p_interest_rate || '%';
12329: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_cr_detail_str);
12330: