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_EXT_LOAN_PUB dependencies on FND_MSG_PUB

Line 141: FND_MSG_PUB.Add;

137: then
138:
139: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Not all required data is set.');
140: FND_MESSAGE.SET_NAME('LNS', 'LNS_EXTN_NO_REQ_PAR');
141: FND_MSG_PUB.Add;
142: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
143: RAISE FND_API.G_EXC_ERROR;
144:
145: end if;

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

138:
139: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Not all required data is set.');
140: FND_MESSAGE.SET_NAME('LNS', 'LNS_EXTN_NO_REQ_PAR');
141: FND_MSG_PUB.Add;
142: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
143: RAISE FND_API.G_EXC_ERROR;
144:
145: end if;
146:

Line 163: FND_MSG_PUB.Add;

159: P_LOAN_EXT_REC.EXT_IO_FLAG is null) then
160:
161: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Not all required data is set.');
162: FND_MESSAGE.SET_NAME('LNS', 'LNS_EXTN_NO_REQ_PAR');
163: FND_MSG_PUB.Add;
164: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
165: RAISE FND_API.G_EXC_ERROR;
166:
167: end if;

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

160:
161: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Not all required data is set.');
162: FND_MESSAGE.SET_NAME('LNS', 'LNS_EXTN_NO_REQ_PAR');
163: FND_MSG_PUB.Add;
164: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
165: RAISE FND_API.G_EXC_ERROR;
166:
167: end if;
168:

Line 182: FND_MSG_PUB.Add;

178: l_loan_status <> 'IN_FUNDING') then
179:
180: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Invalid loan status.');
181: FND_MESSAGE.SET_NAME('LNS', 'LNS_EXTN_INVAL_LN_STATUS');
182: FND_MSG_PUB.Add;
183: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
184: RAISE FND_API.G_EXC_ERROR;
185:
186: end if;

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

179:
180: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Invalid loan status.');
181: FND_MESSAGE.SET_NAME('LNS', 'LNS_EXTN_INVAL_LN_STATUS');
182: FND_MSG_PUB.Add;
183: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
184: RAISE FND_API.G_EXC_ERROR;
185:
186: end if;
187:

Line 196: FND_MSG_PUB.Add;

192: if (l_extn_count > 0) then
193:
194: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: A pending extension for this loan already exists.');
195: FND_MESSAGE.SET_NAME('LNS', 'LNS_EXTN_ALREADY_EXTN');
196: FND_MSG_PUB.Add;
197: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
198: RAISE FND_API.G_EXC_ERROR;
199:
200: end if;

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

193:
194: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: A pending extension for this loan already exists.');
195: FND_MESSAGE.SET_NAME('LNS', 'LNS_EXTN_ALREADY_EXTN');
196: FND_MSG_PUB.Add;
197: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
198: RAISE FND_API.G_EXC_ERROR;
199:
200: end if;
201:

Line 213: FND_MSG_PUB.Add;

209: l_loan_status <> 'IN_FUNDING') then
210:
211: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Invalid loan status.');
212: FND_MESSAGE.SET_NAME('LNS', 'LNS_EXTN_INVAL_LN_STATUS');
213: FND_MSG_PUB.Add;
214: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
215: RAISE FND_API.G_EXC_ERROR;
216:
217: end if;

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

210:
211: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Invalid loan status.');
212: FND_MESSAGE.SET_NAME('LNS', 'LNS_EXTN_INVAL_LN_STATUS');
213: FND_MSG_PUB.Add;
214: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
215: RAISE FND_API.G_EXC_ERROR;
216:
217: end if;
218:

Line 227: FND_MSG_PUB.Add;

223: if (l_extn_status <> 'PENDING') then
224:
225: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Invalid loan extension.');
226: FND_MESSAGE.SET_NAME('LNS', 'LNS_EXTN_INVAL_EXTN');
227: FND_MSG_PUB.Add;
228: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
229: RAISE FND_API.G_EXC_ERROR;
230:
231: end if;

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

224:
225: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Invalid loan extension.');
226: FND_MESSAGE.SET_NAME('LNS', 'LNS_EXTN_INVAL_EXTN');
227: FND_MSG_PUB.Add;
228: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
229: RAISE FND_API.G_EXC_ERROR;
230:
231: end if;
232:

Line 388: FND_MSG_PUB.Add;

384: then
385:
386: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Not all required data is set.');
387: FND_MESSAGE.SET_NAME('LNS', 'LNS_EXTN_NO_REQ_PAR');
388: FND_MSG_PUB.Add;
389: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
390: RAISE FND_API.G_EXC_ERROR;
391:
392: end if;

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

