661: hr_utility.set_location(' Leaving:'||l_proc, 10);
662: Exception
663: When hr_api.check_integrity_violated Then
664: -- A check constraint has been violated
665: pqh_cea_shd.constraint_error
666: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
667: When hr_api.parent_integrity_violated Then
668: -- Parent integrity has been violated
669: pqh_cea_shd.constraint_error
665: pqh_cea_shd.constraint_error
666: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
667: When hr_api.parent_integrity_violated Then
668: -- Parent integrity has been violated
669: pqh_cea_shd.constraint_error
670: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
671: When hr_api.unique_integrity_violated Then
672: -- Unique integrity has been violated
673: pqh_cea_shd.constraint_error
669: pqh_cea_shd.constraint_error
670: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
671: When hr_api.unique_integrity_violated Then
672: -- Unique integrity has been violated
673: pqh_cea_shd.constraint_error
674: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
675: When Others Then
676: Raise;
677: End ;