[Home] [Help]
38: L_API_NAME CONSTANT VARCHAR2(30) := 'Lock_Dmlift';
39: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
40: l_pvt_Lift_rec AMS_DMLift_PVT.Lift_rec_type;
41: BEGIN
42: -- Standard call to check for call compatibility.
43: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
44: p_api_version,
45: l_api_name,
46: G_PKG_NAME)
100:
101: WHEN FND_API.G_EXC_ERROR THEN
102: ROLLBACK TO LOCK_Dmlift_PUB;
103: x_return_status := FND_API.G_RET_STS_ERROR;
104: -- Standard call to get message count and if count=1, get the message
105: FND_MSG_PUB.Count_And_Get (
106: p_encoded => FND_API.G_FALSE,
107: p_count => x_msg_count,
108: p_data => x_msg_data
110:
111: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
112: ROLLBACK TO LOCK_Dmlift_PUB;
113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
114: -- Standard call to get message count and if count=1, get the message
115: FND_MSG_PUB.Count_And_Get (
116: p_encoded => FND_API.G_FALSE,
117: p_count => x_msg_count,
118: p_data => x_msg_data
124: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
125: THEN
126: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
127: END IF;
128: -- Standard call to get message count and if count=1, get the message
129: FND_MSG_PUB.Count_And_Get (
130: p_encoded => FND_API.G_FALSE,
131: p_count => x_msg_count,
132: p_data => x_msg_data
151: L_API_NAME CONSTANT VARCHAR2(30) := 'Create_Lift';
152: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
153: l_pvt_Lift_rec AMS_DMLift_PVT.Lift_rec_type;
154: BEGIN
155: -- Standard Start of API savepoint
156: SAVEPOINT Create_Lift_PUB;
157:
158: -- Standard call to check for call compatibility.
159: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
154: BEGIN
155: -- Standard Start of API savepoint
156: SAVEPOINT Create_Lift_PUB;
157:
158: -- Standard call to check for call compatibility.
159: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
160: p_api_version,
161: l_api_name,
162: G_PKG_NAME)
217: --
218: -- End of API body.
219: --
220:
221: -- Standard check for p_commit
222: IF FND_API.to_Boolean( p_commit )
223: THEN
224: COMMIT WORK;
225: END IF;
227:
228: -- Debug Message
229: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
230:
231: -- Standard call to get message count and if count is 1, get message info.
232: FND_MSG_PUB.Count_And_Get
233: (p_count => x_msg_count,
234: p_data => x_msg_data
235: );
244:
245: WHEN FND_API.G_EXC_ERROR THEN
246: ROLLBACK TO Create_Lift_PUB;
247: x_return_status := FND_API.G_RET_STS_ERROR;
248: -- Standard call to get message count and if count=1, get the message
249: FND_MSG_PUB.Count_And_Get (
250: p_encoded => FND_API.G_FALSE,
251: p_count => x_msg_count,
252: p_data => x_msg_data
254:
255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
256: ROLLBACK TO Create_Lift_PUB;
257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
258: -- Standard call to get message count and if count=1, get the message
259: FND_MSG_PUB.Count_And_Get (
260: p_encoded => FND_API.G_FALSE,
261: p_count => x_msg_count,
262: p_data => x_msg_data
268: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
269: THEN
270: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
271: END IF;
272: -- Standard call to get message count and if count=1, get the message
273: FND_MSG_PUB.Count_And_Get (
274: p_encoded => FND_API.G_FALSE,
275: p_count => x_msg_count,
276: p_data => x_msg_data
296: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
297: l_object_version_number NUMBER;
298: l_pvt_Lift_rec AMS_DMLift_PVT.Lift_rec_type;
299: BEGIN
300: -- Standard Start of API savepoint
301: SAVEPOINT Update_Lift_PUB;
302:
303: -- Standard call to check for call compatibility.
304: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
299: BEGIN
300: -- Standard Start of API savepoint
301: SAVEPOINT Update_Lift_PUB;
302:
303: -- Standard call to check for call compatibility.
304: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
305: p_api_version,
306: l_api_name,
307: G_PKG_NAME)
346: --
347: -- End of API body
348: --
349:
350: -- Standard check for p_commit
351: IF FND_API.to_Boolean( p_commit )
352: THEN
353: COMMIT WORK;
354: END IF;
356:
357: -- Debug Message
358: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
359:
360: -- Standard call to get message count and if count is 1, get message info.
361: FND_MSG_PUB.Count_And_Get
362: (p_count => x_msg_count,
363: p_data => x_msg_data
364: );
373:
374: WHEN FND_API.G_EXC_ERROR THEN
375: ROLLBACK TO Update_Lift_PUB;
376: x_return_status := FND_API.G_RET_STS_ERROR;
377: -- Standard call to get message count and if count=1, get the message
378: FND_MSG_PUB.Count_And_Get (
379: p_encoded => FND_API.G_FALSE,
380: p_count => x_msg_count,
381: p_data => x_msg_data
383:
384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
385: ROLLBACK TO Update_Lift_PUB;
386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
387: -- Standard call to get message count and if count=1, get the message
388: FND_MSG_PUB.Count_And_Get (
389: p_encoded => FND_API.G_FALSE,
390: p_count => x_msg_count,
391: p_data => x_msg_data
397: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
398: THEN
399: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
400: END IF;
401: -- Standard call to get message count and if count=1, get the message
402: FND_MSG_PUB.Count_And_Get (
403: p_encoded => FND_API.G_FALSE,
404: p_count => x_msg_count,
405: p_data => x_msg_data
424: l_LIFT_ID NUMBER := p_LIFT_ID;
425: l_object_version_number NUMBER := p_object_version_number;
426: l_pvt_Lift_rec AMS_DMLift_PVT.Lift_rec_type;
427: BEGIN
428: -- Standard Start of API savepoint
429: SAVEPOINT Delete_Lift_PUB;
430:
431: -- Standard call to check for call compatibility.
432: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
427: BEGIN
428: -- Standard Start of API savepoint
429: SAVEPOINT Delete_Lift_PUB;
430:
431: -- Standard call to check for call compatibility.
432: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
433: p_api_version,
434: l_api_name,
435: G_PKG_NAME)
474: --
475: -- End of API body
476: --
477:
478: -- Standard check for p_commit
479: IF FND_API.to_Boolean( p_commit )
480: THEN
481: COMMIT WORK;
482: END IF;
484:
485: -- Debug Message
486: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
487:
488: -- Standard call to get message count and if count is 1, get message info.
489: FND_MSG_PUB.Count_And_Get
490: (p_count => x_msg_count,
491: p_data => x_msg_data
492: );
501:
502: WHEN FND_API.G_EXC_ERROR THEN
503: ROLLBACK TO Delete_Lift_PUB;
504: x_return_status := FND_API.G_RET_STS_ERROR;
505: -- Standard call to get message count and if count=1, get the message
506: FND_MSG_PUB.Count_And_Get (
507: p_encoded => FND_API.G_FALSE,
508: p_count => x_msg_count,
509: p_data => x_msg_data
511:
512: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
513: ROLLBACK TO Delete_Lift_PUB;
514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
515: -- Standard call to get message count and if count=1, get the message
516: FND_MSG_PUB.Count_And_Get (
517: p_encoded => FND_API.G_FALSE,
518: p_count => x_msg_count,
519: p_data => x_msg_data
525: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
526: THEN
527: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
528: END IF;
529: -- Standard call to get message count and if count=1, get the message
530: FND_MSG_PUB.Count_And_Get (
531: p_encoded => FND_API.G_FALSE,
532: p_count => x_msg_count,
533: p_data => x_msg_data