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;
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,
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
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;
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;
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,
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
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;
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;
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,
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
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;
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;
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
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
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;