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.LNS_FINANCIALS dependencies on FND_API

Line 225: IF FND_API.to_Boolean(p_init_msg_list) THEN

221: -- Standard Start of API savepoint
222: SAVEPOINT floatingPostProcessor;
223:
224: -- Initialize message list IF p_init_msg_list is set to TRUE.
225: IF FND_API.to_Boolean(p_init_msg_list) THEN
226: FND_MSG_PUB.initialize;
227: END IF;
228:
229: -- Initialize API return status to SUCCESS

Line 230: x_return_status := FND_API.G_RET_STS_SUCCESS;

226: FND_MSG_PUB.initialize;
227: END IF;
228:
229: -- Initialize API return status to SUCCESS
230: x_return_status := FND_API.G_RET_STS_SUCCESS;
231:
232: --
233: -- Api body
234: -- ----------------------------------------------------------------

Line 354: WHEN FND_API.G_EXC_ERROR THEN

350: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
351: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
352:
353: EXCEPTION
354: WHEN FND_API.G_EXC_ERROR THEN
355: ROLLBACK TO floatingPostProcessor;
356: x_return_status := FND_API.G_RET_STS_ERROR;
357: x_msg_count := l_msg_count;
358: x_msg_data := l_msg_data;

Line 356: x_return_status := FND_API.G_RET_STS_ERROR;

352:
353: EXCEPTION
354: WHEN FND_API.G_EXC_ERROR THEN
355: ROLLBACK TO floatingPostProcessor;
356: x_return_status := FND_API.G_RET_STS_ERROR;
357: x_msg_count := l_msg_count;
358: x_msg_data := l_msg_data;
359: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
360: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 362: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

358: x_msg_data := l_msg_data;
359: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
360: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
361:
362: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
363: ROLLBACK TO floatingPostProcessor;
364: x_return_status := FND_API.G_RET_STS_ERROR;
365: x_msg_count := l_msg_count;
366: x_msg_data := l_msg_data;

Line 364: x_return_status := FND_API.G_RET_STS_ERROR;

360: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
361:
362: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
363: ROLLBACK TO floatingPostProcessor;
364: x_return_status := FND_API.G_RET_STS_ERROR;
365: x_msg_count := l_msg_count;
366: x_msg_data := l_msg_data;
367: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
368: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 372: x_return_status := FND_API.G_RET_STS_ERROR;

368: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
369:
370: WHEN OTHERS THEN
371: ROLLBACK TO floatingPostProcessor;
372: x_return_status := FND_API.G_RET_STS_ERROR;
373: x_msg_count := l_msg_count;
374: x_msg_data := l_msg_data;
375: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
376: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 440: IF NOT FND_API.Compatible_API_Call (l_api_version_number, p_api_version,

436: -- Standard Start of API savepoint
437: SAVEPOINT validateLoan;
438:
439: -- Standard call to check for call compatibility.
440: IF NOT FND_API.Compatible_API_Call (l_api_version_number, p_api_version,
441: l_api_name, G_PKG_NAME)
442: THEN
443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
444: END IF;

Line 443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

439: -- Standard call to check for call compatibility.
440: IF NOT FND_API.Compatible_API_Call (l_api_version_number, p_api_version,
441: l_api_name, G_PKG_NAME)
442: THEN
443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
444: END IF;
445:
446: -- Initialize message list IF p_init_msg_list is set to TRUE.
447: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 447: IF FND_API.to_Boolean(p_init_msg_list) THEN

443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
444: END IF;
445:
446: -- Initialize message list IF p_init_msg_list is set to TRUE.
447: IF FND_API.to_Boolean(p_init_msg_list) THEN
448: FND_MSG_PUB.initialize;
449: END IF;
450:
451: -- Initialize API return status to SUCCESS

Line 452: x_return_status := FND_API.G_RET_STS_SUCCESS;

448: FND_MSG_PUB.initialize;
449: END IF;
450:
451: -- Initialize API return status to SUCCESS
452: x_return_status := FND_API.G_RET_STS_SUCCESS;
453:
454: --
455: -- Api body
456: -- ----------------------------------------------------------------

Line 468: RAISE FND_API.G_EXC_ERROR;

464: When No_Data_Found then
465: CLOSE c_terms;
466: FND_MESSAGE.Set_Name('LNS', 'LNS_NO_TERMS');
467: FND_MSG_PUB.Add;
468: RAISE FND_API.G_EXC_ERROR;
469: end;
470:
471: -- rate schedules should have one row
472: l_rate_tbl := lns_financials.getRateSchedule(p_loan_id, 'TERM');

Line 477: RAISE FND_API.G_EXC_ERROR;

473:
474: if l_rate_tbl.count = 0 then
475: FND_MESSAGE.Set_Name('LNS', 'LNS_NO_RATE_SCHEDULE');
476: FND_MSG_PUB.Add;
477: RAISE FND_API.G_EXC_ERROR;
478: end if;
479:
480: Begin
481: l_amount := lns_financials.getRemainingBalance(p_loan_id);

Line 485: RAISE FND_API.G_EXC_ERROR;

481: l_amount := lns_financials.getRemainingBalance(p_loan_id);
482: if l_amount <= 0 then
483: FND_MESSAGE.Set_Name('LNS', 'LNS_NO_AMOUNT');
484: FND_MSG_PUB.Add;
485: RAISE FND_API.G_EXC_ERROR;
486: end if;
487:
488: end;
489:

Line 499: WHEN FND_API.G_EXC_ERROR THEN

495:
496: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
497:
498: EXCEPTION
499: WHEN FND_API.G_EXC_ERROR THEN
500: x_return_status := FND_API.G_RET_STS_ERROR;
501: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
502:
503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 500: x_return_status := FND_API.G_RET_STS_ERROR;

496: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
497:
498: EXCEPTION
499: WHEN FND_API.G_EXC_ERROR THEN
500: x_return_status := FND_API.G_RET_STS_ERROR;
501: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
502:
503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
504: x_return_status := FND_API.G_RET_STS_ERROR;

Line 503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

499: WHEN FND_API.G_EXC_ERROR THEN
500: x_return_status := FND_API.G_RET_STS_ERROR;
501: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
502:
503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
504: x_return_status := FND_API.G_RET_STS_ERROR;
505: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, sqlerrm);
506:
507: WHEN OTHERS THEN

Line 504: x_return_status := FND_API.G_RET_STS_ERROR;

500: x_return_status := FND_API.G_RET_STS_ERROR;
501: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
502:
503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
504: x_return_status := FND_API.G_RET_STS_ERROR;
505: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, sqlerrm);
506:
507: WHEN OTHERS THEN
508: x_return_status := FND_API.G_RET_STS_ERROR;

Line 508: x_return_status := FND_API.G_RET_STS_ERROR;

504: x_return_status := FND_API.G_RET_STS_ERROR;
505: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, sqlerrm);
506:
507: WHEN OTHERS THEN
508: x_return_status := FND_API.G_RET_STS_ERROR;
509: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
510:
511: END validateLoan;
512:

Line 659: IF NOT FND_API.Compatible_API_Call (l_api_version_number, p_api_version,

655: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_loan_ID ' || p_loan_ID);
656: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_based_on_terms ' || p_based_on_terms);
657:
658: -- Standard call to check for call compatibility.
659: IF NOT FND_API.Compatible_API_Call (l_api_version_number, p_api_version,
660: l_api_name, G_PKG_NAME)
661: THEN
662: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
663: END IF;

Line 662: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

658: -- Standard call to check for call compatibility.
659: IF NOT FND_API.Compatible_API_Call (l_api_version_number, p_api_version,
660: l_api_name, G_PKG_NAME)
661: THEN
662: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
663: END IF;
664:
665: -- Initialize message list IF p_init_msg_list is set to TRUE.
666: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 666: IF FND_API.to_Boolean( p_init_msg_list ) THEN

662: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
663: END IF;
664:
665: -- Initialize message list IF p_init_msg_list is set to TRUE.
666: IF FND_API.to_Boolean( p_init_msg_list ) THEN
667: FND_MSG_PUB.initialize;
668: END IF;
669:
670: -- Initialize API return status to SUCCESS

Line 671: x_return_status := FND_API.G_RET_STS_SUCCESS;

667: FND_MSG_PUB.initialize;
668: END IF;
669:
670: -- Initialize API return status to SUCCESS
671: x_return_status := FND_API.G_RET_STS_SUCCESS;
672:
673: --
674: -- Api body
675: -- ----------------------------------------------------------------

Line 686: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

682: ,p_col_id => p_loan_id
683: ,p_col_name => 'LOAN_ID'
684: ,p_table_name => 'LNS_LOAN_HEADERS_ALL');
685:
686: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
687: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
688: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
689: FND_MESSAGE.SET_TOKEN('VALUE', p_loan_ID);
690: FND_MSG_PUB.ADD;

