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

105: lv_sin per_all_people_f.national_identifier%TYPE;
106: lv_year VARCHAR2(4);
107:
108: BEGIN
109: hr_utility.trace('Entered get_payroll_action_info');
110: open c_payroll_action_info(p_payroll_action_id);
111: fetch c_payroll_action_info into ln_tax_unit_id,
112: ln_person_id,
113: lv_sin,

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

117: ld_start_date,
118: ln_business_group_id;
119: close c_payroll_action_info;
120:
121: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
122: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
123: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
124: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
125: hr_utility.trace('lv_sin = ' || lv_sin);

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

118: ln_business_group_id;
119: close c_payroll_action_info;
120:
121: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
122: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
123: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
124: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
125: hr_utility.trace('lv_sin = ' || lv_sin);
126: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));

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

119: close c_payroll_action_info;
120:
121: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
122: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
123: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
124: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
125: hr_utility.trace('lv_sin = ' || lv_sin);
126: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
127: hr_utility.trace('lv_year = ' || lv_year);

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

120:
121: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
122: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
123: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
124: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
125: hr_utility.trace('lv_sin = ' || lv_sin);
126: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
127: hr_utility.trace('lv_year = ' || lv_year);
128:

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

121: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
122: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
123: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
124: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
125: hr_utility.trace('lv_sin = ' || lv_sin);
126: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
127: hr_utility.trace('lv_year = ' || lv_year);
128:
129: p_end_date := ld_end_date;

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

122: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
123: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
124: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
125: hr_utility.trace('lv_sin = ' || lv_sin);
126: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
127: hr_utility.trace('lv_year = ' || lv_year);
128:
129: p_end_date := ld_end_date;
130: p_start_date := ld_start_date;

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

123: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
124: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
125: hr_utility.trace('lv_sin = ' || lv_sin);
126: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
127: hr_utility.trace('lv_year = ' || lv_year);
128:
129: p_end_date := ld_end_date;
130: p_start_date := ld_start_date;
131: p_business_group_id := ln_business_group_id;

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

