150: );
151: --
152: hr_utility.set_location(' Leaving:'||l_proc, 10);
153: Exception
154: When hr_api.check_integrity_violated Then
155: -- A check constraint has been violated
156: per_par_shd.constraint_error
157: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
158: When hr_api.parent_integrity_violated Then
153: Exception
154: When hr_api.check_integrity_violated Then
155: -- A check constraint has been violated
156: per_par_shd.constraint_error
157: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
158: When hr_api.parent_integrity_violated Then
159: -- Parent integrity has been violated
160: per_par_shd.constraint_error
161: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
154: When hr_api.check_integrity_violated Then
155: -- A check constraint has been violated
156: per_par_shd.constraint_error
157: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
158: When hr_api.parent_integrity_violated Then
159: -- Parent integrity has been violated
160: per_par_shd.constraint_error
161: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
162: When hr_api.unique_integrity_violated Then
157: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
158: When hr_api.parent_integrity_violated Then
159: -- Parent integrity has been violated
160: per_par_shd.constraint_error
161: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
162: When hr_api.unique_integrity_violated Then
163: -- Unique integrity has been violated
164: per_par_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
158: When hr_api.parent_integrity_violated Then
159: -- Parent integrity has been violated
160: per_par_shd.constraint_error
161: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
162: When hr_api.unique_integrity_violated Then
163: -- Unique integrity has been violated
164: per_par_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When Others Then
161: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
162: When hr_api.unique_integrity_violated Then
163: -- Unique integrity has been violated
164: per_par_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When Others Then
167: Raise;
168: End insert_dml;
169: --
337: p_attribute20 => p_rec.attribute20 ,
338: p_participant_usage_status=> p_rec.participant_usage_status);
339:
340: exception
341: when hr_api.cannot_find_prog_unit then
342: hr_api.cannot_find_prog_unit_error
343: ( p_module_name => 'PER_PARTICIPANTS'
344: ,p_hook_type => 'AI'
345: );
338: p_participant_usage_status=> p_rec.participant_usage_status);
339:
340: exception
341: when hr_api.cannot_find_prog_unit then
342: hr_api.cannot_find_prog_unit_error
343: ( p_module_name => 'PER_PARTICIPANTS'
344: ,p_hook_type => 'AI'
345: );
346: end;
401: --
402: -- If we are validating then raise the Validate_Enabled exception
403: --
404: If p_validate then
405: Raise HR_Api.Validate_Enabled;
406: End If;
407: --
408: hr_utility.set_location(' Leaving:'||l_proc, 10);
409: Exception
406: End If;
407: --
408: hr_utility.set_location(' Leaving:'||l_proc, 10);
409: Exception
410: When HR_Api.Validate_Enabled Then
411: --
412: -- As the Validate_Enabled exception has been raised
413: -- we must rollback to the savepoint
414: --