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 144: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

539: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
540:
541: EXCEPTION
542: WHEN FND_API.G_EXC_ERROR THEN
543: FND_MESSAGE.Set_Name('LNS', 'LNS_CREATE_CUSTOM_ERROR');
544: FND_MSG_PUB.Add;
545: x_return_status := FND_API.G_RET_STS_ERROR;
546: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
547: ROLLBACK TO createCustomSchedule;

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

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

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

553: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
554: ROLLBACK TO createCustomSchedule;
555:
556: WHEN OTHERS THEN
557: FND_MESSAGE.Set_Name('LNS', 'LNS_CREATE_CUSTOM_ERROR');
558: FND_MSG_PUB.Add;
559: x_return_status := FND_API.G_RET_STS_ERROR;
560: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
561: ROLLBACK TO createCustomSchedule;

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

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

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

684: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
685: if l_installment is not null then
686: X_INVALID_INSTALLMENT_NUM := l_installment;
687: FND_MESSAGE.Set_Name('LNS', 'LNS_INVALID_INSTALLMENT');
688: FND_MESSAGE.SET_TOKEN('PARAMETER', 'INSTALLMENT');
689: FND_MESSAGE.SET_TOKEN('VALUE', l_installment);
690: FND_MSG_PUB.Add;
691: RAISE FND_API.G_EXC_ERROR;
692: end if;

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

685: if l_installment is not null then
686: X_INVALID_INSTALLMENT_NUM := l_installment;
687: FND_MESSAGE.Set_Name('LNS', 'LNS_INVALID_INSTALLMENT');
688: FND_MESSAGE.SET_TOKEN('PARAMETER', 'INSTALLMENT');
689: FND_MESSAGE.SET_TOKEN('VALUE', l_installment);
690: FND_MSG_PUB.Add;
691: RAISE FND_API.G_EXC_ERROR;
692: end if;
693: FND_MESSAGE.Set_Name('LNS', 'LNS_VALIDATE_CUSTOM_ERROR');

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

689: FND_MESSAGE.SET_TOKEN('VALUE', l_installment);
690: FND_MSG_PUB.Add;
691: RAISE FND_API.G_EXC_ERROR;
692: end if;
693: FND_MESSAGE.Set_Name('LNS', 'LNS_VALIDATE_CUSTOM_ERROR');
694: FND_MSG_PUB.Add;
695: RAISE FND_API.G_EXC_ERROR;
696: end if;
697:

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

750: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
751:
752: EXCEPTION
753: WHEN FND_API.G_EXC_ERROR THEN
754: --FND_MESSAGE.Set_Name('LNS', 'LNS_UPDATE_CUSTOM_ERROR');
755: --FND_MSG_PUB.Add;
756: --RAISE FND_API.G_EXC_ERROR;
757: x_return_status := FND_API.G_RET_STS_ERROR;
758: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

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

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

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

766: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
767: ROLLBACK TO updateCustomSchedule;
768:
769: WHEN OTHERS THEN
770: --FND_MESSAGE.Set_Name('LNS', 'LNS_UPDATE_CUSTOM_ERROR');
771: --FND_MSG_PUB.Add;
772: --RAISE FND_API.G_EXC_ERROR;
773: x_return_status := FND_API.G_RET_STS_ERROR;
774: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

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

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

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

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

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

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

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

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

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

872: x_installment := i;
873: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'invalid installment found #' || i);
874: FND_MESSAGE.Set_Name('LNS', 'LNS_INVALID_INSTALLMENT');
875: FND_MESSAGE.SET_TOKEN('PARAMETER', 'INSTALLMENT');
876: FND_MESSAGE.SET_TOKEN('VALUE', i);
877: FND_MSG_PUB.Add;
878: RAISE FND_API.G_EXC_ERROR;
879: end if;
880:

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

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

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

897:
898: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'PASS: ' || i || 'p_cust_tbl(i).due_date is : ' || l_cust_tbl(i).due_date);
899: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'l_date is: ' || l_date);
900: if p_cust_tbl(i).due_date <= l_date then
901: FND_MESSAGE.Set_Name('LNS', 'LNS_NONSEQUENTIAL_DATES');
902: FND_MSG_PUB.Add;
903: RAISE FND_API.G_EXC_ERROR;
904: end if;
905: l_date := l_cust_tbl(i).due_date;

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

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

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

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

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

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

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

941: x_return_status := FND_API.G_RET_STS_ERROR;
942: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
943:
944: WHEN OTHERS THEN
945: --FND_MESSAGE.Set_Name('LNS', 'LNS_VALIDATE_CUSTOM_ERROR');
946: --FND_MSG_PUB.Add;
947: x_return_status := FND_API.G_RET_STS_ERROR;
948: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
949: End;

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