385:
386: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Not all required data is set.');
387: FND_MESSAGE.SET_NAME('LNS', 'LNS_EXTN_NO_REQ_PAR');
388: FND_MSG_PUB.Add;
389: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
390: RAISE FND_API.G_EXC_ERROR;
391:
392: end if;
393:

Line 403: FND_MSG_PUB.Add;

399: then
400:
401: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Not all required data is set.');
402: FND_MESSAGE.SET_NAME('LNS', 'LNS_EXTN_NO_REQ_PAR');
403: FND_MSG_PUB.Add;
404: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
405: RAISE FND_API.G_EXC_ERROR;
406:
407: end if;

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

400:
401: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Not all required data is set.');
402: FND_MESSAGE.SET_NAME('LNS', 'LNS_EXTN_NO_REQ_PAR');
403: FND_MSG_PUB.Add;
404: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
405: RAISE FND_API.G_EXC_ERROR;
406:
407: end if;
408:

Line 420: FND_MSG_PUB.Add;

416: l_loan_status <> 'IN_FUNDING') then
417:
418: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Invalid loan status.');
419: FND_MESSAGE.SET_NAME('LNS', 'LNS_EXTN_INVAL_LN_STATUS');
420: FND_MSG_PUB.Add;
421: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
422: RAISE FND_API.G_EXC_ERROR;
423:
424: end if;

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

417:
418: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Invalid loan status.');
419: FND_MESSAGE.SET_NAME('LNS', 'LNS_EXTN_INVAL_LN_STATUS');
420: FND_MSG_PUB.Add;
421: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
422: RAISE FND_API.G_EXC_ERROR;
423:
424: end if;
425:

Line 430: FND_MSG_PUB.Add;

426: if (l_STATUS <> 'PENDING') then
427:
428: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Invalid loan extension.');
429: FND_MESSAGE.SET_NAME('LNS', 'LNS_EXTN_INVAL_EXTN');
430: FND_MSG_PUB.Add;
431: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
432: RAISE FND_API.G_EXC_ERROR;
433:
434: end if;

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

427:
428: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Invalid loan extension.');
429: FND_MESSAGE.SET_NAME('LNS', 'LNS_EXTN_INVAL_EXTN');
430: FND_MSG_PUB.Add;
431: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
432: RAISE FND_API.G_EXC_ERROR;
433:
434: end if;
435:

Line 447: FND_MSG_PUB.Add;

443: l_loan_status <> 'IN_FUNDING') then
444:
445: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Invalid loan status.');
446: FND_MESSAGE.SET_NAME('LNS', 'LNS_EXTN_INVAL_LN_STATUS');
447: FND_MSG_PUB.Add;
448: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
449: RAISE FND_API.G_EXC_ERROR;
450:
451: end if;

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

444:
445: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Invalid loan status.');
446: FND_MESSAGE.SET_NAME('LNS', 'LNS_EXTN_INVAL_LN_STATUS');
447: FND_MSG_PUB.Add;
448: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
449: RAISE FND_API.G_EXC_ERROR;
450:
451: end if;
452:

Line 457: FND_MSG_PUB.Add;

453: if (l_STATUS <> 'PENDING') then
454:
455: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Invalid loan extension.');
456: FND_MESSAGE.SET_NAME('LNS', 'LNS_EXTN_INVAL_EXTN');
457: FND_MSG_PUB.Add;
458: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
459: RAISE FND_API.G_EXC_ERROR;
460:
461: end if;

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

454:
455: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Invalid loan extension.');
456: FND_MESSAGE.SET_NAME('LNS', 'LNS_EXTN_INVAL_EXTN');
457: FND_MSG_PUB.Add;
458: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
459: RAISE FND_API.G_EXC_ERROR;
460:
461: end if;
462:

Line 547: FND_MSG_PUB.initialize;

543: END IF;
544:
545: -- Initialize message list if p_init_msg_list is set to TRUE
546: IF FND_API.To_Boolean(p_init_msg_list) THEN
547: FND_MSG_PUB.initialize;
548: END IF;
549:
550: -- Initialize API return status to success
551: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 747: FND_MSG_PUB.Count_And_Get(

743:
744: x_return_status := FND_API.G_RET_STS_SUCCESS;
745:
746: -- Standard call to get message count and if count is 1, get message info
747: FND_MSG_PUB.Count_And_Get(
748: p_encoded => FND_API.G_FALSE,
749: p_count => x_msg_count,
750: p_data => x_msg_data);
751:

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

754: EXCEPTION
755: WHEN FND_API.G_EXC_ERROR THEN
756: ROLLBACK TO SAVE_LOAN_EXTENSION;
757: x_return_status := FND_API.G_RET_STS_ERROR;
758: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
759: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
760: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
761: ROLLBACK TO SAVE_LOAN_EXTENSION;
762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

759: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
760: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
761: ROLLBACK TO SAVE_LOAN_EXTENSION;
762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
763: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
764: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
765: WHEN OTHERS THEN
766: ROLLBACK TO SAVE_LOAN_EXTENSION;
767: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 768: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN

764: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
765: WHEN OTHERS THEN
766: ROLLBACK TO SAVE_LOAN_EXTENSION;
767: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
768: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
769: FND_MSG_PUB.Add_Exc_Msg(l_api_name);
770: END IF;
771: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
772: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');

Line 769: FND_MSG_PUB.Add_Exc_Msg(l_api_name);

765: WHEN OTHERS THEN
766: ROLLBACK TO SAVE_LOAN_EXTENSION;
767: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
768: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
769: FND_MSG_PUB.Add_Exc_Msg(l_api_name);
770: END IF;
771: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
772: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
773: END;

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

767: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
768: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
769: FND_MSG_PUB.Add_Exc_Msg(l_api_name);
770: END IF;
771: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
772: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
773: END;
774:
775:

Line 926: -- FND_MSG_PUB.initialize;

922: END IF;
923:
924: -- Initialize message list if p_init_msg_list is set to TRUE
925: --IF FND_API.To_Boolean(p_init_msg_list) THEN
926: -- FND_MSG_PUB.initialize;
927: --END IF;
928:
929: -- Initialize API return status to success
930: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1165: FND_MSG_PUB.Count_And_Get(

1161:
1162: x_return_status := FND_API.G_RET_STS_SUCCESS;
1163:
1164: -- Standard call to get message count and if count is 1, get message info
1165: FND_MSG_PUB.Count_And_Get(
1166: p_encoded => FND_API.G_FALSE,
1167: p_count => x_msg_count,
1168: p_data => x_msg_data);
1169:

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

1172: EXCEPTION
1173: WHEN FND_API.G_EXC_ERROR THEN
1174: ROLLBACK TO APPROVE_LOAN_EXTENSION;
1175: x_return_status := FND_API.G_RET_STS_ERROR;
1176: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1177: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
1178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1179: ROLLBACK TO APPROVE_LOAN_EXTENSION;
1180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1177: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
1178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1179: ROLLBACK TO APPROVE_LOAN_EXTENSION;
1180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1181: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1182: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
1183: WHEN OTHERS THEN
1184: ROLLBACK TO APPROVE_LOAN_EXTENSION;
1185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1186: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN

1182: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
1183: WHEN OTHERS THEN
1184: ROLLBACK TO APPROVE_LOAN_EXTENSION;
1185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1186: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
1187: FND_MSG_PUB.Add_Exc_Msg(l_api_name);
1188: END IF;
1189: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1190: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');

Line 1187: FND_MSG_PUB.Add_Exc_Msg(l_api_name);

1183: WHEN OTHERS THEN
1184: ROLLBACK TO APPROVE_LOAN_EXTENSION;
1185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1186: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
1187: FND_MSG_PUB.Add_Exc_Msg(l_api_name);
1188: END IF;
1189: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1190: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
1191: END;

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

1185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1186: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
1187: FND_MSG_PUB.Add_Exc_Msg(l_api_name);
1188: END IF;
1189: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1190: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
1191: END;
1192:
1193:

Line 1268: -- FND_MSG_PUB.initialize;

1264: END IF;
1265:
1266: -- Initialize message list if p_init_msg_list is set to TRUE
1267: --IF FND_API.To_Boolean(p_init_msg_list) THEN
1268: -- FND_MSG_PUB.initialize;
1269: --END IF;
1270:
1271: -- Initialize API return status to success
1272: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1301: FND_MSG_PUB.Count_And_Get(

1297:
1298: x_return_status := FND_API.G_RET_STS_SUCCESS;
1299:
1300: -- Standard call to get message count and if count is 1, get message info
1301: FND_MSG_PUB.Count_And_Get(
1302: p_encoded => FND_API.G_FALSE,
1303: p_count => x_msg_count,
1304: p_data => x_msg_data);
1305:

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

1308: EXCEPTION
1309: WHEN FND_API.G_EXC_ERROR THEN
1310: ROLLBACK TO REJECT_LOAN_EXTENSION;
1311: x_return_status := FND_API.G_RET_STS_ERROR;
1312: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1313: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
1314: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1315: ROLLBACK TO REJECT_LOAN_EXTENSION;
1316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1313: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
1314: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1315: ROLLBACK TO REJECT_LOAN_EXTENSION;
1316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1317: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1318: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
1319: WHEN OTHERS THEN
1320: ROLLBACK TO REJECT_LOAN_EXTENSION;
1321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1322: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN

1318: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
1319: WHEN OTHERS THEN
1320: ROLLBACK TO REJECT_LOAN_EXTENSION;
1321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1322: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
1323: FND_MSG_PUB.Add_Exc_Msg(l_api_name);
1324: END IF;
1325: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1326: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');

Line 1323: FND_MSG_PUB.Add_Exc_Msg(l_api_name);

1319: WHEN OTHERS THEN
1320: ROLLBACK TO REJECT_LOAN_EXTENSION;
1321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1322: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
1323: FND_MSG_PUB.Add_Exc_Msg(l_api_name);
1324: END IF;
1325: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1326: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
1327: END;

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

1321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1322: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
1323: FND_MSG_PUB.Add_Exc_Msg(l_api_name);
1324: END IF;
1325: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1326: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
1327: END;
1328:
1329:

Line 1467: -- FND_MSG_PUB.initialize;

1463: END IF;
1464:
1465: -- Initialize message list if p_init_msg_list is set to TRUE
1466: --IF FND_API.To_Boolean(p_init_msg_list) THEN
1467: -- FND_MSG_PUB.initialize;
1468: --END IF;
1469:
1470: -- Initialize API return status to success
1471: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1684: FND_MSG_PUB.Add;

1680: if (P_NEW_TERM_REC.NEW_AMORT_TERM < P_NEW_TERM_REC.NEW_TERM) then
1681:
1682: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Loan amortized term cannot be less than loan term.');
1683: FND_MESSAGE.SET_NAME('LNS', 'LNS_LOAN_TERM_INVALID');
1684: FND_MSG_PUB.Add;
1685: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1686: RAISE FND_API.G_EXC_ERROR;
1687:
1688: end if;

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

1681:
1682: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Loan amortized term cannot be less than loan term.');
1683: FND_MESSAGE.SET_NAME('LNS', 'LNS_LOAN_TERM_INVALID');
1684: FND_MSG_PUB.Add;
1685: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1686: RAISE FND_API.G_EXC_ERROR;
1687:
1688: end if;
1689:

Line 1700: FND_MSG_PUB.Count_And_Get(

1696: */
1697: x_return_status := FND_API.G_RET_STS_SUCCESS;
1698:
1699: -- Standard call to get message count and if count is 1, get message info
1700: FND_MSG_PUB.Count_And_Get(
1701: p_encoded => FND_API.G_FALSE,
1702: p_count => x_msg_count,
1703: p_data => x_msg_data);
1704:

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

1707: EXCEPTION
1708: WHEN FND_API.G_EXC_ERROR THEN
1709: --ROLLBACK TO CALC_NEW_TERMS;
1710: x_return_status := FND_API.G_RET_STS_ERROR;
1711: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1712: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'In exception');
1713: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1714: --ROLLBACK TO CALC_NEW_TERMS;
1715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1712: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'In exception');
1713: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1714: --ROLLBACK TO CALC_NEW_TERMS;
1715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1716: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1717: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'In exception');
1718: WHEN OTHERS THEN
1719: --ROLLBACK TO CALC_NEW_TERMS;
1720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1721: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN

1717: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'In exception');
1718: WHEN OTHERS THEN
1719: --ROLLBACK TO CALC_NEW_TERMS;
1720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1721: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
1722: FND_MSG_PUB.Add_Exc_Msg(l_api_name);
1723: END IF;
1724: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1725: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'In exception');

Line 1722: FND_MSG_PUB.Add_Exc_Msg(l_api_name);

1718: WHEN OTHERS THEN
1719: --ROLLBACK TO CALC_NEW_TERMS;
1720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1721: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
1722: FND_MSG_PUB.Add_Exc_Msg(l_api_name);
1723: END IF;
1724: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1725: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'In exception');
1726: END;

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

1720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1721: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
1722: FND_MSG_PUB.Add_Exc_Msg(l_api_name);
1723: END IF;
1724: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1725: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'In exception');
1726: END;
1727:
1728: