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

Line 178: --hr_utility.trace_on('Y','RL1');

174: l_payroll_id number;
175: leg_param pay_payroll_actions.legislative_parameters%type;
176:
177: begin
178: --hr_utility.trace_on('Y','RL1');
179: hr_utility.trace('begining of range_cursor 1 ');
180: select legislative_parameters
181: into leg_param
182: from pay_payroll_actions ppa

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

175: leg_param pay_payroll_actions.legislative_parameters%type;
176:
177: begin
178: --hr_utility.trace_on('Y','RL1');
179: hr_utility.trace('begining of range_cursor 1 ');
180: select legislative_parameters
181: into leg_param
182: from pay_payroll_actions ppa
183: where ppa.payroll_action_id = pactid;

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

214: and fai3.value = nvl(pay_ca_rl1_reg.get_parameter(''PER_ID'',
215: ppa.legislative_parameters),fai3.value)
216: order by to_number(fai3.value)';
217:
218: hr_utility.trace('End of range_cursor 2 ');
219: end range_cursor;
220: /*
221: -------------------------------- action_creation ----------------------------------
222: */

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

477: order by assignment_id desc,paf.effective_end_date desc;
478: --Changes for bug 15886428 ends
479:
480: begin
481: hr_utility.set_location('procpyr',1);
482: hr_utility.trace('begining of action creation 1'||to_char(pactid));
483:
484: /* get report type and effective date */
485:

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

478: --Changes for bug 15886428 ends
479:
480: begin
481: hr_utility.set_location('procpyr',1);
482: hr_utility.trace('begining of action creation 1'||to_char(pactid));
483:
484: /* get report type and effective date */
485:
486: select effective_date,

