[Home] [Help]
50: FROM OZF_OFFER_ADJUSTMENT_LINES
51: WHERE OFFER_ADJUSTMENT_LINE_ID = l_id;
52:
53: BEGIN
54: -- Standard Start of API savepoint
55: SAVEPOINT CREATE_Offer_Back_PVT;
56:
57: -- Standard call to check for call compatibility.
58: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
53: BEGIN
54: -- Standard Start of API savepoint
55: SAVEPOINT CREATE_Offer_Back_PVT;
56:
57: -- Standard call to check for call compatibility.
58: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
59: p_api_version_number,
60: l_api_name,
61: G_PKG_NAME)
152: --
153: -- End of API body
154: --
155:
156: -- Standard check for p_commit
157: IF FND_API.to_Boolean( p_commit )
158: THEN
159: COMMIT WORK;
160: END IF;
162:
163: -- Debug Message
164: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
165:
166: -- Standard call to get message count and if count is 1, get message info.
167: FND_MSG_PUB.Count_And_Get
168: (p_count => x_msg_count,
169: p_data => x_msg_data
170: );
176:
177: WHEN FND_API.G_EXC_ERROR THEN
178: ROLLBACK TO CREATE_Offer_Back_PVT;
179: x_return_status := FND_API.G_RET_STS_ERROR;
180: -- Standard call to get message count and if count=1, get the message
181: FND_MSG_PUB.Count_And_Get (
182: p_encoded => FND_API.G_FALSE,
183: p_count => x_msg_count,
184: p_data => x_msg_data
186:
187: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
188: ROLLBACK TO CREATE_Offer_Back_PVT;
189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
190: -- Standard call to get message count and if count=1, get the message
191: FND_MSG_PUB.Count_And_Get (
192: p_encoded => FND_API.G_FALSE,
193: p_count => x_msg_count,
194: p_data => x_msg_data
200: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
201: THEN
202: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
203: END IF;
204: -- Standard call to get message count and if count=1, get the message
205: FND_MSG_PUB.Count_And_Get (
206: p_encoded => FND_API.G_FALSE,
207: p_count => x_msg_count,
208: p_data => x_msg_data
241: l_tar_offer_back_create_rec OZF_Offer_Back_Create_PVT.offer_back_create_rec_type := P_offer_back_create_rec;
242: l_rowid ROWID;
243:
244: BEGIN
245: -- Standard Start of API savepoint
246: SAVEPOINT UPDATE_Offer_Back_PVT;
247:
248: -- Standard call to check for call compatibility.
249: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
244: BEGIN
245: -- Standard Start of API savepoint
246: SAVEPOINT UPDATE_Offer_Back_PVT;
247:
248: -- Standard call to check for call compatibility.
249: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
250: p_api_version_number,
251: l_api_name,
252: G_PKG_NAME)
352: --
353: -- End of API body.
354: --
355:
356: -- Standard check for p_commit
357: IF FND_API.to_Boolean( p_commit )
358: THEN
359: COMMIT WORK;
360: END IF;
362:
363: -- Debug Message
364: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
365:
366: -- Standard call to get message count and if count is 1, get message info.
367: FND_MSG_PUB.Count_And_Get
368: (p_count => x_msg_count,
369: p_data => x_msg_data
370: );
376:
377: WHEN FND_API.G_EXC_ERROR THEN
378: ROLLBACK TO UPDATE_Offer_Back_PVT;
379: x_return_status := FND_API.G_RET_STS_ERROR;
380: -- Standard call to get message count and if count=1, get the message
381: FND_MSG_PUB.Count_And_Get (
382: p_encoded => FND_API.G_FALSE,
383: p_count => x_msg_count,
384: p_data => x_msg_data
386:
387: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
388: ROLLBACK TO UPDATE_Offer_Back_PVT;
389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
390: -- Standard call to get message count and if count=1, get the message
391: FND_MSG_PUB.Count_And_Get (
392: p_encoded => FND_API.G_FALSE,
393: p_count => x_msg_count,
394: p_data => x_msg_data
400: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
401: THEN
402: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
403: END IF;
404: -- Standard call to get message count and if count=1, get the message
405: FND_MSG_PUB.Count_And_Get (
406: p_encoded => FND_API.G_FALSE,
407: p_count => x_msg_count,
408: p_data => x_msg_data
427: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
428: l_object_version_number NUMBER;
429:
430: BEGIN
431: -- Standard Start of API savepoint
432: SAVEPOINT DELETE_Offer_Back_Create_PVT;
433:
434: -- Standard call to check for call compatibility.
435: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
430: BEGIN
431: -- Standard Start of API savepoint
432: SAVEPOINT DELETE_Offer_Back_Create_PVT;
433:
434: -- Standard call to check for call compatibility.
435: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
436: p_api_version_number,
437: l_api_name,
438: G_PKG_NAME)
465: --
466: -- End of API body
467: --
468:
469: -- Standard check for p_commit
470: IF FND_API.to_Boolean( p_commit )
471: THEN
472: COMMIT WORK;
473: END IF;
475:
476: -- Debug Message
477: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
478:
479: -- Standard call to get message count and if count is 1, get message info.
480: FND_MSG_PUB.Count_And_Get
481: (p_count => x_msg_count,
482: p_data => x_msg_data
483: );
489:
490: WHEN FND_API.G_EXC_ERROR THEN
491: ROLLBACK TO DELETE_Offer_Back_PVT;
492: x_return_status := FND_API.G_RET_STS_ERROR;
493: -- Standard call to get message count and if count=1, get the message
494: FND_MSG_PUB.Count_And_Get (
495: p_encoded => FND_API.G_FALSE,
496: p_count => x_msg_count,
497: p_data => x_msg_data
499:
500: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
501: ROLLBACK TO DELETE_Offer_Back_PVT;
502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
503: -- Standard call to get message count and if count=1, get the message
504: FND_MSG_PUB.Count_And_Get (
505: p_encoded => FND_API.G_FALSE,
506: p_count => x_msg_count,
507: p_data => x_msg_data
513: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
514: THEN
515: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
516: END IF;
517: -- Standard call to get message count and if count=1, get the message
518: FND_MSG_PUB.Count_And_Get (
519: p_encoded => FND_API.G_FALSE,
520: p_count => x_msg_count,
521: p_data => x_msg_data
560: THEN
561: FND_MSG_PUB.initialize;
562: END IF;
563:
564: -- Standard call to check for call compatibility.
565: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
566: p_api_version_number,
567: l_api_name,
568: G_PKG_NAME)
607:
608: WHEN FND_API.G_EXC_ERROR THEN
609: ROLLBACK TO LOCK_Offer_Back_PVT;
610: x_return_status := FND_API.G_RET_STS_ERROR;
611: -- Standard call to get message count and if count=1, get the message
612: FND_MSG_PUB.Count_And_Get (
613: p_encoded => FND_API.G_FALSE,
614: p_count => x_msg_count,
615: p_data => x_msg_data
617:
618: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
619: ROLLBACK TO LOCK_Offer_Back_PVT;
620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
621: -- Standard call to get message count and if count=1, get the message
622: FND_MSG_PUB.Count_And_Get (
623: p_encoded => FND_API.G_FALSE,
624: p_count => x_msg_count,
625: p_data => x_msg_data
631: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
632: THEN
633: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
634: END IF;
635: -- Standard call to get message count and if count=1, get the message
636: FND_MSG_PUB.Count_And_Get (
637: p_encoded => FND_API.G_FALSE,
638: p_count => x_msg_count,
639: p_data => x_msg_data
860: l_object_version_number NUMBER;
861: l_offer_back_create_rec OZF_Offer_Back_Create_PVT.offer_back_create_rec_type;
862:
863: BEGIN
864: -- Standard Start of API savepoint
865: SAVEPOINT VALIDATE_Offer_Back_;
866:
867: -- Standard call to check for call compatibility.
868: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
863: BEGIN
864: -- Standard Start of API savepoint
865: SAVEPOINT VALIDATE_Offer_Back_;
866:
867: -- Standard call to check for call compatibility.
868: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
869: p_api_version_number,
870: l_api_name,
871: G_PKG_NAME)
924:
925: -- Debug Message
926: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
927:
928: -- Standard call to get message count and if count is 1, get message info.
929: FND_MSG_PUB.Count_And_Get
930: (p_count => x_msg_count,
931: p_data => x_msg_data
932: );
938:
939: WHEN FND_API.G_EXC_ERROR THEN
940: ROLLBACK TO VALIDATE_Offer_Back_;
941: x_return_status := FND_API.G_RET_STS_ERROR;
942: -- Standard call to get message count and if count=1, get the message
943: FND_MSG_PUB.Count_And_Get (
944: p_encoded => FND_API.G_FALSE,
945: p_count => x_msg_count,
946: p_data => x_msg_data
948:
949: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
950: ROLLBACK TO VALIDATE_Offer_Back_;
951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
952: -- Standard call to get message count and if count=1, get the message
953: FND_MSG_PUB.Count_And_Get (
954: p_encoded => FND_API.G_FALSE,
955: p_count => x_msg_count,
956: p_data => x_msg_data
962: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
963: THEN
964: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
965: END IF;
966: -- Standard call to get message count and if count=1, get the message
967: FND_MSG_PUB.Count_And_Get (
968: p_encoded => FND_API.G_FALSE,
969: p_count => x_msg_count,
970: p_data => x_msg_data
997: -- x_return_status := FND_API.G_RET_STS_ERROR;
998:
999: -- Debug Message
1000: OZF_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1001: -- Standard call to get message count and if count is 1, get message info.
1002: FND_MSG_PUB.Count_And_Get
1003: (p_count => x_msg_count,
1004: p_data => x_msg_data
1005: );