180: );
181: --
182: hr_utility.set_location(' Leaving:'||l_proc, 10);
183: Exception
184: When hr_api.check_integrity_violated Then
185: -- A check constraint has been violated
186: pe_poi_shd.constraint_error
187: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
188: When hr_api.parent_integrity_violated Then
183: Exception
184: When hr_api.check_integrity_violated Then
185: -- A check constraint has been violated
186: pe_poi_shd.constraint_error
187: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
188: When hr_api.parent_integrity_violated Then
189: -- Parent integrity has been violated
190: pe_poi_shd.constraint_error
191: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
184: When hr_api.check_integrity_violated Then
185: -- A check constraint has been violated
186: pe_poi_shd.constraint_error
187: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
188: When hr_api.parent_integrity_violated Then
189: -- Parent integrity has been violated
190: pe_poi_shd.constraint_error
191: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
192: When hr_api.unique_integrity_violated Then
187: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
188: When hr_api.parent_integrity_violated Then
189: -- Parent integrity has been violated
190: pe_poi_shd.constraint_error
191: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
192: When hr_api.unique_integrity_violated Then
193: -- Unique integrity has been violated
194: pe_poi_shd.constraint_error
195: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
188: When hr_api.parent_integrity_violated Then
189: -- Parent integrity has been violated
190: pe_poi_shd.constraint_error
191: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
192: When hr_api.unique_integrity_violated Then
193: -- Unique integrity has been violated
194: pe_poi_shd.constraint_error
195: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
196: When Others Then
191: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
192: When hr_api.unique_integrity_violated Then
193: -- Unique integrity has been violated
194: pe_poi_shd.constraint_error
195: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
196: When Others Then
197: Raise;
198: End insert_dml;
199: --
356: p_poei_information29 => p_rec.poei_information29 ,
357: p_poei_information30 => p_rec.poei_information30
358: );
359: exception
360: when hr_api.cannot_find_prog_unit then
361: hr_api.cannot_find_prog_unit_error
362: ( p_module_name => 'PER_POSITION_EXTRA_INFO'
363: ,p_hook_type => 'AI'
364: );
357: p_poei_information30 => p_rec.poei_information30
358: );
359: exception
360: when hr_api.cannot_find_prog_unit then
361: hr_api.cannot_find_prog_unit_error
362: ( p_module_name => 'PER_POSITION_EXTRA_INFO'
363: ,p_hook_type => 'AI'
364: );
365: end;
409: --
410: -- If we are validating then raise the Validate_Enabled exception
411: --
412: If p_validate then
413: Raise HR_Api.Validate_Enabled;
414: End If;
415: --
416: hr_utility.set_location(' Leaving:'||l_proc, 10);
417: Exception
414: End If;
415: --
416: hr_utility.set_location(' Leaving:'||l_proc, 10);
417: Exception
418: When HR_Api.Validate_Enabled Then
419: --
420: -- As the Validate_Enabled exception has been raised
421: -- we must rollback to the savepoint
422: --