DBA Data[Home] [Help]

APPS.LNS_XLA_EVENTS dependencies on FND_API

Line 171: IF FND_API.to_Boolean(p_init_msg_list) THEN

167: -- Standard Start of API savepoint
168: SAVEPOINT create_event;
169:
170: -- Initialize message list IF p_init_msg_list is set to TRUE.
171: IF FND_API.to_Boolean(p_init_msg_list) THEN
172: FND_MSG_PUB.initialize;
173: END IF;
174:
175: -- Initialize API return status to SUCCESS

Line 176: x_return_status := FND_API.G_RET_STS_SUCCESS;

172: FND_MSG_PUB.initialize;
173: END IF;
174:
175: -- Initialize API return status to SUCCESS
176: x_return_status := FND_API.G_RET_STS_SUCCESS;
177:
178: -- ---------------------------------------------------------------------
179: -- Api body
180: -- ---------------------------------------------------------------------

Line 199: RAISE FND_API.G_EXC_ERROR;

195: if (p_disb_header_id is null and p_loan_amount_adj_id is null and p_loan_line_id is null)then
196: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
197: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_api_name || ' SQLERRM: ' || SQLERRM);
198: FND_MSG_PUB.ADD;
199: RAISE FND_API.G_EXC_ERROR;
200: end if;
201:
202: -- initialize any variables here
203: l_loan_details.application_id := 206; -- XLA registered application

Line 252: RAISE FND_API.G_EXC_ERROR;

248: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
249: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed to create Loans XLA event ' || p_event_type_code);
250: FND_MSG_PUB.ADD;
251: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
252: RAISE FND_API.G_EXC_ERROR;
253: end if;
254: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully created Loans XLA event ' || p_event_type_code);
255:
256: ELSE

Line 321: RAISE FND_API.G_EXC_ERROR;

317: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
318: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed to create Loans XLA event ' || p_event_type_code);
319: FND_MSG_PUB.ADD;
320: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
321: RAISE FND_API.G_EXC_ERROR;
322: end if;
323: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully created Loans XLA event ' || p_event_type_code);
324: END IF; -- END of IF NOT XLA_EVENTS_PUB_PKG.event_exists
325: END; -- END of event Creation code

Line 335: WHEN FND_API.G_EXC_ERROR THEN

331:
332: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
333:
334: EXCEPTION
335: WHEN FND_API.G_EXC_ERROR THEN
336: x_return_status := FND_API.G_RET_STS_ERROR;
337: x_msg_count := l_msg_count;
338: x_msg_data := l_msg_data;
339: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 336: x_return_status := FND_API.G_RET_STS_ERROR;

332: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
333:
334: EXCEPTION
335: WHEN FND_API.G_EXC_ERROR THEN
336: x_return_status := FND_API.G_RET_STS_ERROR;
337: x_msg_count := l_msg_count;
338: x_msg_data := l_msg_data;
339: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
340: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 343: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

339: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
340: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
341: ROLLBACK TO create_event;
342:
343: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
344: x_return_status := FND_API.G_RET_STS_ERROR;
345: x_msg_count := l_msg_count;
346: x_msg_data := l_msg_data;
347: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 344: x_return_status := FND_API.G_RET_STS_ERROR;

340: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
341: ROLLBACK TO create_event;
342:
343: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
344: x_return_status := FND_API.G_RET_STS_ERROR;
345: x_msg_count := l_msg_count;
346: x_msg_data := l_msg_data;
347: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
348: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 352: x_return_status := FND_API.G_RET_STS_ERROR;

348: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
349: ROLLBACK TO create_event;
350:
351: WHEN OTHERS THEN
352: x_return_status := FND_API.G_RET_STS_ERROR;
353: x_msg_count := l_msg_count;
354: x_msg_data := l_msg_data;
355: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
356: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 445: IF FND_API.to_Boolean(p_init_msg_list) THEN

441: -- Standard Start of API savepoint
442: SAVEPOINT update_event;
443:
444: -- Initialize message list IF p_init_msg_list is set to TRUE.
445: IF FND_API.to_Boolean(p_init_msg_list) THEN
446: FND_MSG_PUB.initialize;
447: END IF;
448:
449: -- Initialize API return status to SUCCESS

Line 450: x_return_status := FND_API.G_RET_STS_SUCCESS;

