154: WHERE EXISTS (SELECT 1 FROM OZF_THRESHOLD_RULES_ALL
155: WHERE THRESHOLD_RULE_ID = l_id);
156:
157: BEGIN
158: -- Standard Start of API savepoint
159: SAVEPOINT CREATE_Threshold_Rule_PVT;
160:
161: -- Standard call to check for call compatibility.
162: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
157: BEGIN
158: -- Standard Start of API savepoint
159: SAVEPOINT CREATE_Threshold_Rule_PVT;
160:
161: -- Standard call to check for call compatibility.
162: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
163: p_api_version_number,
164: l_api_name,
165: G_PKG_NAME)
338: --
339: -- End of API body
340: --
341:
342: -- Standard check for p_commit
343: IF FND_API.to_Boolean( p_commit )
344: THEN
345: COMMIT WORK;
346: END IF;
351: IF G_DEBUG THEN
352: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
353: END IF;
354:
355: -- Standard call to get message count and if count is 1, get message info.
356: FND_MSG_PUB.Count_And_Get
357: (p_count => x_msg_count,
358: p_data => x_msg_data
359: );
365:
366: WHEN FND_API.G_EXC_ERROR THEN
367: ROLLBACK TO CREATE_Threshold_Rule_PVT;
368: x_return_status := FND_API.G_RET_STS_ERROR;
369: -- Standard call to get message count and if count=1, get the message
370: FND_MSG_PUB.Count_And_Get (
371: p_encoded => FND_API.G_FALSE,
372: p_count => x_msg_count,
373: p_data => x_msg_data
375:
376: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
377: ROLLBACK TO CREATE_Threshold_Rule_PVT;
378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
379: -- Standard call to get message count and if count=1, get the message
380: FND_MSG_PUB.Count_And_Get (
381: p_encoded => FND_API.G_FALSE,
382: p_count => x_msg_count,
383: p_data => x_msg_data
389: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
390: THEN
391: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
392: END IF;
393: -- Standard call to get message count and if count=1, get the message
394: FND_MSG_PUB.Count_And_Get (
395: p_encoded => FND_API.G_FALSE,
396: p_count => x_msg_count,
397: p_data => x_msg_data
434: l_converted_days NUMBER;
435: l_return_status VARCHAR2(30);
436:
437: BEGIN
438: -- Standard Start of API savepoint
439: SAVEPOINT UPDATE_Threshold_Rule_PVT;
440:
441: -- Standard call to check for call compatibility.
442: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
437: BEGIN
438: -- Standard Start of API savepoint
439: SAVEPOINT UPDATE_Threshold_Rule_PVT;
440:
441: -- Standard call to check for call compatibility.
442: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
443: p_api_version_number,
444: l_api_name,
445: G_PKG_NAME)
612: --
613: -- End of API body.
614: --
615:
616: -- Standard check for p_commit
617: IF FND_API.to_Boolean( p_commit )
618: THEN
619: COMMIT WORK;
620: END IF;
625: IF G_DEBUG THEN
626: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
627: END IF;
628:
629: -- Standard call to get message count and if count is 1, get message info.
630: FND_MSG_PUB.Count_And_Get
631: (p_count => x_msg_count,
632: p_data => x_msg_data
633: );
639:
640: WHEN FND_API.G_EXC_ERROR THEN
641: ROLLBACK TO UPDATE_Threshold_Rule_PVT;
642: x_return_status := FND_API.G_RET_STS_ERROR;
643: -- Standard call to get message count and if count=1, get the message
644: FND_MSG_PUB.Count_And_Get (
645: p_encoded => FND_API.G_FALSE,
646: p_count => x_msg_count,
647: p_data => x_msg_data
649:
650: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
651: ROLLBACK TO UPDATE_Threshold_Rule_PVT;
652: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
653: -- Standard call to get message count and if count=1, get the message
654: FND_MSG_PUB.Count_And_Get (
655: p_encoded => FND_API.G_FALSE,
656: p_count => x_msg_count,
657: p_data => x_msg_data
663: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
664: THEN
665: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
666: END IF;
667: -- Standard call to get message count and if count=1, get the message
668: FND_MSG_PUB.Count_And_Get (
669: p_encoded => FND_API.G_FALSE,
670: p_count => x_msg_count,
671: p_data => x_msg_data
690: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
691: l_object_version_number NUMBER;
692:
693: BEGIN
694: -- Standard Start of API savepoint
695: SAVEPOINT DELETE_Threshold_Rule_PVT;
696:
697: -- Standard call to check for call compatibility.
698: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
693: BEGIN
694: -- Standard Start of API savepoint
695: SAVEPOINT DELETE_Threshold_Rule_PVT;
696:
697: -- Standard call to check for call compatibility.
698: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
699: p_api_version_number,
700: l_api_name,
701: G_PKG_NAME)
732: --
733: -- End of API body
734: --
735:
736: -- Standard check for p_commit
737: IF FND_API.to_Boolean( p_commit )
738: THEN
739: COMMIT WORK;
740: END IF;
744: IF G_DEBUG THEN
745: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
746: END IF;
747:
748: -- Standard call to get message count and if count is 1, get message info.
749: FND_MSG_PUB.Count_And_Get
750: (p_count => x_msg_count,
751: p_data => x_msg_data
752: );
758:
759: WHEN FND_API.G_EXC_ERROR THEN
760: ROLLBACK TO DELETE_Threshold_Rule_PVT;
761: x_return_status := FND_API.G_RET_STS_ERROR;
762: -- Standard call to get message count and if count=1, get the message
763: FND_MSG_PUB.Count_And_Get (
764: p_encoded => FND_API.G_FALSE,
765: p_count => x_msg_count,
766: p_data => x_msg_data
768:
769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
770: ROLLBACK TO DELETE_Threshold_Rule_PVT;
771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
772: -- Standard call to get message count and if count=1, get the message
773: FND_MSG_PUB.Count_And_Get (
774: p_encoded => FND_API.G_FALSE,
775: p_count => x_msg_count,
776: p_data => x_msg_data
782: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
783: THEN
784: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
785: END IF;
786: -- Standard call to get message count and if count=1, get the message
787: FND_MSG_PUB.Count_And_Get (
788: p_encoded => FND_API.G_FALSE,
789: p_count => x_msg_count,
790: p_data => x_msg_data
831: THEN
832: FND_MSG_PUB.initialize;
833: END IF;
834:
835: -- Standard call to check for call compatibility.
836: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
837: p_api_version_number,
838: l_api_name,
839: G_PKG_NAME)
882:
883: WHEN FND_API.G_EXC_ERROR THEN
884: ROLLBACK TO LOCK_Threshold_Rule_PVT;
885: x_return_status := FND_API.G_RET_STS_ERROR;
886: -- Standard call to get message count and if count=1, get the message
887: FND_MSG_PUB.Count_And_Get (
888: p_encoded => FND_API.G_FALSE,
889: p_count => x_msg_count,
890: p_data => x_msg_data
892:
893: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
894: ROLLBACK TO LOCK_Threshold_Rule_PVT;
895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
896: -- Standard call to get message count and if count=1, get the message
897: FND_MSG_PUB.Count_And_Get (
898: p_encoded => FND_API.G_FALSE,
899: p_count => x_msg_count,
900: p_data => x_msg_data
906: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
907: THEN
908: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
909: END IF;
910: -- Standard call to get message count and if count=1, get the message
911: FND_MSG_PUB.Count_And_Get (
912: p_encoded => FND_API.G_FALSE,
913: p_count => x_msg_count,
914: p_data => x_msg_data
1693: l_object_version_number NUMBER;
1694: l_threshold_rule_rec OZF_Threshold_Rule_PVT.threshold_rule_rec_type;
1695:
1696: BEGIN
1697: -- Standard Start of API savepoint
1698: SAVEPOINT VALIDATE_Threshold_Rule_;
1699:
1700: -- Standard call to check for call compatibility.
1701: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1696: BEGIN
1697: -- Standard Start of API savepoint
1698: SAVEPOINT VALIDATE_Threshold_Rule_;
1699:
1700: -- Standard call to check for call compatibility.
1701: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1702: p_api_version_number,
1703: l_api_name,
1704: G_PKG_NAME)
1746: IF G_DEBUG THEN
1747: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1748: END IF;
1749:
1750: -- Standard call to get message count and if count is 1, get message info.
1751: FND_MSG_PUB.Count_And_Get
1752: (p_count => x_msg_count,
1753: p_data => x_msg_data
1754: );
1760:
1761: WHEN FND_API.G_EXC_ERROR THEN
1762: ROLLBACK TO VALIDATE_Threshold_Rule_;
1763: x_return_status := FND_API.G_RET_STS_ERROR;
1764: -- Standard call to get message count and if count=1, get the message
1765: FND_MSG_PUB.Count_And_Get (
1766: p_encoded => FND_API.G_FALSE,
1767: p_count => x_msg_count,
1768: p_data => x_msg_data
1770:
1771: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1772: ROLLBACK TO VALIDATE_Threshold_Rule_;
1773: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1774: -- Standard call to get message count and if count=1, get the message
1775: FND_MSG_PUB.Count_And_Get (
1776: p_encoded => FND_API.G_FALSE,
1777: p_count => x_msg_count,
1778: p_data => x_msg_data
1784: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1785: THEN
1786: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1787: END IF;
1788: -- Standard call to get message count and if count=1, get the message
1789: FND_MSG_PUB.Count_And_Get (
1790: p_encoded => FND_API.G_FALSE,
1791: p_count => x_msg_count,
1792: p_data => x_msg_data
1839: -- Debug Message
1840: IF G_DEBUG THEN
1841: OZF_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1842: END IF;
1843: -- Standard call to get message count and if count is 1, get message info.
1844: FND_MSG_PUB.Count_And_Get
1845: (p_count => x_msg_count,
1846: p_data => x_msg_data
1847: );