[Home] [Help]
68: FROM ozf_OFFER_ADJUSTMENTS_B
69: WHERE OFFER_ADJUSTMENT_ID = l_id;
70:
71: BEGIN
72: -- Standard Start of API savepoint
73: SAVEPOINT CREATE_Offer_Backdate_PVT;
74:
75: -- Standard call to check for call compatibility.
76: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
71: BEGIN
72: -- Standard Start of API savepoint
73: SAVEPOINT CREATE_Offer_Backdate_PVT;
74:
75: -- Standard call to check for call compatibility.
76: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
77: p_api_version_number,
78: l_api_name,
79: G_PKG_NAME)
173: --
174: -- End of API body
175: --
176:
177: -- Standard check for p_commit
178: IF FND_API.to_Boolean( p_commit )
179: THEN
180: COMMIT WORK;
181: END IF;
183:
184: -- Debug Message
185: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
186:
187: -- Standard call to get message count and if count is 1, get message info.
188: FND_MSG_PUB.Count_And_Get
189: (p_count => x_msg_count,
190: p_data => x_msg_data
191: );
197:
198: WHEN FND_API.G_EXC_ERROR THEN
199: ROLLBACK TO CREATE_Offer_Backdate_PVT;
200: x_return_status := FND_API.G_RET_STS_ERROR;
201: -- Standard call to get message count and if count=1, get the message
202: FND_MSG_PUB.Count_And_Get (
203: p_encoded => FND_API.G_FALSE,
204: p_count => x_msg_count,
205: p_data => x_msg_data
207:
208: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
209: ROLLBACK TO CREATE_Offer_Backdate_PVT;
210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
211: -- Standard call to get message count and if count=1, get the message
212: FND_MSG_PUB.Count_And_Get (
213: p_encoded => FND_API.G_FALSE,
214: p_count => x_msg_count,
215: p_data => x_msg_data
221: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
222: THEN
223: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
224: END IF;
225: -- Standard call to get message count and if count=1, get the message
226: FND_MSG_PUB.Count_And_Get (
227: p_encoded => FND_API.G_FALSE,
228: p_count => x_msg_count,
229: p_data => x_msg_data
269: l_tar_offer_backdate_rec OZF_Offer_Backdate_PVT.offer_backdate_rec_type := P_offer_backdate_rec;
270: l_rowid ROWID;
271:
272: BEGIN
273: -- Standard Start of API savepoint
274: SAVEPOINT UPDATE_Offer_Backdate_PVT;
275:
276: -- Standard call to check for call compatibility.
277: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
272: BEGIN
273: -- Standard Start of API savepoint
274: SAVEPOINT UPDATE_Offer_Backdate_PVT;
275:
276: -- Standard call to check for call compatibility.
277: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
278: p_api_version_number,
279: l_api_name,
280: G_PKG_NAME)
411: --
412: -- End of API body.
413: --
414:
415: -- Standard check for p_commit
416: IF FND_API.to_Boolean( p_commit )
417: THEN
418: COMMIT WORK;
419: END IF;
421:
422: -- Debug Message
423: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
424:
425: -- Standard call to get message count and if count is 1, get message info.
426: FND_MSG_PUB.Count_And_Get
427: (p_count => x_msg_count,
428: p_data => x_msg_data
429: );
435:
436: WHEN FND_API.G_EXC_ERROR THEN
437: ROLLBACK TO UPDATE_Offer_Backdate_PVT;
438: x_return_status := FND_API.G_RET_STS_ERROR;
439: -- Standard call to get message count and if count=1, get the message
440: FND_MSG_PUB.Count_And_Get (
441: p_encoded => FND_API.G_FALSE,
442: p_count => x_msg_count,
443: p_data => x_msg_data
445:
446: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
447: ROLLBACK TO UPDATE_Offer_Backdate_PVT;
448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
449: -- Standard call to get message count and if count=1, get the message
450: FND_MSG_PUB.Count_And_Get (
451: p_encoded => FND_API.G_FALSE,
452: p_count => x_msg_count,
453: p_data => x_msg_data
459: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
460: THEN
461: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
462: END IF;
463: -- Standard call to get message count and if count=1, get the message
464: FND_MSG_PUB.Count_And_Get (
465: p_encoded => FND_API.G_FALSE,
466: p_count => x_msg_count,
467: p_data => x_msg_data
486: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
487: l_object_version_number NUMBER;
488:
489: BEGIN
490: -- Standard Start of API savepoint
491: SAVEPOINT DELETE_Offer_Backdate_PVT;
492:
493: -- Standard call to check for call compatibility.
494: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
489: BEGIN
490: -- Standard Start of API savepoint
491: SAVEPOINT DELETE_Offer_Backdate_PVT;
492:
493: -- Standard call to check for call compatibility.
494: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
495: p_api_version_number,
496: l_api_name,
497: G_PKG_NAME)
524: --
525: -- End of API body
526: --
527:
528: -- Standard check for p_commit
529: IF FND_API.to_Boolean( p_commit )
530: THEN
531: COMMIT WORK;
532: END IF;
534:
535: -- Debug Message
536: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
537:
538: -- Standard call to get message count and if count is 1, get message info.
539: FND_MSG_PUB.Count_And_Get
540: (p_count => x_msg_count,
541: p_data => x_msg_data
542: );
548:
549: WHEN FND_API.G_EXC_ERROR THEN
550: ROLLBACK TO DELETE_Offer_Backdate_PVT;
551: x_return_status := FND_API.G_RET_STS_ERROR;
552: -- Standard call to get message count and if count=1, get the message
553: FND_MSG_PUB.Count_And_Get (
554: p_encoded => FND_API.G_FALSE,
555: p_count => x_msg_count,
556: p_data => x_msg_data
558:
559: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
560: ROLLBACK TO DELETE_Offer_Backdate_PVT;
561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
562: -- Standard call to get message count and if count=1, get the message
563: FND_MSG_PUB.Count_And_Get (
564: p_encoded => FND_API.G_FALSE,
565: p_count => x_msg_count,
566: p_data => x_msg_data
572: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
573: THEN
574: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
575: END IF;
576: -- Standard call to get message count and if count=1, get the message
577: FND_MSG_PUB.Count_And_Get (
578: p_encoded => FND_API.G_FALSE,
579: p_count => x_msg_count,
580: p_data => x_msg_data
619: THEN
620: FND_MSG_PUB.initialize;
621: END IF;
622:
623: -- Standard call to check for call compatibility.
624: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
625: p_api_version_number,
626: l_api_name,
627: G_PKG_NAME)
666:
667: WHEN FND_API.G_EXC_ERROR THEN
668: ROLLBACK TO LOCK_Offer_Backdate_PVT;
669: x_return_status := FND_API.G_RET_STS_ERROR;
670: -- Standard call to get message count and if count=1, get the message
671: FND_MSG_PUB.Count_And_Get (
672: p_encoded => FND_API.G_FALSE,
673: p_count => x_msg_count,
674: p_data => x_msg_data
676:
677: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
678: ROLLBACK TO LOCK_Offer_Backdate_PVT;
679: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
680: -- Standard call to get message count and if count=1, get the message
681: FND_MSG_PUB.Count_And_Get (
682: p_encoded => FND_API.G_FALSE,
683: p_count => x_msg_count,
684: p_data => x_msg_data
690: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
691: THEN
692: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
693: END IF;
694: -- Standard call to get message count and if count=1, get the message
695: FND_MSG_PUB.Count_And_Get (
696: p_encoded => FND_API.G_FALSE,
697: p_count => x_msg_count,
698: p_data => x_msg_data
982: l_object_version_number NUMBER;
983: l_offer_backdate_rec OZF_Offer_Backdate_PVT.offer_backdate_rec_type;
984:
985: BEGIN
986: -- Standard Start of API savepoint
987: SAVEPOINT VALIDATE_Offer_Backdate_;
988:
989: -- Standard call to check for call compatibility.
990: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
985: BEGIN
986: -- Standard Start of API savepoint
987: SAVEPOINT VALIDATE_Offer_Backdate_;
988:
989: -- Standard call to check for call compatibility.
990: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
991: p_api_version_number,
992: l_api_name,
993: G_PKG_NAME)
1046:
1047: -- Debug Message
1048: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1049:
1050: -- Standard call to get message count and if count is 1, get message info.
1051: FND_MSG_PUB.Count_And_Get
1052: (p_count => x_msg_count,
1053: p_data => x_msg_data
1054: );
1060:
1061: WHEN FND_API.G_EXC_ERROR THEN
1062: ROLLBACK TO VALIDATE_Offer_Backdate_;
1063: x_return_status := FND_API.G_RET_STS_ERROR;
1064: -- Standard call to get message count and if count=1, get the message
1065: FND_MSG_PUB.Count_And_Get (
1066: p_encoded => FND_API.G_FALSE,
1067: p_count => x_msg_count,
1068: p_data => x_msg_data
1070:
1071: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1072: ROLLBACK TO VALIDATE_Offer_Backdate_;
1073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1074: -- Standard call to get message count and if count=1, get the message
1075: FND_MSG_PUB.Count_And_Get (
1076: p_encoded => FND_API.G_FALSE,
1077: p_count => x_msg_count,
1078: p_data => x_msg_data
1084: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1085: THEN
1086: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1087: END IF;
1088: -- Standard call to get message count and if count=1, get the message
1089: FND_MSG_PUB.Count_And_Get (
1090: p_encoded => FND_API.G_FALSE,
1091: p_count => x_msg_count,
1092: p_data => x_msg_data
1119: -- x_return_status := FND_API.G_RET_STS_ERROR;
1120:
1121: -- Debug Message
1122: OZF_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1123: -- Standard call to get message count and if count is 1, get message info.
1124: FND_MSG_PUB.Count_And_Get
1125: (p_count => x_msg_count,
1126: p_data => x_msg_data
1127: );