Line 691: RAISE FND_API.G_EXC_ERROR;

687: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
688: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
689: FND_MESSAGE.SET_TOKEN('VALUE', p_loan_ID);
690: FND_MSG_PUB.ADD;
691: RAISE FND_API.G_EXC_ERROR;
692: end if;
693: /*
694: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - getting customization status');
695:

Line 721: ,p_commit => FND_API.G_FALSE --p_commit

717: -- call preProcessInstallment only for current amortization
718: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - preProcess the loan');
719: preProcessInstallment(p_api_version => 1.0
720: ,p_init_msg_list => p_init_msg_list
721: ,p_commit => FND_API.G_FALSE --p_commit
722: ,p_loan_ID => p_loan_id
723: ,p_installment_number => lns_billing_util_pub.last_payment_number(p_loan_id)
724: ,x_amortization_rec => l_amortization_rec
725: ,x_return_status => l_return_status

Line 805: P_INIT_MSG_LIST => FND_API.G_TRUE,

801:
802: -- load custom schedule
803: LNS_CUSTOM_PUB.loadCustomSchedule(
804: P_API_VERSION => 1.0,
805: P_INIT_MSG_LIST => FND_API.G_TRUE,
806: P_COMMIT => FND_API.G_FALSE,
807: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
808: P_LOAN_ID => P_LOAN_ID,
809: P_BASED_ON_TERMS => p_based_on_terms,

Line 806: P_COMMIT => FND_API.G_FALSE,

802: -- load custom schedule
803: LNS_CUSTOM_PUB.loadCustomSchedule(
804: P_API_VERSION => 1.0,
805: P_INIT_MSG_LIST => FND_API.G_TRUE,
806: P_COMMIT => FND_API.G_FALSE,
807: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
808: P_LOAN_ID => P_LOAN_ID,
809: P_BASED_ON_TERMS => p_based_on_terms,
810: X_AMORT_METHOD => l_AMORT_METHOD,

Line 807: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,

803: LNS_CUSTOM_PUB.loadCustomSchedule(
804: P_API_VERSION => 1.0,
805: P_INIT_MSG_LIST => FND_API.G_TRUE,
806: P_COMMIT => FND_API.G_FALSE,
807: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
808: P_LOAN_ID => P_LOAN_ID,
809: P_BASED_ON_TERMS => p_based_on_terms,
810: X_AMORT_METHOD => l_AMORT_METHOD,
811: X_CUSTOM_TBL => l_custom_tbl,

Line 817: RAISE FND_API.G_EXC_ERROR;

813: x_msg_count => l_msg_count,
814: x_msg_data => l_msg_data);
815:
816: IF l_return_status <> 'S' THEN
817: RAISE FND_API.G_EXC_ERROR;
818: END IF;
819:
820: for p in 1..l_custom_tbl.count loop
821:

Line 981: IF FND_API.to_Boolean(p_commit) THEN

977: -- End of API body
978: --
979:
980: -- Standard check for p_commit
981: IF FND_API.to_Boolean(p_commit) THEN
982: COMMIT WORK;
983: END IF;
984:
985: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 989: WHEN FND_API.G_EXC_ERROR THEN

985: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
986: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
987:
988: EXCEPTION
989: WHEN FND_API.G_EXC_ERROR THEN
990: ROLLBACK TO runAmortization_PVT;
991: x_return_status := FND_API.G_RET_STS_ERROR;
992: x_msg_count := l_msg_count;
993: x_msg_data := l_msg_data;

Line 991: x_return_status := FND_API.G_RET_STS_ERROR;

987:
988: EXCEPTION
989: WHEN FND_API.G_EXC_ERROR THEN
990: ROLLBACK TO runAmortization_PVT;
991: x_return_status := FND_API.G_RET_STS_ERROR;
992: x_msg_count := l_msg_count;
993: x_msg_data := l_msg_data;
994: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
995: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 997: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

993: x_msg_data := l_msg_data;
994: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
995: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
996:
997: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
998: ROLLBACK TO runAmortization_PVT;
999: x_return_status := FND_API.G_RET_STS_ERROR;
1000: x_msg_count := l_msg_count;
1001: x_msg_data := l_msg_data;

Line 999: x_return_status := FND_API.G_RET_STS_ERROR;

995: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
996:
997: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
998: ROLLBACK TO runAmortization_PVT;
999: x_return_status := FND_API.G_RET_STS_ERROR;
1000: x_msg_count := l_msg_count;
1001: x_msg_data := l_msg_data;
1002: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1003: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 1007: x_return_status := FND_API.G_RET_STS_ERROR;

1003: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
1004:
1005: WHEN OTHERS THEN
1006: ROLLBACK TO runAmortization_PVT;
1007: x_return_status := FND_API.G_RET_STS_ERROR;
1008: x_msg_count := l_msg_count;
1009: x_msg_data := l_msg_data;
1010: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1011: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 1077: RAISE FND_API.G_EXC_ERROR;

1073: -- this will be a loan that will never be paid off
1074: if ( l_periodic_rate * p_loan_amount ) / (p_payments_per_year * p_termly_amount) >= 1 then
1075: FND_MESSAGE.Set_Name('LNS', 'LNS_NEVER_PAYOFF');
1076: FND_MSG_PUB.Add;
1077: RAISE FND_API.G_EXC_ERROR;
1078: end if;
1079:
1080: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': l_periodic_rate * p_loan_amount :' || l_periodic_rate * p_loan_amount);
1081: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': p_payments_per_year * p_termly_amount : ' || p_payments_per_year * p_termly_amount);

Line 1113: When FND_API.G_EXC_ERROR then

1109: return l_num_periods;
1110:
1111: Exception
1112:
1113: When FND_API.G_EXC_ERROR then
1114: return -1;
1115:
1116: When others then
1117: return -1;

Line 1208: IF NOT FND_API.Compatible_API_Call (l_api_version_number, p_api_version,

1204: -- Standard Start of API savepoint
1205: SAVEPOINT preProcessInstallment;
1206:
1207: -- Standard call to check for call compatibility.
1208: IF NOT FND_API.Compatible_API_Call (l_api_version_number, p_api_version,
1209: l_api_name, G_PKG_NAME)
1210: THEN
1211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1212: END IF;

Line 1211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1207: -- Standard call to check for call compatibility.
1208: IF NOT FND_API.Compatible_API_Call (l_api_version_number, p_api_version,
1209: l_api_name, G_PKG_NAME)
1210: THEN
1211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1212: END IF;
1213:
1214: -- Initialize message list IF p_init_msg_list is set to TRUE.
1215: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1215: IF FND_API.to_Boolean(p_init_msg_list) THEN

1211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1212: END IF;
1213:
1214: -- Initialize message list IF p_init_msg_list is set to TRUE.
1215: IF FND_API.to_Boolean(p_init_msg_list) THEN
1216: FND_MSG_PUB.initialize;
1217: END IF;
1218: -- Initialize API return status to SUCCESS
1219: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1219: x_return_status := FND_API.G_RET_STS_SUCCESS;

1215: IF FND_API.to_Boolean(p_init_msg_list) THEN
1216: FND_MSG_PUB.initialize;
1217: END IF;
1218: -- Initialize API return status to SUCCESS
1219: x_return_status := FND_API.G_RET_STS_SUCCESS;
1220:
1221: -- Api body
1222: -- get the loan details
1223: -- compare the actual balance to the theoretical balance

Line 1422: IF FND_API.to_Boolean(p_commit) THEN

1418: -- End of API body
1419: -- ---------------------------------------------------------------
1420:
1421: -- Standard check for p_commit
1422: IF FND_API.to_Boolean(p_commit) THEN
1423: COMMIT WORK;
1424: END IF;
1425:
1426: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 1430: WHEN FND_API.G_EXC_ERROR THEN

1426: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1427: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
1428:
1429: Exception
1430: WHEN FND_API.G_EXC_ERROR THEN
1431: ROLLBACK TO preProcessInstallment;
1432: x_return_status := FND_API.G_RET_STS_ERROR;
1433: x_msg_count := l_msg_count;
1434: x_msg_data := l_msg_data;

Line 1432: x_return_status := FND_API.G_RET_STS_ERROR;

1428:
1429: Exception
1430: WHEN FND_API.G_EXC_ERROR THEN
1431: ROLLBACK TO preProcessInstallment;
1432: x_return_status := FND_API.G_RET_STS_ERROR;
1433: x_msg_count := l_msg_count;
1434: x_msg_data := l_msg_data;
1435: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1436: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 1438: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1434: x_msg_data := l_msg_data;
1435: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1436: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
1437:
1438: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1439: ROLLBACK TO preProcessInstallment;
1440: x_return_status := FND_API.G_RET_STS_ERROR;
1441: x_msg_count := l_msg_count;
1442: x_msg_data := l_msg_data;

Line 1440: x_return_status := FND_API.G_RET_STS_ERROR;

1436: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
1437:
1438: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1439: ROLLBACK TO preProcessInstallment;
1440: x_return_status := FND_API.G_RET_STS_ERROR;
1441: x_msg_count := l_msg_count;
1442: x_msg_data := l_msg_data;
1443: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1444: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, sqlerrm);

Line 1448: x_return_status := FND_API.G_RET_STS_ERROR;

1444: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, sqlerrm);
1445:
1446: WHEN OTHERS THEN
1447: ROLLBACK TO preProcessInstallment;
1448: x_return_status := FND_API.G_RET_STS_ERROR;
1449: x_msg_count := l_msg_count;
1450: x_msg_data := l_msg_data;
1451: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1452: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 1519: IF FND_API.to_Boolean(p_init_msg_list) THEN

1515: -- Standard Start of API savepoint
1516: SAVEPOINT preProcessOpenInstallment;
1517:
1518: -- Initialize message list IF p_init_msg_list is set to TRUE.
1519: IF FND_API.to_Boolean(p_init_msg_list) THEN
1520: FND_MSG_PUB.initialize;
1521: END IF;
1522:
1523: -- Initialize API return status to SUCCESS

Line 1524: x_return_status := FND_API.G_RET_STS_SUCCESS;

1520: FND_MSG_PUB.initialize;
1521: END IF;
1522:
1523: -- Initialize API return status to SUCCESS
1524: x_return_status := FND_API.G_RET_STS_SUCCESS;
1525:
1526: -- ---------------------------------------------------------------
1527: -- Beginning of API body
1528: --

Line 1544: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1540: ,x_return_status => l_return_Status
1541: ,x_msg_count => l_msg_count
1542: ,x_msg_data => l_msg_data);
1543:
1544: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1545: FND_MESSAGE.SET_NAME('LNS', 'LNS_PROCESS_FEE_ERROR');
1546: FND_MSG_PUB.ADD;
1547: RAISE FND_API.G_EXC_ERROR;
1548: end if;

Line 1547: RAISE FND_API.G_EXC_ERROR;

1543:
1544: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1545: FND_MESSAGE.SET_NAME('LNS', 'LNS_PROCESS_FEE_ERROR');
1546: FND_MSG_PUB.ADD;
1547: RAISE FND_API.G_EXC_ERROR;
1548: end if;
1549:
1550: -- processFees for servicing
1551: x_amortization_rec := l_amortization_rec;

Line 1558: IF FND_API.to_Boolean(p_commit) THEN

1554: -- End of API body
1555: -- ---------------------------------------------------------------
1556:
1557: -- Standard check for p_commit
1558: IF FND_API.to_Boolean(p_commit) THEN
1559: COMMIT WORK;
1560: END IF;
1561:
1562: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 1566: WHEN FND_API.G_EXC_ERROR THEN

1562: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1563: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
1564:
1565: Exception
1566: WHEN FND_API.G_EXC_ERROR THEN
1567: ROLLBACK TO preProcessOpenInstallment;
1568: x_return_status := FND_API.G_RET_STS_ERROR;
1569: x_msg_count := l_msg_count;
1570: x_msg_data := l_msg_data;

Line 1568: x_return_status := FND_API.G_RET_STS_ERROR;

1564:
1565: Exception
1566: WHEN FND_API.G_EXC_ERROR THEN
1567: ROLLBACK TO preProcessOpenInstallment;
1568: x_return_status := FND_API.G_RET_STS_ERROR;
1569: x_msg_count := l_msg_count;
1570: x_msg_data := l_msg_data;
1571: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1572: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 1574: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1570: x_msg_data := l_msg_data;
1571: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1572: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
1573:
1574: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1575: ROLLBACK TO preProcessOpenInstallment;
1576: x_return_status := FND_API.G_RET_STS_ERROR;
1577: x_msg_count := l_msg_count;
1578: x_msg_data := l_msg_data;

Line 1576: x_return_status := FND_API.G_RET_STS_ERROR;

1572: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
1573:
1574: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1575: ROLLBACK TO preProcessOpenInstallment;
1576: x_return_status := FND_API.G_RET_STS_ERROR;
1577: x_msg_count := l_msg_count;
1578: x_msg_data := l_msg_data;
1579: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1580: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, sqlerrm);

Line 1584: x_return_status := FND_API.G_RET_STS_ERROR;

1580: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, sqlerrm);
1581:
1582: WHEN OTHERS THEN
1583: ROLLBACK TO preProcessOpenInstallment;
1584: x_return_status := FND_API.G_RET_STS_ERROR;
1585: x_msg_count := l_msg_count;
1586: x_msg_data := l_msg_data;
1587: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1588: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 1684: IF NOT FND_API.Compatible_API_Call (l_api_version_number, p_api_version,

1680: -- Standard Start of API savepoint
1681: SAVEPOINT getInstallment;
1682:
1683: -- Standard call to check for call compatibility.
1684: IF NOT FND_API.Compatible_API_Call (l_api_version_number, p_api_version,
1685: l_api_name, G_PKG_NAME)
1686: THEN
1687: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1688: END IF;

Line 1687: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1683: -- Standard call to check for call compatibility.
1684: IF NOT FND_API.Compatible_API_Call (l_api_version_number, p_api_version,
1685: l_api_name, G_PKG_NAME)
1686: THEN
1687: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1688: END IF;
1689:
1690: -- Initialize message list IF p_init_msg_list is set to TRUE.
1691: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1691: IF FND_API.to_Boolean(p_init_msg_list) THEN

1687: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1688: END IF;
1689:
1690: -- Initialize message list IF p_init_msg_list is set to TRUE.
1691: IF FND_API.to_Boolean(p_init_msg_list) THEN
1692: FND_MSG_PUB.initialize;
1693: END IF;
1694:
1695: -- Initialize API return status to SUCCESS

Line 1696: x_return_status := FND_API.G_RET_STS_SUCCESS;

1692: FND_MSG_PUB.initialize;
1693: END IF;
1694:
1695: -- Initialize API return status to SUCCESS
1696: x_return_status := FND_API.G_RET_STS_SUCCESS;
1697:
1698: -- --------------------------------------------------------------------
1699: -- Api body
1700: -- --------------------------------------------------------------------

Line 1773: P_INIT_MSG_LIST => FND_API.G_TRUE,

1769: */
1770: -- load custom schedule
1771: LNS_CUSTOM_PUB.loadCustomSchedule(
1772: P_API_VERSION => 1.0,
1773: P_INIT_MSG_LIST => FND_API.G_TRUE,
1774: P_COMMIT => FND_API.G_FALSE,
1775: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
1776: P_LOAN_ID => p_loan_id,
1777: P_BASED_ON_TERMS => 'CURRENT',

Line 1774: P_COMMIT => FND_API.G_FALSE,

1770: -- load custom schedule
1771: LNS_CUSTOM_PUB.loadCustomSchedule(
1772: P_API_VERSION => 1.0,
1773: P_INIT_MSG_LIST => FND_API.G_TRUE,
1774: P_COMMIT => FND_API.G_FALSE,
1775: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
1776: P_LOAN_ID => p_loan_id,
1777: P_BASED_ON_TERMS => 'CURRENT',
1778: X_AMORT_METHOD => l_AMORT_METHOD,

Line 1775: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,

1771: LNS_CUSTOM_PUB.loadCustomSchedule(
1772: P_API_VERSION => 1.0,
1773: P_INIT_MSG_LIST => FND_API.G_TRUE,
1774: P_COMMIT => FND_API.G_FALSE,
1775: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
1776: P_LOAN_ID => p_loan_id,
1777: P_BASED_ON_TERMS => 'CURRENT',
1778: X_AMORT_METHOD => l_AMORT_METHOD,
1779: X_CUSTOM_TBL => l_custom_tbl,

Line 1785: RAISE FND_API.G_EXC_ERROR;

1781: x_msg_count => l_msg_count,
1782: x_msg_data => l_msg_data);
1783:
1784: IF l_return_status <> 'S' THEN
1785: RAISE FND_API.G_EXC_ERROR;
1786: END IF;
1787:
1788: for p in 1..l_custom_tbl.count loop
1789:

Line 1840: lns_fee_engine.processFees(p_init_msg_list => FND_API.G_FALSE

1836: l_fee_basis_tbl(4).fee_basis_name := 'OVERDUE_PRIN_INT';
1837: -- l_fee_basis_tbl(4).fee_basis_amount := l_amortization_rec.principal_amount + l_amortization_rec.interest_amount;
1838: l_fee_basis_tbl(4).fee_basis_amount := l_amortization_rec.UNPAID_PRIN + l_amortization_rec.UNPAID_INT;
1839:
1840: lns_fee_engine.processFees(p_init_msg_list => FND_API.G_FALSE
1841: ,p_commit => FND_API.G_FALSE
1842: ,p_loan_id => p_loan_id
1843: ,p_installment_number => p_installment_number
1844: ,p_fee_basis_tbl => l_fee_basis_tbl

Line 1841: ,p_commit => FND_API.G_FALSE

1837: -- l_fee_basis_tbl(4).fee_basis_amount := l_amortization_rec.principal_amount + l_amortization_rec.interest_amount;
1838: l_fee_basis_tbl(4).fee_basis_amount := l_amortization_rec.UNPAID_PRIN + l_amortization_rec.UNPAID_INT;
1839:
1840: lns_fee_engine.processFees(p_init_msg_list => FND_API.G_FALSE
1841: ,p_commit => FND_API.G_FALSE
1842: ,p_loan_id => p_loan_id
1843: ,p_installment_number => p_installment_number
1844: ,p_fee_basis_tbl => l_fee_basis_tbl
1845: ,p_fee_structures => l_fee_structures

Line 1851: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1847: ,x_return_status => l_return_Status
1848: ,x_msg_count => l_msg_count
1849: ,x_msg_data => l_msg_data);
1850:
1851: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1852: FND_MESSAGE.SET_NAME('LNS', 'LNS_PROCESS_FEE_ERROR');
1853: FND_MSG_PUB.ADD;
1854: RAISE FND_API.G_EXC_ERROR;
1855: end if;

Line 1854: RAISE FND_API.G_EXC_ERROR;

1850:
1851: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1852: FND_MESSAGE.SET_NAME('LNS', 'LNS_PROCESS_FEE_ERROR');
1853: FND_MSG_PUB.ADD;
1854: RAISE FND_API.G_EXC_ERROR;
1855: end if;
1856: end if;
1857:
1858: -- 12-21-2004 raverma added for lns.b

Line 1860: lns_fee_engine.getFeeSchedule(p_init_msg_list => FND_API.G_FALSE

1856: end if;
1857:
1858: -- 12-21-2004 raverma added for lns.b
1859: -- only get the dis
1860: lns_fee_engine.getFeeSchedule(p_init_msg_list => FND_API.G_FALSE
1861: ,p_loan_id => p_loan_id
1862: ,p_installment_number => p_installment_number
1863: ,p_disb_header_id => null
1864: ,x_fees_tbl => l_fees_tbl_1

Line 1869: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1865: ,x_return_status => l_return_status
1866: ,x_msg_count => l_msg_count
1867: ,x_msg_data => l_msg_data);
1868:
1869: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1870: FND_MESSAGE.SET_NAME('LNS', 'LNS_READ_FEE_ERROR');
1871: FND_MSG_PUB.ADD;
1872: RAISE FND_API.G_EXC_ERROR;
1873: end if;

Line 1872: RAISE FND_API.G_EXC_ERROR;

1868:
1869: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1870: FND_MESSAGE.SET_NAME('LNS', 'LNS_READ_FEE_ERROR');
1871: FND_MSG_PUB.ADD;
1872: RAISE FND_API.G_EXC_ERROR;
1873: end if;
1874:
1875: for k in 1..l_fees_tbl_1.count loop
1876: l_fees_tbl_2(k).FEE_ID := l_fees_tbl_1(k).FEE_ID;

Line 1898: IF FND_API.to_Boolean(p_commit) THEN

1894: -- End of API body
1895: -- --------------------------------------------------------------------
1896:
1897: -- Standard check for p_commit
1898: IF FND_API.to_Boolean(p_commit) THEN
1899: COMMIT WORK;
1900: END IF;
1901:
1902: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 1906: WHEN FND_API.G_EXC_ERROR THEN

1902: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1903: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
1904:
1905: EXCEPTION
1906: WHEN FND_API.G_EXC_ERROR THEN
1907: ROLLBACK TO getInstallment;
1908: x_return_status := FND_API.G_RET_STS_ERROR;
1909: x_msg_count := l_msg_count;
1910: x_msg_data := l_msg_data;

Line 1908: x_return_status := FND_API.G_RET_STS_ERROR;

1904:
1905: EXCEPTION
1906: WHEN FND_API.G_EXC_ERROR THEN
1907: ROLLBACK TO getInstallment;
1908: x_return_status := FND_API.G_RET_STS_ERROR;
1909: x_msg_count := l_msg_count;
1910: x_msg_data := l_msg_data;
1911: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1912: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 1914: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1910: x_msg_data := l_msg_data;
1911: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1912: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
1913:
1914: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1915: ROLLBACK TO getInstallment;
1916: x_return_status := FND_API.G_RET_STS_ERROR;
1917: x_msg_count := l_msg_count;
1918: x_msg_data := l_msg_data;

Line 1916: x_return_status := FND_API.G_RET_STS_ERROR;

1912: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
1913:
1914: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1915: ROLLBACK TO getInstallment;
1916: x_return_status := FND_API.G_RET_STS_ERROR;
1917: x_msg_count := l_msg_count;
1918: x_msg_data := l_msg_data;
1919: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1920: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 1924: x_return_status := FND_API.G_RET_STS_ERROR;

1920: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
1921:
1922: WHEN OTHERS THEN
1923: ROLLBACK TO getInstallment;
1924: x_return_status := FND_API.G_RET_STS_ERROR;
1925: x_msg_count := l_msg_count;
1926: x_msg_data := l_msg_data;
1927: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1928: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 2107: IF FND_API.to_Boolean(p_init_msg_list) THEN

2103: -- Standard Start of API savepoint
2104: SAVEPOINT getOpenInstallment;
2105:
2106: -- Initialize message list IF p_init_msg_list is set to TRUE.
2107: IF FND_API.to_Boolean(p_init_msg_list) THEN
2108: FND_MSG_PUB.initialize;
2109: END IF;
2110:
2111: -- Initialize API return status to SUCCESS

Line 2112: x_return_status := FND_API.G_RET_STS_SUCCESS;

2108: FND_MSG_PUB.initialize;
2109: END IF;
2110:
2111: -- Initialize API return status to SUCCESS
2112: x_return_status := FND_API.G_RET_STS_SUCCESS;
2113:
2114: -- --------------------------------------------------------------------
2115: -- Api body
2116: -- --------------------------------------------------------------------

Line 2152: RAISE FND_API.G_EXC_ERROR;

2148: exception
2149: when others then
2150: FND_MESSAGE.SET_NAME('LNS', 'LNS_COMPUTE_BALANCE_ERROR');
2151: FND_MSG_PUB.ADD;
2152: RAISE FND_API.G_EXC_ERROR;
2153:
2154: end;
2155: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_wtd_balance is ' || l_wtd_balance);
2156:

Line 2200: RAISE FND_API.G_EXC_ERROR;

2196: FND_MESSAGE.SET_NAME('LNS', 'LNS_RATES_ERROR');
2197: FND_MSG_PUB.ADD;
2198: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': rates missing for INDEX_ID ' || l_loan_details.OPEN_INDEX_RATE_ID);
2199: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': rates missing for DATE ' || l_loan_details.NEXT_RATE_CHANGE_DATE);
2200: RAISE FND_API.G_EXC_ERROR;
2201: end if;
2202:
2203: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': l_rate_details.ANNUAL_RATE ' || l_rate_details.ANNUAL_RATE );
2204: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': l_rate_details.spread ' || l_rate_details.spread);

Line 2253: lns_fee_engine.getFeeSchedule(p_init_msg_list => FND_API.G_FALSE

2249: l_amortization_rec.principal_amount := l_periodic_principal; /* needed to calculate fees */
2250: l_amortization_rec.interest_amount := l_periodic_interest;
2251:
2252: -- 12-21-2004 raverma added for lns.b
2253: lns_fee_engine.getFeeSchedule(p_init_msg_list => FND_API.G_FALSE
2254: ,p_loan_id => p_loan_id
2255: ,p_installment_number => p_installment_number
2256: ,p_disb_header_id => null
2257: ,x_fees_tbl => l_fees_tbl_1

Line 2262: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

2258: ,x_return_status => l_return_status
2259: ,x_msg_count => l_msg_count
2260: ,x_msg_data => l_msg_data);
2261:
2262: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2263: FND_MESSAGE.SET_NAME('LNS', 'LNS_READ_FEE_ERROR');
2264: FND_MSG_PUB.ADD;
2265: RAISE FND_API.G_EXC_ERROR;
2266: end if;

Line 2265: RAISE FND_API.G_EXC_ERROR;

2261:
2262: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2263: FND_MESSAGE.SET_NAME('LNS', 'LNS_READ_FEE_ERROR');
2264: FND_MSG_PUB.ADD;
2265: RAISE FND_API.G_EXC_ERROR;
2266: end if;
2267:
2268: for k in 1..l_fees_tbl_1.count loop
2269: l_fees_tbl_2(k).FEE_ID := l_fees_tbl_1(k).FEE_ID;

Line 2297: WHEN FND_API.G_EXC_ERROR THEN

2293: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2294: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
2295:
2296: EXCEPTION
2297: WHEN FND_API.G_EXC_ERROR THEN
2298: ROLLBACK TO getOpenInstallment;
2299: x_return_status := FND_API.G_RET_STS_ERROR;
2300: x_msg_count := l_msg_count;
2301: x_msg_data := l_msg_data;

Line 2299: x_return_status := FND_API.G_RET_STS_ERROR;

2295:
2296: EXCEPTION
2297: WHEN FND_API.G_EXC_ERROR THEN
2298: ROLLBACK TO getOpenInstallment;
2299: x_return_status := FND_API.G_RET_STS_ERROR;
2300: x_msg_count := l_msg_count;
2301: x_msg_data := l_msg_data;
2302: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2303: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 2305: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2301: x_msg_data := l_msg_data;
2302: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2303: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
2304:
2305: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2306: ROLLBACK TO getOpenInstallment;
2307: x_return_status := FND_API.G_RET_STS_ERROR;
2308: x_msg_count := l_msg_count;
2309: x_msg_data := l_msg_data;

Line 2307: x_return_status := FND_API.G_RET_STS_ERROR;

2303: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
2304:
2305: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2306: ROLLBACK TO getOpenInstallment;
2307: x_return_status := FND_API.G_RET_STS_ERROR;
2308: x_msg_count := l_msg_count;
2309: x_msg_data := l_msg_data;
2310: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2311: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 2315: x_return_status := FND_API.G_RET_STS_ERROR;

2311: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
2312:
2313: WHEN OTHERS THEN
2314: ROLLBACK TO getOpenInstallment;
2315: x_return_status := FND_API.G_RET_STS_ERROR;
2316: x_msg_count := l_msg_count;
2317: x_msg_data := l_msg_data;
2318: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2319: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 2984: RAISE FND_API.G_EXC_ERROR;

2980: FND_MESSAGE.SET_NAME('LNS', 'LNS_RATES_ERROR');
2981: FND_MSG_PUB.ADD;
2982: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': rates missing for INDEX_ID ' || p_loan_details.TERM_INDEX_RATE_ID);
2983: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': rates missing for DATE ' || p_loan_details.NEXT_RATE_CHANGE_DATE);
2984: RAISE FND_API.G_EXC_ERROR;
2985: end if;
2986:
2987: -- add the spread into the rate
2988: l_raw_rate := l_rate_details.ANNUAL_RATE + l_rate_details.spread;

