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

Line 114: hr_utility.trace('Entered get_payroll_action_info');

110: lv_prov_cd varchar2(5);
111: lv_report_type varchar2(50);
112:
113: BEGIN
114: hr_utility.trace('Entered get_payroll_action_info');
115: open c_payroll_action_info(p_payroll_action_id);
116: fetch c_payroll_action_info into ln_tax_unit_id,
117: ln_person_id,
118: ln_asg_set,

Line 127: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));

123: lv_prov_cd,
124: lv_report_type;
125: close c_payroll_action_info;
126:
127: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
128: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
129: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
130: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
131: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));

Line 128: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));

124: lv_report_type;
125: close c_payroll_action_info;
126:
127: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
128: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
129: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
130: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
131: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
132: hr_utility.trace('lv_prov_cd = ' || lv_prov_cd);

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

125: close c_payroll_action_info;
126:
127: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
128: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
129: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
130: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
131: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
132: hr_utility.trace('lv_prov_cd = ' || lv_prov_cd);
133:

Line 130: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));

126:
127: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
128: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
129: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
130: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
131: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
132: hr_utility.trace('lv_prov_cd = ' || lv_prov_cd);
133:
134: p_end_date := ld_end_date;

Line 131: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));

127: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
128: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
129: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
130: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
131: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
132: hr_utility.trace('lv_prov_cd = ' || lv_prov_cd);
133:
134: p_end_date := ld_end_date;
135: p_start_date := ld_start_date;

Line 132: hr_utility.trace('lv_prov_cd = ' || lv_prov_cd);

128: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
129: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
130: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
131: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
132: hr_utility.trace('lv_prov_cd = ' || lv_prov_cd);
133:
134: p_end_date := ld_end_date;
135: p_start_date := ld_start_date;
136: p_business_group_id := ln_business_group_id;

Line 144: hr_utility.trace('Leaving get_payroll_action_info');

