151: ,p_competency_update_level => p_competency_update_level
152:
153: );
154: exception
155: when hr_api.cannot_find_prog_unit then
156: hr_api.cannot_find_prog_unit_error
157: (p_module_name => 'CREATE_ACTIVITY_VERSION'
158: ,p_hook_type => 'BP'
159: );
152:
153: );
154: exception
155: when hr_api.cannot_find_prog_unit then
156: hr_api.cannot_find_prog_unit_error
157: (p_module_name => 'CREATE_ACTIVITY_VERSION'
158: ,p_hook_type => 'BP'
159: );
160: end;
310: ,p_competency_update_level => p_competency_update_level
311:
312: );
313: exception
314: when hr_api.cannot_find_prog_unit then
315: hr_api.cannot_find_prog_unit_error
316: (p_module_name => 'CREATE_ACTIVITY_VERSION'
317: ,p_hook_type => 'AP'
318: );
311:
312: );
313: exception
314: when hr_api.cannot_find_prog_unit then
315: hr_api.cannot_find_prog_unit_error
316: (p_module_name => 'CREATE_ACTIVITY_VERSION'
317: ,p_hook_type => 'AP'
318: );
319: end;
321: --
322: -- When in validation only mode raise the Validate_Enabled exception
323: --
324: if p_validate then
325: raise hr_api.validate_enabled;
326: end if;
327:
328: hr_utility.set_location(' Leaving:'||l_proc, 70);
329: exception
326: end if;
327:
328: hr_utility.set_location(' Leaving:'||l_proc, 70);
329: exception
330: when hr_api.validate_enabled then
331: --
332: -- As the Validate_Enabled exception has been raised
333: -- we must rollback to the savepoint
334: --
497: ,p_competency_update_level => p_competency_update_level
498:
499: );
500: exception
501: when hr_api.cannot_find_prog_unit then
502: hr_api.cannot_find_prog_unit_error
503: (p_module_name => 'UPDATE_ACTIVITY_VERSION'
504: ,p_hook_type => 'BP'
505: );
498:
499: );
500: exception
501: when hr_api.cannot_find_prog_unit then
502: hr_api.cannot_find_prog_unit_error
503: (p_module_name => 'UPDATE_ACTIVITY_VERSION'
504: ,p_hook_type => 'BP'
505: );
506: end;
646:
647:
648: );
649: exception
650: when hr_api.cannot_find_prog_unit then
651: hr_api.cannot_find_prog_unit_error
652: (p_module_name => 'UPDATE_ACTIVITY_VERSION'
653: ,p_hook_type => 'AP'
654: );
647:
648: );
649: exception
650: when hr_api.cannot_find_prog_unit then
651: hr_api.cannot_find_prog_unit_error
652: (p_module_name => 'UPDATE_ACTIVITY_VERSION'
653: ,p_hook_type => 'AP'
654: );
655: end;
658: --
659: -- When in validation only mode raise the Validate_Enabled exception
660: --
661: if p_validate then
662: raise hr_api.validate_enabled;
663: end if;
664: --
665: -- Set all output arguments
666: --
665: -- Set all output arguments
666: --
667: hr_utility.set_location(' Leaving:'||l_proc, 70);
668: exception
669: when hr_api.validate_enabled then
670: --
671: -- As the Validate_Enabled exception has been raised
672: -- we must rollback to the savepoint
673: --
744: (p_activity_version_id => p_activity_version_id
745: ,p_object_version_number => p_object_version_number
746: );
747: exception
748: when hr_api.cannot_find_prog_unit then
749: hr_api.cannot_find_prog_unit_error
750: (p_module_name => 'DELETE_ACTIVITY_VERSION'
751: ,p_hook_type => 'BP'
752: );
745: ,p_object_version_number => p_object_version_number
746: );
747: exception
748: when hr_api.cannot_find_prog_unit then
749: hr_api.cannot_find_prog_unit_error
750: (p_module_name => 'DELETE_ACTIVITY_VERSION'
751: ,p_hook_type => 'BP'
752: );
753: end ;
811: (p_activity_version_id => p_activity_version_id ,
812: p_object_version_number => p_object_version_number
813: );
814: exception
815: when hr_api.cannot_find_prog_unit then
816: hr_api.cannot_find_prog_unit_error
817: (p_module_name => 'DELETE_ACTIVITY_VERSION'
818: ,p_hook_type => 'AP'
819: );
812: p_object_version_number => p_object_version_number
813: );
814: exception
815: when hr_api.cannot_find_prog_unit then
816: hr_api.cannot_find_prog_unit_error
817: (p_module_name => 'DELETE_ACTIVITY_VERSION'
818: ,p_hook_type => 'AP'
819: );
820: end;
820: end;
821: --
822: --
823: if p_validate then
824: raise hr_api.validate_enabled;
825: end if;
826: --
827: -- Set all output arguments
828: --
828: --
829: --
830: hr_utility.set_location(' Leaving:'||l_proc, 170);
831: exception
832: when hr_api.validate_enabled then
833: --
834: -- As the Validate_Enabled exception has been raised
835: -- we must rollback to the savepoint
836: --