113: FND_MSG_PUB.initialize;
114: END IF;
115:
116: -- Debug Message
117: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
118:
119:
120: -- Initialize API return status to SUCCESS
121: x_return_status := FND_API.G_RET_STS_SUCCESS;
219: END IF;
220:
221:
222: -- Debug Message
223: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
224:
225: -- Standard call to get message count and if count is 1, get message info.
226: FND_MSG_PUB.Count_And_Get
227: (p_count => x_msg_count,
228: p_data => x_msg_data
229: );
230:
231: EXCEPTION
232: WHEN AMS_Utility_PVT.resource_locked THEN
233: x_return_status := FND_API.g_ret_sts_error;
234: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
235: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
236: FND_MSG_PUB.add;
314: FND_MSG_PUB.initialize;
315: END IF;
316:
317: -- Debug Message
318: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
319:
320: -- Initialize API return status to SUCCESS
321: x_return_status := FND_API.G_RET_STS_SUCCESS;
322:
413: END IF;
414:
415:
416: -- Debug Message
417: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
418:
419: -- Standard call to get message count and if count is 1, get message info.
420: FND_MSG_PUB.Count_And_Get
421: (p_count => x_msg_count,
423: );
424:
425: EXCEPTION
426:
427: WHEN AMS_Utility_PVT.resource_locked THEN
428: x_return_status := FND_API.g_ret_sts_error;
429: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
430: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
431: FND_MSG_PUB.add;
509: FND_MSG_PUB.initialize;
510: END IF;
511:
512: -- Debug Message
513: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
514:
515: -- Initialize API return status to SUCCESS
516: x_return_status := FND_API.G_RET_STS_SUCCESS;
517:
610: END IF;
611:
612:
613: -- Debug Message
614: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
615:
616: -- Standard call to get message count and if count is 1, get message info.
617: FND_MSG_PUB.Count_And_Get
618: (p_count => x_msg_count,
620: );
621:
622: EXCEPTION
623:
624: WHEN AMS_Utility_PVT.resource_locked THEN
625: x_return_status := FND_API.g_ret_sts_error;
626: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
627: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
628: FND_MSG_PUB.add;
715: FND_MSG_PUB.initialize;
716: END IF;
717:
718: -- Debug Message
719: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
720:
721: SAVEPOINT lock_act_resource_pub;
722:
723: -- Initialize API return status to SUCCESS
809: END IF;
810: END IF;
811:
812: -- Debug Message
813: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
814:
815: EXCEPTION
816:
817: WHEN AMS_Utility_PVT.resource_locked THEN
813: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
814:
815: EXCEPTION
816:
817: WHEN AMS_Utility_PVT.resource_locked THEN
818: x_return_status := FND_API.g_ret_sts_error;
819: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
820: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
821: FND_MSG_PUB.add;
974: END IF;
975: END IF;
976:
977: -- Debug Message
978: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
979:
980: -- Standard call to get message count and if count is 1, get message info.
981: FND_MSG_PUB.Count_And_Get
982: (p_count => x_msg_count,