49: ,p_object_version_number => p_object_version_number
50: ,p_name => p_name
51: );
52: exception
53: when hr_api.cannot_find_prog_unit then
54: hr_api.cannot_find_prog_unit_error
55: (p_module_name => 'create_fld_mapping'
56: ,p_hook_type => 'BP'
57: );
50: ,p_name => p_name
51: );
52: exception
53: when hr_api.cannot_find_prog_unit then
54: hr_api.cannot_find_prog_unit_error
55: (p_module_name => 'create_fld_mapping'
56: ,p_hook_type => 'BP'
57: );
58: end;
87: ,p_object_version_number => l_object_version_number
88: ,p_name => p_name
89: );
90: exception
91: when hr_api.cannot_find_prog_unit then
92: hr_api.cannot_find_prog_unit_error
93: (p_module_name => 'create_fld_mapping'
94: ,p_hook_type => 'AP'
95: );
88: ,p_name => p_name
89: );
90: exception
91: when hr_api.cannot_find_prog_unit then
92: hr_api.cannot_find_prog_unit_error
93: (p_module_name => 'create_fld_mapping'
94: ,p_hook_type => 'AP'
95: );
96: end;
101: --
102: -- When in validation only mode raise the Validate_Enabled exception
103: --
104: if p_validate then
105: raise hr_api.validate_enabled;
106: end if;
107: --
108: if g_debug then
109: hr_utility.set_location(' Leaving:'||l_proc, 70);
115: p_object_version_number := l_object_version_number;
116: --
117: exception
118: --
119: when hr_api.validate_enabled then
120: --
121: -- As the Validate_Enabled exception has been raised
122: -- we must rollback to the savepoint
123: --
186: ,p_object_version_number => p_object_version_number
187: ,p_name => p_name
188: );
189: exception
190: when hr_api.cannot_find_prog_unit then
191: hr_api.cannot_find_prog_unit_error
192: (p_module_name => 'update_fld_mapping'
193: ,p_hook_type => 'BP'
194: );
187: ,p_name => p_name
188: );
189: exception
190: when hr_api.cannot_find_prog_unit then
191: hr_api.cannot_find_prog_unit_error
192: (p_module_name => 'update_fld_mapping'
193: ,p_hook_type => 'BP'
194: );
195: end;
220: ,p_object_version_number => l_object_version_number
221: ,p_name => p_name
222: );
223: exception
224: when hr_api.cannot_find_prog_unit then
225: hr_api.cannot_find_prog_unit_error
226: (p_module_name => 'update_fld_mapping'
227: ,p_hook_type => 'AP'
228: );
221: ,p_name => p_name
222: );
223: exception
224: when hr_api.cannot_find_prog_unit then
225: hr_api.cannot_find_prog_unit_error
226: (p_module_name => 'update_fld_mapping'
227: ,p_hook_type => 'AP'
228: );
229: end;
234: --
235: -- When in validation only mode raise the Validate_Enabled exception
236: --
237: if p_validate then
238: raise hr_api.validate_enabled;
239: end if;
240: --
241: if g_debug then
242: hr_utility.set_location(' Leaving:'||l_proc, 60);
247: p_object_version_number := l_object_version_number;
248: --
249: exception
250: --
251: when hr_api.validate_enabled then
252: --
253: -- As the Validate_Enabled exception has been raised
254: -- we must rollback to the savepoint
255: --
315: (p_mapping_id => p_mapping_id
316: ,p_object_version_number => p_object_version_number
317: );
318: exception
319: when hr_api.cannot_find_prog_unit then
320: hr_api.cannot_find_prog_unit_error
321: (p_module_name => 'delete_fld_mapping_b'
322: ,p_hook_type => 'BP'
323: );
316: ,p_object_version_number => p_object_version_number
317: );
318: exception
319: when hr_api.cannot_find_prog_unit then
320: hr_api.cannot_find_prog_unit_error
321: (p_module_name => 'delete_fld_mapping_b'
322: ,p_hook_type => 'BP'
323: );
324: end;
347: (p_mapping_id => p_mapping_id
348: ,p_object_version_number => p_object_version_number
349: );
350: exception
351: when hr_api.cannot_find_prog_unit then
352: hr_api.cannot_find_prog_unit_error
353: (p_module_name => 'delete_fld_mapping_a'
354: ,p_hook_type => 'AP'
355: );
348: ,p_object_version_number => p_object_version_number
349: );
350: exception
351: when hr_api.cannot_find_prog_unit then
352: hr_api.cannot_find_prog_unit_error
353: (p_module_name => 'delete_fld_mapping_a'
354: ,p_hook_type => 'AP'
355: );
356: end;
357: --
358: -- When in validation only mode raise the Validate_Enabled exception
359: --
360: if p_validate then
361: raise hr_api.validate_enabled;
362: end if;
363: --
364: if g_debug then
365: hr_utility.set_location(' Leaving:'||l_proc, 50);
366: end if;
367: --
368: exception
369: --
370: when hr_api.validate_enabled then
371: --
372: -- As the Validate_Enabled exception has been raised
373: -- we must rollback to the savepoint
374: --