DBA Data[Home] [Help]

APPS.AMS_VENUE_RATES_PUB dependencies on AMS_UTILITY_PVT

Line 58: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');

54: FND_MSG_PUB.initialize;
55: END IF;
56:
57: -- Debug Message
58: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
59:
60:
61: -- Initialize API return status to SUCCESS
62: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 99: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');

95: END IF;
96:
97:
98: -- Debug Message
99: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
100:
101: -- Standard call to get message count and if count is 1, get message info.
102: FND_MSG_PUB.Count_And_Get
103: (p_count => x_msg_count,

Line 108: WHEN AMS_Utility_PVT.resource_locked THEN

104: p_data => x_msg_data
105: );
106: EXCEPTION
107:
108: WHEN AMS_Utility_PVT.resource_locked THEN
109: x_return_status := FND_API.g_ret_sts_error;
110: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
111:
112: WHEN FND_API.G_EXC_ERROR THEN

Line 110: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

106: EXCEPTION
107:
108: WHEN AMS_Utility_PVT.resource_locked THEN
109: x_return_status := FND_API.g_ret_sts_error;
110: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
111:
112: WHEN FND_API.G_EXC_ERROR THEN
113: ROLLBACK TO CREATE_Venue_Rates_PUB;
114: x_return_status := FND_API.G_RET_STS_ERROR;

Line 186: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');

182: FND_MSG_PUB.initialize;
183: END IF;
184:
185: -- Debug Message
186: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
187:
188:
189: -- Initialize API return status to SUCCESS
190: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 225: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');

221: END IF;
222:
223:
224: -- Debug Message
225: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
226:
227: -- Standard call to get message count and if count is 1, get message info.
228: FND_MSG_PUB.Count_And_Get
229: (p_count => x_msg_count,

Line 234: WHEN AMS_Utility_PVT.resource_locked THEN

230: p_data => x_msg_data
231: );
232: EXCEPTION
233:
234: WHEN AMS_Utility_PVT.resource_locked THEN
235: x_return_status := FND_API.g_ret_sts_error;
236: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
237:
238: WHEN FND_API.G_EXC_ERROR THEN

Line 236: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

232: EXCEPTION
233:
234: WHEN AMS_Utility_PVT.resource_locked THEN
235: x_return_status := FND_API.g_ret_sts_error;
236: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
237:
238: WHEN FND_API.G_EXC_ERROR THEN
239: ROLLBACK TO UPDATE_Venue_Rates_PUB;
240: x_return_status := FND_API.G_RET_STS_ERROR;

Line 311: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');

307: FND_MSG_PUB.initialize;
308: END IF;
309:
310: -- Debug Message
311: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
312:
313:
314: -- Initialize API return status to SUCCESS
315: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 350: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');

346: END IF;
347:
348:
349: -- Debug Message
350: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
351:
352: -- Standard call to get message count and if count is 1, get message info.
353: FND_MSG_PUB.Count_And_Get
354: (p_count => x_msg_count,

Line 359: WHEN AMS_Utility_PVT.resource_locked THEN

355: p_data => x_msg_data
356: );
357: EXCEPTION
358:
359: WHEN AMS_Utility_PVT.resource_locked THEN
360: x_return_status := FND_API.g_ret_sts_error;
361: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
362:
363: WHEN FND_API.G_EXC_ERROR THEN

Line 361: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

357: EXCEPTION
358:
359: WHEN AMS_Utility_PVT.resource_locked THEN
360: x_return_status := FND_API.g_ret_sts_error;
361: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
362:
363: WHEN FND_API.G_EXC_ERROR THEN
364: ROLLBACK TO DELETE_Venue_Rates_PUB;
365: x_return_status := FND_API.G_RET_STS_ERROR;

Line 432: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');

428: FND_MSG_PUB.initialize;
429: END IF;
430:
431: -- Debug Message
432: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
433:
434:
435: -- Initialize API return status to SUCCESS
436: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 464: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');

460: -- End of API body.
461: --
462:
463: -- Debug Message
464: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
465:
466: EXCEPTION
467:
468: WHEN AMS_Utility_PVT.resource_locked THEN

Line 468: WHEN AMS_Utility_PVT.resource_locked THEN

464: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
465:
466: EXCEPTION
467:
468: WHEN AMS_Utility_PVT.resource_locked THEN
469: x_return_status := FND_API.g_ret_sts_error;
470: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
471:
472: WHEN FND_API.G_EXC_ERROR THEN

Line 470: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

466: EXCEPTION
467:
468: WHEN AMS_Utility_PVT.resource_locked THEN
469: x_return_status := FND_API.g_ret_sts_error;
470: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
471:
472: WHEN FND_API.G_EXC_ERROR THEN
473: ROLLBACK TO LOCK_Venue_Rates_PUB;
474: x_return_status := FND_API.G_RET_STS_ERROR;