133: p_person_id := ln_person_id;
134: p_asg_set := ln_asg_set;
135: p_year := lv_year;
136:
137: hr_utility.trace('Leaving get_payroll_action_info');
138:
139: EXCEPTION
140: when others then
141: hr_utility.trace('Error in ' || gv_procedure_name ||

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

137: hr_utility.trace('Leaving get_payroll_action_info');
138:
139: EXCEPTION
140: when others then
141: hr_utility.trace('Error in ' || gv_procedure_name ||
142: to_char(sqlcode) || '-' || sqlerrm);
143: raise hr_utility.hr_error;
144:
145: END get_payroll_action_info;

Line 143: raise hr_utility.hr_error;

139: EXCEPTION
140: when others then
141: hr_utility.trace('Error in ' || gv_procedure_name ||
142: to_char(sqlcode) || '-' || sqlerrm);
143: raise hr_utility.hr_error;
144:
145: END get_payroll_action_info;
146:
147: /*****************************************************************************

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

203: lv_report_cat pay_payroll_actions.report_category%type;
204: -- Variables declared for bug 10399514
205:
206: BEGIN
207: hr_utility.trace('Entered get_payroll_action_info');
208: open c_payroll_action_info(p_payroll_action_id);
209: fetch c_payroll_action_info into ln_tax_unit_id,
210: ln_person_id,
211: lv_sin,

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

220: lv_report_cat;
221: -- Added for bug 10399514
222: close c_payroll_action_info;
223:
224: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
225: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
226: hr_utility.trace('ln_tax_unit_id = ' || to_char(ln_tax_unit_id));
227: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
228: hr_utility.trace('lv_sin = ' || lv_sin);

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

221: -- Added for bug 10399514
222: close c_payroll_action_info;
223:
224: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
225: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
226: hr_utility.trace('ln_tax_unit_id = ' || to_char(ln_tax_unit_id));
227: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
228: hr_utility.trace('lv_sin = ' || lv_sin);
229: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));

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

222: close c_payroll_action_info;
223:
224: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
225: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
226: hr_utility.trace('ln_tax_unit_id = ' || to_char(ln_tax_unit_id));
227: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
228: hr_utility.trace('lv_sin = ' || lv_sin);
229: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
230: hr_utility.trace('lv_year = ' || lv_year);

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

223:
224: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
225: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
226: hr_utility.trace('ln_tax_unit_id = ' || to_char(ln_tax_unit_id));
227: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
228: hr_utility.trace('lv_sin = ' || lv_sin);
229: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
230: hr_utility.trace('lv_year = ' || lv_year);
231: hr_utility.trace('lv_report_type = ' || lv_report_type);

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

224: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
225: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
226: hr_utility.trace('ln_tax_unit_id = ' || to_char(ln_tax_unit_id));
227: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
228: hr_utility.trace('lv_sin = ' || lv_sin);
229: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
230: hr_utility.trace('lv_year = ' || lv_year);
231: hr_utility.trace('lv_report_type = ' || lv_report_type);
232: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);

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

225: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
226: hr_utility.trace('ln_tax_unit_id = ' || to_char(ln_tax_unit_id));
227: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
228: hr_utility.trace('lv_sin = ' || lv_sin);
229: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
230: hr_utility.trace('lv_year = ' || lv_year);
231: hr_utility.trace('lv_report_type = ' || lv_report_type);
232: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);
233: hr_utility.trace('lv_report_cat = ' || lv_report_cat);

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

226: hr_utility.trace('ln_tax_unit_id = ' || to_char(ln_tax_unit_id));
227: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
228: hr_utility.trace('lv_sin = ' || lv_sin);
229: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
230: hr_utility.trace('lv_year = ' || lv_year);
231: hr_utility.trace('lv_report_type = ' || lv_report_type);
232: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);
233: hr_utility.trace('lv_report_cat = ' || lv_report_cat);
234:

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

227: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
228: hr_utility.trace('lv_sin = ' || lv_sin);
229: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
230: hr_utility.trace('lv_year = ' || lv_year);
231: hr_utility.trace('lv_report_type = ' || lv_report_type);
232: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);
233: hr_utility.trace('lv_report_cat = ' || lv_report_cat);
234:
235: p_end_date := ld_end_date;

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

228: hr_utility.trace('lv_sin = ' || lv_sin);
229: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
230: hr_utility.trace('lv_year = ' || lv_year);
231: hr_utility.trace('lv_report_type = ' || lv_report_type);
232: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);
233: hr_utility.trace('lv_report_cat = ' || lv_report_cat);
234:
235: p_end_date := ld_end_date;
236: p_start_date := ld_start_date;

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

229: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
230: hr_utility.trace('lv_year = ' || lv_year);
231: hr_utility.trace('lv_report_type = ' || lv_report_type);
232: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);
233: hr_utility.trace('lv_report_cat = ' || lv_report_cat);
234:
235: p_end_date := ld_end_date;
236: p_start_date := ld_start_date;
237: p_business_group_id := ln_business_group_id;

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

244: p_state := lv_report_qualifier;
245: p_report_cat := lv_report_cat;
246: -- Added for bug 10399514
247:
248: hr_utility.trace('Leaving get_payroll_action_info');
249:
250: EXCEPTION
251: when others then
252: hr_utility.trace('Error in ' || gv_procedure_name ||

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

248: hr_utility.trace('Leaving get_payroll_action_info');
249:
250: EXCEPTION
251: when others then
252: hr_utility.trace('Error in ' || gv_procedure_name ||
253: to_char(sqlcode) || '-' || sqlerrm);
254: raise hr_utility.hr_error;
255:
256: END get_payroll_action_info;

Line 254: raise hr_utility.hr_error;

250: EXCEPTION
251: when others then
252: hr_utility.trace('Error in ' || gv_procedure_name ||
253: to_char(sqlcode) || '-' || sqlerrm);
254: raise hr_utility.hr_error;
255:
256: END get_payroll_action_info;
257:
258:

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

282: lv_record_name varchar2(80);
283: lv_message varchar2(100) := null;
284:
285: BEGIN
286: hr_utility.trace('Entered eoy_range_cursor');
287: hr_utility.trace('p_payroll_action_id = ' ||
288: to_char(p_payroll_action_id));
289:
290: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id

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

283: lv_message varchar2(100) := null;
284:
285: BEGIN
286: hr_utility.trace('Entered eoy_range_cursor');
287: hr_utility.trace('p_payroll_action_id = ' ||
288: to_char(p_payroll_action_id));
289:
290: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
291: ,p_start_date => ld_start_date

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

304: from per_all_assignments_f asg
305: where person_id = ' || to_char(ln_person_id) ||
306: ' and :p_payroll_action_id > 0';
307:
308: hr_utility.trace('Range for person_id not null');
309:
310: elsif ln_asg_set is not null then
311:
312: lv_sql_string :=

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

318: and asgset.include_or_exclude = ''I''
319: and :payroll_action_id > 0
320: order by paf.person_id ';
321:
322: hr_utility.trace('Range for asg_set not null');
323:
324: else
325:
326: lv_record_name := 'Federal Amendment Pre-Process';

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

338: where person_id = 0
339: and :p_payroll_action_id > 0
340: order by asg.person_id';
341:
342: hr_utility.trace('No person selected as ln_person_id and ln_asg_set are null');
343:
344: end if;
345:
346: p_sqlstr := lv_sql_string;

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

343:
344: end if;
345:
346: p_sqlstr := lv_sql_string;
347: hr_utility.trace('p_sqlstr = ' ||p_sqlstr);
348:
349: hr_utility.trace('Leaving eoy_range_cursor');
350: END eoy_range_cursor;
351:

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

345:
346: p_sqlstr := lv_sql_string;
347: hr_utility.trace('p_sqlstr = ' ||p_sqlstr);
348:
349: hr_utility.trace('Leaving eoy_range_cursor');
350: END eoy_range_cursor;
351:
352:
353: /************************************************************

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

503: ,ld_end_date);
504: fetch get_prev_t4_amend_dtls into lv_report_type
505: ,ln_primary_assignment_id
506: ,ln_asg_act_to_lock;
507: hr_utility.trace('lv_report_type ='||lv_report_type);
508: hr_utility.trace('ln_primary_assignment_id ='||
509: to_char(ln_primary_assignment_id));
510: hr_utility.trace('ln_asg_act_to_lock ='||
511: to_char(ln_asg_act_to_lock));

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

504: fetch get_prev_t4_amend_dtls into lv_report_type
505: ,ln_primary_assignment_id
506: ,ln_asg_act_to_lock;
507: hr_utility.trace('lv_report_type ='||lv_report_type);
508: hr_utility.trace('ln_primary_assignment_id ='||
509: to_char(ln_primary_assignment_id));
510: hr_utility.trace('ln_asg_act_to_lock ='||
511: to_char(ln_asg_act_to_lock));
512:

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

506: ,ln_asg_act_to_lock;
507: hr_utility.trace('lv_report_type ='||lv_report_type);
508: hr_utility.trace('ln_primary_assignment_id ='||
509: to_char(ln_primary_assignment_id));
510: hr_utility.trace('ln_asg_act_to_lock ='||
511: to_char(ln_asg_act_to_lock));
512:
513: if get_prev_t4_amend_dtls%notfound then
514:

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

511: to_char(ln_asg_act_to_lock));
512:
513: if get_prev_t4_amend_dtls%notfound then
514:
515: hr_utility.trace('get_prev_t4_amend_dtls Not Found');
516: hr_utility.trace('Warning Message Generated');
517: hr_utility.trace('p_person_id ='||to_char(p_person_id));
518:
519: open get_warning_dtls_for_ee(p_person_id);

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

512:
513: if get_prev_t4_amend_dtls%notfound then
514:
515: hr_utility.trace('get_prev_t4_amend_dtls Not Found');
516: hr_utility.trace('Warning Message Generated');
517: hr_utility.trace('p_person_id ='||to_char(p_person_id));
518:
519: open get_warning_dtls_for_ee(p_person_id);
520: fetch get_warning_dtls_for_ee into lv_full_name

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

513: if get_prev_t4_amend_dtls%notfound then
514:
515: hr_utility.trace('get_prev_t4_amend_dtls Not Found');
516: hr_utility.trace('Warning Message Generated');
517: hr_utility.trace('p_person_id ='||to_char(p_person_id));
518:
519: open get_warning_dtls_for_ee(p_person_id);
520: fetch get_warning_dtls_for_ee into lv_full_name
521: ,lv_national_identifier;

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

519: open get_warning_dtls_for_ee(p_person_id);
520: fetch get_warning_dtls_for_ee into lv_full_name
521: ,lv_national_identifier;
522:
523: hr_utility.trace('lv_full_name ='||lv_full_name);
524: hr_utility.trace('lv_national_identifier ='||lv_national_identifier);
525:
526: lv_name := lv_full_name || ', SIN '||lv_national_identifier;
527:

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

520: fetch get_warning_dtls_for_ee into lv_full_name
521: ,lv_national_identifier;
522:
523: hr_utility.trace('lv_full_name ='||lv_full_name);
524: hr_utility.trace('lv_national_identifier ='||lv_national_identifier);
525:
526: lv_name := lv_full_name || ', SIN '||lv_national_identifier;
527:
528: close get_warning_dtls_for_ee;

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

539: end if;
540:
541:
542: if get_prev_t4_amend_dtls%found then
543: hr_utility.trace('get_prev_t4_amend_dtls Found');
544:
545: if lv_report_type in ('T4', 'CAEOY_T4_AMEND_PP') then
546:
547: /* Create an assignment action for this person */

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

547: /* Create an assignment action for this person */
548: select pay_assignment_actions_s.nextval
549: into ln_t4amend_asg_action
550: from dual;
551: hr_utility.trace('New T4 Amendment Action = ' ||
552: to_char(ln_t4amend_asg_action));
553:
554: /* Insert into pay_assignment_actions. */
555: hr_utility.trace('creating asg_action');

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

551: hr_utility.trace('New T4 Amendment Action = ' ||
552: to_char(ln_t4amend_asg_action));
553:
554: /* Insert into pay_assignment_actions. */
555: hr_utility.trace('creating asg_action');
556: hr_nonrun_asact.insact(ln_t4amend_asg_action
557: ,ln_primary_assignment_id
558: ,p_payroll_action_id
559: ,p_chunk

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

563: so that the T4 Amendment report will not have
564: to do an additional checking against the assignment
565: table */
566:
567: hr_utility.trace('updating asg_action');
568:
569: update pay_assignment_actions aa
570: set aa.serial_number = to_char(p_person_id)
571: where aa.assignment_action_id = ln_t4amend_asg_action;

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

572:
573: /* Interlock the YEPP or Previous T4 Amendment Archiver
574: action for current T4 Amendment Pre-process action */
575:
576: hr_utility.trace('Locking Action = ' || to_char(ln_t4amend_asg_action));
577: hr_utility.trace('Locked Action = ' || to_char(ln_asg_act_to_lock));
578: hr_nonrun_asact.insint(ln_t4amend_asg_action
579: ,ln_asg_act_to_lock);
580:

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

573: /* Interlock the YEPP or Previous T4 Amendment Archiver
574: action for current T4 Amendment Pre-process action */
575:
576: hr_utility.trace('Locking Action = ' || to_char(ln_t4amend_asg_action));
577: hr_utility.trace('Locked Action = ' || to_char(ln_asg_act_to_lock));
578: hr_nonrun_asact.insint(ln_t4amend_asg_action
579: ,ln_asg_act_to_lock);
580:
581: end if; /* report type */

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

582:
583: end if; /* employee found*/
584:
585: close get_prev_t4_amend_dtls;
586: hr_utility.trace('closed get_prev_t4_amend_dtls');
587: END action_creation;
588:
589: BEGIN
590: hr_utility.trace('Entered eoy_action_creation ');

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

586: hr_utility.trace('closed get_prev_t4_amend_dtls');
587: END action_creation;
588:
589: BEGIN
590: hr_utility.trace('Entered eoy_action_creation ');
591: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
592: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
593: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
594: hr_utility.trace('p_chunk = ' || to_char(p_chunk));

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

587: END action_creation;
588:
589: BEGIN
590: hr_utility.trace('Entered eoy_action_creation ');
591: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
592: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
593: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
594: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
595:

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

588:
589: BEGIN
590: hr_utility.trace('Entered eoy_action_creation ');
591: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
592: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
593: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
594: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
595:
596: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id

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

589: BEGIN
590: hr_utility.trace('Entered eoy_action_creation ');
591: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
592: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
593: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
594: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
595:
596: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
597: ,p_start_date => ld_start_date

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

590: hr_utility.trace('Entered eoy_action_creation ');
591: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
592: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
593: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
594: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
595:
596: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
597: ,p_start_date => ld_start_date
598: ,p_end_date => ld_end_date

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

610: /* PERSON ID IS NOT NULL */
611:
612: if ln_person_id is not null then
613:
614: hr_utility.trace('Entered PersonId logic');
615: action_creation(p_start_person_id);
616:
617: elsif ln_asg_set is not null then
618:

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

615: action_creation(p_start_person_id);
616:
617: elsif ln_asg_set is not null then
618:
619: hr_utility.trace('Entered Asg Set logic');
620: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
621:
622: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
623: hr_utility.trace('End Person ='||to_char(p_end_person_id));

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

616:
617: elsif ln_asg_set is not null then
618:
619: hr_utility.trace('Entered Asg Set logic');
620: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
621:
622: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
623: hr_utility.trace('End Person ='||to_char(p_end_person_id));
624: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));

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

