125: );
126: --
127: hr_utility.set_location(' Leaving:'||l_proc, 10);
128: Exception
129: When hr_api.check_integrity_violated Then
130: -- A check constraint has been violated
131: per_pss_shd.constraint_error
132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
133: When hr_api.parent_integrity_violated Then
128: Exception
129: When hr_api.check_integrity_violated Then
130: -- A check constraint has been violated
131: per_pss_shd.constraint_error
132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
133: When hr_api.parent_integrity_violated Then
134: -- Parent integrity has been violated
135: per_pss_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: When hr_api.check_integrity_violated Then
130: -- A check constraint has been violated
131: per_pss_shd.constraint_error
132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
133: When hr_api.parent_integrity_violated Then
134: -- Parent integrity has been violated
135: per_pss_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When hr_api.unique_integrity_violated Then
132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
133: When hr_api.parent_integrity_violated Then
134: -- Parent integrity has been violated
135: per_pss_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When hr_api.unique_integrity_violated Then
138: -- Unique integrity has been violated
139: per_pss_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
133: When hr_api.parent_integrity_violated Then
134: -- Parent integrity has been violated
135: per_pss_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When hr_api.unique_integrity_violated Then
138: -- Unique integrity has been violated
139: per_pss_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When Others Then
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When hr_api.unique_integrity_violated Then
138: -- Unique integrity has been violated
139: per_pss_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When Others Then
142: Raise;
143: End insert_dml;
144: --
302: => p_rec.attribute20
303: );
304:
305: exception
306: when hr_api.cannot_find_prog_unit then
307: hr_api.cannot_find_prog_unit_error
308: (p_module_name => 'PER_SALARY_SURVEYS'
309: ,p_hook_type => 'AI'
310: );
303: );
304:
305: exception
306: when hr_api.cannot_find_prog_unit then
307: hr_api.cannot_find_prog_unit_error
308: (p_module_name => 'PER_SALARY_SURVEYS'
309: ,p_hook_type => 'AI'
310: );
311: end;