DBA Data[Home] [Help]

APPS.HR_SFT_UPD dependencies on HR_API

Line 81: When hr_api.check_integrity_violated Then

77: --
78: hr_utility.set_location(' Leaving:'||l_proc, 10);
79: --
80: Exception
81: When hr_api.check_integrity_violated Then
82: -- A check constraint has been violated
83: --
84: hr_sft_shd.constraint_error
85: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

81: When hr_api.check_integrity_violated Then
82: -- A check constraint has been violated
83: --
84: hr_sft_shd.constraint_error
85: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
86: When hr_api.parent_integrity_violated Then
87: -- Parent integrity has been violated
88: --
89: hr_sft_shd.constraint_error

Line 86: When hr_api.parent_integrity_violated Then

82: -- A check constraint has been violated
83: --
84: hr_sft_shd.constraint_error
85: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
86: When hr_api.parent_integrity_violated Then
87: -- Parent integrity has been violated
88: --
89: hr_sft_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

86: When hr_api.parent_integrity_violated Then
87: -- Parent integrity has been violated
88: --
89: hr_sft_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.unique_integrity_violated Then
92: -- Unique integrity has been violated
93: --
94: hr_sft_shd.constraint_error

Line 91: When hr_api.unique_integrity_violated Then

87: -- Parent integrity has been violated
88: --
89: hr_sft_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.unique_integrity_violated Then
92: -- Unique integrity has been violated
93: --
94: hr_sft_shd.constraint_error
95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

91: When hr_api.unique_integrity_violated Then
92: -- Unique integrity has been violated
93: --
94: hr_sft_shd.constraint_error
95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
96: When Others Then
97: --
98: Raise;
99: End update_dml;

Line 206: when hr_api.cannot_find_prog_unit then

202: );
203: --
204: exception
205: --
206: when hr_api.cannot_find_prog_unit then
207: --
208: hr_api.cannot_find_prog_unit_error
209: (p_module_name => 'HR_SOURCE_FORM_TEMPLATES'
210: ,p_hook_type => 'AU');

Line 208: hr_api.cannot_find_prog_unit_error

204: exception
205: --
206: when hr_api.cannot_find_prog_unit then
207: --
208: hr_api.cannot_find_prog_unit_error
209: (p_module_name => 'HR_SOURCE_FORM_TEMPLATES'
210: ,p_hook_type => 'AU');
211: --
212: end;

Line 272: If (p_rec.form_template_id_to = hr_api.g_number) then

268: -- p_rec plsql record structure
269: -- to see if a system default is being used. If a system default
270: -- is being used then we must set to the 'current' argument value.
271: --
272: If (p_rec.form_template_id_to = hr_api.g_number) then
273: p_rec.form_template_id_to :=
274: hr_sft_shd.g_old_rec.form_template_id_to;
275: End If;
276: If (p_rec.form_template_id_from = hr_api.g_number) then

Line 276: If (p_rec.form_template_id_from = hr_api.g_number) then

272: If (p_rec.form_template_id_to = hr_api.g_number) then
273: p_rec.form_template_id_to :=
274: hr_sft_shd.g_old_rec.form_template_id_to;
275: End If;
276: If (p_rec.form_template_id_from = hr_api.g_number) then
277: p_rec.form_template_id_from :=
278: hr_sft_shd.g_old_rec.form_template_id_from;
279: End If;
280: --

Line 334: ,p_form_template_id_to in number default hr_api.g_number

330: -- ----------------------------------------------------------------------------
331: Procedure upd
332: (p_source_form_template_id in number
333: ,p_object_version_number in out nocopy number
334: ,p_form_template_id_to in number default hr_api.g_number
335: ,p_form_template_id_from in number default hr_api.g_number
336: ) is
337: --
338: l_rec hr_sft_shd.g_rec_type;

Line 335: ,p_form_template_id_from in number default hr_api.g_number

331: Procedure upd
332: (p_source_form_template_id in number
333: ,p_object_version_number in out nocopy number
334: ,p_form_template_id_to in number default hr_api.g_number
335: ,p_form_template_id_from in number default hr_api.g_number
336: ) is
337: --
338: l_rec hr_sft_shd.g_rec_type;
339: l_proc varchar2(72) := g_package||'upd';