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

82: ln_asg_set NUMBER := 0;
83: lv_year VARCHAR2(4);
84:
85: BEGIN
86: hr_utility.trace('Entered get_payroll_action_info');
87:
88: open c_payroll_action_info(p_payroll_action_id);
89: fetch c_payroll_action_info into ln_tax_unit_id,
90: ln_person_id,

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

94: ld_start_date,
95: ln_business_group_id;
96: close c_payroll_action_info;
97:
98: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
99: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
100: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
101: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
102: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));

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

95: ln_business_group_id;
96: close c_payroll_action_info;
97:
98: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
99: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
100: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
101: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
102: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
103: hr_utility.trace('lv_year = ' || lv_year);

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

96: close c_payroll_action_info;
97:
98: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
99: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
100: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
101: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
102: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
103: hr_utility.trace('lv_year = ' || lv_year);
104:

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

97:
98: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
99: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
100: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
101: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
102: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
103: hr_utility.trace('lv_year = ' || lv_year);
104:
105: p_end_date := ld_end_date;

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

98: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
99: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
100: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
101: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
102: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
103: hr_utility.trace('lv_year = ' || lv_year);
104:
105: p_end_date := ld_end_date;
106: p_start_date := ld_start_date;

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

99: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
100: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
101: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
102: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
103: hr_utility.trace('lv_year = ' || lv_year);
104:
105: p_end_date := ld_end_date;
106: p_start_date := ld_start_date;
107: p_business_group_id := ln_business_group_id;

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

