74: l_object_version_number ben_paird_rt_f.object_version_number%TYPE;
75: --
76: begin
77: --
78: hr_utility.set_location('Entering:'|| l_proc, 10);
79: --
80: -- Issue a savepoint if operating in validation only mode
81: --
82: savepoint create_PAIRED_RATE;
80: -- Issue a savepoint if operating in validation only mode
81: --
82: savepoint create_PAIRED_RATE;
83: --
84: hr_utility.set_location(l_proc, 20);
85: --
86: -- Process Logic
87: --
88: begin
277: -- End of API User Hook for the after hook of create_PAIRED_RATE
278: --
279: end;
280: --
281: hr_utility.set_location(l_proc, 60);
282: --
283: -- When in validation only mode raise the Validate_Enabled exception
284: --
285: if p_validate then
292: p_effective_start_date := l_effective_start_date;
293: p_effective_end_date := l_effective_end_date;
294: p_object_version_number := l_object_version_number;
295: --
296: hr_utility.set_location(' Leaving:'||l_proc, 70);
297: --
298: exception
299: --
300: when hr_api.validate_enabled then
311: p_paird_rt_id := null;
312: p_effective_start_date := null;
313: p_effective_end_date := null;
314: p_object_version_number := null;
315: hr_utility.set_location(' Leaving:'||l_proc, 80);
316: --
317: when others then
318: --
319: -- A validation or unexpected error has occured
395: l_effective_end_date ben_paird_rt_f.effective_end_date%TYPE;
396: --
397: begin
398: --
399: hr_utility.set_location('Entering:'|| l_proc, 10);
400: --
401: -- Issue a savepoint if operating in validation only mode
402: --
403: savepoint update_PAIRED_RATE;
401: -- Issue a savepoint if operating in validation only mode
402: --
403: savepoint update_PAIRED_RATE;
404: --
405: hr_utility.set_location(l_proc, 20);
406: --
407: -- Process Logic
408: --
409: l_object_version_number := p_object_version_number;
604: -- End of API User Hook for the after hook of update_PAIRED_RATE
605: --
606: end;
607: --
608: hr_utility.set_location(l_proc, 60);
609: --
610: -- When in validation only mode raise the Validate_Enabled exception
611: --
612: if p_validate then
618: p_object_version_number := l_object_version_number;
619: p_effective_start_date := l_effective_start_date;
620: p_effective_end_date := l_effective_end_date;
621: --
622: hr_utility.set_location(' Leaving:'||l_proc, 70);
623: --
624: exception
625: --
626: when hr_api.validate_enabled then
635: -- Only set output warning arguments
636: -- (Any key or derived arguments must be set to null
637: -- when validation only mode is being used.)
638: --
639: hr_utility.set_location(' Leaving:'||l_proc, 80);
640: --
641: when others then
642: --
643: -- A validation or unexpected error has occured
671: l_effective_end_date ben_paird_rt_f.effective_end_date%TYPE;
672: --
673: begin
674: --
675: hr_utility.set_location('Entering:'|| l_proc, 10);
676: --
677: -- Issue a savepoint if operating in validation only mode
678: --
679: savepoint delete_PAIRED_RATE;
677: -- Issue a savepoint if operating in validation only mode
678: --
679: savepoint delete_PAIRED_RATE;
680: --
681: hr_utility.set_location(l_proc, 20);
682: --
683: -- Process Logic
684: --
685: l_object_version_number := p_object_version_number;
740: -- End of API User Hook for the after hook of delete_PAIRED_RATE
741: --
742: end;
743: --
744: hr_utility.set_location(l_proc, 60);
745: --
746: -- When in validation only mode raise the Validate_Enabled exception
747: --
748: if p_validate then
748: if p_validate then
749: raise hr_api.validate_enabled;
750: end if;
751: --
752: hr_utility.set_location(' Leaving:'||l_proc, 70);
753: --
754: exception
755: --
756: when hr_api.validate_enabled then
801: l_validation_end_date date;
802: --
803: begin
804: --
805: hr_utility.set_location('Entering:'|| l_proc, 10);
806: --
807: ben_prd_shd.lck
808: (
809: p_paird_rt_id => p_paird_rt_id
813: ,p_effective_date => p_effective_date
814: ,p_datetrack_mode => p_datetrack_mode
815: );
816: --
817: hr_utility.set_location(' Leaving:'||l_proc, 70);
818: --
819: end lck;
820: --
821: end ben_PAIRED_RATE_api;