Line 3480: WHEN FND_API.G_EXC_ERROR THEN

3476:
3477: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
3478:
3479: Exception
3480: WHEN FND_API.G_EXC_ERROR THEN
3481: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
3482:
3483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3484: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, sqlerrm);

Line 3483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3479: Exception
3480: WHEN FND_API.G_EXC_ERROR THEN
3481: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
3482:
3483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3484: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, sqlerrm);
3485:
3486: WHEN OTHERS THEN
3487: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 4076: RAISE FND_API.G_EXC_ERROR;

4072: FND_MESSAGE.SET_NAME('LNS', 'LNS_RATES_ERROR');
4073: FND_MSG_PUB.ADD;
4074: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': rates missing for INDEX_ID ' || p_loan_details.TERM_INDEX_RATE_ID);
4075: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': rates missing for DATE ' || p_loan_details.NEXT_RATE_CHANGE_DATE);
4076: RAISE FND_API.G_EXC_ERROR;
4077: end if;
4078:
4079: -- add the spread into the rate
4080: l_raw_rate := l_rate_details.ANNUAL_RATE + l_rate_details.spread;

Line 4483: WHEN FND_API.G_EXC_ERROR THEN

4479:
4480: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
4481:
4482: Exception
4483: WHEN FND_API.G_EXC_ERROR THEN
4484: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
4485:
4486: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4487: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, sqlerrm);

