DBA Data[Home] [Help]

APPS.LNS_XLA_EVENTS dependencies on FND_API

Line 142: IF FND_API.to_Boolean(p_init_msg_list) THEN

138: -- Standard Start of API savepoint
139: SAVEPOINT create_event;
140:
141: -- Initialize message list IF p_init_msg_list is set to TRUE.
142: IF FND_API.to_Boolean(p_init_msg_list) THEN
143: FND_MSG_PUB.initialize;
144: END IF;
145:
146: -- Initialize API return status to SUCCESS

Line 147: x_return_status := FND_API.G_RET_STS_SUCCESS;

143: FND_MSG_PUB.initialize;
144: END IF;
145:
146: -- Initialize API return status to SUCCESS
147: x_return_status := FND_API.G_RET_STS_SUCCESS;
148:
149: -- ---------------------------------------------------------------------
150: -- Api body
151: -- ---------------------------------------------------------------------

Line 170: RAISE FND_API.G_EXC_ERROR;

166: if p_disb_header_id is null then
167: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
168: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_api_name || ' SQLERRM: ' || SQLERRM);
169: FND_MSG_PUB.ADD;
170: RAISE FND_API.G_EXC_ERROR;
171: end if;
172:
173: -- initialize any variables here
174: l_loan_details.application_id := 206; -- XLA registered application

Line 213: RAISE FND_API.G_EXC_ERROR;

209: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
210: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed to create Loans XLA event ' || p_event_type_code);
211: FND_MSG_PUB.ADD;
212: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
213: RAISE FND_API.G_EXC_ERROR;
214: end if;
215: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully created Loans XLA event ' || p_event_type_code);
216: else
217: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Event already exists');

Line 235: RAISE FND_API.G_EXC_ERROR;

231: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
232: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed to find Loans XLA event ' || p_event_type_code);
233: FND_MSG_PUB.ADD;
234: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
235: RAISE FND_API.G_EXC_ERROR;
236: end if;
237: end if;
238:
239: -- ---------------------------------------------------------------------

Line 247: WHEN FND_API.G_EXC_ERROR THEN

243:
244: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
245:
246: EXCEPTION
247: WHEN FND_API.G_EXC_ERROR THEN
248: x_return_status := FND_API.G_RET_STS_ERROR;
249: x_msg_count := l_msg_count;
250: x_msg_data := l_msg_data;
251: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 248: x_return_status := FND_API.G_RET_STS_ERROR;

244: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
245:
246: EXCEPTION
247: WHEN FND_API.G_EXC_ERROR THEN
248: x_return_status := FND_API.G_RET_STS_ERROR;
249: x_msg_count := l_msg_count;
250: x_msg_data := l_msg_data;
251: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
252: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

251: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
252: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
253: ROLLBACK TO create_event;
254:
255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
256: x_return_status := FND_API.G_RET_STS_ERROR;
257: x_msg_count := l_msg_count;
258: x_msg_data := l_msg_data;
259: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 256: x_return_status := FND_API.G_RET_STS_ERROR;

252: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
253: ROLLBACK TO create_event;
254:
255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
256: x_return_status := FND_API.G_RET_STS_ERROR;
257: x_msg_count := l_msg_count;
258: x_msg_data := l_msg_data;
259: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
260: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 264: x_return_status := FND_API.G_RET_STS_ERROR;

260: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
261: ROLLBACK TO create_event;
262:
263: WHEN OTHERS THEN
264: x_return_status := FND_API.G_RET_STS_ERROR;
265: x_msg_count := l_msg_count;
266: x_msg_data := l_msg_data;
267: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
268: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 348: IF FND_API.to_Boolean(p_init_msg_list) THEN

344: -- Standard Start of API savepoint
345: SAVEPOINT update_event;
346:
347: -- Initialize message list IF p_init_msg_list is set to TRUE.
348: IF FND_API.to_Boolean(p_init_msg_list) THEN
349: FND_MSG_PUB.initialize;
350: END IF;
351:
352: -- Initialize API return status to SUCCESS

Line 353: x_return_status := FND_API.G_RET_STS_SUCCESS;

349: FND_MSG_PUB.initialize;
350: END IF;
351:
352: -- Initialize API return status to SUCCESS
353: x_return_status := FND_API.G_RET_STS_SUCCESS;
354:
355: -- ---------------------------------------------------------------------
356: -- Api body
357: -- ---------------------------------------------------------------------

Line 398: WHEN FND_API.G_EXC_ERROR THEN

394:
395: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
396:
397: EXCEPTION
398: WHEN FND_API.G_EXC_ERROR THEN
399: x_return_status := FND_API.G_RET_STS_ERROR;
400: x_msg_count := l_msg_count;
401: x_msg_data := l_msg_data;
402: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 399: x_return_status := FND_API.G_RET_STS_ERROR;

395: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
396:
397: EXCEPTION
398: WHEN FND_API.G_EXC_ERROR THEN
399: x_return_status := FND_API.G_RET_STS_ERROR;
400: x_msg_count := l_msg_count;
401: x_msg_data := l_msg_data;
402: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
403: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 406: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

402: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
403: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
404: ROLLBACK TO update_event;
405:
406: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
407: x_return_status := FND_API.G_RET_STS_ERROR;
408: x_msg_count := l_msg_count;
409: x_msg_data := l_msg_data;
410: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 407: x_return_status := FND_API.G_RET_STS_ERROR;

403: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
404: ROLLBACK TO update_event;
405:
406: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
407: x_return_status := FND_API.G_RET_STS_ERROR;
408: x_msg_count := l_msg_count;
409: x_msg_data := l_msg_data;
410: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
411: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 415: x_return_status := FND_API.G_RET_STS_ERROR;

411: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
412: ROLLBACK TO update_event;
413:
414: WHEN OTHERS THEN
415: x_return_status := FND_API.G_RET_STS_ERROR;
416: x_msg_count := l_msg_count;
417: x_msg_data := l_msg_data;
418: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
419: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 485: IF FND_API.to_Boolean(p_init_msg_list) THEN

481: -- Standard Start of API savepoint
482: SAVEPOINT delete_event;
483:
484: -- Initialize message list IF p_init_msg_list is set to TRUE.
485: IF FND_API.to_Boolean(p_init_msg_list) THEN
486: FND_MSG_PUB.initialize;
487: END IF;
488:
489: -- Initialize API return status to SUCCESS

Line 490: x_return_status := FND_API.G_RET_STS_SUCCESS;

486: FND_MSG_PUB.initialize;
487: END IF;
488:
489: -- Initialize API return status to SUCCESS
490: x_return_status := FND_API.G_RET_STS_SUCCESS;
491:
492: -- ---------------------------------------------------------------------
493: -- Api body
494: -- ---------------------------------------------------------------------

Line 534: WHEN FND_API.G_EXC_ERROR THEN

530:
531: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
532:
533: EXCEPTION
534: WHEN FND_API.G_EXC_ERROR THEN
535: x_return_status := FND_API.G_RET_STS_ERROR;
536: x_msg_count := l_msg_count;
537: x_msg_data := l_msg_data;
538: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 535: x_return_status := FND_API.G_RET_STS_ERROR;

531: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
532:
533: EXCEPTION
534: WHEN FND_API.G_EXC_ERROR THEN
535: x_return_status := FND_API.G_RET_STS_ERROR;
536: x_msg_count := l_msg_count;
537: x_msg_data := l_msg_data;
538: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
539: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 542: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

538: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
539: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
540: ROLLBACK TO delete_event;
541:
542: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
543: x_return_status := FND_API.G_RET_STS_ERROR;
544: x_msg_count := l_msg_count;
545: x_msg_data := l_msg_data;
546: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 543: x_return_status := FND_API.G_RET_STS_ERROR;

539: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
540: ROLLBACK TO delete_event;
541:
542: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
543: x_return_status := FND_API.G_RET_STS_ERROR;
544: x_msg_count := l_msg_count;
545: x_msg_data := l_msg_data;
546: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
547: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 551: x_return_status := FND_API.G_RET_STS_ERROR;

547: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
548: ROLLBACK TO delete_event;
549:
550: WHEN OTHERS THEN
551: x_return_status := FND_API.G_RET_STS_ERROR;
552: x_msg_count := l_msg_count;
553: x_msg_data := l_msg_data;
554: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
555: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);