DBA Data[Home] [Help]

APPS.ARI_PROCESS_VALIDATE dependencies on FND_API

Line 97: x_return_status := FND_API.G_RET_STS_SUCCESS;

93: -- Initialize message list IF p_init_msg_list is set to TRUE.
94: FND_MSG_PUB.initialize;
95:
96: -- Initialize API return status to SUCCESS
97: x_return_status := FND_API.G_RET_STS_SUCCESS;
98:
99: -- ---------------------------------------------------------------------
100: -- API BODY
101: -- ---------------------------------------------------------------------

Line 187: WHEN FND_API.G_EXC_ERROR THEN

183:
184: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
185:
186: EXCEPTION
187: WHEN FND_API.G_EXC_ERROR THEN
188: x_return_status := FND_API.G_RET_STS_ERROR;
189: x_fail_payment_schedule_tbl := l_psh_tbl;
190: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
191: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 188: x_return_status := FND_API.G_RET_STS_ERROR;

184: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
185:
186: EXCEPTION
187: WHEN FND_API.G_EXC_ERROR THEN
188: x_return_status := FND_API.G_RET_STS_ERROR;
189: x_fail_payment_schedule_tbl := l_psh_tbl;
190: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
191: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
192:

Line 193: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

189: x_fail_payment_schedule_tbl := l_psh_tbl;
190: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
191: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
192:
193: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
194: x_return_status := FND_API.G_RET_STS_ERROR;
195: x_fail_payment_schedule_tbl := l_psh_tbl;
196: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
197: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 194: x_return_status := FND_API.G_RET_STS_ERROR;

190: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
191: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
192:
193: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
194: x_return_status := FND_API.G_RET_STS_ERROR;
195: x_fail_payment_schedule_tbl := l_psh_tbl;
196: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
197: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
198:

Line 200: x_return_status := FND_API.G_RET_STS_ERROR;

196: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
197: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
198:
199: WHEN OTHERS THEN
200: x_return_status := FND_API.G_RET_STS_ERROR;
201: x_fail_payment_schedule_tbl := l_psh_tbl;
202: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
203: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
204:

Line 270: x_return_status := FND_API.G_RET_STS_SUCCESS;

266: -- Initialize message list IF p_init_msg_list is set to TRUE.
267: FND_MSG_PUB.initialize;
268:
269: -- Initialize API return status to SUCCESS
270: x_return_status := FND_API.G_RET_STS_SUCCESS;
271:
272: -- ---------------------------------------------------------------------
273: -- API BODY
274: -- ---------------------------------------------------------------------

Line 359: WHEN FND_API.G_EXC_ERROR THEN

355:
356: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
357:
358: EXCEPTION
359: WHEN FND_API.G_EXC_ERROR THEN
360: x_return_status := FND_API.G_RET_STS_ERROR;
361: x_fail_payment_schedule_tbl := l_psh_tbl;
362: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
363: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 360: x_return_status := FND_API.G_RET_STS_ERROR;

356: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
357:
358: EXCEPTION
359: WHEN FND_API.G_EXC_ERROR THEN
360: x_return_status := FND_API.G_RET_STS_ERROR;
361: x_fail_payment_schedule_tbl := l_psh_tbl;
362: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
363: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
364:

Line 365: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

361: x_fail_payment_schedule_tbl := l_psh_tbl;
362: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
363: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
364:
365: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
366: x_return_status := FND_API.G_RET_STS_ERROR;
367: x_fail_payment_schedule_tbl := l_psh_tbl;
368: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
369: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 366: x_return_status := FND_API.G_RET_STS_ERROR;

362: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
363: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
364:
365: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
366: x_return_status := FND_API.G_RET_STS_ERROR;
367: x_fail_payment_schedule_tbl := l_psh_tbl;
368: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
369: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
370:

Line 372: x_return_status := FND_API.G_RET_STS_ERROR;

368: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
369: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
370:
371: WHEN OTHERS THEN
372: x_return_status := FND_API.G_RET_STS_ERROR;
373: x_fail_payment_schedule_tbl := l_psh_tbl;
374: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
375: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
376:

Line 442: x_return_status := FND_API.G_RET_STS_SUCCESS;

438: -- Initialize message list IF p_init_msg_list is set to TRUE.
439: FND_MSG_PUB.initialize;
440:
441: -- Initialize API return status to SUCCESS
442: x_return_status := FND_API.G_RET_STS_SUCCESS;
443:
444: -- ---------------------------------------------------------------------
445: -- API BODY
446: -- ---------------------------------------------------------------------

Line 531: WHEN FND_API.G_EXC_ERROR THEN

527:
528: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
529:
530: EXCEPTION
531: WHEN FND_API.G_EXC_ERROR THEN
532: x_return_status := FND_API.G_RET_STS_ERROR;
533: x_fail_payment_schedule_tbl := l_psh_tbl;
534: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
535: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 532: x_return_status := FND_API.G_RET_STS_ERROR;

528: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
529:
530: EXCEPTION
531: WHEN FND_API.G_EXC_ERROR THEN
532: x_return_status := FND_API.G_RET_STS_ERROR;
533: x_fail_payment_schedule_tbl := l_psh_tbl;
534: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
535: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
536:

Line 537: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

533: x_fail_payment_schedule_tbl := l_psh_tbl;
534: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
535: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
536:
537: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
538: x_return_status := FND_API.G_RET_STS_ERROR;
539: x_fail_payment_schedule_tbl := l_psh_tbl;
540: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
541: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 538: x_return_status := FND_API.G_RET_STS_ERROR;

534: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
535: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
536:
537: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
538: x_return_status := FND_API.G_RET_STS_ERROR;
539: x_fail_payment_schedule_tbl := l_psh_tbl;
540: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
541: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
542:

Line 544: x_return_status := FND_API.G_RET_STS_ERROR;

540: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
541: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
542:
543: WHEN OTHERS THEN
544: x_return_status := FND_API.G_RET_STS_ERROR;
545: x_fail_payment_schedule_tbl := l_psh_tbl;
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: