APPS.PY_ZA_PRORATE_PKG dependencies on HR_UTILITY

Line 243: hr_utility.set_location('py_za_prorate_pkg.pro_rate_days',1);

239:
240: -------------------------------------------------------------------------------
241: BEGIN -- MAIN --
242: -------------------------------------------------------------------------------
243: hr_utility.set_location('py_za_prorate_pkg.pro_rate_days',1);
244:
245: OPEN c_Timeperiod(PAYROLL_ACTION_ID);
246: FETCH c_Timeperiod INTO l_Pdates;
247: IF c_Timeperiod%NOTFOUND THEN

Line 252: hr_utility.set_location('py_za_prorate_pkg.pro_rate_days',2);

248: raise no_data_found;
249: END IF;
250: CLOSE c_Timeperiod;
251:
252: hr_utility.set_location('py_za_prorate_pkg.pro_rate_days',2);
253:
254: OPEN c_Assignment(ASSIGNMENT_ID);
255: FETCH c_Assignment INTO l_Adates;
256: IF c_Assignment%NOTFOUND THEN

Line 261: hr_utility.set_location('py_za_prorate_pkg.pro_rate_days',3);

257: raise no_data_found;
258: END IF;
259: CLOSE c_Assignment;
260:
261: hr_utility.set_location('py_za_prorate_pkg.pro_rate_days',3);
262:
263: l_asg_dys_wrkd := LEAST(l_Pdates.end_date,l_Adates.end_date)
264: - GREATEST(l_Pdates.start_date,l_Adates.start_date)
265: + 1;

Line 270: hr_utility.set_location('py_za_prorate_pkg.pro_rate_days',4);

266: l_dys_in_prd := l_Pdates.end_date - l_Pdates.start_date + 1;
267:
268: l_frctn := l_asg_dys_wrkd / l_dys_in_prd;
269:
270: hr_utility.set_location('py_za_prorate_pkg.pro_rate_days',4);
271: RETURN l_frctn;
272:
273: EXCEPTION
274: WHEN OTHERS THEN

Line 275: hr_utility.set_location('py_za_prorate_pkg.pro_rate_days',5);

271: RETURN l_frctn;
272:
273: EXCEPTION
274: WHEN OTHERS THEN
275: hr_utility.set_location('py_za_prorate_pkg.pro_rate_days',5);
276: hr_utility.set_message(801, 'py_za_prorate_pkg: '||TO_CHAR(SQLCODE));
277: hr_utility.raise_error;
278: -------------------------------------------------------------------------------
279: END pro_rate_days;

Line 276: hr_utility.set_message(801, 'py_za_prorate_pkg: '||TO_CHAR(SQLCODE));

272:
273: EXCEPTION
274: WHEN OTHERS THEN
275: hr_utility.set_location('py_za_prorate_pkg.pro_rate_days',5);
276: hr_utility.set_message(801, 'py_za_prorate_pkg: '||TO_CHAR(SQLCODE));
277: hr_utility.raise_error;
278: -------------------------------------------------------------------------------
279: END pro_rate_days;
280:

Line 277: hr_utility.raise_error;

273: EXCEPTION
274: WHEN OTHERS THEN
275: hr_utility.set_location('py_za_prorate_pkg.pro_rate_days',5);
276: hr_utility.set_message(801, 'py_za_prorate_pkg: '||TO_CHAR(SQLCODE));
277: hr_utility.raise_error;
278: -------------------------------------------------------------------------------
279: END pro_rate_days;
280:
281: