156: );
157: --
158: hr_utility.set_location(' Leaving:'||l_proc, 10);
159: Exception
160: When hr_api.check_integrity_violated Then
161: -- A check constraint has been violated
162: per_asn_shd.constraint_error
163: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
164: When hr_api.parent_integrity_violated Then
159: Exception
160: When hr_api.check_integrity_violated Then
161: -- A check constraint has been violated
162: per_asn_shd.constraint_error
163: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
164: When hr_api.parent_integrity_violated Then
165: -- Parent integrity has been violated
166: per_asn_shd.constraint_error
167: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
160: When hr_api.check_integrity_violated Then
161: -- A check constraint has been violated
162: per_asn_shd.constraint_error
163: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
164: When hr_api.parent_integrity_violated Then
165: -- Parent integrity has been violated
166: per_asn_shd.constraint_error
167: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
168: When hr_api.unique_integrity_violated Then
163: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
164: When hr_api.parent_integrity_violated Then
165: -- Parent integrity has been violated
166: per_asn_shd.constraint_error
167: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
168: When hr_api.unique_integrity_violated Then
169: -- Unique integrity has been violated
170: per_asn_shd.constraint_error
171: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
164: When hr_api.parent_integrity_violated Then
165: -- Parent integrity has been violated
166: per_asn_shd.constraint_error
167: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
168: When hr_api.unique_integrity_violated Then
169: -- Unique integrity has been violated
170: per_asn_shd.constraint_error
171: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
172: When Others Then
167: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
168: When hr_api.unique_integrity_violated Then
169: -- Unique integrity has been violated
170: per_asn_shd.constraint_error
171: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
172: When Others Then
173: Raise;
174: End insert_dml;
175: --
348: p_attribute18 => p_rec.attribute18 ,
349: p_attribute19 => p_rec.attribute19 ,
350: p_attribute20 => p_rec.attribute20 );
351: exception
352: when hr_api.cannot_find_prog_unit then
353: hr_api.cannot_find_prog_unit_error
354: ( p_module_name => 'PER_ASSESSMENTS'
355: ,p_hook_type => 'AI'
356: );
349: p_attribute19 => p_rec.attribute19 ,
350: p_attribute20 => p_rec.attribute20 );
351: exception
352: when hr_api.cannot_find_prog_unit then
353: hr_api.cannot_find_prog_unit_error
354: ( p_module_name => 'PER_ASSESSMENTS'
355: ,p_hook_type => 'AI'
356: );
357: end;
414: -- If we are validating then raise the Validate_Enabled exception
415: --
416: --
417: If p_validate then
418: Raise HR_Api.Validate_Enabled;
419: End If;
420: --
421: hr_utility.set_location(' Leaving:'||l_proc, 10);
422: Exception
419: End If;
420: --
421: hr_utility.set_location(' Leaving:'||l_proc, 10);
422: Exception
423: When HR_Api.Validate_Enabled Then
424: --
425: -- As the Validate_Enabled exception has been raised
426: -- we must rollback to the savepoint
427: --