APPS.PQP_EXPPREPROC_PKG dependencies on HR_UTILITY

Line 241: --hr_utility.trace_on('Y','ORACLE');

237: -- but we have to take into account assignments and
238: -- personal payment methods.
239: BEGIN
240:
241: --hr_utility.trace_on('Y','ORACLE');
242: hr_utility.set_location('procpyr',1);
243:
244: OPEN c_parameters(pactid);
245: FETCH c_parameters into leg_param,

Line 242: hr_utility.set_location('procpyr',1);

238: -- personal payment methods.
239: BEGIN
240:
241: --hr_utility.trace_on('Y','ORACLE');
242: hr_utility.set_location('procpyr',1);
243:
244: OPEN c_parameters(pactid);
245: FETCH c_parameters into leg_param,
246: l_consolidation_set_id,

Line 254: hr_utility.set_location('procpyr',1);

250: l_jd_cd
251: ;
252: CLOSE c_parameters;
253:
254: hr_utility.set_location('procpyr',1);
255:
256: l_off_date :=pqp_expreplod_pkg.get_offset_date
257: ( l_payroll_id
258: ,l_consolidation_set_id

Line 265: hr_utility.set_location('procpyr',2);

261: if l_payroll_id is null then -- Bug 14530472: If the report is run for entire consolodation set id
262: OPEN c_actions(pactid,stperson,endperson,l_off_date);
263: num := 0;
264: LOOP
265: hr_utility.set_location('procpyr',2);
266: fetch c_actions into lockedactid,assignid;
267: if c_actions%found then num := num + 1; end if;
268: exit when c_actions%notfound;
269:

Line 271: hr_utility.set_location('procpyr',3);

267: if c_actions%found then num := num + 1; end if;
268: exit when c_actions%notfound;
269:
270: --
271: hr_utility.set_location('procpyr',3);
272: select pay_assignment_actions_s.nextval
273: into lockingactid
274: from dual;
275: --

Line 288: hr_utility.set_location('procpyr',2);

284: else -- Bug 14530472: If the report is run for a single payroll
285: OPEN c_actions_with_payroll(pactid,stperson,endperson,l_off_date);
286: num := 0;
287: LOOP
288: hr_utility.set_location('procpyr',2);
289: fetch c_actions_with_payroll into lockedactid,assignid;
290: if c_actions_with_payroll%found then num := num + 1; end if;
291: exit when c_actions_with_payroll%notfound;
292:

Line 294: hr_utility.set_location('procpyr',3);

290: if c_actions_with_payroll%found then num := num + 1; end if;
291: exit when c_actions_with_payroll%notfound;
292:
293: --
294: hr_utility.set_location('procpyr',3);
295: select pay_assignment_actions_s.nextval
296: into lockingactid
297: from dual;
298: --