APPS.OTA_TSP_INS dependencies on HR_API

Line 144: When hr_api.check_integrity_violated Then

140: ota_tsp_shd.g_api_dml := false; -- Unset the api dml status
141: --
142: hr_utility.set_location(' Leaving:'||l_proc, 10);
143: Exception
144: When hr_api.check_integrity_violated Then
145: -- A check constraint has been violated
146: ota_tsp_shd.g_api_dml := false; -- Unset the api dml status
147: ota_tsp_shd.g_api_dml := true; -- Set the api dml status
148: ota_tsp_shd.constraint_error

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

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

Line 150: When hr_api.parent_integrity_violated Then

146: ota_tsp_shd.g_api_dml := false; -- Unset the api dml status
147: ota_tsp_shd.g_api_dml := true; -- Set the api dml status
148: ota_tsp_shd.constraint_error
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
150: When hr_api.parent_integrity_violated Then
151: -- Parent integrity has been violated
152: ota_tsp_shd.g_api_dml := false; -- Unset the api dml status
153: ota_tsp_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.parent_integrity_violated Then
151: -- Parent integrity has been violated
152: ota_tsp_shd.g_api_dml := false; -- Unset the api dml status
153: ota_tsp_shd.constraint_error
154: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
155: When hr_api.unique_integrity_violated Then
156: -- Unique integrity has been violated
157: ota_tsp_shd.g_api_dml := false; -- Unset the api dml status
158: ota_tsp_shd.constraint_error

Line 155: When hr_api.unique_integrity_violated Then

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

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

155: When hr_api.unique_integrity_violated Then
156: -- Unique integrity has been violated
157: ota_tsp_shd.g_api_dml := false; -- Unset the api dml status
158: ota_tsp_shd.constraint_error
159: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
160: When Others Then
161: ota_tsp_shd.g_api_dml := false; -- Unset the api dml status
162: Raise;
163: End insert_dml;

Line 340: Raise HR_Api.Validate_Enabled;

336: --
337: -- If we are validating then raise the Validate_Enabled exception
338: --
339: If p_validate then
340: Raise HR_Api.Validate_Enabled;
341: End If;
342: --
343: hr_utility.set_location(' Leaving:'||l_proc, 10);
344: Exception

Line 345: When HR_Api.Validate_Enabled Then

341: End If;
342: --
343: hr_utility.set_location(' Leaving:'||l_proc, 10);
344: Exception
345: When HR_Api.Validate_Enabled Then
346: --
347: -- As the Validate_Enabled exception has been raised
348: -- we must rollback to the savepoint
349: --