58: ,p_adr_offered => p_adr_offered
59: ,p_date_accepted => p_date_accepted
60: );
61: exception
62: when hr_api.cannot_find_prog_unit then
63: hr_api.cannot_find_prog_unit_error
64: (p_module_name => 'create_compl_adr'
65: ,p_hook_type => 'BP'
66: );
59: ,p_date_accepted => p_date_accepted
60: );
61: exception
62: when hr_api.cannot_find_prog_unit then
63: hr_api.cannot_find_prog_unit_error
64: (p_module_name => 'create_compl_adr'
65: ,p_hook_type => 'BP'
66: );
67: end;
107: ,p_compl_adr_id => l_compl_adr_id
108: ,p_object_version_number => l_object_version_number
109: );
110: exception
111: when hr_api.cannot_find_prog_unit then
112: hr_api.cannot_find_prog_unit_error
113: (p_module_name => 'create_compl_adr'
114: ,p_hook_type => 'AP'
115: );
108: ,p_object_version_number => l_object_version_number
109: );
110: exception
111: when hr_api.cannot_find_prog_unit then
112: hr_api.cannot_find_prog_unit_error
113: (p_module_name => 'create_compl_adr'
114: ,p_hook_type => 'AP'
115: );
116: end;
119: --
120: -- When in validation only mode raise the Validate_Enabled exception
121: --
122: if p_validate then
123: raise hr_api.validate_enabled;
124: end if;
125: --
126: -- Set all output arguments
127: --
129: p_object_version_number := l_object_version_number;
130: --
131: hr_utility.set_location(' Leaving:'||l_proc, 70);
132: exception
133: when hr_api.validate_enabled then
134: --
135: -- As the Validate_Enabled exception has been raised
136: -- we must rollback to the savepoint
137: --
204: ,p_date_accepted => p_date_accepted
205: ,p_object_version_number => l_object_version_number
206: );
207: exception
208: when hr_api.cannot_find_prog_unit then
209: hr_api.cannot_find_prog_unit_error
210: (p_module_name => 'Update_compl_adr'
211: ,p_hook_type => 'BP'
212: );
205: ,p_object_version_number => l_object_version_number
206: );
207: exception
208: when hr_api.cannot_find_prog_unit then
209: hr_api.cannot_find_prog_unit_error
210: (p_module_name => 'Update_compl_adr'
211: ,p_hook_type => 'BP'
212: );
213: end;
252: ,p_compl_adr_id => p_compl_adr_id
253: ,p_object_version_number => l_object_version_number
254: );
255: exception
256: when hr_api.cannot_find_prog_unit then
257: hr_api.cannot_find_prog_unit_error
258: (p_module_name => 'Update_compl_adr'
259: ,p_hook_type => 'AP'
260: );
253: ,p_object_version_number => l_object_version_number
254: );
255: exception
256: when hr_api.cannot_find_prog_unit then
257: hr_api.cannot_find_prog_unit_error
258: (p_module_name => 'Update_compl_adr'
259: ,p_hook_type => 'AP'
260: );
261: end;
262: --
263: -- When in validation only mode raise the Validate_Enabled exception
264: --
265: if p_validate then
266: raise hr_api.validate_enabled;
267: end if;
268: --
269: -- Set all output arguments
270: --
271: p_object_version_number := l_object_version_number;
272: --
273: hr_utility.set_location(' Leaving:'||l_proc, 70);
274: exception
275: when hr_api.validate_enabled then
276: --
277: -- As the Validate_Enabled exception has been raised
278: -- we must rollback to the savepoint
279: --
327: (p_compl_adr_id => p_compl_adr_id
328: ,p_object_version_number => p_object_version_number
329: );
330: exception
331: when hr_api.cannot_find_prog_unit then
332: hr_api.cannot_find_prog_unit_error
333: (p_module_name => 'delete_compl_adr'
334: ,p_hook_type => 'BP'
335: );
328: ,p_object_version_number => p_object_version_number
329: );
330: exception
331: when hr_api.cannot_find_prog_unit then
332: hr_api.cannot_find_prog_unit_error
333: (p_module_name => 'delete_compl_adr'
334: ,p_hook_type => 'BP'
335: );
336: end;
351: (p_compl_adr_id => p_compl_adr_id
352: ,p_object_version_number => p_object_version_number
353: );
354: exception
355: when hr_api.cannot_find_prog_unit then
356: hr_api.cannot_find_prog_unit_error
357: (p_module_name => 'delete_compl_adr'
358: ,p_hook_type => 'AP'
359: );
352: ,p_object_version_number => p_object_version_number
353: );
354: exception
355: when hr_api.cannot_find_prog_unit then
356: hr_api.cannot_find_prog_unit_error
357: (p_module_name => 'delete_compl_adr'
358: ,p_hook_type => 'AP'
359: );
360: end;
361: --
362: -- When in validation only mode raise the Validate_Enabled exception
363: --
364: if p_validate then
365: raise hr_api.validate_enabled;
366: end if;
367: --
368: hr_utility.set_location(' Leaving:'||l_proc, 11);
369: exception
366: end if;
367: --
368: hr_utility.set_location(' Leaving:'||l_proc, 11);
369: exception
370: when hr_api.validate_enabled then
371: -- we must rollback to the savepoint
372: --
373: ROLLBACK TO delete_compl_adr;
374: --