109: p_person_id := ln_person_id;
110: p_asg_set := ln_asg_set;
111: p_year := lv_year;
112:
113: hr_utility.trace('Leaving get_payroll_action_info');
114:
115: EXCEPTION
116: when others then
117: hr_utility.trace('Error in ' || gv_procedure_name ||

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

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

Line 119: raise hr_utility.hr_error;

115: EXCEPTION
116: when others then
117: hr_utility.trace('Error in ' || gv_procedure_name ||
118: to_char(sqlcode) || '-' || sqlerrm);
119: raise hr_utility.hr_error;
120:
121: END get_payroll_action_info;
122:
123: /*****************************************************************************

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

176: lv_report_cat pay_payroll_actions.report_category%type;
177: -- Variables declared for bug 10399514
178:
179: BEGIN
180: hr_utility.trace('Entered get_payroll_action_info');
181:
182: open c_payroll_action_info(p_payroll_action_id);
183: fetch c_payroll_action_info into ln_tax_unit_id,
184: ln_person_id,

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

193: lv_report_cat;
194: -- Added for bug 10399514
195: close c_payroll_action_info;
196:
197: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
198: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
199: hr_utility.trace('ln_tax_unit_id = ' || to_char(ln_tax_unit_id));
200: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
201: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));

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

194: -- Added for bug 10399514
195: close c_payroll_action_info;
196:
197: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
198: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
199: hr_utility.trace('ln_tax_unit_id = ' || to_char(ln_tax_unit_id));
200: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
201: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
202: hr_utility.trace('lv_report_type = ' || lv_report_type);

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

195: close c_payroll_action_info;
196:
197: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
198: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
199: hr_utility.trace('ln_tax_unit_id = ' || to_char(ln_tax_unit_id));
200: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
201: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
202: hr_utility.trace('lv_report_type = ' || lv_report_type);
203: hr_utility.trace('lv_report_qualifier = '|| lv_report_qualifier);

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

196:
197: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
198: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
199: hr_utility.trace('ln_tax_unit_id = ' || to_char(ln_tax_unit_id));
200: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
201: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
202: hr_utility.trace('lv_report_type = ' || lv_report_type);
203: hr_utility.trace('lv_report_qualifier = '|| lv_report_qualifier);
204: hr_utility.trace('lv_report_cat = ' || lv_report_cat);

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

197: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
198: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
199: hr_utility.trace('ln_tax_unit_id = ' || to_char(ln_tax_unit_id));
200: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
201: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
202: hr_utility.trace('lv_report_type = ' || lv_report_type);
203: hr_utility.trace('lv_report_qualifier = '|| lv_report_qualifier);
204: hr_utility.trace('lv_report_cat = ' || lv_report_cat);
205:

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

198: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
199: hr_utility.trace('ln_tax_unit_id = ' || to_char(ln_tax_unit_id));
200: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
201: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
202: hr_utility.trace('lv_report_type = ' || lv_report_type);
203: hr_utility.trace('lv_report_qualifier = '|| lv_report_qualifier);
204: hr_utility.trace('lv_report_cat = ' || lv_report_cat);
205:
206: p_end_date := ld_end_date;

Line 203: hr_utility.trace('lv_report_qualifier = '|| lv_report_qualifier);

199: hr_utility.trace('ln_tax_unit_id = ' || to_char(ln_tax_unit_id));
200: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
201: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
202: hr_utility.trace('lv_report_type = ' || lv_report_type);
203: hr_utility.trace('lv_report_qualifier = '|| lv_report_qualifier);
204: hr_utility.trace('lv_report_cat = ' || lv_report_cat);
205:
206: p_end_date := ld_end_date;
207: p_start_date := ld_start_date;

Line 204: hr_utility.trace('lv_report_cat = ' || lv_report_cat);

200: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
201: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
202: hr_utility.trace('lv_report_type = ' || lv_report_type);
203: hr_utility.trace('lv_report_qualifier = '|| lv_report_qualifier);
204: hr_utility.trace('lv_report_cat = ' || lv_report_cat);
205:
206: p_end_date := ld_end_date;
207: p_start_date := ld_start_date;
208: p_business_group_id := ln_business_group_id;

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

215: p_state := lv_report_qualifier;
216: p_report_cat := lv_report_cat;
217: -- Added for bug 10399514
218:
219: hr_utility.trace('Leaving get_payroll_action_info');
220:
221: EXCEPTION
222: when others then
223: hr_utility.trace('Error in ' || gv_procedure_name ||

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

219: hr_utility.trace('Leaving get_payroll_action_info');
220:
221: EXCEPTION
222: when others then
223: hr_utility.trace('Error in ' || gv_procedure_name ||
224: to_char(sqlcode) || '-' || sqlerrm);
225: raise hr_utility.hr_error;
226:
227: END get_payroll_action_info;

Line 225: raise hr_utility.hr_error;

221: EXCEPTION
222: when others then
223: hr_utility.trace('Error in ' || gv_procedure_name ||
224: to_char(sqlcode) || '-' || sqlerrm);
225: raise hr_utility.hr_error;
226:
227: END get_payroll_action_info;
228:
229:

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

252: lv_record_name varchar2(80);
253: lv_message varchar2(100) := null;
254:
255: BEGIN
256: hr_utility.trace('Entered eoy_range_cursor');
257: hr_utility.trace('p_payroll_action_id = ' ||
258: to_char(p_payroll_action_id));
259:
260: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id

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

253: lv_message varchar2(100) := null;
254:
255: BEGIN
256: hr_utility.trace('Entered eoy_range_cursor');
257: hr_utility.trace('p_payroll_action_id = ' ||
258: to_char(p_payroll_action_id));
259:
260: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
261: ,p_start_date => ld_start_date

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

273: from per_all_assignments_f asg
274: where person_id = ' || to_char(ln_person_id) ||
275: ' and :p_payroll_action_id > 0';
276:
277: hr_utility.trace('Range for person_id not null');
278:
279: elsif ln_asg_set is not null then
280:
281: lv_sql_string :=

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

287: and asgset.include_or_exclude = ''I''
288: and :payroll_action_id > 0
289: order by paf.person_id ';
290:
291: hr_utility.trace('Range for asg_set not null');
292:
293: else
294:
295: lv_record_name := 'Federal Amendment Pre-Process';

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

307: where person_id = 0
308: and :p_payroll_action_id > 0
309: order by asg.person_id ';
310:
311: hr_utility.trace('No person selected as ln_person_id and ln_asg_set are null');
312:
313: end if;
314:
315: p_sqlstr := lv_sql_string;

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

312:
313: end if;
314:
315: p_sqlstr := lv_sql_string;
316: hr_utility.trace('p_sqlstr = ' ||p_sqlstr);
317:
318: hr_utility.trace('Leaving eoy_range_cursor');
319:
320: END eoy_range_cursor;

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

314:
315: p_sqlstr := lv_sql_string;
316: hr_utility.trace('p_sqlstr = ' ||p_sqlstr);
317:
318: hr_utility.trace('Leaving eoy_range_cursor');
319:
320: END eoy_range_cursor;
321:
322:

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

473: fetch get_prev_t4a_amend_dtls into lv_report_type
474: ,ln_primary_assignment_id
475: ,ln_asg_act_to_lock;
476:
477: hr_utility.trace('lv_report_type ='||lv_report_type);
478: hr_utility.trace('ln_primary_assignment_id ='||
479: to_char(ln_primary_assignment_id));
480: hr_utility.trace('ln_asg_act_to_lock ='||
481: to_char(ln_asg_act_to_lock));

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

474: ,ln_primary_assignment_id
475: ,ln_asg_act_to_lock;
476:
477: hr_utility.trace('lv_report_type ='||lv_report_type);
478: hr_utility.trace('ln_primary_assignment_id ='||
479: to_char(ln_primary_assignment_id));
480: hr_utility.trace('ln_asg_act_to_lock ='||
481: to_char(ln_asg_act_to_lock));
482:

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

476:
477: hr_utility.trace('lv_report_type ='||lv_report_type);
478: hr_utility.trace('ln_primary_assignment_id ='||
479: to_char(ln_primary_assignment_id));
480: hr_utility.trace('ln_asg_act_to_lock ='||
481: to_char(ln_asg_act_to_lock));
482:
483: if get_prev_t4a_amend_dtls%notfound then
484:

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

481: to_char(ln_asg_act_to_lock));
482:
483: if get_prev_t4a_amend_dtls%notfound then
484:
485: hr_utility.trace('get_prev_t4a_amend_dtls Not Found');
486: hr_utility.trace('Warning Message Generated');
487: hr_utility.trace('p_person_id ='||to_char(p_person_id));
488:
489: open get_warning_dtls_for_ee(p_person_id);

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

482:
483: if get_prev_t4a_amend_dtls%notfound then
484:
485: hr_utility.trace('get_prev_t4a_amend_dtls Not Found');
486: hr_utility.trace('Warning Message Generated');
487: hr_utility.trace('p_person_id ='||to_char(p_person_id));
488:
489: open get_warning_dtls_for_ee(p_person_id);
490: fetch get_warning_dtls_for_ee into lv_full_name

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

483: if get_prev_t4a_amend_dtls%notfound then
484:
485: hr_utility.trace('get_prev_t4a_amend_dtls Not Found');
486: hr_utility.trace('Warning Message Generated');
487: hr_utility.trace('p_person_id ='||to_char(p_person_id));
488:
489: open get_warning_dtls_for_ee(p_person_id);
490: fetch get_warning_dtls_for_ee into lv_full_name
491: ,lv_national_identifier;

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

489: open get_warning_dtls_for_ee(p_person_id);
490: fetch get_warning_dtls_for_ee into lv_full_name
491: ,lv_national_identifier;
492:
493: hr_utility.trace('lv_full_name ='||lv_full_name);
494: hr_utility.trace('lv_national_identifier ='||lv_national_identifier);
495:
496: lv_name := lv_full_name || ', SIN '||lv_national_identifier;
497:

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

490: fetch get_warning_dtls_for_ee into lv_full_name
491: ,lv_national_identifier;
492:
493: hr_utility.trace('lv_full_name ='||lv_full_name);
494: hr_utility.trace('lv_national_identifier ='||lv_national_identifier);
495:
496: lv_name := lv_full_name || ', SIN '||lv_national_identifier;
497:
498: close get_warning_dtls_for_ee;

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

509: end if;
510:
511:
512: if get_prev_t4a_amend_dtls%found then
513: hr_utility.trace('get_prev_t4a_amend_dtls Found');
514:
515: if lv_report_type in ('T4A', 'CAEOY_T4A_AMEND_PP') then
516:
517: /* Create an assignment action for this person */

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

518: select pay_assignment_actions_s.nextval
519: into ln_t4a_amend_asg_action
520: from dual;
521:
522: hr_utility.trace('New T4A Amendment Action = ' ||
523: to_char(ln_t4a_amend_asg_action));
524:
525: /* Insert into pay_assignment_actions. */
526: hr_utility.trace('creating assignment action');

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

522: hr_utility.trace('New T4A Amendment Action = ' ||
523: to_char(ln_t4a_amend_asg_action));
524:
525: /* Insert into pay_assignment_actions. */
526: hr_utility.trace('creating assignment action');
527: hr_nonrun_asact.insact(ln_t4a_amend_asg_action
528: ,ln_primary_assignment_id
529: ,p_payroll_action_id
530: ,p_chunk

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

534: so that the T4A Amendment report will not have
535: to do an additional checking against the assignment
536: table */
537:
538: hr_utility.trace('updating assignment action');
539:
540: update pay_assignment_actions aa
541: set aa.serial_number = to_char(p_person_id)
542: where aa.assignment_action_id = ln_t4a_amend_asg_action;

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

543:
544: /* Interlock the YEPP or Previous T4A Amendment Archiver
545: action for current T4A Amendment Pre-process action */
546:
547: hr_utility.trace('Locking Action = ' || to_char(ln_t4a_amend_asg_action));
548: hr_utility.trace('Locked Action = ' || to_char(ln_asg_act_to_lock));
549: hr_nonrun_asact.insint(ln_t4a_amend_asg_action
550: ,ln_asg_act_to_lock);
551:

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

544: /* Interlock the YEPP or Previous T4A Amendment Archiver
545: action for current T4A Amendment Pre-process action */
546:
547: hr_utility.trace('Locking Action = ' || to_char(ln_t4a_amend_asg_action));
548: hr_utility.trace('Locked Action = ' || to_char(ln_asg_act_to_lock));
549: hr_nonrun_asact.insint(ln_t4a_amend_asg_action
550: ,ln_asg_act_to_lock);
551:
552: end if; /* report type */

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

553:
554: end if; /* employee found*/
555:
556: close get_prev_t4a_amend_dtls;
557: hr_utility.trace('closed get_prev_t4a_amend_dtls');
558: END action_creation;
559:
560: BEGIN
561: hr_utility.trace('Entered eoy_action_creation ');

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

557: hr_utility.trace('closed get_prev_t4a_amend_dtls');
558: END action_creation;
559:
560: BEGIN
561: hr_utility.trace('Entered eoy_action_creation ');
562: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
563: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
564: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
565: hr_utility.trace('p_chunk = ' || to_char(p_chunk));

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

558: END action_creation;
559:
560: BEGIN
561: hr_utility.trace('Entered eoy_action_creation ');
562: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
563: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
564: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
565: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
566:

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

559:
560: BEGIN
561: hr_utility.trace('Entered eoy_action_creation ');
562: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
563: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
564: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
565: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
566:
567: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id

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

560: BEGIN
561: hr_utility.trace('Entered eoy_action_creation ');
562: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
563: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
564: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
565: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
566:
567: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
568: ,p_start_date => ld_start_date

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

561: hr_utility.trace('Entered eoy_action_creation ');
562: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
563: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
564: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
565: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
566:
567: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
568: ,p_start_date => ld_start_date
569: ,p_end_date => ld_end_date

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

581: /* PERSON ID IS NOT NULL */
582:
583: if ln_person_id is not null then
584:
585: hr_utility.trace('Entered Person Id logic');
586: action_creation(p_start_person_id);
587:
588: elsif ln_asg_set is not null then
589:

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

586: action_creation(p_start_person_id);
587:
588: elsif ln_asg_set is not null then
589:
590: hr_utility.trace('Entered Asg Set logic');
591: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
592:
593: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
594: hr_utility.trace('End Person ='||to_char(p_end_person_id));

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

587:
588: elsif ln_asg_set is not null then
589:
590: hr_utility.trace('Entered Asg Set logic');
591: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
592:
593: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
594: hr_utility.trace('End Person ='||to_char(p_end_person_id));
595: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));

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

