[Home] [Help]
111: entity= pc_entity
112: ;
113:
114: BEGIN
115: -- Standard Start of API savepoint
116: SAVEPOINT Upsert_Attr_Value_PUB;
117:
118: -- Standard call to check for call compatibility.
119: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
114: BEGIN
115: -- Standard Start of API savepoint
116: SAVEPOINT Upsert_Attr_Value_PUB;
117:
118: -- Standard call to check for call compatibility.
119: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
120: p_api_version_number,
121: l_api_name,
122: G_PKG_NAME)
332:
333: --initialise it to null
334: l_lead_enty_attr_val_rec := PV_Enty_Attr_Value_PVT.g_miss_enty_attr_val_rec;
335:
336: --initialising standard columns in the record
337: --initialising in parameters to record fields
338: l_lead_enty_attr_val_rec.entity := p_entity;
339: l_lead_enty_attr_val_rec.attribute_id := p_attribute_id;
340:
377:
378: --initialise it to null
379: l_lead_enty_attr_val_rec := PV_Enty_Attr_Value_PVT.g_miss_enty_attr_val_rec;
380:
381: --initialising standard columns in the record
382: --initialising in parameters to record fields
383: l_lead_enty_attr_val_rec.entity := p_entity;
384: l_lead_enty_attr_val_rec.attribute_id := p_attribute_id;
385:
913: THEN
914: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
915: END IF;
916: */
917: -- Standard call to get message count and if count=1, get the message
918: FND_MSG_PUB.Count_And_Get (
919: p_encoded => FND_API.G_FALSE
920: ,p_count => x_msg_count
921: ,p_data => x_msg_data
978: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' - Value Table Null or Zero length');
979: END IF;
980: l_enty_attr_val_rec := PV_Enty_Attr_Value_PVT.g_miss_enty_attr_val_rec;
981:
982: --initialising standard columns in the record
983: --l_enty_attr_val_rec.enty_attr_val_id := l_enty_attr_val_id;
984: /*l_enty_attr_val_rec.last_update_date := SYSDATE;
985: l_enty_attr_val_rec.last_updated_by := G_USER_ID;
986: l_enty_attr_val_rec.creation_date := SYSDATE;
1080: END IF;
1081: --initialise it to null
1082: l_enty_attr_val_rec := PV_Enty_Attr_Value_PVT.g_miss_enty_attr_val_rec;
1083:
1084: --initialising standard columns in the record
1085: --l_enty_attr_val_rec.enty_attr_val_id := l_enty_attr_val_id;
1086: l_enty_attr_val_rec.last_update_date := SYSDATE;
1087: l_enty_attr_val_rec.last_updated_by := G_USER_ID;
1088: l_enty_attr_val_rec.creation_date := SYSDATE;
1138: --
1139: -- End of API body
1140: --
1141:
1142: -- Standard check for p_commit
1143: IF FND_API.to_Boolean( p_commit )
1144: THEN
1145: COMMIT WORK;
1146: END IF;
1150: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1151: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' - end');
1152: END IF;
1153:
1154: -- Standard call to get message count and if count is 1, get message info.
1155: FND_MSG_PUB.Count_And_Get (
1156: p_count => x_msg_count
1157: ,p_data => x_msg_data
1158: );
1165: */
1166: WHEN FND_API.G_EXC_ERROR THEN
1167: ROLLBACK TO Upsert_Attr_Value_PUB;
1168: x_return_status := FND_API.G_RET_STS_ERROR;
1169: -- Standard call to get message count and if count=1, get the message
1170: FND_MSG_PUB.Count_And_Get (
1171: p_encoded => FND_API.G_FALSE
1172: ,p_count => x_msg_count
1173: ,p_data => x_msg_data
1175:
1176: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1177: ROLLBACK TO Upsert_Attr_Value_PUB;
1178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1179: -- Standard call to get message count and if count=1, get the message
1180: FND_MSG_PUB.Count_And_Get (
1181: p_encoded => FND_API.G_FALSE
1182: ,p_count => x_msg_count
1183: ,p_data => x_msg_data
1189: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1190: THEN
1191: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1192: END IF;
1193: -- Standard call to get message count and if count=1, get the message
1194: FND_MSG_PUB.Count_And_Get (
1195: p_encoded => FND_API.G_FALSE
1196: ,p_count => x_msg_count
1197: ,p_data => x_msg_data
1404: entity = cv_entity and
1405: latest_flag = 'Y';
1406:
1407: BEGIN
1408: -- Standard Start of API savepoint
1409: SAVEPOINT Copy_Partner_Attr_Values_PUB;
1410:
1411: -- Standard call to check for call compatibility.
1412: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1407: BEGIN
1408: -- Standard Start of API savepoint
1409: SAVEPOINT Copy_Partner_Attr_Values_PUB;
1410:
1411: -- Standard call to check for call compatibility.
1412: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1413: p_api_version_number,
1414: l_api_name,
1415: G_PKG_NAME)
1645: --
1646: -- End of API body
1647: --
1648:
1649: -- Standard check for p_commit
1650: IF FND_API.to_Boolean( p_commit )
1651: THEN
1652: COMMIT WORK;
1653: END IF;
1657: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1658: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' - end');
1659: END IF;
1660:
1661: -- Standard call to get message count and if count is 1, get message info.
1662: FND_MSG_PUB.Count_And_Get (
1663: p_count => x_msg_count
1664: ,p_data => x_msg_data
1665: );
1668:
1669: WHEN FND_API.G_EXC_ERROR THEN
1670: ROLLBACK TO Copy_Partner_Attr_Values_PUB;
1671: x_return_status := FND_API.G_RET_STS_ERROR;
1672: -- Standard call to get message count and if count=1, get the message
1673: FND_MSG_PUB.Count_And_Get (
1674: p_encoded => FND_API.G_FALSE
1675: ,p_count => x_msg_count
1676: ,p_data => x_msg_data
1678:
1679: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1680: ROLLBACK TO Copy_Partner_Attr_Values_PUB;
1681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1682: -- Standard call to get message count and if count=1, get the message
1683: FND_MSG_PUB.Count_And_Get (
1684: p_encoded => FND_API.G_FALSE
1685: ,p_count => x_msg_count
1686: ,p_data => x_msg_data
1692: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1693: THEN
1694: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1695: END IF;
1696: -- Standard call to get message count and if count=1, get the message
1697: FND_MSG_PUB.Count_And_Get (
1698: p_encoded => FND_API.G_FALSE
1699: ,p_count => x_msg_count
1700: ,p_data => x_msg_data
1738: l_index number := 1;
1739:
1740: BEGIN
1741:
1742: -- Standard Start of API savepoint
1743: SAVEPOINT Upsert_Partner_Types_pub;
1744:
1745: -- Standard call to check for call compatibility.
1746: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1741:
1742: -- Standard Start of API savepoint
1743: SAVEPOINT Upsert_Partner_Types_pub;
1744:
1745: -- Standard call to check for call compatibility.
1746: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1747: p_api_version_number,
1748: l_api_name,
1749: G_PKG_NAME)
2002: END IF;
2003:
2004:
2005: -- End of API body
2006: -- Standard check for p_commit
2007:
2008: IF FND_API.to_Boolean( p_commit )
2009: THEN
2010: COMMIT WORK;
2014: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
2015: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' - end');
2016: END IF;
2017:
2018: -- Standard call to get message count and if count is 1, get message info.
2019: FND_MSG_PUB.Count_And_Get (
2020: p_count => x_msg_count
2021: ,p_data => x_msg_data
2022: );
2025:
2026: WHEN FND_API.G_EXC_ERROR THEN
2027: ROLLBACK TO Upsert_Partner_Types_pub;
2028: x_return_status := FND_API.G_RET_STS_ERROR;
2029: -- Standard call to get message count and if count=1, get the message
2030: FND_MSG_PUB.Count_And_Get (
2031: p_encoded => FND_API.G_FALSE
2032: ,p_count => x_msg_count
2033: ,p_data => x_msg_data
2035:
2036: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2037: ROLLBACK TO Upsert_Partner_Types_pub;
2038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2039: -- Standard call to get message count and if count=1, get the message
2040: FND_MSG_PUB.Count_And_Get (
2041: p_encoded => FND_API.G_FALSE
2042: ,p_count => x_msg_count
2043: ,p_data => x_msg_data
2049: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2050: THEN
2051: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2052: END IF;
2053: -- Standard call to get message count and if count=1, get the message
2054: FND_MSG_PUB.Count_And_Get (
2055: p_encoded => FND_API.G_FALSE
2056: ,p_count => x_msg_count
2057: ,p_data => x_msg_data