[Home] [Help]
137: -- x_return_status OUT VARCHAR2
138: -- x_msg_count OUT NUMBER
139: -- x_msg_data OUT VARCHAR2
140: -- Version : Current version 1.0
141: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
142: -- and basic operation, developer must manually add parameters and business logic as necessary.
143: --
144: -- History
145: --
178: SELECT 1
179: FROM OZF_OFFER_ADJUSTMENTS_B
180: WHERE offer_adjustment_id = l_id;
181: BEGIN
182: -- Standard Start of API savepoint
183: SAVEPOINT create_offer_adjustment_pvt;
184:
185: -- Standard call to check for call compatibility.
186: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
181: BEGIN
182: -- Standard Start of API savepoint
183: SAVEPOINT create_offer_adjustment_pvt;
184:
185: -- Standard call to check for call compatibility.
186: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
187: p_api_version_number,
188: l_api_name,
189: G_PKG_NAME)
307: --
308: -- End of API body
309: --
310:
311: -- Standard check for p_commit
312: IF FND_API.to_Boolean( p_commit )
313: THEN
314: -- OZF_Offer_Adj_Line_PVT.debug_message('Problemo hereo: ');
315: -- RAISE FND_API.G_EXC_ERROR;
320: -- Debug Message
321: OZF_Offer_Adj_Line_PVT.debug_message('Private API: ' || l_api_name || 'end');
322:
323:
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_Offer_Adjustment_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
344:
345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
346: ROLLBACK TO CREATE_Offer_Adjustment_PVT;
347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
348: -- Standard call to get message count and if count=1, get the message
349: FND_MSG_PUB.Count_And_Get (
350: p_encoded => FND_API.G_FALSE,
351: p_count => x_msg_count,
352: p_data => x_msg_data
358: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
359: THEN
360: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
361: END IF;
362: -- Standard call to get message count and if count=1, get the message
363: FND_MSG_PUB.Count_And_Get (
364: p_encoded => FND_API.G_FALSE,
365: p_count => x_msg_count,
366: p_data => x_msg_data
390: -- x_return_status OUT VARCHAR2
391: -- x_msg_count OUT NUMBER
392: -- x_msg_data OUT VARCHAR2
393: -- Version : Current version 1.0
394: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
395: -- and basic operation, developer must manually add parameters and business logic as necessary.
396: --
397: -- History
398: --
494: l_budgetAdjFlag VARCHAR2(1);
495: -- end mthumu
496:
497: BEGIN
498: -- Standard Start of API savepoint
499: SAVEPOINT update_offer_adjustment_pvt;
500:
501: -- Standard call to check for call compatibility.
502: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
497: BEGIN
498: -- Standard Start of API savepoint
499: SAVEPOINT update_offer_adjustment_pvt;
500:
501: -- Standard call to check for call compatibility.
502: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
503: p_api_version_number,
504: l_api_name,
505: G_PKG_NAME)
749: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
750: WHEN FND_API.G_EXC_ERROR THEN
751: ROLLBACK TO UPDATE_Offer_Adjustment_PVT;
752: x_return_status := FND_API.G_RET_STS_ERROR;
753: -- Standard call to get message count and if count=1, get the message
754: FND_MSG_PUB.Count_And_Get (
755: p_encoded => FND_API.G_FALSE,
756: p_count => x_msg_count,
757: p_data => x_msg_data
758: );
759: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
760: ROLLBACK TO UPDATE_Offer_Adjustment_PVT;
761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
762: -- Standard call to get message count and if count=1, get the message
763: FND_MSG_PUB.Count_And_Get (
764: p_encoded => FND_API.G_FALSE,
765: p_count => x_msg_count,
766: p_data => x_msg_data
772: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
773: THEN
774: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
775: END IF;
776: -- Standard call to get message count and if count=1, get the message
777: FND_MSG_PUB.Count_And_Get (
778: p_encoded => FND_API.G_FALSE,
779: p_count => x_msg_count,
780: p_data => x_msg_data
805: -- x_return_status OUT VARCHAR2
806: -- x_msg_count OUT NUMBER
807: -- x_msg_data OUT VARCHAR2
808: -- Version : Current version 1.0
809: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
810: -- and basic operation, developer must manually add parameters and business logic as necessary.
811: --
812: -- History
813: --
833: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
834: l_object_version_number NUMBER;
835:
836: BEGIN
837: -- Standard Start of API savepoint
838: SAVEPOINT delete_offer_adjustment_pvt;
839:
840: -- Standard call to check for call compatibility.
841: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
836: BEGIN
837: -- Standard Start of API savepoint
838: SAVEPOINT delete_offer_adjustment_pvt;
839:
840: -- Standard call to check for call compatibility.
841: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
842: p_api_version_number,
843: l_api_name,
844: G_PKG_NAME)
876: --
877: -- End of API body
878: --
879:
880: -- Standard check for p_commit
881: IF FND_API.to_Boolean( p_commit )
882: THEN
883: COMMIT WORK;
884: END IF;
887: -- Debug Message
888: OZF_Offer_Adj_Line_PVT.debug_message('Private API: ' || l_api_name || 'end');
889:
890:
891: -- Standard call to get message count and if count is 1, get message info.
892: FND_MSG_PUB.Count_And_Get
893: (p_count => x_msg_count,
894: p_data => x_msg_data
895: );
901:
902: WHEN FND_API.G_EXC_ERROR THEN
903: ROLLBACK TO DELETE_Offer_Adjustment_PVT;
904: x_return_status := FND_API.G_RET_STS_ERROR;
905: -- Standard call to get message count and if count=1, get the message
906: FND_MSG_PUB.Count_And_Get (
907: p_encoded => FND_API.G_FALSE,
908: p_count => x_msg_count,
909: p_data => x_msg_data
911:
912: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
913: ROLLBACK TO DELETE_Offer_Adjustment_PVT;
914: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
915: -- Standard call to get message count and if count=1, get the message
916: FND_MSG_PUB.Count_And_Get (
917: p_encoded => FND_API.G_FALSE,
918: p_count => x_msg_count,
919: p_data => x_msg_data
925: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
926: THEN
927: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
928: END IF;
929: -- Standard call to get message count and if count=1, get the message
930: FND_MSG_PUB.Count_And_Get (
931: p_encoded => FND_API.G_FALSE,
932: p_count => x_msg_count,
933: p_data => x_msg_data
959: -- x_return_status OUT VARCHAR2
960: -- x_msg_count OUT NUMBER
961: -- x_msg_data OUT VARCHAR2
962: -- Version : Current version 1.0
963: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
964: -- and basic operation, developer must manually add parameters and business logic as necessary.
965: --
966: -- History
967: --
1001: END IF;
1002:
1003:
1004:
1005: -- Standard call to check for call compatibility.
1006: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1007: p_api_version_number,
1008: l_api_name,
1009: G_PKG_NAME)
1035:
1036: WHEN FND_API.G_EXC_ERROR THEN
1037: ROLLBACK TO LOCK_Offer_Adjustment_PVT;
1038: x_return_status := FND_API.G_RET_STS_ERROR;
1039: -- Standard call to get message count and if count=1, get the message
1040: FND_MSG_PUB.Count_And_Get (
1041: p_encoded => FND_API.G_FALSE,
1042: p_count => x_msg_count,
1043: p_data => x_msg_data
1045:
1046: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1047: ROLLBACK TO LOCK_Offer_Adjustment_PVT;
1048: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1049: -- Standard call to get message count and if count=1, get the message
1050: FND_MSG_PUB.Count_And_Get (
1051: p_encoded => FND_API.G_FALSE,
1052: p_count => x_msg_count,
1053: p_data => x_msg_data
1059: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1060: THEN
1061: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1062: END IF;
1063: -- Standard call to get message count and if count=1, get the message
1064: FND_MSG_PUB.Count_And_Get (
1065: p_encoded => FND_API.G_FALSE,
1066: p_count => x_msg_count,
1067: p_data => x_msg_data
1533: l_object_version_number NUMBER;
1534: l_offer_adj_rec offer_adj_rec_type;
1535:
1536: BEGIN
1537: -- Standard Start of API savepoint
1538: SAVEPOINT validate_offer_adjustment_;
1539:
1540: -- Standard call to check for call compatibility.
1541: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1536: BEGIN
1537: -- Standard Start of API savepoint
1538: SAVEPOINT validate_offer_adjustment_;
1539:
1540: -- Standard call to check for call compatibility.
1541: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1542: p_api_version_number,
1543: l_api_name,
1544: G_PKG_NAME)
1614: -- Debug Message
1615: OZF_Offer_Adj_Line_PVT.debug_message('Private API: ' || l_api_name || 'end');
1616:
1617:
1618: -- Standard call to get message count and if count is 1, get message info.
1619: FND_MSG_PUB.Count_And_Get
1620: (p_count => x_msg_count,
1621: p_data => x_msg_data
1622: );
1628:
1629: WHEN FND_API.G_EXC_ERROR THEN
1630: ROLLBACK TO VALIDATE_Offer_Adjustment_;
1631: x_return_status := FND_API.G_RET_STS_ERROR;
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
1638:
1639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1640: ROLLBACK TO VALIDATE_Offer_Adjustment_;
1641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1642: -- Standard call to get message count and if count=1, get the message
1643: FND_MSG_PUB.Count_And_Get (
1644: p_encoded => FND_API.G_FALSE,
1645: p_count => x_msg_count,
1646: p_data => x_msg_data
1652: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1653: THEN
1654: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1655: END IF;
1656: -- Standard call to get message count and if count=1, get the message
1657: FND_MSG_PUB.Count_And_Get (
1658: p_encoded => FND_API.G_FALSE,
1659: p_count => x_msg_count,
1660: p_data => x_msg_data
1689: -- x_return_status := FND_API.G_RET_STS_ERROR;
1690:
1691: -- Debug Message
1692: OZF_Offer_Adj_Line_PVT.debug_message('Private API: Validate_dm_model_rec');
1693: -- Standard call to get message count and if count is 1, get message info.
1694: FND_MSG_PUB.Count_And_Get
1695: (p_count => x_msg_count,
1696: p_data => x_msg_data
1697: );