APPS.OTA_TEA_INS dependencies on HR_API

Line 130: When hr_api.check_integrity_violated Then

126: ota_tea_shd.g_api_dml := false; -- Unset the api dml status
127: --
128: hr_utility.set_location(' Leaving:'||l_proc, 10);
129: Exception
130: When hr_api.check_integrity_violated Then
131: -- A check constraint has been violated
132: ota_tea_shd.g_api_dml := false; -- Unset the api dml status
133: ota_tea_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

130: When hr_api.check_integrity_violated Then
131: -- A check constraint has been violated
132: ota_tea_shd.g_api_dml := false; -- Unset the api dml status
133: ota_tea_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.parent_integrity_violated Then
136: -- Parent integrity has been violated
137: ota_tea_shd.g_api_dml := false; -- Unset the api dml status
138: ota_tea_shd.constraint_error

Line 135: When hr_api.parent_integrity_violated Then

131: -- A check constraint has been violated
132: ota_tea_shd.g_api_dml := false; -- Unset the api dml status
133: ota_tea_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.parent_integrity_violated Then
136: -- Parent integrity has been violated
137: ota_tea_shd.g_api_dml := false; -- Unset the api dml status
138: ota_tea_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

135: When hr_api.parent_integrity_violated Then
136: -- Parent integrity has been violated
137: ota_tea_shd.g_api_dml := false; -- Unset the api dml status
138: ota_tea_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.unique_integrity_violated Then
141: -- Unique integrity has been violated
142: ota_tea_shd.g_api_dml := false; -- Unset the api dml status
143: ota_tea_shd.constraint_error

Line 140: When hr_api.unique_integrity_violated Then

136: -- Parent integrity has been violated
137: ota_tea_shd.g_api_dml := false; -- Unset the api dml status
138: ota_tea_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.unique_integrity_violated Then
141: -- Unique integrity has been violated
142: ota_tea_shd.g_api_dml := false; -- Unset the api dml status
143: ota_tea_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.unique_integrity_violated Then
141: -- Unique integrity has been violated
142: ota_tea_shd.g_api_dml := false; -- Unset the api dml status
143: ota_tea_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When Others Then
146: ota_tea_shd.g_api_dml := false; -- Unset the api dml status
147: Raise;
148: End insert_dml;

Line 403: Raise HR_Api.Validate_Enabled;

399: --
400: -- If we are validating then raise the Validate_Enabled exception
401: --
402: If p_validate then
403: Raise HR_Api.Validate_Enabled;
404: End If;
405: --
406: hr_utility.set_location(' Leaving:'||l_proc, 10);
407: Exception

Line 408: When HR_Api.Validate_Enabled Then

404: End If;
405: --
406: hr_utility.set_location(' Leaving:'||l_proc, 10);
407: Exception
408: When HR_Api.Validate_Enabled Then
409: --
410: -- As the Validate_Enabled exception has been raised
411: -- we must rollback to the savepoint
412: --