136: ,p_equal_to => p_equal_to
137: ,p_type => p_type
138: );
139: exception
140: when hr_api.cannot_find_prog_unit then
141: hr_api.cannot_find_prog_unit_error
142: (p_module_name => 'create_time_category_comp'
143: ,p_hook_type => 'BP'
144: );
137: ,p_type => p_type
138: );
139: exception
140: when hr_api.cannot_find_prog_unit then
141: hr_api.cannot_find_prog_unit_error
142: (p_module_name => 'create_time_category_comp'
143: ,p_hook_type => 'BP'
144: );
145: end;
202: ,p_equal_to => p_equal_to
203: ,p_type => p_type
204: );
205: exception
206: when hr_api.cannot_find_prog_unit then
207: hr_api.cannot_find_prog_unit_error
208: (p_module_name => 'create_time_category_comp'
209: ,p_hook_type => 'AP'
210: );
203: ,p_type => p_type
204: );
205: exception
206: when hr_api.cannot_find_prog_unit then
207: hr_api.cannot_find_prog_unit_error
208: (p_module_name => 'create_time_category_comp'
209: ,p_hook_type => 'AP'
210: );
211: end;
216: --
217: -- When in validation only mode raise the Validate_Enabled exception
218: --
219: if p_validate then
220: raise hr_api.validate_enabled;
221: end if;
222: --
223: if g_debug then
224: hr_utility.set_location(' Leaving:'||l_proc, 70);
230: p_object_version_number := l_object_version_number;
231: --
232: exception
233: --
234: when hr_api.validate_enabled then
235: --
236: -- As the Validate_Enabled exception has been raised
237: -- we must rollback to the savepoint
238: --
355: ,p_equal_to => p_equal_to
356: ,p_type => p_type
357: );
358: exception
359: when hr_api.cannot_find_prog_unit then
360: hr_api.cannot_find_prog_unit_error
361: (p_module_name => 'update_time_category_comp'
362: ,p_hook_type => 'BP'
363: );
356: ,p_type => p_type
357: );
358: exception
359: when hr_api.cannot_find_prog_unit then
360: hr_api.cannot_find_prog_unit_error
361: (p_module_name => 'update_time_category_comp'
362: ,p_hook_type => 'BP'
363: );
364: end;
417: ,p_equal_to => p_equal_to
418: ,p_type => p_type
419: );
420: exception
421: when hr_api.cannot_find_prog_unit then
422: hr_api.cannot_find_prog_unit_error
423: (p_module_name => 'update_time_category_comp'
424: ,p_hook_type => 'AP'
425: );
418: ,p_type => p_type
419: );
420: exception
421: when hr_api.cannot_find_prog_unit then
422: hr_api.cannot_find_prog_unit_error
423: (p_module_name => 'update_time_category_comp'
424: ,p_hook_type => 'AP'
425: );
426: end;
431: --
432: -- When in validation only mode raise the Validate_Enabled exception
433: --
434: if p_validate then
435: raise hr_api.validate_enabled;
436: end if;
437: --
438: if g_debug then
439: hr_utility.set_location(' Leaving:'||l_proc, 60);
444: p_object_version_number := l_object_version_number;
445: --
446: exception
447: --
448: when hr_api.validate_enabled then
449: --
450: -- As the Validate_Enabled exception has been raised
451: -- we must rollback to the savepoint
452: --
512: (p_time_category_comp_id => p_time_category_comp_id
513: ,p_object_version_number => p_object_version_number
514: );
515: exception
516: when hr_api.cannot_find_prog_unit then
517: hr_api.cannot_find_prog_unit_error
518: (p_module_name => 'delete_time_category_comp_b'
519: ,p_hook_type => 'BP'
520: );
513: ,p_object_version_number => p_object_version_number
514: );
515: exception
516: when hr_api.cannot_find_prog_unit then
517: hr_api.cannot_find_prog_unit_error
518: (p_module_name => 'delete_time_category_comp_b'
519: ,p_hook_type => 'BP'
520: );
521: end;
548: (p_time_category_comp_id => p_time_category_comp_id
549: ,p_object_version_number => p_object_version_number
550: );
551: exception
552: when hr_api.cannot_find_prog_unit then
553: hr_api.cannot_find_prog_unit_error
554: (p_module_name => 'delete_time_category_comp_a'
555: ,p_hook_type => 'AP'
556: );
549: ,p_object_version_number => p_object_version_number
550: );
551: exception
552: when hr_api.cannot_find_prog_unit then
553: hr_api.cannot_find_prog_unit_error
554: (p_module_name => 'delete_time_category_comp_a'
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: if g_debug then
566: hr_utility.set_location(' Leaving:'||l_proc, 50);
567: end if;
568: --
569: exception
570: --
571: when hr_api.validate_enabled then
572: --
573: -- As the Validate_Enabled exception has been raised
574: -- we must rollback to the savepoint
575: --