140: p_print := lv_print;
141: p_prov_cd := lv_prov_cd;
142: p_report_type := lv_report_type;
143:
144: hr_utility.trace('Leaving get_payroll_action_info');
145:
146: EXCEPTION
147: when others then
148: hr_utility.trace('Error in ' || gv_procedure_name ||

Line 148: hr_utility.trace('Error in ' || gv_procedure_name ||

144: hr_utility.trace('Leaving get_payroll_action_info');
145:
146: EXCEPTION
147: when others then
148: hr_utility.trace('Error in ' || gv_procedure_name ||
149: to_char(sqlcode) || '-' || sqlerrm);
150: raise hr_utility.hr_error;
151:
152: END get_payroll_action_info;

Line 150: raise hr_utility.hr_error;

146: EXCEPTION
147: when others then
148: hr_utility.trace('Error in ' || gv_procedure_name ||
149: to_char(sqlcode) || '-' || sqlerrm);
150: raise hr_utility.hr_error;
151:
152: END get_payroll_action_info;
153:
154:

Line 184: hr_utility.trace('Entered range_cursor');

180: lv_prov_cd varchar2(5);
181: lv_report_type varchar2(50);
182:
183: BEGIN
184: hr_utility.trace('Entered range_cursor');
185: hr_utility.trace('p_payroll_action_id = ' ||
186: to_char(p_payroll_action_id));
187:
188: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id

Line 185: hr_utility.trace('p_payroll_action_id = ' ||

181: lv_report_type varchar2(50);
182:
183: BEGIN
184: hr_utility.trace('Entered range_cursor');
185: hr_utility.trace('p_payroll_action_id = ' ||
186: to_char(p_payroll_action_id));
187:
188: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
189: ,p_start_date => ld_start_date

Line 201: hr_utility.trace('Checking for Preprocess Agent GRE setup');

197: ,p_report_type => lv_report_type);
198:
199: ln_year := to_number(to_char(ld_end_date,'YYYY'));
200:
201: hr_utility.trace('Checking for Preprocess Agent GRE setup');
202:
203: if ln_person_id is not null then
204:
205: lv_sql_string :=

Line 211: hr_utility.trace('Range for person_id not null');

207: from per_assignments_f asg
208: where person_id = ' || ln_person_id ||
209: ' and :payroll_action_id > 0';
210:
211: hr_utility.trace('Range for person_id not null');
212:
213: elsif ln_asg_set is not null then
214:
215: lv_sql_string :=

Line 225: hr_utility.trace('Range for asg_set not null');

221: and asgset.include_or_exclude = ''I''
222: and :payroll_action_id > 0
223: order by paf.person_id';
224:
225: hr_utility.trace('Range for asg_set not null');
226:
227: elsif ln_tax_unit_id is not NULL then
228:
229: lv_sql_string :=

Line 265: hr_utility.trace('p_sqlstr = ' ||p_sqlstr);

261:
262: end if;
263:
264: p_sqlstr := lv_sql_string;
265: hr_utility.trace('p_sqlstr = ' ||p_sqlstr);
266:
267: hr_utility.trace('Leaving range_cursor');
268:
269: END range_cursor;

Line 267: hr_utility.trace('Leaving range_cursor');

263:
264: p_sqlstr := lv_sql_string;
265: hr_utility.trace('p_sqlstr = ' ||p_sqlstr);
266:
267: hr_utility.trace('Leaving range_cursor');
268:
269: END range_cursor;
270:
271:

Line 525: hr_utility.trace('get_latest_t4amend_dtls not found');

521: fetch get_warning_dtls_for_ee into lv_full_name
522: ,lv_employee_number;
523: close get_warning_dtls_for_ee;
524:
525: hr_utility.trace('get_latest_t4amend_dtls not found');
526: hr_utility.trace('p_person_id :'||to_char(p_person_id));
527:
528: if lv_ppr_report_type = 'PYT4PRAMEND' then
529: lv_record_name := 'T4 Amend Paper Report';

Line 526: hr_utility.trace('p_person_id :'||to_char(p_person_id));

522: ,lv_employee_number;
523: close get_warning_dtls_for_ee;
524:
525: hr_utility.trace('get_latest_t4amend_dtls not found');
526: hr_utility.trace('p_person_id :'||to_char(p_person_id));
527:
528: if lv_ppr_report_type = 'PYT4PRAMEND' then
529: lv_record_name := 'T4 Amend Paper Report';
530: else

Line 559: hr_utility.trace('lv_fed_amend_flag : '||lv_fed_amend_flag);

555:
556: lv_fed_amend_flag := 'N';
557: fetch c_get_fed_amend_flag into lv_fed_amend_flag,
558: lv_prov_of_emp;
559: hr_utility.trace('lv_fed_amend_flag : '||lv_fed_amend_flag);
560: hr_utility.trace('lv_prov_of_emp : '||lv_prov_of_emp);
561: exit when c_get_fed_amend_flag%NOTFOUND;
562:
563: if c_get_fed_amend_flag%FOUND then

Line 560: hr_utility.trace('lv_prov_of_emp : '||lv_prov_of_emp);

556: lv_fed_amend_flag := 'N';
557: fetch c_get_fed_amend_flag into lv_fed_amend_flag,
558: lv_prov_of_emp;
559: hr_utility.trace('lv_fed_amend_flag : '||lv_fed_amend_flag);
560: hr_utility.trace('lv_prov_of_emp : '||lv_prov_of_emp);
561: exit when c_get_fed_amend_flag%NOTFOUND;
562:
563: if c_get_fed_amend_flag%FOUND then
564:

Line 578: hr_utility.trace('get_latest_t4amend_dtls found ');

574: fetch get_yepp_pact_id into ln_yepp_pact_id;
575: close get_yepp_pact_id;
576:
577: /* Create an assignment action for this person */
578: hr_utility.trace('get_latest_t4amend_dtls found ');
579: hr_utility.trace('Report Type: '||lv_report_type);
580:
581: select pay_assignment_actions_s.nextval
582: into ln_t4amend_reg_asg_action

Line 579: hr_utility.trace('Report Type: '||lv_report_type);

575: close get_yepp_pact_id;
576:
577: /* Create an assignment action for this person */
578: hr_utility.trace('get_latest_t4amend_dtls found ');
579: hr_utility.trace('Report Type: '||lv_report_type);
580:
581: select pay_assignment_actions_s.nextval
582: into ln_t4amend_reg_asg_action
583: from dual;

Line 585: hr_utility.trace('New T4 Amend Action = ' ||

581: select pay_assignment_actions_s.nextval
582: into ln_t4amend_reg_asg_action
583: from dual;
584:
585: hr_utility.trace('New T4 Amend Action = ' ||
586: to_char(ln_t4amend_reg_asg_action));
587:
588: /* Insert into pay_assignment_actions. */
589: hr_nonrun_asact.insact(ln_t4amend_reg_asg_action

Line 613: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));

609:
610: update pay_assignment_actions aa
611: set aa.serial_number = ln_serial_number
612: where aa.assignment_action_id = ln_t4amend_reg_asg_action;
613: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));
614: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
615: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
616:
617: hr_utility.trace('Locking Action'||ln_t4amend_reg_asg_action);