618:
619: hr_utility.trace('Entered Asg Set logic');
620: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
621:
622: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
623: hr_utility.trace('End Person ='||to_char(p_end_person_id));
624: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
625:
626: -- Code modification for bug 10399514 start here

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

619: hr_utility.trace('Entered Asg Set logic');
620: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
621:
622: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
623: hr_utility.trace('End Person ='||to_char(p_end_person_id));
624: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
625:
626: -- Code modification for bug 10399514 start here
627: l_person_on := FALSE ;

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

620: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
621:
622: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
623: hr_utility.trace('End Person ='||to_char(p_end_person_id));
624: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
625:
626: -- Code modification for bug 10399514 start here
627: l_person_on := FALSE ;
628:

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

644: p_report_category => l_report_cat) ;
645:
646:
647: if l_person_on then
648: hr_utility.trace('opening c_selected_asg_set_range CURSOR');
649: OPEN c_selected_asg_set_range (p_start_person_id
650: ,p_end_person_id
651: ,ln_asg_set);
652: else

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

649: OPEN c_selected_asg_set_range (p_start_person_id
650: ,p_end_person_id
651: ,ln_asg_set);
652: else
653: hr_utility.trace('opening c_selected_asg_set CURSOR');
654: OPEN c_selected_asg_set (p_start_person_id
655: ,p_end_person_id
656: ,ln_asg_set);
657: end if ;

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

661: loop
662:
663: -- Code modification for bug 10399514 starts here
664: if l_person_on then
665: hr_utility.trace('fetching from c_selected_asg_set_range CURSOR');
666: fetch c_selected_asg_set_range
667: into ln_person_id_sel;
668: exit when c_selected_asg_set_range%NOTFOUND;
669: else

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

666: fetch c_selected_asg_set_range
667: into ln_person_id_sel;
668: exit when c_selected_asg_set_range%NOTFOUND;
669: else
670: hr_utility.trace('fetching from c_selected_asg_set CURSOR');
671: fetch c_selected_asg_set
672: into ln_person_id_sel;
673: exit when c_selected_asg_set%NOTFOUND;
674: end if ;

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

673: exit when c_selected_asg_set%NOTFOUND;
674: end if ;
675: -- Code modification for bug 10399514 ends here
676:
677: hr_utility.trace('ln_person_id after c_selected_asg_set = '||to_char(ln_person_id_sel));
678:
679: action_creation(ln_person_id_sel);
680:
681: end loop;

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

681: end loop;
682:
683: -- Code modification for bug 10399514 starts here
684: if l_person_on then
685: hr_utility.trace('closing c_selected_asg_set_range CURSOR');
686: close c_selected_asg_set_range;
687: else
688: hr_utility.trace('closing c_selected_asg_set CURSOR');
689: close c_selected_asg_set;

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

684: if l_person_on then
685: hr_utility.trace('closing c_selected_asg_set_range CURSOR');
686: close c_selected_asg_set_range;
687: else
688: hr_utility.trace('closing c_selected_asg_set CURSOR');
689: close c_selected_asg_set;
690: end if ;
691: -- Code modification for bug 10399514 ends here
692:

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

725:
726: end get_parameter;
727:
728: Begin
729: --hr_utility.trace_on(null,'T4AMENDPP');
730: null;
731:
732:
733: