124: );
125: --
126: hr_utility.set_location(' Leaving:'||l_proc, 10);
127: Exception
128: When hr_api.check_integrity_violated Then
129: -- A check constraint has been violated
130: per_pdm_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When hr_api.parent_integrity_violated Then
127: Exception
128: When hr_api.check_integrity_violated Then
129: -- A check constraint has been violated
130: per_pdm_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When hr_api.parent_integrity_violated Then
133: -- Parent integrity has been violated
134: per_pdm_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When hr_api.check_integrity_violated Then
129: -- A check constraint has been violated
130: per_pdm_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When hr_api.parent_integrity_violated Then
133: -- Parent integrity has been violated
134: per_pdm_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.unique_integrity_violated Then
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When hr_api.parent_integrity_violated Then
133: -- Parent integrity has been violated
134: per_pdm_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.unique_integrity_violated Then
137: -- Unique integrity has been violated
138: per_pdm_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When hr_api.parent_integrity_violated Then
133: -- Parent integrity has been violated
134: per_pdm_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.unique_integrity_violated Then
137: -- Unique integrity has been violated
138: per_pdm_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When Others Then
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.unique_integrity_violated Then
137: -- Unique integrity has been violated
138: per_pdm_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When Others Then
141: Raise;
142: End insert_dml;
143: --
280: );
281: --
282: exception
283: --
284: when hr_api.cannot_find_prog_unit then
285: --
286: hr_api.cannot_find_prog_unit_error
287: (p_module_name => 'PER_PERSON_DLVRY_METHODS'
288: ,p_hook_type => 'AI');
282: exception
283: --
284: when hr_api.cannot_find_prog_unit then
285: --
286: hr_api.cannot_find_prog_unit_error
287: (p_module_name => 'PER_PERSON_DLVRY_METHODS'
288: ,p_hook_type => 'AI');
289: --
290: end;
333: (
334: p_effective_date in date,
335: p_delivery_method_id out nocopy number,
336: p_date_start in date,
337: p_date_end in date default hr_api.g_eot,
338: p_person_id in number,
339: p_comm_dlvry_method in varchar2,
340: p_preferred_flag in varchar2 default null,
341: p_object_version_number out nocopy number,