58: ,p_recurring_period_id => p_recurring_period_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_approval_period_comps'
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_approval_period_comps'
65: ,p_hook_type => 'BP'
66: );
67: end;
110: ,p_recurring_period_id => p_recurring_period_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_approval_period_comps'
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_approval_period_comps'
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_recurring_period_id => p_recurring_period_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_approval_period_comps'
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_approval_period_comps'
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_approval_period_comps'
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_approval_period_comps'
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: --
372: (p_approval_period_comp_id => p_approval_period_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_approval_period_comps'
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_approval_period_comps'
379: ,p_hook_type => 'BP'
380: );
381: end;
404: (p_approval_period_comp_id => p_approval_period_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_approval_period_comps'
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_approval_period_comps'
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: --