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.

[Home] [Help]

APPS.PAY_CA_PAYRG_PKG dependencies on HR_UTILITY

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

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

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

377: -- but we have to take into account assignments and
378: -- personal payment methods.
379: BEGIN
380: --hr_utility.trace_on(null,'PAYREG');
381: hr_utility.set_location('procpyr',1);
382:
383: prev_assignment_id := 0;
384: prev_tax_unit_id := 0;
385: prev_source_action_id := 0;

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

409: lv_pyrl_arch_lvl := 'GRE';
410: end if;
411: close c_arch_lvl;
412:
413: hr_utility.trace('lv_pyrl_arch_lvl = '||lv_pyrl_arch_lvl);
414:
415: open c_sepchk_run_type;
416: fetch c_sepchk_run_type into ln_sepchk_run_tp_id;
417: close c_sepchk_run_type;

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

415: open c_sepchk_run_type;
416: fetch c_sepchk_run_type into ln_sepchk_run_tp_id;
417: close c_sepchk_run_type;
418:
419: hr_utility.trace('ln_sepchk_run_tp_id = '||ln_sepchk_run_tp_id);
420:
421: open c_actions(pactid,stperson,endperson,
422: ln_leg_cons_set_id,
423: ln_leg_payroll_id,

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

430: l_asg_set_id := pay_payrg_pkg.get_parameter('PASID',l_leg_param);
431:
432: num := 0;
433: loop
434: hr_utility.set_location('procpyr',2);
435:
436: fetch c_actions into lockedactid
437: ,assignid
438: ,greid

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

461: open c_get_map_flag(lockedactid);
462: fetch c_get_map_flag into lv_multi_asg_flag;
463: close c_get_map_flag;
464:
465: hr_utility.trace('lv_multi_asg_flag = '||lv_multi_asg_flag);
466:
467: --if l_asg_flag = 'Y' then removed as no parameter for assignment set
468:
469: if actiontype in ( 'P', 'U' ) then

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

549: end if;
550:
551: end if;
552:
553: hr_utility.trace('lockedactid = '||lockedactid);
554: hr_utility.trace('ln_assignment_id = '||ln_assignment_id);
555: hr_utility.trace('ln_pp_aaid = '||ln_pp_aaid);
556: hr_utility.trace('lv_run_action_type = '||lv_run_action_type);
557: hr_utility.trace('lv_sep_check = '||lv_sep_check);

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

550:
551: end if;
552:
553: hr_utility.trace('lockedactid = '||lockedactid);
554: hr_utility.trace('ln_assignment_id = '||ln_assignment_id);
555: hr_utility.trace('ln_pp_aaid = '||ln_pp_aaid);
556: hr_utility.trace('lv_run_action_type = '||lv_run_action_type);
557: hr_utility.trace('lv_sep_check = '||lv_sep_check);
558:

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

551: end if;
552:
553: hr_utility.trace('lockedactid = '||lockedactid);
554: hr_utility.trace('ln_assignment_id = '||ln_assignment_id);
555: hr_utility.trace('ln_pp_aaid = '||ln_pp_aaid);
556: hr_utility.trace('lv_run_action_type = '||lv_run_action_type);
557: hr_utility.trace('lv_sep_check = '||lv_sep_check);
558:
559: hr_utility.trace('----------------------------------');

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

552:
553: hr_utility.trace('lockedactid = '||lockedactid);
554: hr_utility.trace('ln_assignment_id = '||ln_assignment_id);
555: hr_utility.trace('ln_pp_aaid = '||ln_pp_aaid);
556: hr_utility.trace('lv_run_action_type = '||lv_run_action_type);
557: hr_utility.trace('lv_sep_check = '||lv_sep_check);
558:
559: hr_utility.trace('----------------------------------');
560: hr_utility.trace('prev_tax_unit_id = '||prev_tax_unit_id);

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

553: hr_utility.trace('lockedactid = '||lockedactid);
554: hr_utility.trace('ln_assignment_id = '||ln_assignment_id);
555: hr_utility.trace('ln_pp_aaid = '||ln_pp_aaid);
556: hr_utility.trace('lv_run_action_type = '||lv_run_action_type);
557: hr_utility.trace('lv_sep_check = '||lv_sep_check);
558:
559: hr_utility.trace('----------------------------------');
560: hr_utility.trace('prev_tax_unit_id = '||prev_tax_unit_id);
561: hr_utility.trace('ln_tax_unit_id = '||ln_tax_unit_id);

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

555: hr_utility.trace('ln_pp_aaid = '||ln_pp_aaid);
556: hr_utility.trace('lv_run_action_type = '||lv_run_action_type);
557: hr_utility.trace('lv_sep_check = '||lv_sep_check);
558:
559: hr_utility.trace('----------------------------------');
560: hr_utility.trace('prev_tax_unit_id = '||prev_tax_unit_id);
561: hr_utility.trace('ln_tax_unit_id = '||ln_tax_unit_id);
562: hr_utility.trace('prev_source_action_id = '||prev_source_action_id);
563: hr_utility.trace('ln_source_action_id = '||ln_source_action_id);

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

556: hr_utility.trace('lv_run_action_type = '||lv_run_action_type);
557: hr_utility.trace('lv_sep_check = '||lv_sep_check);
558:
559: hr_utility.trace('----------------------------------');
560: hr_utility.trace('prev_tax_unit_id = '||prev_tax_unit_id);
561: hr_utility.trace('ln_tax_unit_id = '||ln_tax_unit_id);
562: hr_utility.trace('prev_source_action_id = '||prev_source_action_id);
563: hr_utility.trace('ln_source_action_id = '||ln_source_action_id);
564: hr_utility.trace('----------------------------------');

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

557: hr_utility.trace('lv_sep_check = '||lv_sep_check);
558:
559: hr_utility.trace('----------------------------------');
560: hr_utility.trace('prev_tax_unit_id = '||prev_tax_unit_id);
561: hr_utility.trace('ln_tax_unit_id = '||ln_tax_unit_id);
562: hr_utility.trace('prev_source_action_id = '||prev_source_action_id);
563: hr_utility.trace('ln_source_action_id = '||ln_source_action_id);
564: hr_utility.trace('----------------------------------');
565:

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

558:
559: hr_utility.trace('----------------------------------');
560: hr_utility.trace('prev_tax_unit_id = '||prev_tax_unit_id);
561: hr_utility.trace('ln_tax_unit_id = '||ln_tax_unit_id);
562: hr_utility.trace('prev_source_action_id = '||prev_source_action_id);
563: hr_utility.trace('ln_source_action_id = '||ln_source_action_id);
564: hr_utility.trace('----------------------------------');
565:
566: if ( ( ln_source_action_id <> prev_source_action_id ) or

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

559: hr_utility.trace('----------------------------------');
560: hr_utility.trace('prev_tax_unit_id = '||prev_tax_unit_id);
561: hr_utility.trace('ln_tax_unit_id = '||ln_tax_unit_id);
562: hr_utility.trace('prev_source_action_id = '||prev_source_action_id);
563: hr_utility.trace('ln_source_action_id = '||ln_source_action_id);
564: hr_utility.trace('----------------------------------');
565:
566: if ( ( ln_source_action_id <> prev_source_action_id ) or
567: ( ln_tax_unit_id <> prev_tax_unit_id ) ) then

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

560: hr_utility.trace('prev_tax_unit_id = '||prev_tax_unit_id);
561: hr_utility.trace('ln_tax_unit_id = '||ln_tax_unit_id);
562: hr_utility.trace('prev_source_action_id = '||prev_source_action_id);
563: hr_utility.trace('ln_source_action_id = '||ln_source_action_id);
564: hr_utility.trace('----------------------------------');
565:
566: if ( ( ln_source_action_id <> prev_source_action_id ) or
567: ( ln_tax_unit_id <> prev_tax_unit_id ) ) then
568:

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

610: lockingactid,
611: ln_max_run_aa_id,
612: ln_assignment_id);
613:
614: hr_utility.trace('if lockingactid = '||lockingactid);
615: hr_utility.trace('if ln_max_run_aa_id= '||ln_max_run_aa_id);
616:
617: /*************************************************************
618: ** Getting all other elements of different assignments which

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

611: ln_max_run_aa_id,
612: ln_assignment_id);
613:
614: hr_utility.trace('if lockingactid = '||lockingactid);
615: hr_utility.trace('if ln_max_run_aa_id= '||ln_max_run_aa_id);
616:
617: /*************************************************************
618: ** Getting all other elements of different assignments which
619: ** are needed to be printed for

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

626: open c_sepchk_act_seq(ln_max_run_aa_id);
627: fetch c_sepchk_act_seq into ln_sepchk_act_seq;
628: close c_sepchk_act_seq;
629:
630: hr_utility.trace('ln_sepchk_act_seq= '||ln_sepchk_act_seq);
631: for c_asg in c_other_asg_for_sepchk(lockedactid
632: ,ln_assignment_id)
633: loop
634: hr_utility.trace('c_asg.assignment_id= '||c_asg.assignment_id);

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

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

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

638: fetch c_multi_asg_max_aaid into ln_action_sequence
639: ,ln_map_max_aaid;
640: close c_multi_asg_max_aaid;
641:
642: hr_utility.trace('ln_action_sequence= '||ln_action_sequence);
643: hr_utility.trace('ln_map_max_aaid= '||ln_map_max_aaid);
644:
645: insert into pay_us_rpt_totals
646: (session_id,

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

639: ,ln_map_max_aaid;
640: close c_multi_asg_max_aaid;
641:
642: hr_utility.trace('ln_action_sequence= '||ln_action_sequence);
643: hr_utility.trace('ln_map_max_aaid= '||ln_map_max_aaid);
644:
645: insert into pay_us_rpt_totals
646: (session_id,
647: tax_unit_id,

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

679: lockingactid,
680: ln_max_run_aa_id,
681: ln_assignment_id);
682:
683: hr_utility.trace('else lockingactid = '||lockingactid);
684: hr_utility.trace('else ln_max_run_aa_id= '||ln_max_run_aa_id);
685:
686: else
687: null;

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

680: ln_max_run_aa_id,
681: ln_assignment_id);
682:
683: hr_utility.trace('else lockingactid = '||lockingactid);
684: hr_utility.trace('else ln_max_run_aa_id= '||ln_max_run_aa_id);
685:
686: else
687: null;
688: end if;

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

700: select pay_assignment_actions_s.nextval
701: into lockingactid
702: from dual;
703:
704: hr_utility.trace('B4 insact'||to_char(lockingactid) ||','||
705: to_char(greid)||','||actiontype||','||to_char(runactid) );
706:
707: -- insert the action record.
708: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);

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

705: to_char(greid)||','||actiontype||','||to_char(runactid) );
706:
707: -- insert the action record.
708: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
709: hr_utility.trace('A4 insact'||to_char(lockingactid) ||','||
710: to_char(greid)||','||actiontype||','||to_char(runactid) );
711:
712: -- insert an interlock to this action.
713: hr_nonrun_asact.insint(lockingactid,lockedactid);