DBA Data[Home] [Help]

APPS.LNS_XLA_EVENTS dependencies on FND_MSG_PUB

Line 143: FND_MSG_PUB.initialize;

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

Line 169: FND_MSG_PUB.ADD;

165: -- force caller to pass disbursement_id
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

Line 211: FND_MSG_PUB.ADD;

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

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

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

Line 233: FND_MSG_PUB.ADD;

229:
230: if x_event_id is null then
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;

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

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

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

238:
239: -- ---------------------------------------------------------------------
240: -- End of API body
241: -- ---------------------------------------------------------------------
242: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
243:
244: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
245:
246: EXCEPTION

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

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);
253: ROLLBACK TO create_event;
254:
255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

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);
261: ROLLBACK TO create_event;
262:
263: WHEN OTHERS THEN

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

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);
269: ROLLBACK TO create_event;
270:
271: end create_event;

Line 349: FND_MSG_PUB.initialize;

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

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

389:
390: -- ---------------------------------------------------------------------
391: -- End of API body
392: -- ---------------------------------------------------------------------
393: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
394:
395: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
396:
397: EXCEPTION

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

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);
404: ROLLBACK TO update_event;
405:
406: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

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);
412: ROLLBACK TO update_event;
413:
414: WHEN OTHERS THEN

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

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);
420: ROLLBACK TO update_event;
421:
422: end update_event;

Line 486: FND_MSG_PUB.initialize;

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

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

525:
526: -- ---------------------------------------------------------------------
527: -- End of API body
528: -- ---------------------------------------------------------------------
529: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
530:
531: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
532:
533: EXCEPTION

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

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);
540: ROLLBACK TO delete_event;
541:
542: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

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);
548: ROLLBACK TO delete_event;
549:
550: WHEN OTHERS THEN

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

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);
556: ROLLBACK TO delete_event;
557:
558: end delete_event;