APPS.PER_SIP_INS dependencies on HR_API

Line 212: When hr_api.check_integrity_violated Then

208: per_sip_shd.g_api_dml := false; -- Unset the api dml status
209: --
210: hr_utility.set_location(' Leaving:'||l_proc, 10);
211: Exception
212: When hr_api.check_integrity_violated Then
213: -- A check constraint has been violated
214: per_sip_shd.g_api_dml := false; -- Unset the api dml status
215: per_sip_shd.constraint_error
216: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

212: When hr_api.check_integrity_violated Then
213: -- A check constraint has been violated
214: per_sip_shd.g_api_dml := false; -- Unset the api dml status
215: per_sip_shd.constraint_error
216: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
217: When hr_api.parent_integrity_violated Then
218: -- Parent integrity has been violated
219: per_sip_shd.g_api_dml := false; -- Unset the api dml status
220: per_sip_shd.constraint_error

Line 217: When hr_api.parent_integrity_violated Then

213: -- A check constraint has been violated
214: per_sip_shd.g_api_dml := false; -- Unset the api dml status
215: per_sip_shd.constraint_error
216: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
217: When hr_api.parent_integrity_violated Then
218: -- Parent integrity has been violated
219: per_sip_shd.g_api_dml := false; -- Unset the api dml status
220: per_sip_shd.constraint_error
221: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

217: When hr_api.parent_integrity_violated Then
218: -- Parent integrity has been violated
219: per_sip_shd.g_api_dml := false; -- Unset the api dml status
220: per_sip_shd.constraint_error
221: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
222: When hr_api.unique_integrity_violated Then
223: -- Unique integrity has been violated
224: per_sip_shd.g_api_dml := false; -- Unset the api dml status
225: per_sip_shd.constraint_error

Line 222: When hr_api.unique_integrity_violated Then

218: -- Parent integrity has been violated
219: per_sip_shd.g_api_dml := false; -- Unset the api dml status
220: per_sip_shd.constraint_error
221: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
222: When hr_api.unique_integrity_violated Then
223: -- Unique integrity has been violated
224: per_sip_shd.g_api_dml := false; -- Unset the api dml status
225: per_sip_shd.constraint_error
226: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

222: When hr_api.unique_integrity_violated Then
223: -- Unique integrity has been violated
224: per_sip_shd.g_api_dml := false; -- Unset the api dml status
225: per_sip_shd.constraint_error
226: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
227: When Others Then
228: per_sip_shd.g_api_dml := false; -- Unset the api dml status
229: Raise;
230: End insert_dml;

Line 487: when hr_api.cannot_find_prog_unit then

483: );
484: --
485: exception
486: --
487: when hr_api.cannot_find_prog_unit then
488: --
489: hr_api.cannot_find_prog_unit_error
490: (p_module_name => 'PER_SP_SUCCESSOR_IN_PLAN'
491: ,p_hook_type => 'AI');

Line 489: hr_api.cannot_find_prog_unit_error

485: exception
486: --
487: when hr_api.cannot_find_prog_unit then
488: --
489: hr_api.cannot_find_prog_unit_error
490: (p_module_name => 'PER_SP_SUCCESSOR_IN_PLAN'
491: ,p_hook_type => 'AI');
492: --
493: end;