56: ,p_object_version_number => p_object_version_number
57: ,p_name => p_name
58: );
59: exception
60: when hr_api.cannot_find_prog_unit then
61: hr_api.cannot_find_prog_unit_error
62: (p_module_name => 'create_retrieval_rule_grp'
63: ,p_hook_type => 'BP'
64: );
57: ,p_name => p_name
58: );
59: exception
60: when hr_api.cannot_find_prog_unit then
61: hr_api.cannot_find_prog_unit_error
62: (p_module_name => 'create_retrieval_rule_grp'
63: ,p_hook_type => 'BP'
64: );
65: end;
95: ,p_object_version_number => l_object_version_number
96: ,p_name => p_name
97: );
98: exception
99: when hr_api.cannot_find_prog_unit then
100: hr_api.cannot_find_prog_unit_error
101: (p_module_name => 'create_retrieval_rule_grp'
102: ,p_hook_type => 'AP'
103: );
96: ,p_name => p_name
97: );
98: exception
99: when hr_api.cannot_find_prog_unit then
100: hr_api.cannot_find_prog_unit_error
101: (p_module_name => 'create_retrieval_rule_grp'
102: ,p_hook_type => 'AP'
103: );
104: end;
109: --
110: -- When in validation only mode raise the Validate_Enabled exception
111: --
112: if p_validate then
113: raise hr_api.validate_enabled;
114: end if;
115: --
116: if g_debug then
117: hr_utility.set_location(' Leaving:'||l_proc, 70);
123: p_object_version_number := l_object_version_number;
124: --
125: exception
126: --
127: when hr_api.validate_enabled then
128: --
129: -- As the Validate_Enabled exception has been raised
130: -- we must rollback to the savepoint
131: --
198: ,p_object_version_number => p_object_version_number
199: ,p_name => p_name
200: );
201: exception
202: when hr_api.cannot_find_prog_unit then
203: hr_api.cannot_find_prog_unit_error
204: (p_module_name => 'update_retrieval_rule_grp'
205: ,p_hook_type => 'BP'
206: );
199: ,p_name => p_name
200: );
201: exception
202: when hr_api.cannot_find_prog_unit then
203: hr_api.cannot_find_prog_unit_error
204: (p_module_name => 'update_retrieval_rule_grp'
205: ,p_hook_type => 'BP'
206: );
207: end;
233: ,p_object_version_number => l_object_version_number
234: ,p_name => p_name
235: );
236: exception
237: when hr_api.cannot_find_prog_unit then
238: hr_api.cannot_find_prog_unit_error
239: (p_module_name => 'update_retrieval_rule_grp'
240: ,p_hook_type => 'AP'
241: );
234: ,p_name => p_name
235: );
236: exception
237: when hr_api.cannot_find_prog_unit then
238: hr_api.cannot_find_prog_unit_error
239: (p_module_name => 'update_retrieval_rule_grp'
240: ,p_hook_type => 'AP'
241: );
242: end;
247: --
248: -- When in validation only mode raise the Validate_Enabled exception
249: --
250: if p_validate then
251: raise hr_api.validate_enabled;
252: end if;
253: --
254: if g_debug then
255: hr_utility.set_location(' Leaving:'||l_proc, 60);
260: p_object_version_number := l_object_version_number;
261: --
262: exception
263: --
264: when hr_api.validate_enabled then
265: --
266: -- As the Validate_Enabled exception has been raised
267: -- we must rollback to the savepoint
268: --
331: (p_retrieval_rule_grp_id => p_retrieval_rule_grp_id
332: ,p_object_version_number => p_object_version_number
333: );
334: exception
335: when hr_api.cannot_find_prog_unit then
336: hr_api.cannot_find_prog_unit_error
337: (p_module_name => 'delete_retrieval_rule_grp_b'
338: ,p_hook_type => 'BP'
339: );
332: ,p_object_version_number => p_object_version_number
333: );
334: exception
335: when hr_api.cannot_find_prog_unit then
336: hr_api.cannot_find_prog_unit_error
337: (p_module_name => 'delete_retrieval_rule_grp_b'
338: ,p_hook_type => 'BP'
339: );
340: end;
363: (p_retrieval_rule_grp_id => p_retrieval_rule_grp_id
364: ,p_object_version_number => p_object_version_number
365: );
366: exception
367: when hr_api.cannot_find_prog_unit then
368: hr_api.cannot_find_prog_unit_error
369: (p_module_name => 'delete_retrieval_rule_grp_a'
370: ,p_hook_type => 'AP'
371: );
364: ,p_object_version_number => p_object_version_number
365: );
366: exception
367: when hr_api.cannot_find_prog_unit then
368: hr_api.cannot_find_prog_unit_error
369: (p_module_name => 'delete_retrieval_rule_grp_a'
370: ,p_hook_type => 'AP'
371: );
372: end;
373: --
374: -- When in validation only mode raise the Validate_Enabled exception
375: --
376: if p_validate then
377: raise hr_api.validate_enabled;
378: end if;
379: --
380: if g_debug then
381: hr_utility.set_location(' Leaving:'||l_proc, 50);
382: end if;
383: --
384: exception
385: --
386: when hr_api.validate_enabled then
387: --
388: -- As the Validate_Enabled exception has been raised
389: -- we must rollback to the savepoint
390: --