APPS.LNS_CUSTOM_PUB dependencies on FND_MSG_PUB

Line 124: FND_MSG_PUB.initialize;

120: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
121:
122: -- Initialize message list IF p_init_msg_list is set to TRUE.
123: IF FND_API.to_Boolean( p_init_msg_list ) THEN
124: FND_MSG_PUB.initialize;
125: END IF;
126:
127: -- Initialize API return status to SUCCESS
128: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 147: FND_MSG_PUB.ADD;

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:
151: -- check to see if the loan is customized

Line 161: FND_MSG_PUB.Add;

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
165: -- loan is customized

Line 174: FND_MSG_PUB.Add;

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:
178: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - deleting custom rows');

Line 211: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

207: IF FND_API.to_Boolean(p_commit) THEN
208: COMMIT WORK;
209: END IF;
210:
211: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
212:
213: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
214:
215: EXCEPTION

Line 217: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

213: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
214:
215: EXCEPTION
216: WHEN FND_API.G_EXC_ERROR THEN
217: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
218: x_return_status := FND_API.G_RET_STS_ERROR;
219: x_msg_count := l_msg_count;
220: x_msg_data := l_msg_data;
221: ROLLBACK TO resetCustomSchedule;

Line 225: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

221: ROLLBACK TO resetCustomSchedule;
222: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
223:
224: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
225: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
226: x_return_status := FND_API.G_RET_STS_ERROR;
227: x_msg_count := l_msg_count;
228: x_msg_data := l_msg_data;
229: ROLLBACK TO resetCustomSchedule;

Line 233: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

229: ROLLBACK TO resetCustomSchedule;
230: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
231:
232: WHEN OTHERS THEN
233: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
234: x_return_status := FND_API.G_RET_STS_ERROR;
235: x_msg_count := l_msg_count;
236: x_msg_data := l_msg_data;
237: ROLLBACK TO resetCustomSchedule;

Line 327: FND_MSG_PUB.initialize;

323: SAVEPOINT createCustomSchedule;
324:
325: -- Initialize message list IF p_init_msg_list is set to TRUE.
326: IF FND_API.to_Boolean( p_init_msg_list ) THEN
327: FND_MSG_PUB.initialize;
328: END IF;
329:
330: -- Initialize API return status to SUCCESS
331: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 361: FND_MSG_PUB.Add;

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');
365: FND_MSG_PUB.Add;

Line 365: FND_MSG_PUB.Add;

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:
369: open c_loan_details(p_loan_id);

Line 527: FND_MSG_PUB.Add;

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:
531: IF FND_API.to_Boolean(p_commit)

Line 536: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

532: THEN
533: COMMIT WORK;
534: END IF;
535:
536: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
537: p_data => x_msg_data);
538:
539: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
540:

Line 544: FND_MSG_PUB.Add;

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;
548:

Line 551: FND_MSG_PUB.Add;

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;
555:

Line 558: FND_MSG_PUB.Add;

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;
562:

Line 645: FND_MSG_PUB.initialize;

641: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
642:
643: -- Initialize message list IF p_init_msg_list is set to TRUE.
644: IF FND_API.to_Boolean( p_init_msg_list ) THEN
645: FND_MSG_PUB.initialize;
646: END IF;
647:
648: -- Initialize API return status to SUCCESS
649: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 690: FND_MSG_PUB.Add;

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');
694: FND_MSG_PUB.Add;

Line 694: FND_MSG_PUB.Add;

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:
698: -- now we've passed validation initialize loan_begin_balance to calculate balances

Line 748: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

744: THEN
745: COMMIT WORK;
746: END IF;
747:
748: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
749: p_data => x_msg_data);
750: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
751:
752: EXCEPTION

Line 755: --FND_MSG_PUB.Add;

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);
759: ROLLBACK TO updateCustomSchedule;

Line 763: --FND_MSG_PUB.Add;

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);
767: ROLLBACK TO updateCustomSchedule;

Line 771: --FND_MSG_PUB.Add;

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);
775: ROLLBACK TO updateCustomSchedule;

Line 842: FND_MSG_PUB.Add;

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');
846: end if;

