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_CUSTOM_PUB dependencies on FND_MESSAGE

Line 141: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');

137: ,p_col_name => 'LOAN_ID'
138: ,p_table_name => 'LNS_LOAN_HEADERS_ALL');
139:
140: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
141: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
142: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
143: FND_MESSAGE.SET_TOKEN('VALUE', p_loan_ID);
144: FND_MSG_PUB.ADD;
145: RAISE FND_API.G_EXC_ERROR;

Line 142: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');

138: ,p_table_name => 'LNS_LOAN_HEADERS_ALL');
139:
140: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
141: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
142: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
143: FND_MESSAGE.SET_TOKEN('VALUE', p_loan_ID);
144: FND_MSG_PUB.ADD;
145: RAISE FND_API.G_EXC_ERROR;
146: end if;

Line 143: FND_MESSAGE.SET_TOKEN('VALUE', p_loan_ID);

139:
140: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
141: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
142: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
143: FND_MESSAGE.SET_TOKEN('VALUE', p_loan_ID);
144: FND_MSG_PUB.ADD;
145: RAISE FND_API.G_EXC_ERROR;
146: end if;
147:

Line 157: FND_MESSAGE.Set_Name('LNS', 'LNS_NOT_CUSTOMIZED');

153:
154: if l_customized = 'N' then
155: l_skip_update := true;
156: /* dont raise this error as per karamach conversation 12-1-2004
157: FND_MESSAGE.Set_Name('LNS', 'LNS_NOT_CUSTOMIZED');
158: FND_MSG_PUB.Add;
159: RAISE FND_API.G_EXC_ERROR;
160: */
161: else

Line 170: FND_MESSAGE.Set_Name('LNS', 'LNS_LOAN_ALREADY_BILLED');

166: l_last_installment_billed := LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_loan_id);
167: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - last installment ' || l_last_installment_billed);
168:
169: if l_last_installment_billed > 0 then
170: FND_MESSAGE.Set_Name('LNS', 'LNS_LOAN_ALREADY_BILLED');
171: FND_MSG_PUB.Add;
172: RAISE FND_API.G_EXC_ERROR;
173: end if;
174:

Line 355: FND_MESSAGE.Set_Name('LNS', 'LNS_INVALID_INSTALLMENT');

351:
352: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
353: if l_installment is not null then
354: X_INVALID_INSTALLMENT_NUM := l_installment;
355: FND_MESSAGE.Set_Name('LNS', 'LNS_INVALID_INSTALLMENT');
356: FND_MESSAGE.SET_TOKEN('PARAMETER', 'INSTALLMENT');
357: FND_MESSAGE.SET_TOKEN('VALUE', l_installment);
358: FND_MSG_PUB.Add;
359: RAISE FND_API.G_EXC_ERROR;

Line 356: FND_MESSAGE.SET_TOKEN('PARAMETER', 'INSTALLMENT');

352: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
353: if l_installment is not null then
354: X_INVALID_INSTALLMENT_NUM := l_installment;
355: FND_MESSAGE.Set_Name('LNS', 'LNS_INVALID_INSTALLMENT');
356: FND_MESSAGE.SET_TOKEN('PARAMETER', 'INSTALLMENT');
357: FND_MESSAGE.SET_TOKEN('VALUE', l_installment);
358: FND_MSG_PUB.Add;
359: RAISE FND_API.G_EXC_ERROR;
360: end if;

Line 357: FND_MESSAGE.SET_TOKEN('VALUE', l_installment);

353: if l_installment is not null then
354: X_INVALID_INSTALLMENT_NUM := l_installment;
355: FND_MESSAGE.Set_Name('LNS', 'LNS_INVALID_INSTALLMENT');
356: FND_MESSAGE.SET_TOKEN('PARAMETER', 'INSTALLMENT');
357: FND_MESSAGE.SET_TOKEN('VALUE', l_installment);
358: FND_MSG_PUB.Add;
359: RAISE FND_API.G_EXC_ERROR;
360: end if;
361: FND_MESSAGE.Set_Name('LNS', 'LNS_VALIDATE_CUSTOM_ERROR');

Line 361: FND_MESSAGE.Set_Name('LNS', 'LNS_VALIDATE_CUSTOM_ERROR');

357: FND_MESSAGE.SET_TOKEN('VALUE', l_installment);
358: FND_MSG_PUB.Add;
359: RAISE FND_API.G_EXC_ERROR;
360: end if;
361: FND_MESSAGE.Set_Name('LNS', 'LNS_VALIDATE_CUSTOM_ERROR');
362: FND_MSG_PUB.Add;
363: RAISE FND_API.G_EXC_ERROR;
364: end if;
365:

Line 521: FND_MESSAGE.Set_Name('LNS', 'LNS_HEADER_UPDATE_ERROR');

517: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - header update set custom = Y');
518:
519: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
520: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - header update ERROR');
521: FND_MESSAGE.Set_Name('LNS', 'LNS_HEADER_UPDATE_ERROR');
522: FND_MSG_PUB.Add;
523: RAISE FND_API.G_EXC_ERROR;
524: end if;
525:

Line 538: FND_MESSAGE.Set_Name('LNS', 'LNS_CREATE_CUSTOM_ERROR');

534: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
535:
536: EXCEPTION
537: WHEN FND_API.G_EXC_ERROR THEN
538: FND_MESSAGE.Set_Name('LNS', 'LNS_CREATE_CUSTOM_ERROR');
539: FND_MSG_PUB.Add;
540: x_return_status := FND_API.G_RET_STS_ERROR;
541: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
542: ROLLBACK TO createCustomSchedule;

Line 545: FND_MESSAGE.Set_Name('LNS', 'LNS_CREATE_CUSTOM_ERROR');

541: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
542: ROLLBACK TO createCustomSchedule;
543:
544: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
545: FND_MESSAGE.Set_Name('LNS', 'LNS_CREATE_CUSTOM_ERROR');
546: FND_MSG_PUB.Add;
547: x_return_status := FND_API.G_RET_STS_ERROR;
548: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
549: ROLLBACK TO createCustomSchedule;

Line 552: FND_MESSAGE.Set_Name('LNS', 'LNS_CREATE_CUSTOM_ERROR');

548: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
549: ROLLBACK TO createCustomSchedule;
550:
551: WHEN OTHERS THEN
552: FND_MESSAGE.Set_Name('LNS', 'LNS_CREATE_CUSTOM_ERROR');
553: FND_MSG_PUB.Add;
554: x_return_status := FND_API.G_RET_STS_ERROR;
555: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
556: ROLLBACK TO createCustomSchedule;

