[Home] [Help]
38: L_API_NAME CONSTANT VARCHAR2(30) := 'Create_Scoreresult';
39: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
40: l_pvt_scoreresult_rec AMS_Scoreresult_PVT.scoreresult_rec_type;
41: BEGIN
42: -- Standard Start of API savepoint
43: SAVEPOINT CREATE_Scoreresult_PUB;
44:
45: -- Standard call to check for call compatibility.
46: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
41: BEGIN
42: -- Standard Start of API savepoint
43: SAVEPOINT CREATE_Scoreresult_PUB;
44:
45: -- Standard call to check for call compatibility.
46: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
47: p_api_version,
48: l_api_name,
49: G_PKG_NAME)
97: --
98: -- End of API body.
99: --
100:
101: -- Standard check for p_commit
102: IF FND_API.to_Boolean( p_commit ) THEN
103: COMMIT WORK;
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: );
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;
124: -- Standard call to get message count and if count=1, get the message
125: FND_MSG_PUB.Count_And_Get (
126: p_encoded => FND_API.G_FALSE,
127: p_count => x_msg_count,
128: p_data => x_msg_data
130:
131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
132: ROLLBACK TO CREATE_Scoreresult_PUB;
133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
134: -- Standard call to get message count and if count=1, get the message
135: FND_MSG_PUB.Count_And_Get (
136: p_encoded => FND_API.G_FALSE,
137: p_count => x_msg_count,
138: p_data => x_msg_data
144: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
145: THEN
146: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
147: END IF;
148: -- Standard call to get message count and if count=1, get the message
149: FND_MSG_PUB.Count_And_Get (
150: p_encoded => FND_API.G_FALSE,
151: p_count => x_msg_count,
152: p_data => x_msg_data
171: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
172: l_object_version_number NUMBER;
173: l_pvt_scoreresult_rec AMS_Scoreresult_PVT.scoreresult_rec_type;
174: BEGIN
175: -- Standard Start of API savepoint
176: SAVEPOINT UPDATE_Scoreresult_PUB;
177:
178: -- Standard call to check for call compatibility.
179: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
174: BEGIN
175: -- Standard Start of API savepoint
176: SAVEPOINT UPDATE_Scoreresult_PUB;
177:
178: -- Standard call to check for call compatibility.
179: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
180: p_api_version,
181: l_api_name,
182: G_PKG_NAME)
230: --
231: -- End of API body
232: --
233:
234: -- Standard check for p_commit
235: IF FND_API.to_Boolean( p_commit ) THEN
236: COMMIT WORK;
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: );
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;
257: -- Standard call to get message count and if count=1, get the message
258: FND_MSG_PUB.Count_And_Get (
259: p_encoded => FND_API.G_FALSE,
260: p_count => x_msg_count,
261: p_data => x_msg_data
263:
264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
265: ROLLBACK TO UPDATE_Scoreresult_PUB;
266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
267: -- Standard call to get message count and if count=1, get the message
268: FND_MSG_PUB.Count_And_Get (
269: p_encoded => FND_API.G_FALSE,
270: p_count => x_msg_count,
271: p_data => x_msg_data
277: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
278: THEN
279: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
280: END IF;
281: -- Standard call to get message count and if count=1, get the message
282: FND_MSG_PUB.Count_And_Get (
283: p_encoded => FND_API.G_FALSE,
284: p_count => x_msg_count,
285: p_data => x_msg_data
300: IS
301: L_API_NAME CONSTANT VARCHAR2(30) := 'Delete_Scoreresult';
302: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
303: BEGIN
304: -- Standard Start of API savepoint
305: SAVEPOINT DELETE_Scoreresult_PUB;
306:
307: -- Standard call to check for call compatibility.
308: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
303: BEGIN
304: -- Standard Start of API savepoint
305: SAVEPOINT DELETE_Scoreresult_PUB;
306:
307: -- Standard call to check for call compatibility.
308: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
309: p_api_version,
310: l_api_name,
311: G_PKG_NAME)
349: --
350: -- End of API body
351: --
352:
353: -- Standard check for p_commit
354: IF FND_API.to_Boolean( p_commit ) THEN
355: COMMIT WORK;
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: );
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;
376: -- Standard call to get message count and if count=1, get the message
377: FND_MSG_PUB.Count_And_Get (
378: p_encoded => FND_API.G_FALSE,
379: p_count => x_msg_count,
380: p_data => x_msg_data
382:
383: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
384: ROLLBACK TO DELETE_Scoreresult_PUB;
385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
386: -- Standard call to get message count and if count=1, get the message
387: FND_MSG_PUB.Count_And_Get (
388: p_encoded => FND_API.G_FALSE,
389: p_count => x_msg_count,
390: p_data => x_msg_data
396: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
397: THEN
398: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
399: END IF;
400: -- Standard call to get message count and if count=1, get the message
401: FND_MSG_PUB.Count_And_Get (
402: p_encoded => FND_API.G_FALSE,
403: p_count => x_msg_count,
404: p_data => x_msg_data
420: L_API_NAME CONSTANT VARCHAR2(30) := 'Lock_Scoreresult';
421: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
422: BEGIN
423:
424: -- Standard call to check for call compatibility.
425: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
426: p_api_version,
427: l_api_name,
428: G_PKG_NAME)
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;
482: -- Standard call to get message count and if count=1, get the message
483: FND_MSG_PUB.Count_And_Get (
484: p_encoded => FND_API.G_FALSE,
485: p_count => x_msg_count,
486: p_data => x_msg_data
488:
489: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
490: ROLLBACK TO LOCK_Scoreresult_PUB;
491: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
492: -- Standard call to get message count and if count=1, get the message
493: FND_MSG_PUB.Count_And_Get (
494: p_encoded => FND_API.G_FALSE,
495: p_count => x_msg_count,
496: p_data => x_msg_data
502: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
503: THEN
504: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
505: END IF;
506: -- Standard call to get message count and if count=1, get the message
507: FND_MSG_PUB.Count_And_Get (
508: p_encoded => FND_API.G_FALSE,
509: p_count => x_msg_count,
510: p_data => x_msg_data
545: FROM ams_dm_score_results
546: WHERE score_result_id = p_result_id)
547: ;
548: BEGIN
549: -- Standard Start of API savepoint
550: SAVEPOINT CREATE_Scoreresult_PUB;
551:
552: -- Initialize API return status to SUCCESS
553: x_return_status := FND_API.G_RET_STS_SUCCESS;