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

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

93: lv_print varchar2(10);
94: lv_report_type varchar2(50);
95:
96: BEGIN
97: hr_utility.trace('Entered get_payroll_action_info');
98: open c_payroll_action_info(p_payroll_action_id);
99: fetch c_payroll_action_info into ln_pre_org_id,
100: ln_person_id,
101: ln_asg_set,

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

105: ln_business_group_id,
106: lv_report_type;
107: close c_payroll_action_info;
108:
109: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
110: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
111: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
112: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
113: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));

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

106: lv_report_type;
107: close c_payroll_action_info;
108:
109: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
110: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
111: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
112: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
113: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
114:

Line 111: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));

107: close c_payroll_action_info;
108:
109: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
110: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
111: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
112: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
113: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
114:
115: p_end_date := ld_end_date;

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

108:
109: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
110: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
111: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
112: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
113: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
114:
115: p_end_date := ld_end_date;
116: p_start_date := ld_start_date;

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

109: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
110: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
111: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
112: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
113: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
114:
115: p_end_date := ld_end_date;
116: p_start_date := ld_start_date;
117: p_business_group_id := ln_business_group_id;

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

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

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

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

Line 130: raise hr_utility.hr_error;

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

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

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

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

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

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 :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 :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_pre_org_id is not NULL then
201:
202: lv_sql_string :=

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

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

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

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

Line 506: hr_utility.trace('get_latest_rl1_amend_dtls not found');

502: fetch get_warning_dtls_for_ee into lv_full_name
503: ,lv_employee_number;
504: close get_warning_dtls_for_ee;
505:
506: hr_utility.trace('get_latest_rl1_amend_dtls not found');
507: hr_utility.trace('p_person_id :'||to_char(p_person_id));
508:
509: if lv_ppr_report_type = 'PYRL1PRAMEND' then
510: lv_record_name := 'RL1 Amend Paper Report';

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

503: ,lv_employee_number;
504: close get_warning_dtls_for_ee;
505:
506: hr_utility.trace('get_latest_rl1_amend_dtls not found');
507: hr_utility.trace('p_person_id :'||to_char(p_person_id));
508:
509: if lv_ppr_report_type = 'PYRL1PRAMEND' then
510: lv_record_name := 'RL1 Amend Paper Report';
511: else

Line 540: hr_utility.trace('lv_prov_amend_flag : '||lv_prov_amend_flag);

536:
537: lv_prov_amend_flag := 'N';
538: fetch c_get_prov_amend_flag into lv_prov_amend_flag,
539: lv_prov_of_emp;
540: hr_utility.trace('lv_prov_amend_flag : '||lv_prov_amend_flag);
541: hr_utility.trace('lv_prov_of_emp : '||lv_prov_of_emp);
542: exit when c_get_prov_amend_flag%NOTFOUND;
543:
544: if c_get_prov_amend_flag%FOUND then

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

537: lv_prov_amend_flag := 'N';
538: fetch c_get_prov_amend_flag into lv_prov_amend_flag,
539: lv_prov_of_emp;
540: hr_utility.trace('lv_prov_amend_flag : '||lv_prov_amend_flag);
541: hr_utility.trace('lv_prov_of_emp : '||lv_prov_of_emp);
542: exit when c_get_prov_amend_flag%NOTFOUND;
543:
544: if c_get_prov_amend_flag%FOUND then
545:

Line 559: hr_utility.trace('get_latest_rl1_amend_dtls found ');

555: fetch get_yepp_pact_id into ln_yepp_pact_id;
556: close get_yepp_pact_id;
557:
558: /* Create an assignment action for this person */
559: hr_utility.trace('get_latest_rl1_amend_dtls found ');
560: hr_utility.trace('Report Type: '||lv_report_type);
561:
562: select pay_assignment_actions_s.nextval
563: into ln_rl1_amend_reg_asg_action

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