Line 682: FND_MESSAGE.Set_Name('LNS', 'LNS_INVALID_INSTALLMENT');

678:
679: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
680: if l_installment is not null then
681: X_INVALID_INSTALLMENT_NUM := l_installment;
682: FND_MESSAGE.Set_Name('LNS', 'LNS_INVALID_INSTALLMENT');
683: FND_MESSAGE.SET_TOKEN('PARAMETER', 'INSTALLMENT');
684: FND_MESSAGE.SET_TOKEN('VALUE', l_installment);
685: FND_MSG_PUB.Add;
686: RAISE FND_API.G_EXC_ERROR;

Line 683: FND_MESSAGE.SET_TOKEN('PARAMETER', 'INSTALLMENT');

679: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
680: if l_installment is not null then
681: X_INVALID_INSTALLMENT_NUM := l_installment;
682: FND_MESSAGE.Set_Name('LNS', 'LNS_INVALID_INSTALLMENT');
683: FND_MESSAGE.SET_TOKEN('PARAMETER', 'INSTALLMENT');
684: FND_MESSAGE.SET_TOKEN('VALUE', l_installment);
685: FND_MSG_PUB.Add;
686: RAISE FND_API.G_EXC_ERROR;
687: end if;

Line 684: FND_MESSAGE.SET_TOKEN('VALUE', l_installment);

680: if l_installment is not null then
681: X_INVALID_INSTALLMENT_NUM := l_installment;
682: FND_MESSAGE.Set_Name('LNS', 'LNS_INVALID_INSTALLMENT');
683: FND_MESSAGE.SET_TOKEN('PARAMETER', 'INSTALLMENT');
684: FND_MESSAGE.SET_TOKEN('VALUE', l_installment);
685: FND_MSG_PUB.Add;
686: RAISE FND_API.G_EXC_ERROR;
687: end if;
688: FND_MESSAGE.Set_Name('LNS', 'LNS_VALIDATE_CUSTOM_ERROR');

Line 688: FND_MESSAGE.Set_Name('LNS', 'LNS_VALIDATE_CUSTOM_ERROR');

684: FND_MESSAGE.SET_TOKEN('VALUE', l_installment);
685: FND_MSG_PUB.Add;
686: RAISE FND_API.G_EXC_ERROR;
687: end if;
688: FND_MESSAGE.Set_Name('LNS', 'LNS_VALIDATE_CUSTOM_ERROR');
689: FND_MSG_PUB.Add;
690: RAISE FND_API.G_EXC_ERROR;
691: end if;
692:

Line 749: --FND_MESSAGE.Set_Name('LNS', 'LNS_UPDATE_CUSTOM_ERROR');

745: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
746:
747: EXCEPTION
748: WHEN FND_API.G_EXC_ERROR THEN
749: --FND_MESSAGE.Set_Name('LNS', 'LNS_UPDATE_CUSTOM_ERROR');
750: --FND_MSG_PUB.Add;
751: --RAISE FND_API.G_EXC_ERROR;
752: x_return_status := FND_API.G_RET_STS_ERROR;
753: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 757: --FND_MESSAGE.Set_Name('LNS', 'LNS_UPDATE_CUSTOM_ERROR');

753: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
754: ROLLBACK TO updateCustomSchedule;
755:
756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
757: --FND_MESSAGE.Set_Name('LNS', 'LNS_UPDATE_CUSTOM_ERROR');
758: --FND_MSG_PUB.Add;
759: --RAISE FND_API.G_EXC_ERROR;
760: x_return_status := FND_API.G_RET_STS_ERROR;
761: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 765: --FND_MESSAGE.Set_Name('LNS', 'LNS_UPDATE_CUSTOM_ERROR');

761: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
762: ROLLBACK TO updateCustomSchedule;
763:
764: WHEN OTHERS THEN
765: --FND_MESSAGE.Set_Name('LNS', 'LNS_UPDATE_CUSTOM_ERROR');
766: --FND_MSG_PUB.Add;
767: --RAISE FND_API.G_EXC_ERROR;
768: x_return_status := FND_API.G_RET_STS_ERROR;
769: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 836: FND_MESSAGE.Set_Name('LNS', 'LNS_INVALID_NUM_ROWS');

832: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'original installments ' || l_loan_details.number_installments);
833: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'billed installments (without 0) is ' || l_count);
834:
835: if l_loan_details.number_installments - l_count <> l_cust_tbl.count then
836: FND_MESSAGE.Set_Name('LNS', 'LNS_INVALID_NUM_ROWS');
837: FND_MSG_PUB.Add;
838: RAISE FND_API.G_EXC_ERROR;
839: end if;
840: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'passed update validation');

Line 854: FND_MESSAGE.Set_Name('LNS', 'LNS_BEGIN_BALANCE_INCORRECT');

850: -- CHECK THIS WITH KARTHIK
851: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'check balance');
852: if l_cust_tbl(1).installment_begin_balance <> lns_financials.getRemainingBalance(p_loan_id) then
853: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'balance incorrect');
854: FND_MESSAGE.Set_Name('LNS', 'LNS_BEGIN_BALANCE_INCORRECT');
855: FND_MSG_PUB.Add;
856: RAISE FND_API.G_EXC_ERROR;
857: end if;
858: end if;

Line 869: FND_MESSAGE.Set_Name('LNS', 'LNS_INVALID_INSTALLMENT');

865:
866: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
867: x_installment := i;
868: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'invalid installment found #' || i);
869: FND_MESSAGE.Set_Name('LNS', 'LNS_INVALID_INSTALLMENT');
870: FND_MESSAGE.SET_TOKEN('PARAMETER', 'INSTALLMENT');
871: FND_MESSAGE.SET_TOKEN('VALUE', i);
872: FND_MSG_PUB.Add;
873: RAISE FND_API.G_EXC_ERROR;

Line 870: FND_MESSAGE.SET_TOKEN('PARAMETER', 'INSTALLMENT');

866: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
867: x_installment := i;
868: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'invalid installment found #' || i);
869: FND_MESSAGE.Set_Name('LNS', 'LNS_INVALID_INSTALLMENT');
870: FND_MESSAGE.SET_TOKEN('PARAMETER', 'INSTALLMENT');
871: FND_MESSAGE.SET_TOKEN('VALUE', i);
872: FND_MSG_PUB.Add;
873: RAISE FND_API.G_EXC_ERROR;
874: end if;

Line 871: FND_MESSAGE.SET_TOKEN('VALUE', i);

