84: l_object_version_number ben_lee_rsn_f.object_version_number%TYPE;
85: --
86: begin
87: --
88: hr_utility.set_location('Entering:'|| l_proc, 10);
89: --
90: -- Issue a savepoint if operating in validation only mode
91: --
92: savepoint create_Life_Event_Enroll_Rsn;
90: -- Issue a savepoint if operating in validation only mode
91: --
92: savepoint create_Life_Event_Enroll_Rsn;
93: --
94: hr_utility.set_location(l_proc, 20);
95: --
96: -- Process Logic
97: --
98: begin
317: -- End of API User Hook for the after hook of create_Life_Event_Enroll_Rsn
318: --
319: end;
320: --
321: hr_utility.set_location(l_proc, 60);
322: --
323: -- When in validation only mode raise the Validate_Enabled exception
324: --
325: if p_validate then
332: p_effective_start_date := l_effective_start_date;
333: p_effective_end_date := l_effective_end_date;
334: p_object_version_number := l_object_version_number;
335: --
336: hr_utility.set_location(' Leaving:'||l_proc, 70);
337: --
338: exception
339: --
340: when hr_api.validate_enabled then
351: p_lee_rsn_id := null;
352: p_effective_start_date := null;
353: p_effective_end_date := null;
354: p_object_version_number := null;
355: hr_utility.set_location(' Leaving:'||l_proc, 80);
356: --
357: when others then
358: --
359: -- A validation or unexpected error has occured
441: l_effective_end_date ben_lee_rsn_f.effective_end_date%TYPE;
442: --
443: begin
444: --
445: hr_utility.set_location('Entering:'|| l_proc, 10);
446: --
447: -- Issue a savepoint if operating in validation only mode
448: --
449: savepoint update_Life_Event_Enroll_Rsn;
447: -- Issue a savepoint if operating in validation only mode
448: --
449: savepoint update_Life_Event_Enroll_Rsn;
450: --
451: hr_utility.set_location(l_proc, 20);
452: --
453: -- Process Logic
454: --
455: l_object_version_number := p_object_version_number;
680: -- End of API User Hook for the after hook of update_Life_Event_Enroll_Rsn
681: --
682: end;
683: --
684: hr_utility.set_location(l_proc, 60);
685: --
686: -- When in validation only mode raise the Validate_Enabled exception
687: --
688: if p_validate then
694: p_object_version_number := l_object_version_number;
695: p_effective_start_date := l_effective_start_date;
696: p_effective_end_date := l_effective_end_date;
697: --
698: hr_utility.set_location(' Leaving:'||l_proc, 70);
699: --
700: exception
701: --
702: when hr_api.validate_enabled then
709: -- Only set output warning arguments
710: -- (Any key or derived arguments must be set to null
711: -- when validation only mode is being used.)
712: --
713: hr_utility.set_location(' Leaving:'||l_proc, 80);
714: --
715: when others then
716: --
717: -- A validation or unexpected error has occured
746: l_effective_end_date ben_lee_rsn_f.effective_end_date%TYPE;
747: --
748: begin
749: --
750: hr_utility.set_location('Entering:'|| l_proc, 10);
751: --
752: -- Issue a savepoint if operating in validation only mode
753: --
754: savepoint delete_Life_Event_Enroll_Rsn;
752: -- Issue a savepoint if operating in validation only mode
753: --
754: savepoint delete_Life_Event_Enroll_Rsn;
755: --
756: hr_utility.set_location(l_proc, 20);
757: --
758: -- Process Logic
759: --
760: l_object_version_number := p_object_version_number;
815: -- End of API User Hook for the after hook of delete_Life_Event_Enroll_Rsn
816: --
817: end;
818: --
819: hr_utility.set_location(l_proc, 60);
820: --
821: -- When in validation only mode raise the Validate_Enabled exception
822: --
823: if p_validate then
823: if p_validate then
824: raise hr_api.validate_enabled;
825: end if;
826: --
827: hr_utility.set_location(' Leaving:'||l_proc, 70);
828: --
829: exception
830: --
831: when hr_api.validate_enabled then
877: l_validation_end_date date;
878: --
879: begin
880: --
881: hr_utility.set_location('Entering:'|| l_proc, 10);
882: --
883: ben_len_shd.lck
884: (
885: p_lee_rsn_id => p_lee_rsn_id
889: ,p_effective_date => p_effective_date
890: ,p_datetrack_mode => p_datetrack_mode
891: );
892: --
893: hr_utility.set_location(' Leaving:'||l_proc, 70);
894: --
895: end lck;
896: --
897: end ben_Life_Event_Enroll_Rsn_api;