[Home] [Help]
56: FROM PV_ATTRIBUTES_B
57: WHERE ATTRIBUTE_ID = l_id;
58:
59: BEGIN
60: -- Standard Start of API savepoint
61: SAVEPOINT CREATE_Attribute_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_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)
233: --
234: -- End of API body
235: --
236:
237: -- Standard check for p_commit
238: IF FND_API.to_Boolean( p_commit )
239: THEN
240: COMMIT WORK;
241: END IF;
245: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
246: PVX_UTILITY_PVT.debug_message('Private API: ' || L_FULL_NAME || 'end');
247: END IF;
248:
249: -- Standard call to get message count and if count is 1, get message info.
250: FND_MSG_PUB.Count_And_Get
251: (p_count => x_msg_count,
252: p_data => x_msg_data
253: );
261:
262: WHEN FND_API.G_EXC_ERROR THEN
263: ROLLBACK TO CREATE_Attribute_PVT;
264: x_return_status := FND_API.G_RET_STS_ERROR;
265: -- Standard call to get message count and if count=1, get the message
266: FND_MSG_PUB.Count_And_Get (
267: p_encoded => FND_API.G_FALSE,
268: p_count => x_msg_count,
269: p_data => x_msg_data
271:
272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
273: ROLLBACK TO CREATE_Attribute_PVT;
274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
275: -- Standard call to get message count and if count=1, get the message
276: FND_MSG_PUB.Count_And_Get (
277: p_encoded => FND_API.G_FALSE,
278: p_count => x_msg_count,
279: p_data => x_msg_data
285: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
286: THEN
287: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
288: END IF;
289: -- Standard call to get message count and if count=1, get the message
290: FND_MSG_PUB.Count_And_Get (
291: p_encoded => FND_API.G_FALSE,
292: p_count => x_msg_count,
293: p_data => x_msg_data
347: val.entity_type = 'MANUAL_MATCHING' and
348: resp.RESPONSIBILITY_ID = val.responsibility_id;
349:
350: BEGIN
351: -- Standard Start of API savepoint
352: SAVEPOINT UPDATE_Attribute_PVT;
353:
354: -- Standard call to check for call compatibility.
355: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
350: BEGIN
351: -- Standard Start of API savepoint
352: SAVEPOINT UPDATE_Attribute_PVT;
353:
354: -- Standard call to check for call compatibility.
355: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
356: p_api_version_number,
357: l_api_name,
358: G_PKG_NAME)
737: --
738: -- End of API body.
739: --
740:
741: -- Standard check for p_commit
742: IF FND_API.to_Boolean( p_commit )
743: THEN
744: COMMIT WORK;
745: END IF;
749: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
750: PVX_UTILITY_PVT.debug_message('Private API: ' || L_FULL_NAME || 'end');
751: END IF;
752:
753: -- Standard call to get message count and if count is 1, get message info.
754: FND_MSG_PUB.Count_And_Get
755: (p_count => x_msg_count,
756: p_data => x_msg_data
757: );
765:
766: WHEN FND_API.G_EXC_ERROR THEN
767: ROLLBACK TO UPDATE_Attribute_PVT;
768: x_return_status := FND_API.G_RET_STS_ERROR;
769: -- Standard call to get message count and if count=1, get the message
770: FND_MSG_PUB.Count_And_Get (
771: p_encoded => FND_API.G_FALSE,
772: p_count => x_msg_count,
773: p_data => x_msg_data
775:
776: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
777: ROLLBACK TO UPDATE_Attribute_PVT;
778: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
779: -- Standard call to get message count and if count=1, get the message
780: FND_MSG_PUB.Count_And_Get (
781: p_encoded => FND_API.G_FALSE,
782: p_count => x_msg_count,
783: p_data => x_msg_data
789: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
790: THEN
791: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
792: END IF;
793: -- Standard call to get message count and if count=1, get the message
794: FND_MSG_PUB.Count_And_Get (
795: p_encoded => FND_API.G_FALSE,
796: p_count => x_msg_count,
797: p_data => x_msg_data
883:
884: BEGIN
885: --DBMS_output.put_line('Begin Delete_attribute');
886:
887: -- Standard Start of API savepoint
888: SAVEPOINT DELETE_Attribute_PVT;
889:
890: -- Standard call to check for call compatibility.
891: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
886:
887: -- Standard Start of API savepoint
888: SAVEPOINT DELETE_Attribute_PVT;
889:
890: -- Standard call to check for call compatibility.
891: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
892: p_api_version_number,
893: l_api_name,
894: G_PKG_NAME)
1150: -- End of API body
1151: --
1152:
1153:
1154: -- Standard check for p_commit
1155: IF FND_API.to_Boolean( p_commit )
1156: THEN
1157: COMMIT WORK;
1158: END IF;
1162: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) 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: );
1178:
1179: WHEN FND_API.G_EXC_ERROR THEN
1180: ROLLBACK TO DELETE_Attribute_PVT;
1181: x_return_status := FND_API.G_RET_STS_ERROR;
1182: -- Standard call to get message count and if count=1, get the message
1183: FND_MSG_PUB.Count_And_Get (
1184: p_encoded => FND_API.G_FALSE,
1185: p_count => x_msg_count,
1186: p_data => x_msg_data
1188:
1189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1190: ROLLBACK TO DELETE_Attribute_PVT;
1191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1192: -- Standard call to get message count and if count=1, get the message
1193: FND_MSG_PUB.Count_And_Get (
1194: p_encoded => FND_API.G_FALSE,
1195: p_count => x_msg_count,
1196: p_data => x_msg_data
1202: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1203: THEN
1204: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1205: END IF;
1206: -- Standard call to get message count and if count=1, get the message
1207: FND_MSG_PUB.Count_And_Get (
1208: p_encoded => FND_API.G_FALSE,
1209: p_count => x_msg_count,
1210: p_data => x_msg_data
1252: THEN
1253: FND_MSG_PUB.initialize;
1254: END IF;
1255:
1256: -- Standard call to check for call compatibility.
1257: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1258: p_api_version_number,
1259: l_api_name,
1260: G_PKG_NAME)
1299:
1300: WHEN FND_API.G_EXC_ERROR THEN
1301: ROLLBACK TO LOCK_Attribute_PVT;
1302: x_return_status := FND_API.G_RET_STS_ERROR;
1303: -- Standard call to get message count and if count=1, get the message
1304: FND_MSG_PUB.Count_And_Get (
1305: p_encoded => FND_API.G_FALSE,
1306: p_count => x_msg_count,
1307: p_data => x_msg_data
1309:
1310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1311: ROLLBACK TO LOCK_Attribute_PVT;
1312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1313: -- Standard call to get message count and if count=1, get the message
1314: FND_MSG_PUB.Count_And_Get (
1315: p_encoded => FND_API.G_FALSE,
1316: p_count => x_msg_count,
1317: p_data => x_msg_data
1323: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1324: THEN
1325: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1326: END IF;
1327: -- Standard call to get message count and if count=1, get the message
1328: FND_MSG_PUB.Count_And_Get (
1329: p_encoded => FND_API.G_FALSE,
1330: p_count => x_msg_count,
1331: p_data => x_msg_data
1903: l_object_version_number NUMBER;
1904: l_attribute_rec PV_Attribute_PVT.attribute_rec_type;
1905:
1906: BEGIN
1907: -- Standard Start of API savepoint
1908: SAVEPOINT VALIDATE_ATTRIBUTE_PVT;
1909: --DBMS_output.put_line('Begin Validate_attribute');
1910:
1911:
1908: SAVEPOINT VALIDATE_ATTRIBUTE_PVT;
1909: --DBMS_output.put_line('Begin Validate_attribute');
1910:
1911:
1912: -- Standard call to check for call compatibility.
1913: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1914: p_api_version_number,
1915: l_api_name,
1916: G_PKG_NAME)
1981: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1982: PVX_UTILITY_PVT.debug_message('Private API: ' || L_FULL_NAME || 'end');
1983: END IF;
1984:
1985: -- Standard call to get message count and if count is 1, get message info.
1986: FND_MSG_PUB.Count_And_Get
1987: (p_count => x_msg_count,
1988: p_data => x_msg_data
1989: );
1996:
1997: WHEN FND_API.G_EXC_ERROR THEN
1998: ROLLBACK TO VALIDATE_Attribute_PVT;
1999: x_return_status := FND_API.G_RET_STS_ERROR;
2000: -- Standard call to get message count and if count=1, get the message
2001: FND_MSG_PUB.Count_And_Get (
2002: p_encoded => FND_API.G_FALSE,
2003: p_count => x_msg_count,
2004: p_data => x_msg_data
2006:
2007: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2008: ROLLBACK TO VALIDATE_Attribute_PVT;
2009: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2010: -- Standard call to get message count and if count=1, get the message
2011: FND_MSG_PUB.Count_And_Get (
2012: p_encoded => FND_API.G_FALSE,
2013: p_count => x_msg_count,
2014: p_data => x_msg_data
2020: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2021: THEN
2022: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2023: END IF;
2024: -- Standard call to get message count and if count=1, get the message
2025: FND_MSG_PUB.Count_And_Get (
2026: p_encoded => FND_API.G_FALSE,
2027: p_count => x_msg_count,
2028: p_data => x_msg_data
2062: -- Debug Message
2063: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
2064: PVX_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
2065: END IF;
2066: -- Standard call to get message count and if count is 1, get message info.
2067: FND_MSG_PUB.Count_And_Get
2068: (p_count => x_msg_count,
2069: p_data => x_msg_data
2070: );