DBA Data[Home] [Help]

APPS.PER_SUB_INS dependencies on HR_API

Line 177: When hr_api.check_integrity_violated Then

173: per_sub_shd.g_api_dml := false; -- Unset the api dml status
174: --
175: hr_utility.set_location(' Leaving:'||l_proc, 10);
176: Exception
177: When hr_api.check_integrity_violated Then
178: -- A check constraint has been violated
179: per_sub_shd.g_api_dml := false; -- Unset the api dml status
180: per_sub_shd.constraint_error
181: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

177: When hr_api.check_integrity_violated Then
178: -- A check constraint has been violated
179: per_sub_shd.g_api_dml := false; -- Unset the api dml status
180: per_sub_shd.constraint_error
181: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
182: When hr_api.parent_integrity_violated Then
183: -- Parent integrity has been violated
184: per_sub_shd.g_api_dml := false; -- Unset the api dml status
185: per_sub_shd.constraint_error

Line 182: When hr_api.parent_integrity_violated Then

178: -- A check constraint has been violated
179: per_sub_shd.g_api_dml := false; -- Unset the api dml status
180: per_sub_shd.constraint_error
181: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
182: When hr_api.parent_integrity_violated Then
183: -- Parent integrity has been violated
184: per_sub_shd.g_api_dml := false; -- Unset the api dml status
185: per_sub_shd.constraint_error
186: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

182: When hr_api.parent_integrity_violated Then
183: -- Parent integrity has been violated
184: per_sub_shd.g_api_dml := false; -- Unset the api dml status
185: per_sub_shd.constraint_error
186: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
187: When hr_api.unique_integrity_violated Then
188: -- Unique integrity has been violated
189: per_sub_shd.g_api_dml := false; -- Unset the api dml status
190: per_sub_shd.constraint_error

Line 187: When hr_api.unique_integrity_violated Then

183: -- Parent integrity has been violated
184: per_sub_shd.g_api_dml := false; -- Unset the api dml status
185: per_sub_shd.constraint_error
186: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
187: When hr_api.unique_integrity_violated Then
188: -- Unique integrity has been violated
189: per_sub_shd.g_api_dml := false; -- Unset the api dml status
190: per_sub_shd.constraint_error
191: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

187: When hr_api.unique_integrity_violated Then
188: -- Unique integrity has been violated
189: per_sub_shd.g_api_dml := false; -- Unset the api dml status
190: per_sub_shd.constraint_error
191: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
192: When Others Then
193: per_sub_shd.g_api_dml := false; -- Unset the api dml status
194: Raise;
195: End insert_dml;

Line 352: when hr_api.cannot_find_prog_unit then

348: p_sub_information20 => p_rec.sub_information20,
349: p_effective_date => p_effective_date
350: );
351: exception
352: when hr_api.cannot_find_prog_unit then
353: hr_api.cannot_find_prog_unit_error
354: (p_module_name => 'PER_SUBJECTS_TAKEN'
355: ,p_hook_type => 'AI'
356: );

Line 353: hr_api.cannot_find_prog_unit_error

349: p_effective_date => p_effective_date
350: );
351: exception
352: when hr_api.cannot_find_prog_unit then
353: hr_api.cannot_find_prog_unit_error
354: (p_module_name => 'PER_SUBJECTS_TAKEN'
355: ,p_hook_type => 'AI'
356: );
357: end;

Line 407: Raise HR_Api.Validate_Enabled;

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

Line 412: When HR_Api.Validate_Enabled Then

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