53: ,p_name => p_name
54: -- ,p_effective_date => p_effective_date
55: );
56: exception
57: when hr_api.cannot_find_prog_unit then
58: hr_api.cannot_find_prog_unit_error
59: (p_module_name => 'create_approval_period_sets'
60: ,p_hook_type => 'BP'
61: );
54: -- ,p_effective_date => p_effective_date
55: );
56: exception
57: when hr_api.cannot_find_prog_unit then
58: hr_api.cannot_find_prog_unit_error
59: (p_module_name => 'create_approval_period_sets'
60: ,p_hook_type => 'BP'
61: );
62: end;
100: ,p_name => p_name
101: -- ,p_effective_date => p_effective_date
102: );
103: exception
104: when hr_api.cannot_find_prog_unit then
105: hr_api.cannot_find_prog_unit_error
106: (p_module_name => 'create_approval_perriod_sets'
107: ,p_hook_type => 'AP'
108: );
101: -- ,p_effective_date => p_effective_date
102: );
103: exception
104: when hr_api.cannot_find_prog_unit then
105: hr_api.cannot_find_prog_unit_error
106: (p_module_name => 'create_approval_perriod_sets'
107: ,p_hook_type => 'AP'
108: );
109: end;
115: --
116: -- When in validation only mode raise the Validate_Enabled exception
117: --
118: if p_validate then
119: raise hr_api.validate_enabled;
120: end if;
121: --
122: --if g_debug then
123: --hr_utility.set_location(' Leaving:'||l_proc, 70);
132: if g_debug then
133: hr_utility.set_location(' Leaving:'||l_proc, 70);
134: end if;
135: exception
136: when hr_api.validate_enabled then
137: --
138: -- As the Validate_Enabled exception has been raised
139: -- we must rollback to the savepoint
140: --
204: ,p_name => p_name
205: -- ,p_effective_date => p_effective_date
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_approval_period_sets'
211: ,p_hook_type => 'BP'
212: );
205: -- ,p_effective_date => p_effective_date
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_approval_period_sets'
211: ,p_hook_type => 'BP'
212: );
213: end;
240: ,p_name => p_name
241: -- ,p_effective_date => p_effective_date
242: );
243: exception
244: when hr_api.cannot_find_prog_unit then
245: hr_api.cannot_find_prog_unit_error
246: (p_module_name => 'update_approval_period_sets'
247: ,p_hook_type => 'AP'
248: );
241: -- ,p_effective_date => p_effective_date
242: );
243: exception
244: when hr_api.cannot_find_prog_unit then
245: hr_api.cannot_find_prog_unit_error
246: (p_module_name => 'update_approval_period_sets'
247: ,p_hook_type => 'AP'
248: );
249: end;
254: --
255: -- When in validation only mode raise the Validate_Enabled exception
256: --
257: if p_validate then
258: raise hr_api.validate_enabled;
259: end if;
260: --
261: if g_debug then
262: hr_utility.set_location(' Leaving:'||l_proc, 60);
267: p_object_version_number := l_object_version_number;
268: --
269: exception
270: --
271: when hr_api.validate_enabled then
272: --
273: -- As the Validate_Enabled exception has been raised
274: -- we must rollback to the savepoint
275: --
335: (p_approval_period_set_id => p_approval_period_set_id
336: ,p_object_version_number => p_object_version_number
337: );
338: exception
339: when hr_api.cannot_find_prog_unit then
340: hr_api.cannot_find_prog_unit_error
341: (p_module_name => 'delete_approval_period_sets'
342: ,p_hook_type => 'BP'
343: );
336: ,p_object_version_number => p_object_version_number
337: );
338: exception
339: when hr_api.cannot_find_prog_unit then
340: hr_api.cannot_find_prog_unit_error
341: (p_module_name => 'delete_approval_period_sets'
342: ,p_hook_type => 'BP'
343: );
344: end;
367: (p_approval_period_set_id => p_approval_period_set_id
368: ,p_object_version_number => p_object_version_number
369: );
370: exception
371: when hr_api.cannot_find_prog_unit then
372: hr_api.cannot_find_prog_unit_error
373: (p_module_name => 'delete_approval_period_sets'
374: ,p_hook_type => 'AP'
375: );
368: ,p_object_version_number => p_object_version_number
369: );
370: exception
371: when hr_api.cannot_find_prog_unit then
372: hr_api.cannot_find_prog_unit_error
373: (p_module_name => 'delete_approval_period_sets'
374: ,p_hook_type => 'AP'
375: );
376: end;
377: --
378: -- When in validation only mode raise the Validate_Enabled exception
379: --
380: if p_validate then
381: raise hr_api.validate_enabled;
382: end if;
383: --
384: if g_debug then
385: hr_utility.set_location(' Leaving:'||l_proc, 50);
386: end if;
387: --
388: exception
389: --
390: when hr_api.validate_enabled then
391: --
392: -- As the Validate_Enabled exception has been raised
393: -- we must rollback to the savepoint
394: --