Line 505: hr_utility.trace('begining of action creation 2 '||

501: l_legislative_parameters
502: from pay_payroll_actions
503: where payroll_action_id = pactid;
504:
505: hr_utility.trace('begining of action creation 2 '||
506: to_char(l_bus_group_id));
507:
508: hr_utility.trace('legislative parameters is '||l_legislative_parameters);
509:

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

504:
505: hr_utility.trace('begining of action creation 2 '||
506: to_char(l_bus_group_id));
507:
508: hr_utility.trace('legislative parameters is '||l_legislative_parameters);
509:
510: l_year := pay_ca_rl1_reg.get_parameter('TAX_YEAR',l_legislative_parameters);
511: l_year_start := trunc(to_date(l_year,'YYYY'), 'Y');
512: l_year_end := add_months(trunc(to_date(l_year,'YYYY'), 'Y'),12) - 1;

Line 517: hr_utility.trace('begin action creation '||l_year||to_char(l_year_start)||to_char(l_year_end));

513: l_asg_set_id := pay_ca_rl1_reg.get_parameter('ASG_SET_ID',l_legislative_parameters);
514: lv_per_id := pay_ca_rl1_reg.get_parameter('PER_ID',l_legislative_parameters);
515: l_print_term := pay_ca_rl1_reg.get_parameter('PRINT_TERM',l_legislative_parameters);
516:
517: hr_utility.trace('begin action creation '||l_year||to_char(l_year_start)||to_char(l_year_end));
518:
519: l_rl1reg_pre_org_id := pay_ca_rl1_reg.get_parameter('PRE_ORGANIZATION_ID',
520: l_legislative_parameters);
521:

Line 522: hr_utility.trace('begining of action creation 4 *'||

518:
519: l_rl1reg_pre_org_id := pay_ca_rl1_reg.get_parameter('PRE_ORGANIZATION_ID',
520: l_legislative_parameters);
521:
522: hr_utility.trace('begining of action creation 4 *'||
523: l_rl1reg_pre_org_id||'*');
524:
525: if l_rl1reg_pre_org_id is NULL then
526: open c_all_pres;

Line 527: hr_utility.trace('else condition after open c_all_pres '||

523: l_rl1reg_pre_org_id||'*');
524:
525: if l_rl1reg_pre_org_id is NULL then
526: open c_all_pres;
527: hr_utility.trace('else condition after open c_all_pres '||
528: 'c_all_asg cursor 6 ');
529: else
530: l_pre_organization_id := l_rl1reg_pre_org_id;
531: hr_utility.trace('begining of if condition 5 '||l_pre_organization_id);

Line 531: hr_utility.trace('begining of if condition 5 '||l_pre_organization_id);

527: hr_utility.trace('else condition after open c_all_pres '||
528: 'c_all_asg cursor 6 ');
529: else
530: l_pre_organization_id := l_rl1reg_pre_org_id;
531: hr_utility.trace('begining of if condition 5 '||l_pre_organization_id);
532: end if;
533:
534: -- Code modification for bug 10399514 starts here
535: /* Initializing variable */

Line 558: hr_utility.trace('Begining of else loop for c_all_pres 7 '||

554:
555: if l_rl1reg_pre_org_id is NULL then
556: loop
557: fetch c_all_pres into l_pre_organization_id;
558: hr_utility.trace('Begining of else loop for c_all_pres 7 '||
559: l_pre_organization_id);
560: exit when c_all_pres%notfound;
561: open c_first_tax_unit_id(l_pre_organization_id);
562: fetch c_first_tax_unit_id into l_tax_unit_id;

Line 572: hr_utility.trace('opening c_all_asg_in_asgset_range CURSOR');

568:
569: /* Added this validation to fix bug#2135545 */
570: if l_asg_set_id is not null then
571: if l_person_on then
572: hr_utility.trace('opening c_all_asg_in_asgset_range CURSOR');
573: open c_all_asg_in_asgset_range(l_bus_group_id,
574: l_year_start , l_year_end);
575: else
576: hr_utility.trace('opening c_all_asg_in_asgset CURSOR');

Line 576: hr_utility.trace('opening c_all_asg_in_asgset CURSOR');

572: hr_utility.trace('opening c_all_asg_in_asgset_range CURSOR');
573: open c_all_asg_in_asgset_range(l_bus_group_id,
574: l_year_start , l_year_end);
575: else
576: hr_utility.trace('opening c_all_asg_in_asgset CURSOR');
577: open c_all_asg_in_asgset(l_bus_group_id,
578: l_year_start , l_year_end);
579: end if;
580: elsif lv_per_id is not null then

Line 582: hr_utility.trace('opening c_single_asg_range CURSOR');

578: l_year_start , l_year_end);
579: end if;
580: elsif lv_per_id is not null then
581: if l_person_on then
582: hr_utility.trace('opening c_single_asg_range CURSOR');
583: open c_single_asg_range(l_bus_group_id, l_year_start,
584: l_year_end, lv_per_id);
585: else
586: hr_utility.trace('opening c_single_asg CURSOR');

Line 586: hr_utility.trace('opening c_single_asg CURSOR');

582: hr_utility.trace('opening c_single_asg_range CURSOR');
583: open c_single_asg_range(l_bus_group_id, l_year_start,
584: l_year_end, lv_per_id);
585: else
586: hr_utility.trace('opening c_single_asg CURSOR');
587: open c_single_asg(l_bus_group_id, l_year_start,
588: l_year_end, lv_per_id);
589: end if;
590: else

Line 592: hr_utility.trace('opening c_all_asg_range CURSOR');

588: l_year_end, lv_per_id);
589: end if;
590: else
591: if l_person_on then
592: hr_utility.trace('opening c_all_asg_range CURSOR');
593: open c_all_asg_range(l_bus_group_id,
594: l_year_start, l_year_end);
595: else
596: hr_utility.trace('opening c_all_asg CURSOR');

Line 596: hr_utility.trace('opening c_all_asg CURSOR');

592: hr_utility.trace('opening c_all_asg_range CURSOR');
593: open c_all_asg_range(l_bus_group_id,
594: l_year_start, l_year_end);
595: else
596: hr_utility.trace('opening c_all_asg CURSOR');
597: open c_all_asg(l_bus_group_id,
598: l_year_start, l_year_end);
599: end if;
600: end if;

Line 630: hr_utility.trace('Begining of loop for c_all_asg 8 '||

626: exit when c_all_asg%notfound;
627: end if;
628: end if;
629:
630: hr_utility.trace('Begining of loop for c_all_asg 8 '||
631: to_char(l_asg_id));
632:
633: if ( l_person_id = l_prev_person_id and
634: l_pre_organization_id = l_prev_pre_organization_id) then

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

632:
633: if ( l_person_id = l_prev_person_id and
634: l_pre_organization_id = l_prev_pre_organization_id) then
635:
636: hr_utility.trace('Not creating assignment action');
637:
638: else
639: /* Get the primary assignment as the primary
640: assignment is the assignment_id that is

Line 660: hr_utility.raise_error;

656: open c_get_asg_id(l_person_id);
657: fetch c_get_asg_id into l_primary_asg,l_effective_end_date;
658: if c_get_asg_id%NOTFOUND then
659: close c_get_asg_id;
660: hr_utility.raise_error;
661: else
662: close c_get_asg_id;
663: end if;
664: end if;

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

674: fetch c_archived_person_info
675: into ln_arch_asgact_id,
676: ln_arch_pact_id;
677: if c_archived_person_info%notfound then
678: hr_utility.trace('No Archived Person Found');
679: else
680: select pay_assignment_actions_s.nextval
681: into lockingactid
682: from dual;

Line 691: hr_utility.trace('in if loop after calling '||

687: pactid,
688: chunk,
689: l_pre_org_id);
690:
691: hr_utility.trace('in if loop after calling '||
692: 'hr_nonrun_asact.insact pkg 9 '||to_char(l_asg_id));
693:
694: /* Added this to implement RL1 Register and RL1 Amendment Register
695: using the same report file */

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

695: using the same report file */
696: lv_serial_number := 'QC' ||lpad(to_char(ln_arch_asgact_id),14,0)||
697: lpad(to_char(ln_arch_pact_id),14,0);
698:
699: hr_utility.trace('lv_serial_number :' ||lv_serial_number);
700:
701: update pay_assignment_actions paa
702: set paa.serial_number = lv_serial_number
703: where paa.assignment_action_id = lockingactid;

Line 739: hr_utility.trace('No GRE for this PRE Organization id');

735: end if;
736:
737: else
738:
739: hr_utility.trace('No GRE for this PRE Organization id');
740: hr_utility.raise_error;
741:
742: end if;
743: end loop;

Line 740: hr_utility.raise_error;

736:
737: else
738:
739: hr_utility.trace('No GRE for this PRE Organization id');
740: hr_utility.raise_error;
741:
742: end if;
743: end loop;
744: close c_all_pres;

Line 757: hr_utility.trace('opening c_all_asg_in_asgset_range CURSOR');

753:
754: /* Added this validation to fix bug#2135545 */
755: if l_asg_set_id is not null then
756: if l_person_on then
757: hr_utility.trace('opening c_all_asg_in_asgset_range CURSOR');
758: open c_all_asg_in_asgset_range(l_bus_group_id,
759: l_year_start , l_year_end);
760: else
761: hr_utility.trace('opening c_all_asg_in_asgset CURSOR');

Line 761: hr_utility.trace('opening c_all_asg_in_asgset CURSOR');

757: hr_utility.trace('opening c_all_asg_in_asgset_range CURSOR');
758: open c_all_asg_in_asgset_range(l_bus_group_id,
759: l_year_start , l_year_end);
760: else
761: hr_utility.trace('opening c_all_asg_in_asgset CURSOR');
762: open c_all_asg_in_asgset(l_bus_group_id,
763: l_year_start , l_year_end);
764: end if;
765: elsif lv_per_id is not null then

Line 767: hr_utility.trace('opening c_single_asg_range CURSOR');

763: l_year_start , l_year_end);
764: end if;
765: elsif lv_per_id is not null then
766: if l_person_on then
767: hr_utility.trace('opening c_single_asg_range CURSOR');
768: open c_single_asg_range(l_bus_group_id, l_year_start,
769: l_year_end, lv_per_id);
770: else
771: hr_utility.trace('opening c_single_asg CURSOR');

Line 771: hr_utility.trace('opening c_single_asg CURSOR');

767: hr_utility.trace('opening c_single_asg_range CURSOR');
768: open c_single_asg_range(l_bus_group_id, l_year_start,
769: l_year_end, lv_per_id);
770: else
771: hr_utility.trace('opening c_single_asg CURSOR');
772: open c_single_asg(l_bus_group_id, l_year_start,
773: l_year_end, lv_per_id);
774: end if;
775: else

Line 777: hr_utility.trace('opening c_all_asg_range CURSOR');

773: l_year_end, lv_per_id);
774: end if;
775: else
776: if l_person_on then
777: hr_utility.trace('opening c_all_asg_range CURSOR');
778: open c_all_asg_range(l_bus_group_id,
779: l_year_start, l_year_end);
780: else
781: hr_utility.trace('opening c_all_asg CURSOR');

Line 781: hr_utility.trace('opening c_all_asg CURSOR');

777: hr_utility.trace('opening c_all_asg_range CURSOR');
778: open c_all_asg_range(l_bus_group_id,
779: l_year_start, l_year_end);
780: else
781: hr_utility.trace('opening c_all_asg CURSOR');
782: open c_all_asg(l_bus_group_id,
783: l_year_start, l_year_end);
784: end if;
785: end if;

Line 816: hr_utility.trace('Begining of if part loop for c_all_asg 10 '||

812: exit when c_all_asg%notfound;
813: end if;
814: end if;
815:
816: hr_utility.trace('Begining of if part loop for c_all_asg 10 '||
817: to_char(l_asg_id));
818:
819:
820: if ( l_person_id = l_prev_person_id and

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

819:
820: if ( l_person_id = l_prev_person_id and
821: l_pre_organization_id = l_prev_pre_organization_id) then
822:
823: hr_utility.trace('Not creating assignment action');
824:
825: else
826:
827: /* Get the primary assignment as the primary

Line 848: hr_utility.raise_error;

844: open c_get_asg_id(l_person_id);
845: fetch c_get_asg_id into l_primary_asg,l_effective_end_date;
846: if c_get_asg_id%NOTFOUND then
847: close c_get_asg_id;
848: hr_utility.raise_error;
849: else
850: close c_get_asg_id;
851: end if;
852: end if;

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

863: fetch c_archived_person_info
864: into ln_arch_asgact_id,
865: ln_arch_pact_id;
866: if c_archived_person_info%notfound then
867: hr_utility.trace('No Archived Person Found');
868: else
869: select pay_assignment_actions_s.nextval
870: into lockingactid
871: from dual;

Line 879: hr_utility.trace('in if loop after calling '||

875: l_primary_asg,
876: pactid,
877: chunk,
878: l_pre_org_id);
879: hr_utility.trace('in if loop after calling '||
880: 'hr_nonrun_asact.insact pkg 11 '||to_char(lockingactid));
881:
882: /* Added this to implement RL1 Register and RL1 Amendment Register
883: using the same report file */

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

883: using the same report file */
884: lv_serial_number := 'QC' ||lpad(to_char(ln_arch_asgact_id),14,0)||
885: lpad(to_char(ln_arch_pact_id),14,0);
886:
887: hr_utility.trace('lv_serial_number :' ||lv_serial_number);
888:
889: update pay_assignment_actions paa
890: set paa.serial_number = lv_serial_number
891: where paa.assignment_action_id = lockingactid;

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

921: close c_all_asg;
922: end if;
923: end if;
924:
925: hr_utility.trace('End of cursor c_all_asg 12');
926: end if;
927: end if;
928: hr_utility.trace('End of If Condition for Loop 13');
929: end action_creation;

Line 928: hr_utility.trace('End of If Condition for Loop 13');

924:
925: hr_utility.trace('End of cursor c_all_asg 12');
926: end if;
927: end if;
928: hr_utility.trace('End of If Condition for Loop 13');
929: end action_creation;
930: /*
931: ---------------------------------- sort_action ----------------------------------
932: */

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

936: sqlstr in out nocopy varchar2, /* string holding the sql statement */
937: len out nocopy number /* length of the sql string */
938: ) is
939: begin
940: hr_utility.trace('Start of Sort_Action 1');
941: -- assignment_type, primary_flag condition are added by sneelapa, for bug 7572889
942: sqlstr := 'select paa1.rowid /* we need the row id of the assignment actions that are created by PYUGEN */
943: from hr_all_organization_units hou1,
944: hr_all_organization_units hou,

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

984: -- paaf.effective_end_date,-1,to_date(''31-DEC-''||
985: -- to_char(paaf.effective_end_date,''YY'')) )
986:
987: len := length(sqlstr); -- return the length of the string.
988: hr_utility.trace('End of Sort_Action 2');
989: end sort_action;
990: /*
991: ------------------------------ get_parameter -------------------------------
992: */

