APPS.OTA_TPL_INS dependencies on HR_API

Line 142: When hr_api.check_integrity_violated Then

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

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

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

Line 147: When hr_api.parent_integrity_violated Then

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

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

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

Line 152: When hr_api.unique_integrity_violated Then

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

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

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

Line 302: Raise HR_Api.Validate_Enabled;

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

Line 307: When HR_Api.Validate_Enabled Then

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