[Home] [Help]
55: FROM PV_ATTRIBUTE_CODES_B
56: WHERE ATTR_CODE_ID = l_id;
57:
58: BEGIN
59: -- Standard Start of API savepoint
60: SAVEPOINT CREATE_Attribute_Code_PVT;
61:
62: -- Standard call to check for call compatibility.
63: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
58: BEGIN
59: -- Standard Start of API savepoint
60: SAVEPOINT CREATE_Attribute_Code_PVT;
61:
62: -- Standard call to check for call compatibility.
63: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
64: p_api_version_number,
65: l_api_name,
66: G_PKG_NAME)
184: --
185: -- End of API body
186: --
187:
188: -- Standard check for p_commit
189: IF FND_API.to_Boolean( p_commit )
190: THEN
191: COMMIT WORK;
192: END IF;
196: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
197: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
198: end if;
199:
200: -- Standard call to get message count and if count is 1, get message info.
201: FND_MSG_PUB.Count_And_Get
202: (p_count => x_msg_count,
203: p_data => x_msg_data
204: );
210: */
211: WHEN FND_API.G_EXC_ERROR THEN
212: ROLLBACK TO CREATE_Attribute_Code_PVT;
213: x_return_status := FND_API.G_RET_STS_ERROR;
214: -- Standard call to get message count and if count=1, get the message
215: FND_MSG_PUB.Count_And_Get (
216: p_encoded => FND_API.G_FALSE,
217: p_count => x_msg_count,
218: p_data => x_msg_data
220:
221: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
222: ROLLBACK TO CREATE_Attribute_Code_PVT;
223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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
234: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
235: THEN
236: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
237: END IF;
238: -- Standard call to get message count and if count=1, get the message
239: FND_MSG_PUB.Count_And_Get (
240: p_encoded => FND_API.G_FALSE,
241: p_count => x_msg_count,
242: p_data => x_msg_data
313:
314:
315:
316: BEGIN
317: -- Standard Start of API savepoint
318: SAVEPOINT UPDATE_Attribute_Code_PVT;
319:
320: -- Standard call to check for call compatibility.
321: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
316: BEGIN
317: -- Standard Start of API savepoint
318: SAVEPOINT UPDATE_Attribute_Code_PVT;
319:
320: -- Standard call to check for call compatibility.
321: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
322: p_api_version_number,
323: l_api_name,
324: G_PKG_NAME)
536: --
537: -- End of API body.
538: --
539:
540: -- Standard check for p_commit
541: IF FND_API.to_Boolean( p_commit )
542: THEN
543: COMMIT WORK;
544: END IF;
548: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
549: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
550: end if;
551:
552: -- Standard call to get message count and if count is 1, get message info.
553: FND_MSG_PUB.Count_And_Get
554: (p_count => x_msg_count,
555: p_data => x_msg_data
556: );
562: */
563: WHEN FND_API.G_EXC_ERROR THEN
564: ROLLBACK TO UPDATE_Attribute_Code_PVT;
565: x_return_status := FND_API.G_RET_STS_ERROR;
566: -- Standard call to get message count and if count=1, get the message
567: FND_MSG_PUB.Count_And_Get (
568: p_encoded => FND_API.G_FALSE,
569: p_count => x_msg_count,
570: p_data => x_msg_data
572:
573: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
574: ROLLBACK TO UPDATE_Attribute_Code_PVT;
575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
576: -- Standard call to get message count and if count=1, get the message
577: FND_MSG_PUB.Count_And_Get (
578: p_encoded => FND_API.G_FALSE,
579: p_count => x_msg_count,
580: p_data => x_msg_data
586: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
587: THEN
588: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
589: END IF;
590: -- Standard call to get message count and if count=1, get the message
591: FND_MSG_PUB.Count_And_Get (
592: p_encoded => FND_API.G_FALSE,
593: p_count => x_msg_count,
594: p_data => x_msg_data
655: where code.attr_code_id=pc_attr_code_id and
656: code.attr_code=usage.attribute_usage_code;
657:
658: BEGIN
659: -- Standard Start of API savepoint
660: SAVEPOINT DELETE_Attribute_Code_PVT;
661:
662: -- Standard call to check for call compatibility.
663: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
658: BEGIN
659: -- Standard Start of API savepoint
660: SAVEPOINT DELETE_Attribute_Code_PVT;
661:
662: -- Standard call to check for call compatibility.
663: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
664: p_api_version_number,
665: l_api_name,
666: G_PKG_NAME)
846: --
847: -- End of API body
848: --
849:
850: -- Standard check for p_commit
851: IF FND_API.to_Boolean( p_commit )
852: THEN
853: COMMIT WORK;
854: END IF;
858: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
859: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
860: END IF;
861:
862: -- Standard call to get message count and if count is 1, get message info.
863: FND_MSG_PUB.Count_And_Get
864: (p_count => x_msg_count,
865: p_data => x_msg_data
866: );
872: */
873: WHEN FND_API.G_EXC_ERROR THEN
874: ROLLBACK TO DELETE_Attribute_Code_PVT;
875: x_return_status := FND_API.G_RET_STS_ERROR;
876: -- Standard call to get message count and if count=1, get the message
877: FND_MSG_PUB.Count_And_Get (
878: p_encoded => FND_API.G_FALSE,
879: p_count => x_msg_count,
880: p_data => x_msg_data
882:
883: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
884: ROLLBACK TO DELETE_Attribute_Code_PVT;
885: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
886: -- Standard call to get message count and if count=1, get the message
887: FND_MSG_PUB.Count_And_Get (
888: p_encoded => FND_API.G_FALSE,
889: p_count => x_msg_count,
890: p_data => x_msg_data
896: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
897: THEN
898: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
899: END IF;
900: -- Standard call to get message count and if count=1, get the message
901: FND_MSG_PUB.Count_And_Get (
902: p_encoded => FND_API.G_FALSE,
903: p_count => x_msg_count,
904: p_data => x_msg_data
933: AND object_version_number = p_object_version
934: FOR UPDATE NOWAIT;
935:
936: BEGIN
937: -- Standard Start of API savepoint
938: SAVEPOINT LOCK_Attribute_Code_PVT;
939:
940: -- Debug Message
941: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
947: THEN
948: FND_MSG_PUB.initialize;
949: END IF;
950:
951: -- Standard call to check for call compatibility.
952: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
953: p_api_version_number,
954: l_api_name,
955: G_PKG_NAME)
996: */
997: WHEN FND_API.G_EXC_ERROR THEN
998: ROLLBACK TO LOCK_Attribute_Code_PVT;
999: x_return_status := FND_API.G_RET_STS_ERROR;
1000: -- Standard call to get message count and if count=1, get the message
1001: FND_MSG_PUB.Count_And_Get (
1002: p_encoded => FND_API.G_FALSE,
1003: p_count => x_msg_count,
1004: p_data => x_msg_data
1006:
1007: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1008: ROLLBACK TO LOCK_Attribute_Code_PVT;
1009: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1010: -- Standard call to get message count and if count=1, get the message
1011: FND_MSG_PUB.Count_And_Get (
1012: p_encoded => FND_API.G_FALSE,
1013: p_count => x_msg_count,
1014: p_data => x_msg_data
1020: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1021: THEN
1022: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1023: END IF;
1024: -- Standard call to get message count and if count=1, get the message
1025: FND_MSG_PUB.Count_And_Get (
1026: p_encoded => FND_API.G_FALSE,
1027: p_count => x_msg_count,
1028: p_data => x_msg_data
1520: l_object_version_number NUMBER;
1521: l_attribute_code_rec PV_Attribute_Code_PVT.attribute_code_rec_type;
1522:
1523: BEGIN
1524: -- Standard Start of API savepoint
1525: SAVEPOINT Validate_Attribute_Code;
1526:
1527: -- Standard call to check for call compatibility.
1528: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1523: BEGIN
1524: -- Standard Start of API savepoint
1525: SAVEPOINT Validate_Attribute_Code;
1526:
1527: -- Standard call to check for call compatibility.
1528: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1529: p_api_version_number,
1530: l_api_name,
1531: G_PKG_NAME)
1590: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1591: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
1592: END IF;
1593:
1594: -- Standard call to get message count and if count is 1, get message info.
1595: FND_MSG_PUB.Count_And_Get
1596: (p_count => x_msg_count,
1597: p_data => x_msg_data
1598: );
1604: */
1605: WHEN FND_API.G_EXC_ERROR THEN
1606: ROLLBACK TO Validate_Attribute_Code;
1607: x_return_status := FND_API.G_RET_STS_ERROR;
1608: -- Standard call to get message count and if count=1, get the message
1609: FND_MSG_PUB.Count_And_Get (
1610: p_encoded => FND_API.G_FALSE,
1611: p_count => x_msg_count,
1612: p_data => x_msg_data
1614:
1615: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1616: ROLLBACK TO Validate_Attribute_Code;
1617: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1618: -- Standard call to get message count and if count=1, get the message
1619: FND_MSG_PUB.Count_And_Get (
1620: p_encoded => FND_API.G_FALSE,
1621: p_count => x_msg_count,
1622: p_data => x_msg_data
1628: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1629: THEN
1630: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1631: END IF;
1632: -- Standard call to get message count and if count=1, get the message
1633: FND_MSG_PUB.Count_And_Get (
1634: p_encoded => FND_API.G_FALSE,
1635: p_count => x_msg_count,
1636: p_data => x_msg_data
1667: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1668: PVX_Utility_PVT.debug_message('Private API: Validate_dm_model_rec');
1669: END IF;
1670:
1671: -- Standard call to get message count and if count is 1, get message info.
1672: FND_MSG_PUB.Count_And_Get
1673: (p_count => x_msg_count,
1674: p_data => x_msg_data
1675: );