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

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

88: lv_sin per_all_people_f.national_identifier%TYPE;
89: lv_year VARCHAR2(4);
90:
91: BEGIN
92: hr_utility.trace('Entered get_payroll_action_info');
93: open c_payroll_action_info(p_payroll_action_id);
94: fetch c_payroll_action_info into ln_pre_org_id,
95: ln_person_id,
96: lv_sin,

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

100: ld_start_date,
101: ln_business_group_id;
102: close c_payroll_action_info;
103:
104: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
105: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
106: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
107: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
108: hr_utility.trace('lv_sin = ' || lv_sin);

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

101: ln_business_group_id;
102: close c_payroll_action_info;
103:
104: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
105: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
106: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
107: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
108: hr_utility.trace('lv_sin = ' || lv_sin);
109: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));

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

102: close c_payroll_action_info;
103:
104: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
105: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
106: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
107: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
108: hr_utility.trace('lv_sin = ' || lv_sin);
109: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
110: hr_utility.trace('lv_year = ' || lv_year);

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

103:
104: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
105: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
106: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
107: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
108: hr_utility.trace('lv_sin = ' || lv_sin);
109: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
110: hr_utility.trace('lv_year = ' || lv_year);
111:

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

104: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
105: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
106: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
107: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
108: hr_utility.trace('lv_sin = ' || lv_sin);
109: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
110: hr_utility.trace('lv_year = ' || lv_year);
111:
112: p_end_date := ld_end_date;

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

105: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
106: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
107: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
108: hr_utility.trace('lv_sin = ' || lv_sin);
109: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
110: hr_utility.trace('lv_year = ' || lv_year);
111:
112: p_end_date := ld_end_date;
113: p_start_date := ld_start_date;

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

106: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
107: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
108: hr_utility.trace('lv_sin = ' || lv_sin);
109: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
110: hr_utility.trace('lv_year = ' || lv_year);
111:
112: p_end_date := ld_end_date;
113: p_start_date := ld_start_date;
114: p_business_group_id := ln_business_group_id;

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