974: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' ' || p_custom_rec.PRINCIPAL_AMOUNT );
975: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' ' || p_custom_rec.INTEREST_AMOUNT );
976:
977: if p_custom_rec.due_Date is null then
978: FND_MESSAGE.Set_Name('LNS', 'LNS_NO_DUE_DATE');
979: FND_MSG_PUB.Add;
980: RAISE FND_API.G_EXC_ERROR;
981:
982: elsif p_custom_rec.payment_number is null or p_custom_rec.payment_number < 1 then

Line 983: 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.payment_number is null or p_custom_rec.payment_number < 1 then
983: FND_MESSAGE.Set_Name('LNS', 'LNS_INVALID_PAYMENT_NUMBER');
984: FND_MSG_PUB.Add;
985: RAISE FND_API.G_EXC_ERROR;
986:
987: elsif p_custom_rec.PRINCIPAL_AMOUNT is not null and p_custom_rec.PRINCIPAL_AMOUNT < 0 then

Line 988: 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.PRINCIPAL_AMOUNT is not null and p_custom_rec.PRINCIPAL_AMOUNT < 0 then
988: FND_MESSAGE.Set_Name('LNS', 'LNS_PRINICIPAL_AMOUNT_ERROR');
989: FND_MSG_PUB.Add;
990: RAISE FND_API.G_EXC_ERROR;
991:
992: elsif p_custom_rec.INTEREST_AMOUNT is not null and p_custom_rec.INTEREST_AMOUNT < 0 then

Line 993: 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.INTEREST_AMOUNT is not null and p_custom_rec.INTEREST_AMOUNT < 0 then
993: FND_MESSAGE.Set_Name('LNS', 'LNS_INTEREST_AMOUNT_ERROR');
994: FND_MSG_PUB.Add;
995: RAISE FND_API.G_EXC_ERROR;
996:
997: elsif p_custom_rec.FEE_AMOUNT is not null and p_custom_rec.FEE_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.FEE_AMOUNT is not null and p_custom_rec.FEE_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: elsif p_custom_rec.OTHER_AMOUNT is not null and p_custom_rec.OTHER_AMOUNT < 0 then

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

999: FND_MSG_PUB.Add;
1000: RAISE FND_API.G_EXC_ERROR;
1001:
1002: elsif p_custom_rec.OTHER_AMOUNT is not null and p_custom_rec.OTHER_AMOUNT < 0 then
1003: FND_MESSAGE.Set_Name('LNS', 'LNS_OTHER_AMOUNT_ERROR');
1004: FND_MSG_PUB.Add;
1005: RAISE FND_API.G_EXC_ERROR;
1006:
1007: end if;

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

1191: l_custom_tbl(j).INTEREST_AMOUNT := 0;
1192: end if;
1193: /*
1194: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Several installments have the same due date.');
1195: FND_MESSAGE.SET_NAME('LNS', 'LNS_DUE_DATE_DUPL');
1196: FND_MSG_PUB.Add;
1197: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1198: RAISE FND_API.G_EXC_ERROR;
1199: */

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

1312:
1313: EXCEPTION
1314: WHEN OTHERS THEN
1315: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'ERROR: ' || sqlerrm);
1316: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
1317: FND_MESSAGE.SET_TOKEN('PARAMETER', 'RELATIVE_DATE');
1318: FND_MESSAGE.SET_TOKEN('VALUE', l_custom_tbl(i).RELATIVE_DATE);
1319: FND_MSG_PUB.ADD;
1320: RAISE FND_API.G_EXC_ERROR;

Line 1317: FND_MESSAGE.SET_TOKEN('PARAMETER', 'RELATIVE_DATE');

1313: EXCEPTION
1314: WHEN OTHERS THEN
1315: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'ERROR: ' || sqlerrm);
1316: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
1317: FND_MESSAGE.SET_TOKEN('PARAMETER', 'RELATIVE_DATE');
1318: FND_MESSAGE.SET_TOKEN('VALUE', l_custom_tbl(i).RELATIVE_DATE);
1319: FND_MSG_PUB.ADD;
1320: RAISE FND_API.G_EXC_ERROR;
1321: END;

Line 1318: FND_MESSAGE.SET_TOKEN('VALUE', l_custom_tbl(i).RELATIVE_DATE);

1314: WHEN OTHERS THEN
1315: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'ERROR: ' || sqlerrm);
1316: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
1317: FND_MESSAGE.SET_TOKEN('PARAMETER', 'RELATIVE_DATE');
1318: FND_MESSAGE.SET_TOKEN('VALUE', l_custom_tbl(i).RELATIVE_DATE);
1319: FND_MSG_PUB.ADD;
1320: RAISE FND_API.G_EXC_ERROR;
1321: END;
1322: /*

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

1331: l_custom_tbl(i).DUE_DATE := add_months(l_last_due_date, l_term);
1332: elsif l_period = 'Y' then
1333: l_custom_tbl(i).DUE_DATE := l_last_due_date + NUMTOYMINTERVAL(l_term,'YEAR');
1334: else
1335: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
1336: FND_MESSAGE.SET_TOKEN('PARAMETER', 'RELATIVE_DATE');
1337: FND_MESSAGE.SET_TOKEN('VALUE', l_custom_tbl(i).RELATIVE_DATE);
1338: FND_MSG_PUB.ADD;
1339: RAISE FND_API.G_EXC_ERROR;

Line 1336: FND_MESSAGE.SET_TOKEN('PARAMETER', 'RELATIVE_DATE');

1332: elsif l_period = 'Y' then
1333: l_custom_tbl(i).DUE_DATE := l_last_due_date + NUMTOYMINTERVAL(l_term,'YEAR');
1334: else
1335: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
1336: FND_MESSAGE.SET_TOKEN('PARAMETER', 'RELATIVE_DATE');
1337: FND_MESSAGE.SET_TOKEN('VALUE', l_custom_tbl(i).RELATIVE_DATE);
1338: FND_MSG_PUB.ADD;
1339: RAISE FND_API.G_EXC_ERROR;
1340: end if;

Line 1337: FND_MESSAGE.SET_TOKEN('VALUE', l_custom_tbl(i).RELATIVE_DATE);

1333: l_custom_tbl(i).DUE_DATE := l_last_due_date + NUMTOYMINTERVAL(l_term,'YEAR');
1334: else
1335: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
1336: FND_MESSAGE.SET_TOKEN('PARAMETER', 'RELATIVE_DATE');
1337: FND_MESSAGE.SET_TOKEN('VALUE', l_custom_tbl(i).RELATIVE_DATE);
1338: FND_MSG_PUB.ADD;
1339: RAISE FND_API.G_EXC_ERROR;
1340: end if;
1341: */

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

1344:
1345: l_custom_tbl(i).RELATIVE_DATE := null;
1346:
1347: if l_custom_tbl(i).DUE_DATE is null then
1348: FND_MESSAGE.Set_Name('LNS', 'LNS_NO_DUE_DATE');
1349: FND_MSG_PUB.Add;
1350: RAISE FND_API.G_EXC_ERROR;
1351: end if;
1352:

Line 1370: FND_MESSAGE.SET_NAME('LNS', 'LNS_CUST_INVALID_DUEDATE_WARN');

1366: end loop;
1367: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Done.');
1368:
1369: if l_filtered then
1370: FND_MESSAGE.SET_NAME('LNS', 'LNS_CUST_INVALID_DUEDATE_WARN');
1371: FND_MSG_PUB.ADD_DETAIL(p_message_type => FND_MSG_PUB.G_WARNING_MSG);
1372: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1373: end if;
1374:

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

1781:
1782: Exception
1783: When No_Data_Found then
1784: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'LOAN ID: ' || p_loan_id || ' not found');
1785: FND_MESSAGE.Set_Name('LNS', 'LNS_INVALID_LOAN_ID');
1786: FND_MSG_PUB.Add;
1787: RAISE FND_API.G_EXC_ERROR;
1788:
1789: When Others then

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

1878: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_LOAN_ID: ' || P_LOAN_ID);
1879: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_BASED_ON_TERMS: ' || P_BASED_ON_TERMS);
1880:
1881: if P_LOAN_ID is null then
1882: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
1883: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
1884: FND_MESSAGE.SET_TOKEN('VALUE', P_LOAN_ID);
1885: FND_MSG_PUB.ADD;
1886: RAISE FND_API.G_EXC_ERROR;

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

1879: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_BASED_ON_TERMS: ' || P_BASED_ON_TERMS);
1880:
1881: if P_LOAN_ID is null then
1882: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
1883: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
1884: FND_MESSAGE.SET_TOKEN('VALUE', P_LOAN_ID);
1885: FND_MSG_PUB.ADD;
1886: RAISE FND_API.G_EXC_ERROR;
1887: end if;

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

1880:
1881: if P_LOAN_ID is null then
1882: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
1883: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
1884: FND_MESSAGE.SET_TOKEN('VALUE', P_LOAN_ID);
1885: FND_MSG_PUB.ADD;
1886: RAISE FND_API.G_EXC_ERROR;
1887: end if;
1888:

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

1886: RAISE FND_API.G_EXC_ERROR;
1887: end if;
1888:
1889: if P_BASED_ON_TERMS is null then
1890: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
1891: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BASED_ON_TERMS');
1892: FND_MESSAGE.SET_TOKEN('VALUE', P_BASED_ON_TERMS);
1893: FND_MSG_PUB.ADD;
1894: RAISE FND_API.G_EXC_ERROR;

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

1887: end if;
1888:
1889: if P_BASED_ON_TERMS is null then
1890: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
1891: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BASED_ON_TERMS');
1892: FND_MESSAGE.SET_TOKEN('VALUE', P_BASED_ON_TERMS);
1893: FND_MSG_PUB.ADD;
1894: RAISE FND_API.G_EXC_ERROR;
1895: end if;

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

1888:
1889: if P_BASED_ON_TERMS is null then
1890: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
1891: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BASED_ON_TERMS');
1892: FND_MESSAGE.SET_TOKEN('VALUE', P_BASED_ON_TERMS);
1893: FND_MSG_PUB.ADD;
1894: RAISE FND_API.G_EXC_ERROR;
1895: end if;
1896:

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