Line 4486: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4482: Exception
4483: WHEN FND_API.G_EXC_ERROR THEN
4484: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
4485:
4486: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4487: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, sqlerrm);
4488:
4489: WHEN OTHERS THEN
4490: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 5090: RAISE FND_API.G_EXC_ERROR;

5086: FND_MESSAGE.SET_NAME('LNS', 'LNS_RATES_ERROR');
5087: FND_MSG_PUB.ADD;
5088: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': rates missing for INDEX_ID ' || p_loan_details.TERM_INDEX_RATE_ID);
5089: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': rates missing for DATE ' || p_loan_details.NEXT_RATE_CHANGE_DATE);
5090: RAISE FND_API.G_EXC_ERROR;
5091: end if;
5092:
5093: -- add the spread into the rate
5094: l_raw_rate := l_rate_details.ANNUAL_RATE + l_rate_details.spread;

Line 5540: WHEN FND_API.G_EXC_ERROR THEN

5536:
5537: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
5538:
5539: Exception
5540: WHEN FND_API.G_EXC_ERROR THEN
5541: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
5542:
5543: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5544: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, sqlerrm);

Line 5543: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5539: Exception
5540: WHEN FND_API.G_EXC_ERROR THEN
5541: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
5542:
5543: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5544: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, sqlerrm);
5545:
5546: WHEN OTHERS THEN
5547: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 5842: RAISE FND_API.G_EXC_ERROR;

