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.

[Home] [Help]

APPS.PAY_CA_EOY_RL2_AMEND_ARCH dependencies on HR_UTILITY

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

78: lv_sin per_all_people_f.national_identifier%TYPE;
79: lv_year VARCHAR2(4);
80:
81: BEGIN
82: hr_utility.trace('Entered get_payroll_action_info');
83: open c_payroll_action_info(p_payroll_action_id);
84: fetch c_payroll_action_info into ln_pre_org_id,
85: ln_person_id,
86: lv_sin,

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

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

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

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

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

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

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

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

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

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

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

95: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
96: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
97: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
98: hr_utility.trace('lv_sin = ' || lv_sin);
99: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
100: hr_utility.trace('lv_year = ' || lv_year);
101:
102: p_end_date := ld_end_date;
103: p_start_date := ld_start_date;

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

96: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
97: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
98: hr_utility.trace('lv_sin = ' || lv_sin);
99: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
100: hr_utility.trace('lv_year = ' || lv_year);
101:
102: p_end_date := ld_end_date;
103: p_start_date := ld_start_date;
104: p_business_group_id := ln_business_group_id;

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

106: p_person_id := ln_person_id;
107: p_asg_set := ln_asg_set;
108: p_year := lv_year;
109:
110: hr_utility.trace('Leaving get_payroll_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_payroll_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_payroll_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_payroll_action_info;
119:
120:

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

145: lv_record_name varchar2(80);
146: lv_message varchar2(100) := null;
147:
148: BEGIN
149: hr_utility.trace('Entered eoy_range_cursor');
150: hr_utility.trace('p_payroll_action_id = ' ||
151: to_char(p_payroll_action_id));
152:
153: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id

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

146: lv_message varchar2(100) := null;
147:
148: BEGIN
149: hr_utility.trace('Entered eoy_range_cursor');
150: hr_utility.trace('p_payroll_action_id = ' ||
151: to_char(p_payroll_action_id));
152:
153: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
154: ,p_start_date => ld_start_date

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

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

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

180: and asgset.include_or_exclude = ''I''
181: and :payroll_action_id > 0
182: order by paf.person_id';
183:
184: hr_utility.trace('Range for asg_set not null');
185:
186: else
187:
188: lv_record_name := 'Provincial Amendment Pre-Process';

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

200: where person_id = 0
201: and :p_payroll_action_id > 0
202: order by asg.person_id ';
203:
204: hr_utility.trace('No person is selected as ln_person_id and ln_asg_set are null');
205:
206: end if;
207:
208: p_sqlstr := lv_sql_string;

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

205:
206: end if;
207:
208: p_sqlstr := lv_sql_string;
209: hr_utility.trace('p_sqlstr = ' ||p_sqlstr);
210:
211: hr_utility.trace('Leaving eoy_range_cursor');
212: END eoy_range_cursor;
213:

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

207:
208: p_sqlstr := lv_sql_string;
209: hr_utility.trace('p_sqlstr = ' ||p_sqlstr);
210:
211: hr_utility.trace('Leaving eoy_range_cursor');
212: END eoy_range_cursor;
213:
214:
215: /************************************************************

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

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

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

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

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

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

Line 340: hr_utility.trace('get_prev_rl2_amend_dtls Not Found');

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

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

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

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

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

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

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

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

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

Line 368: hr_utility.trace('get_prev_rl2_amend_dtls Found');

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

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

372: /* Create an assignment action for this person */
373: select pay_assignment_actions_s.nextval
374: into ln_rl2amend_asg_action
375: from dual;
376: hr_utility.trace('New RL2 Amendment Action = ' ||
377: to_char(ln_rl2amend_asg_action));
378:
379: /* Insert into pay_assignment_actions. */
380: -- hr_utility.trace('creating asg. action');

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

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

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

388: so that the RL2 Amendment report will not have
389: to do an additional checking against the assignment
390: table */
391:
392: -- hr_utility.trace('updating asg. 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_rl2amend_asg_action;

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

397:
398: /* Interlock the YEPP or Previous RL2 Amendment Archiver
399: action for current RL2 Amendment Pre-process action */
400:
401: hr_utility.trace('Locking Action = ' || to_char(ln_rl2amend_asg_action));
402: hr_utility.trace('Locked Action = ' || to_char(ln_asg_act_to_lock));
403: hr_nonrun_asact.insint(ln_rl2amend_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 RL2 Amendment Archiver
399: action for current RL2 Amendment Pre-process action */
400:
401: hr_utility.trace('Locking Action = ' || to_char(ln_rl2amend_asg_action));
402: hr_utility.trace('Locked Action = ' || to_char(ln_asg_act_to_lock));
403: hr_nonrun_asact.insint(ln_rl2amend_asg_action
404: ,ln_asg_act_to_lock);
405:
406: end if; /* report type */

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

441: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
442:
443: ln_person_id_sel := 0;
444:
445: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
446: hr_utility.trace('End Person ='||to_char(p_end_person_id));
447: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
448: hr_utility.trace('EOY Pactid ='||to_char(ln_eoy_pactid));
449:

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

442:
443: ln_person_id_sel := 0;
444:
445: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
446: hr_utility.trace('End Person ='||to_char(p_end_person_id));
447: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
448: hr_utility.trace('EOY Pactid ='||to_char(ln_eoy_pactid));
449:
450: open c_selected_asg_set (p_start_person_id

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

443: ln_person_id_sel := 0;
444:
445: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
446: hr_utility.trace('End Person ='||to_char(p_end_person_id));
447: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
448: hr_utility.trace('EOY Pactid ='||to_char(ln_eoy_pactid));
449:
450: open c_selected_asg_set (p_start_person_id
451: ,p_end_person_id

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

444:
445: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
446: hr_utility.trace('End Person ='||to_char(p_end_person_id));
447: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
448: hr_utility.trace('EOY Pactid ='||to_char(ln_eoy_pactid));
449:
450: open c_selected_asg_set (p_start_person_id
451: ,p_end_person_id
452: ,ln_asg_set);

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

449:
450: open c_selected_asg_set (p_start_person_id
451: ,p_end_person_id
452: ,ln_asg_set);
453: hr_utility.trace('Opened cusor c_selected_asg_set');
454: loop
455: fetch c_selected_asg_set into ln_person_id_sel ;
456: if c_selected_asg_set%notfound then
457: hr_utility.trace('No Person found for reporting in this chunk');

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

453: hr_utility.trace('Opened cusor c_selected_asg_set');
454: loop
455: fetch c_selected_asg_set into ln_person_id_sel ;
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;