[Home] [Help]
68: where attribute_id=cv_attribute_id
69: ;
70:
71: BEGIN
72: -- Standard Start of API savepoint
73: SAVEPOINT Create_Entity_Attr_PVT;
74:
75: -- Standard call to check for call compatibility.
76: IF NOT Fnd_Api.Compatible_API_Call ( l_api_version_number,
71: BEGIN
72: -- Standard Start of API savepoint
73: SAVEPOINT Create_Entity_Attr_PVT;
74:
75: -- Standard call to check for call compatibility.
76: IF NOT Fnd_Api.Compatible_API_Call ( l_api_version_number,
77: p_api_version_number,
78: l_api_name,
79: G_PKG_NAME)
311: END IF;
312: --
313: -- End of API body
314: --
315: -- Standard check for p_commit
316: IF Fnd_Api.to_Boolean( p_commit )
317: THEN
318: COMMIT WORK;
319: END IF;
320: -- Debug Message
321: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
322: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'end');
323: END IF;
324: -- Standard call to get message count and if count is 1, get message info.
325: Fnd_Msg_Pub.Count_And_Get
326: (p_count => x_msg_count,
327: p_data => x_msg_data
328: );
334: */
335: WHEN Fnd_Api.G_EXC_ERROR THEN
336: ROLLBACK TO Create_Entity_Attr_PVT;
337: x_return_status := Fnd_Api.G_RET_STS_ERROR;
338: -- Standard call to get message count and if count=1, get the message
339: Fnd_Msg_Pub.Count_And_Get (
340: p_encoded => Fnd_Api.G_FALSE,
341: p_count => x_msg_count,
342: p_data => x_msg_data
343: );
344: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
345: ROLLBACK TO Create_Entity_Attr_PVT;
346: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
347: -- Standard call to get message count and if count=1, get the message
348: Fnd_Msg_Pub.Count_And_Get (
349: p_encoded => Fnd_Api.G_FALSE,
350: p_count => x_msg_count,
351: p_data => x_msg_data
356: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
357: THEN
358: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
359: END IF;
360: -- Standard call to get message count and if count=1, get the message
361: Fnd_Msg_Pub.Count_And_Get (
362: p_encoded => Fnd_Api.G_FALSE,
363: p_count => x_msg_count,
364: p_data => x_msg_data
407: l_lov_string varchar2(2000);
408:
409: BEGIN
410:
411: -- Standard Start of API savepoint
412: SAVEPOINT Update_Entity_Attr_PVT;
413: -- Standard call to check for call compatibility.
414: IF NOT Fnd_Api.Compatible_API_Call ( l_api_version_number,
415: p_api_version_number,
409: BEGIN
410:
411: -- Standard Start of API savepoint
412: SAVEPOINT Update_Entity_Attr_PVT;
413: -- Standard call to check for call compatibility.
414: IF NOT Fnd_Api.Compatible_API_Call ( l_api_version_number,
415: p_api_version_number,
416: l_api_name,
417: G_PKG_NAME)
595: x_object_version_number := p_entity_attr_rec.object_version_number + 1;
596: --
597: -- End of API body.
598: --
599: -- Standard check for p_commit
600: IF Fnd_Api.to_Boolean( p_commit )
601: THEN
602: COMMIT WORK;
603: END IF;
604: -- Debug Message
605: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
606: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'end');
607: END IF;
608: -- Standard call to get message count and if count is 1, get message info.
609: Fnd_Msg_Pub.Count_And_Get
610: (p_count => x_msg_count,
611: p_data => x_msg_data
612: );
618: */
619: WHEN Fnd_Api.G_EXC_ERROR THEN
620: ROLLBACK TO Update_Entity_Attr_PVT;
621: x_return_status := Fnd_Api.G_RET_STS_ERROR;
622: -- Standard call to get message count and if count=1, get the message
623: Fnd_Msg_Pub.Count_And_Get (
624: p_encoded => Fnd_Api.G_FALSE,
625: p_count => x_msg_count,
626: p_data => x_msg_data
627: );
628: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
629: ROLLBACK TO Update_Entity_Attr_PVT;
630: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
631: -- Standard call to get message count and if count=1, get the message
632: Fnd_Msg_Pub.Count_And_Get (
633: p_encoded => Fnd_Api.G_FALSE,
634: p_count => x_msg_count,
635: p_data => x_msg_data
640: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
641: THEN
642: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
643: END IF;
644: -- Standard call to get message count and if count=1, get the message
645: Fnd_Msg_Pub.Count_And_Get (
646: p_encoded => Fnd_Api.G_FALSE,
647: p_count => x_msg_count,
648: p_data => x_msg_data
685: ;
686:
687:
688: BEGIN
689: -- Standard Start of API savepoint
690: SAVEPOINT Validate_sql_text;
691:
692: -- Standard call to check for call compatibility.
693: IF NOT Fnd_Api.Compatible_API_Call ( l_api_version_number,
688: BEGIN
689: -- Standard Start of API savepoint
690: SAVEPOINT Validate_sql_text;
691:
692: -- Standard call to check for call compatibility.
693: IF NOT Fnd_Api.Compatible_API_Call ( l_api_version_number,
694: p_api_version_number,
695: l_api_name,
696: G_PKG_NAME)
840: -- Initialize API return status to SUCCESS
841: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
842: -- Debug Message
843: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'end');
844: -- Standard call to get message count and if count is 1, get message info.
845: Fnd_Msg_Pub.Count_And_Get
846: (p_count => x_msg_count
847: ,p_data => x_msg_data
848: );
854: */
855: WHEN Fnd_Api.G_EXC_ERROR THEN
856: ROLLBACK TO Validate_sql_text;
857: x_return_status := Fnd_Api.G_RET_STS_ERROR;
858: -- Standard call to get message count and if count=1, get the message
859: Fnd_Msg_Pub.Count_And_Get (
860: p_encoded => Fnd_Api.G_FALSE,
861: p_count => x_msg_count,
862: p_data => x_msg_data
863: );
864: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
865: ROLLBACK TO Validate_sql_text;
866: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
867: -- Standard call to get message count and if count=1, get the message
868: Fnd_Msg_Pub.Count_And_Get (
869: p_encoded => Fnd_Api.G_FALSE,
870: p_count => x_msg_count,
871: p_data => x_msg_data
877: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
878: THEN
879: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
880: END IF;
881: -- Standard call to get message count and if count=1, get the message
882: Fnd_Msg_Pub.Count_And_Get (
883: p_encoded => Fnd_Api.G_FALSE
884: ,p_count => x_msg_count
885: ,p_data => x_msg_data
927:
928: l_lov_string varchar2(2000);
929:
930: BEGIN
931: -- Standard Start of API savepoint
932: SAVEPOINT Validate_lov_string;
933:
934: -- Standard call to check for call compatibility.
935: IF NOT Fnd_Api.Compatible_API_Call ( l_api_version_number,
930: BEGIN
931: -- Standard Start of API savepoint
932: SAVEPOINT Validate_lov_string;
933:
934: -- Standard call to check for call compatibility.
935: IF NOT Fnd_Api.Compatible_API_Call ( l_api_version_number,
936: p_api_version_number,
937: l_api_name,
938: G_PKG_NAME)
1100: -- Initialize API return status to SUCCESS
1101: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1102: -- Debug Message
1103: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'end');
1104: -- Standard call to get message count and if count is 1, get message info.
1105: Fnd_Msg_Pub.Count_And_Get
1106: (p_count => x_msg_count
1107: ,p_data => x_msg_data
1108: );
1114: */
1115: WHEN Fnd_Api.G_EXC_ERROR THEN
1116: ROLLBACK TO Validate_lov_string;
1117: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1118: -- Standard call to get message count and if count=1, get the message
1119: Fnd_Msg_Pub.Count_And_Get (
1120: p_encoded => Fnd_Api.G_FALSE,
1121: p_count => x_msg_count,
1122: p_data => x_msg_data
1123: );
1124: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1125: ROLLBACK TO Validate_lov_string;
1126: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1127: -- Standard call to get message count and if count=1, get the message
1128: Fnd_Msg_Pub.Count_And_Get (
1129: p_encoded => Fnd_Api.G_FALSE,
1130: p_count => x_msg_count,
1131: p_data => x_msg_data
1137: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
1138: THEN
1139: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1140: END IF;
1141: -- Standard call to get message count and if count=1, get the message
1142: Fnd_Msg_Pub.Count_And_Get (
1143: p_encoded => Fnd_Api.G_FALSE
1144: ,p_count => x_msg_count
1145: ,p_data => x_msg_data
1190: enty.entity = val.entity
1191: ;
1192:
1193: BEGIN
1194: -- Standard Start of API savepoint
1195: SAVEPOINT Delete_Entity_Attr_PVT;
1196: -- Standard call to check for call compatibility.
1197: IF NOT Fnd_Api.Compatible_API_Call ( l_api_version_number,
1198: p_api_version_number,
1192:
1193: BEGIN
1194: -- Standard Start of API savepoint
1195: SAVEPOINT Delete_Entity_Attr_PVT;
1196: -- Standard call to check for call compatibility.
1197: IF NOT Fnd_Api.Compatible_API_Call ( l_api_version_number,
1198: p_api_version_number,
1199: l_api_name,
1200: G_PKG_NAME)
1284: p_ENTITY_ATTR_ID => p_ENTITY_ATTR_ID);
1285: --
1286: -- End of API body
1287: --
1288: -- Standard check for p_commit
1289: IF Fnd_Api.to_Boolean( p_commit )
1290: THEN
1291: COMMIT WORK;
1292: END IF;
1293: -- Debug Message
1294: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1295: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'end');
1296: END IF;
1297: -- Standard call to get message count and if count is 1, get message info.
1298: Fnd_Msg_Pub.Count_And_Get
1299: (p_count => x_msg_count,
1300: p_data => x_msg_data
1301: );
1307: */
1308: WHEN Fnd_Api.G_EXC_ERROR THEN
1309: ROLLBACK TO Delete_Entity_Attr_PVT;
1310: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1311: -- Standard call to get message count and if count=1, get the message
1312: Fnd_Msg_Pub.Count_And_Get (
1313: p_encoded => Fnd_Api.G_FALSE,
1314: p_count => x_msg_count,
1315: p_data => x_msg_data
1316: );
1317: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1318: ROLLBACK TO Delete_Entity_Attr_PVT;
1319: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1320: -- Standard call to get message count and if count=1, get the message
1321: Fnd_Msg_Pub.Count_And_Get (
1322: p_encoded => Fnd_Api.G_FALSE,
1323: p_count => x_msg_count,
1324: p_data => x_msg_data
1329: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
1330: THEN
1331: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1332: END IF;
1333: -- Standard call to get message count and if count=1, get the message
1334: Fnd_Msg_Pub.Count_And_Get (
1335: p_encoded => Fnd_Api.G_FALSE,
1336: p_count => x_msg_count,
1337: p_data => x_msg_data
1368: IF Fnd_Api.to_Boolean( p_init_msg_list )
1369: THEN
1370: Fnd_Msg_Pub.initialize;
1371: END IF;
1372: -- Standard call to check for call compatibility.
1373: IF NOT Fnd_Api.Compatible_API_Call ( l_api_version_number,
1374: p_api_version_number,
1375: l_api_name,
1376: G_PKG_NAME)
1411: */
1412: WHEN Fnd_Api.G_EXC_ERROR THEN
1413: ROLLBACK TO Lock_Entity_Attr_PVT;
1414: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1415: -- Standard call to get message count and if count=1, get the message
1416: Fnd_Msg_Pub.Count_And_Get (
1417: p_encoded => Fnd_Api.G_FALSE,
1418: p_count => x_msg_count,
1419: p_data => x_msg_data
1420: );
1421: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1422: ROLLBACK TO Lock_Entity_Attr_PVT;
1423: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1424: -- Standard call to get message count and if count=1, get the message
1425: Fnd_Msg_Pub.Count_And_Get (
1426: p_encoded => Fnd_Api.G_FALSE,
1427: p_count => x_msg_count,
1428: p_data => x_msg_data
1434: THEN
1435: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1436: END IF;
1437:
1438: -- Standard call to get message count and if count=1, get the message
1439: Fnd_Msg_Pub.Count_And_Get (
1440: p_encoded => Fnd_Api.G_FALSE,
1441: p_count => x_msg_count,
1442: p_data => x_msg_data
1975: l_object_version_number NUMBER;
1976: l_entity_attr_rec Pv_Entity_Attribute_Pvt.entity_attr_rec_type;
1977:
1978: BEGIN
1979: -- Standard Start of API savepoint
1980: SAVEPOINT Validate_Entity_Attr_;
1981:
1982: -- Standard call to check for call compatibility.
1983: IF NOT Fnd_Api.Compatible_API_Call ( l_api_version_number,
1978: BEGIN
1979: -- Standard Start of API savepoint
1980: SAVEPOINT Validate_Entity_Attr_;
1981:
1982: -- Standard call to check for call compatibility.
1983: IF NOT Fnd_Api.Compatible_API_Call ( l_api_version_number,
1984: p_api_version_number,
1985: l_api_name,
1986: G_PKG_NAME)
2041: -- Debug Message
2042: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
2043: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'end');
2044: END IF;
2045: -- Standard call to get message count and if count is 1, get message info.
2046: Fnd_Msg_Pub.Count_And_Get
2047: (p_count => x_msg_count
2048: ,p_data => x_msg_data
2049: );
2055: */
2056: WHEN Fnd_Api.G_EXC_ERROR THEN
2057: ROLLBACK TO Validate_Entity_Attr_;
2058: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2059: -- Standard call to get message count and if count=1, get the message
2060: Fnd_Msg_Pub.Count_And_Get (
2061: p_encoded => Fnd_Api.G_FALSE,
2062: p_count => x_msg_count,
2063: p_data => x_msg_data
2064: );
2065: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2066: ROLLBACK TO Validate_Entity_Attr_;
2067: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2068: -- Standard call to get message count and if count=1, get the message
2069: Fnd_Msg_Pub.Count_And_Get (
2070: p_encoded => Fnd_Api.G_FALSE,
2071: p_count => x_msg_count,
2072: p_data => x_msg_data
2078: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
2079: THEN
2080: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2081: END IF;
2082: -- Standard call to get message count and if count=1, get the message
2083: Fnd_Msg_Pub.Count_And_Get (
2084: p_encoded => Fnd_Api.G_FALSE
2085: ,p_count => x_msg_count
2086: ,p_data => x_msg_data
2117: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
2118: Pvx_Utility_Pvt.debug_message('Private API: Validate_dm_model_rec');
2119: END IF;
2120:
2121: -- Standard call to get message count and if count is 1, get message info.
2122: Fnd_Msg_Pub.Count_And_Get (
2123: p_count => x_msg_count
2124: ,p_data => x_msg_data
2125: );