[Home] [Help]
285: p_prsi_details_id := null;
286: p_object_version_number := null;
287: p_effective_start_date := null;
288: p_effective_end_Date := null;
289: hr_utility.set_location(' Leaving:'||l_proc, 80);
290: when others then
291: --
292: -- A validation or unexpected error has occured
293: --
295: p_object_version_number := l_object_version_number;
296: p_effective_start_date := null;
297: p_effective_end_date := null;
298:
299: hr_utility.set_location(' Leaving:'||l_proc, 90);
300: raise;
301: end create_ie_prsi_details;
302: --
303: --
574: -- IN OUT parameter should be reset to its IN value
575: -- therefore no need to reset p_object_version_number
576: p_effective_start_date := null;
577: p_effective_end_Date := null;
578: hr_utility.set_location(' Leaving:'||l_proc, 80);
579: when others then
580: --
581: -- A validation or unexpected error has occured
582: --
583: rollback to update_ie_prsi_details;
584: p_object_version_number := l_object_version_number;
585: p_effective_start_date := null;
586: p_effective_end_date := null;
587: hr_utility.set_location(' Leaving:'||l_proc, 90);
588: raise;
589: end update_ie_prsi_details;
590:
591: --
724: -- no need to set p_object_version_number
725: p_effective_start_date := null;
726: p_effective_end_Date := null;
727: --
728: hr_utility.set_location(' Leaving:'||l_proc, 80);
729: when others then
730: --
731: -- A validation or unexpected error has occured
732: --
734: p_object_version_number := l_object_version_number;
735: p_effective_start_date := null;
736: p_effective_end_date := null;
737:
738: hr_utility.set_location(' Leaving:'||l_proc, 90);
739: raise;
740: end delete_ie_prsi_details;
741:
742: end pay_ie_prsi_api;