231: --
232: --
233: hr_utility.set_location(' Leaving:'||l_proc, 10);
234: Exception
235: When hr_api.check_integrity_violated Then
236: -- A check constraint has been violated
237: pay_set_shd.constraint_error
238: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
239: When hr_api.parent_integrity_violated Then
234: Exception
235: When hr_api.check_integrity_violated Then
236: -- A check constraint has been violated
237: pay_set_shd.constraint_error
238: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
239: When hr_api.parent_integrity_violated Then
240: -- Parent integrity has been violated
241: pay_set_shd.constraint_error
242: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
235: When hr_api.check_integrity_violated Then
236: -- A check constraint has been violated
237: pay_set_shd.constraint_error
238: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
239: When hr_api.parent_integrity_violated Then
240: -- Parent integrity has been violated
241: pay_set_shd.constraint_error
242: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
243: When hr_api.unique_integrity_violated Then
238: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
239: When hr_api.parent_integrity_violated Then
240: -- Parent integrity has been violated
241: pay_set_shd.constraint_error
242: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
243: When hr_api.unique_integrity_violated Then
244: -- Unique integrity has been violated
245: pay_set_shd.constraint_error
246: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
239: When hr_api.parent_integrity_violated Then
240: -- Parent integrity has been violated
241: pay_set_shd.constraint_error
242: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
243: When hr_api.unique_integrity_violated Then
244: -- Unique integrity has been violated
245: pay_set_shd.constraint_error
246: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
247: When Others Then
242: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
243: When hr_api.unique_integrity_violated Then
244: -- Unique integrity has been violated
245: pay_set_shd.constraint_error
246: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
247: When Others Then
248: Raise;
249: End insert_dml;
250: --