58: ,p_time_recipient_id => p_time_recipient_id
59: ,p_effective_date => p_effective_date
60: );
61: exception
62: when hr_api.cannot_find_prog_unit then
63: hr_api.cannot_find_prog_unit_error
64: (p_module_name => 'create_data_app_rule_usages'
65: ,p_hook_type => 'BP'
66: );
59: ,p_effective_date => p_effective_date
60: );
61: exception
62: when hr_api.cannot_find_prog_unit then
63: hr_api.cannot_find_prog_unit_error
64: (p_module_name => 'create_data_app_rule_usages'
65: ,p_hook_type => 'BP'
66: );
67: end;
110: ,p_time_recipient_id => p_time_recipient_id
111: ,p_effective_date => p_effective_date
112: );
113: exception
114: when hr_api.cannot_find_prog_unit then
115: hr_api.cannot_find_prog_unit_error
116: (p_module_name => 'create_data_app_rule_usages'
117: ,p_hook_type => 'AP'
118: );
111: ,p_effective_date => p_effective_date
112: );
113: exception
114: when hr_api.cannot_find_prog_unit then
115: hr_api.cannot_find_prog_unit_error
116: (p_module_name => 'create_data_app_rule_usages'
117: ,p_hook_type => 'AP'
118: );
119: end;
125: --
126: -- When in validation only mode raise the Validate_Enabled exception
127: --
128: if p_validate then
129: raise hr_api.validate_enabled;
130: end if;
131: --
132: --if g_debug then
133: --hr_utility.set_location(' Leaving:'||l_proc, 70);
142: if g_debug then
143: hr_utility.set_location(' Leaving:'||l_proc, 70);
144: end if;
145: exception
146: when hr_api.validate_enabled then
147: --
148: -- As the Validate_Enabled exception has been raised
149: -- we must rollback to the savepoint
150: --
218: ,p_time_recipient_id => p_time_recipient_id
219: ,p_effective_date => p_effective_date
220: );
221: exception
222: when hr_api.cannot_find_prog_unit then
223: hr_api.cannot_find_prog_unit_error
224: (p_module_name => 'update_data_app_rule_usages'
225: ,p_hook_type => 'BP'
226: );
219: ,p_effective_date => p_effective_date
220: );
221: exception
222: when hr_api.cannot_find_prog_unit then
223: hr_api.cannot_find_prog_unit_error
224: (p_module_name => 'update_data_app_rule_usages'
225: ,p_hook_type => 'BP'
226: );
227: end;
266: ,p_time_recipient_id => p_time_recipient_id
267: ,p_effective_date => p_effective_date
268: );
269: exception
270: when hr_api.cannot_find_prog_unit then
271: hr_api.cannot_find_prog_unit_error
272: (p_module_name => 'update_data_app_rule_usages'
273: ,p_hook_type => 'AP'
274: );
267: ,p_effective_date => p_effective_date
268: );
269: exception
270: when hr_api.cannot_find_prog_unit then
271: hr_api.cannot_find_prog_unit_error
272: (p_module_name => 'update_data_app_rule_usages'
273: ,p_hook_type => 'AP'
274: );
275: end;
283: --
284: -- When in validation only mode raise the Validate_Enabled exception
285: --
286: if p_validate then
287: raise hr_api.validate_enabled;
288: end if;
289: --
290: if g_debug then
291: hr_utility.set_location(' Leaving:'||l_proc, 60);
302: --commit;
303:
304: exception
305: --
306: when hr_api.validate_enabled then
307: --
308: -- As the Validate_Enabled exception has been raised
309: -- we must rollback to the savepoint
310: --
373: (p_data_app_rule_usage_id => p_data_app_rule_usage_id
374: ,p_object_version_number => p_object_version_number
375: );
376: exception
377: when hr_api.cannot_find_prog_unit then
378: hr_api.cannot_find_prog_unit_error
379: (p_module_name => 'delete_data_app_rule_usages'
380: ,p_hook_type => 'BP'
381: );
374: ,p_object_version_number => p_object_version_number
375: );
376: exception
377: when hr_api.cannot_find_prog_unit then
378: hr_api.cannot_find_prog_unit_error
379: (p_module_name => 'delete_data_app_rule_usages'
380: ,p_hook_type => 'BP'
381: );
382: end;
405: (p_data_app_rule_usage_id => p_data_app_rule_usage_id
406: ,p_object_version_number => p_object_version_number
407: );
408: exception
409: when hr_api.cannot_find_prog_unit then
410: hr_api.cannot_find_prog_unit_error
411: (p_module_name => 'delete_data_app_rule_usages'
412: ,p_hook_type => 'AP'
413: );
406: ,p_object_version_number => p_object_version_number
407: );
408: exception
409: when hr_api.cannot_find_prog_unit then
410: hr_api.cannot_find_prog_unit_error
411: (p_module_name => 'delete_data_app_rule_usages'
412: ,p_hook_type => 'AP'
413: );
414: end;
415: --
416: -- When in validation only mode raise the Validate_Enabled exception
417: --
418: if p_validate then
419: raise hr_api.validate_enabled;
420: end if;
421: --
422: if g_debug then
423: hr_utility.set_location(' Leaving:'||l_proc, 50);
424: end if;
425: --
426: exception
427: --
428: when hr_api.validate_enabled then
429: --
430: -- As the Validate_Enabled exception has been raised
431: -- we must rollback to the savepoint
432: --