589:
590: hr_utility.trace('Entered Asg Set logic');
591: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
592:
593: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
594: hr_utility.trace('End Person ='||to_char(p_end_person_id));
595: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
596:
597: -- Code modification for bug 10399514 start here

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

590: hr_utility.trace('Entered Asg Set logic');
591: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
592:
593: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
594: hr_utility.trace('End Person ='||to_char(p_end_person_id));
595: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
596:
597: -- Code modification for bug 10399514 start here
598: l_person_on := FALSE ;

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

591: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
592:
593: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
594: hr_utility.trace('End Person ='||to_char(p_end_person_id));
595: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
596:
597: -- Code modification for bug 10399514 start here
598: l_person_on := FALSE ;
599:

Line 619: hr_utility.trace('opening c_selected_asg_set_range CURSOR');

615: p_report_category => l_report_cat) ;
616:
617:
618: if l_person_on then
619: hr_utility.trace('opening c_selected_asg_set_range CURSOR');
620: OPEN c_selected_asg_set_range (p_start_person_id
621: ,p_end_person_id
622: ,ln_asg_set);
623: else

Line 624: hr_utility.trace('opening c_selected_asg_set CURSOR');

620: OPEN c_selected_asg_set_range (p_start_person_id
621: ,p_end_person_id
622: ,ln_asg_set);
623: else
624: hr_utility.trace('opening c_selected_asg_set CURSOR');
625: OPEN c_selected_asg_set (p_start_person_id
626: ,p_end_person_id
627: ,ln_asg_set);
628: end if ;

