eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CA_RL2_REG dependencies on HR_UTILITY

Line 63: --hr_utility.trace_on('Y','RL2');

59: l_taxyear varchar2(100);
60: l_pre_org_id varchar2(100);
61:
62: begin
63: --hr_utility.trace_on('Y','RL2');
64: hr_utility.trace('begining of range_cursor 1 ');
65:
66: select legislative_parameters
67: into leg_param

Line 64: hr_utility.trace('begining of range_cursor 1 ');

60: l_pre_org_id varchar2(100);
61:
62: begin
63: --hr_utility.trace_on('Y','RL2');
64: hr_utility.trace('begining of range_cursor 1 ');
65:
66: select legislative_parameters
67: into leg_param
68: from pay_payroll_actions ppa

Line 96: hr_utility.trace('End of range_cursor 2 ');

92: and paa_arch.serial_number = nvl(pay_ca_rl2_reg.get_parameter(''PER_ID'',ppa_reg.legislative_parameters),
93: paa_arch.serial_number)
94: order by to_number(paa_arch.serial_number)';
95:
96: hr_utility.trace('End of range_cursor 2 ');
97: end range_cursor;
98: /*
99: -------------------------------- action_creation ----------------------------------
100: */

Line 300: --hr_utility.trace_on('Y','RL2PAPER');

296: and upper(hasa.include_or_exclude) = 'I');
297: */
298:
299: begin
300: --hr_utility.trace_on('Y','RL2PAPER');
301: hr_utility.set_location('procpyr',1);
302: hr_utility.trace('begining of action creation 1'||to_char(pactid));
303:
304: /* get report type and effective date */

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

297: */
298:
299: begin
300: --hr_utility.trace_on('Y','RL2PAPER');
301: hr_utility.set_location('procpyr',1);
302: hr_utility.trace('begining of action creation 1'||to_char(pactid));
303:
304: /* get report type and effective date */
305:

Line 302: hr_utility.trace('begining of action creation 1'||to_char(pactid));

298:
299: begin
300: --hr_utility.trace_on('Y','RL2PAPER');
301: hr_utility.set_location('procpyr',1);
302: hr_utility.trace('begining of action creation 1'||to_char(pactid));
303:
304: /* get report type and effective date */
305:
306: select effective_date,

Line 317: hr_utility.trace('legislative parameters is '||l_legislative_parameters);

313: l_legislative_parameters
314: from pay_payroll_actions
315: where payroll_action_id = pactid;
316:
317: hr_utility.trace('legislative parameters is '||l_legislative_parameters);
318:
319: l_year := pay_ca_rl2_reg.get_parameter('TAX_YEAR',l_legislative_parameters);
320: l_year_start := trunc(to_date(l_year,'YYYY'), 'Y');
321: l_year_end := add_months(trunc(to_date(l_year,'YYYY'), 'Y'),12) - 1;

Line 329: hr_utility.trace('else condition after open c_all_pres c_all_asg cursor 6 ');

325: l_rlreg_pre_org_id := pay_ca_rl2_reg.get_parameter('PRE_ORGANIZATION_ID',l_legislative_parameters);
326:
327: if l_rlreg_pre_org_id is NULL then
328: open c_all_pres;
329: hr_utility.trace('else condition after open c_all_pres c_all_asg cursor 6 ');
330: else
331: l_pre_org_id := l_rlreg_pre_org_id;
332: hr_utility.trace('begining of if condition 5 '||l_pre_org_id);
333: end if;

Line 332: hr_utility.trace('begining of if condition 5 '||l_pre_org_id);

328: open c_all_pres;
329: hr_utility.trace('else condition after open c_all_pres c_all_asg cursor 6 ');
330: else
331: l_pre_org_id := l_rlreg_pre_org_id;
332: hr_utility.trace('begining of if condition 5 '||l_pre_org_id);
333: end if;
334:
335:
336: if l_rlreg_pre_org_id is NULL then

Line 340: hr_utility.trace('Begining of else loop for c_all_pres 7 '|| l_pre_org_id);

336: if l_rlreg_pre_org_id is NULL then
337:
338: loop
339: fetch c_all_pres into l_pre_org_id;
340: hr_utility.trace('Begining of else loop for c_all_pres 7 '|| l_pre_org_id);
341:
342: exit when c_all_pres%notfound;
343:
344: open c_first_tax_unit_id(l_pre_org_id);

Line 377: hr_utility.trace('Not creating assignment action');

