APPS.OTA_PMM_INS dependencies on HR_API

Line 134: When hr_api.check_integrity_violated Then

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

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

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

Line 139: When hr_api.parent_integrity_violated Then

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

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

139: When hr_api.parent_integrity_violated Then
140: -- Parent integrity has been violated
141: ota_pmm_shd.g_api_dml := false; -- Unset the api dml status
142: ota_pmm_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When hr_api.unique_integrity_violated Then
145: -- Unique integrity has been violated
146: ota_pmm_shd.g_api_dml := false; -- Unset the api dml status
147: ota_pmm_shd.constraint_error

Line 144: When hr_api.unique_integrity_violated Then

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

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

144: When hr_api.unique_integrity_violated Then
145: -- Unique integrity has been violated
146: ota_pmm_shd.g_api_dml := false; -- Unset the api dml status
147: ota_pmm_shd.constraint_error
148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
149: When Others Then
150: ota_pmm_shd.g_api_dml := false; -- Unset the api dml status
151: Raise;
152: End insert_dml;

Line 294: Raise HR_Api.Validate_Enabled;

290: --
291: -- If we are validating then raise the Validate_Enabled exception
292: --
293: If p_validate then
294: Raise HR_Api.Validate_Enabled;
295: End If;
296: --
297: hr_utility.set_location(' Leaving:'||l_proc, 10);
298: Exception

Line 299: When HR_Api.Validate_Enabled Then

295: End If;
296: --
297: hr_utility.set_location(' Leaving:'||l_proc, 10);
298: Exception
299: When HR_Api.Validate_Enabled Then
300: --
301: -- As the Validate_Enabled exception has been raised
302: -- we must rollback to the savepoint
303: --