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

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

77: ln_asg_set NUMBER := 0;
78: lv_year VARCHAR2(4);
79:
80: BEGIN
81: hr_utility.trace('Entered get_payroll_action_info');
82:
83: open c_payroll_action_info(p_payroll_action_id);
84: fetch c_payroll_action_info into ln_tax_unit_id,
85: ln_person_id,

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

89: ld_start_date,
90: ln_business_group_id;
91: close c_payroll_action_info;
92:
93: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
94: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
95: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
96: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
97: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));

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

90: ln_business_group_id;
91: close c_payroll_action_info;
92:
93: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
94: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
95: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
96: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
97: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
98: hr_utility.trace('lv_year = ' || lv_year);

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

91: close c_payroll_action_info;
92:
93: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
94: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
95: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
96: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
97: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
98: hr_utility.trace('lv_year = ' || lv_year);
99:

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

92:
93: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
94: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
95: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
96: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
97: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
98: hr_utility.trace('lv_year = ' || lv_year);
99:
100: p_end_date := ld_end_date;

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

93: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
94: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
95: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
96: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
97: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
98: hr_utility.trace('lv_year = ' || lv_year);
99:
100: p_end_date := ld_end_date;
101: p_start_date := ld_start_date;

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

94: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
95: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
96: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
97: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
98: hr_utility.trace('lv_year = ' || lv_year);
99:
100: p_end_date := ld_end_date;
101: p_start_date := ld_start_date;
102: p_business_group_id := ln_business_group_id;

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

104: p_person_id := ln_person_id;
105: p_asg_set := ln_asg_set;
106: p_year := lv_year;
107:
108: hr_utility.trace('Leaving get_payroll_action_info');
109:
110: EXCEPTION
111: when others then
112: hr_utility.trace('Error in ' || gv_procedure_name ||

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

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

Line 114: raise hr_utility.hr_error;

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

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

141: lv_record_name varchar2(80);
142: lv_message varchar2(100) := null;
143:
144: BEGIN
145: hr_utility.trace('Entered eoy_range_cursor');
146: hr_utility.trace('p_payroll_action_id = ' ||
147: to_char(p_payroll_action_id));
148:
149: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id

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

142: lv_message varchar2(100) := null;
143:
144: BEGIN
145: hr_utility.trace('Entered eoy_range_cursor');
146: hr_utility.trace('p_payroll_action_id = ' ||
147: to_char(p_payroll_action_id));
148:
149: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
150: ,p_start_date => ld_start_date

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

162: from per_all_assignments_f asg
163: where person_id = ' || to_char(ln_person_id) ||
164: ' and :p_payroll_action_id > 0';
165:
166: hr_utility.trace('Range for person_id not null');
167:
168: elsif ln_asg_set is not null then
169:
170: lv_sql_string :=

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

176: and asgset.include_or_exclude = ''I''
177: and :payroll_action_id > 0
178: order by paf.person_id ';
179:
180: hr_utility.trace('Range for asg_set not null');
181:
182: else
183:
184: lv_record_name := 'Federal Amendment Pre-Process';

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

196: where person_id = 0
197: and :p_payroll_action_id > 0
198: order by asg.person_id ';
199:
200: hr_utility.trace('No person selected as ln_person_id and ln_asg_set are null');
201:
202: end if;
203:
204: p_sqlstr := lv_sql_string;

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

201:
202: end if;
203:
204: p_sqlstr := lv_sql_string;
205: hr_utility.trace('p_sqlstr = ' ||p_sqlstr);
206:
207: hr_utility.trace('Leaving eoy_range_cursor');
208:
209: END eoy_range_cursor;

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

203:
204: p_sqlstr := lv_sql_string;
205: hr_utility.trace('p_sqlstr = ' ||p_sqlstr);
206:
207: hr_utility.trace('Leaving eoy_range_cursor');
208:
209: END eoy_range_cursor;
210:
211:

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

327: fetch get_prev_t4a_amend_dtls into lv_report_type
328: ,ln_primary_assignment_id
329: ,ln_asg_act_to_lock;
330:
331: hr_utility.trace('lv_report_type ='||lv_report_type);
332: hr_utility.trace('ln_primary_assignment_id ='||
333: to_char(ln_primary_assignment_id));
334: hr_utility.trace('ln_asg_act_to_lock ='||
335: to_char(ln_asg_act_to_lock));

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

328: ,ln_primary_assignment_id
329: ,ln_asg_act_to_lock;
330:
331: hr_utility.trace('lv_report_type ='||lv_report_type);
332: hr_utility.trace('ln_primary_assignment_id ='||
333: to_char(ln_primary_assignment_id));
334: hr_utility.trace('ln_asg_act_to_lock ='||
335: to_char(ln_asg_act_to_lock));
336:

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

330:
331: hr_utility.trace('lv_report_type ='||lv_report_type);
332: hr_utility.trace('ln_primary_assignment_id ='||
333: to_char(ln_primary_assignment_id));
334: hr_utility.trace('ln_asg_act_to_lock ='||
335: to_char(ln_asg_act_to_lock));
336:
337: if get_prev_t4a_amend_dtls%notfound then
338:

Line 339: hr_utility.trace('get_prev_t4a_amend_dtls Not Found');

335: to_char(ln_asg_act_to_lock));
336:
337: if get_prev_t4a_amend_dtls%notfound then
338:
339: hr_utility.trace('get_prev_t4a_amend_dtls Not Found');
340: hr_utility.trace('Warning Message Generated');
341: hr_utility.trace('p_person_id ='||to_char(p_person_id));
342:
343: open get_warning_dtls_for_ee(p_person_id);

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

336:
337: if get_prev_t4a_amend_dtls%notfound then
338:
339: hr_utility.trace('get_prev_t4a_amend_dtls Not Found');
340: hr_utility.trace('Warning Message Generated');
341: hr_utility.trace('p_person_id ='||to_char(p_person_id));
342:
343: open get_warning_dtls_for_ee(p_person_id);
344: fetch get_warning_dtls_for_ee into lv_full_name

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

337: if get_prev_t4a_amend_dtls%notfound then
338:
339: hr_utility.trace('get_prev_t4a_amend_dtls Not Found');
340: hr_utility.trace('Warning Message Generated');
341: hr_utility.trace('p_person_id ='||to_char(p_person_id));
342:
343: open get_warning_dtls_for_ee(p_person_id);
344: fetch get_warning_dtls_for_ee into lv_full_name
345: ,lv_national_identifier;

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

343: open get_warning_dtls_for_ee(p_person_id);
344: fetch get_warning_dtls_for_ee into lv_full_name
345: ,lv_national_identifier;
346:
347: hr_utility.trace('lv_full_name ='||lv_full_name);
348: hr_utility.trace('lv_national_identifier ='||lv_national_identifier);
349:
350: lv_name := lv_full_name || ', SIN '||lv_national_identifier;
351:

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

344: fetch get_warning_dtls_for_ee into lv_full_name
345: ,lv_national_identifier;
346:
347: hr_utility.trace('lv_full_name ='||lv_full_name);
348: hr_utility.trace('lv_national_identifier ='||lv_national_identifier);
349:
350: lv_name := lv_full_name || ', SIN '||lv_national_identifier;
351:
352: close get_warning_dtls_for_ee;

Line 367: hr_utility.trace('get_prev_t4a_amend_dtls Found');

363: end if;
364:
365:
366: if get_prev_t4a_amend_dtls%found then
367: hr_utility.trace('get_prev_t4a_amend_dtls Found');
368:
369: if lv_report_type in ('T4A', 'CAEOY_T4A_AMEND_PP') then
370:
371: /* Create an assignment action for this person */