2271: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'AMORT_METHOD: ' || P_CUSTOM_SET_REC.AMORT_METHOD);
2272: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'DESCRIPTION: ' || P_CUSTOM_SET_REC.DESCRIPTION);
2273:
2274: if P_LOAN_ID is null then
2275: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2276: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
2277: FND_MESSAGE.SET_TOKEN('VALUE', P_LOAN_ID);
2278: FND_MSG_PUB.ADD;
2279: RAISE FND_API.G_EXC_ERROR;

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

2272: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'DESCRIPTION: ' || P_CUSTOM_SET_REC.DESCRIPTION);
2273:
2274: if P_LOAN_ID is null then
2275: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2276: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
2277: FND_MESSAGE.SET_TOKEN('VALUE', P_LOAN_ID);
2278: FND_MSG_PUB.ADD;
2279: RAISE FND_API.G_EXC_ERROR;
2280: end if;

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

2273:
2274: if P_LOAN_ID is null then
2275: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2276: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
2277: FND_MESSAGE.SET_TOKEN('VALUE', P_LOAN_ID);
2278: FND_MSG_PUB.ADD;
2279: RAISE FND_API.G_EXC_ERROR;
2280: end if;
2281:

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

2279: RAISE FND_API.G_EXC_ERROR;
2280: end if;
2281:
2282: if P_BASED_ON_TERMS is null then
2283: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2284: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BASED_ON_TERMS');
2285: FND_MESSAGE.SET_TOKEN('VALUE', P_BASED_ON_TERMS);
2286: FND_MSG_PUB.ADD;
2287: RAISE FND_API.G_EXC_ERROR;

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

2280: end if;
2281:
2282: if P_BASED_ON_TERMS is null then
2283: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2284: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BASED_ON_TERMS');
2285: FND_MESSAGE.SET_TOKEN('VALUE', P_BASED_ON_TERMS);
2286: FND_MSG_PUB.ADD;
2287: RAISE FND_API.G_EXC_ERROR;
2288: end if;

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

2281:
2282: if P_BASED_ON_TERMS is null then
2283: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2284: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BASED_ON_TERMS');
2285: FND_MESSAGE.SET_TOKEN('VALUE', P_BASED_ON_TERMS);
2286: FND_MSG_PUB.ADD;
2287: RAISE FND_API.G_EXC_ERROR;
2288: end if;
2289:

Line 3411: FND_MESSAGE.SET_NAME('LNS', 'LNS_LOAN_BAL_GREATER_ZERO');

3407: end loop;
3408:
3409: -- fix for bug 8309391 - give warning is amortization schedule does not bring loan balance to 0
3410: if l_custom_tbl(l_custom_tbl.count).INSTALLMENT_END_BALANCE > 0 then
3411: FND_MESSAGE.SET_NAME('LNS', 'LNS_LOAN_BAL_GREATER_ZERO');
3412: FND_MSG_PUB.ADD_DETAIL(p_message_type => FND_MSG_PUB.G_WARNING_MSG );
3413: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3414: end if;
3415:

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

3567: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'AMORT_METHOD: ' || P_CUSTOM_SET_REC.AMORT_METHOD);
3568: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'DESCRIPTION: ' || P_CUSTOM_SET_REC.DESCRIPTION);
3569:
3570: if P_LOAN_ID is null then
3571: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
3572: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
3573: FND_MESSAGE.SET_TOKEN('VALUE', P_LOAN_ID);
3574: FND_MSG_PUB.ADD;
3575: RAISE FND_API.G_EXC_ERROR;

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

3568: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'DESCRIPTION: ' || P_CUSTOM_SET_REC.DESCRIPTION);
3569:
3570: if P_LOAN_ID is null then
3571: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
3572: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
3573: FND_MESSAGE.SET_TOKEN('VALUE', P_LOAN_ID);
3574: FND_MSG_PUB.ADD;
3575: RAISE FND_API.G_EXC_ERROR;
3576: end if;

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

3569:
3570: if P_LOAN_ID is null then
3571: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
3572: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
3573: FND_MESSAGE.SET_TOKEN('VALUE', P_LOAN_ID);
3574: FND_MSG_PUB.ADD;
3575: RAISE FND_API.G_EXC_ERROR;
3576: end if;
3577:

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

3575: RAISE FND_API.G_EXC_ERROR;
3576: end if;
3577:
3578: if P_BASED_ON_TERMS is null then
3579: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
3580: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BASED_ON_TERMS');
3581: FND_MESSAGE.SET_TOKEN('VALUE', P_BASED_ON_TERMS);
3582: FND_MSG_PUB.ADD;
3583: RAISE FND_API.G_EXC_ERROR;

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

3576: end if;
3577:
3578: if P_BASED_ON_TERMS is null then
3579: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
3580: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BASED_ON_TERMS');
3581: FND_MESSAGE.SET_TOKEN('VALUE', P_BASED_ON_TERMS);
3582: FND_MSG_PUB.ADD;
3583: RAISE FND_API.G_EXC_ERROR;
3584: end if;

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

