DBA Data[Home] [Help]

APPS.PAY_GB_WNU_RULES dependencies on HR_UTILITY

Line 53: hr_utility.set_location('Entering:'|| l_proc, 10);

49: aaf.effective_start_date and aaf.effective_end_date;
50: --
51: begin
52: --
53: hr_utility.set_location('Entering:'|| l_proc, 10);
54: --
55: -- Assign Variables
56: --
57: l_assignment_id := p_assignment_id;

Line 82: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');

78: open csr_bg;
79: fetch csr_bg into l_legislation_code;
80: if csr_bg%notfound then
81: close csr_bg;
82: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
83: hr_utility.raise_error;
84: end if;
85: --
86: close csr_bg;

Line 83: hr_utility.raise_error;

79: fetch csr_bg into l_legislation_code;
80: if csr_bg%notfound then
81: close csr_bg;
82: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
83: hr_utility.raise_error;
84: end if;
85: --
86: close csr_bg;
87: --

Line 103: hr_utility.set_location(l_proc, 20);

99: fetch csr_extra_info into l_ass_extra_info_id, l_ovn, l_not_included_in_wnu;
100:
101: if csr_extra_info%notfound then
102: --
103: hr_utility.set_location(l_proc, 20);
104: --
105: -- Create an entry for WNU
106: --
107: if p_not_included_in_wnu is not null then

Line 129: hr_utility.set_location(l_proc, 30);

125: close csr_extra_info;
126:
127: else
128: --
129: hr_utility.set_location(l_proc, 30);
130: --
131: -- Update Existing Entry for WNU
132: --
133: if p_not_included_in_wnu is not null then

Line 156: hr_utility.set_location('Leaving:'|| l_proc, 100);

152: end if;
153: --
154: --end if;
155: --
156: hr_utility.set_location('Leaving:'|| l_proc, 100);
157: --
158: end;
159: --
160: -- BUG 3294480 Added this for the case when NI gets updated

Line 249: hr_utility.set_location('Entering:'|| l_proc, 10);

245: GROUP BY hsck.segment1;
246: --
247: begin
248: --
249: hr_utility.set_location('Entering:'|| l_proc, 10);
250:
251: -- Will only update Currnt Employee Records
252: --
253: open csr_employee;

Line 271: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');

267: open csr_bg(asg_id.assignment_id);
268: fetch csr_bg into l_legislation_code;
269: if csr_bg%notfound then
270: close csr_bg;
271: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
272: hr_utility.raise_error;
273: end if;
274: --
275: close csr_bg;

Line 272: hr_utility.raise_error;

268: fetch csr_bg into l_legislation_code;
269: if csr_bg%notfound then
270: close csr_bg;
271: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
272: hr_utility.raise_error;
273: end if;
274: --
275: close csr_bg;
276: --

Line 292: hr_utility.set_location(l_proc, 20);

288: fetch csr_extra_info into l_ass_extra_info_id, l_ovn,l_ass_number_old, l_not_included_in_wnu,l_ni_number_update;
289:
290: if csr_extra_info%notfound then
291: --
292: hr_utility.set_location(l_proc, 20);
293: --
294: -- Create an entry for WNU
295: --
296: if p_not_included_in_wnu is not null then

Line 319: hr_utility.set_location(l_proc, 30);

315: close csr_extra_info;
316:
317: else
318: --
319: hr_utility.set_location(l_proc, 30);
320: --
321: -- Update Existing Entry for WNU
322: --
323: if p_not_included_in_wnu is not null then

Line 355: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');

351: open csr_bg(asg_id.assignment_id);
352: fetch csr_bg into l_legislation_code;
353: if csr_bg%notfound then
354: close csr_bg;
355: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
356: hr_utility.raise_error;
357: end if;
358: --
359: close csr_bg;

Line 356: hr_utility.raise_error;

352: fetch csr_bg into l_legislation_code;
353: if csr_bg%notfound then
354: close csr_bg;
355: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
356: hr_utility.raise_error;
357: end if;
358: --
359: close csr_bg;
360: --

Line 376: hr_utility.set_location(l_proc, 20);

372: fetch csr_extra_info into l_ass_extra_info_id, l_ovn,l_ass_number_old, l_not_included_in_wnu,l_ni_number_update;
373:
374: if csr_extra_info%notfound then
375: --
376: hr_utility.set_location(l_proc, 20);
377: --
378: -- Create an entry for WNU
379: --
380: if p_not_included_in_wnu is not null then

Line 403: hr_utility.set_location(l_proc, 30);

399: close csr_extra_info;
400:
401: else
402: --
403: hr_utility.set_location(l_proc, 30);
404: --
405: -- Update Existing Entry for WNU
406: --
407: if p_not_included_in_wnu is not null then

Line 434: hr_utility.set_location('Leaving:'|| l_proc, 100);

430: end if;
431: --
432: end if;
433: --
434: hr_utility.set_location('Leaving:'|| l_proc, 100);
435: --
436: end;
437: --
438: end pay_gb_wnu_rules;