62: ,p_equal_to => p_equal_to
63: ,p_type => p_type
64: );
65: exception
66: when hr_api.cannot_find_prog_unit then
67: hr_api.cannot_find_prog_unit_error
68: (p_module_name => 'create_time_category_comp'
69: ,p_hook_type => 'BP'
70: );
63: ,p_type => p_type
64: );
65: exception
66: when hr_api.cannot_find_prog_unit then
67: hr_api.cannot_find_prog_unit_error
68: (p_module_name => 'create_time_category_comp'
69: ,p_hook_type => 'BP'
70: );
71: end;
115: ,p_equal_to => p_equal_to
116: ,p_type => p_type
117: );
118: exception
119: when hr_api.cannot_find_prog_unit then
120: hr_api.cannot_find_prog_unit_error
121: (p_module_name => 'create_time_category_comp'
122: ,p_hook_type => 'AP'
123: );
116: ,p_type => p_type
117: );
118: exception
119: when hr_api.cannot_find_prog_unit then
120: hr_api.cannot_find_prog_unit_error
121: (p_module_name => 'create_time_category_comp'
122: ,p_hook_type => 'AP'
123: );
124: end;
129: --
130: -- When in validation only mode raise the Validate_Enabled exception
131: --
132: if p_validate then
133: raise hr_api.validate_enabled;
134: end if;
135: --
136: if g_debug then
137: hr_utility.set_location(' Leaving:'||l_proc, 70);
143: p_object_version_number := l_object_version_number;
144: --
145: exception
146: --
147: when hr_api.validate_enabled then
148: --
149: -- As the Validate_Enabled exception has been raised
150: -- we must rollback to the savepoint
151: --
228: ,p_equal_to => p_equal_to
229: ,p_type => p_type
230: );
231: exception
232: when hr_api.cannot_find_prog_unit then
233: hr_api.cannot_find_prog_unit_error
234: (p_module_name => 'update_time_category_comp'
235: ,p_hook_type => 'BP'
236: );
229: ,p_type => p_type
230: );
231: exception
232: when hr_api.cannot_find_prog_unit then
233: hr_api.cannot_find_prog_unit_error
234: (p_module_name => 'update_time_category_comp'
235: ,p_hook_type => 'BP'
236: );
237: end;
277: ,p_equal_to => p_equal_to
278: ,p_type => p_type
279: );
280: exception
281: when hr_api.cannot_find_prog_unit then
282: hr_api.cannot_find_prog_unit_error
283: (p_module_name => 'update_time_category_comp'
284: ,p_hook_type => 'AP'
285: );
278: ,p_type => p_type
279: );
280: exception
281: when hr_api.cannot_find_prog_unit then
282: hr_api.cannot_find_prog_unit_error
283: (p_module_name => 'update_time_category_comp'
284: ,p_hook_type => 'AP'
285: );
286: end;
291: --
292: -- When in validation only mode raise the Validate_Enabled exception
293: --
294: if p_validate then
295: raise hr_api.validate_enabled;
296: end if;
297: --
298: if g_debug then
299: hr_utility.set_location(' Leaving:'||l_proc, 60);
304: p_object_version_number := l_object_version_number;
305: --
306: exception
307: --
308: when hr_api.validate_enabled then
309: --
310: -- As the Validate_Enabled exception has been raised
311: -- we must rollback to the savepoint
312: --
372: (p_time_category_comp_id => p_time_category_comp_id
373: ,p_object_version_number => p_object_version_number
374: );
375: exception
376: when hr_api.cannot_find_prog_unit then
377: hr_api.cannot_find_prog_unit_error
378: (p_module_name => 'delete_time_category_comp_b'
379: ,p_hook_type => 'BP'
380: );
373: ,p_object_version_number => p_object_version_number
374: );
375: exception
376: when hr_api.cannot_find_prog_unit then
377: hr_api.cannot_find_prog_unit_error
378: (p_module_name => 'delete_time_category_comp_b'
379: ,p_hook_type => 'BP'
380: );
381: end;
404: (p_time_category_comp_id => p_time_category_comp_id
405: ,p_object_version_number => p_object_version_number
406: );
407: exception
408: when hr_api.cannot_find_prog_unit then
409: hr_api.cannot_find_prog_unit_error
410: (p_module_name => 'delete_time_category_comp_a'
411: ,p_hook_type => 'AP'
412: );
405: ,p_object_version_number => p_object_version_number
406: );
407: exception
408: when hr_api.cannot_find_prog_unit then
409: hr_api.cannot_find_prog_unit_error
410: (p_module_name => 'delete_time_category_comp_a'
411: ,p_hook_type => 'AP'
412: );
413: end;
414: --
415: -- When in validation only mode raise the Validate_Enabled exception
416: --
417: if p_validate then
418: raise hr_api.validate_enabled;
419: end if;
420: --
421: if g_debug then
422: hr_utility.set_location(' Leaving:'||l_proc, 50);
423: end if;
424: --
425: exception
426: --
427: when hr_api.validate_enabled then
428: --
429: -- As the Validate_Enabled exception has been raised
430: -- we must rollback to the savepoint
431: --