5838: when others then
5839: FND_MESSAGE.SET_NAME('LNS', 'LNS_COMPUTE_BALANCE_ERROR');
5840: FND_MSG_PUB.ADD;
5841: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - ERROR COMPUTING BALANCE');
5842: RAISE FND_API.G_EXC_ERROR;
5843: end;
5844:
5845: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_wtd_balance is ' || l_wtd_balance);
5846:

Line 5972: WHEN FND_API.G_EXC_ERROR THEN

5968:
5969: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
5970:
5971: Exception
5972: WHEN FND_API.G_EXC_ERROR THEN
5973: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
5974:
5975: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5976: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, sqlerrm);

Line 5975: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5971: Exception
5972: WHEN FND_API.G_EXC_ERROR THEN
5973: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
5974:
5975: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5976: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, sqlerrm);
5977:
5978: WHEN OTHERS THEN
5979: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 6091: IF FND_API.to_Boolean( p_init_msg_list ) THEN

6087:
6088: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
6089:
6090: -- Initialize message list IF p_init_msg_list is set to TRUE.
6091: IF FND_API.to_Boolean( p_init_msg_list ) THEN
6092: FND_MSG_PUB.initialize;
6093: END IF;
6094:
6095: -- Initialize API return status to SUCCESS

Line 6096: x_return_status := FND_API.G_RET_STS_SUCCESS;

6092: FND_MSG_PUB.initialize;
6093: END IF;
6094:
6095: -- Initialize API return status to SUCCESS
6096: x_return_status := FND_API.G_RET_STS_SUCCESS;
6097:
6098: --
6099: -- Api body
6100: -- ----------------------------------------------------------------

Line 6111: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

6107: ,p_col_id => p_loan_id
6108: ,p_col_name => 'LOAN_ID'
6109: ,p_table_name => 'LNS_LOAN_HEADERS_ALL');
6110:
6111: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
6112: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
6113: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
6114: FND_MESSAGE.SET_TOKEN('VALUE', p_loan_ID);
6115: FND_MSG_PUB.ADD;

Line 6116: RAISE FND_API.G_EXC_ERROR;

6112: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
6113: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
6114: FND_MESSAGE.SET_TOKEN('VALUE', p_loan_ID);
6115: FND_MSG_PUB.ADD;
6116: RAISE FND_API.G_EXC_ERROR;
6117: end if;
6118:
6119: -- check if disbursements exist and is amount > 0 as per karthik instructions
6120: open c_disbursements(p_loan_id);

Line 6132: RAISE FND_API.G_EXC_ERROR;

6128:
6129: if l_invalid_disb > 0 then
6130: FND_MESSAGE.SET_NAME('LNS', 'LNS_DISB_REQ_DATE_ERR');
6131: FND_MSG_PUB.ADD;
6132: RAISE FND_API.G_EXC_ERROR;
6133: end if;
6134:
6135: if l_disb_amount > 0 then
6136: l_rate_tbl := lns_financials.getRateSchedule(p_loan_id, 'OPEN');

Line 6207: WHEN FND_API.G_EXC_ERROR THEN

6203:
6204: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
6205:
6206: EXCEPTION
6207: WHEN FND_API.G_EXC_ERROR THEN
6208: ROLLBACK TO runLoanProjection_PVT;
6209: x_return_status := FND_API.G_RET_STS_ERROR;
6210: x_msg_count := l_msg_count;
6211: x_msg_data := l_msg_data;

Line 6209: x_return_status := FND_API.G_RET_STS_ERROR;