Line 376: hr_utility.trace('New T4A Amendment Action = ' ||

372: select pay_assignment_actions_s.nextval
373: into ln_t4a_amend_asg_action
374: from dual;
375:
376: hr_utility.trace('New T4A Amendment Action = ' ||
377: to_char(ln_t4a_amend_asg_action));
378:
379: /* Insert into pay_assignment_actions. */
380: hr_utility.trace('creating assignment action');

Line 380: hr_utility.trace('creating assignment action');

376: hr_utility.trace('New T4A Amendment Action = ' ||
377: to_char(ln_t4a_amend_asg_action));
378:
379: /* Insert into pay_assignment_actions. */
380: hr_utility.trace('creating assignment action');
381: hr_nonrun_asact.insact(ln_t4a_amend_asg_action
382: ,ln_primary_assignment_id
383: ,p_payroll_action_id
384: ,p_chunk

Line 392: hr_utility.trace('updating assignment action');

388: so that the T4A Amendment report will not have
389: to do an additional checking against the assignment
390: table */
391:
392: hr_utility.trace('updating assignment action');
393:
394: update pay_assignment_actions aa
395: set aa.serial_number = to_char(p_person_id)
396: where aa.assignment_action_id = ln_t4a_amend_asg_action;

Line 401: hr_utility.trace('Locking Action = ' || to_char(ln_t4a_amend_asg_action));

397:
398: /* Interlock the YEPP or Previous T4A Amendment Archiver
399: action for current T4A Amendment Pre-process action */
400:
401: hr_utility.trace('Locking Action = ' || to_char(ln_t4a_amend_asg_action));
402: hr_utility.trace('Locked Action = ' || to_char(ln_asg_act_to_lock));
403: hr_nonrun_asact.insint(ln_t4a_amend_asg_action
404: ,ln_asg_act_to_lock);
405:

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

398: /* Interlock the YEPP or Previous T4A Amendment Archiver
399: action for current T4A Amendment Pre-process action */
400:
401: hr_utility.trace('Locking Action = ' || to_char(ln_t4a_amend_asg_action));
402: hr_utility.trace('Locked Action = ' || to_char(ln_asg_act_to_lock));
403: hr_nonrun_asact.insint(ln_t4a_amend_asg_action
404: ,ln_asg_act_to_lock);
405:
406: end if; /* report type */

Line 411: hr_utility.trace('closed get_prev_t4a_amend_dtls');

407:
408: end if; /* employee found*/
409:
410: close get_prev_t4a_amend_dtls;
411: hr_utility.trace('closed get_prev_t4a_amend_dtls');
412: END action_creation;
413:
414: BEGIN
415: hr_utility.trace('Entered eoy_action_creation ');

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

411: hr_utility.trace('closed get_prev_t4a_amend_dtls');
412: END action_creation;
413:
414: BEGIN
415: hr_utility.trace('Entered eoy_action_creation ');
416: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
417: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
418: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
419: hr_utility.trace('p_chunk = ' || to_char(p_chunk));

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

412: END action_creation;
413:
414: BEGIN
415: hr_utility.trace('Entered eoy_action_creation ');
416: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
417: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
418: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
419: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
420:

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

413:
414: BEGIN
415: hr_utility.trace('Entered eoy_action_creation ');
416: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
417: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
418: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
419: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
420:
421: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id

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

414: BEGIN
415: hr_utility.trace('Entered eoy_action_creation ');
416: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
417: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
418: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
419: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
420:
421: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
422: ,p_start_date => ld_start_date

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

415: hr_utility.trace('Entered eoy_action_creation ');
416: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
417: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
418: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
419: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
420:
421: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
422: ,p_start_date => ld_start_date
423: ,p_end_date => ld_end_date

Line 434: hr_utility.trace('Entered Person Id logic');

430: /* PERSON ID IS NOT NULL */
431:
432: if ln_person_id is not null then
433:
434: hr_utility.trace('Entered Person Id logic');
435: action_creation(p_start_person_id);
436:
437: elsif ln_asg_set is not null then
438:

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

435: action_creation(p_start_person_id);
436:
437: elsif ln_asg_set is not null then
438:
439: hr_utility.trace('Entered Asg Set logic');
440: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
441:
442: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
443: hr_utility.trace('End Person ='||to_char(p_end_person_id));

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

436:
437: elsif ln_asg_set is not null then
438:
439: hr_utility.trace('Entered Asg Set logic');
440: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
441:
442: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
443: hr_utility.trace('End Person ='||to_char(p_end_person_id));
444: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));

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

438:
439: hr_utility.trace('Entered Asg Set logic');
440: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
441:
442: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
443: hr_utility.trace('End Person ='||to_char(p_end_person_id));
444: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
445:
446: open c_selected_asg_set(p_start_person_id

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

439: hr_utility.trace('Entered Asg Set logic');
440: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
441:
442: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
443: hr_utility.trace('End Person ='||to_char(p_end_person_id));
444: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
445:
446: open c_selected_asg_set(p_start_person_id
447: ,p_end_person_id

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

440: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
441:
442: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
443: hr_utility.trace('End Person ='||to_char(p_end_person_id));
444: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
445:
446: open c_selected_asg_set(p_start_person_id
447: ,p_end_person_id
448: ,ln_asg_set);

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

446: open c_selected_asg_set(p_start_person_id
447: ,p_end_person_id
448: ,ln_asg_set);
449:
450: hr_utility.trace('Opened cusor c_selected_asg_set');
451:
452: loop
453:
454: fetch c_selected_asg_set into ln_person_id_sel;

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

453:
454: fetch c_selected_asg_set into ln_person_id_sel;
455:
456: if c_selected_asg_set%notfound then
457: hr_utility.trace('No Person found for reporting in this chunk');
458: exit;
459: end if;
460:
461: hr_utility.trace('ln_person_id after c_selected_asg_set = '||to_char(ln_person_id_sel));

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

457: hr_utility.trace('No Person found for reporting in this chunk');
458: exit;
459: end if;
460:
461: hr_utility.trace('ln_person_id after c_selected_asg_set = '||to_char(ln_person_id_sel));
462:
463: action_creation(ln_person_id_sel);
464:
465: end loop;

Line 505: --hr_utility.trace_on(null,'T4AAMENDPP');

501:
502: end get_parameter;
503:
504: Begin
505: --hr_utility.trace_on(null,'T4AAMENDPP');
506: null;
507:
508:
509: