143: ,p_end_date_active => p_end_date_active
144: ,p_comments => p_comments
145: );
146: exception
147: when hr_api.cannot_find_prog_unit then
148: hr_api.cannot_find_prog_unit_error
149: (p_module_name => 'CREATE_CATEGORY'
150: ,p_hook_type => 'BP'
151: );
144: ,p_comments => p_comments
145: );
146: exception
147: when hr_api.cannot_find_prog_unit then
148: hr_api.cannot_find_prog_unit_error
149: (p_module_name => 'CREATE_CATEGORY'
150: ,p_hook_type => 'BP'
151: );
152: end;
264: ,p_comments => p_comments
265:
266: );
267: exception
268: when hr_api.cannot_find_prog_unit then
269: hr_api.cannot_find_prog_unit_error
270: (p_module_name => 'CREATE_CATEGORY'
271: ,p_hook_type => 'AP'
272: );
265:
266: );
267: exception
268: when hr_api.cannot_find_prog_unit then
269: hr_api.cannot_find_prog_unit_error
270: (p_module_name => 'CREATE_CATEGORY'
271: ,p_hook_type => 'AP'
272: );
273: end;
274: --
275: -- When in validation only mode raise the Validate_Enabled exception
276: --
277: if p_validate then
278: raise hr_api.validate_enabled;
279: end if;
280: --
281: -- Set all output arguments
282: --
284: p_object_version_number := l_object_version_number;
285: --
286: hr_utility.set_location(' Leaving:'||l_proc, 70);
287: exception
288: when hr_api.validate_enabled then
289: --
290: -- As the Validate_Enabled exception has been raised
291: -- we must rollback to the savepoint
292: --
420: ,p_end_date_active => p_end_date_active
421: ,p_comments => p_comments
422: );
423: exception
424: when hr_api.cannot_find_prog_unit then
425: hr_api.cannot_find_prog_unit_error
426: (p_module_name => 'UPDATE_CATEGORY'
427: ,p_hook_type => 'BP'
428: );
421: ,p_comments => p_comments
422: );
423: exception
424: when hr_api.cannot_find_prog_unit then
425: hr_api.cannot_find_prog_unit_error
426: (p_module_name => 'UPDATE_CATEGORY'
427: ,p_hook_type => 'BP'
428: );
429: end;
548: ,p_comments => p_comments
549:
550: );
551: exception
552: when hr_api.cannot_find_prog_unit then
553: hr_api.cannot_find_prog_unit_error
554: (p_module_name => 'UPDATE_CATEGORY'
555: ,p_hook_type => 'AP'
556: );
549:
550: );
551: exception
552: when hr_api.cannot_find_prog_unit then
553: hr_api.cannot_find_prog_unit_error
554: (p_module_name => 'UPDATE_CATEGORY'
555: ,p_hook_type => 'AP'
556: );
557: end;
558: --
559: -- When in validation only mode raise the Validate_Enabled exception
560: --
561: if p_validate then
562: raise hr_api.validate_enabled;
563: end if;
564: --
565: -- Set all output arguments
566: --
565: -- Set all output arguments
566: --
567: hr_utility.set_location(' Leaving:'||l_proc, 70);
568: exception
569: when hr_api.validate_enabled then
570: --
571: -- As the Validate_Enabled exception has been raised
572: -- we must rollback to the savepoint
573: --
636: (p_category_usage_id => p_category_usage_id
637: ,p_object_version_number => p_object_version_number
638: );
639: exception
640: when hr_api.cannot_find_prog_unit then
641: hr_api.cannot_find_prog_unit_error
642: (p_module_name => 'DELETE_CATEGORY'
643: ,p_hook_type => 'BP'
644: );
637: ,p_object_version_number => p_object_version_number
638: );
639: exception
640: when hr_api.cannot_find_prog_unit then
641: hr_api.cannot_find_prog_unit_error
642: (p_module_name => 'DELETE_CATEGORY'
643: ,p_hook_type => 'BP'
644: );
645: end;
681: (p_category_usage_id => p_category_usage_id
682: ,p_object_version_number => p_object_version_number
683: );
684: exception
685: when hr_api.cannot_find_prog_unit then
686: hr_api.cannot_find_prog_unit_error
687: (p_module_name => 'DELETE_CATEGORY'
688: ,p_hook_type => 'AP'
689: );
682: ,p_object_version_number => p_object_version_number
683: );
684: exception
685: when hr_api.cannot_find_prog_unit then
686: hr_api.cannot_find_prog_unit_error
687: (p_module_name => 'DELETE_CATEGORY'
688: ,p_hook_type => 'AP'
689: );
690: end;
691: --
692: -- When in validation only mode raise the Validate_Enabled exception
693: --
694: if p_validate then
695: raise hr_api.validate_enabled;
696: end if;
697: --
698: -- Set all output arguments
699: --
699: --
700: --
701: hr_utility.set_location(' Leaving:'||l_proc, 170);
702: exception
703: when hr_api.validate_enabled then
704: --
705: -- As the Validate_Enabled exception has been raised
706: -- we must rollback to the savepoint
707: --