6205:
6206: EXCEPTION
6207: WHEN FND_API.G_EXC_ERROR THEN
6208: ROLLBACK TO runLoanProjection_PVT;
6209: x_return_status := FND_API.G_RET_STS_ERROR;
6210: x_msg_count := l_msg_count;
6211: x_msg_data := l_msg_data;
6212: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
6213: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 6215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6211: x_msg_data := l_msg_data;
6212: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
6213: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
6214:
6215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6216: ROLLBACK TO runLoanProjection_PVT;
6217: x_return_status := FND_API.G_RET_STS_ERROR;
6218: x_msg_count := l_msg_count;
6219: x_msg_data := l_msg_data;

Line 6217: x_return_status := FND_API.G_RET_STS_ERROR;

6213: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
6214:
6215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6216: ROLLBACK TO runLoanProjection_PVT;
6217: x_return_status := FND_API.G_RET_STS_ERROR;
6218: x_msg_count := l_msg_count;
6219: x_msg_data := l_msg_data;
6220: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
6221: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 6225: x_return_status := FND_API.G_RET_STS_ERROR;

6221: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
6222:
6223: WHEN OTHERS THEN
6224: ROLLBACK TO runLoanProjection_PVT;
6225: x_return_status := FND_API.G_RET_STS_ERROR;
6226: x_msg_count := l_msg_count;
6227: x_msg_data := l_msg_data;
6228: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
6229: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 6341: RAISE FND_API.G_EXC_ERROR;

6337: Exception
6338: When No_Data_Found then
6339: FND_MESSAGE.Set_Name('LNS', 'LNS_NO_RATES');
6340: FND_MSG_PUB.Add;
6341: RAISE FND_API.G_EXC_ERROR;
6342: End;
6343:
6344: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
6345:

Line 6349: WHEN FND_API.G_EXC_ERROR THEN

6345:
6346: return l_rate_tbl;
6347:
6348: Exception
6349: WHEN FND_API.G_EXC_ERROR THEN
6350: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
6351:
6352: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6353: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, sqlerrm);

Line 6352: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6348: Exception
6349: WHEN FND_API.G_EXC_ERROR THEN
6350: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
6351:
6352: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6353: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, sqlerrm);
6354:
6355: WHEN OTHERS THEN
6356: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 7300: RAISE FND_API.G_EXC_ERROR;

7296: When No_Data_Found then
7297: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - LOAN ID: ' || l_loan_id || ' not found');
7298: FND_MESSAGE.Set_Name('LNS', 'LNS_INVALID_LOAN_ID');
7299: FND_MSG_PUB.Add;
7300: RAISE FND_API.G_EXC_ERROR;
7301:
7302: When Others then
7303: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || 'Err: ' || sqlerrm);
7304: RAISE FND_API.G_EXC_ERROR;

Line 7304: RAISE FND_API.G_EXC_ERROR;

7300: RAISE FND_API.G_EXC_ERROR;
7301:
7302: When Others then
7303: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || 'Err: ' || sqlerrm);
7304: RAISE FND_API.G_EXC_ERROR;
7305:
7306: end getLoanDetails;
7307:
7308:

Line 7417: x_return_status := FND_API.G_RET_STS_SUCCESS;

7413: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
7414: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_loan_id ' || p_loan_id);
7415:
7416: -- Initialize API return status to SUCCESS
7417: x_return_status := FND_API.G_RET_STS_SUCCESS;
7418:
7419: --
7420: -- Api body
7421: -- -----------------------------------------------------------------

Line 7515: ,p_init_msg_list => fnd_api.g_false

7511: l_term_rec.NEXT_PAYMENT_DUE_DATE := l_loan_details.first_payment_Date;
7512: l_loan_header_rec.loan_maturity_date := l_loan_details.maturity_date;
7513: l_loan_header_rec.loan_start_date := l_loan_details.loan_start_date;
7514: lns_terms_pub.update_term(p_object_version_number => l_terms_version_number
7515: ,p_init_msg_list => fnd_api.g_false
7516: ,p_loan_term_rec => l_term_rec
7517: ,x_return_status => l_return_status
7518: ,x_msg_count => l_msg_count
7519: ,x_msg_data => l_msg_data);

Line 7531: ,p_init_msg_list => fnd_api.g_false

7527: l_loan_header_rec.open_loan_term_period := l_new_frequency;
7528:
7529: lns_loan_header_pub.update_loan(p_object_version_number => l_version_number
7530: ,p_loan_header_rec => l_loan_header_rec
7531: ,p_init_msg_list => fnd_api.g_false
7532: ,x_return_status => l_return_status
7533: ,x_msg_count => l_msg_count
7534: ,x_msg_data => l_msg_data);
7535: elsif l_current_phase = 'TERM' then

Line 7544: ,p_init_msg_list => fnd_api.g_false

7540: l_loan_header_rec.loan_term_period := l_new_frequency;
7541:
7542: lns_loan_header_pub.update_loan(p_object_version_number => l_version_number
7543: ,p_loan_header_rec => l_loan_header_rec
7544: ,p_init_msg_list => fnd_api.g_false
7545: ,x_return_status => l_return_status
7546: ,x_msg_count => l_msg_count
7547: ,x_msg_data => l_msg_data);
7548:

Line 7561: IF FND_API.to_Boolean(p_commit) THEN

7557: -- End of API body
7558: -- ----------------------------------------------------------------
7559: --
7560: -- Standard check for p_commit
7561: IF FND_API.to_Boolean(p_commit) THEN
7562: COMMIT WORK;
7563: END IF;
7564:
7565:

Line 7571: WHEN FND_API.G_EXC_ERROR THEN

7567:
7568: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
7569:
7570: EXCEPTION
7571: WHEN FND_API.G_EXC_ERROR THEN
7572: ROLLBACK TO shiftLoan;
7573: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
7574: x_return_status := FND_API.G_RET_STS_ERROR;
7575: x_msg_count := l_msg_count;

Line 7574: x_return_status := FND_API.G_RET_STS_ERROR;

7570: EXCEPTION
7571: WHEN FND_API.G_EXC_ERROR THEN
7572: ROLLBACK TO shiftLoan;
7573: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
7574: x_return_status := FND_API.G_RET_STS_ERROR;
7575: x_msg_count := l_msg_count;
7576: x_msg_data := l_msg_data;
7577: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
7578:

Line 7579: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

7575: x_msg_count := l_msg_count;
7576: x_msg_data := l_msg_data;
7577: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
7578:
7579: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7580: ROLLBACK TO shiftLoan;
7581: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
7582: x_return_status := FND_API.G_RET_STS_ERROR;
7583: x_msg_count := l_msg_count;

Line 7582: x_return_status := FND_API.G_RET_STS_ERROR;

7578:
7579: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7580: ROLLBACK TO shiftLoan;
7581: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
7582: x_return_status := FND_API.G_RET_STS_ERROR;
7583: x_msg_count := l_msg_count;
7584: x_msg_data := l_msg_data;
7585: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
7586:

Line 7590: x_return_status := FND_API.G_RET_STS_ERROR;

7586:
7587: WHEN OTHERS THEN
7588: ROLLBACK TO shiftLoan;
7589: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
7590: x_return_status := FND_API.G_RET_STS_ERROR;
7591: x_msg_count := l_msg_count;
7592: x_msg_data := l_msg_data;
7593: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
7594:

Line 7657: x_return_status := FND_API.G_RET_STS_SUCCESS;

7653: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_new_start_date ' || p_new_start_date);
7654: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_phase ' || p_phase);
7655:
7656: -- Initialize API return status to SUCCESS
7657: x_return_status := FND_API.G_RET_STS_SUCCESS;
7658: x_dates_shifted_flag := 'N';
7659:
7660: --
7661: -- Api body

Line 7672: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

7668: ,p_col_id => p_loan_id
7669: ,p_col_name => 'LOAN_ID'
7670: ,p_table_name => 'LNS_LOAN_HEADERS_ALL');
7671:
7672: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
7673: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
7674: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
7675: FND_MESSAGE.SET_TOKEN('VALUE', p_loan_ID);
7676: FND_MSG_PUB.ADD;

Line 7677: RAISE FND_API.G_EXC_ERROR;