867: x_installment := i;
868: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'invalid installment found #' || i);
869: FND_MESSAGE.Set_Name('LNS', 'LNS_INVALID_INSTALLMENT');
870: FND_MESSAGE.SET_TOKEN('PARAMETER', 'INSTALLMENT');
871: FND_MESSAGE.SET_TOKEN('VALUE', i);
872: FND_MSG_PUB.Add;
873: RAISE FND_API.G_EXC_ERROR;
874: end if;
875:

Line 880: FND_MESSAGE.Set_Name('LNS', 'LNS_NONSEQUENTIAL_INSTALLMENTS');

876: -- check for consecutive installments
877: if l_cust_tbl.exists(i+1) then
878: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'checking consecutive installments' || l_cust_tbl(i).payment_number || ' ' || l_cust_tbl(i+1).payment_number );
879: if l_cust_tbl(i).payment_number + 1 <> l_cust_tbl(i+1).payment_number then
880: FND_MESSAGE.Set_Name('LNS', 'LNS_NONSEQUENTIAL_INSTALLMENTS');
881: FND_MSG_PUB.Add;
882: RAISE FND_API.G_EXC_ERROR;
883: end if;
884: end if;

Line 896: FND_MESSAGE.Set_Name('LNS', 'LNS_NONSEQUENTIAL_DATES');

892:
893: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'PASS: ' || i || 'p_cust_tbl(i).due_date is : ' || l_cust_tbl(i).due_date);
894: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'l_date is: ' || l_date);
895: if p_cust_tbl(i).due_date <= l_date then
896: FND_MESSAGE.Set_Name('LNS', 'LNS_NONSEQUENTIAL_DATES');
897: FND_MSG_PUB.Add;
898: RAISE FND_API.G_EXC_ERROR;
899: end if;
900: l_date := l_cust_tbl(i).due_date;

Line 915: FND_MESSAGE.Set_Name('LNS', 'LNS_BALANCE_INCORRECT');

911: --karamach bug5231822 l_loan_details.unbilled_principal does not return correct value for Direct loan
912: --if l_amount <> l_loan_details.unbilled_principal then
913: if l_amount <> l_loan_details.remaining_balance then
914: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'balance check incorrect');
915: FND_MESSAGE.Set_Name('LNS', 'LNS_BALANCE_INCORRECT');
916: FND_MSG_PUB.Add;
917: RAISE FND_API.G_EXC_ERROR;
918: end if;
919:

Line 928: --FND_MESSAGE.Set_Name('LNS', 'LNS_VALIDATE_CUSTOM_ERROR');

924:
925: EXCEPTION
926:
927: WHEN FND_API.G_EXC_ERROR THEN
928: --FND_MESSAGE.Set_Name('LNS', 'LNS_VALIDATE_CUSTOM_ERROR');
929: --FND_MSG_PUB.Add;
930: x_return_status := FND_API.G_RET_STS_ERROR;
931: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
932:

Line 934: --FND_MESSAGE.Set_Name('LNS', 'LNS_VALIDATE_CUSTOM_ERROR');

930: x_return_status := FND_API.G_RET_STS_ERROR;
931: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
932:
933: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
934: --FND_MESSAGE.Set_Name('LNS', 'LNS_VALIDATE_CUSTOM_ERROR');
935: --FND_MSG_PUB.Add;
936: x_return_status := FND_API.G_RET_STS_ERROR;
937: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
938:

Line 940: --FND_MESSAGE.Set_Name('LNS', 'LNS_VALIDATE_CUSTOM_ERROR');

936: x_return_status := FND_API.G_RET_STS_ERROR;
937: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
938:
939: WHEN OTHERS THEN
940: --FND_MESSAGE.Set_Name('LNS', 'LNS_VALIDATE_CUSTOM_ERROR');
941: --FND_MSG_PUB.Add;
942: x_return_status := FND_API.G_RET_STS_ERROR;
943: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
944: End;

Line 973: FND_MESSAGE.Set_Name('LNS', 'LNS_NO_DUE_DATE');

969: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' ' || p_custom_rec.PRINCIPAL_AMOUNT );
970: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' ' || p_custom_rec.INTEREST_AMOUNT );
971:
972: if p_custom_rec.due_Date is null then
973: FND_MESSAGE.Set_Name('LNS', 'LNS_NO_DUE_DATE');
974: FND_MSG_PUB.Add;
975: RAISE FND_API.G_EXC_ERROR;
976:
977: elsif p_custom_rec.payment_number is null or p_custom_rec.payment_number < 1 then

Line 978: FND_MESSAGE.Set_Name('LNS', 'LNS_INVALID_PAYMENT_NUMBER');

974: FND_MSG_PUB.Add;
975: RAISE FND_API.G_EXC_ERROR;
976:
977: elsif p_custom_rec.payment_number is null or p_custom_rec.payment_number < 1 then
978: FND_MESSAGE.Set_Name('LNS', 'LNS_INVALID_PAYMENT_NUMBER');
979: FND_MSG_PUB.Add;
980: RAISE FND_API.G_EXC_ERROR;
981:
982: elsif p_custom_rec.PRINCIPAL_AMOUNT is not null and p_custom_rec.PRINCIPAL_AMOUNT < 0 then

Line 983: FND_MESSAGE.Set_Name('LNS', 'LNS_PRINICIPAL_AMOUNT_ERROR');

979: FND_MSG_PUB.Add;
980: RAISE FND_API.G_EXC_ERROR;
981:
982: elsif p_custom_rec.PRINCIPAL_AMOUNT is not null and p_custom_rec.PRINCIPAL_AMOUNT < 0 then
983: FND_MESSAGE.Set_Name('LNS', 'LNS_PRINICIPAL_AMOUNT_ERROR');
984: FND_MSG_PUB.Add;
985: RAISE FND_API.G_EXC_ERROR;
986:
987: elsif p_custom_rec.INTEREST_AMOUNT is not null and p_custom_rec.INTEREST_AMOUNT < 0 then

Line 988: FND_MESSAGE.Set_Name('LNS', 'LNS_INTEREST_AMOUNT_ERROR');

984: FND_MSG_PUB.Add;
985: RAISE FND_API.G_EXC_ERROR;
986:
987: elsif p_custom_rec.INTEREST_AMOUNT is not null and p_custom_rec.INTEREST_AMOUNT < 0 then
988: FND_MESSAGE.Set_Name('LNS', 'LNS_INTEREST_AMOUNT_ERROR');
989: FND_MSG_PUB.Add;
990: RAISE FND_API.G_EXC_ERROR;
991:
992: elsif p_custom_rec.FEE_AMOUNT is not null and p_custom_rec.FEE_AMOUNT < 0 then

