DBA Data[Home] [Help]

APPS.PAY_APR_INS dependencies on HR_API

Line 170: When hr_api.check_integrity_violated Then

166: pay_apr_shd.g_api_dml := false; -- Unset the api dml status
167: --
168: hr_utility.set_location(' Leaving:'||l_proc, 10);
169: Exception
170: When hr_api.check_integrity_violated Then
171: -- A check constraint has been violated
172: pay_apr_shd.g_api_dml := false; -- Unset the api dml status
173: pay_apr_shd.constraint_error
174: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 174: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

170: When hr_api.check_integrity_violated Then
171: -- A check constraint has been violated
172: pay_apr_shd.g_api_dml := false; -- Unset the api dml status
173: pay_apr_shd.constraint_error
174: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
175: When hr_api.parent_integrity_violated Then
176: -- Parent integrity has been violated
177: pay_apr_shd.g_api_dml := false; -- Unset the api dml status
178: pay_apr_shd.constraint_error

Line 175: When hr_api.parent_integrity_violated Then

171: -- A check constraint has been violated
172: pay_apr_shd.g_api_dml := false; -- Unset the api dml status
173: pay_apr_shd.constraint_error
174: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
175: When hr_api.parent_integrity_violated Then
176: -- Parent integrity has been violated
177: pay_apr_shd.g_api_dml := false; -- Unset the api dml status
178: pay_apr_shd.constraint_error
179: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 179: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

175: When hr_api.parent_integrity_violated Then
176: -- Parent integrity has been violated
177: pay_apr_shd.g_api_dml := false; -- Unset the api dml status
178: pay_apr_shd.constraint_error
179: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
180: When hr_api.unique_integrity_violated Then
181: -- Unique integrity has been violated
182: pay_apr_shd.g_api_dml := false; -- Unset the api dml status
183: pay_apr_shd.constraint_error

Line 180: When hr_api.unique_integrity_violated Then

176: -- Parent integrity has been violated
177: pay_apr_shd.g_api_dml := false; -- Unset the api dml status
178: pay_apr_shd.constraint_error
179: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
180: When hr_api.unique_integrity_violated Then
181: -- Unique integrity has been violated
182: pay_apr_shd.g_api_dml := false; -- Unset the api dml status
183: pay_apr_shd.constraint_error
184: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 184: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

180: When hr_api.unique_integrity_violated Then
181: -- Unique integrity has been violated
182: pay_apr_shd.g_api_dml := false; -- Unset the api dml status
183: pay_apr_shd.constraint_error
184: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
185: When Others Then
186: pay_apr_shd.g_api_dml := false; -- Unset the api dml status
187: Raise;
188: End insert_dml;