54: ,p_description => p_description
55: ,p_display => p_display
56: );
57: exception
58: when hr_api.cannot_find_prog_unit then
59: hr_api.cannot_find_prog_unit_error
60: (p_module_name => 'create_time_category'
61: ,p_hook_type => 'BP'
62: );
55: ,p_display => p_display
56: );
57: exception
58: when hr_api.cannot_find_prog_unit then
59: hr_api.cannot_find_prog_unit_error
60: (p_module_name => 'create_time_category'
61: ,p_hook_type => 'BP'
62: );
63: end;
98: ,p_description => p_description
99: ,p_display => p_display
100: );
101: exception
102: when hr_api.cannot_find_prog_unit then
103: hr_api.cannot_find_prog_unit_error
104: (p_module_name => 'create_time_category'
105: ,p_hook_type => 'AP'
106: );
99: ,p_display => p_display
100: );
101: exception
102: when hr_api.cannot_find_prog_unit then
103: hr_api.cannot_find_prog_unit_error
104: (p_module_name => 'create_time_category'
105: ,p_hook_type => 'AP'
106: );
107: end;
112: --
113: -- When in validation only mode raise the Validate_Enabled exception
114: --
115: if p_validate then
116: raise hr_api.validate_enabled;
117: end if;
118: --
119: if g_debug then
120: hr_utility.set_location(' Leaving:'||l_proc, 70);
126: p_object_version_number := l_object_version_number;
127: --
128: exception
129: --
130: when hr_api.validate_enabled then
131: --
132: -- As the Validate_Enabled exception has been raised
133: -- we must rollback to the savepoint
134: --
204: ,p_display => p_display
205: ,p_operator => p_operator
206: );
207: exception
208: when hr_api.cannot_find_prog_unit then
209: hr_api.cannot_find_prog_unit_error
210: (p_module_name => 'update_time_category'
211: ,p_hook_type => 'BP'
212: );
205: ,p_operator => p_operator
206: );
207: exception
208: when hr_api.cannot_find_prog_unit then
209: hr_api.cannot_find_prog_unit_error
210: (p_module_name => 'update_time_category'
211: ,p_hook_type => 'BP'
212: );
213: end;
243: ,p_description => p_description
244: ,p_display => p_display
245: ,p_operator => p_operator );
246: exception
247: when hr_api.cannot_find_prog_unit then
248: hr_api.cannot_find_prog_unit_error
249: (p_module_name => 'update_time_category'
250: ,p_hook_type => 'AP'
251: );
244: ,p_display => p_display
245: ,p_operator => p_operator );
246: exception
247: when hr_api.cannot_find_prog_unit then
248: hr_api.cannot_find_prog_unit_error
249: (p_module_name => 'update_time_category'
250: ,p_hook_type => 'AP'
251: );
252: end;
257: --
258: -- When in validation only mode raise the Validate_Enabled exception
259: --
260: if p_validate then
261: raise hr_api.validate_enabled;
262: end if;
263: --
264: if g_debug then
265: hr_utility.set_location(' Leaving:'||l_proc, 60);
270: p_object_version_number := l_object_version_number;
271: --
272: exception
273: --
274: when hr_api.validate_enabled then
275: --
276: -- As the Validate_Enabled exception has been raised
277: -- we must rollback to the savepoint
278: --
340: ,p_time_Category_name => p_time_category_name
341: ,p_object_version_number => p_object_version_number
342: );
343: exception
344: when hr_api.cannot_find_prog_unit then
345: hr_api.cannot_find_prog_unit_error
346: (p_module_name => 'delete_time_category_b'
347: ,p_hook_type => 'BP'
348: );
341: ,p_object_version_number => p_object_version_number
342: );
343: exception
344: when hr_api.cannot_find_prog_unit then
345: hr_api.cannot_find_prog_unit_error
346: (p_module_name => 'delete_time_category_b'
347: ,p_hook_type => 'BP'
348: );
349: end;
374: ,p_time_Category_name => p_time_category_name
375: ,p_object_version_number => p_object_version_number
376: );
377: exception
378: when hr_api.cannot_find_prog_unit then
379: hr_api.cannot_find_prog_unit_error
380: (p_module_name => 'delete_time_category_a'
381: ,p_hook_type => 'AP'
382: );
375: ,p_object_version_number => p_object_version_number
376: );
377: exception
378: when hr_api.cannot_find_prog_unit then
379: hr_api.cannot_find_prog_unit_error
380: (p_module_name => 'delete_time_category_a'
381: ,p_hook_type => 'AP'
382: );
383: end;
384: --
385: -- When in validation only mode raise the Validate_Enabled exception
386: --
387: if p_validate then
388: raise hr_api.validate_enabled;
389: end if;
390: --
391: if g_debug then
392: hr_utility.set_location(' Leaving:'||l_proc, 50);
393: end if;
394: --
395: exception
396: --
397: when hr_api.validate_enabled then
398: --
399: -- As the Validate_Enabled exception has been raised
400: -- we must rollback to the savepoint
401: --