306: ,p_top_level_parent_id => p_top_level_parent_id --Performance Fix
307: ,p_code => p_code
308: );
309: exception
310: when hr_api.cannot_find_prog_unit then
311: hr_api.cannot_find_prog_unit_error
312: (p_module_name => 'create_pref_hierarchies'
313: ,p_hook_type => 'BP'
314: );
307: ,p_code => p_code
308: );
309: exception
310: when hr_api.cannot_find_prog_unit then
311: hr_api.cannot_find_prog_unit_error
312: (p_module_name => 'create_pref_hierarchies'
313: ,p_hook_type => 'BP'
314: );
315: end;
437: ,p_top_level_parent_id => p_top_level_parent_id --Performance Fix
438: ,p_code => p_code
439: );
440: exception
441: when hr_api.cannot_find_prog_unit then
442: hr_api.cannot_find_prog_unit_error
443: (p_module_name => 'create_pref_hierarchies'
444: ,p_hook_type => 'AP'
445: );
438: ,p_code => p_code
439: );
440: exception
441: when hr_api.cannot_find_prog_unit then
442: hr_api.cannot_find_prog_unit_error
443: (p_module_name => 'create_pref_hierarchies'
444: ,p_hook_type => 'AP'
445: );
446: end;
451: --
452: -- When in validation only mode raise the Validate_Enabled exception
453: --
454: if p_validate then
455: raise hr_api.validate_enabled;
456: end if;
457: --
458: --if g_debug then
459: --hr_utility.set_location(' Leaving:'||l_proc, 70);
468: if g_debug then
469: hr_utility.set_location(' Leaving:'||l_proc, 70);
470: end if;
471: exception
472: when hr_api.validate_enabled then
473: --
474: -- As the Validate_Enabled exception has been raised
475: -- we must rollback to the savepoint
476: --
625: ,p_code => p_code
626: );
627:
628: exception
629: when hr_api.cannot_find_prog_unit then
630: hr_api.cannot_find_prog_unit_error
631: (p_module_name => 'update_pref_hierarchies'
632: ,p_hook_type => 'BP'
633: );
626: );
627:
628: exception
629: when hr_api.cannot_find_prog_unit then
630: hr_api.cannot_find_prog_unit_error
631: (p_module_name => 'update_pref_hierarchies'
632: ,p_hook_type => 'BP'
633: );
634: end;
753: ,p_top_level_parent_id => p_top_level_parent_id --Performance Fix
754: ,p_code => p_code
755: );
756: exception
757: when hr_api.cannot_find_prog_unit then
758: hr_api.cannot_find_prog_unit_error
759: (p_module_name => 'update_pref_hierarchies'
760: ,p_hook_type => 'AP'
761: );
754: ,p_code => p_code
755: );
756: exception
757: when hr_api.cannot_find_prog_unit then
758: hr_api.cannot_find_prog_unit_error
759: (p_module_name => 'update_pref_hierarchies'
760: ,p_hook_type => 'AP'
761: );
762: end;
770: --
771: -- When in validation only mode raise the Validate_Enabled exception
772: --
773: if p_validate then
774: raise hr_api.validate_enabled;
775: end if;
776: --
777: if g_debug then
778: hr_utility.set_location(' Leaving:'||l_proc, 60);
790: --commit;
791:
792: exception
793: --
794: when hr_api.validate_enabled then
795: --
796: -- As the Validate_Enabled exception has been raised
797: -- we must rollback to the savepoint
798: --
862: (p_pref_hierarchy_id => p_pref_hierarchy_id
863: ,p_object_version_number => p_object_version_number
864: );
865: exception
866: when hr_api.cannot_find_prog_unit then
867: hr_api.cannot_find_prog_unit_error
868: (p_module_name => 'delete_pref_hierarchies'
869: ,p_hook_type => 'BP'
870: );
863: ,p_object_version_number => p_object_version_number
864: );
865: exception
866: when hr_api.cannot_find_prog_unit then
867: hr_api.cannot_find_prog_unit_error
868: (p_module_name => 'delete_pref_hierarchies'
869: ,p_hook_type => 'BP'
870: );
871: end;
894: (p_pref_hierarchy_id => p_pref_hierarchy_id
895: ,p_object_version_number => p_object_version_number
896: );
897: exception
898: when hr_api.cannot_find_prog_unit then
899: hr_api.cannot_find_prog_unit_error
900: (p_module_name => 'delete_pref_hierarchies'
901: ,p_hook_type => 'AP'
902: );
895: ,p_object_version_number => p_object_version_number
896: );
897: exception
898: when hr_api.cannot_find_prog_unit then
899: hr_api.cannot_find_prog_unit_error
900: (p_module_name => 'delete_pref_hierarchies'
901: ,p_hook_type => 'AP'
902: );
903: end;
904: --
905: -- When in validation only mode raise the Validate_Enabled exception
906: --
907: if p_validate then
908: raise hr_api.validate_enabled;
909: end if;
910: --
911: if g_debug then
912: hr_utility.set_location(' Leaving:'||l_proc, 50);
913: end if;
914: --
915: exception
916: --
917: when hr_api.validate_enabled then
918: --
919: -- As the Validate_Enabled exception has been raised
920: -- we must rollback to the savepoint
921: --