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

Line 91: hr_utility.trace('Entered get_eoy_action_info');

87: ln_eoy_pactid number :=0;
88:
89: BEGIN
90:
91: hr_utility.trace('Entered get_eoy_action_info');
92:
93: open get_eoy_info(p_w2c_eff_date
94: ,p_w2c_tax_unit_id);
95:

Line 96: hr_utility.trace('Opened get_eoy_info');

92:
93: open get_eoy_info(p_w2c_eff_date
94: ,p_w2c_tax_unit_id);
95:
96: hr_utility.trace('Opened get_eoy_info');
97:
98: fetch get_eoy_info into ln_eoy_pactid;
99:
100: hr_utility.trace('Fetched get_eoy_info ');

Line 100: hr_utility.trace('Fetched get_eoy_info ');

96: hr_utility.trace('Opened get_eoy_info');
97:
98: fetch get_eoy_info into ln_eoy_pactid;
99:
100: hr_utility.trace('Fetched get_eoy_info ');
101:
102: close get_eoy_info;
103:
104: hr_utility.trace('Closed get_eoy_info ');

Line 104: hr_utility.trace('Closed get_eoy_info ');

100: hr_utility.trace('Fetched get_eoy_info ');
101:
102: close get_eoy_info;
103:
104: hr_utility.trace('Closed get_eoy_info ');
105:
106: p_eoy_pactid := ln_eoy_pactid;
107:
108: hr_utility.trace('ln_eoy_pactid = ' ||

Line 108: hr_utility.trace('ln_eoy_pactid = ' ||

104: hr_utility.trace('Closed get_eoy_info ');
105:
106: p_eoy_pactid := ln_eoy_pactid;
107:
108: hr_utility.trace('ln_eoy_pactid = ' ||
109: to_char(ln_eoy_pactid));
110: hr_utility.trace('Leaving get_eoy_action_info');
111:
112: EXCEPTION

Line 110: hr_utility.trace('Leaving get_eoy_action_info');

106: p_eoy_pactid := ln_eoy_pactid;
107:
108: hr_utility.trace('ln_eoy_pactid = ' ||
109: to_char(ln_eoy_pactid));
110: hr_utility.trace('Leaving get_eoy_action_info');
111:
112: EXCEPTION
113: when others then
114: hr_utility.trace('Error in ' || gv_procedure_name ||

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

110: hr_utility.trace('Leaving get_eoy_action_info');
111:
112: EXCEPTION
113: when others then
114: hr_utility.trace('Error in ' || gv_procedure_name ||
115: to_char(sqlcode) || '-' || sqlerrm);
116: raise hr_utility.hr_error;
117:
118: END get_eoy_action_info;

Line 116: raise hr_utility.hr_error;

112: EXCEPTION
113: when others then
114: hr_utility.trace('Error in ' || gv_procedure_name ||
115: to_char(sqlcode) || '-' || sqlerrm);
116: raise hr_utility.hr_error;
117:
118: END get_eoy_action_info;
119:
120: /*****************************************************************************

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

160: lv_ssn per_people_f.national_identifier%TYPE;
161: lv_year VARCHAR2(4) := 0;
162:
163: BEGIN
164: hr_utility.trace('Entered get_payroll_action_info');
165: open c_payroll_action_info(p_payroll_action_id);
166: fetch c_payroll_action_info into ln_tax_unit_id,
167: ln_person_id,
168: lv_ssn,

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

172: ld_start_date,
173: ln_business_group_id;
174: close c_payroll_action_info;
175:
176: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
177: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
178: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
179: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
180: hr_utility.trace('lv_ssn = ' || lv_ssn);

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

173: ln_business_group_id;
174: close c_payroll_action_info;
175:
176: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
177: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
178: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
179: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
180: hr_utility.trace('lv_ssn = ' || lv_ssn);
181: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));

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

174: close c_payroll_action_info;
175:
176: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
177: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
178: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
179: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
180: hr_utility.trace('lv_ssn = ' || lv_ssn);
181: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
182: hr_utility.trace('lv_year = ' || lv_year);

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

175:
176: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
177: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
178: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
179: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
180: hr_utility.trace('lv_ssn = ' || lv_ssn);
181: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
182: hr_utility.trace('lv_year = ' || lv_year);
183:

Line 180: hr_utility.trace('lv_ssn = ' || lv_ssn);

176: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
177: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
178: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
179: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
180: hr_utility.trace('lv_ssn = ' || lv_ssn);
181: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
182: hr_utility.trace('lv_year = ' || lv_year);
183:
184: p_end_date := ld_end_date;

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

177: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
178: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
179: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
180: hr_utility.trace('lv_ssn = ' || lv_ssn);
181: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
182: hr_utility.trace('lv_year = ' || lv_year);
183:
184: p_end_date := ld_end_date;
185: p_start_date := ld_start_date;

Line 182: hr_utility.trace('lv_year = ' || lv_year);

178: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
179: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
180: hr_utility.trace('lv_ssn = ' || lv_ssn);
181: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
182: hr_utility.trace('lv_year = ' || lv_year);
183:
184: p_end_date := ld_end_date;
185: p_start_date := ld_start_date;
186: p_business_group_id := ln_business_group_id;

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

187: p_tax_unit_id := ln_tax_unit_id;
188: p_person_id := ln_person_id;
189: p_asg_set := ln_asg_set;
190:
191: hr_utility.trace('Leaving get_payroll_action_info');
192:
193: EXCEPTION
194: when others then
195: hr_utility.trace('Error in ' || gv_procedure_name ||

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

191: hr_utility.trace('Leaving get_payroll_action_info');
192:
193: EXCEPTION
194: when others then
195: hr_utility.trace('Error in ' || gv_procedure_name ||
196: to_char(sqlcode) || '-' || sqlerrm);
197: raise hr_utility.hr_error;
198:
199: END get_payroll_action_info;

Line 197: raise hr_utility.hr_error;

193: EXCEPTION
194: when others then
195: hr_utility.trace('Error in ' || gv_procedure_name ||
196: to_char(sqlcode) || '-' || sqlerrm);
197: raise hr_utility.hr_error;
198:
199: END get_payroll_action_info;
200:
201:

Line 228: hr_utility.trace('Entered w2c_range_cursor');

224: lv_sql_string VARCHAR2(32000);
225: ln_eoy_pactid number;
226:
227: BEGIN
228: hr_utility.trace('Entered w2c_range_cursor');
229: hr_utility.trace('p_payroll_action_id = ' ||
230: to_char(p_payroll_action_id));
231:
232: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id

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

225: ln_eoy_pactid number;
226:
227: BEGIN
228: hr_utility.trace('Entered w2c_range_cursor');
229: hr_utility.trace('p_payroll_action_id = ' ||
230: to_char(p_payroll_action_id));
231:
232: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
233: ,p_start_date => ld_start_date

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

244: from per_all_assignments_f asg
245: where person_id = ' || to_char(ln_person_id) ||
246: ' and :p_payroll_action_id is not null';
247:
248: hr_utility.trace('Range for person_id not null');
249:
250: elsif ln_asg_set is not null then
251:
252: lv_sql_string :=

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

257: and asgset.assignment_id = paf.assignment_id
258: and asgset.include_or_exclude = ''I''
259: and :payroll_action_id is not null order by paf.person_id';
260:
261: hr_utility.trace('Range for asg_set not null');
262: end if;
263:
264: p_sqlstr := lv_sql_string;
265: hr_utility.trace('p_sqlstr = ' ||p_sqlstr);

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

261: hr_utility.trace('Range for asg_set not null');
262: end if;
263:
264: p_sqlstr := lv_sql_string;
265: hr_utility.trace('p_sqlstr = ' ||p_sqlstr);
266:
267:
268:
269: hr_utility.trace('Leaving w2c_range_cursor');

Line 269: hr_utility.trace('Leaving w2c_range_cursor');

265: hr_utility.trace('p_sqlstr = ' ||p_sqlstr);
266:
267:
268:
269: hr_utility.trace('Leaving w2c_range_cursor');
270: END w2c_range_cursor;
271:
272:
273: /************************************************************

Line 436: hr_utility.trace('lv_full_name ='||lv_full_name);

432:
433: open get_warning_dtls_for_ee(p_person_id);
434: fetch get_warning_dtls_for_ee into lv_full_name
435: ,lv_national_identifier;
436: hr_utility.trace('lv_full_name ='||lv_full_name);
437: hr_utility.trace('lv_national_identifier ='||lv_national_identifier);
438: lv_name := lv_full_name || ', SSN '||lv_national_identifier;
439:
440:

Line 437: hr_utility.trace('lv_national_identifier ='||lv_national_identifier);

433: open get_warning_dtls_for_ee(p_person_id);
434: fetch get_warning_dtls_for_ee into lv_full_name
435: ,lv_national_identifier;
436: hr_utility.trace('lv_full_name ='||lv_full_name);
437: hr_utility.trace('lv_national_identifier ='||lv_national_identifier);
438: lv_name := lv_full_name || ', SSN '||lv_national_identifier;
439:
440:
441: close get_warning_dtls_for_ee;

Line 462: hr_utility.trace('New w2c Action = ' ||

458: /* Create an assignment action for this person */
459: select pay_assignment_actions_s.nextval
460: into ln_w2c_asg_action
461: from dual;
462: hr_utility.trace('New w2c Action = ' ||
463: to_char(ln_w2c_asg_action));
464:
465: /* Insert into pay_assignment_actions. */
466: hr_utility.trace('creating asg action');

Line 466: hr_utility.trace('creating asg action');

462: hr_utility.trace('New w2c Action = ' ||
463: to_char(ln_w2c_asg_action));
464:
465: /* Insert into pay_assignment_actions. */
466: hr_utility.trace('creating asg action');
467:
468: /*Bug No. 2819817- pick up latest processed primary assignment
469: In case a terminated employee is rehired and paid, the
470: latest processed assignment is picked. */

Line 496: hr_utility.trace('updating asg action');

492: so that the W2C report will not have
493: to do an additional checking against the assignment
494: table */
495:
496: hr_utility.trace('updating asg action');
497:
498: update pay_assignment_actions aa
499: set aa.serial_number = p_person_id
500: where aa.assignment_action_id = ln_w2c_asg_action;

Line 505: hr_utility.trace('Locking Action = ' || ln_w2c_asg_action);

501:
502: /* Interlock the yepp/last w2c report
503: action with current w2c action */
504:
505: hr_utility.trace('Locking Action = ' || ln_w2c_asg_action);
506: hr_utility.trace('Locked Action = ' || ln_asg_act_to_lock);
507: hr_nonrun_asact.insint(ln_w2c_asg_action
508: ,ln_asg_act_to_lock);
509:

Line 506: hr_utility.trace('Locked Action = ' || ln_asg_act_to_lock);

502: /* Interlock the yepp/last w2c report
503: action with current w2c action */
504:
505: hr_utility.trace('Locking Action = ' || ln_w2c_asg_action);
506: hr_utility.trace('Locked Action = ' || ln_asg_act_to_lock);
507: hr_nonrun_asact.insint(ln_w2c_asg_action
508: ,ln_asg_act_to_lock);
509:
510: elsif lv_report_type = 'W2C_PRE_PROCESS' then

Line 516: hr_utility.trace('lv_full_name ='||lv_full_name);

512:
513: open get_warning_dtls_for_ee(p_person_id);
514: fetch get_warning_dtls_for_ee into lv_full_name
515: ,lv_national_identifier;
516: hr_utility.trace('lv_full_name ='||lv_full_name);
517: hr_utility.trace('lv_national_identifier ='||lv_national_identifier);
518: lv_name := lv_full_name || ', SSN '||lv_national_identifier;
519:
520: close get_warning_dtls_for_ee;

Line 517: hr_utility.trace('lv_national_identifier ='||lv_national_identifier);

513: open get_warning_dtls_for_ee(p_person_id);
514: fetch get_warning_dtls_for_ee into lv_full_name
515: ,lv_national_identifier;
516: hr_utility.trace('lv_full_name ='||lv_full_name);
517: hr_utility.trace('lv_national_identifier ='||lv_national_identifier);
518: lv_name := lv_full_name || ', SSN '||lv_national_identifier;
519:
520: close get_warning_dtls_for_ee;
521:

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

535:
536: END action_creation;
537:
538: BEGIN
539: hr_utility.trace('Entered action_creation ');
540: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
541: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
542: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
543: hr_utility.trace('p_chunk = ' || to_char(p_chunk));

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

536: END action_creation;
537:
538: BEGIN
539: hr_utility.trace('Entered action_creation ');
540: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
541: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
542: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
543: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
544:

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

537:
538: BEGIN
539: hr_utility.trace('Entered action_creation ');
540: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
541: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
542: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
543: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
544:
545: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id

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

538: BEGIN
539: hr_utility.trace('Entered action_creation ');
540: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
541: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
542: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
543: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
544:
545: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
546: ,p_start_date => ld_start_date

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

539: hr_utility.trace('Entered action_creation ');
540: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
541: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
542: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
543: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
544:
545: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
546: ,p_start_date => ld_start_date
547: ,p_end_date => ld_end_date

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

561: action_creation(p_start_person_id);
562:
563: elsif ln_asg_set is not null then
564:
565: hr_utility.trace('Entered Asg Set logic');
566: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
567:
568: ln_person_id_sel := 0;
569:

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

562:
563: elsif ln_asg_set is not null then
564:
565: hr_utility.trace('Entered Asg Set logic');
566: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
567:
568: ln_person_id_sel := 0;
569:
570: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));

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

566: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
567:
568: ln_person_id_sel := 0;
569:
570: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
571: hr_utility.trace('End Person ='||to_char(p_end_person_id));
572: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
573: hr_utility.trace('EOY Pactid ='||to_char(ln_eoy_pactid));
574:

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

567:
568: ln_person_id_sel := 0;
569:
570: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
571: hr_utility.trace('End Person ='||to_char(p_end_person_id));
572: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
573: hr_utility.trace('EOY Pactid ='||to_char(ln_eoy_pactid));
574:
575: open c_selected_asg_set (p_start_person_id

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

568: ln_person_id_sel := 0;
569:
570: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
571: hr_utility.trace('End Person ='||to_char(p_end_person_id));
572: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
573: hr_utility.trace('EOY Pactid ='||to_char(ln_eoy_pactid));
574:
575: open c_selected_asg_set (p_start_person_id
576: ,p_end_person_id

Line 573: hr_utility.trace('EOY Pactid ='||to_char(ln_eoy_pactid));

569:
570: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
571: hr_utility.trace('End Person ='||to_char(p_end_person_id));
572: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
573: hr_utility.trace('EOY Pactid ='||to_char(ln_eoy_pactid));
574:
575: open c_selected_asg_set (p_start_person_id
576: ,p_end_person_id
577: ,ln_asg_set

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

576: ,p_end_person_id
577: ,ln_asg_set
578: ,ln_eoy_pactid
579: ,ld_start_date) ;
580: hr_utility.trace('Opened cusor c_selected_asg_set');
581: loop
582: fetch c_selected_asg_set into ln_person_id_sel ;
583: if c_selected_asg_set%notfound then
584: hr_utility.trace('No Person found for reporting in this chunk');

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

580: hr_utility.trace('Opened cusor c_selected_asg_set');
581: loop
582: fetch c_selected_asg_set into ln_person_id_sel ;
583: if c_selected_asg_set%notfound then
584: hr_utility.trace('No Person found for reporting in this chunk');
585: exit;
586: end if;
587:
588: hr_utility.trace('ln_person_id after c_selected_asg_set = '||to_char(ln_person_id));

Line 588: hr_utility.trace('ln_person_id after c_selected_asg_set = '||to_char(ln_person_id));

584: hr_utility.trace('No Person found for reporting in this chunk');
585: exit;
586: end if;
587:
588: hr_utility.trace('ln_person_id after c_selected_asg_set = '||to_char(ln_person_id));
589:
590: action_creation(ln_person_id_sel);
591:
592: end loop;

Line 632: --hr_utility.trace_on(null,'W2C');

628:
629: end get_parameter;
630:
631: --Begin
632: --hr_utility.trace_on(null,'W2C');
633:
634:
635: end pay_us_w2c_arch;