446: FND_MSG_PUB.initialize;
447: END IF;
448:
449: -- Initialize API return status to SUCCESS
450: x_return_status := FND_API.G_RET_STS_SUCCESS;
451:
452: -- ---------------------------------------------------------------------
453: -- Api body
454: -- ---------------------------------------------------------------------

Line 499: WHEN FND_API.G_EXC_ERROR THEN

495:
496: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
497:
498: EXCEPTION
499: WHEN FND_API.G_EXC_ERROR THEN
500: x_return_status := FND_API.G_RET_STS_ERROR;
501: x_msg_count := l_msg_count;
502: x_msg_data := l_msg_data;
503: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 500: x_return_status := FND_API.G_RET_STS_ERROR;

496: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
497:
498: EXCEPTION
499: WHEN FND_API.G_EXC_ERROR THEN
500: x_return_status := FND_API.G_RET_STS_ERROR;
501: x_msg_count := l_msg_count;
502: x_msg_data := l_msg_data;
503: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
504: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

503: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
504: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
505: ROLLBACK TO update_event;
506:
507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
508: x_return_status := FND_API.G_RET_STS_ERROR;
509: x_msg_count := l_msg_count;
510: x_msg_data := l_msg_data;
511: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 508: x_return_status := FND_API.G_RET_STS_ERROR;

504: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
505: ROLLBACK TO update_event;
506:
507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
508: x_return_status := FND_API.G_RET_STS_ERROR;
509: x_msg_count := l_msg_count;
510: x_msg_data := l_msg_data;
511: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
512: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 516: x_return_status := FND_API.G_RET_STS_ERROR;

512: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
513: ROLLBACK TO update_event;
514:
515: WHEN OTHERS THEN
516: x_return_status := FND_API.G_RET_STS_ERROR;
517: x_msg_count := l_msg_count;
518: x_msg_data := l_msg_data;
519: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
520: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 596: IF FND_API.to_Boolean(p_init_msg_list) THEN

592: -- Standard Start of API savepoint
593: SAVEPOINT delete_event;
594:
595: -- Initialize message list IF p_init_msg_list is set to TRUE.
596: IF FND_API.to_Boolean(p_init_msg_list) THEN
597: FND_MSG_PUB.initialize;
598: END IF;
599:
600: -- Initialize API return status to SUCCESS

Line 601: x_return_status := FND_API.G_RET_STS_SUCCESS;

597: FND_MSG_PUB.initialize;
598: END IF;
599:
600: -- Initialize API return status to SUCCESS
601: x_return_status := FND_API.G_RET_STS_SUCCESS;
602:
603: -- ---------------------------------------------------------------------
604: -- Api body
605: -- ---------------------------------------------------------------------

Line 652: WHEN FND_API.G_EXC_ERROR THEN

648:
649: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
650:
651: EXCEPTION
652: WHEN FND_API.G_EXC_ERROR THEN
653: x_return_status := FND_API.G_RET_STS_ERROR;
654: x_msg_count := l_msg_count;
655: x_msg_data := l_msg_data;
656: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 653: x_return_status := FND_API.G_RET_STS_ERROR;

649: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
650:
651: EXCEPTION
652: WHEN FND_API.G_EXC_ERROR THEN
653: x_return_status := FND_API.G_RET_STS_ERROR;
654: x_msg_count := l_msg_count;
655: x_msg_data := l_msg_data;
656: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
657: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 660: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

656: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
657: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
658: ROLLBACK TO delete_event;
659:
660: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
661: x_return_status := FND_API.G_RET_STS_ERROR;
662: x_msg_count := l_msg_count;
663: x_msg_data := l_msg_data;
664: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 661: x_return_status := FND_API.G_RET_STS_ERROR;

657: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
658: ROLLBACK TO delete_event;
659:
660: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
661: x_return_status := FND_API.G_RET_STS_ERROR;
662: x_msg_count := l_msg_count;
663: x_msg_data := l_msg_data;
664: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
665: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 669: x_return_status := FND_API.G_RET_STS_ERROR;

665: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
666: ROLLBACK TO delete_event;
667:
668: WHEN OTHERS THEN
669: x_return_status := FND_API.G_RET_STS_ERROR;
670: x_msg_count := l_msg_count;
671: x_msg_data := l_msg_data;
672: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
673: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);