Line 993: FND_MESSAGE.Set_Name('LNS', 'LNS_OTHER_AMOUNT_ERROR');

989: FND_MSG_PUB.Add;
990: RAISE FND_API.G_EXC_ERROR;
991:
992: elsif p_custom_rec.FEE_AMOUNT is not null and p_custom_rec.FEE_AMOUNT < 0 then
993: FND_MESSAGE.Set_Name('LNS', 'LNS_OTHER_AMOUNT_ERROR');
994: FND_MSG_PUB.Add;
995: RAISE FND_API.G_EXC_ERROR;
996:
997: elsif p_custom_rec.OTHER_AMOUNT is not null and p_custom_rec.OTHER_AMOUNT < 0 then

Line 998: FND_MESSAGE.Set_Name('LNS', 'LNS_OTHER_AMOUNT_ERROR');

994: FND_MSG_PUB.Add;
995: RAISE FND_API.G_EXC_ERROR;
996:
997: elsif p_custom_rec.OTHER_AMOUNT is not null and p_custom_rec.OTHER_AMOUNT < 0 then
998: FND_MESSAGE.Set_Name('LNS', 'LNS_OTHER_AMOUNT_ERROR');
999: FND_MSG_PUB.Add;
1000: RAISE FND_API.G_EXC_ERROR;
1001:
1002: end if;

Line 1177: FND_MESSAGE.SET_NAME('LNS', 'LNS_DUE_DATE_DUPL');

1173: l_custom_tbl(j) := l_custom_tbl(j+1);
1174: l_custom_tbl(j+1) := l_temp;
1175: elsif l_custom_tbl(j).DUE_DATE = l_custom_tbl(j+1).DUE_DATE then
1176: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Several installments have the same due date.');
1177: FND_MESSAGE.SET_NAME('LNS', 'LNS_DUE_DATE_DUPL');
1178: FND_MSG_PUB.Add;
1179: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1180: RAISE FND_API.G_EXC_ERROR;
1181: end if;

Line 1614: FND_MESSAGE.Set_Name('LNS', 'LNS_INVALID_LOAN_ID');

1610:
1611: Exception
1612: When No_Data_Found then
1613: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'LOAN ID: ' || p_loan_id || ' not found');
1614: FND_MESSAGE.Set_Name('LNS', 'LNS_INVALID_LOAN_ID');
1615: FND_MSG_PUB.Add;
1616: RAISE FND_API.G_EXC_ERROR;
1617:
1618: When Others then

Line 1709: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');

1705: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_LOAN_ID: ' || P_LOAN_ID);
1706: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_BASED_ON_TERMS: ' || P_BASED_ON_TERMS);
1707:
1708: if P_LOAN_ID is null then
1709: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
1710: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
1711: FND_MESSAGE.SET_TOKEN('VALUE', P_LOAN_ID);
1712: FND_MSG_PUB.ADD;
1713: RAISE FND_API.G_EXC_ERROR;

Line 1710: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');

1706: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_BASED_ON_TERMS: ' || P_BASED_ON_TERMS);
1707:
1708: if P_LOAN_ID is null then
1709: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
1710: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
1711: FND_MESSAGE.SET_TOKEN('VALUE', P_LOAN_ID);
1712: FND_MSG_PUB.ADD;
1713: RAISE FND_API.G_EXC_ERROR;
1714: end if;

Line 1711: FND_MESSAGE.SET_TOKEN('VALUE', P_LOAN_ID);

1707:
1708: if P_LOAN_ID is null then
1709: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
1710: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
1711: FND_MESSAGE.SET_TOKEN('VALUE', P_LOAN_ID);
1712: FND_MSG_PUB.ADD;
1713: RAISE FND_API.G_EXC_ERROR;
1714: end if;
1715:

Line 1717: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');

1713: RAISE FND_API.G_EXC_ERROR;
1714: end if;
1715:
1716: if P_BASED_ON_TERMS is null then
1717: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
1718: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BASED_ON_TERMS');
1719: FND_MESSAGE.SET_TOKEN('VALUE', P_BASED_ON_TERMS);
1720: FND_MSG_PUB.ADD;
1721: RAISE FND_API.G_EXC_ERROR;

Line 1718: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BASED_ON_TERMS');

1714: end if;
1715:
1716: if P_BASED_ON_TERMS is null then
1717: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
1718: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BASED_ON_TERMS');
1719: FND_MESSAGE.SET_TOKEN('VALUE', P_BASED_ON_TERMS);
1720: FND_MSG_PUB.ADD;
1721: RAISE FND_API.G_EXC_ERROR;
1722: end if;

Line 1719: FND_MESSAGE.SET_TOKEN('VALUE', P_BASED_ON_TERMS);

1715:
1716: if P_BASED_ON_TERMS is null then
1717: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
1718: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BASED_ON_TERMS');
1719: FND_MESSAGE.SET_TOKEN('VALUE', P_BASED_ON_TERMS);
1720: FND_MSG_PUB.ADD;
1721: RAISE FND_API.G_EXC_ERROR;
1722: end if;
1723:

Line 2032: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');

2028: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_BASED_ON_TERMS: ' || P_BASED_ON_TERMS);
2029: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_AMORT_METHOD: ' || P_AMORT_METHOD);
2030:
2031: if P_LOAN_ID is null then
2032: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2033: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
2034: FND_MESSAGE.SET_TOKEN('VALUE', P_LOAN_ID);
2035: FND_MSG_PUB.ADD;
2036: RAISE FND_API.G_EXC_ERROR;

Line 2033: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');

2029: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_AMORT_METHOD: ' || P_AMORT_METHOD);
2030:
2031: if P_LOAN_ID is null then
2032: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2033: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
2034: FND_MESSAGE.SET_TOKEN('VALUE', P_LOAN_ID);
2035: FND_MSG_PUB.ADD;
2036: RAISE FND_API.G_EXC_ERROR;
2037: end if;

Line 2034: FND_MESSAGE.SET_TOKEN('VALUE', P_LOAN_ID);

2030:
2031: if P_LOAN_ID is null then
2032: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2033: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
2034: FND_MESSAGE.SET_TOKEN('VALUE', P_LOAN_ID);
2035: FND_MSG_PUB.ADD;
2036: RAISE FND_API.G_EXC_ERROR;
2037: end if;
2038:

Line 2040: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');

