DBA Data[Home] [Help]

APPS.OTA_TSR_INS dependencies on HR_API

Line 179: When hr_api.check_integrity_violated Then

175: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
176: --
177: hr_utility.set_location(' Leaving:'||l_proc, 10);
178: Exception
179: When hr_api.check_integrity_violated Then
180: -- A check constraint has been violated
181: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
182: ota_tsr_shd.constraint_error
183: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

179: When hr_api.check_integrity_violated Then
180: -- A check constraint has been violated
181: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
182: ota_tsr_shd.constraint_error
183: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
184: When hr_api.parent_integrity_violated Then
185: -- Parent integrity has been violated
186: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
187: ota_tsr_shd.constraint_error

Line 184: When hr_api.parent_integrity_violated Then

180: -- A check constraint has been violated
181: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
182: ota_tsr_shd.constraint_error
183: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
184: When hr_api.parent_integrity_violated Then
185: -- Parent integrity has been violated
186: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
187: ota_tsr_shd.constraint_error
188: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

184: When hr_api.parent_integrity_violated Then
185: -- Parent integrity has been violated
186: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
187: ota_tsr_shd.constraint_error
188: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
189: When hr_api.unique_integrity_violated Then
190: -- Unique integrity has been violated
191: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
192: ota_tsr_shd.constraint_error

Line 189: When hr_api.unique_integrity_violated Then

185: -- Parent integrity has been violated
186: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
187: ota_tsr_shd.constraint_error
188: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
189: When hr_api.unique_integrity_violated Then
190: -- Unique integrity has been violated
191: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
192: ota_tsr_shd.constraint_error
193: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

189: When hr_api.unique_integrity_violated Then
190: -- Unique integrity has been violated
191: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
192: ota_tsr_shd.constraint_error
193: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
194: When Others Then
195: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
196: Raise;
197: End insert_dml;

Line 372: Raise HR_Api.Validate_Enabled;

368: --
369: -- If we are validating then raise the Validate_Enabled exception
370: --
371: If p_validate then
372: Raise HR_Api.Validate_Enabled;
373: End If;
374: --
375: hr_utility.set_location(' Leaving:'||l_proc, 10);
376: Exception

Line 377: When HR_Api.Validate_Enabled Then

373: End If;
374: --
375: hr_utility.set_location(' Leaving:'||l_proc, 10);
376: Exception
377: When HR_Api.Validate_Enabled Then
378: --
379: -- As the Validate_Enabled exception has been raised
380: -- we must rollback to the savepoint
381: --