DBA Data[Home] [Help]

APPS.PER_JBR_INS dependencies on HR_API

Line 146: When hr_api.check_integrity_violated Then

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

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

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

Line 151: When hr_api.parent_integrity_violated Then

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

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

151: When hr_api.parent_integrity_violated Then
152: -- Parent integrity has been violated
153: per_jbr_shd.g_api_dml := false; -- Unset the api dml status
154: per_jbr_shd.constraint_error
155: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
156: When hr_api.unique_integrity_violated Then
157: -- Unique integrity has been violated
158: per_jbr_shd.g_api_dml := false; -- Unset the api dml status
159: per_jbr_shd.constraint_error

Line 156: When hr_api.unique_integrity_violated Then

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

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

156: When hr_api.unique_integrity_violated Then
157: -- Unique integrity has been violated
158: per_jbr_shd.g_api_dml := false; -- Unset the api dml status
159: per_jbr_shd.constraint_error
160: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
161: When Others Then
162: per_jbr_shd.g_api_dml := false; -- Unset the api dml status
163: Raise;
164: End insert_dml;

Line 303: when hr_api.cannot_find_prog_unit then

299: p_attribute20 => p_rec.attribute20,
300: p_object_version_number => p_rec.object_version_number
301: );
302: exception
303: when hr_api.cannot_find_prog_unit then
304: hr_api.cannot_find_prog_unit_error
305: (p_module_name => 'PER_JOB_REQUIREMENTS'
306: ,p_hook_type => 'AI'
307: );

Line 304: hr_api.cannot_find_prog_unit_error

300: p_object_version_number => p_rec.object_version_number
301: );
302: exception
303: when hr_api.cannot_find_prog_unit then
304: hr_api.cannot_find_prog_unit_error
305: (p_module_name => 'PER_JOB_REQUIREMENTS'
306: ,p_hook_type => 'AI'
307: );
308: end;

Line 356: Raise HR_Api.Validate_Enabled;

352: --
353: -- If we are validating then raise the Validate_Enabled exception
354: --
355: If p_validate then
356: Raise HR_Api.Validate_Enabled;
357: End If;
358: --
359: hr_utility.set_location(' Leaving:'||l_proc, 10);
360: Exception

Line 361: When HR_Api.Validate_Enabled Then

357: End If;
358: --
359: hr_utility.set_location(' Leaving:'||l_proc, 10);
360: Exception
361: When HR_Api.Validate_Enabled Then
362: --
363: -- As the Validate_Enabled exception has been raised
364: -- we must rollback to the savepoint
365: --