Line 860: FND_MSG_PUB.Add;

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;
864: */

Line 877: FND_MSG_PUB.Add;

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:
881: -- check for consecutive installments

Line 886: FND_MSG_PUB.Add;

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;
890:

Line 902: FND_MSG_PUB.Add;

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;
906:

Line 921: FND_MSG_PUB.Add;

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:
925: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'after final balance check');

Line 926: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

922: RAISE FND_API.G_EXC_ERROR;
923: end if;
924:
925: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'after final balance check');
926: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
927:
928: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
929:
930: EXCEPTION

Line 934: --FND_MSG_PUB.Add;

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:
938: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 940: --FND_MSG_PUB.Add;

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:
944: WHEN OTHERS THEN

Line 946: --FND_MSG_PUB.Add;

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;
950:

Line 979: FND_MSG_PUB.Add;

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
983: FND_MESSAGE.Set_Name('LNS', 'LNS_INVALID_PAYMENT_NUMBER');

Line 984: 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
988: FND_MESSAGE.Set_Name('LNS', 'LNS_PRINICIPAL_AMOUNT_ERROR');

Line 989: 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
993: FND_MESSAGE.Set_Name('LNS', 'LNS_INTEREST_AMOUNT_ERROR');

Line 994: 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
998: FND_MESSAGE.Set_Name('LNS', 'LNS_OTHER_AMOUNT_ERROR');

Line 999: 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
1003: FND_MESSAGE.Set_Name('LNS', 'LNS_OTHER_AMOUNT_ERROR');

Line 1004: 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;
1008:

Line 1196: FND_MSG_PUB.Add;

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: */
1200: end if;

Line 1197: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

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: */
1200: end if;
1201: end loop;

Line 1319: FND_MSG_PUB.ADD;

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: /*
1323: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'RELATIVE_DATE = ' || l_custom_tbl(i).RELATIVE_DATE);

Line 1338: FND_MSG_PUB.ADD;

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: */
1342: end if;

Line 1349: FND_MSG_PUB.Add;

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:
1353: if l_custom_tbl(i).DUE_DATE < p_loan_details.loan_start_date or

Line 1371: FND_MSG_PUB.ADD_DETAIL(p_message_type => FND_MSG_PUB.G_WARNING_MSG);

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:
1375: p_custom_tbl := l_new_custom_tbl;

Line 1372: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

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:
1375: p_custom_tbl := l_new_custom_tbl;
1376: end;

Line 1786: FND_MSG_PUB.Add;

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
1790: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Err: ' || sqlerrm);

Line 1869: FND_MSG_PUB.initialize;

1865: END IF;
1866:
1867: -- Initialize message list if p_init_msg_list is set to TRUE
1868: IF FND_API.To_Boolean(p_init_msg_list) THEN
1869: FND_MSG_PUB.initialize;
1870: END IF;
1871:
1872: -- Initialize API return status to success
1873: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1885: FND_MSG_PUB.ADD;

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:
1889: if P_BASED_ON_TERMS is null then

