53: FND_MSG_PUB.initialize;
54: END IF;
55:
56: -- Debug Message
57: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
58:
59:
60: -- Initialize API return status to SUCCESS
61: x_return_status := FND_API.G_RET_STS_SUCCESS;
94: END IF;
95:
96:
97: -- Debug Message
98: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
99:
100: -- Standard call to get message count and if count is 1, get message info.
101: FND_MSG_PUB.Count_And_Get
102: (p_count => x_msg_count,
103: p_data => x_msg_data
104: );
105: EXCEPTION
106:
107: WHEN AMS_Utility_PVT.resource_locked THEN
108: x_return_status := FND_API.g_ret_sts_error;
109: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
110:
111: WHEN FND_API.G_EXC_ERROR THEN
105: EXCEPTION
106:
107: WHEN AMS_Utility_PVT.resource_locked THEN
108: x_return_status := FND_API.g_ret_sts_error;
109: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
110:
111: WHEN FND_API.G_EXC_ERROR THEN
112: ROLLBACK TO CREATE_Ct_Rule_PUB;
113: x_return_status := FND_API.G_RET_STS_ERROR;
181: FND_MSG_PUB.initialize;
182: END IF;
183:
184: -- Debug Message
185: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
186:
187:
188: -- Initialize API return status to SUCCESS
189: x_return_status := FND_API.G_RET_STS_SUCCESS;
220: END IF;
221:
222:
223: -- Debug Message
224: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
225:
226: -- Standard call to get message count and if count is 1, get message info.
227: FND_MSG_PUB.Count_And_Get
228: (p_count => x_msg_count,
229: p_data => x_msg_data
230: );
231: EXCEPTION
232:
233: WHEN AMS_Utility_PVT.resource_locked THEN
234: x_return_status := FND_API.g_ret_sts_error;
235: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
236:
237: WHEN FND_API.G_EXC_ERROR THEN
231: EXCEPTION
232:
233: WHEN AMS_Utility_PVT.resource_locked THEN
234: x_return_status := FND_API.g_ret_sts_error;
235: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
236:
237: WHEN FND_API.G_EXC_ERROR THEN
238: ROLLBACK TO UPDATE_Ct_Rule_PUB;
239: x_return_status := FND_API.G_RET_STS_ERROR;
306: FND_MSG_PUB.initialize;
307: END IF;
308:
309: -- Debug Message
310: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
311:
312:
313: -- Initialize API return status to SUCCESS
314: x_return_status := FND_API.G_RET_STS_SUCCESS;
345: END IF;
346:
347:
348: -- Debug Message
349: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
350:
351: -- Standard call to get message count and if count is 1, get message info.
352: FND_MSG_PUB.Count_And_Get
353: (p_count => x_msg_count,
354: p_data => x_msg_data
355: );
356: EXCEPTION
357:
358: WHEN AMS_Utility_PVT.resource_locked THEN
359: x_return_status := FND_API.g_ret_sts_error;
360: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
361:
362: WHEN FND_API.G_EXC_ERROR THEN
356: EXCEPTION
357:
358: WHEN AMS_Utility_PVT.resource_locked THEN
359: x_return_status := FND_API.g_ret_sts_error;
360: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
361:
362: WHEN FND_API.G_EXC_ERROR THEN
363: ROLLBACK TO DELETE_Ct_Rule_PUB;
364: x_return_status := FND_API.G_RET_STS_ERROR;
427: FND_MSG_PUB.initialize;
428: END IF;
429:
430: -- Debug Message
431: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
432:
433:
434: -- Initialize API return status to SUCCESS
435: x_return_status := FND_API.G_RET_STS_SUCCESS;
459: -- End of API body.
460: --
461:
462: -- Debug Message
463: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
464:
465: EXCEPTION
466:
467: WHEN AMS_Utility_PVT.resource_locked THEN
463: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
464:
465: EXCEPTION
466:
467: WHEN AMS_Utility_PVT.resource_locked THEN
468: x_return_status := FND_API.g_ret_sts_error;
469: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
470:
471: WHEN FND_API.G_EXC_ERROR THEN
465: EXCEPTION
466:
467: WHEN AMS_Utility_PVT.resource_locked THEN
468: x_return_status := FND_API.g_ret_sts_error;
469: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
470:
471: WHEN FND_API.G_EXC_ERROR THEN
472: ROLLBACK TO LOCK_Ct_Rule_PUB;
473: x_return_status := FND_API.G_RET_STS_ERROR;