APPS.PAY_NL_TAX_PKG dependencies on HR_UTILITY

Line 44: -- hr_utility.set_location('Entering:'|| l_proc, 5);

40: AND p_date_earned BETWEEN paf.effective_start_date AND paf.effective_end_date;
41: --
42: BEGIN
43: --
44: -- hr_utility.set_location('Entering:'|| l_proc, 5);
45:
46: --
47: OPEN get_period_dates;
48: FETCH get_period_dates INTO l_period_start_date,l_period_end_date;

Line 57: hr_utility.set_location('- Name = '|| v_last_name, 5);

53: OPEN get_dob;
54: FETCH get_dob INTO l_dob,v_last_name,v_asg_number;
55: CLOSE get_dob;
56:
57: hr_utility.set_location('- Name = '|| v_last_name, 5);
58: hr_utility.set_location('- Asg No = '|| v_asg_number, 5);
59:
60: l_age_last_day_month := TRUNC(MONTHS_BETWEEN(last_day(p_date_earned),l_dob)/12);
61:

Line 58: hr_utility.set_location('- Asg No = '|| v_asg_number, 5);

54: FETCH get_dob INTO l_dob,v_last_name,v_asg_number;
55: CLOSE get_dob;
56:
57: hr_utility.set_location('- Name = '|| v_last_name, 5);
58: hr_utility.set_location('- Asg No = '|| v_asg_number, 5);
59:
60: l_age_last_day_month := TRUNC(MONTHS_BETWEEN(last_day(p_date_earned),l_dob)/12);
61:
62: IF l_dob >= l_period_start_date AND l_dob <= l_period_end_date THEN

Line 72: -- hr_utility.set_location('-l_dob = '|| l_dob, 5);

68: RETURN(TRUNC(MONTHS_BETWEEN(p_date_earned,l_dob)/12));
69: END IF;
70: END IF;
71: --
72: -- hr_utility.set_location('-l_dob = '|| l_dob, 5);
73: --
74: END get_age_payroll_period;
75: --
76: --

Line 156: hr_utility.set_location('Entering:'|| l_proc, 5);

152:
153: --
154: BEGIN
155: --
156: hr_utility.set_location('Entering:'|| l_proc, 5);
157: --
158: OPEN get_dob;
159: FETCH get_dob INTO l_dob;
160: CLOSE get_dob;

Line 246: hr_utility.set_location('Exception :'||l_proc||SQLERRM(SQLCODE),999);

242: WHEN NO_DATA_FOUND THEN
243: l_found:=FALSE;
244: return l_found;
245: when others then
246: hr_utility.set_location('Exception :'||l_proc||SQLERRM(SQLCODE),999);
247: END chk_lbr_tx_indicator;
248:
249: FUNCTION get_payroll_prd(p_payroll_id number)
250: RETURN VARCHAR2 IS

Line 275: hr_utility.set_location('Exception :'||l_proc||SQLERRM(SQLCODE),999);

271: FETCH get_pay_prd into l_pay_prd;
272: return l_pay_prd;
273: EXCEPTION
274: when others then
275: hr_utility.set_location('Exception :'||l_proc||SQLERRM(SQLCODE),999);
276: --
277: END get_payroll_prd;
278:
279: PROCEDURE chk_tax_code (p_tax_code in varchar2,

Line 295: --hr_utility.set_location('tax code'||p_tax_code||'len'||length(p_tax_code),999);

291: --
292: BEGIN
293:
294: p_valid:=TRUE;
295: --hr_utility.set_location('tax code'||p_tax_code||'len'||length(p_tax_code),999);
296: IF length(p_tax_code) <> 3 then
297: p_valid:=false;
298: ELSE
299: p_1_digit:=to_number(substr(p_tax_code,1,1));