195: );
196:
197: hr_utility.set_location(' Leaving:'||l_proc, 10);
198: Exception
199: When hr_api.check_integrity_violated Then
200: -- A check constraint has been violated
201: per_apt_shd.constraint_error
202: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
203: When hr_api.parent_integrity_violated Then
198: Exception
199: When hr_api.check_integrity_violated Then
200: -- A check constraint has been violated
201: per_apt_shd.constraint_error
202: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
203: When hr_api.parent_integrity_violated Then
204: -- Parent integrity has been violated
205: per_apt_shd.constraint_error
206: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
199: When hr_api.check_integrity_violated Then
200: -- A check constraint has been violated
201: per_apt_shd.constraint_error
202: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
203: When hr_api.parent_integrity_violated Then
204: -- Parent integrity has been violated
205: per_apt_shd.constraint_error
206: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
207: When hr_api.unique_integrity_violated Then
202: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
203: When hr_api.parent_integrity_violated Then
204: -- Parent integrity has been violated
205: per_apt_shd.constraint_error
206: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
207: When hr_api.unique_integrity_violated Then
208: -- Unique integrity has been violated
209: per_apt_shd.constraint_error
210: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
203: When hr_api.parent_integrity_violated Then
204: -- Parent integrity has been violated
205: per_apt_shd.constraint_error
206: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
207: When hr_api.unique_integrity_violated Then
208: -- Unique integrity has been violated
209: per_apt_shd.constraint_error
210: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
211: When Others Then
206: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
207: When hr_api.unique_integrity_violated Then
208: -- Unique integrity has been violated
209: per_apt_shd.constraint_error
210: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
211: When Others Then
212: Raise;
213: End insert_dml;
214:
391: p_part_app_off_template_code => p_rec.part_app_off_template_code,
392: p_part_rev_off_template_code => p_rec.part_rev_off_template_code
393: );
394: exception
395: when hr_api.cannot_find_prog_unit then
396: hr_api.cannot_find_prog_unit_error
397: ( p_module_name => 'PER_APPRAISAL_TEMPLATES'
398: ,p_hook_type => 'AI'
399: );
392: p_part_rev_off_template_code => p_rec.part_rev_off_template_code
393: );
394: exception
395: when hr_api.cannot_find_prog_unit then
396: hr_api.cannot_find_prog_unit_error
397: ( p_module_name => 'PER_APPRAISAL_TEMPLATES'
398: ,p_hook_type => 'AI'
399: );
400: end;
445:
446: -- If we are validating then raise the Validate_Enabled exception
447:
448: If p_validate then
449: Raise HR_Api.Validate_Enabled;
450: End If;
451:
452: hr_utility.set_location(' Leaving:'||l_proc, 10);
453: Exception
450: End If;
451:
452: hr_utility.set_location(' Leaving:'||l_proc, 10);
453: Exception
454: When HR_Api.Validate_Enabled Then
455:
456: -- As the Validate_Enabled exception has been raised
457: -- we must rollback to the savepoint
458: