DBA Data[Home] [Help]

APPS.OTA_PLE_INS dependencies on HR_API

Line 140: When hr_api.check_integrity_violated Then

136: ota_ple_shd.g_api_dml := false; -- Unset the api dml status
137: --
138: hr_utility.set_location(' Leaving:'||l_proc, 10);
139: Exception
140: When hr_api.check_integrity_violated Then
141: -- A check constraint has been violated
142: ota_ple_shd.g_api_dml := false; -- Unset the api dml status
143: ota_ple_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

140: When hr_api.check_integrity_violated Then
141: -- A check constraint has been violated
142: ota_ple_shd.g_api_dml := false; -- Unset the api dml status
143: ota_ple_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When hr_api.parent_integrity_violated Then
146: -- Parent integrity has been violated
147: ota_ple_shd.g_api_dml := false; -- Unset the api dml status
148: ota_ple_shd.constraint_error

Line 145: When hr_api.parent_integrity_violated Then

141: -- A check constraint has been violated
142: ota_ple_shd.g_api_dml := false; -- Unset the api dml status
143: ota_ple_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When hr_api.parent_integrity_violated Then
146: -- Parent integrity has been violated
147: ota_ple_shd.g_api_dml := false; -- Unset the api dml status
148: ota_ple_shd.constraint_error
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

145: When hr_api.parent_integrity_violated Then
146: -- Parent integrity has been violated
147: ota_ple_shd.g_api_dml := false; -- Unset the api dml status
148: ota_ple_shd.constraint_error
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
150: When hr_api.unique_integrity_violated Then
151: -- Unique integrity has been violated
152: ota_ple_shd.g_api_dml := false; -- Unset the api dml status
153: ota_ple_shd.constraint_error

Line 150: When hr_api.unique_integrity_violated Then

146: -- Parent integrity has been violated
147: ota_ple_shd.g_api_dml := false; -- Unset the api dml status
148: ota_ple_shd.constraint_error
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
150: When hr_api.unique_integrity_violated Then
151: -- Unique integrity has been violated
152: ota_ple_shd.g_api_dml := false; -- Unset the api dml status
153: ota_ple_shd.constraint_error
154: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

150: When hr_api.unique_integrity_violated Then
151: -- Unique integrity has been violated
152: ota_ple_shd.g_api_dml := false; -- Unset the api dml status
153: ota_ple_shd.constraint_error
154: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
155: When Others Then
156: ota_ple_shd.g_api_dml := false; -- Unset the api dml status
157: Raise;
158: End insert_dml;

Line 300: Raise HR_Api.Validate_Enabled;

296: --
297: -- If we are validating then raise the Validate_Enabled exception
298: --
299: If p_validate then
300: Raise HR_Api.Validate_Enabled;
301: End If;
302: --
303: hr_utility.set_location(' Leaving:'||l_proc, 10);
304: Exception

Line 305: When HR_Api.Validate_Enabled Then

301: End If;
302: --
303: hr_utility.set_location(' Leaving:'||l_proc, 10);
304: Exception
305: When HR_Api.Validate_Enabled Then
306: --
307: -- As the Validate_Enabled exception has been raised
308: -- we must rollback to the savepoint
309: --