182: pay_pap_shd.g_api_dml := false; -- Unset the api dml status
183: --
184: hr_utility.set_location(' Leaving:'||l_proc, 10);
185: Exception
186: When hr_api.check_integrity_violated Then
187: -- A check constraint has been violated
188: pay_pap_shd.g_api_dml := false; -- Unset the api dml status
189: pay_pap_shd.constraint_error
190: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
186: When hr_api.check_integrity_violated Then
187: -- A check constraint has been violated
188: pay_pap_shd.g_api_dml := false; -- Unset the api dml status
189: pay_pap_shd.constraint_error
190: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
191: When hr_api.parent_integrity_violated Then
192: -- Parent integrity has been violated
193: pay_pap_shd.g_api_dml := false; -- Unset the api dml status
194: pay_pap_shd.constraint_error
187: -- A check constraint has been violated
188: pay_pap_shd.g_api_dml := false; -- Unset the api dml status
189: pay_pap_shd.constraint_error
190: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
191: When hr_api.parent_integrity_violated Then
192: -- Parent integrity has been violated
193: pay_pap_shd.g_api_dml := false; -- Unset the api dml status
194: pay_pap_shd.constraint_error
195: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
191: When hr_api.parent_integrity_violated Then
192: -- Parent integrity has been violated
193: pay_pap_shd.g_api_dml := false; -- Unset the api dml status
194: pay_pap_shd.constraint_error
195: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
196: When hr_api.unique_integrity_violated Then
197: -- Unique integrity has been violated
198: pay_pap_shd.g_api_dml := false; -- Unset the api dml status
199: pay_pap_shd.constraint_error
192: -- Parent integrity has been violated
193: pay_pap_shd.g_api_dml := false; -- Unset the api dml status
194: pay_pap_shd.constraint_error
195: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
196: When hr_api.unique_integrity_violated Then
197: -- Unique integrity has been violated
198: pay_pap_shd.g_api_dml := false; -- Unset the api dml status
199: pay_pap_shd.constraint_error
200: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
196: When hr_api.unique_integrity_violated Then
197: -- Unique integrity has been violated
198: pay_pap_shd.g_api_dml := false; -- Unset the api dml status
199: pay_pap_shd.constraint_error
200: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
201: When Others Then
202: pay_pap_shd.g_api_dml := false; -- Unset the api dml status
203: Raise;
204: End insert_dml;
364: );
365: --
366: exception
367: --
368: when hr_api.cannot_find_prog_unit then
369: --
370: hr_api.cannot_find_prog_unit_error
371: (p_module_name => 'pay_accrual_plans'
372: ,p_hook_type => 'AI');
366: exception
367: --
368: when hr_api.cannot_find_prog_unit then
369: --
370: hr_api.cannot_find_prog_unit_error
371: (p_module_name => 'pay_accrual_plans'
372: ,p_hook_type => 'AI');
373: --
374: end;