[Home] [Help]
136: -- x_return_status OUT VARCHAR2
137: -- x_msg_count OUT NUMBER
138: -- x_msg_data OUT VARCHAR2
139: -- Version : Current version 1.0
140: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
141: -- and basic operation, developer must manually add parameters and business logic as necessary.
142: --
143: -- History
144: --
177: SELECT 1
178: FROM OZF_OFFER_ADJUSTMENTS_B
179: WHERE offer_adjustment_id = l_id;
180: BEGIN
181: -- Standard Start of API savepoint
182: SAVEPOINT create_offer_adjustment_pvt;
183:
184: -- Standard call to check for call compatibility.
185: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
180: BEGIN
181: -- Standard Start of API savepoint
182: SAVEPOINT create_offer_adjustment_pvt;
183:
184: -- Standard call to check for call compatibility.
185: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
186: p_api_version_number,
187: l_api_name,
188: G_PKG_NAME)
306: --
307: -- End of API body
308: --
309:
310: -- Standard check for p_commit
311: IF FND_API.to_Boolean( p_commit )
312: THEN
313: -- OZF_Offer_Adj_Line_PVT.debug_message('Problemo hereo: ');
314: -- RAISE FND_API.G_EXC_ERROR;
319: -- Debug Message
320: OZF_Offer_Adj_Line_PVT.debug_message('Private API: ' || l_api_name || 'end');
321:
322:
323: -- Standard call to get message count and if count is 1, get message info.
324: FND_MSG_PUB.Count_And_Get
325: (p_count => x_msg_count,
326: p_data => x_msg_data
327: );
333:
334: WHEN FND_API.G_EXC_ERROR THEN
335: ROLLBACK TO CREATE_Offer_Adjustment_PVT;
336: x_return_status := FND_API.G_RET_STS_ERROR;
337: -- Standard call to get message count and if count=1, get the message
338: FND_MSG_PUB.Count_And_Get (
339: p_encoded => FND_API.G_FALSE,
340: p_count => x_msg_count,
341: p_data => x_msg_data
343:
344: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
345: ROLLBACK TO CREATE_Offer_Adjustment_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
357: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
358: THEN
359: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
360: END IF;
361: -- Standard call to get message count and if count=1, get the message
362: FND_MSG_PUB.Count_And_Get (
363: p_encoded => FND_API.G_FALSE,
364: p_count => x_msg_count,
365: p_data => x_msg_data
389: -- x_return_status OUT VARCHAR2
390: -- x_msg_count OUT NUMBER
391: -- x_msg_data OUT VARCHAR2
392: -- Version : Current version 1.0
393: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
394: -- and basic operation, developer must manually add parameters and business logic as necessary.
395: --
396: -- History
397: --
493: l_budgetAdjFlag VARCHAR2(1);
494: -- end mthumu
495:
496: BEGIN
497: -- Standard Start of API savepoint
498: SAVEPOINT update_offer_adjustment_pvt;
499:
500: -- Standard call to check for call compatibility.
501: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
496: BEGIN
497: -- Standard Start of API savepoint
498: SAVEPOINT update_offer_adjustment_pvt;
499:
500: -- Standard call to check for call compatibility.
501: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
502: p_api_version_number,
503: l_api_name,
504: G_PKG_NAME)
748: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
749: WHEN FND_API.G_EXC_ERROR THEN
750: ROLLBACK TO UPDATE_Offer_Adjustment_PVT;
751: x_return_status := FND_API.G_RET_STS_ERROR;
752: -- Standard call to get message count and if count=1, get the message
753: FND_MSG_PUB.Count_And_Get (
754: p_encoded => FND_API.G_FALSE,
755: p_count => x_msg_count,
756: p_data => x_msg_data
757: );
758: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
759: ROLLBACK TO UPDATE_Offer_Adjustment_PVT;
760: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
761: -- Standard call to get message count and if count=1, get the message
762: FND_MSG_PUB.Count_And_Get (
763: p_encoded => FND_API.G_FALSE,
764: p_count => x_msg_count,
765: p_data => x_msg_data
771: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
772: THEN
773: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
774: END IF;
775: -- Standard call to get message count and if count=1, get the message
776: FND_MSG_PUB.Count_And_Get (
777: p_encoded => FND_API.G_FALSE,
778: p_count => x_msg_count,
779: p_data => x_msg_data
804: -- x_return_status OUT VARCHAR2
805: -- x_msg_count OUT NUMBER
806: -- x_msg_data OUT VARCHAR2
807: -- Version : Current version 1.0
808: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
809: -- and basic operation, developer must manually add parameters and business logic as necessary.
810: --
811: -- History
812: --
832: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
833: l_object_version_number NUMBER;
834:
835: BEGIN
836: -- Standard Start of API savepoint
837: SAVEPOINT delete_offer_adjustment_pvt;
838:
839: -- Standard call to check for call compatibility.
840: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
835: BEGIN
836: -- Standard Start of API savepoint
837: SAVEPOINT delete_offer_adjustment_pvt;
838:
839: -- Standard call to check for call compatibility.
840: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
841: p_api_version_number,
842: l_api_name,
843: G_PKG_NAME)
875: --
876: -- End of API body
877: --
878:
879: -- Standard check for p_commit
880: IF FND_API.to_Boolean( p_commit )
881: THEN
882: COMMIT WORK;
883: END IF;
886: -- Debug Message
887: OZF_Offer_Adj_Line_PVT.debug_message('Private API: ' || l_api_name || 'end');
888:
889:
890: -- Standard call to get message count and if count is 1, get message info.
891: FND_MSG_PUB.Count_And_Get
892: (p_count => x_msg_count,
893: p_data => x_msg_data
894: );
900:
901: WHEN FND_API.G_EXC_ERROR THEN
902: ROLLBACK TO DELETE_Offer_Adjustment_PVT;
903: x_return_status := FND_API.G_RET_STS_ERROR;
904: -- Standard call to get message count and if count=1, get the message
905: FND_MSG_PUB.Count_And_Get (
906: p_encoded => FND_API.G_FALSE,
907: p_count => x_msg_count,
908: p_data => x_msg_data
910:
911: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
912: ROLLBACK TO DELETE_Offer_Adjustment_PVT;
913: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
914: -- Standard call to get message count and if count=1, get the message
915: FND_MSG_PUB.Count_And_Get (
916: p_encoded => FND_API.G_FALSE,
917: p_count => x_msg_count,
918: p_data => x_msg_data
924: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
925: THEN
926: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
927: END IF;
928: -- Standard call to get message count and if count=1, get the message
929: FND_MSG_PUB.Count_And_Get (
930: p_encoded => FND_API.G_FALSE,
931: p_count => x_msg_count,
932: p_data => x_msg_data
958: -- x_return_status OUT VARCHAR2
959: -- x_msg_count OUT NUMBER
960: -- x_msg_data OUT VARCHAR2
961: -- Version : Current version 1.0
962: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
963: -- and basic operation, developer must manually add parameters and business logic as necessary.
964: --
965: -- History
966: --
1000: END IF;
1001:
1002:
1003:
1004: -- Standard call to check for call compatibility.
1005: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1006: p_api_version_number,
1007: l_api_name,
1008: G_PKG_NAME)
1034:
1035: WHEN FND_API.G_EXC_ERROR THEN
1036: ROLLBACK TO LOCK_Offer_Adjustment_PVT;
1037: x_return_status := FND_API.G_RET_STS_ERROR;
1038: -- Standard call to get message count and if count=1, get the message
1039: FND_MSG_PUB.Count_And_Get (
1040: p_encoded => FND_API.G_FALSE,
1041: p_count => x_msg_count,
1042: p_data => x_msg_data
1044:
1045: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1046: ROLLBACK TO LOCK_Offer_Adjustment_PVT;
1047: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1048: -- Standard call to get message count and if count=1, get the message
1049: FND_MSG_PUB.Count_And_Get (
1050: p_encoded => FND_API.G_FALSE,
1051: p_count => x_msg_count,
1052: p_data => x_msg_data
1058: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1059: THEN
1060: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1061: END IF;
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
1507: l_object_version_number NUMBER;
1508: l_offer_adj_rec offer_adj_rec_type;
1509:
1510: BEGIN
1511: -- Standard Start of API savepoint
1512: SAVEPOINT validate_offer_adjustment_;
1513:
1514: -- Standard call to check for call compatibility.
1515: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1510: BEGIN
1511: -- Standard Start of API savepoint
1512: SAVEPOINT validate_offer_adjustment_;
1513:
1514: -- Standard call to check for call compatibility.
1515: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1516: p_api_version_number,
1517: l_api_name,
1518: G_PKG_NAME)
1588: -- Debug Message
1589: OZF_Offer_Adj_Line_PVT.debug_message('Private API: ' || l_api_name || 'end');
1590:
1591:
1592: -- Standard call to get message count and if count is 1, get message info.
1593: FND_MSG_PUB.Count_And_Get
1594: (p_count => x_msg_count,
1595: p_data => x_msg_data
1596: );
1602:
1603: WHEN FND_API.G_EXC_ERROR THEN
1604: ROLLBACK TO VALIDATE_Offer_Adjustment_;
1605: x_return_status := FND_API.G_RET_STS_ERROR;
1606: -- Standard call to get message count and if count=1, get the message
1607: FND_MSG_PUB.Count_And_Get (
1608: p_encoded => FND_API.G_FALSE,
1609: p_count => x_msg_count,
1610: p_data => x_msg_data
1612:
1613: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1614: ROLLBACK TO VALIDATE_Offer_Adjustment_;
1615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1616: -- Standard call to get message count and if count=1, get the message
1617: FND_MSG_PUB.Count_And_Get (
1618: p_encoded => FND_API.G_FALSE,
1619: p_count => x_msg_count,
1620: p_data => x_msg_data
1626: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1627: THEN
1628: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1629: END IF;
1630: -- Standard call to get message count and if count=1, get the message
1631: FND_MSG_PUB.Count_And_Get (
1632: p_encoded => FND_API.G_FALSE,
1633: p_count => x_msg_count,
1634: p_data => x_msg_data
1663: -- x_return_status := FND_API.G_RET_STS_ERROR;
1664:
1665: -- Debug Message
1666: OZF_Offer_Adj_Line_PVT.debug_message('Private API: Validate_dm_model_rec');
1667: -- Standard call to get message count and if count is 1, get message info.
1668: FND_MSG_PUB.Count_And_Get
1669: (p_count => x_msg_count,
1670: p_data => x_msg_data
1671: );