556: close get_yepp_pact_id;
557:
558: /* Create an assignment action for this person */
559: hr_utility.trace('get_latest_rl1_amend_dtls found ');
560: hr_utility.trace('Report Type: '||lv_report_type);
561:
562: select pay_assignment_actions_s.nextval
563: into ln_rl1_amend_reg_asg_action
564: from dual;

Line 566: hr_utility.trace('New RL1 Amend Action = ' ||

562: select pay_assignment_actions_s.nextval
563: into ln_rl1_amend_reg_asg_action
564: from dual;
565:
566: hr_utility.trace('New RL1 Amend Action = ' ||
567: to_char(ln_rl1_amend_reg_asg_action));
568:
569: /* Insert into pay_assignment_actions. */
570: hr_nonrun_asact.insact(ln_rl1_amend_reg_asg_action

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

590:
591: update pay_assignment_actions aa
592: set aa.serial_number = ln_serial_number
593: where aa.assignment_action_id = ln_rl1_amend_reg_asg_action;
594: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));
595: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
596: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
597:
598: hr_utility.trace('Locking Action'||ln_rl1_amend_reg_asg_action);

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

591: update pay_assignment_actions aa
592: set aa.serial_number = ln_serial_number
593: where aa.assignment_action_id = ln_rl1_amend_reg_asg_action;
594: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));
595: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
596: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
597:
598: hr_utility.trace('Locking Action'||ln_rl1_amend_reg_asg_action);
599: hr_utility.trace('ln_serial_number :' || ln_serial_number);

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

592: set aa.serial_number = ln_serial_number
593: where aa.assignment_action_id = ln_rl1_amend_reg_asg_action;
594: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));
595: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
596: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
597:
598: hr_utility.trace('Locking Action'||ln_rl1_amend_reg_asg_action);
599: hr_utility.trace('ln_serial_number :' || ln_serial_number);
600:

Line 598: hr_utility.trace('Locking Action'||ln_rl1_amend_reg_asg_action);

594: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));
595: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
596: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
597:
598: hr_utility.trace('Locking Action'||ln_rl1_amend_reg_asg_action);
599: hr_utility.trace('ln_serial_number :' || ln_serial_number);
600:
601: end if; -- lv_prov_amend_flag = 'Y'
602:

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

595: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
596: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
597:
598: hr_utility.trace('Locking Action'||ln_rl1_amend_reg_asg_action);
599: hr_utility.trace('ln_serial_number :' || ln_serial_number);
600:
601: end if; -- lv_prov_amend_flag = 'Y'
602:
603: end if; -- c_get_prov_amend_flag%FOUND

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

623: ln_primary_assignment_id := 0;
624: ln_asg_act_to_lock := 0;
625: ln_pre_id_null := 0;
626:
627: hr_utility.trace('lv_print :'||lv_print);
628:
629: loop
630:
631: fetch get_all_rl1_amend_dtls into lv_report_type

Line 637: hr_utility.trace('get_all_rl1_amend_dtls not found ');