Line 1893: FND_MSG_PUB.ADD;

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:
1897: l_loan_details := getLoanDetails(p_loan_Id => p_loan_id

Line 2054: FND_MSG_PUB.Count_And_Get(

2050: -- END OF BODY OF API
2051: x_return_status := FND_API.G_RET_STS_SUCCESS;
2052:
2053: -- Standard call to get message count and if count is 1, get message info
2054: FND_MSG_PUB.Count_And_Get(
2055: p_encoded => FND_API.G_FALSE,
2056: p_count => x_msg_count,
2057: p_data => x_msg_data);
2058:

Line 2065: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

2061: EXCEPTION
2062: WHEN FND_API.G_EXC_ERROR THEN
2063: ROLLBACK TO loadCustomSchedule;
2064: x_return_status := FND_API.G_RET_STS_ERROR;
2065: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2066: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
2067: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2068: ROLLBACK TO loadCustomSchedule;
2069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2070: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

2066: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
2067: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2068: ROLLBACK TO loadCustomSchedule;
2069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2070: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2071: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
2072: WHEN OTHERS THEN
2073: ROLLBACK TO loadCustomSchedule;
2074: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2075: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

2071: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
2072: WHEN OTHERS THEN
2073: ROLLBACK TO loadCustomSchedule;
2074: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2075: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2076: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
2077: END;
2078:
2079:

Line 2259: FND_MSG_PUB.initialize;

2255: END IF;
2256:
2257: -- Initialize message list if p_init_msg_list is set to TRUE
2258: IF FND_API.To_Boolean(p_init_msg_list) THEN
2259: FND_MSG_PUB.initialize;
2260: END IF;
2261:
2262: -- Initialize API return status to success
2263: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2278: FND_MSG_PUB.ADD;

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:
2282: if P_BASED_ON_TERMS is null then

Line 2286: FND_MSG_PUB.ADD;

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:
2290: if P_USE_RETAINED_DATA is not null and P_USE_RETAINED_DATA = 'Y' then

Line 3412: FND_MSG_PUB.ADD_DETAIL(p_message_type => FND_MSG_PUB.G_WARNING_MSG );

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:
3416: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Output Schedule:');

Line 3413: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

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:
3416: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Output Schedule:');
3417: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PN DD RATE BB UP UI PAY PRIN(%) LP INT=N+AP+AI+PL+EI+DEF+CAP LI EB ACT');

Line 3453: FND_MSG_PUB.Count_And_Get(

3449: -- END OF BODY OF API
3450: x_return_status := FND_API.G_RET_STS_SUCCESS;
3451:
3452: -- Standard call to get message count and if count is 1, get message info
3453: FND_MSG_PUB.Count_And_Get(
3454: p_encoded => FND_API.G_FALSE,
3455: p_count => x_msg_count,
3456: p_data => x_msg_data);
3457:

Line 3464: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

3460: EXCEPTION
3461: WHEN FND_API.G_EXC_ERROR THEN
3462: ROLLBACK TO recalcCustomSchedule;
3463: x_return_status := FND_API.G_RET_STS_ERROR;
3464: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3465: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
3466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3467: ROLLBACK TO recalcCustomSchedule;
3468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3469: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

3465: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
3466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3467: ROLLBACK TO recalcCustomSchedule;
3468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3469: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3470: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
3471: WHEN OTHERS THEN
3472: ROLLBACK TO recalcCustomSchedule;
3473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3474: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

3470: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
3471: WHEN OTHERS THEN
3472: ROLLBACK TO recalcCustomSchedule;
3473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3474: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3475: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
3476: END;
3477:
3478:

Line 3555: FND_MSG_PUB.initialize;

3551: END IF;
3552:
3553: -- Initialize message list if p_init_msg_list is set to TRUE
3554: IF FND_API.To_Boolean(p_init_msg_list) THEN
3555: FND_MSG_PUB.initialize;
3556: END IF;
3557:
3558: -- Initialize API return status to success
3559: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3574: FND_MSG_PUB.ADD;

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:
3578: if P_BASED_ON_TERMS is null then

Line 3582: FND_MSG_PUB.ADD;

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:
3586: if P_USE_RETAINED_DATA is not null and P_USE_RETAINED_DATA = 'Y' then

Line 3597: FND_MSG_PUB.ADD;

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:
3601: l_CUSTOM_TBL := P_CUSTOM_TBL;

Line 3742: FND_MSG_PUB.Add;

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;
3746: end if;

Line 3743: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
3746: end if;
3747:

Line 3788: FND_MSG_PUB.Add;

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;
3792:

Line 3789: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
3792:
3793: -- getting number of installments and synching rate schedule

Line 3810: FND_MSG_PUB.Add;

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:
3814: LNS_REP_UTILS.STORE_LOAN_AGREEMENT_CP(p_loan_id, l_agreement_reason);

Line 3811: l_agreement_reason := FND_MSG_PUB.Get(p_encoded => 'F');

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:
3814: LNS_REP_UTILS.STORE_LOAN_AGREEMENT_CP(p_loan_id, l_agreement_reason);
3815: end if;

Line 3812: FND_MSG_PUB.DELETE_MSG(FND_MSG_PUB.COUNT_MSG);

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:
3814: LNS_REP_UTILS.STORE_LOAN_AGREEMENT_CP(p_loan_id, l_agreement_reason);
3815: end if;
3816:

Line 3826: FND_MSG_PUB.Count_And_Get(

3822: -- END OF BODY OF API
3823: x_return_status := FND_API.G_RET_STS_SUCCESS;
3824:
3825: -- Standard call to get message count and if count is 1, get message info
3826: FND_MSG_PUB.Count_And_Get(
3827: p_encoded => FND_API.G_FALSE,
3828: p_count => x_msg_count,
3829: p_data => x_msg_data);
3830:

Line 3837: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

3833: EXCEPTION
3834: WHEN FND_API.G_EXC_ERROR THEN
3835: ROLLBACK TO saveCustomSchedule;
3836: x_return_status := FND_API.G_RET_STS_ERROR;
3837: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3838: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
3839: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3840: ROLLBACK TO saveCustomSchedule;
3841: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3842: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

3838: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
3839: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3840: ROLLBACK TO saveCustomSchedule;
3841: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3842: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3843: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
3844: WHEN OTHERS THEN
3845: ROLLBACK TO saveCustomSchedule;
3846: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3847: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

3843: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
3844: WHEN OTHERS THEN
3845: ROLLBACK TO saveCustomSchedule;
3846: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3847: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3848: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
3849: END;
3850:
3851:

Line 3905: FND_MSG_PUB.initialize;

3901: END IF;
3902:
3903: -- Initialize message list if p_init_msg_list is set to TRUE
3904: IF FND_API.To_Boolean(p_init_msg_list) THEN
3905: FND_MSG_PUB.initialize;
3906: END IF;
3907:
3908: -- Initialize API return status to success
3909: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3921: FND_MSG_PUB.ADD;

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:
3925: l_BASED_ON_TERMS := 'ORIGINATION';

Line 3960: FND_MSG_PUB.Add;

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;
3964:

Line 3961: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
3964:
3965: -- getting terms version for future update

Line 3993: FND_MSG_PUB.Add;

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;
3997:

Line 3994: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
3997:
3998: -- synching rate schedule

Line 4015: FND_MSG_PUB.Count_And_Get(

4011: -- END OF BODY OF API
4012: x_return_status := FND_API.G_RET_STS_SUCCESS;
4013:
4014: -- Standard call to get message count and if count is 1, get message info
4015: FND_MSG_PUB.Count_And_Get(
4016: p_encoded => FND_API.G_FALSE,
4017: p_count => x_msg_count,
4018: p_data => x_msg_data);
4019:

Line 4026: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

4022: EXCEPTION
4023: WHEN FND_API.G_EXC_ERROR THEN
4024: ROLLBACK TO uncustomizeSchedule;
4025: x_return_status := FND_API.G_RET_STS_ERROR;
4026: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4027: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
4028: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4029: ROLLBACK TO uncustomizeSchedule;
4030: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4031: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

4027: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
4028: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4029: ROLLBACK TO uncustomizeSchedule;
4030: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4031: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4032: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
4033: WHEN OTHERS THEN
4034: ROLLBACK TO uncustomizeSchedule;
4035: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4036: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

4032: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
4033: WHEN OTHERS THEN
4034: ROLLBACK TO uncustomizeSchedule;
4035: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4036: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4037: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
4038: END;
4039:
4040:

Line 4135: FND_MSG_PUB.initialize;

4131: END IF;
4132:
4133: -- Initialize message list if p_init_msg_list is set to TRUE
4134: IF FND_API.To_Boolean(p_init_msg_list) THEN
4135: FND_MSG_PUB.initialize;
4136: END IF;
4137:
4138: -- Initialize API return status to success
4139: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4150: FND_MSG_PUB.ADD;

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:
4154: parseClob(

Line 4229: FND_MSG_PUB.Count_And_Get(

4225: -- END OF BODY OF API
4226: x_return_status := FND_API.G_RET_STS_SUCCESS;
4227:
4228: -- Standard call to get message count and if count is 1, get message info
4229: FND_MSG_PUB.Count_And_Get(
4230: p_encoded => FND_API.G_FALSE,
4231: p_count => x_msg_count,
4232: p_data => x_msg_data);
4233:

Line 4240: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

4236: EXCEPTION
4237: WHEN FND_API.G_EXC_ERROR THEN
4238: ROLLBACK TO customizeSchedule;
4239: x_return_status := FND_API.G_RET_STS_ERROR;
4240: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4241: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
4242: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4243: ROLLBACK TO customizeSchedule;
4244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4245: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

4241: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
4242: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4243: ROLLBACK TO customizeSchedule;
4244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4245: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4246: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
4247: WHEN OTHERS THEN
4248: ROLLBACK TO customizeSchedule;
4249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4250: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

4246: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
4247: WHEN OTHERS THEN
4248: ROLLBACK TO customizeSchedule;
4249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4250: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4251: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
4252: END;
4253:
4254:

Line 4389: FND_MSG_PUB.initialize;

4385: END IF;
4386:
4387: -- Initialize message list if p_init_msg_list is set to TRUE
4388: IF FND_API.To_Boolean(p_init_msg_list) THEN
4389: FND_MSG_PUB.initialize;
4390: END IF;
4391:
4392: -- Initialize API return status to success
4393: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4409: FND_MSG_PUB.ADD;

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:
4413: if P_BASED_ON_TERMS is null then

Line 4417: FND_MSG_PUB.ADD;

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:
4421: if P_CUSTOM_SET_REC.AMORT_METHOD is null then

Line 4425: FND_MSG_PUB.ADD;

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:
4429: if P_NEW_DUE_DATE is null then

Line 4433: FND_MSG_PUB.ADD;

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:
4437: l_CUSTOM_TBL := P_CUSTOM_TBL;

Line 4444: FND_MSG_PUB.Add;

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;
4448:

Line 4445: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
4448:
4449: l_return := shiftRowsByDate(P_OLD_DUE_DATE => P_OLD_DUE_DATE,

Line 4486: FND_MSG_PUB.Count_And_Get(

4482: -- END OF BODY OF API
4483: x_return_status := FND_API.G_RET_STS_SUCCESS;
4484:
4485: -- Standard call to get message count and if count is 1, get message info
4486: FND_MSG_PUB.Count_And_Get(
4487: p_encoded => FND_API.G_FALSE,
4488: p_count => x_msg_count,
4489: p_data => x_msg_data);
4490:

Line 4497: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

4493: EXCEPTION
4494: WHEN FND_API.G_EXC_ERROR THEN
4495: ROLLBACK TO shiftCustomSchedule;
4496: x_return_status := FND_API.G_RET_STS_ERROR;
4497: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4498: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
4499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4500: ROLLBACK TO shiftCustomSchedule;
4501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4502: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

4498: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
4499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4500: ROLLBACK TO shiftCustomSchedule;
4501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4502: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4503: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
4504: WHEN OTHERS THEN
4505: ROLLBACK TO shiftCustomSchedule;
4506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4507: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

4503: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
4504: WHEN OTHERS THEN
4505: ROLLBACK TO shiftCustomSchedule;
4506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4507: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4508: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
4509: END;
4510:
4511:

Line 4562: FND_MSG_PUB.initialize;

4558: END IF;
4559:
4560: -- Initialize message list if p_init_msg_list is set to TRUE
4561: IF FND_API.To_Boolean(p_init_msg_list) THEN
4562: FND_MSG_PUB.initialize;
4563: END IF;
4564:
4565: -- Initialize API return status to success
4566: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4577: FND_MSG_PUB.ADD;

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:
4581: l_BASED_ON_TERMS := 'ORIGINATION';

Line 4610: FND_MSG_PUB.Count_And_Get(

4606: -- END OF BODY OF API
4607: x_return_status := FND_API.G_RET_STS_SUCCESS;
4608:
4609: -- Standard call to get message count and if count is 1, get message info
4610: FND_MSG_PUB.Count_And_Get(
4611: p_encoded => FND_API.G_FALSE,
4612: p_count => x_msg_count,
4613: p_data => x_msg_data);
4614:

Line 4621: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

4617: EXCEPTION
4618: WHEN FND_API.G_EXC_ERROR THEN
4619: ROLLBACK TO reBuildCustomdSchedule;
4620: x_return_status := FND_API.G_RET_STS_ERROR;
4621: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4622: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
4623: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4624: ROLLBACK TO reBuildCustomdSchedule;
4625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4626: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

4622: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
4623: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4624: ROLLBACK TO reBuildCustomdSchedule;
4625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4626: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4627: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
4628: WHEN OTHERS THEN
4629: ROLLBACK TO reBuildCustomdSchedule;
4630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4631: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

4627: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
4628: WHEN OTHERS THEN
4629: ROLLBACK TO reBuildCustomdSchedule;
4630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4631: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4632: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
4633: END;
4634:
4635:

Line 4801: FND_MSG_PUB.initialize;

4797: END IF;
4798:
4799: -- Initialize message list if p_init_msg_list is set to TRUE
4800: IF FND_API.To_Boolean(p_init_msg_list) THEN
4801: FND_MSG_PUB.initialize;
4802: END IF;
4803:
4804: -- Initialize API return status to success
4805: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

Line 4825: FND_MSG_PUB.ADD;

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;
4829:

Line 4826: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
4829:
4830: if l_INSTALLMENT_REC.PAYMENT_NUMBER is null then

Line 4834: FND_MSG_PUB.ADD;

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;
4838:

Line 4835: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
4838:
4839: if l_INSTALLMENT_REC.DUE_DATE is null then

Line 4843: FND_MSG_PUB.ADD;

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;
4847:

Line 4844: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
4847:
4848: open c_exist_installment(l_INSTALLMENT_REC.LOAN_ID, l_INSTALLMENT_REC.PAYMENT_NUMBER);

Line 4912: FND_MSG_PUB.Count_And_Get(

4908: -- END OF BODY OF API
4909: x_return_status := FND_API.G_RET_STS_SUCCESS;
4910:
4911: -- Standard call to get message count and if count is 1, get message info
4912: FND_MSG_PUB.Count_And_Get(
4913: p_encoded => FND_API.G_FALSE,
4914: p_count => x_msg_count,
4915: p_data => x_msg_data);
4916:

Line 4923: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

4919: EXCEPTION
4920: WHEN FND_API.G_EXC_ERROR THEN
4921: ROLLBACK TO addMissingInstallment;
4922: x_return_status := FND_API.G_RET_STS_ERROR;
4923: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4924: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
4925: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4926: ROLLBACK TO addMissingInstallment;
4927: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4928: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

4924: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
4925: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4926: ROLLBACK TO addMissingInstallment;
4927: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4928: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4929: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
4930: WHEN OTHERS THEN
4931: ROLLBACK TO addMissingInstallment;
4932: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4933: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

4929: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
4930: WHEN OTHERS THEN
4931: ROLLBACK TO addMissingInstallment;
4932: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4933: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4934: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
4935: END;
4936:
4937:

Line 5071: FND_MSG_PUB.initialize;

5067: END IF;
5068:
5069: -- Initialize message list if p_init_msg_list is set to TRUE
5070: IF FND_API.To_Boolean(p_init_msg_list) THEN
5071: FND_MSG_PUB.initialize;
5072: END IF;
5073:
5074: -- Initialize API return status to success
5075: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5274: FND_MSG_PUB.ADD;

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;
5278:

Line 5287: FND_MSG_PUB.Add;

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
5291: if l_due_date is null then

Line 5293: FND_MSG_PUB.Add;

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:
5297: BEGIN

Line 5405: FND_MSG_PUB.Count_And_Get(

5401: -- END OF BODY OF API
5402: x_return_status := FND_API.G_RET_STS_SUCCESS;
5403:
5404: -- Standard call to get message count and if count is 1, get message info
5405: FND_MSG_PUB.Count_And_Get(
5406: p_encoded => FND_API.G_FALSE,
5407: p_count => x_msg_count,
5408: p_data => x_msg_data);
5409:

Line 5416: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

5412: EXCEPTION
5413: WHEN OTHERS THEN
5414: ROLLBACK TO parseClob;
5415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5416: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5417: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
5418: END;
5419:
5420: