APPS.BEN_PSQ_INS dependencies on HR_API

Line 148: When hr_api.check_integrity_violated Then

144: ben_psq_shd.g_api_dml := false; -- Unset the api dml status
145: --
146: hr_utility.set_location(' Leaving:'||l_proc, 10);
147: Exception
148: When hr_api.check_integrity_violated Then
149: -- A check constraint has been violated
150: ben_psq_shd.g_api_dml := false; -- Unset the api dml status
151: ben_psq_shd.constraint_error
152: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

148: When hr_api.check_integrity_violated Then
149: -- A check constraint has been violated
150: ben_psq_shd.g_api_dml := false; -- Unset the api dml status
151: ben_psq_shd.constraint_error
152: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
153: When hr_api.parent_integrity_violated Then
154: -- Parent integrity has been violated
155: ben_psq_shd.g_api_dml := false; -- Unset the api dml status
156: ben_psq_shd.constraint_error

Line 153: When hr_api.parent_integrity_violated Then

149: -- A check constraint has been violated
150: ben_psq_shd.g_api_dml := false; -- Unset the api dml status
151: ben_psq_shd.constraint_error
152: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
153: When hr_api.parent_integrity_violated Then
154: -- Parent integrity has been violated
155: ben_psq_shd.g_api_dml := false; -- Unset the api dml status
156: ben_psq_shd.constraint_error
157: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

153: When hr_api.parent_integrity_violated Then
154: -- Parent integrity has been violated
155: ben_psq_shd.g_api_dml := false; -- Unset the api dml status
156: ben_psq_shd.constraint_error
157: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
158: When hr_api.unique_integrity_violated Then
159: -- Unique integrity has been violated
160: ben_psq_shd.g_api_dml := false; -- Unset the api dml status
161: ben_psq_shd.constraint_error

Line 158: When hr_api.unique_integrity_violated Then

154: -- Parent integrity has been violated
155: ben_psq_shd.g_api_dml := false; -- Unset the api dml status
156: ben_psq_shd.constraint_error
157: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
158: When hr_api.unique_integrity_violated Then
159: -- Unique integrity has been violated
160: ben_psq_shd.g_api_dml := false; -- Unset the api dml status
161: ben_psq_shd.constraint_error
162: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

158: When hr_api.unique_integrity_violated Then
159: -- Unique integrity has been violated
160: ben_psq_shd.g_api_dml := false; -- Unset the api dml status
161: ben_psq_shd.constraint_error
162: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
163: When Others Then
164: ben_psq_shd.g_api_dml := false; -- Unset the api dml status
165: Raise;
166: End insert_dml;

Line 316: when hr_api.cannot_find_prog_unit then

312: );
313: --
314: exception
315: --
316: when hr_api.cannot_find_prog_unit then
317: --
318: hr_api.cannot_find_prog_unit_error
319: (p_module_name => 'ben_pymt_sched_py_freq'
320: ,p_hook_type => 'AI');

Line 318: hr_api.cannot_find_prog_unit_error

314: exception
315: --
316: when hr_api.cannot_find_prog_unit then
317: --
318: hr_api.cannot_find_prog_unit_error
319: (p_module_name => 'ben_pymt_sched_py_freq'
320: ,p_hook_type => 'AI');
321: --
322: end;