[Home] [Help]
199: WHERE EXISTS (SELECT 1 FROM OZF_THRESHOLDS_ALL_B
200: WHERE THRESHOLD_ID = l_id);
201:
202: BEGIN
203: -- Standard Start of API savepoint
204: SAVEPOINT CREATE_Threshold_PVT;
205:
206: -- Standard call to check for call compatibility.
207: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
202: BEGIN
203: -- Standard Start of API savepoint
204: SAVEPOINT CREATE_Threshold_PVT;
205:
206: -- Standard call to check for call compatibility.
207: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
208: p_api_version_number,
209: l_api_name,
210: G_PKG_NAME)
362: --
363: -- End of API body
364: --
365:
366: -- Standard check for p_commit
367: IF FND_API.to_Boolean( p_commit )
368: THEN
369: COMMIT WORK;
370: END IF;
374: IF G_DEBUG THEN
375: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end' || x_threshold_id);
376: END IF;
377:
378: -- Standard call to get message count and if count is 1, get message info.
379: FND_MSG_PUB.Count_And_Get
380: (p_count => x_msg_count,
381: p_data => x_msg_data
382: );
388:
389: WHEN FND_API.G_EXC_ERROR THEN
390: ROLLBACK TO CREATE_Threshold_PVT;
391: x_return_status := FND_API.G_RET_STS_ERROR;
392: -- Standard call to get message count and if count=1, get the message
393: FND_MSG_PUB.Count_And_Get (
394: p_encoded => FND_API.G_FALSE,
395: p_count => x_msg_count,
396: p_data => x_msg_data
398:
399: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
400: ROLLBACK TO CREATE_Threshold_PVT;
401: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
402: -- Standard call to get message count and if count=1, get the message
403: FND_MSG_PUB.Count_And_Get (
404: p_encoded => FND_API.G_FALSE,
405: p_count => x_msg_count,
406: p_data => x_msg_data
412: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
413: THEN
414: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
415: END IF;
416: -- Standard call to get message count and if count=1, get the message
417: FND_MSG_PUB.Count_And_Get (
418: p_encoded => FND_API.G_FALSE,
419: p_count => x_msg_count,
420: p_data => x_msg_data
455: l_threshold_rec OZF_Fundthreshold_PVT.threshold_rec_type;
456: l_rowid ROWID;
457:
458: BEGIN
459: -- Standard Start of API savepoint
460: SAVEPOINT UPDATE_Threshold_PVT;
461:
462: -- Standard call to check for call compatibility.
463: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
458: BEGIN
459: -- Standard Start of API savepoint
460: SAVEPOINT UPDATE_Threshold_PVT;
461:
462: -- Standard call to check for call compatibility.
463: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
464: p_api_version_number,
465: l_api_name,
466: G_PKG_NAME)
624: --
625: -- End of API body.
626: --
627:
628: -- Standard check for p_commit
629: IF FND_API.to_Boolean( p_commit )
630: THEN
631: COMMIT WORK;
632: END IF;
637: IF G_DEBUG THEN
638: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
639: END IF;
640:
641: -- Standard call to get message count and if count is 1, get message info.
642: FND_MSG_PUB.Count_And_Get
643: (p_count => x_msg_count,
644: p_data => x_msg_data
645: );
651:
652: WHEN FND_API.G_EXC_ERROR THEN
653: ROLLBACK TO UPDATE_Threshold_PVT;
654: x_return_status := FND_API.G_RET_STS_ERROR;
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
661:
662: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
663: ROLLBACK TO UPDATE_Threshold_PVT;
664: x_return_status := FND_API.G_RET_STS_UNEXP_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
675: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
676: THEN
677: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
678: END IF;
679: -- Standard call to get message count and if count=1, get the message
680: FND_MSG_PUB.Count_And_Get (
681: p_encoded => FND_API.G_FALSE,
682: p_count => x_msg_count,
683: p_data => x_msg_data
702: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
703: l_object_version_number NUMBER;
704:
705: BEGIN
706: -- Standard Start of API savepoint
707: SAVEPOINT DELETE_Threshold_PVT;
708:
709: -- Standard call to check for call compatibility.
710: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
705: BEGIN
706: -- Standard Start of API savepoint
707: SAVEPOINT DELETE_Threshold_PVT;
708:
709: -- Standard call to check for call compatibility.
710: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
711: p_api_version_number,
712: l_api_name,
713: G_PKG_NAME)
744: --
745: -- End of API body
746: --
747:
748: -- Standard check for p_commit
749: IF FND_API.to_Boolean( p_commit )
750: THEN
751: COMMIT WORK;
752: END IF;
756: IF G_DEBUG THEN
757: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
758: END IF;
759:
760: -- Standard call to get message count and if count is 1, get message info.
761: FND_MSG_PUB.Count_And_Get
762: (p_count => x_msg_count,
763: p_data => x_msg_data
764: );
770:
771: WHEN FND_API.G_EXC_ERROR THEN
772: ROLLBACK TO DELETE_Threshold_PVT;
773: x_return_status := FND_API.G_RET_STS_ERROR;
774: -- Standard call to get message count and if count=1, get the message
775: FND_MSG_PUB.Count_And_Get (
776: p_encoded => FND_API.G_FALSE,
777: p_count => x_msg_count,
778: p_data => x_msg_data
780:
781: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
782: ROLLBACK TO DELETE_Threshold_PVT;
783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
784: -- Standard call to get message count and if count=1, get the message
785: FND_MSG_PUB.Count_And_Get (
786: p_encoded => FND_API.G_FALSE,
787: p_count => x_msg_count,
788: p_data => x_msg_data
794: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
795: THEN
796: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
797: END IF;
798: -- Standard call to get message count and if count=1, get the message
799: FND_MSG_PUB.Count_And_Get (
800: p_encoded => FND_API.G_FALSE,
801: p_count => x_msg_count,
802: p_data => x_msg_data
843: THEN
844: FND_MSG_PUB.initialize;
845: END IF;
846:
847: -- Standard call to check for call compatibility.
848: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
849: p_api_version_number,
850: l_api_name,
851: G_PKG_NAME)
894:
895: WHEN FND_API.G_EXC_ERROR THEN
896: ROLLBACK TO LOCK_Threshold_PVT;
897: x_return_status := FND_API.G_RET_STS_ERROR;
898: -- Standard call to get message count and if count=1, get the message
899: FND_MSG_PUB.Count_And_Get (
900: p_encoded => FND_API.G_FALSE,
901: p_count => x_msg_count,
902: p_data => x_msg_data
904:
905: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
906: ROLLBACK TO LOCK_Threshold_PVT;
907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
908: -- Standard call to get message count and if count=1, get the message
909: FND_MSG_PUB.Count_And_Get (
910: p_encoded => FND_API.G_FALSE,
911: p_count => x_msg_count,
912: p_data => x_msg_data
918: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
919: THEN
920: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
921: END IF;
922: -- Standard call to get message count and if count=1, get the message
923: FND_MSG_PUB.Count_And_Get (
924: p_encoded => FND_API.G_FALSE,
925: p_count => x_msg_count,
926: p_data => x_msg_data
1472: l_object_version_number NUMBER;
1473: l_threshold_rec OZF_Fundthreshold_PVT.threshold_rec_type;
1474:
1475: BEGIN
1476: -- Standard Start of API savepoint
1477: SAVEPOINT VALIDATE_Threshold_;
1478:
1479: -- Standard call to check for call compatibility.
1480: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1475: BEGIN
1476: -- Standard Start of API savepoint
1477: SAVEPOINT VALIDATE_Threshold_;
1478:
1479: -- Standard call to check for call compatibility.
1480: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1481: p_api_version_number,
1482: l_api_name,
1483: G_PKG_NAME)
1535: IF G_DEBUG THEN
1536: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1537: END IF;
1538:
1539: -- Standard call to get message count and if count is 1, get message info.
1540: FND_MSG_PUB.Count_And_Get
1541: (p_count => x_msg_count,
1542: p_data => x_msg_data
1543: );
1549:
1550: WHEN FND_API.G_EXC_ERROR THEN
1551: ROLLBACK TO VALIDATE_Threshold_;
1552: x_return_status := FND_API.G_RET_STS_ERROR;
1553: -- Standard call to get message count and if count=1, get the message
1554: FND_MSG_PUB.Count_And_Get (
1555: p_encoded => FND_API.G_FALSE,
1556: p_count => x_msg_count,
1557: p_data => x_msg_data
1559:
1560: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1561: ROLLBACK TO VALIDATE_Threshold_;
1562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1563: -- Standard call to get message count and if count=1, get the message
1564: FND_MSG_PUB.Count_And_Get (
1565: p_encoded => FND_API.G_FALSE,
1566: p_count => x_msg_count,
1567: p_data => x_msg_data
1573: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1574: THEN
1575: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1576: END IF;
1577: -- Standard call to get message count and if count=1, get the message
1578: FND_MSG_PUB.Count_And_Get (
1579: p_encoded => FND_API.G_FALSE,
1580: p_count => x_msg_count,
1581: p_data => x_msg_data
1627: -- Debug Message
1628: IF G_DEBUG THEN
1629: OZF_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1630: END IF;
1631: -- Standard call to get message count and if count is 1, get message info.
1632: FND_MSG_PUB.Count_And_Get
1633: (p_count => x_msg_count,
1634: p_data => x_msg_data
1635: );