Line 614: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));

610: update pay_assignment_actions aa
611: set aa.serial_number = ln_serial_number
612: where aa.assignment_action_id = ln_t4amend_reg_asg_action;
613: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));
614: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
615: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
616:
617: hr_utility.trace('Locking Action'||ln_t4amend_reg_asg_action);
618: hr_utility.trace('ln_serial_number :' || ln_serial_number);

Line 615: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));

611: set aa.serial_number = ln_serial_number
612: where aa.assignment_action_id = ln_t4amend_reg_asg_action;
613: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));
614: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
615: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
616:
617: hr_utility.trace('Locking Action'||ln_t4amend_reg_asg_action);
618: hr_utility.trace('ln_serial_number :' || ln_serial_number);
619:

Line 617: hr_utility.trace('Locking Action'||ln_t4amend_reg_asg_action);

613: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));
614: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
615: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
616:
617: hr_utility.trace('Locking Action'||ln_t4amend_reg_asg_action);
618: hr_utility.trace('ln_serial_number :' || ln_serial_number);
619:
620: end if; -- lv_fed_amend_flag = 'Y'
621:

Line 618: hr_utility.trace('ln_serial_number :' || ln_serial_number);

614: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
615: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
616:
617: hr_utility.trace('Locking Action'||ln_t4amend_reg_asg_action);
618: hr_utility.trace('ln_serial_number :' || ln_serial_number);
619:
620: end if; -- lv_fed_amend_flag = 'Y'
621:
622: end if; -- c_get_fed_amend_flag%FOUND

Line 645: hr_utility.trace('lv_print :'||lv_print);

641: ln_primary_assignment_id := 0;
642: ln_asg_act_to_lock := 0;
643: ln_gre_id_null := 0;
644:
645: hr_utility.trace('lv_print :'||lv_print);
646:
647: loop
648:
649: fetch get_all_t4amend_dtls into lv_report_type

Line 654: hr_utility.trace('get_all_t4amend_dtls not found ');

650: ,ln_primary_assignment_id
651: ,ln_asg_act_to_lock
652: ,ln_gre_id_null;
653: if get_all_t4amend_dtls%notfound then
654: hr_utility.trace('get_all_t4amend_dtls not found ');
655: exit;
656: end if;
657:
658: open c_get_fed_amend_flag(ln_asg_act_to_lock,

Line 666: hr_utility.trace('lv_fed_amend_flag : '||lv_fed_amend_flag);

662:
663: lv_fed_amend_flag := 'N';
664: fetch c_get_fed_amend_flag into lv_fed_amend_flag,
665: lv_prov_of_emp;
666: hr_utility.trace('lv_fed_amend_flag : '||lv_fed_amend_flag);
667: hr_utility.trace('lv_prov_of_emp : '||lv_prov_of_emp);
668: exit when c_get_fed_amend_flag%NOTFOUND;
669:
670: if c_get_fed_amend_flag%FOUND then

Line 667: hr_utility.trace('lv_prov_of_emp : '||lv_prov_of_emp);

663: lv_fed_amend_flag := 'N';
664: fetch c_get_fed_amend_flag into lv_fed_amend_flag,
665: lv_prov_of_emp;
666: hr_utility.trace('lv_fed_amend_flag : '||lv_fed_amend_flag);
667: hr_utility.trace('lv_prov_of_emp : '||lv_prov_of_emp);
668: exit when c_get_fed_amend_flag%NOTFOUND;
669:
670: if c_get_fed_amend_flag%FOUND then
671:

Line 685: hr_utility.trace('get_all_t4amend_dtls found ');

681: fetch get_yepp_pact_id into ln_yepp_pact_id;
682: close get_yepp_pact_id;
683:
684:
685: hr_utility.trace('get_all_t4amend_dtls found ');
686: hr_utility.trace('Report Type: '||lv_report_type);
687:
688: /* Create an assignment action for this person */
689:

Line 686: hr_utility.trace('Report Type: '||lv_report_type);

682: close get_yepp_pact_id;
683:
684:
685: hr_utility.trace('get_all_t4amend_dtls found ');
686: hr_utility.trace('Report Type: '||lv_report_type);
687:
688: /* Create an assignment action for this person */
689:
690: select pay_assignment_actions_s.nextval

Line 693: hr_utility.trace('New T4 Amend Action = ' || ln_t4amend_reg_asg_action);

689:
690: select pay_assignment_actions_s.nextval
691: into ln_t4amend_reg_asg_action
692: from dual;
693: hr_utility.trace('New T4 Amend Action = ' || ln_t4amend_reg_asg_action);
694:
695: /* Insert into pay_assignment_actions. */
696: hr_nonrun_asact.insact(ln_t4amend_reg_asg_action
697: ,ln_primary_assignment_id

Line 716: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));

712: ***********************************************************/
713: ln_serial_number := lv_prov_of_emp||
714: lpad(to_char(ln_asg_act_to_lock),14,0)||
715: lpad(to_char(ln_yepp_pact_id),14,0);
716: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));
717: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
718: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
719:
720: update pay_assignment_actions aa

Line 717: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));

713: ln_serial_number := lv_prov_of_emp||
714: lpad(to_char(ln_asg_act_to_lock),14,0)||
715: lpad(to_char(ln_yepp_pact_id),14,0);
716: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));
717: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
718: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
719:
720: update pay_assignment_actions aa
721: set aa.serial_number = ln_serial_number

Line 718: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));

714: lpad(to_char(ln_asg_act_to_lock),14,0)||
715: lpad(to_char(ln_yepp_pact_id),14,0);
716: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));
717: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
718: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
719:
720: update pay_assignment_actions aa
721: set aa.serial_number = ln_serial_number
722: where aa.assignment_action_id = ln_t4amend_reg_asg_action;

Line 738: hr_utility.trace('Entered action_creation ');

734:
735: END action_creation;
736:
737: BEGIN
738: hr_utility.trace('Entered action_creation ');
739: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
740: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
741: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
742: hr_utility.trace('p_chunk = ' || to_char(p_chunk));

Line 739: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));

735: END action_creation;
736:
737: BEGIN
738: hr_utility.trace('Entered action_creation ');
739: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
740: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
741: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
742: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
743:

Line 740: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));

736:
737: BEGIN
738: hr_utility.trace('Entered action_creation ');
739: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
740: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
741: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
742: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
743:
744: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id

Line 741: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));

737: BEGIN
738: hr_utility.trace('Entered action_creation ');
739: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
740: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
741: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
742: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
743:
744: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
745: ,p_start_date => ld_start_date

Line 742: hr_utility.trace('p_chunk = ' || to_char(p_chunk));

738: hr_utility.trace('Entered action_creation ');
739: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
740: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
741: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
742: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
743:
744: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
745: ,p_start_date => ld_start_date
746: ,p_end_date => ld_end_date

Line 755: hr_utility.trace('lv_ppr_report_type: '||lv_ppr_report_type);

751: ,p_print => lv_print
752: ,p_prov_cd => lv_prov_cd
753: ,p_report_type => lv_ppr_report_type);
754:
755: hr_utility.trace('lv_ppr_report_type: '||lv_ppr_report_type);
756:
757: ln_tax_unit_id := ln_gre_parameter;
758:
759: /* PERSON ID IS NOT NULL */

Line 765: hr_utility.trace('Entered Asg Set logic');

761: action_creation(p_start_person_id);
762:
763: elsif ln_asg_set is not null then
764:
765: hr_utility.trace('Entered Asg Set logic');
766: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
767: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
768: hr_utility.trace('End Person ='||to_char(p_end_person_id));
769:

Line 766: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));

762:
763: elsif ln_asg_set is not null then
764:
765: hr_utility.trace('Entered Asg Set logic');
766: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
767: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
768: hr_utility.trace('End Person ='||to_char(p_end_person_id));
769:
770: open c_selected_asg_set (p_start_person_id

Line 767: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));

