56: --
57: hr_utility.set_location(' Leaving:'||l_proc, 10);
58: --
59: Exception
60: When hr_api.child_integrity_violated then
61: -- Child integrity has been violated
62: per_asn_shd.constraint_error
63: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
64: When Others Then
59: Exception
60: When hr_api.child_integrity_violated then
61: -- Child integrity has been violated
62: per_asn_shd.constraint_error
63: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
64: When Others Then
65: Raise;
66: End delete_dml;
67: --
189: p_attribute18_o => per_asn_shd.g_old_rec.attribute18 ,
190: p_attribute19_o => per_asn_shd.g_old_rec.attribute19 ,
191: p_attribute20_o => per_asn_shd.g_old_rec.attribute20 );
192: exception
193: when hr_api.cannot_find_prog_unit then
194: hr_api.cannot_find_prog_unit_error
195: ( p_module_name => 'PER_ASSESSMENTS'
196: ,p_hook_type => 'AD'
197: );
190: p_attribute19_o => per_asn_shd.g_old_rec.attribute19 ,
191: p_attribute20_o => per_asn_shd.g_old_rec.attribute20 );
192: exception
193: when hr_api.cannot_find_prog_unit then
194: hr_api.cannot_find_prog_unit_error
195: ( p_module_name => 'PER_ASSESSMENTS'
196: ,p_hook_type => 'AD'
197: );
198: end;
260: --
261: -- If we are validating then raise the Validate_Enabled exception
262: --
263: If p_validate then
264: Raise HR_Api.Validate_Enabled;
265: End If;
266: --
267: hr_utility.set_location(' Leaving:'||l_proc, 10);
268: Exception
265: End If;
266: --
267: hr_utility.set_location(' Leaving:'||l_proc, 10);
268: Exception
269: When HR_Api.Validate_Enabled Then
270: --
271: -- As the Validate_Enabled exception has been raised
272: -- we must rollback to the savepoint
273: --