54: ,p_object_version_number => p_object_version_number
55: ,p_name => p_name
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_application_set'
61: ,p_hook_type => 'BP'
62: );
55: ,p_name => p_name
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_application_set'
61: ,p_hook_type => 'BP'
62: );
63: end;
93: ,p_object_version_number => l_object_version_number
94: ,p_name => p_name
95: );
96: exception
97: when hr_api.cannot_find_prog_unit then
98: hr_api.cannot_find_prog_unit_error
99: (p_module_name => 'create_application_set'
100: ,p_hook_type => 'AP'
101: );
94: ,p_name => p_name
95: );
96: exception
97: when hr_api.cannot_find_prog_unit then
98: hr_api.cannot_find_prog_unit_error
99: (p_module_name => 'create_application_set'
100: ,p_hook_type => 'AP'
101: );
102: end;
107: --
108: -- When in validation only mode raise the Validate_Enabled exception
109: --
110: if p_validate then
111: raise hr_api.validate_enabled;
112: end if;
113: --
114: if g_debug then
115: hr_utility.set_location(' Leaving:'||l_proc, 70);
121: p_object_version_number := l_object_version_number;
122: --
123: exception
124: --
125: when hr_api.validate_enabled then
126: --
127: -- As the Validate_Enabled exception has been raised
128: -- we must rollback to the savepoint
129: --
196: ,p_object_version_number => p_object_version_number
197: ,p_name => p_name
198: );
199: exception
200: when hr_api.cannot_find_prog_unit then
201: hr_api.cannot_find_prog_unit_error
202: (p_module_name => 'update_application_set'
203: ,p_hook_type => 'BP'
204: );
197: ,p_name => p_name
198: );
199: exception
200: when hr_api.cannot_find_prog_unit then
201: hr_api.cannot_find_prog_unit_error
202: (p_module_name => 'update_application_set'
203: ,p_hook_type => 'BP'
204: );
205: end;
231: ,p_object_version_number => l_object_version_number
232: ,p_name => p_name
233: );
234: exception
235: when hr_api.cannot_find_prog_unit then
236: hr_api.cannot_find_prog_unit_error
237: (p_module_name => 'update_application_set'
238: ,p_hook_type => 'AP'
239: );
232: ,p_name => p_name
233: );
234: exception
235: when hr_api.cannot_find_prog_unit then
236: hr_api.cannot_find_prog_unit_error
237: (p_module_name => 'update_application_set'
238: ,p_hook_type => 'AP'
239: );
240: end;
245: --
246: -- When in validation only mode raise the Validate_Enabled exception
247: --
248: if p_validate then
249: raise hr_api.validate_enabled;
250: end if;
251: --
252: if g_debug then
253: hr_utility.set_location(' Leaving:'||l_proc, 60);
258: p_object_version_number := l_object_version_number;
259: --
260: exception
261: --
262: when hr_api.validate_enabled then
263: --
264: -- As the Validate_Enabled exception has been raised
265: -- we must rollback to the savepoint
266: --
329: (p_application_set_id => p_application_set_id
330: ,p_object_version_number => p_object_version_number
331: );
332: exception
333: when hr_api.cannot_find_prog_unit then
334: hr_api.cannot_find_prog_unit_error
335: (p_module_name => 'delete_application_set_b'
336: ,p_hook_type => 'BP'
337: );
330: ,p_object_version_number => p_object_version_number
331: );
332: exception
333: when hr_api.cannot_find_prog_unit then
334: hr_api.cannot_find_prog_unit_error
335: (p_module_name => 'delete_application_set_b'
336: ,p_hook_type => 'BP'
337: );
338: end;
361: (p_application_set_id => p_application_set_id
362: ,p_object_version_number => p_object_version_number
363: );
364: exception
365: when hr_api.cannot_find_prog_unit then
366: hr_api.cannot_find_prog_unit_error
367: (p_module_name => 'delete_application_set_a'
368: ,p_hook_type => 'AP'
369: );
362: ,p_object_version_number => p_object_version_number
363: );
364: exception
365: when hr_api.cannot_find_prog_unit then
366: hr_api.cannot_find_prog_unit_error
367: (p_module_name => 'delete_application_set_a'
368: ,p_hook_type => 'AP'
369: );
370: end;
371: --
372: -- When in validation only mode raise the Validate_Enabled exception
373: --
374: if p_validate then
375: raise hr_api.validate_enabled;
376: end if;
377: --
378: if g_debug then
379: hr_utility.set_location(' Leaving:'||l_proc, 50);
380: end if;
381: --
382: exception
383: --
384: when hr_api.validate_enabled then
385: --
386: -- As the Validate_Enabled exception has been raised
387: -- we must rollback to the savepoint
388: --