Line 637: hr_utility.trace('fetching from c_selected_asg_set_range CURSOR');

633: loop
634:
635: -- Code modification for bug 10399514 starts here
636: if l_person_on then
637: hr_utility.trace('fetching from c_selected_asg_set_range CURSOR');
638: fetch c_selected_asg_set_range
639: into ln_person_id_sel;
640: exit when c_selected_asg_set_range%NOTFOUND;
641: else

Line 642: hr_utility.trace('fetching from c_selected_asg_set CURSOR');

638: fetch c_selected_asg_set_range
639: into ln_person_id_sel;
640: exit when c_selected_asg_set_range%NOTFOUND;
641: else
642: hr_utility.trace('fetching from c_selected_asg_set CURSOR');
643: fetch c_selected_asg_set
644: into ln_person_id_sel;
645: exit when c_selected_asg_set%NOTFOUND;
646: end if ;

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

645: exit when c_selected_asg_set%NOTFOUND;
646: end if ;
647: -- Code modification for bug 10399514 ends here
648:
649: hr_utility.trace('ln_person_id after c_selected_asg_set = '||to_char(ln_person_id_sel));
650:
651: action_creation(ln_person_id_sel);
652:
653: end loop;

Line 657: hr_utility.trace('closing c_selected_asg_set_range CURSOR');

653: end loop;
654:
655: -- Code modification for bug 10399514 starts here
656: if l_person_on then
657: hr_utility.trace('closing c_selected_asg_set_range CURSOR');
658: close c_selected_asg_set_range;
659: else
660: hr_utility.trace('closing c_selected_asg_set CURSOR');
661: close c_selected_asg_set;

Line 660: hr_utility.trace('closing c_selected_asg_set CURSOR');

656: if l_person_on then
657: hr_utility.trace('closing c_selected_asg_set_range CURSOR');
658: close c_selected_asg_set_range;
659: else
660: hr_utility.trace('closing c_selected_asg_set CURSOR');
661: close c_selected_asg_set;
662: end if ;
663: -- Code modification for bug 10399514 ends here
664: end if; /* ln_person_id or lv_sin is not null */

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

696:
697: end get_parameter;
698:
699: Begin
700: --hr_utility.trace_on(null,'T4AAMENDPP');
701: null;
702:
703:
704: