APPS.PAY_PAYSLIP_REPORT dependencies on HR_UTILITY

Line 240: --hr_utility.trace('###### IN Qualifying Proc');

236: WHERE assignment_set_id = c_assignment_set_id
237: AND assignment_id = nvl(c_assignment_id,assignment_id);
238: --
239: BEGIN
240: --hr_utility.trace('###### IN Qualifying Proc');
241: --
242: l_actid := pay_proc_environment_pkg.get_pactid;
243: --
244: get_all_parameters(l_actid

Line 265: --hr_utility.trace(statem);

261: IF pay_payslip_report.g_pa_token IS NULL THEN
262: DECLARE
263: BEGIN
264: statem := 'BEGIN pay_'||l_legislation_code||'_rules.get_token_names(:p_pa_token, :p_cs_token); END;';
265: --hr_utility.trace(statem);
266: sql_cur := dbms_sql.open_cursor;
267: dbms_sql.parse(sql_cur
268: ,statem
269: ,dbms_sql.v7);

Line 295: --hr_utility.trace('###### 1.p_assignment_id '||p_assignment_id);

291: --
292: END IF;
293: ELSE
294: --
295: --hr_utility.trace('###### 1.p_assignment_id '||p_assignment_id);
296: --
297: IF l_assignment_set_id IS NOT NULL THEN
298: OPEN csr_inc_exc(l_assignment_set_id
299: ,NULL);

Line 323: --hr_utility.trace('###### 2.l_asg_inc_exc '||l_asg_inc_exc);

319: FETCH csr_inc_exc INTO l_asg_inc_exc;
320: CLOSE csr_inc_exc;
321: END IF;
322: --
323: --hr_utility.trace('###### 2.l_asg_inc_exc '||l_asg_inc_exc);
324: --hr_utility.trace('###### 2.l_qualifier '||l_qualifier);
325: --
326: IF NVL(l_asg_inc_exc,'X') <> 'E' AND l_qualifier = 'Y' THEN
327: --

Line 324: --hr_utility.trace('###### 2.l_qualifier '||l_qualifier);

320: CLOSE csr_inc_exc;
321: END IF;
322: --
323: --hr_utility.trace('###### 2.l_asg_inc_exc '||l_asg_inc_exc);
324: --hr_utility.trace('###### 2.l_qualifier '||l_qualifier);
325: --
326: IF NVL(l_asg_inc_exc,'X') <> 'E' AND l_qualifier = 'Y' THEN
327: --
328: p_qualifier := 'Y' ;

Line 413: --hr_utility.trace('###### IN XML_ASG');

409: AND pai.action_information_category = 'EMPLOYEE DETAILS'
410: AND pai.action_context_id = paa.assignment_action_id;
411: --
412: BEGIN
413: --hr_utility.trace('###### IN XML_ASG');
414: --
415: l_actid := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
416: --
417: get_all_parameters(l_actid

Line 435: --hr_utility.trace(statem);

431: IF pay_payslip_report.g_pa_token IS NULL THEN
432: DECLARE
433: BEGIN
434: statem := 'BEGIN pay_'||l_legislation_code||'_rules.get_token_names(:p_pa_token, :p_cs_token); END;';
435: --hr_utility.trace(statem);
436: sql_cur := dbms_sql.open_cursor;
437: dbms_sql.parse(sql_cur
438: ,statem
439: ,dbms_sql.v7);

Line 483: hr_utility.trace('The Custom XML code is: '||lv_custom_xml_code);

479: END IF;
480: END;
481: /*End Bug 13969852, 13969858*/
482:
483: hr_utility.trace('The Custom XML code is: '||lv_custom_xml_code);
484: --
485: pay_core_files.write_to_magtape_lob('');
486: pay_core_files.write_to_magtape_lob('');
487: --

Line 504: --hr_utility.trace('#### act_id '||csr_archive_act_rec.action_context_id);

500: ,P_ROOT_TAG => 'PAYSLIP'
501: ,P_DOCUMENT_TYPE => 'PAYSLIP'
502: ,P_XML => l_xml);
503: --
504: --hr_utility.trace('#### act_id '||csr_archive_act_rec.action_context_id);
505: pay_core_files.write_to_magtape_lob(l_xml);
506: --
507: END LOOP;
508: pay_core_files.write_to_magtape_lob('');