633: ,ln_asg_act_to_lock
634: ,ln_pre_id_null;
635:
636: if get_all_rl1_amend_dtls%notfound then
637: hr_utility.trace('get_all_rl1_amend_dtls not found ');
638: exit;
639: end if;
640:
641: open c_get_prov_amend_flag(ln_asg_act_to_lock,

Line 649: hr_utility.trace('lv_prov_amend_flag : '||lv_prov_amend_flag);

645:
646: lv_prov_amend_flag := 'N';
647: fetch c_get_prov_amend_flag into lv_prov_amend_flag,
648: lv_prov_of_emp;
649: hr_utility.trace('lv_prov_amend_flag : '||lv_prov_amend_flag);
650: hr_utility.trace('lv_prov_of_emp : '||lv_prov_of_emp);
651: exit when c_get_prov_amend_flag%NOTFOUND;
652:
653: if c_get_prov_amend_flag%FOUND then

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

646: lv_prov_amend_flag := 'N';
647: fetch c_get_prov_amend_flag into lv_prov_amend_flag,
648: lv_prov_of_emp;
649: hr_utility.trace('lv_prov_amend_flag : '||lv_prov_amend_flag);
650: hr_utility.trace('lv_prov_of_emp : '||lv_prov_of_emp);
651: exit when c_get_prov_amend_flag%NOTFOUND;
652:
653: if c_get_prov_amend_flag%FOUND then
654:

Line 667: hr_utility.trace('get_all_rl1_amend_dtls found ');

663: ld_end_date);
664: fetch get_yepp_pact_id into ln_yepp_pact_id;
665: close get_yepp_pact_id;
666:
667: hr_utility.trace('get_all_rl1_amend_dtls found ');
668: hr_utility.trace('Report Type: '||lv_report_type);
669:
670: /* Create an assignment action for this person */
671:

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

664: fetch get_yepp_pact_id into ln_yepp_pact_id;
665: close get_yepp_pact_id;
666:
667: hr_utility.trace('get_all_rl1_amend_dtls found ');
668: hr_utility.trace('Report Type: '||lv_report_type);
669:
670: /* Create an assignment action for this person */
671:
672: select pay_assignment_actions_s.nextval

Line 675: hr_utility.trace('New RL1 Amend Action = ' || ln_rl1_amend_reg_asg_action);

671:
672: select pay_assignment_actions_s.nextval
673: into ln_rl1_amend_reg_asg_action
674: from dual;
675: hr_utility.trace('New RL1 Amend Action = ' || ln_rl1_amend_reg_asg_action);
676:
677: /* Insert into pay_assignment_actions. */
678: hr_nonrun_asact.insact(ln_rl1_amend_reg_asg_action
679: ,ln_primary_assignment_id

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

694: ***********************************************************/
695: ln_serial_number := lv_prov_of_emp||
696: lpad(to_char(ln_asg_act_to_lock),14,0)||
697: lpad(to_char(ln_yepp_pact_id),14,0);
698: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));
699: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
700: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
701:
702: update pay_assignment_actions aa

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

695: ln_serial_number := lv_prov_of_emp||
696: lpad(to_char(ln_asg_act_to_lock),14,0)||
697: lpad(to_char(ln_yepp_pact_id),14,0);
698: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));
699: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
700: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
701:
702: update pay_assignment_actions aa
703: set aa.serial_number = ln_serial_number

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

696: lpad(to_char(ln_asg_act_to_lock),14,0)||
697: lpad(to_char(ln_yepp_pact_id),14,0);
698: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));
699: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
700: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
701:
702: update pay_assignment_actions aa
703: set aa.serial_number = ln_serial_number
704: where aa.assignment_action_id = ln_rl1_amend_reg_asg_action;

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

716:
717: END action_creation;
718:
719: BEGIN
720: hr_utility.trace('Entered action_creation ');
721: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
722: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
723: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
724: hr_utility.trace('p_chunk = ' || to_char(p_chunk));

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

717: END action_creation;
718:
719: BEGIN
720: hr_utility.trace('Entered action_creation ');
721: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
722: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
723: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
724: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
725:

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

718:
719: BEGIN
720: hr_utility.trace('Entered action_creation ');
721: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
722: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
723: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
724: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
725:
726: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id

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

719: BEGIN
720: hr_utility.trace('Entered action_creation ');
721: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
722: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
723: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
724: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
725:
726: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
727: ,p_start_date => ld_start_date

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

720: hr_utility.trace('Entered action_creation ');
721: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
722: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
723: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
724: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
725:
726: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
727: ,p_start_date => ld_start_date
728: ,p_end_date => ld_end_date

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

