[Home] [Help]
56: FROM PV_Attr_PrincipalS
57: WHERE Attr_Principal_ID = l_id;
58:
59: BEGIN
60: -- Standard Start of API savepoint
61: SAVEPOINT CREATE_Attr_Principal_PVT;
62:
63: -- Standard call to check for call compatibility.
64: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
59: BEGIN
60: -- Standard Start of API savepoint
61: SAVEPOINT CREATE_Attr_Principal_PVT;
62:
63: -- Standard call to check for call compatibility.
64: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
65: p_api_version_number,
66: l_api_name,
67: G_PKG_NAME)
179: --
180: -- End of API body
181: --
182:
183: -- Standard check for p_commit
184: IF FND_API.to_Boolean( p_commit )
185: THEN
186: COMMIT WORK;
187: END IF;
191: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
192: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
193: END IF;
194:
195: -- Standard call to get message count and if count is 1, get message info.
196: FND_MSG_PUB.Count_And_Get
197: (p_count => x_msg_count,
198: p_data => x_msg_data
199: );
205: */
206: WHEN FND_API.G_EXC_ERROR THEN
207: ROLLBACK TO CREATE_Attr_Principal_PVT;
208: x_return_status := FND_API.G_RET_STS_ERROR;
209: -- Standard call to get message count and if count=1, get the message
210: FND_MSG_PUB.Count_And_Get (
211: p_encoded => FND_API.G_FALSE,
212: p_count => x_msg_count,
213: p_data => x_msg_data
215:
216: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
217: ROLLBACK TO CREATE_Attr_Principal_PVT;
218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
219: -- Standard call to get message count and if count=1, get the message
220: FND_MSG_PUB.Count_And_Get (
221: p_encoded => FND_API.G_FALSE,
222: p_count => x_msg_count,
223: p_data => x_msg_data
229: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
230: THEN
231: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
232: END IF;
233: -- Standard call to get message count and if count=1, get the message
234: FND_MSG_PUB.Count_And_Get (
235: p_encoded => FND_API.G_FALSE,
236: p_count => x_msg_count,
237: p_data => x_msg_data
269: l_tar_Attr_Principal_rec PV_Attr_Principal_PVT.Attr_Principal_rec_type := P_Attr_Principal_rec;
270: l_rowid ROWID;
271:
272: BEGIN
273: -- Standard Start of API savepoint
274: SAVEPOINT UPDATE_Attr_Principal_PVT;
275:
276: -- Standard call to check for call compatibility.
277: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
272: BEGIN
273: -- Standard Start of API savepoint
274: SAVEPOINT UPDATE_Attr_Principal_PVT;
275:
276: -- Standard call to check for call compatibility.
277: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
278: p_api_version_number,
279: l_api_name,
280: G_PKG_NAME)
395: --
396: -- End of API body.
397: --
398:
399: -- Standard check for p_commit
400: IF FND_API.to_Boolean( p_commit )
401: THEN
402: COMMIT WORK;
403: END IF;
407: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
408: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
409: END IF;
410:
411: -- Standard call to get message count and if count is 1, get message info.
412: FND_MSG_PUB.Count_And_Get
413: (p_count => x_msg_count,
414: p_data => x_msg_data
415: );
421: */
422: WHEN FND_API.G_EXC_ERROR THEN
423: ROLLBACK TO UPDATE_Attr_Principal_PVT;
424: x_return_status := FND_API.G_RET_STS_ERROR;
425: -- Standard call to get message count and if count=1, get the message
426: FND_MSG_PUB.Count_And_Get (
427: p_encoded => FND_API.G_FALSE,
428: p_count => x_msg_count,
429: p_data => x_msg_data
431:
432: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
433: ROLLBACK TO UPDATE_Attr_Principal_PVT;
434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
435: -- Standard call to get message count and if count=1, get the message
436: FND_MSG_PUB.Count_And_Get (
437: p_encoded => FND_API.G_FALSE,
438: p_count => x_msg_count,
439: p_data => x_msg_data
445: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
446: THEN
447: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
448: END IF;
449: -- Standard call to get message count and if count=1, get the message
450: FND_MSG_PUB.Count_And_Get (
451: p_encoded => FND_API.G_FALSE,
452: p_count => x_msg_count,
453: p_data => x_msg_data
475: l_api_version_number CONSTANT NUMBER := 1.0;
476: l_object_version_number NUMBER;
477:
478: BEGIN
479: -- Standard Start of API savepoint
480: SAVEPOINT DELETE_Attr_Principal_PVT;
481:
482: -- Standard call to check for call compatibility.
483: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
478: BEGIN
479: -- Standard Start of API savepoint
480: SAVEPOINT DELETE_Attr_Principal_PVT;
481:
482: -- Standard call to check for call compatibility.
483: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
484: p_api_version_number,
485: l_api_name,
486: G_PKG_NAME)
518: --
519: -- End of API body
520: --
521:
522: -- Standard check for p_commit
523: IF FND_API.to_Boolean( p_commit )
524: THEN
525: COMMIT WORK;
526: END IF;
530: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
531: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
532: END IF;
533:
534: -- Standard call to get message count and if count is 1, get message info.
535: FND_MSG_PUB.Count_And_Get
536: (p_count => x_msg_count,
537: p_data => x_msg_data
538: );
544: */
545: WHEN FND_API.G_EXC_ERROR THEN
546: ROLLBACK TO DELETE_Attr_Principal_PVT;
547: x_return_status := FND_API.G_RET_STS_ERROR;
548: -- Standard call to get message count and if count=1, get the message
549: FND_MSG_PUB.Count_And_Get (
550: p_encoded => FND_API.G_FALSE,
551: p_count => x_msg_count,
552: p_data => x_msg_data
554:
555: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
556: ROLLBACK TO DELETE_Attr_Principal_PVT;
557: x_return_status := FND_API.G_RET_STS_UNEXP_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
568: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
569: THEN
570: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
571: END IF;
572: -- Standard call to get message count and if count=1, get the message
573: FND_MSG_PUB.Count_And_Get (
574: p_encoded => FND_API.G_FALSE,
575: p_count => x_msg_count,
576: p_data => x_msg_data
617: THEN
618: FND_MSG_PUB.initialize;
619: END IF;
620:
621: -- Standard call to check for call compatibility.
622: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
623: p_api_version_number,
624: l_api_name,
625: G_PKG_NAME)
669: */
670: WHEN FND_API.G_EXC_ERROR THEN
671: ROLLBACK TO LOCK_Attr_Principal_PVT;
672: x_return_status := FND_API.G_RET_STS_ERROR;
673: -- Standard call to get message count and if count=1, get the message
674: FND_MSG_PUB.Count_And_Get (
675: p_encoded => FND_API.G_FALSE,
676: p_count => x_msg_count,
677: p_data => x_msg_data
679:
680: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
681: ROLLBACK TO LOCK_Attr_Principal_PVT;
682: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
683: -- Standard call to get message count and if count=1, get the message
684: FND_MSG_PUB.Count_And_Get (
685: p_encoded => FND_API.G_FALSE,
686: p_count => x_msg_count,
687: p_data => x_msg_data
693: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
694: THEN
695: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
696: END IF;
697: -- Standard call to get message count and if count=1, get the message
698: FND_MSG_PUB.Count_And_Get (
699: p_encoded => FND_API.G_FALSE,
700: p_count => x_msg_count,
701: p_data => x_msg_data
1096: l_object_version_number NUMBER;
1097: l_Attr_Principal_rec PV_Attr_Principal_PVT.Attr_Principal_rec_type;
1098:
1099: BEGIN
1100: -- Standard Start of API savepoint
1101: SAVEPOINT VALIDATE_Attr_Principal;
1102:
1103: -- Standard call to check for call compatibility.
1104: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1099: BEGIN
1100: -- Standard Start of API savepoint
1101: SAVEPOINT VALIDATE_Attr_Principal;
1102:
1103: -- Standard call to check for call compatibility.
1104: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1105: p_api_version_number,
1106: l_api_name,
1107: G_PKG_NAME)
1162: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1163: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
1164: END IF;
1165:
1166: -- Standard call to get message count and if count is 1, get message info.
1167: FND_MSG_PUB.Count_And_Get
1168: (p_count => x_msg_count,
1169: p_data => x_msg_data
1170: );
1176: */
1177: WHEN FND_API.G_EXC_ERROR THEN
1178: ROLLBACK TO VALIDATE_Attr_Principal;
1179: x_return_status := FND_API.G_RET_STS_ERROR;
1180: -- Standard call to get message count and if count=1, get the message
1181: FND_MSG_PUB.Count_And_Get (
1182: p_encoded => FND_API.G_FALSE,
1183: p_count => x_msg_count,
1184: p_data => x_msg_data
1186:
1187: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1188: ROLLBACK TO VALIDATE_Attr_Principal;
1189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1190: -- Standard call to get message count and if count=1, get the message
1191: FND_MSG_PUB.Count_And_Get (
1192: p_encoded => FND_API.G_FALSE,
1193: p_count => x_msg_count,
1194: p_data => x_msg_data
1200: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1201: THEN
1202: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1203: END IF;
1204: -- Standard call to get message count and if count=1, get the message
1205: FND_MSG_PUB.Count_And_Get (
1206: p_encoded => FND_API.G_FALSE,
1207: p_count => x_msg_count,
1208: p_data => x_msg_data
1238: -- Debug Message
1239: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1240: PVX_Utility_PVT.debug_message('Private API: Validate_dm_model_rec');
1241: END IF;
1242: -- Standard call to get message count and if count is 1, get message info.
1243: FND_MSG_PUB.Count_And_Get
1244: (p_count => x_msg_count,
1245: p_data => x_msg_data
1246: );