3577:
3578: if P_BASED_ON_TERMS is null then
3579: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
3580: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BASED_ON_TERMS');
3581: FND_MESSAGE.SET_TOKEN('VALUE', P_BASED_ON_TERMS);
3582: FND_MSG_PUB.ADD;
3583: RAISE FND_API.G_EXC_ERROR;
3584: end if;
3585:

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

3590: l_CUSTOM_SET_REC.AMORT_METHOD := G_AMORT_METHOD;
3591: l_CUSTOM_SET_REC.DESCRIPTION := g_CUSTOM_SCHED_DESC;
3592: else
3593: if P_CUSTOM_SET_REC.AMORT_METHOD is null then
3594: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
3595: FND_MESSAGE.SET_TOKEN('PARAMETER', 'AMORT_METHOD');
3596: FND_MESSAGE.SET_TOKEN('VALUE', P_CUSTOM_SET_REC.AMORT_METHOD);
3597: FND_MSG_PUB.ADD;
3598: RAISE FND_API.G_EXC_ERROR;

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

3591: l_CUSTOM_SET_REC.DESCRIPTION := g_CUSTOM_SCHED_DESC;
3592: else
3593: if P_CUSTOM_SET_REC.AMORT_METHOD is null then
3594: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
3595: FND_MESSAGE.SET_TOKEN('PARAMETER', 'AMORT_METHOD');
3596: FND_MESSAGE.SET_TOKEN('VALUE', P_CUSTOM_SET_REC.AMORT_METHOD);
3597: FND_MSG_PUB.ADD;
3598: RAISE FND_API.G_EXC_ERROR;
3599: end if;

Line 3596: FND_MESSAGE.SET_TOKEN('VALUE', P_CUSTOM_SET_REC.AMORT_METHOD);

3592: else
3593: if P_CUSTOM_SET_REC.AMORT_METHOD is null then
3594: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
3595: FND_MESSAGE.SET_TOKEN('PARAMETER', 'AMORT_METHOD');
3596: FND_MESSAGE.SET_TOKEN('VALUE', P_CUSTOM_SET_REC.AMORT_METHOD);
3597: FND_MSG_PUB.ADD;
3598: RAISE FND_API.G_EXC_ERROR;
3599: end if;
3600:

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

3737:
3738: IF l_return_status = 'S' THEN
3739: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully updated lns_loan_headers_all');
3740: ELSE
3741: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
3742: FND_MSG_PUB.Add;
3743: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3744: RAISE FND_API.G_EXC_ERROR;
3745: end if;

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

3783: IF l_return_status = 'S' THEN
3784: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully update LNS_TERMS');
3785: ELSE
3786: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: LNS_TERMS_PUB.update_term returned error: ' || substr(l_msg_data,1,225));
3787: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_TERM_FAIL');
3788: FND_MSG_PUB.Add;
3789: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3790: RAISE FND_API.G_EXC_ERROR;
3791: END IF;

Line 3809: FND_MESSAGE.SET_NAME('LNS', 'LNS_CUST_SCHED_AGR_REASON');

3805: P_CUSTOM_TBL := l_CUSTOM_TBL;
3806: P_CUSTOM_SET_REC := l_CUSTOM_SET_REC;
3807:
3808: if P_BASED_ON_TERMS = 'CURRENT' then
3809: FND_MESSAGE.SET_NAME('LNS', 'LNS_CUST_SCHED_AGR_REASON');
3810: FND_MSG_PUB.Add;
3811: l_agreement_reason := FND_MSG_PUB.Get(p_encoded => 'F');
3812: FND_MSG_PUB.DELETE_MSG(FND_MSG_PUB.COUNT_MSG);
3813:

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

3914: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_LOAN_ID: ' || P_LOAN_ID);
3915: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_ST_AMORT_METHOD: ' || P_ST_AMORT_METHOD);
3916:
3917: if P_LOAN_ID is null then
3918: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
3919: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
3920: FND_MESSAGE.SET_TOKEN('VALUE', P_LOAN_ID);
3921: FND_MSG_PUB.ADD;
3922: RAISE FND_API.G_EXC_ERROR;

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

3915: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_ST_AMORT_METHOD: ' || P_ST_AMORT_METHOD);
3916:
3917: if P_LOAN_ID is null then
3918: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
3919: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
3920: FND_MESSAGE.SET_TOKEN('VALUE', P_LOAN_ID);
3921: FND_MSG_PUB.ADD;
3922: RAISE FND_API.G_EXC_ERROR;
3923: end if;

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

3916:
3917: if P_LOAN_ID is null then
3918: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
3919: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
3920: FND_MESSAGE.SET_TOKEN('VALUE', P_LOAN_ID);
3921: FND_MSG_PUB.ADD;
3922: RAISE FND_API.G_EXC_ERROR;
3923: end if;
3924:

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