373:
374: if (l_person_id = l_prev_person_id and
375: l_pre_org_id = l_prev_pre_org_id) then
376:
377: hr_utility.trace('Not creating assignment action');
378:
379: else
380:
381: /* Get the primary assignment as the primary

Line 391: hr_utility.raise_error;

387: fetch c_get_asg_id into l_primary_asg;
388:
389: if c_get_asg_id%NOTFOUND then
390: close c_get_asg_id;
391: hr_utility.raise_error;
392: else
393: close c_get_asg_id;
394: end if;
395:

Line 403: hr_utility.trace('No Archived Person Found');

399: fetch c_archived_person_info
400: into ln_arch_asgact_id,
401: ln_arch_pact_id;
402: if c_archived_person_info%notfound then
403: hr_utility.trace('No Archived Person Found');
404: else
405:
406: select pay_assignment_actions_s.nextval
407: into lockingactid

Line 416: hr_utility.trace('after hr_nonrun_asact.insact'||to_char(l_asg_id));

412: pactid,
413: chunk,
414: l_pre_organization_id);
415:
416: hr_utility.trace('after hr_nonrun_asact.insact'||to_char(l_asg_id));
417:
418: lv_serial_number := 'QC' ||lpad(to_char(ln_arch_asgact_id),14,0)||
419: lpad(to_char(ln_arch_pact_id),14,0);
420:

Line 421: hr_utility.trace('lv_serial_number :' ||lv_serial_number);

417:
418: lv_serial_number := 'QC' ||lpad(to_char(ln_arch_asgact_id),14,0)||
419: lpad(to_char(ln_arch_pact_id),14,0);
420:
421: hr_utility.trace('lv_serial_number :' ||lv_serial_number);
422:
423: update pay_assignment_actions paa
424: set paa.serial_number = lv_serial_number
425: where paa.assignment_action_id = lockingactid;

Line 447: hr_utility.trace('No GRE for this PRE ');

443: end if;
444:
445: else
446: close c_first_tax_unit_id;
447: hr_utility.trace('No GRE for this PRE ');
448:
449: end if;
450:
451: end loop;

Line 490: hr_utility.trace('Not creating assignment action');

486:
487: if (l_person_id = l_prev_person_id and
488: l_pre_org_id = l_prev_pre_org_id) then
489:
490: hr_utility.trace('Not creating assignment action');
491:
492: else
493:
494: /* Get the primary assignment as the primary

Line 504: hr_utility.raise_error;

500: fetch c_get_asg_id into l_primary_asg;
501:
502: if c_get_asg_id%NOTFOUND then
503: close c_get_asg_id;
504: hr_utility.raise_error;
505: else
506: close c_get_asg_id;
507: end if;
508:

Line 516: hr_utility.trace('No Archived Person Found');

512: fetch c_archived_person_info
513: into ln_arch_asgact_id,
514: ln_arch_pact_id;
515: if c_archived_person_info%notfound then
516: hr_utility.trace('No Archived Person Found');
517: else
518:
519: select pay_assignment_actions_s.nextval
520: into lockingactid

Line 529: hr_utility.trace('after calling hr_nonrun_asact.insact '||to_char(lockingactid));

525: pactid,
526: chunk,
527: l_pre_organization_id);
528:
529: hr_utility.trace('after calling hr_nonrun_asact.insact '||to_char(lockingactid));
530:
531: lv_serial_number := 'QC' ||lpad(to_char(ln_arch_asgact_id),14,0)||
532: lpad(to_char(ln_arch_pact_id),14,0);
533:

Line 534: hr_utility.trace('lv_serial_number :' ||lv_serial_number);

530:
531: lv_serial_number := 'QC' ||lpad(to_char(ln_arch_asgact_id),14,0)||
532: lpad(to_char(ln_arch_pact_id),14,0);
533:
534: hr_utility.trace('lv_serial_number :' ||lv_serial_number);
535:
536: update pay_assignment_actions paa
537: set paa.serial_number = lv_serial_number
538: where paa.assignment_action_id = lockingactid;

Line 558: hr_utility.trace('End of cursor c_all_asg 12');

554: else
555: close c_all_asg;
556: end if;
557:
558: hr_utility.trace('End of cursor c_all_asg 12');
559: else
560: close c_first_tax_unit_id;
561: hr_utility.trace('No GRE for this PRE ');
562: end if;

Line 561: hr_utility.trace('No GRE for this PRE ');

557:
558: hr_utility.trace('End of cursor c_all_asg 12');
559: else
560: close c_first_tax_unit_id;
561: hr_utility.trace('No GRE for this PRE ');
562: end if;
563: end if;
564: end action_creation;
565: /*

Line 574: hr_utility.trace('Start of Sort_Action 1');

570: sqlstr in out nocopy varchar2, /* string holding the sql statement */
571: len out nocopy number) /* length of the sql string */
572: is
573: begin
574: hr_utility.trace('Start of Sort_Action 1');
575:
576: sqlstr := 'select paa1.rowid /* we need the row id of the assignment actions that are created by PYUGEN */
577: from hr_all_organization_units hou1,
578: hr_all_organization_units hou,

Line 616: hr_utility.trace('End of Sort_Action 2');

612: ''RL1_LOC'',loc.location_code,null)
613: ,ppf.last_name,ppf.first_name';
614:
615: len := length(sqlstr); -- return the length of the string.
616: hr_utility.trace('End of Sort_Action 2');
617: end sort_action;
618: /*
619: ------------------------------ get_parameter -------------------------------
620: */