732: ,p_asg_set => ln_asg_set
733: ,p_print => lv_print
734: ,p_report_type => lv_ppr_report_type);
735:
736: hr_utility.trace('lv_ppr_report_type: '||lv_ppr_report_type);
737:
738: ln_pre_org_id := ln_pre_parameter;
739:
740: /* PERSON ID IS NOT NULL */

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

742: action_creation(p_start_person_id);
743:
744: elsif ln_asg_set is not null then
745:
746: hr_utility.trace('Entered Asg Set logic');
747: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
748: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
749: hr_utility.trace('End Person ='||to_char(p_end_person_id));
750:

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

743:
744: elsif ln_asg_set is not null then
745:
746: hr_utility.trace('Entered Asg Set logic');
747: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
748: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
749: hr_utility.trace('End Person ='||to_char(p_end_person_id));
750:
751: open c_selected_asg_set (p_start_person_id

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

744: elsif ln_asg_set is not null then
745:
746: hr_utility.trace('Entered Asg Set logic');
747: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
748: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
749: hr_utility.trace('End Person ='||to_char(p_end_person_id));
750:
751: open c_selected_asg_set (p_start_person_id
752: ,p_end_person_id

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

745:
746: hr_utility.trace('Entered Asg Set logic');
747: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
748: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
749: hr_utility.trace('End Person ='||to_char(p_end_person_id));
750:
751: open c_selected_asg_set (p_start_person_id
752: ,p_end_person_id
753: ,ln_asg_set

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

751: open c_selected_asg_set (p_start_person_id
752: ,p_end_person_id
753: ,ln_asg_set
754: ,ld_end_date);
755: hr_utility.trace('Opened cusor c_selected_asg_set');
756: loop
757: fetch c_selected_asg_set into ln_set_person_id;
758: if c_selected_asg_set%notfound then
759: hr_utility.trace('c_selected_asg_set not found ');

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

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

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

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

Line 771: hr_utility.trace('Entered PRE not null logic');

767: close c_selected_asg_set;
768:
769: elsif ln_pre_org_id is not null then
770:
771: hr_utility.trace('Entered PRE not null logic');
772: hr_utility.trace('PRE Organization Id ='||to_char(ln_pre_org_id));
773: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
774: hr_utility.trace('End Person ='||to_char(p_end_person_id));
775:

Line 772: hr_utility.trace('PRE Organization Id ='||to_char(ln_pre_org_id));

768:
769: elsif ln_pre_org_id is not null then
770:
771: hr_utility.trace('Entered PRE not null logic');
772: hr_utility.trace('PRE Organization Id ='||to_char(ln_pre_org_id));
773: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
774: hr_utility.trace('End Person ='||to_char(p_end_person_id));
775:
776: open c_all_asg (ln_business_group_id,

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

769: elsif ln_pre_org_id is not null then
770:
771: hr_utility.trace('Entered PRE not null logic');
772: hr_utility.trace('PRE Organization Id ='||to_char(ln_pre_org_id));
773: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
774: hr_utility.trace('End Person ='||to_char(p_end_person_id));
775:
776: open c_all_asg (ln_business_group_id,
777: ln_pre_org_id,

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

770:
771: hr_utility.trace('Entered PRE not null logic');
772: hr_utility.trace('PRE Organization Id ='||to_char(ln_pre_org_id));
773: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
774: hr_utility.trace('End Person ='||to_char(p_end_person_id));
775:
776: open c_all_asg (ln_business_group_id,
777: ln_pre_org_id,
778: ld_end_date,

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

777: ln_pre_org_id,
778: ld_end_date,
779: p_start_person_id,
780: p_end_person_id);
781: hr_utility.trace('Opened cusor c_all_asg');
782:
783: loop
784: fetch c_all_asg into ln_set_person_id;
785: if c_all_asg%notfound then

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

782:
783: loop
784: fetch c_all_asg into ln_set_person_id;
785: if c_all_asg%notfound then
786: hr_utility.trace('c_all_asg not found ');
787: hr_utility.trace('No Person found for reporting in this chunk');
788: exit;
789: end if;
790:

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

783: loop
784: fetch c_all_asg into ln_set_person_id;
785: if c_all_asg%notfound then
786: hr_utility.trace('c_all_asg not found ');
787: hr_utility.trace('No Person found for reporting in this chunk');
788: exit;
789: end if;
790:
791: action_creation(ln_set_person_id);

Line 798: hr_utility.trace('Entered All PRE logic');

794: close c_all_asg;
795:
796: else
797:
798: hr_utility.trace('Entered All PRE logic');
799:
800: open c_all_pres(ln_business_group_id,
801: ld_end_date);
802:

Line 808: hr_utility.trace('c_all_pres NOT FOUND');

804:
805: fetch c_all_pres into ln_pre_id;
806:
807: if c_all_pres%NOTFOUND then
808: hr_utility.trace('c_all_pres NOT FOUND');
809: exit;
810: end if;
811:
812: hr_utility.trace('PRE ='||to_char(ln_pre_id));

Line 812: hr_utility.trace('PRE ='||to_char(ln_pre_id));

808: hr_utility.trace('c_all_pres NOT FOUND');
809: exit;
810: end if;
811:
812: hr_utility.trace('PRE ='||to_char(ln_pre_id));
813: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
814: hr_utility.trace('End Person ='||to_char(p_end_person_id));
815:
816: open c_all_asg (ln_business_group_id,

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

809: exit;
810: end if;
811:
812: hr_utility.trace('PRE ='||to_char(ln_pre_id));
813: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
814: hr_utility.trace('End Person ='||to_char(p_end_person_id));
815:
816: open c_all_asg (ln_business_group_id,
817: ln_pre_id,

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

810: end if;
811:
812: hr_utility.trace('PRE ='||to_char(ln_pre_id));
813: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
814: hr_utility.trace('End Person ='||to_char(p_end_person_id));
815:
816: open c_all_asg (ln_business_group_id,
817: ln_pre_id,
818: ld_end_date,

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

817: ln_pre_id,
818: ld_end_date,
819: p_start_person_id,
820: p_end_person_id);
821: hr_utility.trace('Opened cursor c_all_asg');
822:
823: loop -- c_all_asg
824: fetch c_all_asg into ln_set_person_id;
825: if c_all_asg%notfound then

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

822:
823: loop -- c_all_asg
824: fetch c_all_asg into ln_set_person_id;
825: if c_all_asg%notfound then
826: hr_utility.trace('c_all_asg not found ');
827: hr_utility.trace('No Person found for reporting in this chunk');
828: exit;
829: end if;
830:

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

823: loop -- c_all_asg
824: fetch c_all_asg into ln_set_person_id;
825: if c_all_asg%notfound then
826: hr_utility.trace('c_all_asg not found ');
827: hr_utility.trace('No Person found for reporting in this chunk');
828: exit;
829: end if;
830:
831: ln_pre_org_id := ln_pre_id;

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

852: ) is
853:
854: begin
855:
856: hr_utility.trace('Beginning of the sort_action cursor');
857:
858: sqlstr := 'select paa1.rowid /* we need the row id of the assignment actions that are created by PYUGEN */
859: from hr_all_organization_units hou1,
860: hr_all_organization_units hou,

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

895: ,ppf.last_name,ppf.first_name';
896:
897:
898: len := length(sqlstr); -- return the length of the string.
899: hr_utility.trace('End of the sort_Action cursor');
900:
901: end sort_action;
902:
903:

Line 936: /* hr_utility.trace_on(null,'RL1AMEND_REG'); */

932: return par_value;
933:
934: END get_parameter;
935: Begin
936: /* hr_utility.trace_on(null,'RL1AMEND_REG'); */
937: null;
938:
939:
940: end pay_ca_eoy_rl1_amend_reg;