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_PAYRG_PKG dependencies on HR_UTILITY

Line 385: --hr_utility.trace_on(null,'PAYREG');

381: -- algorithm is quite similar to the other process cases,
382: -- but we have to take into account assignments and
383: -- personal payment methods.
384: BEGIN
385: --hr_utility.trace_on(null,'PAYREG');
386: hr_utility.set_location('procpyr',1);
387:
388: prev_assignment_id := 0;
389: prev_tax_unit_id := 0;

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

382: -- but we have to take into account assignments and
383: -- personal payment methods.
384: BEGIN
385: --hr_utility.trace_on(null,'PAYREG');
386: hr_utility.set_location('procpyr',1);
387:
388: prev_assignment_id := 0;
389: prev_tax_unit_id := 0;
390: prev_source_action_id := 0;

Line 418: hr_utility.trace('lv_pyrl_arch_lvl = '||lv_pyrl_arch_lvl);

414: lv_pyrl_arch_lvl := 'GRE';
415: end if;
416: close c_arch_lvl;
417:
418: hr_utility.trace('lv_pyrl_arch_lvl = '||lv_pyrl_arch_lvl);
419:
420: open c_sepchk_run_type;
421: fetch c_sepchk_run_type into ln_sepchk_run_tp_id;
422: close c_sepchk_run_type;

Line 424: hr_utility.trace('ln_sepchk_run_tp_id = '||ln_sepchk_run_tp_id);

