APPS.GHR_NRE_UPD dependencies on HR_API

Line 82: When hr_api.check_integrity_violated Then

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

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

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

Line 87: When hr_api.parent_integrity_violated Then

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

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

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

Line 92: When hr_api.unique_integrity_violated Then

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

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

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

Line 213: when hr_api.cannot_find_prog_unit then

209: );
210: --
211: exception
212: --
213: when hr_api.cannot_find_prog_unit then
214: --
215: hr_api.cannot_find_prog_unit_error
216: (p_module_name => 'ghr_noac_remarks'
217: ,p_hook_type => 'AU');

Line 215: hr_api.cannot_find_prog_unit_error

211: exception
212: --
213: when hr_api.cannot_find_prog_unit then
214: --
215: hr_api.cannot_find_prog_unit_error
216: (p_module_name => 'ghr_noac_remarks'
217: ,p_hook_type => 'AU');
218: --
219: end;

Line 286: If (p_rec.nature_of_action_id = hr_api.g_number) then

282: -- p_rec plsql record structure
283: -- to see if a system default is being used. If a system default
284: -- is being used then we must set to the 'current' argument value.
285: --
286: If (p_rec.nature_of_action_id = hr_api.g_number) then
287: p_rec.nature_of_action_id :=
288: ghr_nre_shd.g_old_rec.nature_of_action_id;
289: End If;
290: If (p_rec.remark_id = hr_api.g_number) then

Line 290: If (p_rec.remark_id = hr_api.g_number) then

286: If (p_rec.nature_of_action_id = hr_api.g_number) then
287: p_rec.nature_of_action_id :=
288: ghr_nre_shd.g_old_rec.nature_of_action_id;
289: End If;
290: If (p_rec.remark_id = hr_api.g_number) then
291: p_rec.remark_id :=
292: ghr_nre_shd.g_old_rec.remark_id;
293: End If;
294: If (p_rec.required_flag = hr_api.g_varchar2) then

Line 294: If (p_rec.required_flag = hr_api.g_varchar2) then

290: If (p_rec.remark_id = hr_api.g_number) then
291: p_rec.remark_id :=
292: ghr_nre_shd.g_old_rec.remark_id;
293: End If;
294: If (p_rec.required_flag = hr_api.g_varchar2) then
295: p_rec.required_flag :=
296: ghr_nre_shd.g_old_rec.required_flag;
297: End If;
298: If (p_rec.enabled_flag = hr_api.g_varchar2) then

Line 298: If (p_rec.enabled_flag = hr_api.g_varchar2) then

294: If (p_rec.required_flag = hr_api.g_varchar2) then
295: p_rec.required_flag :=
296: ghr_nre_shd.g_old_rec.required_flag;
297: End If;
298: If (p_rec.enabled_flag = hr_api.g_varchar2) then
299: p_rec.enabled_flag :=
300: ghr_nre_shd.g_old_rec.enabled_flag;
301: End If;
302: If (p_rec.date_from = hr_api.g_date) then

Line 302: If (p_rec.date_from = hr_api.g_date) then

298: If (p_rec.enabled_flag = hr_api.g_varchar2) then
299: p_rec.enabled_flag :=
300: ghr_nre_shd.g_old_rec.enabled_flag;
301: End If;
302: If (p_rec.date_from = hr_api.g_date) then
303: p_rec.date_from :=
304: ghr_nre_shd.g_old_rec.date_from;
305: End If;
306: If (p_rec.date_to = hr_api.g_date) then

Line 306: If (p_rec.date_to = hr_api.g_date) then

302: If (p_rec.date_from = hr_api.g_date) then
303: p_rec.date_from :=
304: ghr_nre_shd.g_old_rec.date_from;
305: End If;
306: If (p_rec.date_to = hr_api.g_date) then
307: p_rec.date_to :=
308: ghr_nre_shd.g_old_rec.date_to;
309: End If;
310:

Line 380: p_nature_of_action_id in number default hr_api.g_number,

376: Procedure upd
377: (
378: p_effective_date in date,
379: p_noac_remark_id in number,
380: p_nature_of_action_id in number default hr_api.g_number,
381: p_remark_id in number default hr_api.g_number,
382: p_required_flag in varchar2 default hr_api.g_varchar2,
383: p_enabled_flag in varchar2 default hr_api.g_varchar2,
384: p_date_from in date default hr_api.g_date,

Line 381: p_remark_id in number default hr_api.g_number,

377: (
378: p_effective_date in date,
379: p_noac_remark_id in number,
380: p_nature_of_action_id in number default hr_api.g_number,
381: p_remark_id in number default hr_api.g_number,
382: p_required_flag in varchar2 default hr_api.g_varchar2,
383: p_enabled_flag in varchar2 default hr_api.g_varchar2,
384: p_date_from in date default hr_api.g_date,
385: p_date_to in date default hr_api.g_date,

Line 382: p_required_flag in varchar2 default hr_api.g_varchar2,

378: p_effective_date in date,
379: p_noac_remark_id in number,
380: p_nature_of_action_id in number default hr_api.g_number,
381: p_remark_id in number default hr_api.g_number,
382: p_required_flag in varchar2 default hr_api.g_varchar2,
383: p_enabled_flag in varchar2 default hr_api.g_varchar2,
384: p_date_from in date default hr_api.g_date,
385: p_date_to in date default hr_api.g_date,
386: p_object_version_number in out NOCOPY number

Line 383: p_enabled_flag in varchar2 default hr_api.g_varchar2,

379: p_noac_remark_id in number,
380: p_nature_of_action_id in number default hr_api.g_number,
381: p_remark_id in number default hr_api.g_number,
382: p_required_flag in varchar2 default hr_api.g_varchar2,
383: p_enabled_flag in varchar2 default hr_api.g_varchar2,
384: p_date_from in date default hr_api.g_date,
385: p_date_to in date default hr_api.g_date,
386: p_object_version_number in out NOCOPY number
387: ) is

Line 384: p_date_from in date default hr_api.g_date,

380: p_nature_of_action_id in number default hr_api.g_number,
381: p_remark_id in number default hr_api.g_number,
382: p_required_flag in varchar2 default hr_api.g_varchar2,
383: p_enabled_flag in varchar2 default hr_api.g_varchar2,
384: p_date_from in date default hr_api.g_date,
385: p_date_to in date default hr_api.g_date,
386: p_object_version_number in out NOCOPY number
387: ) is
388: --

Line 385: p_date_to in date default hr_api.g_date,

381: p_remark_id in number default hr_api.g_number,
382: p_required_flag in varchar2 default hr_api.g_varchar2,
383: p_enabled_flag in varchar2 default hr_api.g_varchar2,
384: p_date_from in date default hr_api.g_date,
385: p_date_to in date default hr_api.g_date,
386: p_object_version_number in out NOCOPY number
387: ) is
388: --
389: l_rec ghr_nre_shd.g_rec_type;