DBA Data[Home] [Help]

APPS.SSP_MAT_INS dependencies on HR_API

Line 216: When hr_api.check_integrity_violated Then

212: ssp_mat_shd.g_api_dml := false; -- Unset the api dml status
213: --
214: hr_utility.set_location(' Leaving:'||l_proc, 10);
215: Exception
216: When hr_api.check_integrity_violated Then
217: -- A check constraint has been violated
218: ssp_mat_shd.g_api_dml := false; -- Unset the api dml status
219: ssp_mat_shd.constraint_error
220: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

216: When hr_api.check_integrity_violated Then
217: -- A check constraint has been violated
218: ssp_mat_shd.g_api_dml := false; -- Unset the api dml status
219: ssp_mat_shd.constraint_error
220: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
221: When hr_api.parent_integrity_violated Then
222: -- Parent integrity has been violated
223: ssp_mat_shd.g_api_dml := false; -- Unset the api dml status
224: ssp_mat_shd.constraint_error

Line 221: When hr_api.parent_integrity_violated Then

217: -- A check constraint has been violated
218: ssp_mat_shd.g_api_dml := false; -- Unset the api dml status
219: ssp_mat_shd.constraint_error
220: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
221: When hr_api.parent_integrity_violated Then
222: -- Parent integrity has been violated
223: ssp_mat_shd.g_api_dml := false; -- Unset the api dml status
224: ssp_mat_shd.constraint_error
225: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

221: When hr_api.parent_integrity_violated Then
222: -- Parent integrity has been violated
223: ssp_mat_shd.g_api_dml := false; -- Unset the api dml status
224: ssp_mat_shd.constraint_error
225: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
226: When hr_api.unique_integrity_violated Then
227: -- Unique integrity has been violated
228: ssp_mat_shd.g_api_dml := false; -- Unset the api dml status
229: ssp_mat_shd.constraint_error

Line 226: When hr_api.unique_integrity_violated Then

222: -- Parent integrity has been violated
223: ssp_mat_shd.g_api_dml := false; -- Unset the api dml status
224: ssp_mat_shd.constraint_error
225: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
226: When hr_api.unique_integrity_violated Then
227: -- Unique integrity has been violated
228: ssp_mat_shd.g_api_dml := false; -- Unset the api dml status
229: ssp_mat_shd.constraint_error
230: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

226: When hr_api.unique_integrity_violated Then
227: -- Unique integrity has been violated
228: ssp_mat_shd.g_api_dml := false; -- Unset the api dml status
229: ssp_mat_shd.constraint_error
230: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
231: When Others Then
232: ssp_mat_shd.g_api_dml := false; -- Unset the api dml status
233: Raise;
234: End insert_dml;

Line 376: Raise HR_Api.Validate_Enabled;

372: --
373: -- If we are validating then raise the Validate_Enabled exception
374: --
375: If p_validate then
376: Raise HR_Api.Validate_Enabled;
377: End If;
378: --
379: hr_utility.set_location(' Leaving:'||l_proc, 10);
380: Exception

Line 381: When HR_Api.Validate_Enabled Then

377: End If;
378: --
379: hr_utility.set_location(' Leaving:'||l_proc, 10);
380: Exception
381: When HR_Api.Validate_Enabled Then
382: --
383: -- As the Validate_Enabled exception has been raised
384: -- we must rollback to the savepoint
385: --