[Home] [Help]
56: -- x_return_status OUT VARCHAR2
57: -- x_msg_count OUT NUMBER
58: -- x_msg_data OUT VARCHAR2
59: -- Version : Current version 1.0
60: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
61: -- and basic operation, developer must manually add parameters and business logic as necessary.
62: --
63: -- History
64: --
97: SELECT 1
98: FROM ozf_OFFER_ADJUSTMENT_TIERS
99: WHERE offer_adjst_tier_id = l_id;
100: BEGIN
101: -- Standard Start of API savepoint
102: SAVEPOINT create_offer_adj_tier_pvt;
103:
104: -- Standard call to check for call compatibility.
105: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
100: BEGIN
101: -- Standard Start of API savepoint
102: SAVEPOINT create_offer_adj_tier_pvt;
103:
104: -- Standard call to check for call compatibility.
105: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
106: p_api_version_number,
107: l_api_name,
108: G_PKG_NAME)
206: --
207: -- End of API body
208: --
209:
210: -- Standard check for p_commit
211: IF FND_API.to_Boolean( p_commit )
212: THEN
213: COMMIT WORK;
214: END IF;
217: -- Debug Message
218: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
219:
220:
221: -- Standard call to get message count and if count is 1, get message info.
222: FND_MSG_PUB.Count_And_Get
223: (p_count => x_msg_count,
224: p_data => x_msg_data
225: );
231:
232: WHEN FND_API.G_EXC_ERROR THEN
233: ROLLBACK TO CREATE_Offer_Adj_Tier_PVT;
234: x_return_status := FND_API.G_RET_STS_ERROR;
235: -- Standard call to get message count and if count=1, get the message
236: FND_MSG_PUB.Count_And_Get (
237: p_encoded => FND_API.G_FALSE,
238: p_count => x_msg_count,
239: p_data => x_msg_data
241:
242: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
243: ROLLBACK TO CREATE_Offer_Adj_Tier_PVT;
244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
245: -- Standard call to get message count and if count=1, get the message
246: FND_MSG_PUB.Count_And_Get (
247: p_encoded => FND_API.G_FALSE,
248: p_count => x_msg_count,
249: p_data => x_msg_data
255: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
256: THEN
257: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
258: END IF;
259: -- Standard call to get message count and if count=1, get the message
260: FND_MSG_PUB.Count_And_Get (
261: p_encoded => FND_API.G_FALSE,
262: p_count => x_msg_count,
263: p_data => x_msg_data
287: -- x_return_status OUT VARCHAR2
288: -- x_msg_count OUT NUMBER
289: -- x_msg_data OUT VARCHAR2
290: -- Version : Current version 1.0
291: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
292: -- and basic operation, developer must manually add parameters and business logic as necessary.
293: --
294: -- History
295: --
331: l_tar_offadj_tier_rec offadj_tier_rec_type := P_offadj_tier_rec;
332: l_rowid ROWID;
333:
334: BEGIN
335: -- Standard Start of API savepoint
336: SAVEPOINT update_offer_adj_tier_pvt;
337:
338: -- Standard call to check for call compatibility.
339: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
334: BEGIN
335: -- Standard Start of API savepoint
336: SAVEPOINT update_offer_adj_tier_pvt;
337:
338: -- Standard call to check for call compatibility.
339: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
340: p_api_version_number,
341: l_api_name,
342: G_PKG_NAME)
441: --
442: -- End of API body.
443: --
444:
445: -- Standard check for p_commit
446: IF FND_API.to_Boolean( p_commit )
447: THEN
448: COMMIT WORK;
449: END IF;
452: -- Debug Message
453: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
454:
455:
456: -- Standard call to get message count and if count is 1, get message info.
457: FND_MSG_PUB.Count_And_Get
458: (p_count => x_msg_count,
459: p_data => x_msg_data
460: );
466:
467: WHEN FND_API.G_EXC_ERROR THEN
468: ROLLBACK TO UPDATE_Offer_Adj_Tier_PVT;
469: x_return_status := FND_API.G_RET_STS_ERROR;
470: -- Standard call to get message count and if count=1, get the message
471: FND_MSG_PUB.Count_And_Get (
472: p_encoded => FND_API.G_FALSE,
473: p_count => x_msg_count,
474: p_data => x_msg_data
476:
477: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
478: ROLLBACK TO UPDATE_Offer_Adj_Tier_PVT;
479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
480: -- Standard call to get message count and if count=1, get the message
481: FND_MSG_PUB.Count_And_Get (
482: p_encoded => FND_API.G_FALSE,
483: p_count => x_msg_count,
484: p_data => x_msg_data
490: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
491: THEN
492: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
493: END IF;
494: -- Standard call to get message count and if count=1, get the message
495: FND_MSG_PUB.Count_And_Get (
496: p_encoded => FND_API.G_FALSE,
497: p_count => x_msg_count,
498: p_data => x_msg_data
523: -- x_return_status OUT VARCHAR2
524: -- x_msg_count OUT NUMBER
525: -- x_msg_data OUT VARCHAR2
526: -- Version : Current version 1.0
527: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
528: -- and basic operation, developer must manually add parameters and business logic as necessary.
529: --
530: -- History
531: --
551: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
552: l_object_version_number NUMBER;
553:
554: BEGIN
555: -- Standard Start of API savepoint
556: SAVEPOINT delete_offer_adj_tier_pvt;
557:
558: -- Standard call to check for call compatibility.
559: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
554: BEGIN
555: -- Standard Start of API savepoint
556: SAVEPOINT delete_offer_adj_tier_pvt;
557:
558: -- Standard call to check for call compatibility.
559: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
560: p_api_version_number,
561: l_api_name,
562: G_PKG_NAME)
594: --
595: -- End of API body
596: --
597:
598: -- Standard check for p_commit
599: IF FND_API.to_Boolean( p_commit )
600: THEN
601: COMMIT WORK;
602: END IF;
605: -- Debug Message
606: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
607:
608:
609: -- Standard call to get message count and if count is 1, get message info.
610: FND_MSG_PUB.Count_And_Get
611: (p_count => x_msg_count,
612: p_data => x_msg_data
613: );
619:
620: WHEN FND_API.G_EXC_ERROR THEN
621: ROLLBACK TO DELETE_Offer_Adj_Tier_PVT;
622: x_return_status := FND_API.G_RET_STS_ERROR;
623: -- Standard call to get message count and if count=1, get the message
624: FND_MSG_PUB.Count_And_Get (
625: p_encoded => FND_API.G_FALSE,
626: p_count => x_msg_count,
627: p_data => x_msg_data
629:
630: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
631: ROLLBACK TO DELETE_Offer_Adj_Tier_PVT;
632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
633: -- Standard call to get message count and if count=1, get the message
634: FND_MSG_PUB.Count_And_Get (
635: p_encoded => FND_API.G_FALSE,
636: p_count => x_msg_count,
637: p_data => x_msg_data
643: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
644: THEN
645: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
646: END IF;
647: -- Standard call to get message count and if count=1, get the message
648: FND_MSG_PUB.Count_And_Get (
649: p_encoded => FND_API.G_FALSE,
650: p_count => x_msg_count,
651: p_data => x_msg_data
677: -- x_return_status OUT VARCHAR2
678: -- x_msg_count OUT NUMBER
679: -- x_msg_data OUT VARCHAR2
680: -- Version : Current version 1.0
681: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
682: -- and basic operation, developer must manually add parameters and business logic as necessary.
683: --
684: -- History
685: --
719: END IF;
720:
721:
722:
723: -- Standard call to check for call compatibility.
724: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
725: p_api_version_number,
726: l_api_name,
727: G_PKG_NAME)
753:
754: WHEN FND_API.G_EXC_ERROR THEN
755: ROLLBACK TO LOCK_Offer_Adj_Tier_PVT;
756: x_return_status := FND_API.G_RET_STS_ERROR;
757: -- Standard call to get message count and if count=1, get the message
758: FND_MSG_PUB.Count_And_Get (
759: p_encoded => FND_API.G_FALSE,
760: p_count => x_msg_count,
761: p_data => x_msg_data
763:
764: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
765: ROLLBACK TO LOCK_Offer_Adj_Tier_PVT;
766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
767: -- Standard call to get message count and if count=1, get the message
768: FND_MSG_PUB.Count_And_Get (
769: p_encoded => FND_API.G_FALSE,
770: p_count => x_msg_count,
771: p_data => x_msg_data
777: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
778: THEN
779: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
780: END IF;
781: -- Standard call to get message count and if count=1, get the message
782: FND_MSG_PUB.Count_And_Get (
783: p_encoded => FND_API.G_FALSE,
784: p_count => x_msg_count,
785: p_data => x_msg_data
1159: l_object_version_number NUMBER;
1160: l_offadj_tier_rec offadj_tier_rec_type;
1161:
1162: BEGIN
1163: -- Standard Start of API savepoint
1164: SAVEPOINT validate_offer_adj_tier_;
1165:
1166: -- Standard call to check for call compatibility.
1167: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1162: BEGIN
1163: -- Standard Start of API savepoint
1164: SAVEPOINT validate_offer_adj_tier_;
1165:
1166: -- Standard call to check for call compatibility.
1167: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1168: p_api_version_number,
1169: l_api_name,
1170: G_PKG_NAME)
1234: -- Debug Message
1235: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1236:
1237:
1238: -- Standard call to get message count and if count is 1, get message info.
1239: FND_MSG_PUB.Count_And_Get
1240: (p_count => x_msg_count,
1241: p_data => x_msg_data
1242: );
1248:
1249: WHEN FND_API.G_EXC_ERROR THEN
1250: ROLLBACK TO VALIDATE_Offer_Adj_Tier_;
1251: x_return_status := FND_API.G_RET_STS_ERROR;
1252: -- Standard call to get message count and if count=1, get the message
1253: FND_MSG_PUB.Count_And_Get (
1254: p_encoded => FND_API.G_FALSE,
1255: p_count => x_msg_count,
1256: p_data => x_msg_data
1258:
1259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1260: ROLLBACK TO VALIDATE_Offer_Adj_Tier_;
1261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1262: -- Standard call to get message count and if count=1, get the message
1263: FND_MSG_PUB.Count_And_Get (
1264: p_encoded => FND_API.G_FALSE,
1265: p_count => x_msg_count,
1266: p_data => x_msg_data
1272: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1273: THEN
1274: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1275: END IF;
1276: -- Standard call to get message count and if count=1, get the message
1277: FND_MSG_PUB.Count_And_Get (
1278: p_encoded => FND_API.G_FALSE,
1279: p_count => x_msg_count,
1280: p_data => x_msg_data
1309: -- x_return_status := FND_API.G_RET_STS_ERROR;
1310:
1311: -- Debug Message
1312: OZF_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1313: -- Standard call to get message count and if count is 1, get message info.
1314: FND_MSG_PUB.Count_And_Get
1315: (p_count => x_msg_count,
1316: p_data => x_msg_data
1317: );