70: l_c1 c1%rowtype;
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_actual_premium_rate;
76: -- Issue a savepoint if operating in validation only mode
77: --
78: savepoint create_actual_premium_rate;
79: --
80: hr_utility.set_location(l_proc, 20);
81: --
82: -- Process Logic
83: --
84: begin
253: ben_derivable_rate.rate_prfl_handler('CREATE','ben_oipl_f','oipl_id',l_c1.oipl_id);
254: --
255: end if;
256: --
257: hr_utility.set_location(l_proc, 60);
258: --
259: -- When in validation only mode raise the Validate_Enabled exception
260: --
261: if p_validate then
268: p_effective_start_date := l_effective_start_date;
269: p_effective_end_date := l_effective_end_date;
270: p_object_version_number := l_object_version_number;
271: --
272: hr_utility.set_location(' Leaving:'||l_proc, 70);
273: --
274: exception
275: --
276: when hr_api.validate_enabled then
287: p_actl_prem_vrbl_rt_id := null;
288: p_effective_start_date := null;
289: p_effective_end_date := null;
290: p_object_version_number := null;
291: hr_utility.set_location(' Leaving:'||l_proc, 80);
292: --
293: when others then
294: --
295: -- A validation or unexpected error has occured
360: l_in_object_version_number number := p_object_version_number ;
361: --
362: begin
363: --
364: hr_utility.set_location('Entering:'|| l_proc, 10);
365: --
366: -- Issue a savepoint if operating in validation only mode
367: --
368: savepoint update_actual_premium_rate;
366: -- Issue a savepoint if operating in validation only mode
367: --
368: savepoint update_actual_premium_rate;
369: --
370: hr_utility.set_location(l_proc, 20);
371: --
372: -- Process Logic
373: --
374: l_object_version_number := p_object_version_number;
533: -- End of API User Hook for the after hook of update_actual_premium_rate
534: --
535: end;
536: --
537: hr_utility.set_location(l_proc, 60);
538: --
539: -- When in validation only mode raise the Validate_Enabled exception
540: --
541: if p_validate then
547: p_object_version_number := l_object_version_number;
548: p_effective_start_date := l_effective_start_date;
549: p_effective_end_date := l_effective_end_date;
550: --
551: hr_utility.set_location(' Leaving:'||l_proc, 70);
552: --
553: exception
554: --
555: when hr_api.validate_enabled then
562: -- Only set output warning arguments
563: -- (Any key or derived arguments must be set to null
564: -- when validation only mode is being used.)
565: --
566: hr_utility.set_location(' Leaving:'||l_proc, 80);
567: --
568: when others then
569: --
570: -- A validation or unexpected error has occured
610: l_c1 c1%rowtype;
611: --
612: begin
613: --
614: hr_utility.set_location('Entering:'|| l_proc, 10);
615: --
616: -- Issue a savepoint if operating in validation only mode
617: --
618: savepoint delete_actual_premium_rate;
616: -- Issue a savepoint if operating in validation only mode
617: --
618: savepoint delete_actual_premium_rate;
619: --
620: hr_utility.set_location(l_proc, 20);
621: --
622: -- Process Logic
623: --
624: l_object_version_number := p_object_version_number;
695: ben_derivable_rate.rate_prfl_handler('DELETE','ben_oipl_f','oipl_id',l_c1.oipl_id);
696: --
697: end if;
698: --
699: hr_utility.set_location(l_proc, 60);
700: --
701: -- When in validation only mode raise the Validate_Enabled exception
702: --
703: if p_validate then
703: if p_validate then
704: raise hr_api.validate_enabled;
705: end if;
706: --
707: hr_utility.set_location(' Leaving:'||l_proc, 70);
708: --
709: exception
710: --
711: when hr_api.validate_enabled then
757: l_validation_end_date date;
758: --
759: begin
760: --
761: hr_utility.set_location('Entering:'|| l_proc, 10);
762: --
763: ben_apv_shd.lck
764: (
765: p_actl_prem_vrbl_rt_id => p_actl_prem_vrbl_rt_id
769: ,p_effective_date => p_effective_date
770: ,p_datetrack_mode => p_datetrack_mode
771: );
772: --
773: hr_utility.set_location(' Leaving:'||l_proc, 70);
774: --
775: end lck;
776: --
777: end ben_actual_premium_rate_api;