[Home] [Help]
73: THEN
74: FND_MSG_PUB.initialize;
75: END IF;
76:
77: -- Standard call to check for call compatibility.
78: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
79: p_api_version,
80: l_api_name,
81: G_PKG_NAME)
132:
133: WHEN FND_API.G_EXC_ERROR THEN
134: ROLLBACK TO LOCK_Dmlift_PVT;
135: x_return_status := FND_API.G_RET_STS_ERROR;
136: -- Standard call to get message count and if count=1, get the message
137: FND_MSG_PUB.Count_And_Get (
138: p_encoded => FND_API.G_FALSE,
139: p_count => x_msg_count,
140: p_data => x_msg_data
142:
143: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
144: ROLLBACK TO LOCK_Dmlift_PVT;
145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
146: -- Standard call to get message count and if count=1, get the message
147: FND_MSG_PUB.Count_And_Get (
148: p_encoded => FND_API.G_FALSE,
149: p_count => x_msg_count,
150: p_data => x_msg_data
156: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
157: THEN
158: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
159: END IF;
160: -- Standard call to get message count and if count=1, get the message
161: FND_MSG_PUB.Count_And_Get (
162: p_encoded => FND_API.G_FALSE,
163: p_count => x_msg_count,
164: p_data => x_msg_data
200: WHERE EXISTS (SELECT 1 FROM AMS_DM_LIFT
201: WHERE LIFT_ID = l_id);
202:
203: BEGIN
204: -- Standard Start of API savepoint
205: SAVEPOINT Create_Lift_PVT;
206:
207: -- Standard call to check for call compatibility.
208: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
203: BEGIN
204: -- Standard Start of API savepoint
205: SAVEPOINT Create_Lift_PVT;
206:
207: -- Standard call to check for call compatibility.
208: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
209: p_api_version,
210: l_api_name,
211: G_PKG_NAME)
306: --
307: -- End of API body
308: --
309:
310: -- Standard check for p_commit
311: IF FND_API.to_Boolean( p_commit )
312: THEN
313: COMMIT WORK;
314: END IF;
319:
320: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
321: END IF;
322:
323: -- Standard call to get message count and if count is 1, get message info.
324: FND_MSG_PUB.Count_And_Get
325: (p_count => x_msg_count,
326: p_data => x_msg_data
327: );
336:
337: WHEN FND_API.G_EXC_ERROR THEN
338: ROLLBACK TO Create_Lift_PVT;
339: x_return_status := FND_API.G_RET_STS_ERROR;
340: -- Standard call to get message count and if count=1, get the message
341: FND_MSG_PUB.Count_And_Get (
342: p_encoded => FND_API.G_FALSE,
343: p_count => x_msg_count,
344: p_data => x_msg_data
346:
347: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
348: ROLLBACK TO Create_Lift_PVT;
349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
350: -- Standard call to get message count and if count=1, get the message
351: FND_MSG_PUB.Count_And_Get (
352: p_encoded => FND_API.G_FALSE,
353: p_count => x_msg_count,
354: p_data => x_msg_data
360: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
361: THEN
362: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
363: END IF;
364: -- Standard call to get message count and if count=1, get the message
365: FND_MSG_PUB.Count_And_Get (
366: p_encoded => FND_API.G_FALSE,
367: p_count => x_msg_count,
368: p_data => x_msg_data
399: l_ref_Lift_rec c_get_Dmlift%ROWTYPE ;
400: l_tar_Lift_rec AMS_DMLift_PVT.Lift_rec_type := P_Lift_rec;
401: l_rowid ROWID;
402: BEGIN
403: -- Standard Start of API savepoint
404: SAVEPOINT Update_Lift_PVT;
405:
406: -- Standard call to check for call compatibility.
407: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
402: BEGIN
403: -- Standard Start of API savepoint
404: SAVEPOINT Update_Lift_PVT;
405:
406: -- Standard call to check for call compatibility.
407: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
408: p_api_version,
409: l_api_name,
410: G_PKG_NAME)
524: --
525: -- End of API body.
526: --
527:
528: -- Standard check for p_commit
529: IF FND_API.to_Boolean( p_commit )
530: THEN
531: COMMIT WORK;
532: END IF;
537:
538: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
539: END IF;
540:
541: -- Standard call to get message count and if count is 1, get message info.
542: FND_MSG_PUB.Count_And_Get
543: (p_count => x_msg_count,
544: p_data => x_msg_data
545: );
554:
555: WHEN FND_API.G_EXC_ERROR THEN
556: ROLLBACK TO Update_Lift_PVT;
557: x_return_status := FND_API.G_RET_STS_ERROR;
558: -- Standard call to get message count and if count=1, get the message
559: FND_MSG_PUB.Count_And_Get (
560: p_encoded => FND_API.G_FALSE,
561: p_count => x_msg_count,
562: p_data => x_msg_data
564:
565: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
566: ROLLBACK TO Update_Lift_PVT;
567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
568: -- Standard call to get message count and if count=1, get the message
569: FND_MSG_PUB.Count_And_Get (
570: p_encoded => FND_API.G_FALSE,
571: p_count => x_msg_count,
572: p_data => x_msg_data
578: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
579: THEN
580: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
581: END IF;
582: -- Standard call to get message count and if count=1, get the message
583: FND_MSG_PUB.Count_And_Get (
584: p_encoded => FND_API.G_FALSE,
585: p_count => x_msg_count,
586: p_data => x_msg_data
605: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
606: l_object_version_number NUMBER;
607:
608: BEGIN
609: -- Standard Start of API savepoint
610: SAVEPOINT Delete_Lift_PVT;
611:
612: -- Standard call to check for call compatibility.
613: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
608: BEGIN
609: -- Standard Start of API savepoint
610: SAVEPOINT Delete_Lift_PVT;
611:
612: -- Standard call to check for call compatibility.
613: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
614: p_api_version,
615: l_api_name,
616: G_PKG_NAME)
655: --
656: -- End of API body
657: --
658:
659: -- Standard check for p_commit
660: IF FND_API.to_Boolean( p_commit )
661: THEN
662: COMMIT WORK;
663: END IF;
668:
669: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
670: END IF;
671:
672: -- Standard call to get message count and if count is 1, get message info.
673: FND_MSG_PUB.Count_And_Get
674: (p_count => x_msg_count,
675: p_data => x_msg_data
676: );
685:
686: WHEN FND_API.G_EXC_ERROR THEN
687: ROLLBACK TO Delete_Lift_PVT;
688: x_return_status := FND_API.G_RET_STS_ERROR;
689: -- Standard call to get message count and if count=1, get the message
690: FND_MSG_PUB.Count_And_Get (
691: p_encoded => FND_API.G_FALSE,
692: p_count => x_msg_count,
693: p_data => x_msg_data
695:
696: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
697: ROLLBACK TO Delete_Lift_PVT;
698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
699: -- Standard call to get message count and if count=1, get the message
700: FND_MSG_PUB.Count_And_Get (
701: p_encoded => FND_API.G_FALSE,
702: p_count => x_msg_count,
703: p_data => x_msg_data
709: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
710: THEN
711: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
712: END IF;
713: -- Standard call to get message count and if count=1, get the message
714: FND_MSG_PUB.Count_And_Get (
715: p_encoded => FND_API.G_FALSE,
716: p_count => x_msg_count,
717: p_data => x_msg_data
957: l_object_version_number NUMBER;
958: l_Lift_rec AMS_DMLift_PVT.Lift_rec_type;
959:
960: BEGIN
961: -- Standard Start of API savepoint
962: SAVEPOINT Validate_Lift_;
963:
964: -- Standard call to check for call compatibility.
965: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
960: BEGIN
961: -- Standard Start of API savepoint
962: SAVEPOINT Validate_Lift_;
963:
964: -- Standard call to check for call compatibility.
965: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
966: p_api_version,
967: l_api_name,
968: G_PKG_NAME)
1027:
1028: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1029: END IF;
1030:
1031: -- Standard call to get message count and if count is 1, get message info.
1032: FND_MSG_PUB.Count_And_Get
1033: (p_count => x_msg_count,
1034: p_data => x_msg_data
1035: );
1043: END IF;
1044:
1045: WHEN FND_API.G_EXC_ERROR THEN
1046: x_return_status := FND_API.G_RET_STS_ERROR;
1047: -- Standard call to get message count and if count=1, get the message
1048: FND_MSG_PUB.Count_And_Get (
1049: p_encoded => FND_API.G_FALSE,
1050: p_count => x_msg_count,
1051: p_data => x_msg_data
1052: );
1053:
1054: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1056: -- Standard call to get message count and if count=1, get the message
1057: FND_MSG_PUB.Count_And_Get (
1058: p_encoded => FND_API.G_FALSE,
1059: p_count => x_msg_count,
1060: p_data => x_msg_data
1065: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1066: THEN
1067: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1068: END IF;
1069: -- Standard call to get message count and if count=1, get the message
1070: FND_MSG_PUB.Count_And_Get (
1071: p_encoded => FND_API.G_FALSE,
1072: p_count => x_msg_count,
1073: p_data => x_msg_data
1103: IF (AMS_DEBUG_HIGH_ON) THEN
1104:
1105: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1106: END IF;
1107: -- Standard call to get message count and if count is 1, get message info.
1108: FND_MSG_PUB.Count_And_Get
1109: (p_count => x_msg_count,
1110: p_data => x_msg_data
1111: );