[Home] [Help]
71: -- x_return_status OUT VARCHAR2
72: -- x_msg_count OUT NUMBER
73: -- x_msg_data OUT VARCHAR2
74: -- Version : Current version 1.0
75: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
76: -- and basic operation, developer must manually add parameters and business logic as necessary.
77: --
78: -- History
79: --
112: SELECT 1
113: FROM OZF_VOLUME_OFFER_TIERS
114: WHERE volume_offer_tiers_id = l_id;
115: BEGIN
116: -- Standard Start of API savepoint
117: SAVEPOINT create_vol_offr_pvt;
118:
119: -- Standard call to check for call compatibility.
120: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
115: BEGIN
116: -- Standard Start of API savepoint
117: SAVEPOINT create_vol_offr_pvt;
118:
119: -- Standard call to check for call compatibility.
120: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
121: p_api_version_number,
122: l_api_name,
123: G_PKG_NAME)
218: --
219: -- End of API body
220: --
221:
222: -- Standard check for p_commit
223: IF FND_API.to_Boolean( p_commit )
224: THEN
225: COMMIT WORK;
226: END IF;
229: -- Debug Message
230: debug_message('Private API: ' || l_api_name || 'end');
231:
232:
233: -- Standard call to get message count and if count is 1, get message info.
234: FND_MSG_PUB.Count_And_Get
235: (p_count => x_msg_count,
236: p_data => x_msg_data
237: );
243:
244: WHEN FND_API.G_EXC_ERROR THEN
245: ROLLBACK TO CREATE_Vol_Offr_PVT;
246: x_return_status := FND_API.G_RET_STS_ERROR;
247: -- Standard call to get message count and if count=1, get the message
248: FND_MSG_PUB.Count_And_Get (
249: p_encoded => FND_API.G_FALSE,
250: p_count => x_msg_count,
251: p_data => x_msg_data
253:
254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
255: ROLLBACK TO CREATE_Vol_Offr_PVT;
256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
257: -- Standard call to get message count and if count=1, get the message
258: FND_MSG_PUB.Count_And_Get (
259: p_encoded => FND_API.G_FALSE,
260: p_count => x_msg_count,
261: p_data => x_msg_data
267: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
268: THEN
269: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
270: END IF;
271: -- Standard call to get message count and if count=1, get the message
272: FND_MSG_PUB.Count_And_Get (
273: p_encoded => FND_API.G_FALSE,
274: p_count => x_msg_count,
275: p_data => x_msg_data
299: -- x_return_status OUT VARCHAR2
300: -- x_msg_count OUT NUMBER
301: -- x_msg_data OUT VARCHAR2
302: -- Version : Current version 1.0
303: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
304: -- and basic operation, developer must manually add parameters and business logic as necessary.
305: --
306: -- History
307: --
343: l_tar_vol_offr_tier_rec vol_offr_tier_rec_type := P_vol_offr_tier_rec;
344: l_rowid ROWID;
345:
346: BEGIN
347: -- Standard Start of API savepoint
348: SAVEPOINT update_vol_offr_pvt;
349:
350: -- Standard call to check for call compatibility.
351: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
346: BEGIN
347: -- Standard Start of API savepoint
348: SAVEPOINT update_vol_offr_pvt;
349:
350: -- Standard call to check for call compatibility.
351: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
352: p_api_version_number,
353: l_api_name,
354: G_PKG_NAME)
449: --
450: -- End of API body.
451: --
452:
453: -- Standard check for p_commit
454: IF FND_API.to_Boolean( p_commit )
455: THEN
456: COMMIT WORK;
457: END IF;
460: -- Debug Message
461: debug_message('Private API: ' || l_api_name || 'end');
462:
463:
464: -- Standard call to get message count and if count is 1, get message info.
465: FND_MSG_PUB.Count_And_Get
466: (p_count => x_msg_count,
467: p_data => x_msg_data
468: );
474:
475: WHEN FND_API.G_EXC_ERROR THEN
476: ROLLBACK TO UPDATE_Vol_Offr_PVT;
477: x_return_status := FND_API.G_RET_STS_ERROR;
478: -- Standard call to get message count and if count=1, get the message
479: FND_MSG_PUB.Count_And_Get (
480: p_encoded => FND_API.G_FALSE,
481: p_count => x_msg_count,
482: p_data => x_msg_data
484:
485: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
486: ROLLBACK TO UPDATE_Vol_Offr_PVT;
487: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
488: -- Standard call to get message count and if count=1, get the message
489: FND_MSG_PUB.Count_And_Get (
490: p_encoded => FND_API.G_FALSE,
491: p_count => x_msg_count,
492: p_data => x_msg_data
498: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
499: THEN
500: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
501: END IF;
502: -- Standard call to get message count and if count=1, get the message
503: FND_MSG_PUB.Count_And_Get (
504: p_encoded => FND_API.G_FALSE,
505: p_count => x_msg_count,
506: p_data => x_msg_data
531: -- x_return_status OUT VARCHAR2
532: -- x_msg_count OUT NUMBER
533: -- x_msg_data OUT VARCHAR2
534: -- Version : Current version 1.0
535: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
536: -- and basic operation, developer must manually add parameters and business logic as necessary.
537: --
538: -- History
539: --
559: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
560: l_object_version_number NUMBER;
561:
562: BEGIN
563: -- Standard Start of API savepoint
564: SAVEPOINT delete_vol_offr_pvt;
565:
566: -- Standard call to check for call compatibility.
567: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
562: BEGIN
563: -- Standard Start of API savepoint
564: SAVEPOINT delete_vol_offr_pvt;
565:
566: -- Standard call to check for call compatibility.
567: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
568: p_api_version_number,
569: l_api_name,
570: G_PKG_NAME)
602: --
603: -- End of API body
604: --
605:
606: -- Standard check for p_commit
607: IF FND_API.to_Boolean( p_commit )
608: THEN
609: COMMIT WORK;
610: END IF;
613: -- Debug Message
614: debug_message('Private API: ' || l_api_name || 'end');
615:
616:
617: -- Standard call to get message count and if count is 1, get message info.
618: FND_MSG_PUB.Count_And_Get
619: (p_count => x_msg_count,
620: p_data => x_msg_data
621: );
627:
628: WHEN FND_API.G_EXC_ERROR THEN
629: ROLLBACK TO DELETE_Vol_Offr_PVT;
630: x_return_status := FND_API.G_RET_STS_ERROR;
631: -- Standard call to get message count and if count=1, get the message
632: FND_MSG_PUB.Count_And_Get (
633: p_encoded => FND_API.G_FALSE,
634: p_count => x_msg_count,
635: p_data => x_msg_data
637:
638: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
639: ROLLBACK TO DELETE_Vol_Offr_PVT;
640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
641: -- Standard call to get message count and if count=1, get the message
642: FND_MSG_PUB.Count_And_Get (
643: p_encoded => FND_API.G_FALSE,
644: p_count => x_msg_count,
645: p_data => x_msg_data
651: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
652: THEN
653: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
654: END IF;
655: -- Standard call to get message count and if count=1, get the message
656: FND_MSG_PUB.Count_And_Get (
657: p_encoded => FND_API.G_FALSE,
658: p_count => x_msg_count,
659: p_data => x_msg_data
685: -- x_return_status OUT VARCHAR2
686: -- x_msg_count OUT NUMBER
687: -- x_msg_data OUT VARCHAR2
688: -- Version : Current version 1.0
689: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
690: -- and basic operation, developer must manually add parameters and business logic as necessary.
691: --
692: -- History
693: --
727: END IF;
728:
729:
730:
731: -- Standard call to check for call compatibility.
732: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
733: p_api_version_number,
734: l_api_name,
735: G_PKG_NAME)
761:
762: WHEN FND_API.G_EXC_ERROR THEN
763: ROLLBACK TO LOCK_Vol_Offr_PVT;
764: x_return_status := FND_API.G_RET_STS_ERROR;
765: -- Standard call to get message count and if count=1, get the message
766: FND_MSG_PUB.Count_And_Get (
767: p_encoded => FND_API.G_FALSE,
768: p_count => x_msg_count,
769: p_data => x_msg_data
771:
772: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
773: ROLLBACK TO LOCK_Vol_Offr_PVT;
774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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
785: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
786: THEN
787: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
788: END IF;
789: -- Standard call to get message count and if count=1, get the message
790: FND_MSG_PUB.Count_And_Get (
791: p_encoded => FND_API.G_FALSE,
792: p_count => x_msg_count,
793: p_data => x_msg_data
1171: l_object_version_number NUMBER;
1172: l_vol_offr_tier_rec vol_offr_tier_rec_type;
1173:
1174: BEGIN
1175: -- Standard Start of API savepoint
1176: SAVEPOINT validate_vol_offr_;
1177:
1178: -- Standard call to check for call compatibility.
1179: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1174: BEGIN
1175: -- Standard Start of API savepoint
1176: SAVEPOINT validate_vol_offr_;
1177:
1178: -- Standard call to check for call compatibility.
1179: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1180: p_api_version_number,
1181: l_api_name,
1182: G_PKG_NAME)
1246: -- Debug Message
1247: debug_message('Private API: ' || l_api_name || ' end');
1248:
1249:
1250: -- Standard call to get message count and if count is 1, get message info.
1251: FND_MSG_PUB.Count_And_Get
1252: (p_count => x_msg_count,
1253: p_data => x_msg_data
1254: );
1260:
1261: WHEN FND_API.G_EXC_ERROR THEN
1262: ROLLBACK TO VALIDATE_Vol_Offr_;
1263: x_return_status := FND_API.G_RET_STS_ERROR;
1264: -- Standard call to get message count and if count=1, get the message
1265: FND_MSG_PUB.Count_And_Get (
1266: p_encoded => FND_API.G_FALSE,
1267: p_count => x_msg_count,
1268: p_data => x_msg_data
1270:
1271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1272: ROLLBACK TO VALIDATE_Vol_Offr_;
1273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1274: -- Standard call to get message count and if count=1, get the message
1275: FND_MSG_PUB.Count_And_Get (
1276: p_encoded => FND_API.G_FALSE,
1277: p_count => x_msg_count,
1278: p_data => x_msg_data
1284: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1285: THEN
1286: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1287: END IF;
1288: -- Standard call to get message count and if count=1, get the message
1289: FND_MSG_PUB.Count_And_Get (
1290: p_encoded => FND_API.G_FALSE,
1291: p_count => x_msg_count,
1292: p_data => x_msg_data
1337: END IF;
1338: END LOOP;
1339: -- Debug Message
1340: debug_message('Private API: Validate_dm_model_rec');
1341: -- Standard call to get message count and if count is 1, get message info.
1342: FND_MSG_PUB.Count_And_Get
1343: (p_count => x_msg_count,
1344: p_data => x_msg_data
1345: );