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

Line 35: hr_utility messages.

31: to avoid numeric or value error,
32: corrected the range_cursor sql
33: string for Asg_set and small
34: local variable conversions for
35: hr_utility messages.
36: 17-SEP-2003 SSattini 115.2 3144801 Corrected variables used
37: to substitute tokens for messages.
38: This was causing the numeric/value
39: error.

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

99: lv_sin per_all_people_f.national_identifier%TYPE;
100: lv_year VARCHAR2(4);
101:
102: BEGIN
103: hr_utility.trace('Entered get_payroll_action_info');
104: open c_payroll_action_info(p_payroll_action_id);
105: fetch c_payroll_action_info into ln_tax_unit_id,
106: ln_person_id,
107: lv_sin,

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

111: ld_start_date,
112: ln_business_group_id;
113: close c_payroll_action_info;
114:
115: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
116: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
117: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
118: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
119: hr_utility.trace('lv_sin = ' || lv_sin);

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

112: ln_business_group_id;
113: close c_payroll_action_info;
114:
115: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
116: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
117: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
118: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
119: hr_utility.trace('lv_sin = ' || lv_sin);
120: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));

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

113: close c_payroll_action_info;
114:
115: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
116: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
117: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
118: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
119: hr_utility.trace('lv_sin = ' || lv_sin);
120: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
121: hr_utility.trace('lv_year = ' || lv_year);

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

114:
115: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
116: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
117: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
118: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
119: hr_utility.trace('lv_sin = ' || lv_sin);
120: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
121: hr_utility.trace('lv_year = ' || lv_year);
122:

Line 119: hr_utility.trace('lv_sin = ' || lv_sin);

115: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
116: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
117: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
118: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
119: hr_utility.trace('lv_sin = ' || lv_sin);
120: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
121: hr_utility.trace('lv_year = ' || lv_year);
122:
123: p_end_date := ld_end_date;

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

116: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
117: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
118: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
119: hr_utility.trace('lv_sin = ' || lv_sin);
120: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
121: hr_utility.trace('lv_year = ' || lv_year);
122:
123: p_end_date := ld_end_date;
124: p_start_date := ld_start_date;

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

117: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
118: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
119: hr_utility.trace('lv_sin = ' || lv_sin);
120: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
121: hr_utility.trace('lv_year = ' || lv_year);
122:
123: p_end_date := ld_end_date;
124: p_start_date := ld_start_date;
125: p_business_group_id := ln_business_group_id;

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

127: p_person_id := ln_person_id;
128: p_asg_set := ln_asg_set;
129: p_year := lv_year;
130:
131: hr_utility.trace('Leaving get_payroll_action_info');
132:
133: EXCEPTION
134: when others then
135: hr_utility.trace('Error in ' || gv_procedure_name ||

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

131: hr_utility.trace('Leaving get_payroll_action_info');
132:
133: EXCEPTION
134: when others then
135: hr_utility.trace('Error in ' || gv_procedure_name ||
136: to_char(sqlcode) || '-' || sqlerrm);
137: raise hr_utility.hr_error;
138:
139: END get_payroll_action_info;

Line 137: raise hr_utility.hr_error;

133: EXCEPTION
134: when others then
135: hr_utility.trace('Error in ' || gv_procedure_name ||
136: to_char(sqlcode) || '-' || sqlerrm);
137: raise hr_utility.hr_error;
138:
139: END get_payroll_action_info;
140:
141:

Line 169: hr_utility.trace('Entered eoy_range_cursor');

165: lv_record_name varchar2(80);
166: lv_message varchar2(100) := null;
167:
168: BEGIN
169: hr_utility.trace('Entered eoy_range_cursor');
170: hr_utility.trace('p_payroll_action_id = ' ||
171: to_char(p_payroll_action_id));
172:
173: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id

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

166: lv_message varchar2(100) := null;
167:
168: BEGIN
169: hr_utility.trace('Entered eoy_range_cursor');
170: hr_utility.trace('p_payroll_action_id = ' ||
171: to_char(p_payroll_action_id));
172:
173: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
174: ,p_start_date => ld_start_date

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

186: from per_all_assignments_f asg
187: where person_id = ' || to_char(ln_person_id) ||
188: ' and :p_payroll_action_id > 0';
189:
190: hr_utility.trace('Range for person_id not null');
191:
192: elsif ln_asg_set is not null then
193:
194: lv_sql_string :=

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

200: and asgset.include_or_exclude = ''I''
201: and :payroll_action_id > 0
202: order by paf.person_id ';
203:
204: hr_utility.trace('Range for asg_set not null');
205:
206: else
207:
208: lv_record_name := 'Federal Amendment Pre-Process';

Line 224: hr_utility.trace('No person selected as ln_person_id and ln_asg_set are null');

220: where person_id = 0
221: and :p_payroll_action_id > 0
222: order by asg.person_id';
223:
224: hr_utility.trace('No person selected as ln_person_id and ln_asg_set are null');
225:
226: end if;
227:
228: p_sqlstr := lv_sql_string;

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

225:
226: end if;
227:
228: p_sqlstr := lv_sql_string;
229: hr_utility.trace('p_sqlstr = ' ||p_sqlstr);
230:
231: hr_utility.trace('Leaving eoy_range_cursor');
232: END eoy_range_cursor;
233:

Line 231: hr_utility.trace('Leaving eoy_range_cursor');

227:
228: p_sqlstr := lv_sql_string;
229: hr_utility.trace('p_sqlstr = ' ||p_sqlstr);
230:
231: hr_utility.trace('Leaving eoy_range_cursor');
232: END eoy_range_cursor;
233:
234:
235: /************************************************************

Line 354: hr_utility.trace('lv_report_type ='||lv_report_type);

350: ,ld_end_date);
351: fetch get_prev_t4_amend_dtls into lv_report_type
352: ,ln_primary_assignment_id
353: ,ln_asg_act_to_lock;
354: hr_utility.trace('lv_report_type ='||lv_report_type);
355: hr_utility.trace('ln_primary_assignment_id ='||
356: to_char(ln_primary_assignment_id));
357: hr_utility.trace('ln_asg_act_to_lock ='||
358: to_char(ln_asg_act_to_lock));

Line 355: hr_utility.trace('ln_primary_assignment_id ='||

351: fetch get_prev_t4_amend_dtls into lv_report_type
352: ,ln_primary_assignment_id
353: ,ln_asg_act_to_lock;
354: hr_utility.trace('lv_report_type ='||lv_report_type);
355: hr_utility.trace('ln_primary_assignment_id ='||
356: to_char(ln_primary_assignment_id));
357: hr_utility.trace('ln_asg_act_to_lock ='||
358: to_char(ln_asg_act_to_lock));
359:

Line 357: hr_utility.trace('ln_asg_act_to_lock ='||

353: ,ln_asg_act_to_lock;
354: hr_utility.trace('lv_report_type ='||lv_report_type);
355: hr_utility.trace('ln_primary_assignment_id ='||
356: to_char(ln_primary_assignment_id));
357: hr_utility.trace('ln_asg_act_to_lock ='||
358: to_char(ln_asg_act_to_lock));
359:
360: if get_prev_t4_amend_dtls%notfound then
361:

Line 362: hr_utility.trace('get_prev_t4_amend_dtls Not Found');

358: to_char(ln_asg_act_to_lock));
359:
360: if get_prev_t4_amend_dtls%notfound then
361:
362: hr_utility.trace('get_prev_t4_amend_dtls Not Found');
363: hr_utility.trace('Warning Message Generated');
364: hr_utility.trace('p_person_id ='||to_char(p_person_id));
365:
366: open get_warning_dtls_for_ee(p_person_id);

Line 363: hr_utility.trace('Warning Message Generated');

359:
360: if get_prev_t4_amend_dtls%notfound then
361:
362: hr_utility.trace('get_prev_t4_amend_dtls Not Found');
363: hr_utility.trace('Warning Message Generated');
364: hr_utility.trace('p_person_id ='||to_char(p_person_id));
365:
366: open get_warning_dtls_for_ee(p_person_id);
367: fetch get_warning_dtls_for_ee into lv_full_name

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

360: if get_prev_t4_amend_dtls%notfound then
361:
362: hr_utility.trace('get_prev_t4_amend_dtls Not Found');
363: hr_utility.trace('Warning Message Generated');
364: hr_utility.trace('p_person_id ='||to_char(p_person_id));
365:
366: open get_warning_dtls_for_ee(p_person_id);
367: fetch get_warning_dtls_for_ee into lv_full_name
368: ,lv_national_identifier;

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

366: open get_warning_dtls_for_ee(p_person_id);
367: fetch get_warning_dtls_for_ee into lv_full_name
368: ,lv_national_identifier;
369:
370: hr_utility.trace('lv_full_name ='||lv_full_name);
371: hr_utility.trace('lv_national_identifier ='||lv_national_identifier);
372:
373: lv_name := lv_full_name || ', SIN '||lv_national_identifier;
374:

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

367: fetch get_warning_dtls_for_ee into lv_full_name
368: ,lv_national_identifier;
369:
370: hr_utility.trace('lv_full_name ='||lv_full_name);
371: hr_utility.trace('lv_national_identifier ='||lv_national_identifier);
372:
373: lv_name := lv_full_name || ', SIN '||lv_national_identifier;
374:
375: close get_warning_dtls_for_ee;

Line 390: hr_utility.trace('get_prev_t4_amend_dtls Found');

386: end if;
387:
388:
389: if get_prev_t4_amend_dtls%found then
390: hr_utility.trace('get_prev_t4_amend_dtls Found');
391:
392: if lv_report_type in ('T4', 'CAEOY_T4_AMEND_PP') then
393:
394: /* Create an assignment action for this person */

Line 398: hr_utility.trace('New T4 Amendment Action = ' ||

394: /* Create an assignment action for this person */
395: select pay_assignment_actions_s.nextval
396: into ln_t4amend_asg_action
397: from dual;
398: hr_utility.trace('New T4 Amendment Action = ' ||
399: to_char(ln_t4amend_asg_action));
400:
401: /* Insert into pay_assignment_actions. */
402: hr_utility.trace('creating asg_action');

Line 402: hr_utility.trace('creating asg_action');

398: hr_utility.trace('New T4 Amendment Action = ' ||
399: to_char(ln_t4amend_asg_action));
400:
401: /* Insert into pay_assignment_actions. */
402: hr_utility.trace('creating asg_action');
403: hr_nonrun_asact.insact(ln_t4amend_asg_action
404: ,ln_primary_assignment_id
405: ,p_payroll_action_id
406: ,p_chunk

Line 414: hr_utility.trace('updating asg_action');

410: so that the T4 Amendment report will not have
411: to do an additional checking against the assignment
412: table */
413:
414: hr_utility.trace('updating asg_action');
415:
416: update pay_assignment_actions aa
417: set aa.serial_number = to_char(p_person_id)
418: where aa.assignment_action_id = ln_t4amend_asg_action;

Line 423: hr_utility.trace('Locking Action = ' || to_char(ln_t4amend_asg_action));

419:
420: /* Interlock the YEPP or Previous T4 Amendment Archiver
421: action for current T4 Amendment Pre-process action */
422:
423: hr_utility.trace('Locking Action = ' || to_char(ln_t4amend_asg_action));
424: hr_utility.trace('Locked Action = ' || to_char(ln_asg_act_to_lock));
425: hr_nonrun_asact.insint(ln_t4amend_asg_action
426: ,ln_asg_act_to_lock);
427:

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

420: /* Interlock the YEPP or Previous T4 Amendment Archiver
421: action for current T4 Amendment Pre-process action */
422:
423: hr_utility.trace('Locking Action = ' || to_char(ln_t4amend_asg_action));
424: hr_utility.trace('Locked Action = ' || to_char(ln_asg_act_to_lock));
425: hr_nonrun_asact.insint(ln_t4amend_asg_action
426: ,ln_asg_act_to_lock);
427:
428: end if; /* report type */

Line 433: hr_utility.trace('closed get_prev_t4_amend_dtls');

429:
430: end if; /* employee found*/
431:
432: close get_prev_t4_amend_dtls;
433: hr_utility.trace('closed get_prev_t4_amend_dtls');
434: END action_creation;
435:
436: BEGIN
437: hr_utility.trace('Entered eoy_action_creation ');

Line 437: hr_utility.trace('Entered eoy_action_creation ');

433: hr_utility.trace('closed get_prev_t4_amend_dtls');
434: END action_creation;
435:
436: BEGIN
437: hr_utility.trace('Entered eoy_action_creation ');
438: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
439: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
440: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
441: hr_utility.trace('p_chunk = ' || to_char(p_chunk));

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

434: END action_creation;
435:
436: BEGIN
437: hr_utility.trace('Entered eoy_action_creation ');
438: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
439: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
440: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
441: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
442:

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

435:
436: BEGIN
437: hr_utility.trace('Entered eoy_action_creation ');
438: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
439: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
440: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
441: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
442:
443: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id

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

436: BEGIN
437: hr_utility.trace('Entered eoy_action_creation ');
438: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
439: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
440: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
441: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
442:
443: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
444: ,p_start_date => ld_start_date

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

437: hr_utility.trace('Entered eoy_action_creation ');
438: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
439: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
440: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
441: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
442:
443: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
444: ,p_start_date => ld_start_date
445: ,p_end_date => ld_end_date

Line 456: hr_utility.trace('Entered PersonId logic');

452: /* PERSON ID IS NOT NULL */
453:
454: if ln_person_id is not null then
455:
456: hr_utility.trace('Entered PersonId logic');
457: action_creation(p_start_person_id);
458:
459: elsif ln_asg_set is not null then
460:

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

457: action_creation(p_start_person_id);
458:
459: elsif ln_asg_set is not null then
460:
461: hr_utility.trace('Entered Asg Set logic');
462: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
463:
464: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
465: hr_utility.trace('End Person ='||to_char(p_end_person_id));

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

458:
459: elsif ln_asg_set is not null then
460:
461: hr_utility.trace('Entered Asg Set logic');
462: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
463:
464: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
465: hr_utility.trace('End Person ='||to_char(p_end_person_id));
466: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));

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

460:
461: hr_utility.trace('Entered Asg Set logic');
462: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
463:
464: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
465: hr_utility.trace('End Person ='||to_char(p_end_person_id));
466: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
467:
468: open c_selected_asg_set (p_start_person_id

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

461: hr_utility.trace('Entered Asg Set logic');
462: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
463:
464: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
465: hr_utility.trace('End Person ='||to_char(p_end_person_id));
466: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
467:
468: open c_selected_asg_set (p_start_person_id
469: ,p_end_person_id

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

462: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
463:
464: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
465: hr_utility.trace('End Person ='||to_char(p_end_person_id));
466: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
467:
468: open c_selected_asg_set (p_start_person_id
469: ,p_end_person_id
470: ,ln_asg_set);

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

467:
468: open c_selected_asg_set (p_start_person_id
469: ,p_end_person_id
470: ,ln_asg_set);
471: hr_utility.trace('Opened cusor c_selected_asg_set');
472: loop
473: fetch c_selected_asg_set into ln_person_id_sel ;
474: if c_selected_asg_set%notfound then
475: hr_utility.trace('No Person found for reporting in this chunk');

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

471: hr_utility.trace('Opened cusor c_selected_asg_set');
472: loop
473: fetch c_selected_asg_set into ln_person_id_sel ;
474: if c_selected_asg_set%notfound then
475: hr_utility.trace('No Person found for reporting in this chunk');
476: exit;
477: end if;
478:
479: hr_utility.trace('ln_person_id after c_selected_asg_set = '||to_char(ln_person_id_sel));

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

475: hr_utility.trace('No Person found for reporting in this chunk');
476: exit;
477: end if;
478:
479: hr_utility.trace('ln_person_id after c_selected_asg_set = '||to_char(ln_person_id_sel));
480:
481: action_creation(ln_person_id_sel);
482:
483: end loop;

Line 523: --hr_utility.trace_on(null,'T4AMENDPP');

519:
520: end get_parameter;
521:
522: Begin
523: --hr_utility.trace_on(null,'T4AMENDPP');
524: null;
525:
526:
527: