70: l_object_version_number ben_ler_chg_ptip_enrt_f.object_version_number%TYPE;
71: --
72: begin
73: --
74: hr_utility.set_location('Entering:'|| l_proc, 10);
75: --
76: -- Issue a savepoint if operating in validation only mode
77: --
78: savepoint create_ler_chg_ptip_enrt;
76: -- Issue a savepoint if operating in validation only mode
77: --
78: savepoint create_ler_chg_ptip_enrt;
79: --
80: hr_utility.set_location(l_proc, 20);
81: --
82: -- Process Logic
83: --
84: begin
261: -- End of API User Hook for the after hook of create_ler_chg_ptip_enrt
262: --
263: end;
264: --
265: hr_utility.set_location(l_proc, 60);
266: --
267: -- When in validation only mode raise the Validate_Enabled exception
268: --
269: if p_validate then
276: p_effective_start_date := l_effective_start_date;
277: p_effective_end_date := l_effective_end_date;
278: p_object_version_number := l_object_version_number;
279: --
280: hr_utility.set_location(' Leaving:'||l_proc, 70);
281: --
282: exception
283: --
284: when hr_api.validate_enabled then
295: p_ler_chg_ptip_enrt_id := null;
296: p_effective_start_date := null;
297: p_effective_end_date := null;
298: p_object_version_number := null;
299: hr_utility.set_location(' Leaving:'||l_proc, 80);
300: --
301: when others then
302: --
303: -- A validation or unexpected error has occured
371: l_effective_end_date ben_ler_chg_ptip_enrt_f.effective_end_date%TYPE;
372: --
373: begin
374: --
375: hr_utility.set_location('Entering:'|| l_proc, 10);
376: --
377: -- Issue a savepoint if operating in validation only mode
378: --
379: savepoint update_ler_chg_ptip_enrt;
377: -- Issue a savepoint if operating in validation only mode
378: --
379: savepoint update_ler_chg_ptip_enrt;
380: --
381: hr_utility.set_location(l_proc, 20);
382: --
383: -- Process Logic
384: --
385: l_object_version_number := p_object_version_number;
568: -- End of API User Hook for the after hook of update_ler_chg_ptip_enrt
569: --
570: end;
571: --
572: hr_utility.set_location(l_proc, 60);
573: --
574: -- When in validation only mode raise the Validate_Enabled exception
575: --
576: if p_validate then
582: p_object_version_number := l_object_version_number;
583: p_effective_start_date := l_effective_start_date;
584: p_effective_end_date := l_effective_end_date;
585: --
586: hr_utility.set_location(' Leaving:'||l_proc, 70);
587: --
588: exception
589: --
590: when hr_api.validate_enabled then
597: -- Only set output warning arguments
598: -- (Any key or derived arguments must be set to null
599: -- when validation only mode is being used.)
600: --
601: hr_utility.set_location(' Leaving:'||l_proc, 80);
602: --
603: when others then
604: --
605: -- A validation or unexpected error has occured
634: l_effective_end_date ben_ler_chg_ptip_enrt_f.effective_end_date%TYPE;
635: --
636: begin
637: --
638: hr_utility.set_location('Entering:'|| l_proc, 10);
639: --
640: -- Issue a savepoint if operating in validation only mode
641: --
642: savepoint delete_ler_chg_ptip_enrt;
640: -- Issue a savepoint if operating in validation only mode
641: --
642: savepoint delete_ler_chg_ptip_enrt;
643: --
644: hr_utility.set_location(l_proc, 20);
645: --
646: -- Process Logic
647: --
648: l_object_version_number := p_object_version_number;
703: -- End of API User Hook for the after hook of delete_ler_chg_ptip_enrt
704: --
705: end;
706: --
707: hr_utility.set_location(l_proc, 60);
708: --
709: -- When in validation only mode raise the Validate_Enabled exception
710: --
711: if p_validate then
711: if p_validate then
712: raise hr_api.validate_enabled;
713: end if;
714: --
715: hr_utility.set_location(' Leaving:'||l_proc, 70);
716: --
717: exception
718: --
719: when hr_api.validate_enabled then
765: l_validation_end_date date;
766: --
767: begin
768: --
769: hr_utility.set_location('Entering:'|| l_proc, 10);
770: --
771: ben_lct_shd.lck
772: (
773: p_ler_chg_ptip_enrt_id => p_ler_chg_ptip_enrt_id
777: ,p_effective_date => p_effective_date
778: ,p_datetrack_mode => p_datetrack_mode
779: );
780: --
781: hr_utility.set_location(' Leaving:'||l_proc, 70);
782: --
783: end lck;
784: --
785: end ben_ler_chg_ptip_enrt_api;