[Home] [Help]
126: l_return_status VARCHAR(1);
127:
128:
129: BEGIN
130: -- Standard Start of API savepoint
131: SAVEPOINT CREATE_ITEM_OWNER_PVT;
132:
133: -- Standard call to check for call compatibility.
134: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
129: BEGIN
130: -- Standard Start of API savepoint
131: SAVEPOINT CREATE_ITEM_OWNER_PVT;
132:
133: -- Standard call to check for call compatibility.
134: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
135: p_api_version_number,
136: l_api_name,
137: G_PKG_NAME)
423: --
424: -- End of API body
425: --
426:
427: -- Standard check for p_commit
428: IF FND_API.to_Boolean( p_commit )
429: THEN
430: COMMIT WORK;
431: END IF;
433:
434: -- Debug Message
435: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end'); END IF;
436:
437: -- Standard call to get message count and if count is 1, get message info.
438: FND_MSG_PUB.Count_And_Get
439: (p_count => x_msg_count,
440: p_data => x_msg_data
441: );
442: EXCEPTION
443: WHEN FND_API.G_EXC_ERROR THEN
444: -- ROLLBACK TO CREATE_ITEM_OWNER_PVT;
445: x_return_status := FND_API.G_RET_STS_ERROR;
446: -- Standard call to get message count and if count=1, get the message
447: FND_MSG_PUB.Count_And_Get (
448: p_encoded => FND_API.G_FALSE,
449: p_count => x_msg_count,
450: p_data => x_msg_data
451: );
452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
453: -- ROLLBACK TO CREATE_ITEM_OWNER_PVT;
454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
455: -- Standard call to get message count and if count=1, get the message
456: FND_MSG_PUB.Count_And_Get (
457: p_encoded => FND_API.G_FALSE,
458: p_count => x_msg_count,
459: p_data => x_msg_data
464: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
465: THEN
466: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
467: END IF;
468: -- Standard call to get message count and if count=1, get the message
469: FND_MSG_PUB.Count_And_Get (
470: p_encoded => FND_API.G_FALSE,
471: p_count => x_msg_count,
472: p_data => x_msg_data
541:
542: l_status_controlled_item VARCHAR2(1) := 'N';
543:
544: BEGIN
545: -- Standard Start of API savepoint
546: SAVEPOINT UPDATE_ITEM_OWNER_PVT;
547:
548: -- Standard call to check for call compatibility.
549: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
544: BEGIN
545: -- Standard Start of API savepoint
546: SAVEPOINT UPDATE_ITEM_OWNER_PVT;
547:
548: -- Standard call to check for call compatibility.
549: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
550: p_api_version_number,
551: l_api_name,
552: G_PKG_NAME)
924: --
925: -- End of API body.
926: --
927:
928: -- Standard check for p_commit
929: IF FND_API.to_Boolean( p_commit )
930: THEN
931: COMMIT WORK;
932: END IF;
934:
935: -- Debug Message
936: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end'); END IF;
937:
938: -- Standard call to get message count and if count is 1, get message info.
939: FND_MSG_PUB.Count_And_Get
940: (p_count => x_msg_count,
941: p_data => x_msg_data
942: );
943: EXCEPTION
944: WHEN FND_API.G_EXC_ERROR THEN
945: -- ROLLBACK TO UPDATE_ITEM_OWNER_PVT;
946: x_return_status := FND_API.G_RET_STS_ERROR;
947: -- Standard call to get message count and if count=1, get the message
948: FND_MSG_PUB.Count_And_Get (
949: p_encoded => FND_API.G_FALSE,
950: p_count => x_msg_count,
951: p_data => x_msg_data
952: );
953: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
954: -- ROLLBACK TO UPDATE_ITEM_OWNER_PVT;
955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
956: -- Standard call to get message count and if count=1, get the message
957: FND_MSG_PUB.Count_And_Get (
958: p_encoded => FND_API.G_FALSE,
959: p_count => x_msg_count,
960: p_data => x_msg_data
965: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
966: THEN
967: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
968: END IF;
969: -- Standard call to get message count and if count=1, get the message
970: FND_MSG_PUB.Count_And_Get (
971: p_encoded => FND_API.G_FALSE,
972: p_count => x_msg_count,
973: p_data => x_msg_data
992: l_api_version_number CONSTANT NUMBER := 1.0;
993: l_object_version_number NUMBER;
994:
995: BEGIN
996: -- Standard Start of API savepoint
997: SAVEPOINT DELETE_ITEM_OWNER_PVT;
998:
999: -- Standard call to check for call compatibility.
1000: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
995: BEGIN
996: -- Standard Start of API savepoint
997: SAVEPOINT DELETE_ITEM_OWNER_PVT;
998:
999: -- Standard call to check for call compatibility.
1000: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1001: p_api_version_number,
1002: l_api_name,
1003: G_PKG_NAME)
1036: --
1037: -- End of API body
1038: --
1039:
1040: -- Standard check for p_commit
1041: IF FND_API.to_Boolean( p_commit )
1042: THEN
1043: COMMIT WORK;
1044: END IF;
1049:
1050: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1051: END IF;
1052:
1053: -- Standard call to get message count and if count is 1, get message info.
1054: FND_MSG_PUB.Count_And_Get
1055: (p_count => x_msg_count,
1056: p_data => x_msg_data
1057: );
1058: EXCEPTION
1059: WHEN FND_API.G_EXC_ERROR THEN
1060: ROLLBACK TO DELETE_ITEM_OWNER_PVT;
1061: x_return_status := FND_API.G_RET_STS_ERROR;
1062: -- Standard call to get message count and if count=1, get the message
1063: FND_MSG_PUB.Count_And_Get (
1064: p_encoded => FND_API.G_FALSE,
1065: p_count => x_msg_count,
1066: p_data => x_msg_data
1067: );
1068: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1069: ROLLBACK TO DELETE_ITEM_OWNER_PVT;
1070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1071: -- Standard call to get message count and if count=1, get the message
1072: FND_MSG_PUB.Count_And_Get (
1073: p_encoded => FND_API.G_FALSE,
1074: p_count => x_msg_count,
1075: p_data => x_msg_data
1080: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1081: THEN
1082: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1083: END IF;
1084: -- Standard call to get message count and if count=1, get the message
1085: FND_MSG_PUB.Count_And_Get (
1086: p_encoded => FND_API.G_FALSE,
1087: p_count => x_msg_count,
1088: p_data => x_msg_data
1165: l_object_version_number NUMBER;
1166: l_ITEM_OWNER_rec AMS_item_owner_PVT.ITEM_OWNER_Rec_Type;
1167:
1168: BEGIN
1169: -- Standard Start of API savepoint
1170: SAVEPOINT VALIDATE_ITEM_OWNER_;
1171:
1172: -- Standard call to check for call compatibility.
1173: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1168: BEGIN
1169: -- Standard Start of API savepoint
1170: SAVEPOINT VALIDATE_ITEM_OWNER_;
1171:
1172: -- Standard call to check for call compatibility.
1173: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1174: p_api_version_number,
1175: l_api_name,
1176: G_PKG_NAME)
1314: raise FND_API.G_EXC_ERROR;
1315: END IF;
1316: */
1317:
1318: -- Standard call to get message count and if count is 1, get message info.
1319: FND_MSG_PUB.Count_And_Get
1320: (p_count => x_msg_count,
1321: p_data => x_msg_data
1322: );
1323: EXCEPTION
1324: WHEN FND_API.G_EXC_ERROR THEN
1325: ROLLBACK TO VALIDATE_ITEM_OWNER_;
1326: x_return_status := FND_API.G_RET_STS_ERROR;
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
1332: );
1333: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1334: ROLLBACK TO VALIDATE_ITEM_OWNER_;
1335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1336: -- Standard call to get message count and if count=1, get the message
1337: FND_MSG_PUB.Count_And_Get (
1338: p_encoded => FND_API.G_FALSE,
1339: p_count => x_msg_count,
1340: p_data => x_msg_data
1345: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1346: THEN
1347: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1348: END IF;
1349: -- Standard call to get message count and if count=1, get the message
1350: FND_MSG_PUB.Count_And_Get (
1351: p_encoded => FND_API.G_FALSE,
1352: p_count => x_msg_count,
1353: p_data => x_msg_data