75: );
76:
77:
78: exception
79: when hr_api.cannot_find_prog_unit then
80: hr_api.cannot_find_prog_unit_error
81: (p_module_name => 'PQH_FR_VALIDATIONS_API.Insert_Validation'
82: ,p_hook_type => 'BP'
83: );
76:
77:
78: exception
79: when hr_api.cannot_find_prog_unit then
80: hr_api.cannot_find_prog_unit_error
81: (p_module_name => 'PQH_FR_VALIDATIONS_API.Insert_Validation'
82: ,p_hook_type => 'BP'
83: );
84: end;
135: ,p_percent_of_salary => p_percent_of_salary
136: );
137:
138: exception
139: when hr_api.cannot_find_prog_unit then
140: hr_api.cannot_find_prog_unit_error
141: (p_module_name => 'PQH_FR_VALIDATIONS_API.Insert_Validation'
142: ,p_hook_type => 'AP'
143: );
136: );
137:
138: exception
139: when hr_api.cannot_find_prog_unit then
140: hr_api.cannot_find_prog_unit_error
141: (p_module_name => 'PQH_FR_VALIDATIONS_API.Insert_Validation'
142: ,p_hook_type => 'AP'
143: );
144: end;
148: -- Removed p_validate from the generated code to facilitate
149: -- writing wrappers to selfservice easily.
150: --
151: -- if p_validate then
152: -- raise hr_api.validate_enabled;
153: -- end if;
154: --
155: -- Set all output arguments
156: --
160:
161: --
162: hr_utility.set_location(' Leaving:'||l_proc, 70);
163: exception
164: when hr_api.validate_enabled then
165: --
166: -- As the Validate_Enabled exception has been raised
167: -- we must rollback to the savepoint
168: --
255: ,p_percent_of_salary => p_percent_of_salary
256: );
257:
258: exception
259: when hr_api.cannot_find_prog_unit then
260: hr_api.cannot_find_prog_unit_error
261: (p_module_name => 'Update_Validation'
262: ,p_hook_type => 'BP'
263: );
256: );
257:
258: exception
259: when hr_api.cannot_find_prog_unit then
260: hr_api.cannot_find_prog_unit_error
261: (p_module_name => 'Update_Validation'
262: ,p_hook_type => 'BP'
263: );
264: end;
316:
317: );
318:
319: exception
320: when hr_api.cannot_find_prog_unit then
321: hr_api.cannot_find_prog_unit_error
322: (p_module_name => 'Update_Validation'
323: ,p_hook_type => 'AP'
324: );
317: );
318:
319: exception
320: when hr_api.cannot_find_prog_unit then
321: hr_api.cannot_find_prog_unit_error
322: (p_module_name => 'Update_Validation'
323: ,p_hook_type => 'AP'
324: );
325: end;
326: --
327: -- When in validation only mode raise the Validate_Enabled exception
328: --
329: -- if p_validate then
330: -- raise hr_api.validate_enabled;
331: -- end if;
332: --
333: -- Set all output arguments
334: --
337:
338: --
339: hr_utility.set_location(' Leaving:'||l_proc, 70);
340: exception
341: when hr_api.validate_enabled then
342: --
343: -- As the Validate_Enabled exception has been raised
344: -- we must rollback to the savepoint
345: --
390: p_validation_id => p_validation_id
391: ,p_object_version_number => p_object_version_number
392: );
393: exception
394: when hr_api.cannot_find_prog_unit then
395: hr_api.cannot_find_prog_unit_error
396: (p_module_name => 'delete_Validation'
397: ,p_hook_type => 'BP');
398: end;
391: ,p_object_version_number => p_object_version_number
392: );
393: exception
394: when hr_api.cannot_find_prog_unit then
395: hr_api.cannot_find_prog_unit_error
396: (p_module_name => 'delete_Validation'
397: ,p_hook_type => 'BP');
398: end;
399: --
415: ,p_object_version_number => p_object_version_number
416: );
417:
418: exception
419: when hr_api.cannot_find_prog_unit then
420: hr_api.cannot_find_prog_unit_error
421: (p_module_name => 'delete_Validation'
422: ,p_hook_type => 'AP');
423: end;
416: );
417:
418: exception
419: when hr_api.cannot_find_prog_unit then
420: hr_api.cannot_find_prog_unit_error
421: (p_module_name => 'delete_Validation'
422: ,p_hook_type => 'AP');
423: end;
424: --
424: --
425: -- When in validation only mode raise the Validate_Enabled exception
426: --
427: -- if p_validate then
428: -- raise hr_api.validate_enabled;
429: -- end if;
430: --
431: -- Set all output arguments
432: --
431: -- Set all output arguments
432: --
433: hr_utility.set_location(' Leaving:'||l_proc, 70);
434: exception
435: when hr_api.validate_enabled then
436: --
437: -- As the Validate_Enabled exception has been raised
438: -- we must rollback to the savepoint
439: --