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

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

90: lv_print varchar2(10);
91: lv_report_type varchar2(50);
92:
93: BEGIN
94: hr_utility.trace('Entered get_payroll_action_info');
95: open c_payroll_action_info(p_payroll_action_id);
96: fetch c_payroll_action_info into ln_tax_unit_id,
97: ln_person_id,
98: ln_asg_set,

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

102: ln_business_group_id,
103: lv_report_type;
104: close c_payroll_action_info;
105:
106: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
107: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
108: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
109: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
110: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));

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

103: lv_report_type;
104: close c_payroll_action_info;
105:
106: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
107: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
108: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
109: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
110: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
111:

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

104: close c_payroll_action_info;
105:
106: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
107: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
108: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
109: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
110: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
111:
112: p_end_date := ld_end_date;

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

105:
106: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
107: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
108: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
109: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
110: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
111:
112: p_end_date := ld_end_date;
113: p_start_date := ld_start_date;

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

106: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
107: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
108: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
109: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
110: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
111:
112: p_end_date := ld_end_date;
113: p_start_date := ld_start_date;
114: p_business_group_id := ln_business_group_id;

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

117: p_asg_set := ln_asg_set;
118: p_print := lv_print;
119: p_report_type := lv_report_type;
120:
121: hr_utility.trace('Leaving get_payroll_action_info');
122:
123: EXCEPTION
124: when others then
125: hr_utility.trace('Error in ' || gv_procedure_name ||

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

121: hr_utility.trace('Leaving get_payroll_action_info');
122:
123: EXCEPTION
124: when others then
125: hr_utility.trace('Error in ' || gv_procedure_name ||
126: to_char(sqlcode) || '-' || sqlerrm);
127: raise hr_utility.hr_error;
128:
129: END get_payroll_action_info;

Line 127: raise hr_utility.hr_error;

123: EXCEPTION
124: when others then
125: hr_utility.trace('Error in ' || gv_procedure_name ||
126: to_char(sqlcode) || '-' || sqlerrm);
127: raise hr_utility.hr_error;
128:
129: END get_payroll_action_info;
130:
131:

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

154: ln_year number;
155: lv_report_type varchar2(50);
156:
157: BEGIN
158: hr_utility.trace('Entered range_cursor');
159: hr_utility.trace('p_payroll_action_id = ' ||
160: to_char(p_payroll_action_id));
161:
162: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id

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

155: lv_report_type varchar2(50);
156:
157: BEGIN
158: hr_utility.trace('Entered range_cursor');
159: hr_utility.trace('p_payroll_action_id = ' ||
160: to_char(p_payroll_action_id));
161:
162: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
163: ,p_start_date => ld_start_date

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

170: ,p_report_type => lv_report_type);
171:
172: ln_year := to_number(to_char(ld_end_date,'YYYY'));
173:
174: hr_utility.trace('Checking for Preprocess Agent GRE setup');
175:
176: if ln_person_id is not null then
177:
178: lv_sql_string :=

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

180: from per_assignments_f asg
181: where person_id = ' || ln_person_id ||
182: ' and :p_payroll_action_id > 0';
183:
184: hr_utility.trace('Range for person_id not null');
185:
186: elsif ln_asg_set is not null then
187:
188: lv_sql_string :=

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

194: and asgset.include_or_exclude = ''I''
195: and :p_payroll_action_id > 0
196: order by paf.person_id ';
197:
198: hr_utility.trace('Range for asg_set not null');
199:
200: elsif ln_tax_unit_id is not NULL then
201:
202: lv_sql_string :=

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

234:
235: end if;
236:
237: p_sqlstr := lv_sql_string;
238: hr_utility.trace('p_sqlstr = ' ||p_sqlstr);
239:
240: hr_utility.trace('Leaving range_cursor');
241:
242: END range_cursor;

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

236:
237: p_sqlstr := lv_sql_string;
238: hr_utility.trace('p_sqlstr = ' ||p_sqlstr);
239:
240: hr_utility.trace('Leaving range_cursor');
241:
242: END range_cursor;
243:
244:

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

457: open get_latest_t4a_amend_dtls(p_person_id
458: ,ln_tax_unit_id
459: ,ld_end_date);
460:
461: hr_utility.trace('ln_tax_unit_id :'||to_char(ln_tax_unit_id));
462: hr_utility.trace('ld_end_date :'||to_char(ld_end_date));
463: hr_utility.trace('ln_business_group_id :'||to_char(ln_business_group_id));
464:
465: loop

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

