DBA Data[Home] [Help]

APPS.OTA_TFH_API_INS dependencies on HR_API

Line 360: When hr_api.check_integrity_violated Then

356: ota_tfh_api_shd.g_api_dml := false; -- Unset the api dml status
357: --
358: hr_utility.set_location(' Leaving:'||l_proc, 10);
359: Exception
360: When hr_api.check_integrity_violated Then
361: -- A check constraint has been violated
362: ota_tfh_api_shd.g_api_dml := false; -- Unset the api dml status
363: ota_tfh_api_shd.constraint_error
364: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

360: When hr_api.check_integrity_violated Then
361: -- A check constraint has been violated
362: ota_tfh_api_shd.g_api_dml := false; -- Unset the api dml status
363: ota_tfh_api_shd.constraint_error
364: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
365: When hr_api.parent_integrity_violated Then
366: -- Parent integrity has been violated
367: ota_tfh_api_shd.g_api_dml := false; -- Unset the api dml status
368: ota_tfh_api_shd.constraint_error

Line 365: When hr_api.parent_integrity_violated Then

361: -- A check constraint has been violated
362: ota_tfh_api_shd.g_api_dml := false; -- Unset the api dml status
363: ota_tfh_api_shd.constraint_error
364: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
365: When hr_api.parent_integrity_violated Then
366: -- Parent integrity has been violated
367: ota_tfh_api_shd.g_api_dml := false; -- Unset the api dml status
368: ota_tfh_api_shd.constraint_error
369: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

365: When hr_api.parent_integrity_violated Then
366: -- Parent integrity has been violated
367: ota_tfh_api_shd.g_api_dml := false; -- Unset the api dml status
368: ota_tfh_api_shd.constraint_error
369: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
370: When hr_api.unique_integrity_violated Then
371: -- Unique integrity has been violated
372: ota_tfh_api_shd.g_api_dml := false; -- Unset the api dml status
373: ota_tfh_api_shd.constraint_error

Line 370: When hr_api.unique_integrity_violated Then

366: -- Parent integrity has been violated
367: ota_tfh_api_shd.g_api_dml := false; -- Unset the api dml status
368: ota_tfh_api_shd.constraint_error
369: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
370: When hr_api.unique_integrity_violated Then
371: -- Unique integrity has been violated
372: ota_tfh_api_shd.g_api_dml := false; -- Unset the api dml status
373: ota_tfh_api_shd.constraint_error
374: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

370: When hr_api.unique_integrity_violated Then
371: -- Unique integrity has been violated
372: ota_tfh_api_shd.g_api_dml := false; -- Unset the api dml status
373: ota_tfh_api_shd.constraint_error
374: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
375: When Others Then
376: ota_tfh_api_shd.g_api_dml := false; -- Unset the api dml status
377: Raise;
378: End insert_dml;

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: --