[Home] [Help]
60: -- x_return_status OUT VARCHAR2
61: -- x_msg_count OUT NUMBER
62: -- x_msg_data OUT VARCHAR2
63: -- Version : Current version 1.0
64: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
65: -- and basic operation, developer must manually add parameters and business logic as necessary.
66: --
67: -- History
68: --
102: SELECT 1
103: FROM OZF_OFFER_QUALIFIERS
104: WHERE qualifier_id = l_id;
105: BEGIN
106: -- Standard Start of API savepoint
107: SAVEPOINT create_offr_qual_pvt;
108:
109: -- Standard call to check for call compatibility.
110: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
105: BEGIN
106: -- Standard Start of API savepoint
107: SAVEPOINT create_offr_qual_pvt;
108:
109: -- Standard call to check for call compatibility.
110: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
111: p_api_version_number,
112: l_api_name,
113: G_PKG_NAME)
235: --
236: -- End of API body
237: --
238:
239: -- Standard check for p_commit
240: IF FND_API.to_Boolean( p_commit )
241: THEN
242: COMMIT WORK;
243: END IF;
246: -- Debug Message
247: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
248:
249:
250: -- Standard call to get message count and if count is 1, get message info.
251: FND_MSG_PUB.Count_And_Get
252: (p_count => x_msg_count,
253: p_data => x_msg_data
254: );
260:
261: WHEN FND_API.G_EXC_ERROR THEN
262: ROLLBACK TO CREATE_Offr_Qual_PVT;
263: x_return_status := FND_API.G_RET_STS_ERROR;
264: -- Standard call to get message count and if count=1, get the message
265: FND_MSG_PUB.Count_And_Get (
266: p_encoded => FND_API.G_FALSE,
267: p_count => x_msg_count,
268: p_data => x_msg_data
270:
271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
272: ROLLBACK TO CREATE_Offr_Qual_PVT;
273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
274: -- Standard call to get message count and if count=1, get the message
275: FND_MSG_PUB.Count_And_Get (
276: p_encoded => FND_API.G_FALSE,
277: p_count => x_msg_count,
278: p_data => x_msg_data
284: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
285: THEN
286: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
287: END IF;
288: -- Standard call to get message count and if count=1, get the message
289: FND_MSG_PUB.Count_And_Get (
290: p_encoded => FND_API.G_FALSE,
291: p_count => x_msg_count,
292: p_data => x_msg_data
316: -- x_return_status OUT VARCHAR2
317: -- x_msg_count OUT NUMBER
318: -- x_msg_data OUT VARCHAR2
319: -- Version : Current version 1.0
320: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
321: -- and basic operation, developer must manually add parameters and business logic as necessary.
322: --
323: -- History
324: --
359: l_tar_ozf_offr_qual_rec ozf_offr_qual_rec_type := p_ozf_offr_qual_rec;
360: l_rowid ROWID;
361:
362: BEGIN
363: -- Standard Start of API savepoint
364: SAVEPOINT update_offr_qual_pvt;
365:
366: -- Standard call to check for call compatibility.
367: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
362: BEGIN
363: -- Standard Start of API savepoint
364: SAVEPOINT update_offr_qual_pvt;
365:
366: -- Standard call to check for call compatibility.
367: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
368: p_api_version_number,
369: l_api_name,
370: G_PKG_NAME)
483: --
484: -- End of API body.
485: --
486:
487: -- Standard check for p_commit
488: IF FND_API.to_Boolean( p_commit )
489: THEN
490: COMMIT WORK;
491: END IF;
494: -- Debug Message
495: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
496:
497:
498: -- Standard call to get message count and if count is 1, get message info.
499: FND_MSG_PUB.Count_And_Get
500: (p_count => x_msg_count,
501: p_data => x_msg_data
502: );
508:
509: WHEN FND_API.G_EXC_ERROR THEN
510: ROLLBACK TO UPDATE_Offr_Qual_PVT;
511: x_return_status := FND_API.G_RET_STS_ERROR;
512: -- Standard call to get message count and if count=1, get the message
513: FND_MSG_PUB.Count_And_Get (
514: p_encoded => FND_API.G_FALSE,
515: p_count => x_msg_count,
516: p_data => x_msg_data
518:
519: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
520: ROLLBACK TO UPDATE_Offr_Qual_PVT;
521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
522: -- Standard call to get message count and if count=1, get the message
523: FND_MSG_PUB.Count_And_Get (
524: p_encoded => FND_API.G_FALSE,
525: p_count => x_msg_count,
526: p_data => x_msg_data
532: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
533: THEN
534: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
535: END IF;
536: -- Standard call to get message count and if count=1, get the message
537: FND_MSG_PUB.Count_And_Get (
538: p_encoded => FND_API.G_FALSE,
539: p_count => x_msg_count,
540: p_data => x_msg_data
565: -- x_return_status OUT VARCHAR2
566: -- x_msg_count OUT NUMBER
567: -- x_msg_data OUT VARCHAR2
568: -- Version : Current version 1.0
569: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
570: -- and basic operation, developer must manually add parameters and business logic as necessary.
571: --
572: -- History
573: --
593: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
594: l_object_version_number NUMBER;
595:
596: BEGIN
597: -- Standard Start of API savepoint
598: SAVEPOINT delete_offr_qual_pvt;
599:
600: -- Standard call to check for call compatibility.
601: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
596: BEGIN
597: -- Standard Start of API savepoint
598: SAVEPOINT delete_offr_qual_pvt;
599:
600: -- Standard call to check for call compatibility.
601: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
602: p_api_version_number,
603: l_api_name,
604: G_PKG_NAME)
636: --
637: -- End of API body
638: --
639:
640: -- Standard check for p_commit
641: IF FND_API.to_Boolean( p_commit )
642: THEN
643: COMMIT WORK;
644: END IF;
647: -- Debug Message
648: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
649:
650:
651: -- Standard call to get message count and if count is 1, get message info.
652: FND_MSG_PUB.Count_And_Get
653: (p_count => x_msg_count,
654: p_data => x_msg_data
655: );
661:
662: WHEN FND_API.G_EXC_ERROR THEN
663: ROLLBACK TO DELETE_Offr_Qual_PVT;
664: x_return_status := FND_API.G_RET_STS_ERROR;
665: -- Standard call to get message count and if count=1, get the message
666: FND_MSG_PUB.Count_And_Get (
667: p_encoded => FND_API.G_FALSE,
668: p_count => x_msg_count,
669: p_data => x_msg_data
671:
672: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
673: ROLLBACK TO DELETE_Offr_Qual_PVT;
674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
675: -- Standard call to get message count and if count=1, get the message
676: FND_MSG_PUB.Count_And_Get (
677: p_encoded => FND_API.G_FALSE,
678: p_count => x_msg_count,
679: p_data => x_msg_data
685: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
686: THEN
687: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
688: END IF;
689: -- Standard call to get message count and if count=1, get the message
690: FND_MSG_PUB.Count_And_Get (
691: p_encoded => FND_API.G_FALSE,
692: p_count => x_msg_count,
693: p_data => x_msg_data
719: -- x_return_status OUT VARCHAR2
720: -- x_msg_count OUT NUMBER
721: -- x_msg_data OUT VARCHAR2
722: -- Version : Current version 1.0
723: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
724: -- and basic operation, developer must manually add parameters and business logic as necessary.
725: --
726: -- History
727: --
761: END IF;
762:
763:
764:
765: -- Standard call to check for call compatibility.
766: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
767: p_api_version_number,
768: l_api_name,
769: G_PKG_NAME)
795:
796: WHEN FND_API.G_EXC_ERROR THEN
797: ROLLBACK TO LOCK_Offr_Qual_PVT;
798: x_return_status := FND_API.G_RET_STS_ERROR;
799: -- Standard call to get message count and if count=1, get the message
800: FND_MSG_PUB.Count_And_Get (
801: p_encoded => FND_API.G_FALSE,
802: p_count => x_msg_count,
803: p_data => x_msg_data
805:
806: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
807: ROLLBACK TO LOCK_Offr_Qual_PVT;
808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
809: -- Standard call to get message count and if count=1, get the message
810: FND_MSG_PUB.Count_And_Get (
811: p_encoded => FND_API.G_FALSE,
812: p_count => x_msg_count,
813: p_data => x_msg_data
819: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
820: THEN
821: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
822: END IF;
823: -- Standard call to get message count and if count=1, get the message
824: FND_MSG_PUB.Count_And_Get (
825: p_encoded => FND_API.G_FALSE,
826: p_count => x_msg_count,
827: p_data => x_msg_data
1245: l_object_version_number NUMBER;
1246: l_ozf_offr_qual_rec ozf_offr_qual_rec_type;
1247:
1248: BEGIN
1249: -- Standard Start of API savepoint
1250: SAVEPOINT validate_offr_qual_Pvt;
1251:
1252:
1253: -- Debug Message
1252:
1253: -- Debug Message
1254: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1255:
1256: -- Standard call to check for call compatibility.
1257: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1258: p_api_version_number,
1259: l_api_name,
1260: G_PKG_NAME)
1310: -- Debug Message
1311: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1312:
1313:
1314: -- Standard call to get message count and if count is 1, get message info.
1315: FND_MSG_PUB.Count_And_Get
1316: (p_count => x_msg_count,
1317: p_data => x_msg_data
1318: );
1324:
1325: WHEN FND_API.G_EXC_ERROR THEN
1326: ROLLBACK TO validate_offr_qual_Pvt;
1327: x_return_status := FND_API.G_RET_STS_ERROR;
1328: -- Standard call to get message count and if count=1, get the message
1329: FND_MSG_PUB.Count_And_Get (
1330: p_encoded => FND_API.G_FALSE,
1331: p_count => x_msg_count,
1332: p_data => x_msg_data
1334:
1335: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1336: ROLLBACK TO validate_offr_qual_Pvt;
1337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1338: -- Standard call to get message count and if count=1, get the message
1339: FND_MSG_PUB.Count_And_Get (
1340: p_encoded => FND_API.G_FALSE,
1341: p_count => x_msg_count,
1342: p_data => x_msg_data
1348: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1349: THEN
1350: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1351: END IF;
1352: -- Standard call to get message count and if count=1, get the message
1353: FND_MSG_PUB.Count_And_Get (
1354: p_encoded => FND_API.G_FALSE,
1355: p_count => x_msg_count,
1356: p_data => x_msg_data
1385: -- x_return_status := FND_API.G_RET_STS_ERROR;
1386:
1387: -- Debug Message
1388: OZF_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1389: -- Standard call to get message count and if count is 1, get message info.
1390: FND_MSG_PUB.Count_And_Get
1391: (p_count => x_msg_count,
1392: p_data => x_msg_data
1393: );