APPS.PQH_RFT_UPD dependencies on HR_API

Line 75: When hr_api.check_integrity_violated Then

71: --
72: hr_utility.set_location(' Leaving:'||l_proc, 10);
73: --
74: Exception
75: When hr_api.check_integrity_violated Then
76: -- A check constraint has been violated
77: pqh_rft_shd.constraint_error
78: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
79: When hr_api.parent_integrity_violated Then

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

74: Exception
75: When hr_api.check_integrity_violated Then
76: -- A check constraint has been violated
77: pqh_rft_shd.constraint_error
78: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
79: When hr_api.parent_integrity_violated Then
80: -- Parent integrity has been violated
81: pqh_rft_shd.constraint_error
82: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 79: When hr_api.parent_integrity_violated Then

75: When hr_api.check_integrity_violated Then
76: -- A check constraint has been violated
77: pqh_rft_shd.constraint_error
78: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
79: When hr_api.parent_integrity_violated Then
80: -- Parent integrity has been violated
81: pqh_rft_shd.constraint_error
82: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
83: When hr_api.unique_integrity_violated Then

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

78: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
79: When hr_api.parent_integrity_violated Then
80: -- Parent integrity has been violated
81: pqh_rft_shd.constraint_error
82: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
83: When hr_api.unique_integrity_violated Then
84: -- Unique integrity has been violated
85: pqh_rft_shd.constraint_error
86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 83: When hr_api.unique_integrity_violated Then

79: When hr_api.parent_integrity_violated Then
80: -- Parent integrity has been violated
81: pqh_rft_shd.constraint_error
82: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
83: When hr_api.unique_integrity_violated Then
84: -- Unique integrity has been violated
85: pqh_rft_shd.constraint_error
86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
87: When Others Then

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

82: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
83: When hr_api.unique_integrity_violated Then
84: -- Unique integrity has been violated
85: pqh_rft_shd.constraint_error
86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
87: When Others Then
88: Raise;
89: End update_dml;
90: --

Line 193: when hr_api.cannot_find_prog_unit then

189: );
190: --
191: exception
192: --
193: when hr_api.cannot_find_prog_unit then
194: --
195: hr_api.cannot_find_prog_unit_error
196: (p_module_name => 'pqh_ref_templates'
197: ,p_hook_type => 'AU');

Line 195: hr_api.cannot_find_prog_unit_error

191: exception
192: --
193: when hr_api.cannot_find_prog_unit then
194: --
195: hr_api.cannot_find_prog_unit_error
196: (p_module_name => 'pqh_ref_templates'
197: ,p_hook_type => 'AU');
198: --
199: end;

Line 263: If (p_rec.base_template_id = hr_api.g_number) then

259: -- p_rec plsql record structure
260: -- to see if a system default is being used. If a system default
261: -- is being used then we must set to the 'current' argument value.
262: --
263: If (p_rec.base_template_id = hr_api.g_number) then
264: p_rec.base_template_id :=
265: pqh_rft_shd.g_old_rec.base_template_id;
266: End If;
267: If (p_rec.parent_template_id = hr_api.g_number) then

Line 267: If (p_rec.parent_template_id = hr_api.g_number) then

263: If (p_rec.base_template_id = hr_api.g_number) then
264: p_rec.base_template_id :=
265: pqh_rft_shd.g_old_rec.base_template_id;
266: End If;
267: If (p_rec.parent_template_id = hr_api.g_number) then
268: p_rec.parent_template_id :=
269: pqh_rft_shd.g_old_rec.parent_template_id;
270: End If;
271: If (p_rec.reference_type_cd = hr_api.g_varchar2) then

Line 271: If (p_rec.reference_type_cd = hr_api.g_varchar2) then

267: If (p_rec.parent_template_id = hr_api.g_number) then
268: p_rec.parent_template_id :=
269: pqh_rft_shd.g_old_rec.parent_template_id;
270: End If;
271: If (p_rec.reference_type_cd = hr_api.g_varchar2) then
272: p_rec.reference_type_cd :=
273: pqh_rft_shd.g_old_rec.reference_type_cd;
274: End If;
275:

Line 332: p_base_template_id in number default hr_api.g_number,

328: Procedure upd
329: (
330: p_effective_date in date,
331: p_ref_template_id in number,
332: p_base_template_id in number default hr_api.g_number,
333: p_parent_template_id in number default hr_api.g_number,
334: p_reference_type_cd in varchar2 default hr_api.g_varchar2,
335: p_object_version_number in out nocopy number
336: ) is

Line 333: p_parent_template_id in number default hr_api.g_number,

329: (
330: p_effective_date in date,
331: p_ref_template_id in number,
332: p_base_template_id in number default hr_api.g_number,
333: p_parent_template_id in number default hr_api.g_number,
334: p_reference_type_cd in varchar2 default hr_api.g_varchar2,
335: p_object_version_number in out nocopy number
336: ) is
337: --

Line 334: p_reference_type_cd in varchar2 default hr_api.g_varchar2,

330: p_effective_date in date,
331: p_ref_template_id in number,
332: p_base_template_id in number default hr_api.g_number,
333: p_parent_template_id in number default hr_api.g_number,
334: p_reference_type_cd in varchar2 default hr_api.g_varchar2,
335: p_object_version_number in out nocopy number
336: ) is
337: --
338: l_rec pqh_rft_shd.g_rec_type;