116: p_person_id := ln_person_id;
117: p_asg_set := ln_asg_set;
118: p_year := lv_year;
119:
120: hr_utility.trace('Leaving get_payroll_action_info');
121:
122: EXCEPTION
123: when others then
124: hr_utility.trace('Error in ' || gv_procedure_name ||

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

120: hr_utility.trace('Leaving get_payroll_action_info');
121:
122: EXCEPTION
123: when others then
124: hr_utility.trace('Error in ' || gv_procedure_name ||
125: to_char(sqlcode) || '-' || sqlerrm);
126: raise hr_utility.hr_error;
127:
128: END get_payroll_action_info;

Line 126: raise hr_utility.hr_error;

122: EXCEPTION
123: when others then
124: hr_utility.trace('Error in ' || gv_procedure_name ||
125: to_char(sqlcode) || '-' || sqlerrm);
126: raise hr_utility.hr_error;
127:
128: END get_payroll_action_info;
129:
130:

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

155: lv_record_name varchar2(80);
156: lv_message varchar2(100) := null;
157:
158: BEGIN
159: hr_utility.trace('Entered eoy_range_cursor');
160: hr_utility.trace('p_payroll_action_id = ' ||
161: to_char(p_payroll_action_id));
162:
163: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id

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

156: lv_message varchar2(100) := null;
157:
158: BEGIN
159: hr_utility.trace('Entered eoy_range_cursor');
160: hr_utility.trace('p_payroll_action_id = ' ||
161: to_char(p_payroll_action_id));
162:
163: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
164: ,p_start_date => ld_start_date

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

176: from per_all_assignments_f asg
177: where person_id = ' || to_char(ln_person_id) ||
178: ' and :p_payroll_action_id > 0';
179:
180: hr_utility.trace('Range for person_id not null');
181:
182: elsif ln_asg_set is not null then
183:
184: lv_sql_string :=

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

190: and asgset.include_or_exclude = ''I''
191: and :payroll_action_id > 0
192: order by paf.person_id';
193:
194: hr_utility.trace('Range for asg_set not null');
195:
196: else
197:
198: lv_record_name := 'Provincial Amendment Pre-Process';

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

210: where person_id = 0
211: and :p_payroll_action_id > 0
212: order by asg.person_id ';
213:
214: hr_utility.trace('No person is selected as ln_person_id and ln_asg_set are null');
215:
216: end if;
217:
218: p_sqlstr := lv_sql_string;

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

215:
216: end if;
217:
218: p_sqlstr := lv_sql_string;
219: hr_utility.trace('p_sqlstr = ' ||p_sqlstr);
220:
221: hr_utility.trace('Leaving eoy_range_cursor');
222: END eoy_range_cursor;
223:

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

217:
218: p_sqlstr := lv_sql_string;
219: hr_utility.trace('p_sqlstr = ' ||p_sqlstr);
220:
221: hr_utility.trace('Leaving eoy_range_cursor');
222: END eoy_range_cursor;
223:
224:
225: /************************************************************

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

338: ,ld_end_date);
339: fetch get_prev_rl1_amend_dtls into lv_report_type
340: ,ln_primary_assignment_id
341: ,ln_asg_act_to_lock;
342: hr_utility.trace('lv_report_type ='||lv_report_type);
343: hr_utility.trace('ln_primary_assignment_id ='||
344: to_char(ln_primary_assignment_id));
345: hr_utility.trace('ln_asg_act_to_lock ='||
346: to_char(ln_asg_act_to_lock));

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

339: fetch get_prev_rl1_amend_dtls into lv_report_type
340: ,ln_primary_assignment_id
341: ,ln_asg_act_to_lock;
342: hr_utility.trace('lv_report_type ='||lv_report_type);
343: hr_utility.trace('ln_primary_assignment_id ='||
344: to_char(ln_primary_assignment_id));
345: hr_utility.trace('ln_asg_act_to_lock ='||
346: to_char(ln_asg_act_to_lock));
347:

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

341: ,ln_asg_act_to_lock;
342: hr_utility.trace('lv_report_type ='||lv_report_type);
343: hr_utility.trace('ln_primary_assignment_id ='||
344: to_char(ln_primary_assignment_id));
345: hr_utility.trace('ln_asg_act_to_lock ='||
346: to_char(ln_asg_act_to_lock));
347:
348: if get_prev_rl1_amend_dtls%notfound then
349:

Line 350: hr_utility.trace('get_prev_rl1_amend_dtls Not Found');

346: to_char(ln_asg_act_to_lock));
347:
348: if get_prev_rl1_amend_dtls%notfound then
349:
350: hr_utility.trace('get_prev_rl1_amend_dtls Not Found');
351: hr_utility.trace('Warning Message Generated');
352: hr_utility.trace('p_person_id ='||to_char(p_person_id));
353:
354: open get_warning_dtls_for_ee(p_person_id);

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

347:
348: if get_prev_rl1_amend_dtls%notfound then
349:
350: hr_utility.trace('get_prev_rl1_amend_dtls Not Found');
351: hr_utility.trace('Warning Message Generated');
352: hr_utility.trace('p_person_id ='||to_char(p_person_id));
353:
354: open get_warning_dtls_for_ee(p_person_id);
355: fetch get_warning_dtls_for_ee into lv_full_name

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

348: if get_prev_rl1_amend_dtls%notfound then
349:
350: hr_utility.trace('get_prev_rl1_amend_dtls Not Found');
351: hr_utility.trace('Warning Message Generated');
352: hr_utility.trace('p_person_id ='||to_char(p_person_id));
353:
354: open get_warning_dtls_for_ee(p_person_id);
355: fetch get_warning_dtls_for_ee into lv_full_name
356: ,lv_national_identifier;

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

354: open get_warning_dtls_for_ee(p_person_id);
355: fetch get_warning_dtls_for_ee into lv_full_name
356: ,lv_national_identifier;
357:
358: hr_utility.trace('lv_full_name ='||lv_full_name);
359: hr_utility.trace('lv_national_identifier ='||lv_national_identifier);
360:
361: lv_name := lv_full_name || ', SIN '||lv_national_identifier;
362:

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

355: fetch get_warning_dtls_for_ee into lv_full_name
356: ,lv_national_identifier;
357:
358: hr_utility.trace('lv_full_name ='||lv_full_name);
359: hr_utility.trace('lv_national_identifier ='||lv_national_identifier);
360:
361: lv_name := lv_full_name || ', SIN '||lv_national_identifier;
362:
363: close get_warning_dtls_for_ee;

Line 378: hr_utility.trace('get_prev_rl1_amend_dtls Found');

374: end if;
375:
376:
377: if get_prev_rl1_amend_dtls%found then
378: hr_utility.trace('get_prev_rl1_amend_dtls Found');
379:
380: if lv_report_type in ('RL1', 'CAEOY_RL1_AMEND_PP') then
381:
382: /* Create an assignment action for this person */

Line 386: hr_utility.trace('New RL1 Amendment Action = ' ||

382: /* Create an assignment action for this person */
383: select pay_assignment_actions_s.nextval
384: into ln_rl1amend_asg_action
385: from dual;
386: hr_utility.trace('New RL1 Amendment Action = ' ||
387: to_char(ln_rl1amend_asg_action));
388:
389: /* Insert into pay_assignment_actions. */
390: -- hr_utility.trace('creating asg. action');

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

386: hr_utility.trace('New RL1 Amendment Action = ' ||
387: to_char(ln_rl1amend_asg_action));
388:
389: /* Insert into pay_assignment_actions. */
390: -- hr_utility.trace('creating asg. action');
391: hr_nonrun_asact.insact(ln_rl1amend_asg_action
392: ,ln_primary_assignment_id
393: ,p_payroll_action_id
394: ,p_chunk

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

398: so that the RL1 Amendment report will not have
399: to do an additional checking against the assignment
400: table */
401:
402: -- hr_utility.trace('updating asg. action');
403:
404: update pay_assignment_actions aa
405: set aa.serial_number = to_char(p_person_id)
406: where aa.assignment_action_id = ln_rl1amend_asg_action;

Line 411: hr_utility.trace('Locking Action = ' || to_char(ln_rl1amend_asg_action));

407:
408: /* Interlock the YEPP or Previous RL1 Amendment Archiver
409: action for current RL1 Amendment Pre-process action */
410:
411: hr_utility.trace('Locking Action = ' || to_char(ln_rl1amend_asg_action));
412: hr_utility.trace('Locked Action = ' || to_char(ln_asg_act_to_lock));
413: hr_nonrun_asact.insint(ln_rl1amend_asg_action
414: ,ln_asg_act_to_lock);
415:

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

408: /* Interlock the YEPP or Previous RL1 Amendment Archiver
409: action for current RL1 Amendment Pre-process action */
410:
411: hr_utility.trace('Locking Action = ' || to_char(ln_rl1amend_asg_action));
412: hr_utility.trace('Locked Action = ' || to_char(ln_asg_act_to_lock));
413: hr_nonrun_asact.insint(ln_rl1amend_asg_action
414: ,ln_asg_act_to_lock);
415:
416: end if; /* report type */

Line 421: hr_utility.trace('closed get_prev_rl1_amend_dtls');

417:
418: end if; /* employee found*/
419:
420: close get_prev_rl1_amend_dtls;
421: hr_utility.trace('closed get_prev_rl1_amend_dtls');
422: END action_creation;
423:
424: BEGIN
425: hr_utility.trace('Entered eoy_action_creation ');

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

421: hr_utility.trace('closed get_prev_rl1_amend_dtls');
422: END action_creation;
423:
424: BEGIN
425: hr_utility.trace('Entered eoy_action_creation ');
426: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
427: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
428: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
429: hr_utility.trace('p_chunk = ' || to_char(p_chunk));

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

422: END action_creation;
423:
424: BEGIN
425: hr_utility.trace('Entered eoy_action_creation ');
426: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
427: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
428: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
429: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
430:

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

423:
424: BEGIN
425: hr_utility.trace('Entered eoy_action_creation ');
426: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
427: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
428: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
429: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
430:
431: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id

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

424: BEGIN
425: hr_utility.trace('Entered eoy_action_creation ');
426: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
427: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
428: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
429: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
430:
431: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
432: ,p_start_date => ld_start_date

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

425: hr_utility.trace('Entered eoy_action_creation ');
426: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
427: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
428: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
429: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
430:
431: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
432: ,p_start_date => ld_start_date
433: ,p_end_date => ld_end_date

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

440: /* PERSON ID IS NOT NULL */
441:
442: if ln_person_id is not null then
443:
444: hr_utility.trace('Entered PersonId logic');
445: action_creation(p_start_person_id);
446:
447: elsif ln_asg_set is not null then
448:

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

445: action_creation(p_start_person_id);
446:
447: elsif ln_asg_set is not null then
448:
449: hr_utility.trace('Entered Asg Set logic');
450: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
451:
452: ln_person_id_sel := 0;
453:

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

446:
447: elsif ln_asg_set is not null then
448:
449: hr_utility.trace('Entered Asg Set logic');
450: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
451:
452: ln_person_id_sel := 0;
453:
454: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));

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

450: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
451:
452: ln_person_id_sel := 0;
453:
454: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
455: hr_utility.trace('End Person ='||to_char(p_end_person_id));
456: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
457: hr_utility.trace('EOY Pactid ='||to_char(ln_eoy_pactid));
458:

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

451:
452: ln_person_id_sel := 0;
453:
454: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
455: hr_utility.trace('End Person ='||to_char(p_end_person_id));
456: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
457: hr_utility.trace('EOY Pactid ='||to_char(ln_eoy_pactid));
458:
459: open c_selected_asg_set (p_start_person_id

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

452: ln_person_id_sel := 0;
453:
454: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
455: hr_utility.trace('End Person ='||to_char(p_end_person_id));
456: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
457: hr_utility.trace('EOY Pactid ='||to_char(ln_eoy_pactid));
458:
459: open c_selected_asg_set (p_start_person_id
460: ,p_end_person_id

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

453:
454: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
455: hr_utility.trace('End Person ='||to_char(p_end_person_id));
456: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
457: hr_utility.trace('EOY Pactid ='||to_char(ln_eoy_pactid));
458:
459: open c_selected_asg_set (p_start_person_id
460: ,p_end_person_id
461: ,ln_asg_set);

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

458:
459: open c_selected_asg_set (p_start_person_id
460: ,p_end_person_id
461: ,ln_asg_set);
462: hr_utility.trace('Opened cusor c_selected_asg_set');
463: loop
464: fetch c_selected_asg_set into ln_person_id_sel ;
465: if c_selected_asg_set%notfound then
466: hr_utility.trace('No Person found for reporting in this chunk');

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

462: hr_utility.trace('Opened cusor c_selected_asg_set');
463: loop
464: fetch c_selected_asg_set into ln_person_id_sel ;
465: if c_selected_asg_set%notfound then
466: hr_utility.trace('No Person found for reporting in this chunk');
467: exit;
468: end if;
469:
470: hr_utility.trace('ln_person_id after c_selected_asg_set = '||to_char(ln_person_id_sel));

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

466: hr_utility.trace('No Person found for reporting in this chunk');
467: exit;
468: end if;
469:
470: hr_utility.trace('ln_person_id after c_selected_asg_set = '||to_char(ln_person_id_sel));
471:
472: action_creation(ln_person_id_sel);
473:
474: end loop;

Line 514: --hr_utility.trace_on(null,'RL1AMENDPP');

510:
511: end get_parameter;
512:
513: Begin
514: --hr_utility.trace_on(null,'RL1AMENDPP');
515: null;
516:
517: end pay_ca_eoy_rl1_amend_arch;