DBA Data[Home] [Help]

APPS.LNS_XLA_EVENTS dependencies on FND_MSG_PUB

Line 172: FND_MSG_PUB.initialize;

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
176: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 198: FND_MSG_PUB.ADD;

194: -- force caller to pass disbursement_id/loan_amount_adj_id/loan_line_id
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

Line 250: FND_MSG_PUB.ADD;

246: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'x_event_id = ' || x_event_id);
247: if x_event_id is null then
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);

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

247: if x_event_id is null then
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:

Line 319: FND_MSG_PUB.ADD;

315: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'x_event_id = ' || x_event_id);
316: if x_event_id is null then
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);

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

316: if x_event_id is null then
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

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

326:
327: -- ---------------------------------------------------------------------
328: -- End of API body
329: -- ---------------------------------------------------------------------
330: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
331:
332: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
333:
334: EXCEPTION

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

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);
341: ROLLBACK TO create_event;
342:
343: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

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);
349: ROLLBACK TO create_event;
350:
351: WHEN OTHERS THEN

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

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);
357: ROLLBACK TO create_event;
358:
359: end create_event;

Line 446: FND_MSG_PUB.initialize;

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
450: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

490:
491: -- ---------------------------------------------------------------------
492: -- End of API body
493: -- ---------------------------------------------------------------------
494: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
495:
496: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
497:
498: EXCEPTION

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

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);
505: ROLLBACK TO update_event;
506:
507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

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);
513: ROLLBACK TO update_event;
514:
515: WHEN OTHERS THEN

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

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);
521: ROLLBACK TO update_event;
522:
523: end update_event;

Line 597: FND_MSG_PUB.initialize;

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
601: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

643:
644: -- ---------------------------------------------------------------------
645: -- End of API body
646: -- ---------------------------------------------------------------------
647: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
648:
649: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
650:
651: EXCEPTION

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

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);
658: ROLLBACK TO delete_event;
659:
660: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

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);
666: ROLLBACK TO delete_event;
667:
668: WHEN OTHERS THEN

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

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);
674: ROLLBACK TO delete_event;
675:
676: end delete_event;