51: ,p_mapping_id => p_mapping_id
52: ,p_mapping_component_id => p_mapping_component_id
53: );
54: exception
55: when hr_api.cannot_find_prog_unit then
56: hr_api.cannot_find_prog_unit_error
57: (p_module_name => 'create_mapping_comp_usage'
58: ,p_hook_type => 'BP'
59: );
52: ,p_mapping_component_id => p_mapping_component_id
53: );
54: exception
55: when hr_api.cannot_find_prog_unit then
56: hr_api.cannot_find_prog_unit_error
57: (p_module_name => 'create_mapping_comp_usage'
58: ,p_hook_type => 'BP'
59: );
60: end;
91: ,p_mapping_id => p_mapping_id
92: ,p_mapping_component_id => p_mapping_component_id
93: );
94: exception
95: when hr_api.cannot_find_prog_unit then
96: hr_api.cannot_find_prog_unit_error
97: (p_module_name => 'create_mapping_comp_usage'
98: ,p_hook_type => 'AP'
99: );
92: ,p_mapping_component_id => p_mapping_component_id
93: );
94: exception
95: when hr_api.cannot_find_prog_unit then
96: hr_api.cannot_find_prog_unit_error
97: (p_module_name => 'create_mapping_comp_usage'
98: ,p_hook_type => 'AP'
99: );
100: end;
105: --
106: -- When in validation only mode raise the Validate_Enabled exception
107: --
108: if p_validate then
109: raise hr_api.validate_enabled;
110: end if;
111: --
112: if g_debug then
113: hr_utility.set_location(' Leaving:'||l_proc, 70);
119: p_object_version_number := l_object_version_number;
120: --
121: exception
122: --
123: when hr_api.validate_enabled then
124: --
125: -- As the Validate_Enabled exception has been raised
126: -- we must rollback to the savepoint
127: --
193: ,p_mapping_id => p_mapping_id
194: ,p_mapping_component_id => p_mapping_component_id
195: );
196: exception
197: when hr_api.cannot_find_prog_unit then
198: hr_api.cannot_find_prog_unit_error
199: (p_module_name => 'update_mapping_comp_usage'
200: ,p_hook_type => 'BP'
201: );
194: ,p_mapping_component_id => p_mapping_component_id
195: );
196: exception
197: when hr_api.cannot_find_prog_unit then
198: hr_api.cannot_find_prog_unit_error
199: (p_module_name => 'update_mapping_comp_usage'
200: ,p_hook_type => 'BP'
201: );
202: end;
228: ,p_mapping_id => p_mapping_id
229: ,p_mapping_component_id => p_mapping_component_id
230: );
231: exception
232: when hr_api.cannot_find_prog_unit then
233: hr_api.cannot_find_prog_unit_error
234: (p_module_name => 'update_mapping_comp_usage'
235: ,p_hook_type => 'AP'
236: );
229: ,p_mapping_component_id => p_mapping_component_id
230: );
231: exception
232: when hr_api.cannot_find_prog_unit then
233: hr_api.cannot_find_prog_unit_error
234: (p_module_name => 'update_mapping_comp_usage'
235: ,p_hook_type => 'AP'
236: );
237: end;
242: --
243: -- When in validation only mode raise the Validate_Enabled exception
244: --
245: if p_validate then
246: raise hr_api.validate_enabled;
247: end if;
248: --
249: if g_debug then
250: hr_utility.set_location(' Leaving:'||l_proc, 60);
255: p_object_version_number := l_object_version_number;
256: --
257: exception
258: --
259: when hr_api.validate_enabled then
260: --
261: -- As the Validate_Enabled exception has been raised
262: -- we must rollback to the savepoint
263: --
324: (p_mapping_comp_usage_id => p_mapping_comp_usage_id
325: ,p_object_version_number => p_object_version_number
326: );
327: exception
328: when hr_api.cannot_find_prog_unit then
329: hr_api.cannot_find_prog_unit_error
330: (p_module_name => 'delete_mapping_comp_usage_b'
331: ,p_hook_type => 'BP'
332: );
325: ,p_object_version_number => p_object_version_number
326: );
327: exception
328: when hr_api.cannot_find_prog_unit then
329: hr_api.cannot_find_prog_unit_error
330: (p_module_name => 'delete_mapping_comp_usage_b'
331: ,p_hook_type => 'BP'
332: );
333: end;
356: (p_mapping_comp_usage_id => p_mapping_comp_usage_id
357: ,p_object_version_number => p_object_version_number
358: );
359: exception
360: when hr_api.cannot_find_prog_unit then
361: hr_api.cannot_find_prog_unit_error
362: (p_module_name => 'delete_mapping_comp_usage_a'
363: ,p_hook_type => 'AP'
364: );
357: ,p_object_version_number => p_object_version_number
358: );
359: exception
360: when hr_api.cannot_find_prog_unit then
361: hr_api.cannot_find_prog_unit_error
362: (p_module_name => 'delete_mapping_comp_usage_a'
363: ,p_hook_type => 'AP'
364: );
365: end;
366: --
367: -- When in validation only mode raise the Validate_Enabled exception
368: --
369: if p_validate then
370: raise hr_api.validate_enabled;
371: end if;
372: --
373: if g_debug then
374: hr_utility.set_location(' Leaving:'||l_proc, 50);
375: end if;
376: --
377: exception
378: --
379: when hr_api.validate_enabled then
380: --
381: -- As the Validate_Enabled exception has been raised
382: -- we must rollback to the savepoint
383: --