63: END IF;
64:
65: /* Initialize message list if p_init_msg_list is set to TRUE */
66: IF FND_API.to_Boolean( p_init_msg_list ) THEN
67: FND_MSG_PUB.initialize;
68: END IF;
69:
70: /* Initialize API return status to success */
71: x_return_status := FND_API.G_RET_STS_SUCCESS;
222: Commit;
223: END IF;
224:
225: /* Get the message count and information */
226: FND_MSG_PUB.Count_And_Get (
227: p_count => x_msg_count,
228: p_data => x_msg_data );
229: EXCEPTION
230: WHEN FND_API.G_EXC_ERROR THEN
229: EXCEPTION
230: WHEN FND_API.G_EXC_ERROR THEN
231: ROLLBACK to Insert_FormulaDetail_PVT;
232: x_return_status := FND_API.G_RET_STS_ERROR;
233: FND_MSG_PUB.Count_And_Get (
234: p_count => x_msg_count,
235: p_data => x_msg_data );
236:
237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
236:
237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
238: ROLLBACK to Insert_FormulaDetail_PVT;
239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
240: FND_MSG_PUB.Count_And_Get (
241: p_count => x_msg_count,
242: p_data => x_msg_data );
243:
244: WHEN OTHERS THEN
242: p_data => x_msg_data );
243:
244: WHEN OTHERS THEN
245: ROLLBACK to Insert_FormulaDetail_PVT;
246: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
248: IF (l_debug = 'Y') THEN
249: gmd_debug.put_line(' In Formula Detail Pvt - In OTHERS Exception Section '
250: ||' - '
314: END IF;
315:
316: /* Initialize message list if p_init_msg_list is set to TRUE */
317: IF FND_API.to_Boolean( p_init_msg_list ) THEN
318: FND_MSG_PUB.initialize;
319: END IF;
320: /* Initialize API return status to success */
321: x_return_status := FND_API.G_RET_STS_SUCCESS;
322:
521: Commit;
522: END IF;
523:
524: /* Get the message count and information */
525: FND_MSG_PUB.Count_And_Get (
526: p_count => x_msg_count,
527: p_data => x_msg_data );
528:
529:
530: EXCEPTION
531: WHEN FND_API.G_EXC_ERROR THEN
532: ROLLBACK to Update_FormulaDetail_PVT;
533: x_return_status := FND_API.G_RET_STS_ERROR;
534: FND_MSG_PUB.Count_And_Get (
535: p_count => x_msg_count,
536: p_data => x_msg_data );
537:
538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
537:
538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
539: ROLLBACK to Update_FormulaDetail_PVT;
540: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
541: FND_MSG_PUB.Count_And_Get (
542: p_count => x_msg_count,
543: p_data => x_msg_data );
544:
545: WHEN OTHERS THEN
543: p_data => x_msg_data );
544:
545: WHEN OTHERS THEN
546: ROLLBACK to Update_FormulaDetail_PVT;
547: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
549: IF (l_debug = 'Y') THEN
550: gmd_debug.put_line(' In Formula Detail Pvt - In OTHERS Exception Section '
551: ||' - '
598: END IF;
599:
600: /* Initialize message list if p_init_msg_list is set to TRUE */
601: IF FND_API.to_Boolean( p_init_msg_list ) THEN
602: FND_MSG_PUB.initialize;
603: END IF;
604: /* Initialize API return status to success */
605: x_return_status := FND_API.G_RET_STS_SUCCESS;
606:
640: Commit;
641: END IF;
642:
643: /* Get the message count and information */
644: FND_MSG_PUB.Count_And_Get (
645: p_count => x_msg_count,
646: p_data => x_msg_data );
647:
648:
649: EXCEPTION
650: WHEN FND_API.G_EXC_ERROR THEN
651: ROLLBACK to Delete_FormulaDetail_PVT;
652: x_return_status := FND_API.G_RET_STS_ERROR;
653: FND_MSG_PUB.Count_And_Get (
654: p_count => x_msg_count,
655: p_data => x_msg_data );
656:
657: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
656:
657: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
658: ROLLBACK to Delete_FormulaDetail_PVT;
659: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
660: FND_MSG_PUB.Count_And_Get (
661: p_count => x_msg_count,
662: p_data => x_msg_data );
663:
664: WHEN OTHERS THEN
662: p_data => x_msg_data );
663:
664: WHEN OTHERS THEN
665: ROLLBACK to Delete_FormulaDetail_PVT;
666: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
668:
669: END Delete_FormulaDetail;
670: