77: --
78: --
79: hr_utility.set_location(' Leaving:'||l_proc, 10);
80: Exception
81: When hr_api.check_integrity_violated Then
82: -- A check constraint has been violated
83: pay_sbc_shd.constraint_error
84: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
85: When hr_api.parent_integrity_violated Then
80: Exception
81: When hr_api.check_integrity_violated Then
82: -- A check constraint has been violated
83: pay_sbc_shd.constraint_error
84: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
85: When hr_api.parent_integrity_violated Then
86: -- Parent integrity has been violated
87: pay_sbc_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
81: When hr_api.check_integrity_violated Then
82: -- A check constraint has been violated
83: pay_sbc_shd.constraint_error
84: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
85: When hr_api.parent_integrity_violated Then
86: -- Parent integrity has been violated
87: pay_sbc_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.unique_integrity_violated Then
84: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
85: When hr_api.parent_integrity_violated Then
86: -- Parent integrity has been violated
87: pay_sbc_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.unique_integrity_violated Then
90: -- Unique integrity has been violated
91: pay_sbc_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
85: When hr_api.parent_integrity_violated Then
86: -- Parent integrity has been violated
87: pay_sbc_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.unique_integrity_violated Then
90: -- Unique integrity has been violated
91: pay_sbc_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When Others Then
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.unique_integrity_violated Then
90: -- Unique integrity has been violated
91: pay_sbc_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When Others Then
94: Raise;
95: End insert_dml;
96: --