Line 1060: hr_utility.set_message(801,'PAY_74040_EOY_EXCP_TURNS_18');

1056: fnd_date.canonical_to_date(lv_year)
1057: then
1058: lv_year := p_termination_dt;
1059: end if;
1060: hr_utility.set_message(801,'PAY_74040_EOY_EXCP_TURNS_18');
1061: -- hr_utility.set_message_token('ST_DATE',lv_eighteen);
1062: hr_utility.set_message_token('ST_DATE',lv_st_dt);
1063: hr_utility.set_message_token('END_DATE',lv_year);
1064: lv_message := hr_utility.get_message;

Line 1061: -- hr_utility.set_message_token('ST_DATE',lv_eighteen);

1057: then
1058: lv_year := p_termination_dt;
1059: end if;
1060: hr_utility.set_message(801,'PAY_74040_EOY_EXCP_TURNS_18');
1061: -- hr_utility.set_message_token('ST_DATE',lv_eighteen);
1062: hr_utility.set_message_token('ST_DATE',lv_st_dt);
1063: hr_utility.set_message_token('END_DATE',lv_year);
1064: lv_message := hr_utility.get_message;
1065: end if;

Line 1062: hr_utility.set_message_token('ST_DATE',lv_st_dt);

1058: lv_year := p_termination_dt;
1059: end if;
1060: hr_utility.set_message(801,'PAY_74040_EOY_EXCP_TURNS_18');
1061: -- hr_utility.set_message_token('ST_DATE',lv_eighteen);
1062: hr_utility.set_message_token('ST_DATE',lv_st_dt);
1063: hr_utility.set_message_token('END_DATE',lv_year);
1064: lv_message := hr_utility.get_message;
1065: end if;
1066: return(lv_message);

Line 1063: hr_utility.set_message_token('END_DATE',lv_year);

1059: end if;
1060: hr_utility.set_message(801,'PAY_74040_EOY_EXCP_TURNS_18');
1061: -- hr_utility.set_message_token('ST_DATE',lv_eighteen);
1062: hr_utility.set_message_token('ST_DATE',lv_st_dt);
1063: hr_utility.set_message_token('END_DATE',lv_year);
1064: lv_message := hr_utility.get_message;
1065: end if;
1066: return(lv_message);
1067: end get_rl1_message;

Line 1064: lv_message := hr_utility.get_message;

1060: hr_utility.set_message(801,'PAY_74040_EOY_EXCP_TURNS_18');
1061: -- hr_utility.set_message_token('ST_DATE',lv_eighteen);
1062: hr_utility.set_message_token('ST_DATE',lv_st_dt);
1063: hr_utility.set_message_token('END_DATE',lv_year);
1064: lv_message := hr_utility.get_message;
1065: end if;
1066: return(lv_message);
1067: end get_rl1_message;
1068: