[Home] [Help]
56: FROM PV_ATTRIBUTE_USAGES
57: WHERE ATTRIBUTE_USAGE_ID = l_id;
58:
59: BEGIN
60: -- Standard Start of API savepoint
61: SAVEPOINT CREATE_Attribute_Usage_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_Attribute_Usage_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)
186: --
187: -- End of API body
188: --
189:
190: -- Standard check for p_commit
191: IF FND_API.to_Boolean( p_commit )
192: THEN
193: COMMIT WORK;
194: END IF;
198: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
199: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
200: END IF;
201:
202: -- Standard call to get message count and if count is 1, get message info.
203: FND_MSG_PUB.Count_And_Get
204: (p_count => x_msg_count,
205: p_data => x_msg_data
206: );
212: */
213: WHEN FND_API.G_EXC_ERROR THEN
214: ROLLBACK TO CREATE_Attribute_Usage_PVT;
215: x_return_status := FND_API.G_RET_STS_ERROR;
216: -- Standard call to get message count and if count=1, get the message
217: FND_MSG_PUB.Count_And_Get (
218: p_encoded => FND_API.G_FALSE,
219: p_count => x_msg_count,
220: p_data => x_msg_data
222:
223: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
224: ROLLBACK TO CREATE_Attribute_Usage_PVT;
225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
226: -- Standard call to get message count and if count=1, get the message
227: FND_MSG_PUB.Count_And_Get (
228: p_encoded => FND_API.G_FALSE,
229: p_count => x_msg_count,
230: p_data => x_msg_data
236: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
237: THEN
238: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
239: END IF;
240: -- Standard call to get message count and if count=1, get the message
241: FND_MSG_PUB.Count_And_Get (
242: p_encoded => FND_API.G_FALSE,
243: p_count => x_msg_count,
244: p_data => x_msg_data
276: l_tar_attribute_usage_rec PV_Attribute_Usage_PVT.attribute_usage_rec_type := P_attribute_usage_rec;
277: l_rowid ROWID;
278:
279: BEGIN
280: -- Standard Start of API savepoint
281: SAVEPOINT UPDATE_Attribute_Usage_PVT;
282:
283: -- Standard call to check for call compatibility.
284: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
279: BEGIN
280: -- Standard Start of API savepoint
281: SAVEPOINT UPDATE_Attribute_Usage_PVT;
282:
283: -- Standard call to check for call compatibility.
284: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
285: p_api_version_number,
286: l_api_name,
287: G_PKG_NAME)
408: --
409: -- End of API body.
410: --
411:
412: -- Standard check for p_commit
413: IF FND_API.to_Boolean( p_commit )
414: THEN
415: COMMIT WORK;
416: END IF;
420: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
421: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
422: END IF;
423:
424: -- Standard call to get message count and if count is 1, get message info.
425: FND_MSG_PUB.Count_And_Get
426: (p_count => x_msg_count,
427: p_data => x_msg_data
428: );
434: */
435: WHEN FND_API.G_EXC_ERROR THEN
436: ROLLBACK TO UPDATE_Attribute_Usage_PVT;
437: x_return_status := FND_API.G_RET_STS_ERROR;
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
444:
445: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
446: ROLLBACK TO UPDATE_Attribute_Usage_PVT;
447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
448: -- Standard call to get message count and if count=1, get the message
449: FND_MSG_PUB.Count_And_Get (
450: p_encoded => FND_API.G_FALSE,
451: p_count => x_msg_count,
452: p_data => x_msg_data
458: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
459: THEN
460: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
461: END IF;
462: -- Standard call to get message count and if count=1, get the message
463: FND_MSG_PUB.Count_And_Get (
464: p_encoded => FND_API.G_FALSE,
465: p_count => x_msg_count,
466: p_data => x_msg_data
488: l_api_version_number CONSTANT NUMBER := 1.0;
489: l_object_version_number NUMBER;
490:
491: BEGIN
492: -- Standard Start of API savepoint
493: SAVEPOINT DELETE_Attribute_Usage_PVT;
494:
495: -- Standard call to check for call compatibility.
496: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
491: BEGIN
492: -- Standard Start of API savepoint
493: SAVEPOINT DELETE_Attribute_Usage_PVT;
494:
495: -- Standard call to check for call compatibility.
496: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
497: p_api_version_number,
498: l_api_name,
499: G_PKG_NAME)
531: --
532: -- End of API body
533: --
534:
535: -- Standard check for p_commit
536: IF FND_API.to_Boolean( p_commit )
537: THEN
538: COMMIT WORK;
539: END IF;
543: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
544: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
545: END IF;
546:
547: -- Standard call to get message count and if count is 1, get message info.
548: FND_MSG_PUB.Count_And_Get
549: (p_count => x_msg_count,
550: p_data => x_msg_data
551: );
557: */
558: WHEN FND_API.G_EXC_ERROR THEN
559: ROLLBACK TO DELETE_Attribute_Usage_PVT;
560: x_return_status := FND_API.G_RET_STS_ERROR;
561: -- Standard call to get message count and if count=1, get the message
562: FND_MSG_PUB.Count_And_Get (
563: p_encoded => FND_API.G_FALSE,
564: p_count => x_msg_count,
565: p_data => x_msg_data
567:
568: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
569: ROLLBACK TO DELETE_Attribute_Usage_PVT;
570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
571: -- Standard call to get message count and if count=1, get the message
572: FND_MSG_PUB.Count_And_Get (
573: p_encoded => FND_API.G_FALSE,
574: p_count => x_msg_count,
575: p_data => x_msg_data
581: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
582: THEN
583: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
584: END IF;
585: -- Standard call to get message count and if count=1, get the message
586: FND_MSG_PUB.Count_And_Get (
587: p_encoded => FND_API.G_FALSE,
588: p_count => x_msg_count,
589: p_data => x_msg_data
630: THEN
631: FND_MSG_PUB.initialize;
632: END IF;
633:
634: -- Standard call to check for call compatibility.
635: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
636: p_api_version_number,
637: l_api_name,
638: G_PKG_NAME)
682: */
683: WHEN FND_API.G_EXC_ERROR THEN
684: ROLLBACK TO LOCK_Attribute_Usage_PVT;
685: x_return_status := FND_API.G_RET_STS_ERROR;
686: -- Standard call to get message count and if count=1, get the message
687: FND_MSG_PUB.Count_And_Get (
688: p_encoded => FND_API.G_FALSE,
689: p_count => x_msg_count,
690: p_data => x_msg_data
692:
693: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
694: ROLLBACK TO LOCK_Attribute_Usage_PVT;
695: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
696: -- Standard call to get message count and if count=1, get the message
697: FND_MSG_PUB.Count_And_Get (
698: p_encoded => FND_API.G_FALSE,
699: p_count => x_msg_count,
700: p_data => x_msg_data
706: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
707: THEN
708: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
709: END IF;
710: -- Standard call to get message count and if count=1, get the message
711: FND_MSG_PUB.Count_And_Get (
712: p_encoded => FND_API.G_FALSE,
713: p_count => x_msg_count,
714: p_data => x_msg_data
1198: l_object_version_number NUMBER;
1199: l_attribute_usage_rec PV_Attribute_Usage_PVT.attribute_usage_rec_type;
1200:
1201: BEGIN
1202: -- Standard Start of API savepoint
1203: SAVEPOINT VALIDATE_Attribute_Usage;
1204:
1205: -- Standard call to check for call compatibility.
1206: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1201: BEGIN
1202: -- Standard Start of API savepoint
1203: SAVEPOINT VALIDATE_Attribute_Usage;
1204:
1205: -- Standard call to check for call compatibility.
1206: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1207: p_api_version_number,
1208: l_api_name,
1209: G_PKG_NAME)
1268: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1269: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
1270: END IF;
1271:
1272: -- Standard call to get message count and if count is 1, get message info.
1273: FND_MSG_PUB.Count_And_Get
1274: (p_count => x_msg_count,
1275: p_data => x_msg_data
1276: );
1282: */
1283: WHEN FND_API.G_EXC_ERROR THEN
1284: ROLLBACK TO VALIDATE_Attribute_Usage;
1285: x_return_status := FND_API.G_RET_STS_ERROR;
1286: -- Standard call to get message count and if count=1, get the message
1287: FND_MSG_PUB.Count_And_Get (
1288: p_encoded => FND_API.G_FALSE,
1289: p_count => x_msg_count,
1290: p_data => x_msg_data
1292:
1293: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1294: ROLLBACK TO VALIDATE_Attribute_Usage;
1295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1296: -- Standard call to get message count and if count=1, get the message
1297: FND_MSG_PUB.Count_And_Get (
1298: p_encoded => FND_API.G_FALSE,
1299: p_count => x_msg_count,
1300: p_data => x_msg_data
1306: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1307: THEN
1308: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1309: END IF;
1310: -- Standard call to get message count and if count=1, get the message
1311: FND_MSG_PUB.Count_And_Get (
1312: p_encoded => FND_API.G_FALSE,
1313: p_count => x_msg_count,
1314: p_data => x_msg_data
1344: -- Debug Message
1345: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1346: PVX_Utility_PVT.debug_message('Private API: Validate_dm_model_rec');
1347: END IF;
1348: -- Standard call to get message count and if count is 1, get message info.
1349: FND_MSG_PUB.Count_And_Get
1350: (p_count => x_msg_count,
1351: p_data => x_msg_data
1352: );