APPS.PER_CEL_INS dependencies on HR_API

Line 262: When hr_api.check_integrity_violated Then

258: per_cel_shd.g_api_dml := false; -- Unset the api dml status
259: --
260: hr_utility.set_location(' Leaving:'||l_proc, 10);
261: Exception
262: When hr_api.check_integrity_violated Then
263: -- A check constraint has been violated
264: per_cel_shd.g_api_dml := false; -- Unset the api dml status
265: per_cel_shd.constraint_error
266: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

262: When hr_api.check_integrity_violated Then
263: -- A check constraint has been violated
264: per_cel_shd.g_api_dml := false; -- Unset the api dml status
265: per_cel_shd.constraint_error
266: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
267: When hr_api.parent_integrity_violated Then
268: -- Parent integrity has been violated
269: per_cel_shd.g_api_dml := false; -- Unset the api dml status
270: per_cel_shd.constraint_error

Line 267: When hr_api.parent_integrity_violated Then

263: -- A check constraint has been violated
264: per_cel_shd.g_api_dml := false; -- Unset the api dml status
265: per_cel_shd.constraint_error
266: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
267: When hr_api.parent_integrity_violated Then
268: -- Parent integrity has been violated
269: per_cel_shd.g_api_dml := false; -- Unset the api dml status
270: per_cel_shd.constraint_error
271: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

267: When hr_api.parent_integrity_violated Then
268: -- Parent integrity has been violated
269: per_cel_shd.g_api_dml := false; -- Unset the api dml status
270: per_cel_shd.constraint_error
271: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
272: When hr_api.unique_integrity_violated Then
273: -- Unique integrity has been violated
274: per_cel_shd.g_api_dml := false; -- Unset the api dml status
275: per_cel_shd.constraint_error

Line 272: When hr_api.unique_integrity_violated Then

268: -- Parent integrity has been violated
269: per_cel_shd.g_api_dml := false; -- Unset the api dml status
270: per_cel_shd.constraint_error
271: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
272: When hr_api.unique_integrity_violated Then
273: -- Unique integrity has been violated
274: per_cel_shd.g_api_dml := false; -- Unset the api dml status
275: per_cel_shd.constraint_error
276: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

272: When hr_api.unique_integrity_violated Then
273: -- Unique integrity has been violated
274: per_cel_shd.g_api_dml := false; -- Unset the api dml status
275: per_cel_shd.constraint_error
276: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
277: When Others Then
278: per_cel_shd.g_api_dml := false; -- Unset the api dml status
279: Raise;
280: End insert_dml;

Line 501: when hr_api.cannot_find_prog_unit then

497: p_achieved_date => p_rec.achieved_date ,
498: p_appr_line_score => p_rec.appr_line_score
499: );
500: exception
501: when hr_api.cannot_find_prog_unit then
502: hr_api.cannot_find_prog_unit_error
503: ( p_module_name => 'PER_COMPETENCE_ELEMENTS'
504: ,p_hook_type => 'AI'
505: );

Line 502: hr_api.cannot_find_prog_unit_error

498: p_appr_line_score => p_rec.appr_line_score
499: );
500: exception
501: when hr_api.cannot_find_prog_unit then
502: hr_api.cannot_find_prog_unit_error
503: ( p_module_name => 'PER_COMPETENCE_ELEMENTS'
504: ,p_hook_type => 'AI'
505: );
506: end;

Line 561: Raise HR_Api.Validate_Enabled;

557: --
558: -- If we are validating then raise the Validate_Enabled exception
559: --
560: If p_validate then
561: Raise HR_Api.Validate_Enabled;
562: End If;
563: --
564: hr_utility.set_location(' Leaving:'||l_proc, 10);
565: Exception

Line 566: When HR_Api.Validate_Enabled Then

562: End If;
563: --
564: hr_utility.set_location(' Leaving:'||l_proc, 10);
565: Exception
566: When HR_Api.Validate_Enabled Then
567: --
568: -- As the Validate_Enabled exception has been raised
569: -- we must rollback to the savepoint
570: --