7673: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
7674: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
7675: FND_MESSAGE.SET_TOKEN('VALUE', p_loan_ID);
7676: FND_MSG_PUB.ADD;
7677: RAISE FND_API.G_EXC_ERROR;
7678: end if;
7679:
7680: l_loan_details := lns_financials.getLoanDetails(p_loan_id => p_loan_id
7681: ,p_based_on_terms => 'ORIGINAL'

Line 7745: WHEN FND_API.G_EXC_ERROR THEN

7741:
7742: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
7743:
7744: EXCEPTION
7745: WHEN FND_API.G_EXC_ERROR THEN
7746: ROLLBACK TO shiftLoanDates;
7747: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
7748: x_return_status := FND_API.G_RET_STS_ERROR;
7749: x_msg_count := l_msg_count;

Line 7748: x_return_status := FND_API.G_RET_STS_ERROR;

7744: EXCEPTION
7745: WHEN FND_API.G_EXC_ERROR THEN
7746: ROLLBACK TO shiftLoanDates;
7747: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
7748: x_return_status := FND_API.G_RET_STS_ERROR;
7749: x_msg_count := l_msg_count;
7750: x_msg_data := l_msg_data;
7751: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
7752:

Line 7753: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

7749: x_msg_count := l_msg_count;
7750: x_msg_data := l_msg_data;
7751: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
7752:
7753: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7754: ROLLBACK TO shiftLoanDates;
7755: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
7756: x_return_status := FND_API.G_RET_STS_ERROR;
7757: x_msg_count := l_msg_count;

Line 7756: x_return_status := FND_API.G_RET_STS_ERROR;

7752:
7753: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7754: ROLLBACK TO shiftLoanDates;
7755: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
7756: x_return_status := FND_API.G_RET_STS_ERROR;
7757: x_msg_count := l_msg_count;
7758: x_msg_data := l_msg_data;
7759: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
7760:

Line 7764: x_return_status := FND_API.G_RET_STS_ERROR;

7760:
7761: WHEN OTHERS THEN
7762: ROLLBACK TO shiftLoanDates;
7763: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
7764: x_return_status := FND_API.G_RET_STS_ERROR;
7765: x_msg_count := l_msg_count;
7766: x_msg_data := l_msg_data;
7767: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
7768: end shiftLoanDates;

Line 8089: x_return_status := FND_API.G_RET_STS_SUCCESS;

8085:
8086: begin
8087:
8088: -- Initialize API return status to SUCCESS
8089: x_return_status := FND_API.G_RET_STS_SUCCESS;
8090: l_api_name := 'validatePayoff';
8091: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
8092: --
8093: -- Api body

Line 8101: RAISE FND_API.G_EXC_ERROR;

8097: -- these dates should be further restricted
8098: if p_loan_details.loan_status = 'PAIDOFF' then
8099: FND_MESSAGE.Set_Name('LNS', 'LNS_PAYOFF_ALREADY');
8100: FND_MSG_PUB.Add;
8101: RAISE FND_API.G_EXC_ERROR;
8102:
8103: --karamach --Bug5295446 --Need to prevent payoff for loans in Approved status as well
8104: --elsif p_loan_details.loan_status = 'INCOMPLETE' or p_loan_details.loan_status = 'DELETED' or
8105: -- p_loan_details.loan_status = 'REJECTED' or p_loan_details.loan_status = 'PENDING' then

Line 8109: RAISE FND_API.G_EXC_ERROR;

8105: -- p_loan_details.loan_status = 'REJECTED' or p_loan_details.loan_status = 'PENDING' then
8106: elsif p_loan_details.loan_status IN ('INCOMPLETE','DELETED','REJECTED','PENDING','APPROVED') then
8107: FND_MESSAGE.Set_Name('LNS', 'LNS_INVOICE_SUMMARY_ERROR');
8108: FND_MSG_PUB.Add;
8109: RAISE FND_API.G_EXC_ERROR;
8110: end if;
8111:
8112: if p_payoff_date < p_loan_details.last_interest_accrual then
8113: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - payoff too early');

Line 8117: RAISE FND_API.G_EXC_ERROR;

8113: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - payoff too early');
8114: FND_MESSAGE.Set_Name('LNS', 'LNS_PAYOFF_TOO_EARLY');
8115: FND_MESSAGE.SET_TOKEN('PAYOFF_DATE', fnd_date.date_to_displaydate(p_loan_details.last_interest_accrual));
8116: FND_MSG_PUB.Add;
8117: RAISE FND_API.G_EXC_ERROR;
8118: end if;
8119:
8120: if p_payoff_date < p_loan_details.last_activity_date then
8121: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - payoff too early');

Line 8126: RAISE FND_API.G_EXC_ERROR;

8122: FND_MESSAGE.Set_Name('LNS', 'LNS_PAYOFF_TOO_EARLY2');
8123: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LAST_ACTIVITY_DATE');
8124: FND_MESSAGE.SET_TOKEN('VALUE', fnd_date.date_to_displaydate(p_loan_details.last_activity_date));
8125: FND_MSG_PUB.Add;
8126: RAISE FND_API.G_EXC_ERROR;
8127: end if;
8128:
8129: /* raverma added 12-08-05 */
8130: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - calling LNS_FUNDING_PUB.validate_disb_for_payoff returns ');

Line 8132: ,P_INIT_MSG_LIST => FND_API.G_FALSE

8128:
8129: /* raverma added 12-08-05 */
8130: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - calling LNS_FUNDING_PUB.validate_disb_for_payoff returns ');
8131: LNS_FUNDING_PUB.VALIDATE_DISB_FOR_PAYOFF(P_API_VERSION => 1.0
8132: ,P_INIT_MSG_LIST => FND_API.G_FALSE
8133: ,P_COMMIT => FND_API.G_FALSE
8134: ,P_VALIDATION_LEVEL => 100
8135: ,P_LOAN_ID => p_loan_details.loan_id
8136: ,x_return_status => l_return_status

Line 8133: ,P_COMMIT => FND_API.G_FALSE

8129: /* raverma added 12-08-05 */
8130: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - calling LNS_FUNDING_PUB.validate_disb_for_payoff returns ');
8131: LNS_FUNDING_PUB.VALIDATE_DISB_FOR_PAYOFF(P_API_VERSION => 1.0
8132: ,P_INIT_MSG_LIST => FND_API.G_FALSE
8133: ,P_COMMIT => FND_API.G_FALSE
8134: ,P_VALIDATION_LEVEL => 100
8135: ,P_LOAN_ID => p_loan_details.loan_id
8136: ,x_return_status => l_return_status
8137: ,x_msg_count => l_msg_count

Line 8139: if l_return_Status <> FND_API.G_RET_STS_SUCCESS then

8135: ,P_LOAN_ID => p_loan_details.loan_id
8136: ,x_return_status => l_return_status
8137: ,x_msg_count => l_msg_count
8138: ,x_msg_data => l_msg_data);
8139: if l_return_Status <> FND_API.G_RET_STS_SUCCESS then
8140: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - validate_disb_for_payoff returns ' || l_return_Status);
8141: RAISE FND_API.G_EXC_ERROR;
8142: end if;
8143:

Line 8141: RAISE FND_API.G_EXC_ERROR;

8137: ,x_msg_count => l_msg_count
8138: ,x_msg_data => l_msg_data);
8139: if l_return_Status <> FND_API.G_RET_STS_SUCCESS then
8140: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - validate_disb_for_payoff returns ' || l_return_Status);
8141: RAISE FND_API.G_EXC_ERROR;
8142: end if;
8143:
8144: x_return_status := l_return_Status;
8145: -- --------------------------------------------------------------------

Line 8155: WHEN FND_API.G_EXC_ERROR THEN

8151: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
8152:
8153: exception
8154:
8155: WHEN FND_API.G_EXC_ERROR THEN
8156: x_return_status := FND_API.G_RET_STS_ERROR;
8157: x_msg_count := l_msg_count;
8158: x_msg_data := l_msg_data;
8159: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 8156: x_return_status := FND_API.G_RET_STS_ERROR;

8152:
8153: exception
8154:
8155: WHEN FND_API.G_EXC_ERROR THEN
8156: x_return_status := FND_API.G_RET_STS_ERROR;
8157: x_msg_count := l_msg_count;
8158: x_msg_data := l_msg_data;
8159: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
8160: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 8162: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

8158: x_msg_data := l_msg_data;
8159: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
8160: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
8161:
8162: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8163: x_return_status := FND_API.G_RET_STS_ERROR;
8164: x_msg_count := l_msg_count;
8165: x_msg_data := l_msg_data;
8166: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 8163: x_return_status := FND_API.G_RET_STS_ERROR;

8159: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
8160: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
8161:
8162: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8163: x_return_status := FND_API.G_RET_STS_ERROR;
8164: x_msg_count := l_msg_count;
8165: x_msg_data := l_msg_data;
8166: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
8167: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 8170: x_return_status := FND_API.G_RET_STS_ERROR;

8166: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
8167: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
8168:
8169: WHEN OTHERS THEN
8170: x_return_status := FND_API.G_RET_STS_ERROR;
8171: x_msg_count := l_msg_count;
8172: x_msg_data := l_msg_data;
8173: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
8174: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 8297: IF NOT FND_API.Compatible_API_Call (l_api_version_number, p_api_version,

8293: -- Standard Start of API savepoint
8294: SAVEPOINT calculatePayoff;
8295:
8296: -- Standard call to check for call compatibility.
8297: IF NOT FND_API.Compatible_API_Call (l_api_version_number, p_api_version,
8298: l_api_name, G_PKG_NAME)
8299: THEN
8300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8301: END IF;

Line 8300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8296: -- Standard call to check for call compatibility.
8297: IF NOT FND_API.Compatible_API_Call (l_api_version_number, p_api_version,
8298: l_api_name, G_PKG_NAME)
8299: THEN
8300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8301: END IF;
8302:
8303: -- Initialize message list IF p_init_msg_list is set to TRUE.
8304: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 8304: IF FND_API.to_Boolean(p_init_msg_list) THEN

8300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8301: END IF;
8302:
8303: -- Initialize message list IF p_init_msg_list is set to TRUE.
8304: IF FND_API.to_Boolean(p_init_msg_list) THEN
8305: FND_MSG_PUB.initialize;
8306: END IF;
8307:
8308: -- Initialize API return status to SUCCESS

Line 8309: x_return_status := FND_API.G_RET_STS_SUCCESS;

8305: FND_MSG_PUB.initialize;
8306: END IF;
8307:
8308: -- Initialize API return status to SUCCESS
8309: x_return_status := FND_API.G_RET_STS_SUCCESS;
8310:
8311: --
8312: -- Api body
8313: -- --------------------------------------------------------------------

Line 8333: RAISE FND_API.G_EXC_ERROR;

8329: if l_rate_for_date is null then
8330: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || FND_MSG_PUB.Get(p_encoded => 'F'));
8331: FND_MESSAGE.Set_Name('LNS', 'LNS_INVALID_PAYOFF_DATE');
8332: FND_MSG_PUB.Add;
8333: RAISE FND_API.G_EXC_ERROR;
8334: end if;
8335:
8336: end if;
8337:

Line 8349: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

8345: ,p_payoff_date => p_payoff_date
8346: ,x_return_status => l_return_status
8347: ,x_msg_count => l_msg_count
8348: ,x_msg_data => l_msg_data);
8349: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8350: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || FND_MSG_PUB.Get(p_encoded => 'F'));
8351: RAISE FND_API.G_EXC_ERROR;
8352: END IF;
8353:

