1: Package Body hxc_recurring_periods_api as
2: /* $Header: hxchrpapi.pkb 120.2 2005/09/23 10:43:08 sechandr noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' hxc_recurring_periods_api.';
63: ,p_end_date => p_end_date
64: ,p_effective_date => p_effective_date
65: );
66: exception
67: when hr_api.cannot_find_prog_unit then
68: hr_api.cannot_find_prog_unit_error
69: (p_module_name => 'create_recurring_periods'
70: ,p_hook_type => 'BP'
71: );
64: ,p_effective_date => p_effective_date
65: );
66: exception
67: when hr_api.cannot_find_prog_unit then
68: hr_api.cannot_find_prog_unit_error
69: (p_module_name => 'create_recurring_periods'
70: ,p_hook_type => 'BP'
71: );
72: end;
119: ,p_end_date => p_end_date
120: ,p_effective_date => p_effective_date
121: );
122: exception
123: when hr_api.cannot_find_prog_unit then
124: hr_api.cannot_find_prog_unit_error
125: (p_module_name => 'create_recurring_periods'
126: ,p_hook_type => 'AP'
127: );
120: ,p_effective_date => p_effective_date
121: );
122: exception
123: when hr_api.cannot_find_prog_unit then
124: hr_api.cannot_find_prog_unit_error
125: (p_module_name => 'create_recurring_periods'
126: ,p_hook_type => 'AP'
127: );
128: end;
134: --
135: -- When in validation only mode raise the Validate_Enabled exception
136: --
137: if p_validate then
138: raise hr_api.validate_enabled;
139: end if;
140: --
141: --if g_debug then
142: --hr_utility.set_location(' Leaving:'||l_proc, 70);
151: if g_debug then
152: hr_utility.set_location(' Leaving:'||l_proc, 70);
153: end if;
154: exception
155: when hr_api.validate_enabled then
156: --
157: -- As the Validate_Enabled exception has been raised
158: -- we must rollback to the savepoint
159: --
232: ,p_duration_in_days => p_duration_in_days
233: ,p_effective_date => p_effective_date
234: );
235: exception
236: when hr_api.cannot_find_prog_unit then
237: hr_api.cannot_find_prog_unit_error
238: (p_module_name => 'update_recurring_periods'
239: ,p_hook_type => 'BP'
240: );
233: ,p_effective_date => p_effective_date
234: );
235: exception
236: when hr_api.cannot_find_prog_unit then
237: hr_api.cannot_find_prog_unit_error
238: (p_module_name => 'update_recurring_periods'
239: ,p_hook_type => 'BP'
240: );
241: end;
286: ,p_end_date => p_end_date
287: ,p_effective_date => p_effective_date
288: );
289: exception
290: when hr_api.cannot_find_prog_unit then
291: hr_api.cannot_find_prog_unit_error
292: (p_module_name => 'update_recurring_periods'
293: ,p_hook_type => 'AP'
294: );
287: ,p_effective_date => p_effective_date
288: );
289: exception
290: when hr_api.cannot_find_prog_unit then
291: hr_api.cannot_find_prog_unit_error
292: (p_module_name => 'update_recurring_periods'
293: ,p_hook_type => 'AP'
294: );
295: end;
303: --
304: -- When in validation only mode raise the Validate_Enabled exception
305: --
306: if p_validate then
307: raise hr_api.validate_enabled;
308: end if;
309: --
310: if g_debug then
311: hr_utility.set_location(' Leaving:'||l_proc, 60);
322: --commit;
323:
324: exception
325: --
326: when hr_api.validate_enabled then
327: --
328: -- As the Validate_Enabled exception has been raised
329: -- we must rollback to the savepoint
330: --
393: (p_recurring_period_id => p_recurring_period_id
394: ,p_object_version_number => p_object_version_number
395: );
396: exception
397: when hr_api.cannot_find_prog_unit then
398: hr_api.cannot_find_prog_unit_error
399: (p_module_name => 'delete_recurring_periods'
400: ,p_hook_type => 'BP'
401: );
394: ,p_object_version_number => p_object_version_number
395: );
396: exception
397: when hr_api.cannot_find_prog_unit then
398: hr_api.cannot_find_prog_unit_error
399: (p_module_name => 'delete_recurring_periods'
400: ,p_hook_type => 'BP'
401: );
402: end;
431: (p_recurring_period_id => p_recurring_period_id
432: ,p_object_version_number => p_object_version_number
433: );
434: exception
435: when hr_api.cannot_find_prog_unit then
436: hr_api.cannot_find_prog_unit_error
437: (p_module_name => 'delete_recurring_periods'
438: ,p_hook_type => 'AP'
439: );
432: ,p_object_version_number => p_object_version_number
433: );
434: exception
435: when hr_api.cannot_find_prog_unit then
436: hr_api.cannot_find_prog_unit_error
437: (p_module_name => 'delete_recurring_periods'
438: ,p_hook_type => 'AP'
439: );
440: end;
441: --
442: -- When in validation only mode raise the Validate_Enabled exception
443: --
444: if p_validate then
445: raise hr_api.validate_enabled;
446: end if;
447: --
448: if g_debug then
449: hr_utility.set_location(' Leaving:'||l_proc, 50);
450: end if;
451: --
452: exception
453: --
454: when hr_api.validate_enabled then
455: --
456: -- As the Validate_Enabled exception has been raised
457: -- we must rollback to the savepoint
458: --