237: per_qua_shd.g_api_dml := false; -- Unset the api dml status
238: --
239: hr_utility.set_location(' Leaving:'||l_proc, 10);
240: Exception
241: When hr_api.check_integrity_violated Then
242: -- A check constraint has been violated
243: per_qua_shd.g_api_dml := false; -- Unset the api dml status
244: per_qua_shd.constraint_error
245: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
241: When hr_api.check_integrity_violated Then
242: -- A check constraint has been violated
243: per_qua_shd.g_api_dml := false; -- Unset the api dml status
244: per_qua_shd.constraint_error
245: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
246: When hr_api.parent_integrity_violated Then
247: -- Parent integrity has been violated
248: per_qua_shd.g_api_dml := false; -- Unset the api dml status
249: per_qua_shd.constraint_error
242: -- A check constraint has been violated
243: per_qua_shd.g_api_dml := false; -- Unset the api dml status
244: per_qua_shd.constraint_error
245: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
246: When hr_api.parent_integrity_violated Then
247: -- Parent integrity has been violated
248: per_qua_shd.g_api_dml := false; -- Unset the api dml status
249: per_qua_shd.constraint_error
250: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
246: When hr_api.parent_integrity_violated Then
247: -- Parent integrity has been violated
248: per_qua_shd.g_api_dml := false; -- Unset the api dml status
249: per_qua_shd.constraint_error
250: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
251: When hr_api.unique_integrity_violated Then
252: -- Unique integrity has been violated
253: per_qua_shd.g_api_dml := false; -- Unset the api dml status
254: per_qua_shd.constraint_error
247: -- Parent integrity has been violated
248: per_qua_shd.g_api_dml := false; -- Unset the api dml status
249: per_qua_shd.constraint_error
250: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
251: When hr_api.unique_integrity_violated Then
252: -- Unique integrity has been violated
253: per_qua_shd.g_api_dml := false; -- Unset the api dml status
254: per_qua_shd.constraint_error
255: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
251: When hr_api.unique_integrity_violated Then
252: -- Unique integrity has been violated
253: per_qua_shd.g_api_dml := false; -- Unset the api dml status
254: per_qua_shd.constraint_error
255: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
256: When Others Then
257: per_qua_shd.g_api_dml := false; -- Unset the api dml status
258: Raise;
259: End insert_dml;
466: p_subscription_payment_method => p_rec.subscription_payment_method,
467: p_party_id => p_rec.party_id
468: );
469: exception
470: when hr_api.cannot_find_prog_unit then
471: hr_api.cannot_find_prog_unit_error
472: (p_module_name => 'PER_QUALIFICATIONS'
473: ,p_hook_type => 'AI'
474: );
467: p_party_id => p_rec.party_id
468: );
469: exception
470: when hr_api.cannot_find_prog_unit then
471: hr_api.cannot_find_prog_unit_error
472: (p_module_name => 'PER_QUALIFICATIONS'
473: ,p_hook_type => 'AI'
474: );
475: end;
529: --
530: -- If we are validating then raise the Validate_Enabled exception
531: --
532: If p_validate then
533: Raise HR_Api.Validate_Enabled;
534: End If;
535: --
536: hr_utility.set_location(' Leaving:'||l_proc, 10);
537: Exception
534: End If;
535: --
536: hr_utility.set_location(' Leaving:'||l_proc, 10);
537: Exception
538: When HR_Api.Validate_Enabled Then
539: --
540: -- As the Validate_Enabled exception has been raised
541: -- we must rollback to the savepoint
542: --