44: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
45: RAISE FND_API.g_exc_unexpected_error;
46: END IF;
47:
48: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'End');
49:
50: EXCEPTION
51:
52: WHEN FND_API.G_EXC_ERROR THEN
110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
111: END IF;
112: -- Initialize message list if p_init_msg_list is set to TRUE.
113: -- Debug Message
114: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
115:
116: -- Initialize API return status to SUCCESS
117: x_return_status := FND_API.G_RET_STS_SUCCESS;
118:
132: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
133: RAISE FND_API.g_exc_unexpected_error;
134: END IF;
135:
136: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'End');
137:
138: EXCEPTION
139:
140: WHEN FND_API.G_EXC_ERROR THEN
195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
196: END IF;
197: -- Initialize message list if p_init_msg_list is set to TRUE.
198: -- Debug Message
199: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
200:
201: -- Initialize API return status to SUCCESS
202: x_return_status := FND_API.G_RET_STS_SUCCESS;
203:
216: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
217: RAISE FND_API.g_exc_unexpected_error;
218: END IF;
219:
220: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'End');
221:
222: EXCEPTION
223:
224: WHEN FND_API.G_EXC_ERROR THEN
282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
283: END IF;
284: -- Initialize message list if p_init_msg_list is set to TRUE.
285: -- Debug Message
286: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
287:
288: -- Initialize API return status to SUCCESS
289: x_return_status := FND_API.G_RET_STS_SUCCESS;
290:
307: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
308: RAISE FND_API.g_exc_unexpected_error;
309: END IF;
310:
311: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'End');
312:
313: EXCEPTION
314:
315: WHEN FND_API.G_EXC_ERROR THEN
535: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
536: END IF;
537: -- Initialize message list if p_init_msg_list is set to TRUE.
538: -- Debug Message
539: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
540:
541: -- Initialize API return status to SUCCESS
542: x_return_status := FND_API.G_RET_STS_SUCCESS;
543:
564: RAISE FND_API.g_exc_unexpected_error;
565:
566: END IF;
567:
568: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'End');
569:
570: EXCEPTION
571:
572: WHEN FND_API.G_EXC_ERROR THEN
623: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
624: END IF;
625: -- Initialize message list if p_init_msg_list is set to TRUE.
626: -- Debug Message
627: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
628:
629: -- Initialize API return status to SUCCESS
630: x_return_status := FND_API.G_RET_STS_SUCCESS;
631:
652: RAISE FND_API.g_exc_unexpected_error;
653:
654: END IF;
655:
656: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'End');
657:
658: EXCEPTION
659:
660: WHEN FND_API.G_EXC_ERROR THEN
719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
720: END IF;
721: -- Initialize message list if p_init_msg_list is set to TRUE.
722: -- Debug Message
723: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
724:
725: -- Initialize API return status to SUCCESS
726: x_return_status := FND_API.G_RET_STS_SUCCESS;
727:
748: RAISE FND_API.g_exc_unexpected_error;
749:
750: END IF;
751:
752: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'End');
753:
754: EXCEPTION
755:
756: WHEN FND_API.G_EXC_ERROR THEN