458: ,ln_tax_unit_id
459: ,ld_end_date);
460:
461: hr_utility.trace('ln_tax_unit_id :'||to_char(ln_tax_unit_id));
462: hr_utility.trace('ld_end_date :'||to_char(ld_end_date));
463: hr_utility.trace('ln_business_group_id :'||to_char(ln_business_group_id));
464:
465: loop
466:

Line 463: hr_utility.trace('ln_business_group_id :'||to_char(ln_business_group_id));

459: ,ld_end_date);
460:
461: hr_utility.trace('ln_tax_unit_id :'||to_char(ln_tax_unit_id));
462: hr_utility.trace('ld_end_date :'||to_char(ld_end_date));
463: hr_utility.trace('ln_business_group_id :'||to_char(ln_business_group_id));
464:
465: loop
466:
467: fetch get_latest_t4a_amend_dtls into lv_report_type

Line 480: hr_utility.trace('get_latest_t4a_amend_dtls not found');

476: fetch get_warning_dtls_for_ee into lv_full_name
477: ,lv_employee_number;
478: close get_warning_dtls_for_ee;
479:
480: hr_utility.trace('get_latest_t4a_amend_dtls not found');
481: hr_utility.trace('p_person_id :'||to_char(p_person_id));
482:
483: if lv_ppr_report_type = 'PYT4APRAMEND' then
484: lv_record_name := 'T4A Amend Paper Report';

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

477: ,lv_employee_number;
478: close get_warning_dtls_for_ee;
479:
480: hr_utility.trace('get_latest_t4a_amend_dtls not found');
481: hr_utility.trace('p_person_id :'||to_char(p_person_id));
482:
483: if lv_ppr_report_type = 'PYT4APRAMEND' then
484: lv_record_name := 'T4A Amend Paper Report';
485: else

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

511:
512: fetch c_get_fed_amend_flag into lv_fed_amend_flag;
513: exit when c_get_fed_amend_flag%NOTFOUND;
514:
515: hr_utility.trace('lv_fed_amend_flag : '||lv_fed_amend_flag);
516:
517: if c_get_fed_amend_flag%FOUND then
518:
519: if lv_fed_amend_flag = 'Y' then

Line 532: hr_utility.trace('get_latest_t4a_amend_dtls found ');

528: fetch get_yepp_pact_id into ln_yepp_pact_id;
529: close get_yepp_pact_id;
530:
531: /* Create an assignment action for this person */
532: hr_utility.trace('get_latest_t4a_amend_dtls found ');
533: hr_utility.trace('Report Type: '||lv_report_type);
534:
535: select pay_assignment_actions_s.nextval
536: into ln_t4a_amend_reg_asg_action

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

529: close get_yepp_pact_id;
530:
531: /* Create an assignment action for this person */
532: hr_utility.trace('get_latest_t4a_amend_dtls found ');
533: hr_utility.trace('Report Type: '||lv_report_type);
534:
535: select pay_assignment_actions_s.nextval
536: into ln_t4a_amend_reg_asg_action
537: from dual;

Line 539: hr_utility.trace('New T4A Amend Action = ' ||

535: select pay_assignment_actions_s.nextval
536: into ln_t4a_amend_reg_asg_action
537: from dual;
538:
539: hr_utility.trace('New T4A Amend Action = ' ||
540: to_char(ln_t4a_amend_reg_asg_action));
541:
542: /* Insert into pay_assignment_actions. */
543: hr_nonrun_asact.insact(ln_t4a_amend_reg_asg_action

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

563: update pay_assignment_actions aa
564: set aa.serial_number = ln_serial_number
565: where aa.assignment_action_id = ln_t4a_amend_reg_asg_action;
566:
567: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
568: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
569:
570: hr_utility.trace('Locking Action'||ln_t4a_amend_reg_asg_action);
571: hr_utility.trace('ln_serial_number :' || ln_serial_number);

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

564: set aa.serial_number = ln_serial_number
565: where aa.assignment_action_id = ln_t4a_amend_reg_asg_action;
566:
567: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
568: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
569:
570: hr_utility.trace('Locking Action'||ln_t4a_amend_reg_asg_action);
571: hr_utility.trace('ln_serial_number :' || ln_serial_number);
572:

Line 570: hr_utility.trace('Locking Action'||ln_t4a_amend_reg_asg_action);

566:
567: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
568: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
569:
570: hr_utility.trace('Locking Action'||ln_t4a_amend_reg_asg_action);
571: hr_utility.trace('ln_serial_number :' || ln_serial_number);
572:
573: end if; -- lv_fed_amend_flag = 'Y'
574:

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

567: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
568: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
569:
570: hr_utility.trace('Locking Action'||ln_t4a_amend_reg_asg_action);
571: hr_utility.trace('ln_serial_number :' || ln_serial_number);
572:
573: end if; -- lv_fed_amend_flag = 'Y'
574:
575: end if; -- c_get_fed_amend_flag%FOUND

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

593: ln_primary_assignment_id := 0;
594: ln_asg_act_to_lock := 0;
595: ln_gre_id_null := 0;
596:
597: hr_utility.trace('lv_print :'||lv_print);
598:
599: loop
600: fetch get_all_t4a_amend_dtls into lv_report_type
601: ,ln_primary_assignment_id

Line 606: hr_utility.trace('get_all_t4a_amend_dtls not found ');

602: ,ln_asg_act_to_lock
603: ,ln_gre_id_null;
604:
605: if get_all_t4a_amend_dtls%notfound then
606: hr_utility.trace('get_all_t4a_amend_dtls not found ');
607: exit;
608: end if;
609:
610: open c_get_fed_amend_flag(ln_asg_act_to_lock,

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

616:
617: fetch c_get_fed_amend_flag into lv_fed_amend_flag;
618: exit when c_get_fed_amend_flag%NOTFOUND;
619:
620: hr_utility.trace('lv_fed_amend_flag : '||lv_fed_amend_flag);
621:
622: if c_get_fed_amend_flag%FOUND then
623:
624: if lv_fed_amend_flag = 'Y' then

Line 637: hr_utility.trace('get_all_t4a_amend_dtls found ');

633: fetch get_yepp_pact_id into ln_yepp_pact_id;
634: close get_yepp_pact_id;
635:
636:
637: hr_utility.trace('get_all_t4a_amend_dtls found ');
638: hr_utility.trace('Report Type: '||lv_report_type);
639:
640: /* Create an assignment action for this person */
641:

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

634: close get_yepp_pact_id;
635:
636:
637: hr_utility.trace('get_all_t4a_amend_dtls found ');
638: hr_utility.trace('Report Type: '||lv_report_type);
639:
640: /* Create an assignment action for this person */
641:
642: select pay_assignment_actions_s.nextval

Line 646: hr_utility.trace('New T4A Amend Action = ' || ln_t4a_amend_reg_asg_action);

642: select pay_assignment_actions_s.nextval
643: into ln_t4a_amend_reg_asg_action
644: from dual;
645:
646: hr_utility.trace('New T4A Amend Action = ' || ln_t4a_amend_reg_asg_action);
647:
648: /* Insert into pay_assignment_actions. */
649: hr_nonrun_asact.insact(ln_t4a_amend_reg_asg_action
650: ,ln_primary_assignment_id

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

665: ***********************************************************/
666: ln_serial_number := lpad(to_char(ln_asg_act_to_lock),14,0)||
667: lpad(to_char(ln_yepp_pact_id),14,0);
668:
669: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
670: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
671:
672: update pay_assignment_actions aa
673: set aa.serial_number = ln_serial_number

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

666: ln_serial_number := lpad(to_char(ln_asg_act_to_lock),14,0)||
667: lpad(to_char(ln_yepp_pact_id),14,0);
668:
669: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
670: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
671:
672: update pay_assignment_actions aa
673: set aa.serial_number = ln_serial_number
674: where aa.assignment_action_id = ln_t4a_amend_reg_asg_action;

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

686:
687: END action_creation;
688:
689: BEGIN
690: hr_utility.trace('Entered action_creation ');
691: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
692: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
693: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
694: hr_utility.trace('p_chunk = ' || to_char(p_chunk));

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

687: END action_creation;
688:
689: BEGIN
690: hr_utility.trace('Entered action_creation ');
691: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
692: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
693: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
694: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
695:

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

688:
689: BEGIN
690: hr_utility.trace('Entered action_creation ');
691: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
692: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
693: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
694: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
695:
696: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id

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

689: BEGIN
690: hr_utility.trace('Entered action_creation ');
691: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
692: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
693: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
694: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
695:
696: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
697: ,p_start_date => ld_start_date

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

690: hr_utility.trace('Entered action_creation ');
691: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
692: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
693: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
694: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
695:
696: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
697: ,p_start_date => ld_start_date
698: ,p_end_date => ld_end_date

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

702: ,p_asg_set => ln_asg_set
703: ,p_print => lv_print
704: ,p_report_type => lv_ppr_report_type);
705:
706: hr_utility.trace('lv_ppr_report_type: '||lv_ppr_report_type);
707:
708: ln_tax_unit_id := ln_gre_parameter;
709:
710: /* PERSON ID IS NOT NULL */

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

712: action_creation(p_start_person_id);
713:
714: elsif ln_asg_set is not null then
715:
716: hr_utility.trace('Entered Asg Set logic');
717: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
718: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
719: hr_utility.trace('End Person ='||to_char(p_end_person_id));
720:

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

713:
714: elsif ln_asg_set is not null then
715:
716: hr_utility.trace('Entered Asg Set logic');
717: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
718: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
719: hr_utility.trace('End Person ='||to_char(p_end_person_id));
720:
721: open c_selected_asg_set (p_start_person_id

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

714: elsif ln_asg_set is not null then
715:
716: hr_utility.trace('Entered Asg Set logic');
717: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
718: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
719: hr_utility.trace('End Person ='||to_char(p_end_person_id));
720:
721: open c_selected_asg_set (p_start_person_id
722: ,p_end_person_id

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

715:
716: hr_utility.trace('Entered Asg Set logic');
717: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
718: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
719: hr_utility.trace('End Person ='||to_char(p_end_person_id));
720:
721: open c_selected_asg_set (p_start_person_id
722: ,p_end_person_id
723: ,ln_asg_set

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

721: open c_selected_asg_set (p_start_person_id
722: ,p_end_person_id
723: ,ln_asg_set
724: ,ld_end_date);
725: hr_utility.trace('Opened cusor c_selected_asg_set');
726: loop
727: fetch c_selected_asg_set into ln_set_person_id;
728: if c_selected_asg_set%notfound then
729: hr_utility.trace('c_selected_asg_set not found ');

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

725: hr_utility.trace('Opened cusor c_selected_asg_set');
726: loop
727: fetch c_selected_asg_set into ln_set_person_id;
728: if c_selected_asg_set%notfound then
729: hr_utility.trace('c_selected_asg_set not found ');
730: hr_utility.trace('No Person found for reporting in this chunk');
731: exit;
732: end if;
733:

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

726: loop
727: fetch c_selected_asg_set into ln_set_person_id;
728: if c_selected_asg_set%notfound then
729: hr_utility.trace('c_selected_asg_set not found ');
730: hr_utility.trace('No Person found for reporting in this chunk');
731: exit;
732: end if;
733:
734: hr_utility.trace('Assignment Set Person ='||to_char(ln_set_person_id));

Line 734: hr_utility.trace('Assignment Set Person ='||to_char(ln_set_person_id));

730: hr_utility.trace('No Person found for reporting in this chunk');
731: exit;
732: end if;
733:
734: hr_utility.trace('Assignment Set Person ='||to_char(ln_set_person_id));
735: action_creation(ln_set_person_id);
736:
737: end loop;
738: close c_selected_asg_set;

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

738: close c_selected_asg_set;
739:
740: elsif ln_tax_unit_id is not null then
741:
742: hr_utility.trace('Entered GRE not null logic');
743: hr_utility.trace('GRE ='||to_char(ln_tax_unit_id));
744: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
745: hr_utility.trace('End Person ='||to_char(p_end_person_id));
746:

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

739:
740: elsif ln_tax_unit_id is not null then
741:
742: hr_utility.trace('Entered GRE not null logic');
743: hr_utility.trace('GRE ='||to_char(ln_tax_unit_id));
744: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
745: hr_utility.trace('End Person ='||to_char(p_end_person_id));
746:
747: open c_all_asg (ln_business_group_id,

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

740: elsif ln_tax_unit_id is not null then
741:
742: hr_utility.trace('Entered GRE not null logic');
743: hr_utility.trace('GRE ='||to_char(ln_tax_unit_id));
744: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
745: hr_utility.trace('End Person ='||to_char(p_end_person_id));
746:
747: open c_all_asg (ln_business_group_id,
748: ln_tax_unit_id,

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

741:
742: hr_utility.trace('Entered GRE not null logic');
743: hr_utility.trace('GRE ='||to_char(ln_tax_unit_id));
744: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
745: hr_utility.trace('End Person ='||to_char(p_end_person_id));
746:
747: open c_all_asg (ln_business_group_id,
748: ln_tax_unit_id,
749: ld_end_date,

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

748: ln_tax_unit_id,
749: ld_end_date,
750: p_start_person_id,
751: p_end_person_id);
752: hr_utility.trace('Opened cusor c_all_asg');
753:
754: loop
755: fetch c_all_asg into ln_set_person_id;
756: if c_all_asg%notfound then

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

753:
754: loop
755: fetch c_all_asg into ln_set_person_id;
756: if c_all_asg%notfound then
757: hr_utility.trace('c_all_asg not found ');
758: hr_utility.trace('No Person found for reporting in this chunk');
759: exit;
760: end if;
761:

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

754: loop
755: fetch c_all_asg into ln_set_person_id;
756: if c_all_asg%notfound then
757: hr_utility.trace('c_all_asg not found ');
758: hr_utility.trace('No Person found for reporting in this chunk');
759: exit;
760: end if;
761:
762: action_creation(ln_set_person_id);

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

765: close c_all_asg;
766:
767: else
768:
769: hr_utility.trace('Entered All GRE logic');
770:
771: open c_all_gres(ln_business_group_id,
772: ld_end_date);
773:

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

775:
776: fetch c_all_gres into ln_gre_id;
777:
778: if c_all_gres%NOTFOUND then
779: hr_utility.trace('c_all_gres NOT FOUND');
780: exit;
781: end if;
782:
783: hr_utility.trace('GRE ='||to_char(ln_gre_id));

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

779: hr_utility.trace('c_all_gres NOT FOUND');
780: exit;
781: end if;
782:
783: hr_utility.trace('GRE ='||to_char(ln_gre_id));
784: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
785: hr_utility.trace('End Person ='||to_char(p_end_person_id));
786:
787: open c_all_asg (ln_business_group_id,

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

780: exit;
781: end if;
782:
783: hr_utility.trace('GRE ='||to_char(ln_gre_id));
784: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
785: hr_utility.trace('End Person ='||to_char(p_end_person_id));
786:
787: open c_all_asg (ln_business_group_id,
788: ln_gre_id,

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

781: end if;
782:
783: hr_utility.trace('GRE ='||to_char(ln_gre_id));
784: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
785: hr_utility.trace('End Person ='||to_char(p_end_person_id));
786:
787: open c_all_asg (ln_business_group_id,
788: ln_gre_id,
789: ld_end_date,

Line 793: hr_utility.trace('Opened cursor c_all_asg');

789: ld_end_date,
790: p_start_person_id,
791: p_end_person_id);
792:
793: hr_utility.trace('Opened cursor c_all_asg');
794:
795: loop -- c_all_asg
796: fetch c_all_asg into ln_set_person_id;
797: if c_all_asg%notfound then

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

794:
795: loop -- c_all_asg
796: fetch c_all_asg into ln_set_person_id;
797: if c_all_asg%notfound then
798: hr_utility.trace('c_all_asg not found ');
799: hr_utility.trace('No Person found for reporting in this chunk');
800: exit;
801: end if;
802:

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

795: loop -- c_all_asg
796: fetch c_all_asg into ln_set_person_id;
797: if c_all_asg%notfound then
798: hr_utility.trace('c_all_asg not found ');
799: hr_utility.trace('No Person found for reporting in this chunk');
800: exit;
801: end if;
802:
803: ln_tax_unit_id := ln_gre_id;

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

823: len out nocopy number
824: ) is
825:
826: begin
827: hr_utility.trace('Beginning of the sort_action cursor');
828:
829: sqlstr := 'select paa1.rowid
830: from hr_all_organization_units hou,
831: hr_all_organization_units hou1,

Line 913: /* hr_utility.trace_on(null,'T4AAMEND_REG'); */

909:
910: END get_parameter;
911:
912: Begin
913: /* hr_utility.trace_on(null,'T4AAMEND_REG'); */
914: null;
915:
916:
917: end pay_ca_eoy_t4a_amend_reg;