114: );
115: --
116: hr_utility.set_location(' Leaving:'||l_proc, 10);
117: Exception
118: When hr_api.check_integrity_violated Then
119: -- A check constraint has been violated
120: per_asr_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.parent_integrity_violated Then
117: Exception
118: When hr_api.check_integrity_violated Then
119: -- A check constraint has been violated
120: per_asr_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.parent_integrity_violated Then
123: -- Parent integrity has been violated
124: per_asr_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When hr_api.check_integrity_violated Then
119: -- A check constraint has been violated
120: per_asr_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.parent_integrity_violated Then
123: -- Parent integrity has been violated
124: per_asr_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.unique_integrity_violated Then
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.parent_integrity_violated Then
123: -- Parent integrity has been violated
124: per_asr_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.unique_integrity_violated Then
127: -- Unique integrity has been violated
128: per_asr_shd.constraint_error
129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.parent_integrity_violated Then
123: -- Parent integrity has been violated
124: per_asr_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.unique_integrity_violated Then
127: -- Unique integrity has been violated
128: per_asr_shd.constraint_error
129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
130: When Others Then
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.unique_integrity_violated Then
127: -- Unique integrity has been violated
128: per_asr_shd.constraint_error
129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
130: When Others Then
131: Raise;
132: End insert_dml;
133: --
257: p_attribute18 => p_rec.attribute18 ,
258: p_attribute19 => p_rec.attribute19 ,
259: p_attribute20 => p_rec.attribute20 );
260: exception
261: when hr_api.cannot_find_prog_unit then
262: hr_api.cannot_find_prog_unit_error
263: ( p_module_name => 'PER_ASSESSMENT_GROUPS'
264: ,p_hook_type => 'AI'
265: );
258: p_attribute19 => p_rec.attribute19 ,
259: p_attribute20 => p_rec.attribute20 );
260: exception
261: when hr_api.cannot_find_prog_unit then
262: hr_api.cannot_find_prog_unit_error
263: ( p_module_name => 'PER_ASSESSMENT_GROUPS'
264: ,p_hook_type => 'AI'
265: );
266: end;
312: --
313: -- If we are validating then raise the Validate_Enabled exception
314: --
315: If p_validate then
316: Raise HR_Api.Validate_Enabled;
317: End If;
318: --
319: hr_utility.set_location(' Leaving:'||l_proc, 10);
320: Exception
317: End If;
318: --
319: hr_utility.set_location(' Leaving:'||l_proc, 10);
320: Exception
321: When HR_Api.Validate_Enabled Then
322: --
323: -- As the Validate_Enabled exception has been raised
324: -- we must rollback to the savepoint
325: --