DBA Data[Home] [Help]

APPS.PER_PDM_INS dependencies on HR_API

Line 128: When hr_api.check_integrity_violated Then

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

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

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));

Line 132: When hr_api.parent_integrity_violated Then

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

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

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));

Line 136: When hr_api.unique_integrity_violated Then

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

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

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: --

Line 284: when hr_api.cannot_find_prog_unit then

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');

Line 286: hr_api.cannot_find_prog_unit_error

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;

Line 337: p_date_end in date default hr_api.g_eot,

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,