47: p_alias_type_id => p_alias_type_id,
48: p_object_version_number => p_object_version_number
49: );
50: exception
51: when hr_api.cannot_find_prog_unit then
52: hr_api.cannot_find_prog_unit_error
53: (p_module_name => 'create_alias_types'
54: ,p_hook_type => 'BP'
55: );
48: p_object_version_number => p_object_version_number
49: );
50: exception
51: when hr_api.cannot_find_prog_unit then
52: hr_api.cannot_find_prog_unit_error
53: (p_module_name => 'create_alias_types'
54: ,p_hook_type => 'BP'
55: );
56: end;
81: p_alias_type_id => p_alias_type_id,
82: p_object_version_number => p_object_version_number
83: );
84: exception
85: when hr_api.cannot_find_prog_unit then
86: hr_api.cannot_find_prog_unit_error
87: (p_module_name => 'create_alias_types'
88: ,p_hook_type => 'AP'
89: );
82: p_object_version_number => p_object_version_number
83: );
84: exception
85: when hr_api.cannot_find_prog_unit then
86: hr_api.cannot_find_prog_unit_error
87: (p_module_name => 'create_alias_types'
88: ,p_hook_type => 'AP'
89: );
90: end;
91: --
92: -- When in validation only mode raise the Validate_Enabled exception
93: --
94: if p_validate then
95: raise hr_api.validate_enabled;
96: end if;
97: --
98: -- Set all output arguments
99: --
103: if g_debug then
104: hr_utility.set_location(' Leaving:'||l_proc, 70);
105: end if;
106: exception
107: when hr_api.validate_enabled then
108: --
109: -- As the Validate_Enabled exception has been raised
110: -- we must rollback to the savepoint
111: --
172: p_alias_type_id => p_alias_type_id,
173: p_object_version_number => p_object_version_number
174: );
175: exception
176: when hr_api.cannot_find_prog_unit then
177: hr_api.cannot_find_prog_unit_error
178: (p_module_name => 'create_alias_types'
179: ,p_hook_type => 'BP'
180: );
173: p_object_version_number => p_object_version_number
174: );
175: exception
176: when hr_api.cannot_find_prog_unit then
177: hr_api.cannot_find_prog_unit_error
178: (p_module_name => 'create_alias_types'
179: ,p_hook_type => 'BP'
180: );
181: end;
202: p_alias_type_id => p_alias_type_id,
203: p_object_version_number => p_object_version_number
204: );
205: exception
206: when hr_api.cannot_find_prog_unit then
207: hr_api.cannot_find_prog_unit_error
208: (p_module_name => 'update_alias_types'
209: ,p_hook_type => 'AP'
210: );
203: p_object_version_number => p_object_version_number
204: );
205: exception
206: when hr_api.cannot_find_prog_unit then
207: hr_api.cannot_find_prog_unit_error
208: (p_module_name => 'update_alias_types'
209: ,p_hook_type => 'AP'
210: );
211: end;
212: --
213: -- When in validation only mode raise the Validate_Enabled exception
214: --
215: if p_validate then
216: raise hr_api.validate_enabled;
217: end if;
218: --
219: --
220: -- Set all output arguments
224: if g_debug then
225: hr_utility.set_location(' Leaving:'||l_proc, 70);
226: end if;
227: exception
228: when hr_api.validate_enabled then
229: --
230: -- As the Validate_Enabled exception has been raised
231: -- we must rollback to the savepoint
232: --
289: (p_alias_type_id => p_alias_type_id,
290: p_object_version_number => p_object_version_number
291: );
292: exception
293: when hr_api.cannot_find_prog_unit then
294: hr_api.cannot_find_prog_unit_error
295: (p_module_name => 'delete_alias_types'
296: ,p_hook_type => 'BP'
297: );
290: p_object_version_number => p_object_version_number
291: );
292: exception
293: when hr_api.cannot_find_prog_unit then
294: hr_api.cannot_find_prog_unit_error
295: (p_module_name => 'delete_alias_types'
296: ,p_hook_type => 'BP'
297: );
298: end;
322: (p_alias_type_id => p_alias_type_id,
323: p_object_version_number => p_object_version_number
324: );
325: exception
326: when hr_api.cannot_find_prog_unit then
327: hr_api.cannot_find_prog_unit_error
328: (p_module_name => 'delete_alias_types'
329: ,p_hook_type => 'AP'
330: );
323: p_object_version_number => p_object_version_number
324: );
325: exception
326: when hr_api.cannot_find_prog_unit then
327: hr_api.cannot_find_prog_unit_error
328: (p_module_name => 'delete_alias_types'
329: ,p_hook_type => 'AP'
330: );
331: end;
335: --
336: -- When in validation only mode raise the Validate_Enabled exception
337: --
338: if p_validate then
339: raise hr_api.validate_enabled;
340: end if;
341: --
342: --
343: -- Set all output arguments
346: if g_debug then
347: hr_utility.set_location(' Leaving:'||l_proc, 70);
348: end if;
349: exception
350: when hr_api.validate_enabled then
351: --
352: -- As the Validate_Enabled exception has been raised
353: -- we must rollback to the savepoint
354: --