DBA Data[Home] [Help]

APPS.AMS_SCORERESULT_PUB dependencies on AMS_UTILITY_PVT

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

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

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

104: END IF;
105:
106:
107: -- Debug Message
108: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
109:
110: -- Standard call to get message count and if count is 1, get message info.
111: FND_MSG_PUB.Count_And_Get
112: (p_count => x_msg_count,

Line 117: WHEN AMS_Utility_PVT.resource_locked THEN

113: p_data => x_msg_data
114: );
115: EXCEPTION
116:
117: WHEN AMS_Utility_PVT.resource_locked THEN
118: x_return_status := FND_API.g_ret_sts_error;
119: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
120:
121: WHEN FND_API.G_EXC_ERROR THEN

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

115: EXCEPTION
116:
117: WHEN AMS_Utility_PVT.resource_locked THEN
118: x_return_status := FND_API.g_ret_sts_error;
119: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
120:
121: WHEN FND_API.G_EXC_ERROR THEN
122: ROLLBACK TO CREATE_Scoreresult_PUB;
123: x_return_status := FND_API.G_RET_STS_ERROR;

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

190: FND_MSG_PUB.initialize;
191: END IF;
192:
193: -- Debug Message
194: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
195:
196:
197: -- Initialize API return status to SUCCESS
198: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

237: END IF;
238:
239:
240: -- Debug Message
241: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
242:
243: -- Standard call to get message count and if count is 1, get message info.
244: FND_MSG_PUB.Count_And_Get
245: (p_count => x_msg_count,

Line 250: WHEN AMS_Utility_PVT.resource_locked THEN

246: p_data => x_msg_data
247: );
248: EXCEPTION
249:
250: WHEN AMS_Utility_PVT.resource_locked THEN
251: x_return_status := FND_API.g_ret_sts_error;
252: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
253:
254: WHEN FND_API.G_EXC_ERROR THEN

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

248: EXCEPTION
249:
250: WHEN AMS_Utility_PVT.resource_locked THEN
251: x_return_status := FND_API.g_ret_sts_error;
252: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
253:
254: WHEN FND_API.G_EXC_ERROR THEN
255: ROLLBACK TO UPDATE_Scoreresult_PUB;
256: x_return_status := FND_API.G_RET_STS_ERROR;

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

319: FND_MSG_PUB.initialize;
320: END IF;
321:
322: -- Debug Message
323: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
324:
325:
326: -- Initialize API return status to SUCCESS
327: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

356: END IF;
357:
358:
359: -- Debug Message
360: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
361:
362: -- Standard call to get message count and if count is 1, get message info.
363: FND_MSG_PUB.Count_And_Get
364: (p_count => x_msg_count,

Line 369: WHEN AMS_Utility_PVT.resource_locked THEN

365: p_data => x_msg_data
366: );
367: EXCEPTION
368:
369: WHEN AMS_Utility_PVT.resource_locked THEN
370: x_return_status := FND_API.g_ret_sts_error;
371: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
372:
373: WHEN FND_API.G_EXC_ERROR THEN

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

367: EXCEPTION
368:
369: WHEN AMS_Utility_PVT.resource_locked THEN
370: x_return_status := FND_API.g_ret_sts_error;
371: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
372:
373: WHEN FND_API.G_EXC_ERROR THEN
374: ROLLBACK TO DELETE_Scoreresult_PUB;
375: x_return_status := FND_API.G_RET_STS_ERROR;

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

436: FND_MSG_PUB.initialize;
437: END IF;
438:
439: -- Debug Message
440: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
441:
442:
443: -- Initialize API return status to SUCCESS
444: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

467: -- End of API body.
468: --
469:
470: -- Debug Message
471: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
472:
473: EXCEPTION
474:
475: WHEN AMS_Utility_PVT.resource_locked THEN

Line 475: WHEN AMS_Utility_PVT.resource_locked THEN

471: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
472:
473: EXCEPTION
474:
475: WHEN AMS_Utility_PVT.resource_locked THEN
476: x_return_status := FND_API.g_ret_sts_error;
477: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
478:
479: WHEN FND_API.G_EXC_ERROR THEN

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

473: EXCEPTION
474:
475: WHEN AMS_Utility_PVT.resource_locked THEN
476: x_return_status := FND_API.g_ret_sts_error;
477: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
478:
479: WHEN FND_API.G_EXC_ERROR THEN
480: ROLLBACK TO LOCK_Scoreresult_PUB;
481: x_return_status := FND_API.G_RET_STS_ERROR;