763: elsif ln_asg_set is not null then
764:
765: hr_utility.trace('Entered Asg Set logic');
766: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
767: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
768: hr_utility.trace('End Person ='||to_char(p_end_person_id));
769:
770: open c_selected_asg_set (p_start_person_id
771: ,p_end_person_id

Line 768: hr_utility.trace('End Person ='||to_char(p_end_person_id));

764:
765: hr_utility.trace('Entered Asg Set logic');
766: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
767: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
768: hr_utility.trace('End Person ='||to_char(p_end_person_id));
769:
770: open c_selected_asg_set (p_start_person_id
771: ,p_end_person_id
772: ,ln_asg_set

Line 774: hr_utility.trace('Opened cusor c_selected_asg_set');

770: open c_selected_asg_set (p_start_person_id
771: ,p_end_person_id
772: ,ln_asg_set
773: ,ld_end_date);
774: hr_utility.trace('Opened cusor c_selected_asg_set');
775: loop
776: fetch c_selected_asg_set into ln_set_person_id;
777: if c_selected_asg_set%notfound then
778: hr_utility.trace('c_selected_asg_set not found ');

Line 778: hr_utility.trace('c_selected_asg_set not found ');

774: hr_utility.trace('Opened cusor c_selected_asg_set');
775: loop
776: fetch c_selected_asg_set into ln_set_person_id;
777: if c_selected_asg_set%notfound then
778: hr_utility.trace('c_selected_asg_set not found ');
779: hr_utility.trace('No Person found for reporting in this chunk');
780: exit;
781: end if;
782:

Line 779: hr_utility.trace('No Person found for reporting in this chunk');

775: loop
776: fetch c_selected_asg_set into ln_set_person_id;
777: if c_selected_asg_set%notfound then
778: hr_utility.trace('c_selected_asg_set not found ');
779: hr_utility.trace('No Person found for reporting in this chunk');
780: exit;
781: end if;
782:
783: action_creation(ln_set_person_id);

Line 790: hr_utility.trace('Entered GRE not null logic');

786: close c_selected_asg_set;
787:
788: elsif ln_tax_unit_id is not null then
789:
790: hr_utility.trace('Entered GRE not null logic');
791: hr_utility.trace('GRE ='||to_char(ln_tax_unit_id));
792: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
793: hr_utility.trace('End Person ='||to_char(p_end_person_id));
794:

Line 791: hr_utility.trace('GRE ='||to_char(ln_tax_unit_id));

787:
788: elsif ln_tax_unit_id is not null then
789:
790: hr_utility.trace('Entered GRE not null logic');
791: hr_utility.trace('GRE ='||to_char(ln_tax_unit_id));
792: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
793: hr_utility.trace('End Person ='||to_char(p_end_person_id));
794:
795: open c_all_asg (ln_business_group_id,

Line 792: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));

788: elsif ln_tax_unit_id is not null then
789:
790: hr_utility.trace('Entered GRE not null logic');
791: hr_utility.trace('GRE ='||to_char(ln_tax_unit_id));
792: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
793: hr_utility.trace('End Person ='||to_char(p_end_person_id));
794:
795: open c_all_asg (ln_business_group_id,
796: ln_tax_unit_id,

Line 793: hr_utility.trace('End Person ='||to_char(p_end_person_id));

789:
790: hr_utility.trace('Entered GRE not null logic');
791: hr_utility.trace('GRE ='||to_char(ln_tax_unit_id));
792: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
793: hr_utility.trace('End Person ='||to_char(p_end_person_id));
794:
795: open c_all_asg (ln_business_group_id,
796: ln_tax_unit_id,
797: ld_end_date,

Line 800: hr_utility.trace('Opened cusor c_all_asg');

796: ln_tax_unit_id,
797: ld_end_date,
798: p_start_person_id,
799: p_end_person_id);
800: hr_utility.trace('Opened cusor c_all_asg');
801:
802: loop
803: fetch c_all_asg into ln_set_person_id;
804: if c_all_asg%notfound then

Line 805: hr_utility.trace('c_all_asg not found ');

801:
802: loop
803: fetch c_all_asg into ln_set_person_id;
804: if c_all_asg%notfound then
805: hr_utility.trace('c_all_asg not found ');
806: hr_utility.trace('No Person found for reporting in this chunk');
807: exit;
808: end if;
809:

Line 806: hr_utility.trace('No Person found for reporting in this chunk');

802: loop
803: fetch c_all_asg into ln_set_person_id;
804: if c_all_asg%notfound then
805: hr_utility.trace('c_all_asg not found ');
806: hr_utility.trace('No Person found for reporting in this chunk');
807: exit;
808: end if;
809:
810: action_creation(ln_set_person_id);

Line 817: hr_utility.trace('Entered All GRE logic');

813: close c_all_asg;
814:
815: else
816:
817: hr_utility.trace('Entered All GRE logic');
818:
819: open c_all_gres(ln_business_group_id,
820: ld_end_date);
821:

Line 826: hr_utility.trace('c_all_gres NOT FOUND');

822: loop -- c_all_gres
823:
824: fetch c_all_gres into ln_gre_id;
825: if c_all_gres%NOTFOUND then
826: hr_utility.trace('c_all_gres NOT FOUND');
827: exit;
828: end if;
829:
830: hr_utility.trace('GRE ='||to_char(ln_gre_id));

Line 830: hr_utility.trace('GRE ='||to_char(ln_gre_id));

826: hr_utility.trace('c_all_gres NOT FOUND');
827: exit;
828: end if;
829:
830: hr_utility.trace('GRE ='||to_char(ln_gre_id));
831: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
832: hr_utility.trace('End Person ='||to_char(p_end_person_id));
833:
834: open c_all_asg (ln_business_group_id,

Line 831: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));

827: exit;
828: end if;
829:
830: hr_utility.trace('GRE ='||to_char(ln_gre_id));
831: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
832: hr_utility.trace('End Person ='||to_char(p_end_person_id));
833:
834: open c_all_asg (ln_business_group_id,
835: ln_gre_id,

Line 832: hr_utility.trace('End Person ='||to_char(p_end_person_id));

828: end if;
829:
830: hr_utility.trace('GRE ='||to_char(ln_gre_id));
831: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
832: hr_utility.trace('End Person ='||to_char(p_end_person_id));
833:
834: open c_all_asg (ln_business_group_id,
835: ln_gre_id,
836: ld_end_date,

Line 839: hr_utility.trace('Opened cusor c_all_asg');

835: ln_gre_id,
836: ld_end_date,
837: p_start_person_id,
838: p_end_person_id);
839: hr_utility.trace('Opened cusor c_all_asg');
840:
841: loop -- c_all_asg
842: fetch c_all_asg into ln_set_person_id;
843: if c_all_asg%notfound then

Line 844: hr_utility.trace('c_all_asg not found ');

840:
841: loop -- c_all_asg
842: fetch c_all_asg into ln_set_person_id;
843: if c_all_asg%notfound then
844: hr_utility.trace('c_all_asg not found ');
845: hr_utility.trace('No Person found for reporting in this chunk');
846: exit;
847: end if;
848:

Line 845: hr_utility.trace('No Person found for reporting in this chunk');

841: loop -- c_all_asg
842: fetch c_all_asg into ln_set_person_id;
843: if c_all_asg%notfound then
844: hr_utility.trace('c_all_asg not found ');
845: hr_utility.trace('No Person found for reporting in this chunk');
846: exit;
847: end if;
848:
849: ln_tax_unit_id := ln_gre_id;

Line 914: hr_utility.trace('Error in Sort Procedure - getting legislative param');

910: from pay_payroll_actions ppa
911: where ppa.payroll_action_id = payactid;
912:
913: exception when no_data_found then
914: hr_utility.trace('Error in Sort Procedure - getting legislative param');
915: raise;
916:
917: end;
918:

Line 923: hr_utility.trace('Beginning of the sort_action cursor');

919: if l_year_end > l_dt then
920: l_dt := l_year_end;
921: end if;
922:
923: hr_utility.trace('Beginning of the sort_action cursor');
924:
925: sqlstr := 'select paa1.rowid
926: from hr_all_organization_units hou,
927: hr_all_organization_units hou1,

Line 973: hr_utility.trace('End of the sort_Action cursor');

969: ppf.last_name,first_name';
970:
971:
972: len := length(sqlstr); -- return the length of the string.
973: hr_utility.trace('End of the sort_Action cursor');
974:
975: end sort_action;
976:
977:

Line 1010: /* hr_utility.trace_on(null,'T4AMEND_REG'); */

1006: return par_value;
1007:
1008: END get_parameter;
1009: Begin
1010: /* hr_utility.trace_on(null,'T4AMEND_REG'); */
1011: null;
1012:
1013:
1014: end pay_ca_eoy_t4_amend_reg;