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 88: hr_utility.trace('Entered get_eoy_action_info');

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

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

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

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

93: hr_utility.trace('Opened get_eoy_info');
94:
95: fetch get_eoy_info into ln_eoy_pactid;
96:
97: hr_utility.trace('Fetched get_eoy_info ');
98:
99: close get_eoy_info;
100:
101: hr_utility.trace('Closed get_eoy_info ');

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

97: hr_utility.trace('Fetched get_eoy_info ');
98:
99: close get_eoy_info;
100:
101: hr_utility.trace('Closed get_eoy_info ');
102:
103: p_eoy_pactid := ln_eoy_pactid;
104:
105: hr_utility.trace('ln_eoy_pactid = ' ||

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

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

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

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

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

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

Line 113: raise hr_utility.hr_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 194: raise hr_utility.hr_error;

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

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

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

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

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

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

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

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

254: and asgset.assignment_id = paf.assignment_id
255: and asgset.include_or_exclude = ''I''
256: and :payroll_action_id is not null ';
257:
258: hr_utility.trace('Range for asg_set not null');
259: end if;
260:
261: p_sqlstr := lv_sql_string;
262: hr_utility.trace('p_sqlstr = ' ||p_sqlstr);

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

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

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

262: hr_utility.trace('p_sqlstr = ' ||p_sqlstr);
263:
264:
265:
266: hr_utility.trace('Leaving w2c_range_cursor');
267: END w2c_range_cursor;
268:
269:
270: /************************************************************

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

625:
626: end get_parameter;
627:
628: --Begin
629: --hr_utility.trace_on(null,'W2C');
630:
631:
632: end pay_us_w2c_arch;