2036: RAISE FND_API.G_EXC_ERROR;
2037: end if;
2038:
2039: if P_BASED_ON_TERMS is null then
2040: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2041: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BASED_ON_TERMS');
2042: FND_MESSAGE.SET_TOKEN('VALUE', P_BASED_ON_TERMS);
2043: FND_MSG_PUB.ADD;
2044: RAISE FND_API.G_EXC_ERROR;

Line 2041: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BASED_ON_TERMS');

2037: end if;
2038:
2039: if P_BASED_ON_TERMS is null then
2040: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2041: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BASED_ON_TERMS');
2042: FND_MESSAGE.SET_TOKEN('VALUE', P_BASED_ON_TERMS);
2043: FND_MSG_PUB.ADD;
2044: RAISE FND_API.G_EXC_ERROR;
2045: end if;

Line 2042: FND_MESSAGE.SET_TOKEN('VALUE', P_BASED_ON_TERMS);

2038:
2039: if P_BASED_ON_TERMS is null then
2040: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2041: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BASED_ON_TERMS');
2042: FND_MESSAGE.SET_TOKEN('VALUE', P_BASED_ON_TERMS);
2043: FND_MSG_PUB.ADD;
2044: RAISE FND_API.G_EXC_ERROR;
2045: end if;
2046:

Line 2048: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');

2044: RAISE FND_API.G_EXC_ERROR;
2045: end if;
2046:
2047: if P_AMORT_METHOD is null then
2048: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2049: FND_MESSAGE.SET_TOKEN('PARAMETER', 'AMORT_METHOD');
2050: FND_MESSAGE.SET_TOKEN('VALUE', P_AMORT_METHOD);
2051: FND_MSG_PUB.ADD;
2052: RAISE FND_API.G_EXC_ERROR;

Line 2049: FND_MESSAGE.SET_TOKEN('PARAMETER', 'AMORT_METHOD');

2045: end if;
2046:
2047: if P_AMORT_METHOD is null then
2048: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2049: FND_MESSAGE.SET_TOKEN('PARAMETER', 'AMORT_METHOD');
2050: FND_MESSAGE.SET_TOKEN('VALUE', P_AMORT_METHOD);
2051: FND_MSG_PUB.ADD;
2052: RAISE FND_API.G_EXC_ERROR;
2053: end if;

Line 2050: FND_MESSAGE.SET_TOKEN('VALUE', P_AMORT_METHOD);

2046:
2047: if P_AMORT_METHOD is null then
2048: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2049: FND_MESSAGE.SET_TOKEN('PARAMETER', 'AMORT_METHOD');
2050: FND_MESSAGE.SET_TOKEN('VALUE', P_AMORT_METHOD);
2051: FND_MSG_PUB.ADD;
2052: RAISE FND_API.G_EXC_ERROR;
2053: end if;
2054:

Line 2086: FND_MESSAGE.SET_NAME('LNS', 'LNS_CUST_AMORT_EMPTY');

2082: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Custom schedule is empty. Returning.');
2083: return;
2084: /*
2085: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Custom amortization is empty.');
2086: FND_MESSAGE.SET_NAME('LNS', 'LNS_CUST_AMORT_EMPTY');
2087: FND_MSG_PUB.Add;
2088: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2089: RAISE FND_API.G_EXC_ERROR;
2090: */

Line 2136: FND_MESSAGE.SET_NAME('LNS', 'LNS_EARLIER_LN_START_DATE');

2132: for i in 1..l_custom_tbl.count loop
2133:
2134: if l_custom_tbl(i).DUE_DATE < l_loan_details.loan_start_date then
2135: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Installment due date cannot be earlier then loan start date.');
2136: FND_MESSAGE.SET_NAME('LNS', 'LNS_EARLIER_LN_START_DATE');
2137: FND_MSG_PUB.Add;
2138: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2139: RAISE FND_API.G_EXC_ERROR;
2140: end if;

Line 2145: FND_MESSAGE.SET_NAME('LNS', 'LNS_EARLIER_LAST_BILLED_DD');

2141:
2142: if l_loan_details.LAST_DUE_DATE is not null then
2143: if l_custom_tbl(i).DUE_DATE <= l_loan_details.LAST_DUE_DATE then
2144: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Installment due date cannot be earlier or equal to due date of the last billed installment.');
2145: FND_MESSAGE.SET_NAME('LNS', 'LNS_EARLIER_LAST_BILLED_DD');
2146: FND_MSG_PUB.Add;
2147: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2148: RAISE FND_API.G_EXC_ERROR;
2149: end if;

Line 2158: FND_MESSAGE.SET_NAME('LNS', 'LNS_LATER_LN_MATUR_DATE');

2154: if i = l_custom_tbl.count then -- fix for bug 6920780: if its last installment and due date is beyond maturity date - set it to maturity date
2155: l_custom_tbl(i).DUE_DATE := l_loan_details.maturity_Date;
2156: else
2157: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Installment due date cannot be later then loan maturity date.');
2158: FND_MESSAGE.SET_NAME('LNS', 'LNS_LATER_LN_MATUR_DATE');
2159: FND_MSG_PUB.Add;
2160: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2161: RAISE FND_API.G_EXC_ERROR;
2162: end if;

Line 2309: FND_MESSAGE.SET_NAME('LNS', 'LNS_RATES_ERROR');

2305: ,l_period_begin_date);
2306:
2307: -- raise error as rates does not exist
2308: if l_rate_details.ANNUAL_RATE is null then
2309: FND_MESSAGE.SET_NAME('LNS', 'LNS_RATES_ERROR');
2310: FND_MSG_PUB.ADD;
2311: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': rates missing for INDEX_ID ' || l_loan_details.TERM_INDEX_RATE_ID);
2312: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': rates missing for DATE ' || l_loan_details.NEXT_RATE_CHANGE_DATE);
2313: RAISE FND_API.G_EXC_ERROR;

Line 2875: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');

2871: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_AMORT_METHOD: ' || P_AMORT_METHOD);
2872: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_BASED_ON_TERMS: ' || P_BASED_ON_TERMS);
2873:
2874: if P_LOAN_ID is null then
2875: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2876: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
2877: FND_MESSAGE.SET_TOKEN('VALUE', P_LOAN_ID);
2878: FND_MSG_PUB.ADD;
2879: RAISE FND_API.G_EXC_ERROR;

Line 2876: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');

2872: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_BASED_ON_TERMS: ' || P_BASED_ON_TERMS);
2873:
2874: if P_LOAN_ID is null then
2875: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2876: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
2877: FND_MESSAGE.SET_TOKEN('VALUE', P_LOAN_ID);
2878: FND_MSG_PUB.ADD;
2879: RAISE FND_API.G_EXC_ERROR;
2880: end if;

Line 2877: FND_MESSAGE.SET_TOKEN('VALUE', P_LOAN_ID);

2873:
2874: if P_LOAN_ID is null then
2875: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2876: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
2877: FND_MESSAGE.SET_TOKEN('VALUE', P_LOAN_ID);
2878: FND_MSG_PUB.ADD;
2879: RAISE FND_API.G_EXC_ERROR;
2880: end if;
2881:

Line 2883: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');

2879: RAISE FND_API.G_EXC_ERROR;
2880: end if;
2881:
2882: if P_BASED_ON_TERMS is null then
2883: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2884: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BASED_ON_TERMS');
2885: FND_MESSAGE.SET_TOKEN('VALUE', P_BASED_ON_TERMS);
2886: FND_MSG_PUB.ADD;
2887: RAISE FND_API.G_EXC_ERROR;

Line 2884: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BASED_ON_TERMS');

2880: end if;
2881:
2882: if P_BASED_ON_TERMS is null then
2883: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2884: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BASED_ON_TERMS');
2885: FND_MESSAGE.SET_TOKEN('VALUE', P_BASED_ON_TERMS);
2886: FND_MSG_PUB.ADD;
2887: RAISE FND_API.G_EXC_ERROR;
2888: end if;

Line 2885: FND_MESSAGE.SET_TOKEN('VALUE', P_BASED_ON_TERMS);

2881:
2882: if P_BASED_ON_TERMS is null then
2883: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2884: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BASED_ON_TERMS');
2885: FND_MESSAGE.SET_TOKEN('VALUE', P_BASED_ON_TERMS);
2886: FND_MSG_PUB.ADD;
2887: RAISE FND_API.G_EXC_ERROR;
2888: end if;
2889:

Line 2891: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');

2887: RAISE FND_API.G_EXC_ERROR;
2888: end if;
2889:
2890: if P_AMORT_METHOD is null then
2891: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2892: FND_MESSAGE.SET_TOKEN('PARAMETER', 'AMORT_METHOD');
2893: FND_MESSAGE.SET_TOKEN('VALUE', P_AMORT_METHOD);
2894: FND_MSG_PUB.ADD;
2895: RAISE FND_API.G_EXC_ERROR;

Line 2892: FND_MESSAGE.SET_TOKEN('PARAMETER', 'AMORT_METHOD');

2888: end if;
2889:
2890: if P_AMORT_METHOD is null then
2891: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2892: FND_MESSAGE.SET_TOKEN('PARAMETER', 'AMORT_METHOD');
2893: FND_MESSAGE.SET_TOKEN('VALUE', P_AMORT_METHOD);
2894: FND_MSG_PUB.ADD;
2895: RAISE FND_API.G_EXC_ERROR;
2896: end if;

Line 2893: FND_MESSAGE.SET_TOKEN('VALUE', P_AMORT_METHOD);

2889:
2890: if P_AMORT_METHOD is null then
2891: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2892: FND_MESSAGE.SET_TOKEN('PARAMETER', 'AMORT_METHOD');
2893: FND_MESSAGE.SET_TOKEN('VALUE', P_AMORT_METHOD);
2894: FND_MSG_PUB.ADD;
2895: RAISE FND_API.G_EXC_ERROR;
2896: end if;
2897:

Line 3008: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');

3004:
3005: IF l_return_status = 'S' THEN
3006: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully updated lns_loan_headers_all');
3007: ELSE
3008: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
3009: FND_MSG_PUB.Add;
3010: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3011: RAISE FND_API.G_EXC_ERROR;
3012: end if;

Line 3049: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_TERM_FAIL');

3045: IF l_return_status = 'S' THEN
3046: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully update LNS_TERMS');
3047: ELSE
3048: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: LNS_TERMS_PUB.update_term returned error: ' || substr(l_msg_data,1,225));
3049: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_TERM_FAIL');
3050: FND_MSG_PUB.Add;
3051: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3052: RAISE FND_API.G_EXC_ERROR;
3053: END IF;

Line 3165: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');

3161: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_LOAN_ID: ' || P_LOAN_ID);
3162: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_ST_AMORT_METHOD: ' || P_ST_AMORT_METHOD);
3163:
3164: if P_LOAN_ID is null then
3165: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
3166: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
3167: FND_MESSAGE.SET_TOKEN('VALUE', P_LOAN_ID);
3168: FND_MSG_PUB.ADD;
3169: RAISE FND_API.G_EXC_ERROR;

Line 3166: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');

3162: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_ST_AMORT_METHOD: ' || P_ST_AMORT_METHOD);
3163:
3164: if P_LOAN_ID is null then
3165: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
3166: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
3167: FND_MESSAGE.SET_TOKEN('VALUE', P_LOAN_ID);
3168: FND_MSG_PUB.ADD;
3169: RAISE FND_API.G_EXC_ERROR;
3170: end if;

Line 3167: FND_MESSAGE.SET_TOKEN('VALUE', P_LOAN_ID);

3163:
3164: if P_LOAN_ID is null then
3165: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
3166: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
3167: FND_MESSAGE.SET_TOKEN('VALUE', P_LOAN_ID);
3168: FND_MSG_PUB.ADD;
3169: RAISE FND_API.G_EXC_ERROR;
3170: end if;
3171:

Line 3206: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');

3202:
3203: IF l_return_status = 'S' THEN
3204: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully updated lns_loan_headers_all');
3205: ELSE
3206: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
3207: FND_MSG_PUB.Add;
3208: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3209: RAISE FND_API.G_EXC_ERROR;
3210: end if;

Line 3239: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_TERM_FAIL');

3235: IF l_return_status = 'S' THEN
3236: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully update LNS_TERMS');
3237: ELSE
3238: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: LNS_TERMS_PUB.update_term returned error: ' || substr(l_msg_data,1,225));
3239: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_TERM_FAIL');
3240: FND_MSG_PUB.Add;
3241: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3242: RAISE FND_API.G_EXC_ERROR;
3243: END IF;

Line 3351: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');

3347: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Input:');
3348: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_LOAN_ID: ' || P_LOAN_ID);
3349:
3350: if P_LOAN_ID is null then
3351: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
3352: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
3353: FND_MESSAGE.SET_TOKEN('VALUE', P_LOAN_ID);
3354: FND_MSG_PUB.ADD;
3355: RAISE FND_API.G_EXC_ERROR;

Line 3352: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');

3348: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_LOAN_ID: ' || P_LOAN_ID);
3349:
3350: if P_LOAN_ID is null then
3351: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
3352: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
3353: FND_MESSAGE.SET_TOKEN('VALUE', P_LOAN_ID);
3354: FND_MSG_PUB.ADD;
3355: RAISE FND_API.G_EXC_ERROR;
3356: end if;

Line 3353: FND_MESSAGE.SET_TOKEN('VALUE', P_LOAN_ID);

3349:
3350: if P_LOAN_ID is null then
3351: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
3352: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
3353: FND_MESSAGE.SET_TOKEN('VALUE', P_LOAN_ID);
3354: FND_MSG_PUB.ADD;
3355: RAISE FND_API.G_EXC_ERROR;
3356: end if;
3357:

Line 3590: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');

3586: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_AMORT_METHOD: ' || P_AMORT_METHOD);
3587: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_BASED_ON_TERMS: ' || P_BASED_ON_TERMS);
3588:
3589: if P_LOAN_ID is null then
3590: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
3591: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
3592: FND_MESSAGE.SET_TOKEN('VALUE', P_LOAN_ID);
3593: FND_MSG_PUB.ADD;
3594: RAISE FND_API.G_EXC_ERROR;

Line 3591: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');

3587: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_BASED_ON_TERMS: ' || P_BASED_ON_TERMS);
3588:
3589: if P_LOAN_ID is null then
3590: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
3591: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
3592: FND_MESSAGE.SET_TOKEN('VALUE', P_LOAN_ID);
3593: FND_MSG_PUB.ADD;
3594: RAISE FND_API.G_EXC_ERROR;
3595: end if;

Line 3592: FND_MESSAGE.SET_TOKEN('VALUE', P_LOAN_ID);

3588:
3589: if P_LOAN_ID is null then
3590: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
3591: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
3592: FND_MESSAGE.SET_TOKEN('VALUE', P_LOAN_ID);
3593: FND_MSG_PUB.ADD;
3594: RAISE FND_API.G_EXC_ERROR;
3595: end if;
3596:

Line 3598: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');

3594: RAISE FND_API.G_EXC_ERROR;
3595: end if;
3596:
3597: if P_BASED_ON_TERMS is null then
3598: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
3599: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BASED_ON_TERMS');
3600: FND_MESSAGE.SET_TOKEN('VALUE', P_BASED_ON_TERMS);
3601: FND_MSG_PUB.ADD;
3602: RAISE FND_API.G_EXC_ERROR;

Line 3599: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BASED_ON_TERMS');

3595: end if;
3596:
3597: if P_BASED_ON_TERMS is null then
3598: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
3599: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BASED_ON_TERMS');
3600: FND_MESSAGE.SET_TOKEN('VALUE', P_BASED_ON_TERMS);
3601: FND_MSG_PUB.ADD;
3602: RAISE FND_API.G_EXC_ERROR;
3603: end if;

Line 3600: FND_MESSAGE.SET_TOKEN('VALUE', P_BASED_ON_TERMS);

3596:
3597: if P_BASED_ON_TERMS is null then
3598: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
3599: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BASED_ON_TERMS');
3600: FND_MESSAGE.SET_TOKEN('VALUE', P_BASED_ON_TERMS);
3601: FND_MSG_PUB.ADD;
3602: RAISE FND_API.G_EXC_ERROR;
3603: end if;
3604:

Line 3606: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');

3602: RAISE FND_API.G_EXC_ERROR;
3603: end if;
3604:
3605: if P_AMORT_METHOD is null then
3606: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
3607: FND_MESSAGE.SET_TOKEN('PARAMETER', 'AMORT_METHOD');
3608: FND_MESSAGE.SET_TOKEN('VALUE', P_AMORT_METHOD);
3609: FND_MSG_PUB.ADD;
3610: RAISE FND_API.G_EXC_ERROR;

Line 3607: FND_MESSAGE.SET_TOKEN('PARAMETER', 'AMORT_METHOD');

3603: end if;
3604:
3605: if P_AMORT_METHOD is null then
3606: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
3607: FND_MESSAGE.SET_TOKEN('PARAMETER', 'AMORT_METHOD');
3608: FND_MESSAGE.SET_TOKEN('VALUE', P_AMORT_METHOD);
3609: FND_MSG_PUB.ADD;
3610: RAISE FND_API.G_EXC_ERROR;
3611: end if;

Line 3608: FND_MESSAGE.SET_TOKEN('VALUE', P_AMORT_METHOD);

3604:
3605: if P_AMORT_METHOD is null then
3606: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
3607: FND_MESSAGE.SET_TOKEN('PARAMETER', 'AMORT_METHOD');
3608: FND_MESSAGE.SET_TOKEN('VALUE', P_AMORT_METHOD);
3609: FND_MSG_PUB.ADD;
3610: RAISE FND_API.G_EXC_ERROR;
3611: end if;
3612:

Line 3614: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');

3610: RAISE FND_API.G_EXC_ERROR;
3611: end if;
3612:
3613: if P_NEW_DUE_DATE is null then
3614: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
3615: FND_MESSAGE.SET_TOKEN('PARAMETER', 'NEW_DUE_DATE');
3616: FND_MESSAGE.SET_TOKEN('VALUE', P_NEW_DUE_DATE);
3617: FND_MSG_PUB.ADD;
3618: RAISE FND_API.G_EXC_ERROR;

Line 3615: FND_MESSAGE.SET_TOKEN('PARAMETER', 'NEW_DUE_DATE');

3611: end if;
3612:
3613: if P_NEW_DUE_DATE is null then
3614: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
3615: FND_MESSAGE.SET_TOKEN('PARAMETER', 'NEW_DUE_DATE');
3616: FND_MESSAGE.SET_TOKEN('VALUE', P_NEW_DUE_DATE);
3617: FND_MSG_PUB.ADD;
3618: RAISE FND_API.G_EXC_ERROR;
3619: end if;

Line 3616: FND_MESSAGE.SET_TOKEN('VALUE', P_NEW_DUE_DATE);

3612:
3613: if P_NEW_DUE_DATE is null then
3614: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
3615: FND_MESSAGE.SET_TOKEN('PARAMETER', 'NEW_DUE_DATE');
3616: FND_MESSAGE.SET_TOKEN('VALUE', P_NEW_DUE_DATE);
3617: FND_MSG_PUB.ADD;
3618: RAISE FND_API.G_EXC_ERROR;
3619: end if;
3620:

Line 3626: FND_MESSAGE.SET_NAME('LNS', 'LNS_CUST_AMORT_EMPTY');

