APPS.HR_NMF_UPD dependencies on HR_API

Line 77: When hr_api.check_integrity_violated Then

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

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

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

Line 81: When hr_api.parent_integrity_violated Then

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

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

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

Line 85: When hr_api.unique_integrity_violated Then

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

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

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

Line 208: when hr_api.cannot_find_prog_unit then

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

Line 210: hr_api.cannot_find_prog_unit_error

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

Line 275: If (p_rec.format_name = hr_api.g_varchar2) then

271: -- p_rec plsql record structure
272: -- to see if a system default is being used. If a system default
273: -- is being used then we must set to the 'current' argument value.
274: --
275: If (p_rec.format_name = hr_api.g_varchar2) then
276: p_rec.format_name :=
277: hr_nmf_shd.g_old_rec.format_name;
278: End If;
279: If (p_rec.legislation_code = hr_api.g_varchar2) then

Line 279: If (p_rec.legislation_code = hr_api.g_varchar2) then

275: If (p_rec.format_name = hr_api.g_varchar2) then
276: p_rec.format_name :=
277: hr_nmf_shd.g_old_rec.format_name;
278: End If;
279: If (p_rec.legislation_code = hr_api.g_varchar2) then
280: p_rec.legislation_code :=
281: hr_nmf_shd.g_old_rec.legislation_code;
282: End If;
283: If (p_rec.user_format_choice = hr_api.g_varchar2) then

Line 283: If (p_rec.user_format_choice = hr_api.g_varchar2) then

279: If (p_rec.legislation_code = hr_api.g_varchar2) then
280: p_rec.legislation_code :=
281: hr_nmf_shd.g_old_rec.legislation_code;
282: End If;
283: If (p_rec.user_format_choice = hr_api.g_varchar2) then
284: p_rec.user_format_choice :=
285: hr_nmf_shd.g_old_rec.user_format_choice;
286: End If;
287: If (p_rec.format_mask = hr_api.g_varchar2) then

Line 287: If (p_rec.format_mask = hr_api.g_varchar2) then

283: If (p_rec.user_format_choice = hr_api.g_varchar2) then
284: p_rec.user_format_choice :=
285: hr_nmf_shd.g_old_rec.user_format_choice;
286: End If;
287: If (p_rec.format_mask = hr_api.g_varchar2) then
288: p_rec.format_mask :=
289: hr_nmf_shd.g_old_rec.format_mask;
290: End If;
291: --

Line 357: ,p_format_mask in varchar2 default hr_api.g_varchar2

353: Procedure upd
354: (p_effective_date in date
355: ,p_name_format_id in number
356: ,p_object_version_number in out nocopy number
357: ,p_format_mask in varchar2 default hr_api.g_varchar2
358: ) is
359: --
360: l_rec hr_nmf_shd.g_rec_type;
361: l_proc varchar2(72) := g_package||'upd';

Line 374: ,hr_api.g_varchar2 --p_format_name

370: --
371: l_rec :=
372: hr_nmf_shd.convert_args
373: (p_name_format_id
374: ,hr_api.g_varchar2 --p_format_name
375: ,hr_api.g_varchar2 --p_legislation_code
376: ,hr_api.g_varchar2 --p_user_format_choice
377: ,p_format_mask
378: ,p_object_version_number

Line 375: ,hr_api.g_varchar2 --p_legislation_code

371: l_rec :=
372: hr_nmf_shd.convert_args
373: (p_name_format_id
374: ,hr_api.g_varchar2 --p_format_name
375: ,hr_api.g_varchar2 --p_legislation_code
376: ,hr_api.g_varchar2 --p_user_format_choice
377: ,p_format_mask
378: ,p_object_version_number
379: );

Line 376: ,hr_api.g_varchar2 --p_user_format_choice

372: hr_nmf_shd.convert_args
373: (p_name_format_id
374: ,hr_api.g_varchar2 --p_format_name
375: ,hr_api.g_varchar2 --p_legislation_code
376: ,hr_api.g_varchar2 --p_user_format_choice
377: ,p_format_mask
378: ,p_object_version_number
379: );
380: --