387: hr_utility.set_location(' Leaving:'||l_proc, 10);
388: Exception
389: When hr_api.check_integrity_violated Then
390: -- A check constraint has been violated
391: pqh_cet_shd.constraint_error
392: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
393: When hr_api.parent_integrity_violated Then
394: -- Parent integrity has been violated
395: pqh_cet_shd.constraint_error
391: pqh_cet_shd.constraint_error
392: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
393: When hr_api.parent_integrity_violated Then
394: -- Parent integrity has been violated
395: pqh_cet_shd.constraint_error
396: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
397: When hr_api.unique_integrity_violated Then
398: -- Unique integrity has been violated
399: pqh_cet_shd.constraint_error
395: pqh_cet_shd.constraint_error
396: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
397: When hr_api.unique_integrity_violated Then
398: -- Unique integrity has been violated
399: pqh_cet_shd.constraint_error
400: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
401: When Others Then
402: Raise;
403: End ;