61: FND_MSG_PUB.initialize;
62: END IF;
63:
64: -- Debug Message
65: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
66:
67:
68: -- Initialize API return status to SUCCESS
69: x_return_status := FND_API.G_RET_STS_SUCCESS;
111: END IF;
112:
113:
114: -- Debug Message
115: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
116:
117: -- Standard call to get message count and if count is 1, get message info.
118: FND_MSG_PUB.Count_And_Get
119: (p_count => x_msg_count,
120: p_data => x_msg_data
121: );
122: EXCEPTION
123:
124: WHEN AMS_Utility_PVT.resource_locked THEN
125: x_return_status := FND_API.g_ret_sts_error;
126: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
127: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
128: FND_MSG_PUB.add;
200: FND_MSG_PUB.initialize;
201: END IF;
202:
203: -- Debug Message
204: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
205:
206:
207: -- Initialize API return status to SUCCESS
208: x_return_status := FND_API.G_RET_STS_SUCCESS;
250: END IF;
251:
252:
253: -- Debug Message
254: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
255:
256: -- Standard call to get message count and if count is 1, get message info.
257: FND_MSG_PUB.Count_And_Get
258: (p_count => x_msg_count,
259: p_data => x_msg_data
260: );
261: EXCEPTION
262:
263: WHEN AMS_Utility_PVT.resource_locked THEN
264: x_return_status := FND_API.g_ret_sts_error;
265: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
266: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
267: FND_MSG_PUB.add;
336: FND_MSG_PUB.initialize;
337: END IF;
338:
339: -- Debug Message
340: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
341:
342:
343: -- Initialize API return status to SUCCESS
344: x_return_status := FND_API.G_RET_STS_SUCCESS;
376: END IF;
377:
378:
379: -- Debug Message
380: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
381:
382: -- Standard call to get message count and if count is 1, get message info.
383: FND_MSG_PUB.Count_And_Get
384: (p_count => x_msg_count,
385: p_data => x_msg_data
386: );
387: EXCEPTION
388:
389: WHEN AMS_Utility_PVT.resource_locked THEN
390: x_return_status := FND_API.g_ret_sts_error;
391: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
392: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
393: FND_MSG_PUB.add;
459: FND_MSG_PUB.initialize;
460: END IF;
461:
462: -- Debug Message
463: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
464:
465:
466: -- Initialize API return status to SUCCESS
467: x_return_status := FND_API.G_RET_STS_SUCCESS;
491: -- End of API body.
492: --
493:
494: -- Debug Message
495: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
496:
497: EXCEPTION
498:
499: WHEN AMS_Utility_PVT.resource_locked THEN
495: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
496:
497: EXCEPTION
498:
499: WHEN AMS_Utility_PVT.resource_locked THEN
500: x_return_status := FND_API.g_ret_sts_error;
501: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
502: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
503: FND_MSG_PUB.add;