3955:
3956: IF l_return_status = 'S' THEN
3957: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully updated lns_loan_headers_all');
3958: ELSE
3959: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
3960: FND_MSG_PUB.Add;
3961: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3962: RAISE FND_API.G_EXC_ERROR;
3963: end if;

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

3988: IF l_return_status = 'S' THEN
3989: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully update LNS_TERMS');
3990: ELSE
3991: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: LNS_TERMS_PUB.update_term returned error: ' || substr(l_msg_data,1,225));
3992: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_TERM_FAIL');
3993: FND_MSG_PUB.Add;
3994: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3995: RAISE FND_API.G_EXC_ERROR;
3996: END IF;

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

4143: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Input:');
4144: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_LOAN_ID: ' || P_LOAN_ID);
4145:
4146: if P_LOAN_ID is null then
4147: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
4148: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
4149: FND_MESSAGE.SET_TOKEN('VALUE', P_LOAN_ID);
4150: FND_MSG_PUB.ADD;
4151: RAISE FND_API.G_EXC_ERROR;

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

4144: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_LOAN_ID: ' || P_LOAN_ID);
4145:
4146: if P_LOAN_ID is null then
4147: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
4148: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
4149: FND_MESSAGE.SET_TOKEN('VALUE', P_LOAN_ID);
4150: FND_MSG_PUB.ADD;
4151: RAISE FND_API.G_EXC_ERROR;
4152: end if;

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

4145:
4146: if P_LOAN_ID is null then
4147: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
4148: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
4149: FND_MESSAGE.SET_TOKEN('VALUE', P_LOAN_ID);
4150: FND_MSG_PUB.ADD;
4151: RAISE FND_API.G_EXC_ERROR;
4152: end if;
4153:

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

4402: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'AMORT_METHOD: ' || P_CUSTOM_SET_REC.AMORT_METHOD);
4403: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'DESCRIPTION: ' || P_CUSTOM_SET_REC.DESCRIPTION);
4404:
4405: if P_LOAN_ID is null then
4406: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
4407: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
4408: FND_MESSAGE.SET_TOKEN('VALUE', P_LOAN_ID);
4409: FND_MSG_PUB.ADD;
4410: RAISE FND_API.G_EXC_ERROR;

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

4403: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'DESCRIPTION: ' || P_CUSTOM_SET_REC.DESCRIPTION);
4404:
4405: if P_LOAN_ID is null then
4406: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
4407: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
4408: FND_MESSAGE.SET_TOKEN('VALUE', P_LOAN_ID);
4409: FND_MSG_PUB.ADD;
4410: RAISE FND_API.G_EXC_ERROR;
4411: end if;

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

4404:
4405: if P_LOAN_ID is null then
4406: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
4407: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
4408: FND_MESSAGE.SET_TOKEN('VALUE', P_LOAN_ID);
4409: FND_MSG_PUB.ADD;
4410: RAISE FND_API.G_EXC_ERROR;
4411: end if;
4412:

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

4410: RAISE FND_API.G_EXC_ERROR;
4411: end if;
4412:
4413: if P_BASED_ON_TERMS is null then
4414: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
4415: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BASED_ON_TERMS');
4416: FND_MESSAGE.SET_TOKEN('VALUE', P_BASED_ON_TERMS);
4417: FND_MSG_PUB.ADD;
4418: RAISE FND_API.G_EXC_ERROR;

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

4411: end if;
4412:
4413: if P_BASED_ON_TERMS is null then
4414: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
4415: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BASED_ON_TERMS');
4416: FND_MESSAGE.SET_TOKEN('VALUE', P_BASED_ON_TERMS);
4417: FND_MSG_PUB.ADD;
4418: RAISE FND_API.G_EXC_ERROR;
4419: end if;

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

4412:
4413: if P_BASED_ON_TERMS is null then
4414: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
4415: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BASED_ON_TERMS');
4416: FND_MESSAGE.SET_TOKEN('VALUE', P_BASED_ON_TERMS);
4417: FND_MSG_PUB.ADD;
4418: RAISE FND_API.G_EXC_ERROR;
4419: end if;
4420:

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

4418: RAISE FND_API.G_EXC_ERROR;
4419: end if;
4420:
4421: if P_CUSTOM_SET_REC.AMORT_METHOD is null then
4422: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
4423: FND_MESSAGE.SET_TOKEN('PARAMETER', 'AMORT_METHOD');
4424: FND_MESSAGE.SET_TOKEN('VALUE', P_CUSTOM_SET_REC.AMORT_METHOD);
4425: FND_MSG_PUB.ADD;
4426: RAISE FND_API.G_EXC_ERROR;

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

4419: end if;
4420:
4421: if P_CUSTOM_SET_REC.AMORT_METHOD is null then
4422: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
4423: FND_MESSAGE.SET_TOKEN('PARAMETER', 'AMORT_METHOD');
4424: FND_MESSAGE.SET_TOKEN('VALUE', P_CUSTOM_SET_REC.AMORT_METHOD);
4425: FND_MSG_PUB.ADD;
4426: RAISE FND_API.G_EXC_ERROR;
4427: end if;

Line 4424: FND_MESSAGE.SET_TOKEN('VALUE', P_CUSTOM_SET_REC.AMORT_METHOD);

4420:
4421: if P_CUSTOM_SET_REC.AMORT_METHOD is null then
4422: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
4423: FND_MESSAGE.SET_TOKEN('PARAMETER', 'AMORT_METHOD');
4424: FND_MESSAGE.SET_TOKEN('VALUE', P_CUSTOM_SET_REC.AMORT_METHOD);
4425: FND_MSG_PUB.ADD;
4426: RAISE FND_API.G_EXC_ERROR;
4427: end if;
4428:

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

4426: RAISE FND_API.G_EXC_ERROR;
4427: end if;
4428:
4429: if P_NEW_DUE_DATE is null then
4430: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
4431: FND_MESSAGE.SET_TOKEN('PARAMETER', 'NEW_DUE_DATE');
4432: FND_MESSAGE.SET_TOKEN('VALUE', P_NEW_DUE_DATE);
4433: FND_MSG_PUB.ADD;
4434: RAISE FND_API.G_EXC_ERROR;

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

4427: end if;
4428:
4429: if P_NEW_DUE_DATE is null then
4430: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
4431: FND_MESSAGE.SET_TOKEN('PARAMETER', 'NEW_DUE_DATE');
4432: FND_MESSAGE.SET_TOKEN('VALUE', P_NEW_DUE_DATE);
4433: FND_MSG_PUB.ADD;
4434: RAISE FND_API.G_EXC_ERROR;
4435: end if;

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

4428:
4429: if P_NEW_DUE_DATE is null then
4430: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
4431: FND_MESSAGE.SET_TOKEN('PARAMETER', 'NEW_DUE_DATE');
4432: FND_MESSAGE.SET_TOKEN('VALUE', P_NEW_DUE_DATE);
4433: FND_MSG_PUB.ADD;
4434: RAISE FND_API.G_EXC_ERROR;
4435: end if;
4436:

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

4439:
4440: filterCustSchedule(l_custom_tbl);
4441: if l_custom_tbl.count = 0 then
4442: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Custom amortization is empty.');
4443: FND_MESSAGE.SET_NAME('LNS', 'LNS_CUST_AMORT_EMPTY');
4444: FND_MSG_PUB.Add;
4445: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
4446: RAISE FND_API.G_EXC_ERROR;
4447: end if;

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

4570: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Input:');
4571: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_LOAN_ID: ' || P_LOAN_ID);
4572:
4573: if P_LOAN_ID is null then
4574: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
4575: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
4576: FND_MESSAGE.SET_TOKEN('VALUE', P_LOAN_ID);
4577: FND_MSG_PUB.ADD;
4578: RAISE FND_API.G_EXC_ERROR;

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

4571: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_LOAN_ID: ' || P_LOAN_ID);
4572:
4573: if P_LOAN_ID is null then
4574: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
4575: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
4576: FND_MESSAGE.SET_TOKEN('VALUE', P_LOAN_ID);
4577: FND_MSG_PUB.ADD;
4578: RAISE FND_API.G_EXC_ERROR;
4579: end if;

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

4572:
4573: if P_LOAN_ID is null then
4574: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
4575: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
4576: FND_MESSAGE.SET_TOKEN('VALUE', P_LOAN_ID);
4577: FND_MSG_PUB.ADD;
4578: RAISE FND_API.G_EXC_ERROR;
4579: end if;
4580:

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

4818: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_INSTALLMENT_REC.LOCK_PRIN: ' || l_INSTALLMENT_REC.LOCK_PRIN);
4819: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_INSTALLMENT_REC.LOCK_INT: ' || l_INSTALLMENT_REC.LOCK_INT);
4820:
4821: if l_INSTALLMENT_REC.LOAN_ID is null then
4822: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
4823: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
4824: FND_MESSAGE.SET_TOKEN('VALUE', l_INSTALLMENT_REC.LOAN_ID);
4825: FND_MSG_PUB.ADD;
4826: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

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

4819: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_INSTALLMENT_REC.LOCK_INT: ' || l_INSTALLMENT_REC.LOCK_INT);
4820:
4821: if l_INSTALLMENT_REC.LOAN_ID is null then
4822: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
4823: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
4824: FND_MESSAGE.SET_TOKEN('VALUE', l_INSTALLMENT_REC.LOAN_ID);
4825: FND_MSG_PUB.ADD;
4826: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
4827: RAISE FND_API.G_EXC_ERROR;

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

4820:
4821: if l_INSTALLMENT_REC.LOAN_ID is null then
4822: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
4823: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
4824: FND_MESSAGE.SET_TOKEN('VALUE', l_INSTALLMENT_REC.LOAN_ID);
4825: FND_MSG_PUB.ADD;
4826: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
4827: RAISE FND_API.G_EXC_ERROR;
4828: end if;

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

