213: l_object_version_number ben_pl_f.object_version_number%TYPE;
214: --
215: begin
216: --
217: hr_utility.set_location('Entering:'|| l_proc, 10);
218: --
219: -- Issue a savepoint if operating in validation only mode
220: --
221: savepoint create_Plan;
219: -- Issue a savepoint if operating in validation only mode
220: --
221: savepoint create_Plan;
222: --
223: hr_utility.set_location(l_proc, 20);
224: --
225: -- Process Logic
226: --
227: begin
830: -- End of API User Hook for the after hook of create_Plan
831: --
832: end;
833: --
834: hr_utility.set_location(l_proc, 60);
835: --
836: -- When in validation only mode raise the Validate_Enabled exception
837: --
838: if p_validate then
845: p_effective_start_date := l_effective_start_date;
846: p_effective_end_date := l_effective_end_date;
847: p_object_version_number := l_object_version_number;
848: --
849: hr_utility.set_location(' Leaving:'||l_proc, 70);
850: --
851: exception
852: --
853: when hr_api.validate_enabled then
864: p_pl_id := null;
865: p_effective_start_date := null;
866: p_effective_end_date := null;
867: p_object_version_number := null;
868: hr_utility.set_location(' Leaving:'||l_proc, 80);
869: --
870: when others then
871: --
872: -- A validation or unexpected error has occured
1087: l_effective_end_date ben_pl_f.effective_end_date%TYPE;
1088: --
1089: begin
1090: --
1091: hr_utility.set_location('Entering:'|| l_proc, 10);
1092: --
1093: -- Issue a savepoint if operating in validation only mode
1094: --
1095: savepoint update_Plan;
1093: -- Issue a savepoint if operating in validation only mode
1094: --
1095: savepoint update_Plan;
1096: --
1097: hr_utility.set_location(l_proc, 20);
1098: --
1099: -- Process Logic
1100: --
1101: l_object_version_number := p_object_version_number;
1711: -- End of API User Hook for the after hook of update_Plan
1712: --
1713: end;
1714: --
1715: hr_utility.set_location(l_proc, 60);
1716: --
1717: -- When in validation only mode raise the Validate_Enabled exception
1718: --
1719: if p_validate then
1725: p_object_version_number := l_object_version_number;
1726: p_effective_start_date := l_effective_start_date;
1727: p_effective_end_date := l_effective_end_date;
1728: --
1729: hr_utility.set_location(' Leaving:'||l_proc, 70);
1730: --
1731: exception
1732: --
1733: when hr_api.validate_enabled then
1740: -- Only set output warning arguments
1741: -- (Any key or derived arguments must be set to null
1742: -- when validation only mode is being used.)
1743: --
1744: hr_utility.set_location(' Leaving:'||l_proc, 80);
1745: --
1746: when others then
1747: --
1748: -- A validation or unexpected error has occured
1777: l_effective_end_date ben_pl_f.effective_end_date%TYPE;
1778: --
1779: begin
1780: --
1781: hr_utility.set_location('Entering:'|| l_proc, 10);
1782: --
1783: -- Issue a savepoint if operating in validation only mode
1784: --
1785: savepoint delete_Plan;
1783: -- Issue a savepoint if operating in validation only mode
1784: --
1785: savepoint delete_Plan;
1786: --
1787: hr_utility.set_location(l_proc, 20);
1788: --
1789: -- Process Logic
1790: --
1791: l_object_version_number := p_object_version_number;
1845: -- End of API User Hook for the after hook of delete_Plan
1846: --
1847: end;
1848: --
1849: hr_utility.set_location(l_proc, 60);
1850: --
1851: -- When in validation only mode raise the Validate_Enabled exception
1852: --
1853: if p_validate then
1853: if p_validate then
1854: raise hr_api.validate_enabled;
1855: end if;
1856: --
1857: hr_utility.set_location(' Leaving:'||l_proc, 70);
1858: --
1859: exception
1860: --
1861: when hr_api.validate_enabled then
1907: l_validation_end_date date;
1908: --
1909: begin
1910: --
1911: hr_utility.set_location('Entering:'|| l_proc, 10);
1912: --
1913: ben_pln_shd.lck
1914: (p_pl_id => p_pl_id
1915: ,p_validation_start_date => l_validation_start_date
1918: ,p_effective_date => p_effective_date
1919: ,p_datetrack_mode => p_datetrack_mode
1920: );
1921: --
1922: hr_utility.set_location(' Leaving:'||l_proc, 70);
1923: --
1924: end lck;
1925: --
1926: end ben_Plan_api;