3622:
3623: filterCustSchedule(l_custom_tbl);
3624: if l_custom_tbl.count = 0 then
3625: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Custom amortization is empty.');
3626: FND_MESSAGE.SET_NAME('LNS', 'LNS_CUST_AMORT_EMPTY');
3627: FND_MSG_PUB.Add;
3628: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3629: RAISE FND_API.G_EXC_ERROR;
3630: end if;

Line 3759: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');

3755: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Input:');
3756: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_LOAN_ID: ' || P_LOAN_ID);
3757:
3758: if P_LOAN_ID is null then
3759: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
3760: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
3761: FND_MESSAGE.SET_TOKEN('VALUE', P_LOAN_ID);
3762: FND_MSG_PUB.ADD;
3763: RAISE FND_API.G_EXC_ERROR;

Line 3760: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');

3756: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_LOAN_ID: ' || P_LOAN_ID);
3757:
3758: if P_LOAN_ID is null then
3759: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
3760: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
3761: FND_MESSAGE.SET_TOKEN('VALUE', P_LOAN_ID);
3762: FND_MSG_PUB.ADD;
3763: RAISE FND_API.G_EXC_ERROR;
3764: end if;

Line 3761: FND_MESSAGE.SET_TOKEN('VALUE', P_LOAN_ID);

3757:
3758: if P_LOAN_ID is null then
3759: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
3760: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
3761: FND_MESSAGE.SET_TOKEN('VALUE', P_LOAN_ID);
3762: FND_MSG_PUB.ADD;
3763: RAISE FND_API.G_EXC_ERROR;
3764: end if;
3765:

Line 4010: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');

4006: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_INSTALLMENT_REC.LOCK_PRIN: ' || l_INSTALLMENT_REC.LOCK_PRIN);
4007: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_INSTALLMENT_REC.LOCK_INT: ' || l_INSTALLMENT_REC.LOCK_INT);
4008:
4009: if l_INSTALLMENT_REC.LOAN_ID is null then
4010: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
4011: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
4012: FND_MESSAGE.SET_TOKEN('VALUE', l_INSTALLMENT_REC.LOAN_ID);
4013: FND_MSG_PUB.ADD;
4014: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

Line 4011: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');

4007: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_INSTALLMENT_REC.LOCK_INT: ' || l_INSTALLMENT_REC.LOCK_INT);
4008:
4009: if l_INSTALLMENT_REC.LOAN_ID is null then
4010: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
4011: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
4012: FND_MESSAGE.SET_TOKEN('VALUE', l_INSTALLMENT_REC.LOAN_ID);
4013: FND_MSG_PUB.ADD;
4014: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
4015: RAISE FND_API.G_EXC_ERROR;

Line 4012: FND_MESSAGE.SET_TOKEN('VALUE', l_INSTALLMENT_REC.LOAN_ID);

4008:
4009: if l_INSTALLMENT_REC.LOAN_ID is null then
4010: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
4011: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
4012: FND_MESSAGE.SET_TOKEN('VALUE', l_INSTALLMENT_REC.LOAN_ID);
4013: FND_MSG_PUB.ADD;
4014: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
4015: RAISE FND_API.G_EXC_ERROR;
4016: end if;

Line 4019: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');

4015: RAISE FND_API.G_EXC_ERROR;
4016: end if;
4017:
4018: if l_INSTALLMENT_REC.PAYMENT_NUMBER is null then
4019: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
4020: FND_MESSAGE.SET_TOKEN('PARAMETER', 'PAYMENT_NUMBER');
4021: FND_MESSAGE.SET_TOKEN('VALUE', l_INSTALLMENT_REC.PAYMENT_NUMBER);
4022: FND_MSG_PUB.ADD;
4023: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

Line 4020: FND_MESSAGE.SET_TOKEN('PARAMETER', 'PAYMENT_NUMBER');

4016: end if;
4017:
4018: if l_INSTALLMENT_REC.PAYMENT_NUMBER is null then
4019: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
4020: FND_MESSAGE.SET_TOKEN('PARAMETER', 'PAYMENT_NUMBER');
4021: FND_MESSAGE.SET_TOKEN('VALUE', l_INSTALLMENT_REC.PAYMENT_NUMBER);
4022: FND_MSG_PUB.ADD;
4023: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
4024: RAISE FND_API.G_EXC_ERROR;

Line 4021: FND_MESSAGE.SET_TOKEN('VALUE', l_INSTALLMENT_REC.PAYMENT_NUMBER);

4017:
4018: if l_INSTALLMENT_REC.PAYMENT_NUMBER is null then
4019: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
4020: FND_MESSAGE.SET_TOKEN('PARAMETER', 'PAYMENT_NUMBER');
4021: FND_MESSAGE.SET_TOKEN('VALUE', l_INSTALLMENT_REC.PAYMENT_NUMBER);
4022: FND_MSG_PUB.ADD;
4023: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
4024: RAISE FND_API.G_EXC_ERROR;
4025: end if;

Line 4028: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');

4024: RAISE FND_API.G_EXC_ERROR;
4025: end if;
4026:
4027: if l_INSTALLMENT_REC.DUE_DATE is null then
4028: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
4029: FND_MESSAGE.SET_TOKEN('PARAMETER', 'DUE_DATE');
4030: FND_MESSAGE.SET_TOKEN('VALUE', l_INSTALLMENT_REC.DUE_DATE);
4031: FND_MSG_PUB.ADD;
4032: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

Line 4029: FND_MESSAGE.SET_TOKEN('PARAMETER', 'DUE_DATE');

4025: end if;
4026:
4027: if l_INSTALLMENT_REC.DUE_DATE is null then
4028: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
4029: FND_MESSAGE.SET_TOKEN('PARAMETER', 'DUE_DATE');
4030: FND_MESSAGE.SET_TOKEN('VALUE', l_INSTALLMENT_REC.DUE_DATE);
4031: FND_MSG_PUB.ADD;
4032: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
4033: RAISE FND_API.G_EXC_ERROR;

Line 4030: FND_MESSAGE.SET_TOKEN('VALUE', l_INSTALLMENT_REC.DUE_DATE);

4026:
4027: if l_INSTALLMENT_REC.DUE_DATE is null then
4028: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
4029: FND_MESSAGE.SET_TOKEN('PARAMETER', 'DUE_DATE');
4030: FND_MESSAGE.SET_TOKEN('VALUE', l_INSTALLMENT_REC.DUE_DATE);
4031: FND_MSG_PUB.ADD;
4032: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
4033: RAISE FND_API.G_EXC_ERROR;
4034: end if;