66: ,p_payment_type => p_payment_type
67: ,p_description => p_description
68: );
69: exception
70: when hr_api.cannot_find_prog_unit then
71: hr_api.cannot_find_prog_unit_error
72: (p_module_name => 'create_ca_detail'
73: ,p_hook_type => 'BP'
74: );
67: ,p_description => p_description
68: );
69: exception
70: when hr_api.cannot_find_prog_unit then
71: hr_api.cannot_find_prog_unit_error
72: (p_module_name => 'create_ca_detail'
73: ,p_hook_type => 'BP'
74: );
75: end;
122: ,p_compl_ca_detail_id => l_compl_ca_detail_id
123: ,p_object_version_number => l_object_version_number
124: );
125: exception
126: when hr_api.cannot_find_prog_unit then
127: hr_api.cannot_find_prog_unit_error
128: (p_module_name => 'create_ca_detail'
129: ,p_hook_type => 'AP'
130: );
123: ,p_object_version_number => l_object_version_number
124: );
125: exception
126: when hr_api.cannot_find_prog_unit then
127: hr_api.cannot_find_prog_unit_error
128: (p_module_name => 'create_ca_detail'
129: ,p_hook_type => 'AP'
130: );
131: end;
132: --
133: -- When in validation only mode raise the Validate_Enabled exception
134: --
135: if p_validate then
136: raise hr_api.validate_enabled;
137: end if;
138: --
139: -- Set all output arguments
140: --
142: p_object_version_number := l_object_version_number;
143: --
144: hr_utility.set_location(' Leaving:'||l_proc, 70);
145: exception
146: when hr_api.validate_enabled then
147: --
148: -- As the Validate_Enabled exception has been raised
149: -- we must rollback to the savepoint
150: --
223: ,p_description => p_description
224: ,p_object_version_number => p_object_version_number
225: );
226: exception
227: when hr_api.cannot_find_prog_unit then
228: hr_api.cannot_find_prog_unit_error
229: (p_module_name => 'update_ca_detail'
230: ,p_hook_type => 'BP'
231: );
224: ,p_object_version_number => p_object_version_number
225: );
226: exception
227: when hr_api.cannot_find_prog_unit then
228: hr_api.cannot_find_prog_unit_error
229: (p_module_name => 'update_ca_detail'
230: ,p_hook_type => 'BP'
231: );
232: end;
279: ,p_description => p_description
280: ,p_object_version_number => l_object_version_number
281: );
282: exception
283: when hr_api.cannot_find_prog_unit then
284: hr_api.cannot_find_prog_unit_error
285: (p_module_name => 'update_ca_detail'
286: ,p_hook_type => 'AP'
287: );
280: ,p_object_version_number => l_object_version_number
281: );
282: exception
283: when hr_api.cannot_find_prog_unit then
284: hr_api.cannot_find_prog_unit_error
285: (p_module_name => 'update_ca_detail'
286: ,p_hook_type => 'AP'
287: );
288: end;
289: --
290: -- When in validation only mode raise the Validate_Enabled exception
291: --
292: if p_validate then
293: raise hr_api.validate_enabled;
294: end if;
295: --
296: -- Set all output arguments
297: --
298: p_object_version_number := l_object_version_number;
299: --
300: hr_utility.set_location(' Leaving:'||l_proc, 70);
301: exception
302: when hr_api.validate_enabled then
303: --
304: -- As the Validate_Enabled exception has been raised
305: -- we must rollback to the savepoint
306: --
356: (p_compl_ca_detail_id => p_compl_ca_detail_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_ca_detail'
363: ,p_hook_type => 'BP'
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_ca_detail'
363: ,p_hook_type => 'BP'
364: );
365: end;
381: (p_compl_ca_detail_id => p_compl_ca_detail_id
382: ,p_object_version_number => p_object_version_number
383: );
384: exception
385: when hr_api.cannot_find_prog_unit then
386: hr_api.cannot_find_prog_unit_error
387: (p_module_name => 'delete_ca_detail'
388: ,p_hook_type => 'AP'
389: );
382: ,p_object_version_number => p_object_version_number
383: );
384: exception
385: when hr_api.cannot_find_prog_unit then
386: hr_api.cannot_find_prog_unit_error
387: (p_module_name => 'delete_ca_detail'
388: ,p_hook_type => 'AP'
389: );
390: end;
391: --
392: -- When in validation only mode raise the Validate_Enabled exception
393: --
394: if p_validate then
395: raise hr_api.validate_enabled;
396: end if;
397: --
398: hr_utility.set_location(' Leaving:'||l_proc, 11);
399: exception
396: end if;
397: --
398: hr_utility.set_location(' Leaving:'||l_proc, 11);
399: exception
400: when hr_api.validate_enabled then
401: -- we must rollback to the savepoint
402: --
403: ROLLBACK TO delete_ca_detail;
404: --