Line 8351: RAISE FND_API.G_EXC_ERROR;

8347: ,x_msg_count => l_msg_count
8348: ,x_msg_data => l_msg_data);
8349: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8350: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || FND_MSG_PUB.Get(p_encoded => 'F'));
8351: RAISE FND_API.G_EXC_ERROR;
8352: END IF;
8353:
8354: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - processing late fees');
8355: lns_fee_engine.processLateFees(p_loan_id => p_loan_id

Line 8534: WHEN FND_API.G_EXC_ERROR THEN

8530:
8531: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
8532:
8533: EXCEPTION
8534: WHEN FND_API.G_EXC_ERROR THEN
8535: ROLLBACK TO calculatePayoff;
8536: x_return_status := FND_API.G_RET_STS_ERROR;
8537: x_msg_count := l_msg_count;
8538: x_msg_data := l_msg_data;

Line 8536: x_return_status := FND_API.G_RET_STS_ERROR;

8532:
8533: EXCEPTION
8534: WHEN FND_API.G_EXC_ERROR THEN
8535: ROLLBACK TO calculatePayoff;
8536: x_return_status := FND_API.G_RET_STS_ERROR;
8537: x_msg_count := l_msg_count;
8538: x_msg_data := l_msg_data;
8539: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
8540: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 8542: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

8538: x_msg_data := l_msg_data;
8539: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
8540: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
8541:
8542: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8543: ROLLBACK TO calculatePayoff;
8544: x_return_status := FND_API.G_RET_STS_ERROR;
8545: x_msg_count := l_msg_count;
8546: x_msg_data := l_msg_data;

Line 8544: x_return_status := FND_API.G_RET_STS_ERROR;

8540: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
8541:
8542: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8543: ROLLBACK TO calculatePayoff;
8544: x_return_status := FND_API.G_RET_STS_ERROR;
8545: x_msg_count := l_msg_count;
8546: x_msg_data := l_msg_data;
8547: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
8548: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 8552: x_return_status := FND_API.G_RET_STS_ERROR;

8548: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
8549:
8550: WHEN OTHERS THEN
8551: ROLLBACK TO calculatePayoff;
8552: x_return_status := FND_API.G_RET_STS_ERROR;
8553: x_msg_count := l_msg_count;
8554: x_msg_data := l_msg_data;
8555: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
8556: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 8585: RAISE FND_API.G_EXC_ERROR;

8581: else
8582: FND_MESSAGE.Set_Name('LNS', 'LNS_INVALID_INTERVAL');
8583: FND_MESSAGE.SET_TOKEN('INTERVAL',p_frequency);
8584: FND_MSG_PUB.Add;
8585: RAISE FND_API.G_EXC_ERROR;
8586: end if;
8587:
8588: return l_ppy;
8589: end;

Line 8913: -- RAISE FND_API.G_EXC_ERROR;

8909: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Error: ' || sqlerrm);
8910: --seed this message
8911: -- FND_MESSAGE.Set_Name('LNS', 'LNS_UNABLE_TO_COMPUTE_BALANCE');
8912: -- FND_MSG_PUB.Add;
8913: -- RAISE FND_API.G_EXC_ERROR;
8914:
8915: end getAnnualRate;
8916:
8917: /*=========================================================================

Line 9194: RAISE FND_API.G_EXC_ERROR;

9190: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Error: ' || sqlerrm);
9191: --seed this message
9192: FND_MESSAGE.Set_Name('LNS', 'LNS_UNABLE_TO_COMPUTE_BALANCE');
9193: FND_MSG_PUB.Add;
9194: RAISE FND_API.G_EXC_ERROR;
9195: */
9196: end getRemainingBalance;
9197:
9198: /*========================================================================

Line 9447: RAISE FND_API.G_EXC_ERROR;

9443: -- validate the from and to Dates
9444: if p_from_date > p_to_date then
9445: FND_MESSAGE.Set_Name('LNS', 'LNS_INVALID_ACTIVE_DATE');
9446: FND_MSG_PUB.Add;
9447: RAISE FND_API.G_EXC_ERROR;
9448: end if;
9449: /*
9450: l_loan_details := lns_financials.getLoanDetails(p_loan_id => p_loan_id
9451: ,p_based_on_terms => 'CURRENT'

Line 9458: RAISE FND_API.G_EXC_ERROR;

9454: -- validate if dates are within the boundaries of loan_start and maturity_dates
9455: if p_to_date > l_loan_details.maturity_date then
9456: FND_MESSAGE.Set_Name('LNS', 'LNS_PAYMENT_START_DATE_ERROR1');
9457: FND_MSG_PUB.Add;
9458: RAISE FND_API.G_EXC_ERROR;
9459: end if;
9460:
9461: if p_from_date < l_loan_details.loan_start_date then
9462: FND_MESSAGE.Set_Name('LNS', 'LNS_PAYMENT_START_DATE_ERROR2');

Line 9464: RAISE FND_API.G_EXC_ERROR;

9460:
9461: if p_from_date < l_loan_details.loan_start_date then
9462: FND_MESSAGE.Set_Name('LNS', 'LNS_PAYMENT_START_DATE_ERROR2');
9463: FND_MSG_PUB.Add;
9464: RAISE FND_API.G_EXC_ERROR;
9465: end if;
9466: */
9467: l_loan_activities(1).ending_balance := 0;
9468:

Line 9653: RAISE FND_API.G_EXC_ERROR;

9649: -- validate the from and to Dates
9650: if p_from_date > p_to_date then
9651: FND_MESSAGE.Set_Name('LNS', 'LNS_INVALID_ACTIVE_DATE');
9652: FND_MSG_PUB.Add;
9653: RAISE FND_API.G_EXC_ERROR;
9654: end if;
9655:
9656: OPEN c_loan_phase(p_loan_id);
9657: FETCH c_loan_phase INTO l_loan_phase;

Line 9670: RAISE FND_API.G_EXC_ERROR;

9666: -- validate if dates are within the boundaries of loan_start and maturity_dates
9667: if p_to_date > l_loan_details.maturity_date then
9668: FND_MESSAGE.Set_Name('LNS', 'LNS_PAYMENT_START_DATE_ERROR1');
9669: FND_MSG_PUB.Add;
9670: RAISE FND_API.G_EXC_ERROR;
9671: end if;
9672:
9673: if p_from_date < l_loan_details.loan_start_date then
9674: FND_MESSAGE.Set_Name('LNS', 'LNS_PAYMENT_START_DATE_ERROR2');

Line 9676: RAISE FND_API.G_EXC_ERROR;

9672:
9673: if p_from_date < l_loan_details.loan_start_date then
9674: FND_MESSAGE.Set_Name('LNS', 'LNS_PAYMENT_START_DATE_ERROR2');
9675: FND_MSG_PUB.Add;
9676: RAISE FND_API.G_EXC_ERROR;
9677: end if;
9678:
9679: -- get all the balance activities on the loan
9680: OPEN c_balance_history(p_loan_id);