4827: RAISE FND_API.G_EXC_ERROR;
4828: end if;
4829:
4830: if l_INSTALLMENT_REC.PAYMENT_NUMBER is null then
4831: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
4832: FND_MESSAGE.SET_TOKEN('PARAMETER', 'PAYMENT_NUMBER');
4833: FND_MESSAGE.SET_TOKEN('VALUE', l_INSTALLMENT_REC.PAYMENT_NUMBER);
4834: FND_MSG_PUB.ADD;
4835: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

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

4828: end if;
4829:
4830: if l_INSTALLMENT_REC.PAYMENT_NUMBER is null then
4831: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
4832: FND_MESSAGE.SET_TOKEN('PARAMETER', 'PAYMENT_NUMBER');
4833: FND_MESSAGE.SET_TOKEN('VALUE', l_INSTALLMENT_REC.PAYMENT_NUMBER);
4834: FND_MSG_PUB.ADD;
4835: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
4836: RAISE FND_API.G_EXC_ERROR;

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

4829:
4830: if l_INSTALLMENT_REC.PAYMENT_NUMBER is null then
4831: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
4832: FND_MESSAGE.SET_TOKEN('PARAMETER', 'PAYMENT_NUMBER');
4833: FND_MESSAGE.SET_TOKEN('VALUE', l_INSTALLMENT_REC.PAYMENT_NUMBER);
4834: FND_MSG_PUB.ADD;
4835: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
4836: RAISE FND_API.G_EXC_ERROR;
4837: end if;

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

4836: RAISE FND_API.G_EXC_ERROR;
4837: end if;
4838:
4839: if l_INSTALLMENT_REC.DUE_DATE is null then
4840: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
4841: FND_MESSAGE.SET_TOKEN('PARAMETER', 'DUE_DATE');
4842: FND_MESSAGE.SET_TOKEN('VALUE', l_INSTALLMENT_REC.DUE_DATE);
4843: FND_MSG_PUB.ADD;
4844: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

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

4837: end if;
4838:
4839: if l_INSTALLMENT_REC.DUE_DATE is null then
4840: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
4841: FND_MESSAGE.SET_TOKEN('PARAMETER', 'DUE_DATE');
4842: FND_MESSAGE.SET_TOKEN('VALUE', l_INSTALLMENT_REC.DUE_DATE);
4843: FND_MSG_PUB.ADD;
4844: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
4845: RAISE FND_API.G_EXC_ERROR;

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

4838:
4839: if l_INSTALLMENT_REC.DUE_DATE is null then
4840: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
4841: FND_MESSAGE.SET_TOKEN('PARAMETER', 'DUE_DATE');
4842: FND_MESSAGE.SET_TOKEN('VALUE', l_INSTALLMENT_REC.DUE_DATE);
4843: FND_MSG_PUB.ADD;
4844: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
4845: RAISE FND_API.G_EXC_ERROR;
4846: end if;

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

5267:
5268: end if;
5269: EXCEPTION
5270: WHEN OTHERS THEN
5271: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
5272: FND_MESSAGE.SET_TOKEN('PARAMETER', l_parameter);
5273: FND_MESSAGE.SET_TOKEN('VALUE', l_element);
5274: FND_MSG_PUB.ADD;
5275: RAISE FND_API.G_EXC_ERROR;

Line 5272: FND_MESSAGE.SET_TOKEN('PARAMETER', l_parameter);

5268: end if;
5269: EXCEPTION
5270: WHEN OTHERS THEN
5271: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
5272: FND_MESSAGE.SET_TOKEN('PARAMETER', l_parameter);
5273: FND_MESSAGE.SET_TOKEN('VALUE', l_element);
5274: FND_MSG_PUB.ADD;
5275: RAISE FND_API.G_EXC_ERROR;
5276: END;

Line 5273: FND_MESSAGE.SET_TOKEN('VALUE', l_element);

5269: EXCEPTION
5270: WHEN OTHERS THEN
5271: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
5272: FND_MESSAGE.SET_TOKEN('PARAMETER', l_parameter);
5273: FND_MESSAGE.SET_TOKEN('VALUE', l_element);
5274: FND_MSG_PUB.ADD;
5275: RAISE FND_API.G_EXC_ERROR;
5276: END;
5277: end if;

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

5282:
5283: -- validation
5284: if l_record_count = 0 then
5285: if l_date_pos is null then
5286: FND_MESSAGE.Set_Name('LNS', 'LNS_NO_DUE_DATE');
5287: FND_MSG_PUB.Add;
5288: RAISE FND_API.G_EXC_ERROR;
5289: end if;
5290: else

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

5288: RAISE FND_API.G_EXC_ERROR;
5289: end if;
5290: else
5291: if l_due_date is null then
5292: FND_MESSAGE.Set_Name('LNS', 'LNS_NO_DUE_DATE');
5293: FND_MSG_PUB.Add;
5294: RAISE FND_API.G_EXC_ERROR;
5295: else
5296: