234: --
235: --
236: hr_utility.set_location(' Leaving:'||l_proc, 10);
237: Exception
238: When hr_api.check_integrity_violated Then
239: -- A check constraint has been violated
240: --
241: pqh_rei_shd.constraint_error
242: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
238: When hr_api.check_integrity_violated Then
239: -- A check constraint has been violated
240: --
241: pqh_rei_shd.constraint_error
242: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
243: When hr_api.parent_integrity_violated Then
244: -- Parent integrity has been violated
245: --
246: pqh_rei_shd.constraint_error
239: -- A check constraint has been violated
240: --
241: pqh_rei_shd.constraint_error
242: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
243: When hr_api.parent_integrity_violated Then
244: -- Parent integrity has been violated
245: --
246: pqh_rei_shd.constraint_error
247: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
243: When hr_api.parent_integrity_violated Then
244: -- Parent integrity has been violated
245: --
246: pqh_rei_shd.constraint_error
247: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
248: When hr_api.unique_integrity_violated Then
249: -- Unique integrity has been violated
250: --
251: pqh_rei_shd.constraint_error
244: -- Parent integrity has been violated
245: --
246: pqh_rei_shd.constraint_error
247: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
248: When hr_api.unique_integrity_violated Then
249: -- Unique integrity has been violated
250: --
251: pqh_rei_shd.constraint_error
252: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
248: When hr_api.unique_integrity_violated Then
249: -- Unique integrity has been violated
250: --
251: pqh_rei_shd.constraint_error
252: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
253: When Others Then
254: --
255: Raise;
256: End insert_dml;
464: );
465: --
466: exception
467: --
468: when hr_api.cannot_find_prog_unit then
469: --
470: hr_api.cannot_find_prog_unit_error
471: (p_module_name => 'PQH_ROLE_EXTRA_INFO'
472: ,p_hook_type => 'AI');
466: exception
467: --
468: when hr_api.cannot_find_prog_unit then
469: --
470: hr_api.cannot_find_prog_unit_error
471: (p_module_name => 'PQH_ROLE_EXTRA_INFO'
472: ,p_hook_type => 'AI');
473: --
474: end;
524: --
525: -- If we are validating then raise the Validate_Enabled exception
526: --
527: If p_validate then
528: Raise HR_Api.Validate_Enabled;
529: End If;
530: --
531: -- Call to raise any errors on multi-message list
532: hr_multi_message.end_validation_set;
532: hr_multi_message.end_validation_set;
533: --
534: hr_utility.set_location('Leaving:'||l_proc, 20);
535: Exception
536: When HR_Api.Validate_Enabled Then
537: --
538: -- As the Validate_Enabled exception has been raised
539: -- we must rollback to the savepoint
540: --