[Home] [Help]
51: WHERE OFFER_PERFORMANCE_ID = l_id;
52:
53: BEGIN
54: --dbms_output.put_line('First message');
55: -- Standard Start of API savepoint
56: SAVEPOINT CREATE_Offer_Performance_PVT;
57:
58: ozf_utility_pvt.debug_message('inside create');
59: -- Standard call to check for call compatibility.
55: -- Standard Start of API savepoint
56: SAVEPOINT CREATE_Offer_Performance_PVT;
57:
58: ozf_utility_pvt.debug_message('inside create');
59: -- Standard call to check for call compatibility.
60: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
61: p_api_version_number,
62: l_api_name,
63: G_PKG_NAME)
178: --
179: -- End of API body
180: --
181:
182: -- Standard check for p_commit
183: IF FND_API.to_Boolean( p_commit )
184: THEN
185: COMMIT WORK;
186: END IF;
188:
189: -- Debug Message
190: ozf_utility_pvt.debug_message('Private API: ' || l_api_name || 'end');
191:
192: -- Standard call to get message count and if count is 1, get message info.
193: FND_MSG_PUB.Count_And_Get
194: (p_count => x_msg_count,
195: p_data => x_msg_data
196: );
202:
203: WHEN FND_API.G_EXC_ERROR THEN
204: ROLLBACK TO CREATE_Offer_Performance_PVT;
205: x_return_status := FND_API.G_RET_STS_ERROR;
206: -- Standard call to get message count and if count=1, get the message
207: FND_MSG_PUB.Count_And_Get (
208: p_encoded => FND_API.G_FALSE,
209: p_count => x_msg_count,
210: p_data => x_msg_data
212:
213: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
214: ROLLBACK TO CREATE_Offer_Performance_PVT;
215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
216: -- Standard call to get message count and if count=1, get the message
217: FND_MSG_PUB.Count_And_Get (
218: p_encoded => FND_API.G_FALSE,
219: p_count => x_msg_count,
220: p_data => x_msg_data
226: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
227: THEN
228: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
229: END IF;
230: -- Standard call to get message count and if count=1, get the message
231: FND_MSG_PUB.Count_And_Get (
232: p_encoded => FND_API.G_FALSE,
233: p_count => x_msg_count,
234: p_data => x_msg_data
268: l_rowid ROWID;
269:
270: BEGIN
271: --dbms_output.put_line('second message');
272: -- Standard Start of API savepoint
273: SAVEPOINT UPDATE_Offer_Performance_PVT;
274: ozf_utility_pvt.debug_message('Inside update Private API: - Open Cursor to Select');
275: ozf_utility_pvt.debug_message('Inside update Private API: - Open Cursor to Select');
276: -- Standard call to check for call compatibility.
272: -- Standard Start of API savepoint
273: SAVEPOINT UPDATE_Offer_Performance_PVT;
274: ozf_utility_pvt.debug_message('Inside update Private API: - Open Cursor to Select');
275: ozf_utility_pvt.debug_message('Inside update Private API: - Open Cursor to Select');
276: -- Standard call to check for call compatibility.
277: -- RAISE FND_API.G_EXC_ERROR;
278: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
279: p_api_version_number,
280: l_api_name,
400: --
401: -- End of API body.
402: --
403:
404: -- Standard check for p_commit
405: IF FND_API.to_Boolean( p_commit )
406: THEN
407: COMMIT WORK;
408: END IF;
410:
411: -- Debug Message
412: ozf_utility_pvt.debug_message('Private API: ' || l_api_name || 'end');
413:
414: -- Standard call to get message count and if count is 1, get message info.
415: FND_MSG_PUB.Count_And_Get
416: (p_count => x_msg_count,
417: p_data => x_msg_data
418: );
424:
425: WHEN FND_API.G_EXC_ERROR THEN
426: ROLLBACK TO UPDATE_Offer_Performance_PVT;
427: x_return_status := FND_API.G_RET_STS_ERROR;
428: -- Standard call to get message count and if count=1, get the message
429: FND_MSG_PUB.Count_And_Get (
430: p_encoded => FND_API.G_FALSE,
431: p_count => x_msg_count,
432: p_data => x_msg_data
434:
435: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
436: ROLLBACK TO UPDATE_Offer_Performance_PVT;
437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
438: -- Standard call to get message count and if count=1, get the message
439: FND_MSG_PUB.Count_And_Get (
440: p_encoded => FND_API.G_FALSE,
441: p_count => x_msg_count,
442: p_data => x_msg_data
448: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
449: THEN
450: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
451: END IF;
452: -- Standard call to get message count and if count=1, get the message
453: FND_MSG_PUB.Count_And_Get (
454: p_encoded => FND_API.G_FALSE,
455: p_count => x_msg_count,
456: p_data => x_msg_data
476: l_object_version_number NUMBER;
477:
478: BEGIN
479: --dbms_output.put_line('Third message');
480: -- Standard Start of API savepoint
481: SAVEPOINT DELETE_Offer_Performance_PVT;
482:
483: -- Standard call to check for call compatibility.
484: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
479: --dbms_output.put_line('Third message');
480: -- Standard Start of API savepoint
481: SAVEPOINT DELETE_Offer_Performance_PVT;
482:
483: -- Standard call to check for call compatibility.
484: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
485: p_api_version_number,
486: l_api_name,
487: G_PKG_NAME)
514: --
515: -- End of API body
516: --
517:
518: -- Standard check for p_commit
519: IF FND_API.to_Boolean( p_commit )
520: THEN
521: COMMIT WORK;
522: END IF;
524:
525: -- Debug Message
526: ozf_utility_pvt.debug_message('Private API: ' || l_api_name || 'end');
527:
528: -- Standard call to get message count and if count is 1, get message info.
529: FND_MSG_PUB.Count_And_Get
530: (p_count => x_msg_count,
531: p_data => x_msg_data
532: );
538:
539: WHEN FND_API.G_EXC_ERROR THEN
540: ROLLBACK TO DELETE_Offer_Performance_PVT;
541: x_return_status := FND_API.G_RET_STS_ERROR;
542: -- Standard call to get message count and if count=1, get the message
543: FND_MSG_PUB.Count_And_Get (
544: p_encoded => FND_API.G_FALSE,
545: p_count => x_msg_count,
546: p_data => x_msg_data
548:
549: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
550: ROLLBACK TO DELETE_Offer_Performance_PVT;
551: x_return_status := FND_API.G_RET_STS_UNEXP_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
562: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
563: THEN
564: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
565: END IF;
566: -- Standard call to get message count and if count=1, get the message
567: FND_MSG_PUB.Count_And_Get (
568: p_encoded => FND_API.G_FALSE,
569: p_count => x_msg_count,
570: p_data => x_msg_data
609: THEN
610: FND_MSG_PUB.initialize;
611: END IF;
612:
613: -- Standard call to check for call compatibility.
614: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
615: p_api_version_number,
616: l_api_name,
617: G_PKG_NAME)
656:
657: WHEN FND_API.G_EXC_ERROR THEN
658: ROLLBACK TO LOCK_Offer_Performance_PVT;
659: x_return_status := FND_API.G_RET_STS_ERROR;
660: -- Standard call to get message count and if count=1, get the message
661: FND_MSG_PUB.Count_And_Get (
662: p_encoded => FND_API.G_FALSE,
663: p_count => x_msg_count,
664: p_data => x_msg_data
666:
667: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
668: ROLLBACK TO LOCK_Offer_Performance_PVT;
669: x_return_status := FND_API.G_RET_STS_UNEXP_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
680: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
681: THEN
682: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
683: END IF;
684: -- Standard call to get message count and if count=1, get the message
685: FND_MSG_PUB.Count_And_Get (
686: p_encoded => FND_API.G_FALSE,
687: p_count => x_msg_count,
688: p_data => x_msg_data
1045: l_object_version_number NUMBER;
1046: l_offer_perf_rec OZF_Offer_Performance_PVT.offer_perf_rec_type;
1047:
1048: BEGIN
1049: -- Standard Start of API savepoint
1050: SAVEPOINT VALIDATE_Offer_Performance_;
1051:
1052: -- Standard call to check for call compatibility.
1053: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1048: BEGIN
1049: -- Standard Start of API savepoint
1050: SAVEPOINT VALIDATE_Offer_Performance_;
1051:
1052: -- Standard call to check for call compatibility.
1053: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1054: p_api_version_number,
1055: l_api_name,
1056: G_PKG_NAME)
1109:
1110: -- Debug Message
1111: ozf_utility_pvt.debug_message('Private API: ' || l_api_name || 'end');
1112:
1113: -- Standard call to get message count and if count is 1, get message info.
1114: FND_MSG_PUB.Count_And_Get
1115: (p_count => x_msg_count,
1116: p_data => x_msg_data
1117: );
1123:
1124: WHEN FND_API.G_EXC_ERROR THEN
1125: ROLLBACK TO VALIDATE_Offer_Performance_;
1126: x_return_status := FND_API.G_RET_STS_ERROR;
1127: -- Standard call to get message count and if count=1, get the message
1128: FND_MSG_PUB.Count_And_Get (
1129: p_encoded => FND_API.G_FALSE,
1130: p_count => x_msg_count,
1131: p_data => x_msg_data
1133:
1134: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1135: ROLLBACK TO VALIDATE_Offer_Performance_;
1136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1137: -- Standard call to get message count and if count=1, get the message
1138: FND_MSG_PUB.Count_And_Get (
1139: p_encoded => FND_API.G_FALSE,
1140: p_count => x_msg_count,
1141: p_data => x_msg_data
1147: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1148: THEN
1149: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1150: END IF;
1151: -- Standard call to get message count and if count=1, get the message
1152: FND_MSG_PUB.Count_And_Get (
1153: p_encoded => FND_API.G_FALSE,
1154: p_count => x_msg_count,
1155: p_data => x_msg_data
1182: -- x_return_status := FND_API.G_RET_STS_ERROR;
1183:
1184: -- Debug Message
1185: ozf_utility_pvt.debug_message('Private API: Validate_dm_model_rec');
1186: -- Standard call to get message count and if count is 1, get message info.
1187: FND_MSG_PUB.Count_And_Get
1188: (p_count => x_msg_count,
1189: p_data => x_msg_data
1190: );