420: open c_sepchk_run_type;
421: fetch c_sepchk_run_type into ln_sepchk_run_tp_id;
422: close c_sepchk_run_type;
423:
424: hr_utility.trace('ln_sepchk_run_tp_id = '||ln_sepchk_run_tp_id);
425:
426: open c_actions(pactid,stperson,endperson,
427: ln_leg_cons_set_id,
428: ln_leg_payroll_id,

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

435: l_asg_set_id := pay_payrg_pkg.get_parameter('PASID',l_leg_param);
436:
437: num := 0;
438: loop
439: hr_utility.set_location('procpyr',2);
440:
441: fetch c_actions into lockedactid
442: ,assignid
443: ,greid

Line 470: hr_utility.trace('lv_multi_asg_flag = '||lv_multi_asg_flag);

466: open c_get_map_flag(lockedactid);
467: fetch c_get_map_flag into lv_multi_asg_flag;
468: close c_get_map_flag;
469:
470: hr_utility.trace('lv_multi_asg_flag = '||lv_multi_asg_flag);
471:
472: --if l_asg_flag = 'Y' then removed as no parameter for assignment set
473:
474: if actiontype in ( 'P', 'U' ) then

Line 558: hr_utility.trace('lockedactid = '||lockedactid);

554: end if;
555:
556: end if;
557:
558: hr_utility.trace('lockedactid = '||lockedactid);
559: hr_utility.trace('ln_assignment_id = '||ln_assignment_id);
560: hr_utility.trace('ln_pp_aaid = '||ln_pp_aaid);
561: hr_utility.trace('lv_run_action_type = '||lv_run_action_type);
562: hr_utility.trace('lv_sep_check = '||lv_sep_check);

Line 559: hr_utility.trace('ln_assignment_id = '||ln_assignment_id);

555:
556: end if;
557:
558: hr_utility.trace('lockedactid = '||lockedactid);
559: hr_utility.trace('ln_assignment_id = '||ln_assignment_id);
560: hr_utility.trace('ln_pp_aaid = '||ln_pp_aaid);
561: hr_utility.trace('lv_run_action_type = '||lv_run_action_type);
562: hr_utility.trace('lv_sep_check = '||lv_sep_check);
563:

Line 560: hr_utility.trace('ln_pp_aaid = '||ln_pp_aaid);

556: end if;
557:
558: hr_utility.trace('lockedactid = '||lockedactid);
559: hr_utility.trace('ln_assignment_id = '||ln_assignment_id);
560: hr_utility.trace('ln_pp_aaid = '||ln_pp_aaid);
561: hr_utility.trace('lv_run_action_type = '||lv_run_action_type);
562: hr_utility.trace('lv_sep_check = '||lv_sep_check);
563:
564: hr_utility.trace('----------------------------------');

Line 561: hr_utility.trace('lv_run_action_type = '||lv_run_action_type);

557:
558: hr_utility.trace('lockedactid = '||lockedactid);
559: hr_utility.trace('ln_assignment_id = '||ln_assignment_id);
560: hr_utility.trace('ln_pp_aaid = '||ln_pp_aaid);
561: hr_utility.trace('lv_run_action_type = '||lv_run_action_type);
562: hr_utility.trace('lv_sep_check = '||lv_sep_check);
563:
564: hr_utility.trace('----------------------------------');
565: hr_utility.trace('prev_tax_unit_id = '||prev_tax_unit_id);

Line 562: hr_utility.trace('lv_sep_check = '||lv_sep_check);

558: hr_utility.trace('lockedactid = '||lockedactid);
559: hr_utility.trace('ln_assignment_id = '||ln_assignment_id);
560: hr_utility.trace('ln_pp_aaid = '||ln_pp_aaid);
561: hr_utility.trace('lv_run_action_type = '||lv_run_action_type);
562: hr_utility.trace('lv_sep_check = '||lv_sep_check);
563:
564: hr_utility.trace('----------------------------------');
565: hr_utility.trace('prev_tax_unit_id = '||prev_tax_unit_id);
566: hr_utility.trace('ln_tax_unit_id = '||ln_tax_unit_id);

Line 564: hr_utility.trace('----------------------------------');

560: hr_utility.trace('ln_pp_aaid = '||ln_pp_aaid);
561: hr_utility.trace('lv_run_action_type = '||lv_run_action_type);
562: hr_utility.trace('lv_sep_check = '||lv_sep_check);
563:
564: hr_utility.trace('----------------------------------');
565: hr_utility.trace('prev_tax_unit_id = '||prev_tax_unit_id);
566: hr_utility.trace('ln_tax_unit_id = '||ln_tax_unit_id);
567: hr_utility.trace('prev_source_action_id = '||prev_source_action_id);
568: hr_utility.trace('ln_source_action_id = '||ln_source_action_id);

Line 565: hr_utility.trace('prev_tax_unit_id = '||prev_tax_unit_id);

561: hr_utility.trace('lv_run_action_type = '||lv_run_action_type);
562: hr_utility.trace('lv_sep_check = '||lv_sep_check);
563:
564: hr_utility.trace('----------------------------------');
565: hr_utility.trace('prev_tax_unit_id = '||prev_tax_unit_id);
566: hr_utility.trace('ln_tax_unit_id = '||ln_tax_unit_id);
567: hr_utility.trace('prev_source_action_id = '||prev_source_action_id);
568: hr_utility.trace('ln_source_action_id = '||ln_source_action_id);
569: hr_utility.trace('----------------------------------');

Line 566: hr_utility.trace('ln_tax_unit_id = '||ln_tax_unit_id);

562: hr_utility.trace('lv_sep_check = '||lv_sep_check);
563:
564: hr_utility.trace('----------------------------------');
565: hr_utility.trace('prev_tax_unit_id = '||prev_tax_unit_id);
566: hr_utility.trace('ln_tax_unit_id = '||ln_tax_unit_id);
567: hr_utility.trace('prev_source_action_id = '||prev_source_action_id);
568: hr_utility.trace('ln_source_action_id = '||ln_source_action_id);
569: hr_utility.trace('----------------------------------');
570:

Line 567: hr_utility.trace('prev_source_action_id = '||prev_source_action_id);

563:
564: hr_utility.trace('----------------------------------');
565: hr_utility.trace('prev_tax_unit_id = '||prev_tax_unit_id);
566: hr_utility.trace('ln_tax_unit_id = '||ln_tax_unit_id);
567: hr_utility.trace('prev_source_action_id = '||prev_source_action_id);
568: hr_utility.trace('ln_source_action_id = '||ln_source_action_id);
569: hr_utility.trace('----------------------------------');
570:
571: if ( ( ln_source_action_id <> prev_source_action_id ) or

Line 568: hr_utility.trace('ln_source_action_id = '||ln_source_action_id);

564: hr_utility.trace('----------------------------------');
565: hr_utility.trace('prev_tax_unit_id = '||prev_tax_unit_id);
566: hr_utility.trace('ln_tax_unit_id = '||ln_tax_unit_id);
567: hr_utility.trace('prev_source_action_id = '||prev_source_action_id);
568: hr_utility.trace('ln_source_action_id = '||ln_source_action_id);
569: hr_utility.trace('----------------------------------');
570:
571: if ( ( ln_source_action_id <> prev_source_action_id ) or
572: ( ln_tax_unit_id <> prev_tax_unit_id ) ) then

Line 569: hr_utility.trace('----------------------------------');

565: hr_utility.trace('prev_tax_unit_id = '||prev_tax_unit_id);
566: hr_utility.trace('ln_tax_unit_id = '||ln_tax_unit_id);
567: hr_utility.trace('prev_source_action_id = '||prev_source_action_id);
568: hr_utility.trace('ln_source_action_id = '||ln_source_action_id);
569: hr_utility.trace('----------------------------------');
570:
571: if ( ( ln_source_action_id <> prev_source_action_id ) or
572: ( ln_tax_unit_id <> prev_tax_unit_id ) ) then
573:

Line 619: hr_utility.trace('if lockingactid = '||lockingactid);

615: lockingactid,
616: ln_max_run_aa_id,
617: ln_assignment_id);
618:
619: hr_utility.trace('if lockingactid = '||lockingactid);
620: hr_utility.trace('if ln_max_run_aa_id= '||ln_max_run_aa_id);
621:
622: /*************************************************************
623: ** Getting all other elements of different assignments which

Line 620: hr_utility.trace('if ln_max_run_aa_id= '||ln_max_run_aa_id);

616: ln_max_run_aa_id,
617: ln_assignment_id);
618:
619: hr_utility.trace('if lockingactid = '||lockingactid);
620: hr_utility.trace('if ln_max_run_aa_id= '||ln_max_run_aa_id);
621:
622: /*************************************************************
623: ** Getting all other elements of different assignments which
624: ** are needed to be printed for

Line 635: hr_utility.trace('ln_sepchk_act_seq= '||ln_sepchk_act_seq);

631: open c_sepchk_act_seq(ln_max_run_aa_id);
632: fetch c_sepchk_act_seq into ln_sepchk_act_seq;
633: close c_sepchk_act_seq;
634:
635: hr_utility.trace('ln_sepchk_act_seq= '||ln_sepchk_act_seq);
636: for c_asg in c_other_asg_for_sepchk(lockedactid
637: ,ln_assignment_id)
638: loop
639: hr_utility.trace('c_asg.assignment_id= '||c_asg.assignment_id);

Line 639: hr_utility.trace('c_asg.assignment_id= '||c_asg.assignment_id);

635: hr_utility.trace('ln_sepchk_act_seq= '||ln_sepchk_act_seq);
636: for c_asg in c_other_asg_for_sepchk(lockedactid
637: ,ln_assignment_id)
638: loop
639: hr_utility.trace('c_asg.assignment_id= '||c_asg.assignment_id);
640: open c_multi_asg_max_aaid(lockedactid
641: ,c_asg.assignment_id
642: ,ln_sepchk_act_seq);
643: fetch c_multi_asg_max_aaid into ln_action_sequence

Line 647: hr_utility.trace('ln_action_sequence= '||ln_action_sequence);

643: fetch c_multi_asg_max_aaid into ln_action_sequence
644: ,ln_map_max_aaid;
645: close c_multi_asg_max_aaid;
646:
647: hr_utility.trace('ln_action_sequence= '||ln_action_sequence);
648: hr_utility.trace('ln_map_max_aaid= '||ln_map_max_aaid);
649:
650: insert into pay_us_rpt_totals
651: (session_id,

Line 648: hr_utility.trace('ln_map_max_aaid= '||ln_map_max_aaid);

644: ,ln_map_max_aaid;
645: close c_multi_asg_max_aaid;
646:
647: hr_utility.trace('ln_action_sequence= '||ln_action_sequence);
648: hr_utility.trace('ln_map_max_aaid= '||ln_map_max_aaid);
649:
650: insert into pay_us_rpt_totals
651: (session_id,
652: tax_unit_id,

Line 688: hr_utility.trace('else lockingactid = '||lockingactid);

684: lockingactid,
685: ln_max_run_aa_id,
686: ln_assignment_id);
687:
688: hr_utility.trace('else lockingactid = '||lockingactid);
689: hr_utility.trace('else ln_max_run_aa_id= '||ln_max_run_aa_id);
690:
691: else
692: null;

Line 689: hr_utility.trace('else ln_max_run_aa_id= '||ln_max_run_aa_id);

685: ln_max_run_aa_id,
686: ln_assignment_id);
687:
688: hr_utility.trace('else lockingactid = '||lockingactid);
689: hr_utility.trace('else ln_max_run_aa_id= '||ln_max_run_aa_id);
690:
691: else
692: null;
693: end if;

Line 709: hr_utility.trace('B4 insact'||to_char(lockingactid) ||','||

705: select pay_assignment_actions_s.nextval
706: into lockingactid
707: from dual;
708:
709: hr_utility.trace('B4 insact'||to_char(lockingactid) ||','||
710: to_char(greid)||','||actiontype||','||to_char(runactid) );
711:
712: -- insert the action record.
713: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);

Line 714: hr_utility.trace('A4 insact'||to_char(lockingactid) ||','||

710: to_char(greid)||','||actiontype||','||to_char(runactid) );
711:
712: -- insert the action record.
713: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
714: hr_utility.trace('A4 insact'||to_char(lockingactid) ||','||
715: to_char(greid)||','||actiontype||','||to_char(runactid) );
716:
717: -- insert an interlock to this action.
718: hr_nonrun_asact.insint(lockingactid,lockedactid);