62: FND_MSG_PUB.initialize;
63: END IF;
64:
65: -- Debug Message
66: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
67:
68:
69: -- Initialize API return status to SUCCESS
70: x_return_status := FND_API.G_RET_STS_SUCCESS;
169: END IF;
170:
171:
172: -- Debug Message
173: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
174:
175: -- Standard call to get message count and if count is 1, get message info.
176: FND_MSG_PUB.Count_And_Get
177: (p_count => x_msg_count,
179: );
180:
181: EXCEPTION
182:
183: WHEN AMS_Utility_PVT.resource_locked THEN
184: x_return_status := FND_API.g_ret_sts_error;
185: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
186: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
187: FND_MSG_PUB.add;
262: FND_MSG_PUB.initialize;
263: END IF;
264:
265: -- Debug Message
266: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
267:
268:
269: -- Initialize API return status to SUCCESS
270: x_return_status := FND_API.G_RET_STS_SUCCESS;
357: END IF;
358: END IF;
359: -------------------------------------------------------
360: -- Debug Message
361: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
362:
363: -- Standard call to get message count and if count is 1, get message info.
364: FND_MSG_PUB.Count_And_Get
365: (p_count => x_msg_count,
366: p_data => x_msg_data
367: );
368: EXCEPTION
369:
370: WHEN AMS_Utility_PVT.resource_locked THEN
371: x_return_status := FND_API.g_ret_sts_error;
372: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
373:
374: WHEN FND_API.G_EXC_ERROR THEN
368: EXCEPTION
369:
370: WHEN AMS_Utility_PVT.resource_locked THEN
371: x_return_status := FND_API.g_ret_sts_error;
372: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
373:
374: WHEN FND_API.G_EXC_ERROR THEN
375: ROLLBACK TO UPDATE_DelivKitItem_PUB;
376: x_return_status := FND_API.G_RET_STS_ERROR;
450: FND_MSG_PUB.initialize;
451: END IF;
452:
453: -- Debug Message
454: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
455:
456:
457: -- Initialize API return status to SUCCESS
458: x_return_status := FND_API.G_RET_STS_SUCCESS;
556: END IF;
557:
558:
559: -- Debug Message
560: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
561:
562: -- Standard call to get message count and if count is 1, get message info.
563: FND_MSG_PUB.Count_And_Get
564: (p_count => x_msg_count,
565: p_data => x_msg_data
566: );
567: EXCEPTION
568:
569: WHEN AMS_Utility_PVT.resource_locked THEN
570: x_return_status := FND_API.g_ret_sts_error;
571: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
572:
573: WHEN FND_API.G_EXC_ERROR THEN
567: EXCEPTION
568:
569: WHEN AMS_Utility_PVT.resource_locked THEN
570: x_return_status := FND_API.g_ret_sts_error;
571: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
572:
573: WHEN FND_API.G_EXC_ERROR THEN
574: ROLLBACK TO DELETE_DelivKitItem_PUB;
575: x_return_status := FND_API.G_RET_STS_ERROR;
719: END IF;
720: END IF;
721:
722: -- Debug Message
723: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
724:
725: -- Standard call to get message count and if count is 1, get message info.
726: FND_MSG_PUB.Count_And_Get
727: (p_count => x_msg_count,
805: FND_MSG_PUB.initialize;
806: END IF;
807:
808: -- Debug Message
809: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
810:
811:
812: -- Initialize API return status to SUCCESS
813: x_return_status := FND_API.G_RET_STS_SUCCESS;
901: END IF;
902: --
903:
904: -- Debug Message
905: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
906:
907: EXCEPTION
908:
909: WHEN AMS_Utility_PVT.resource_locked THEN
905: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
906:
907: EXCEPTION
908:
909: WHEN AMS_Utility_PVT.resource_locked THEN
910: x_return_status := FND_API.g_ret_sts_error;
911: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
912:
913: WHEN FND_API.G_EXC_ERROR THEN
907: EXCEPTION
908:
909: WHEN AMS_Utility_PVT.resource_locked THEN
910: x_return_status := FND_API.g_ret_sts_error;
911: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
912:
913: WHEN FND_API.G_EXC_ERROR THEN
914: ROLLBACK TO LOCK_DelivKitItem_PUB;
915: x_return_status := FND_API.G_RET_STS_ERROR;