[Home] [Help]
52: FROM AMS_ACT_LIST_GROUPS
53: WHERE ACT_LIST_GROUP_ID = l_id;
54:
55: BEGIN
56: -- Standard Start of API savepoint
57: SAVEPOINT CREATE_List_Group_PVT;
58:
59: -- Standard call to check for call compatibility.
60: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
55: BEGIN
56: -- Standard Start of API savepoint
57: SAVEPOINT CREATE_List_Group_PVT;
58:
59: -- Standard call to check for call compatibility.
60: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
61: p_api_version_number,
62: l_api_name,
63: G_PKG_NAME)
169: -- End of API body
170: --
171:
172: x_act_list_group_id := l_act_list_group_id;
173: -- Standard check for p_commit
174: IF FND_API.to_Boolean( p_commit )
175: THEN
176: COMMIT WORK;
177: END IF;
182:
183: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
184: END IF;
185:
186: -- Standard call to get message count and if count is 1, get message info.
187: FND_MSG_PUB.Count_And_Get
188: (p_count => x_msg_count,
189: p_data => x_msg_data
190: );
196:
197: WHEN FND_API.G_EXC_ERROR THEN
198: ROLLBACK TO CREATE_List_Group_PVT;
199: x_return_status := FND_API.G_RET_STS_ERROR;
200: -- Standard call to get message count and if count=1, get the message
201: FND_MSG_PUB.Count_And_Get (
202: p_encoded => FND_API.G_FALSE,
203: p_count => x_msg_count,
204: p_data => x_msg_data
206:
207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
208: ROLLBACK TO CREATE_List_Group_PVT;
209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
210: -- Standard call to get message count and if count=1, get the message
211: FND_MSG_PUB.Count_And_Get (
212: p_encoded => FND_API.G_FALSE,
213: p_count => x_msg_count,
214: p_data => x_msg_data
220: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
221: THEN
222: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
223: END IF;
224: -- Standard call to get message count and if count=1, get the message
225: FND_MSG_PUB.Count_And_Get (
226: p_encoded => FND_API.G_FALSE,
227: p_count => x_msg_count,
228: p_data => x_msg_data
258: l_tar_list_group_rec AMS_List_Group_PVT.list_group_rec_type := P_list_group_rec;
259: l_rowid ROWID;
260:
261: BEGIN
262: -- Standard Start of API savepoint
263: SAVEPOINT UPDATE_List_Group_PVT;
264:
265: -- Standard call to check for call compatibility.
266: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
261: BEGIN
262: -- Standard Start of API savepoint
263: SAVEPOINT UPDATE_List_Group_PVT;
264:
265: -- Standard call to check for call compatibility.
266: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
267: p_api_version_number,
268: l_api_name,
269: G_PKG_NAME)
383: --
384: -- End of API body.
385: --
386:
387: -- Standard check for p_commit
388: IF FND_API.to_Boolean( p_commit )
389: THEN
390: COMMIT WORK;
391: END IF;
396:
397: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
398: END IF;
399:
400: -- Standard call to get message count and if count is 1, get message info.
401: FND_MSG_PUB.Count_And_Get
402: (p_count => x_msg_count,
403: p_data => x_msg_data
404: );
410:
411: WHEN FND_API.G_EXC_ERROR THEN
412: ROLLBACK TO UPDATE_List_Group_PVT;
413: x_return_status := FND_API.G_RET_STS_ERROR;
414: -- Standard call to get message count and if count=1, get the message
415: FND_MSG_PUB.Count_And_Get (
416: p_encoded => FND_API.G_FALSE,
417: p_count => x_msg_count,
418: p_data => x_msg_data
420:
421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
422: ROLLBACK TO UPDATE_List_Group_PVT;
423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
424: -- Standard call to get message count and if count=1, get the message
425: FND_MSG_PUB.Count_And_Get (
426: p_encoded => FND_API.G_FALSE,
427: p_count => x_msg_count,
428: p_data => x_msg_data
434: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
435: THEN
436: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
437: END IF;
438: -- Standard call to get message count and if count=1, get the message
439: FND_MSG_PUB.Count_And_Get (
440: p_encoded => FND_API.G_FALSE,
441: p_count => x_msg_count,
442: p_data => x_msg_data
461: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
462: l_object_version_number NUMBER;
463:
464: BEGIN
465: -- Standard Start of API savepoint
466: SAVEPOINT DELETE_List_Group_PVT;
467:
468: -- Standard call to check for call compatibility.
469: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
464: BEGIN
465: -- Standard Start of API savepoint
466: SAVEPOINT DELETE_List_Group_PVT;
467:
468: -- Standard call to check for call compatibility.
469: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
470: p_api_version_number,
471: l_api_name,
472: G_PKG_NAME)
505: --
506: -- End of API body
507: --
508:
509: -- Standard check for p_commit
510: IF FND_API.to_Boolean( p_commit )
511: THEN
512: COMMIT WORK;
513: END IF;
518:
519: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
520: END IF;
521:
522: -- Standard call to get message count and if count is 1, get message info.
523: FND_MSG_PUB.Count_And_Get
524: (p_count => x_msg_count,
525: p_data => x_msg_data
526: );
532:
533: WHEN FND_API.G_EXC_ERROR THEN
534: ROLLBACK TO DELETE_List_Group_PVT;
535: x_return_status := FND_API.G_RET_STS_ERROR;
536: -- Standard call to get message count and if count=1, get the message
537: FND_MSG_PUB.Count_And_Get (
538: p_encoded => FND_API.G_FALSE,
539: p_count => x_msg_count,
540: p_data => x_msg_data
542:
543: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
544: ROLLBACK TO DELETE_List_Group_PVT;
545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
546: -- Standard call to get message count and if count=1, get the message
547: FND_MSG_PUB.Count_And_Get (
548: p_encoded => FND_API.G_FALSE,
549: p_count => x_msg_count,
550: p_data => x_msg_data
556: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
557: THEN
558: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
559: END IF;
560: -- Standard call to get message count and if count=1, get the message
561: FND_MSG_PUB.Count_And_Get (
562: p_encoded => FND_API.G_FALSE,
563: p_count => x_msg_count,
564: p_data => x_msg_data
606: THEN
607: FND_MSG_PUB.initialize;
608: END IF;
609:
610: -- Standard call to check for call compatibility.
611: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
612: p_api_version_number,
613: l_api_name,
614: G_PKG_NAME)
662:
663: WHEN FND_API.G_EXC_ERROR THEN
664: ROLLBACK TO LOCK_List_Group_PVT;
665: x_return_status := FND_API.G_RET_STS_ERROR;
666: -- Standard call to get message count and if count=1, get the message
667: FND_MSG_PUB.Count_And_Get (
668: p_encoded => FND_API.G_FALSE,
669: p_count => x_msg_count,
670: p_data => x_msg_data
672:
673: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
674: ROLLBACK TO LOCK_List_Group_PVT;
675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
676: -- Standard call to get message count and if count=1, get the message
677: FND_MSG_PUB.Count_And_Get (
678: p_encoded => FND_API.G_FALSE,
679: p_count => x_msg_count,
680: p_data => x_msg_data
686: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
687: THEN
688: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
689: END IF;
690: -- Standard call to get message count and if count=1, get the message
691: FND_MSG_PUB.Count_And_Get (
692: p_encoded => FND_API.G_FALSE,
693: p_count => x_msg_count,
694: p_data => x_msg_data
1076: l_object_version_number NUMBER;
1077: l_list_group_rec AMS_List_Group_PVT.list_group_rec_type;
1078:
1079: BEGIN
1080: -- Standard Start of API savepoint
1081: SAVEPOINT VALIDATE_List_Group_;
1082:
1083: -- Standard call to check for call compatibility.
1084: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1079: BEGIN
1080: -- Standard Start of API savepoint
1081: SAVEPOINT VALIDATE_List_Group_;
1082:
1083: -- Standard call to check for call compatibility.
1084: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1085: p_api_version_number,
1086: l_api_name,
1087: G_PKG_NAME)
1146:
1147: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1148: END IF;
1149:
1150: -- Standard call to get message count and if count is 1, get message info.
1151: FND_MSG_PUB.Count_And_Get
1152: (p_count => x_msg_count,
1153: p_data => x_msg_data
1154: );
1160:
1161: WHEN FND_API.G_EXC_ERROR THEN
1162: ROLLBACK TO VALIDATE_List_Group_;
1163: x_return_status := FND_API.G_RET_STS_ERROR;
1164: -- Standard call to get message count and if count=1, get the message
1165: FND_MSG_PUB.Count_And_Get (
1166: p_encoded => FND_API.G_FALSE,
1167: p_count => x_msg_count,
1168: p_data => x_msg_data
1170:
1171: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1172: ROLLBACK TO VALIDATE_List_Group_;
1173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1174: -- Standard call to get message count and if count=1, get the message
1175: FND_MSG_PUB.Count_And_Get (
1176: p_encoded => FND_API.G_FALSE,
1177: p_count => x_msg_count,
1178: p_data => x_msg_data
1184: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1185: THEN
1186: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1187: END IF;
1188: -- Standard call to get message count and if count=1, get the message
1189: FND_MSG_PUB.Count_And_Get (
1190: p_encoded => FND_API.G_FALSE,
1191: p_count => x_msg_count,
1192: p_data => x_msg_data
1222: IF (AMS_DEBUG_HIGH_ON) THEN
1223:
1224: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1225: END IF;
1226: -- Standard call to get message count and if count is 1, get message info.
1227: FND_MSG_PUB.Count_And_Get
1228: (p_count => x_msg_count,
1229: p_data => x_msg_data
1230: );