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: -- ---------------------------------------------------------------------
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);
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:
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);
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:
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:
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: -- ---------------------------------------------------------------------
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);
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:
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);
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:
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:
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: -- ---------------------------------------------------------------------
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);
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:
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);
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:
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: