APPS.PAY_CA_EOY_RL1_AMEND_ARCH dependencies on HR_UTILITY

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

95: lv_sin per_all_people_f.national_identifier%TYPE;
96: lv_year VARCHAR2(4);
97:
98: BEGIN
99: hr_utility.trace('Entered get_payroll_action_info');
100: open c_payroll_action_info(p_payroll_action_id);
101: fetch c_payroll_action_info into ln_pre_org_id,
102: ln_person_id,
103: lv_sin,

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

107: ld_start_date,
108: ln_business_group_id;
109: close c_payroll_action_info;
110:
111: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
112: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
113: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
114: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
115: hr_utility.trace('lv_sin = ' || lv_sin);

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

108: ln_business_group_id;
109: close c_payroll_action_info;
110:
111: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
112: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
113: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
114: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
115: hr_utility.trace('lv_sin = ' || lv_sin);
116: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));

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

109: close c_payroll_action_info;
110:
111: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
112: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
113: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
114: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
115: hr_utility.trace('lv_sin = ' || lv_sin);
116: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
117: hr_utility.trace('lv_year = ' || lv_year);

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

110:
111: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
112: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
113: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
114: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
115: hr_utility.trace('lv_sin = ' || lv_sin);
116: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
117: hr_utility.trace('lv_year = ' || lv_year);
118:

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

111: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
112: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
113: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
114: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
115: hr_utility.trace('lv_sin = ' || lv_sin);
116: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
117: hr_utility.trace('lv_year = ' || lv_year);
118:
119: p_end_date := ld_end_date;

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

112: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
113: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
114: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
115: hr_utility.trace('lv_sin = ' || lv_sin);
116: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
117: hr_utility.trace('lv_year = ' || lv_year);
118:
119: p_end_date := ld_end_date;
120: p_start_date := ld_start_date;

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

113: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
114: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
115: hr_utility.trace('lv_sin = ' || lv_sin);
116: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
117: hr_utility.trace('lv_year = ' || lv_year);
118:
119: p_end_date := ld_end_date;
120: p_start_date := ld_start_date;
121: p_business_group_id := ln_business_group_id;

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

123: p_person_id := ln_person_id;
124: p_asg_set := ln_asg_set;
125: p_year := lv_year;
126:
127: hr_utility.trace('Leaving get_payroll_action_info');
128:
129: EXCEPTION
130: when others then
131: hr_utility.trace('Error in ' || gv_procedure_name ||

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

127: hr_utility.trace('Leaving get_payroll_action_info');
128:
129: EXCEPTION
130: when others then
131: hr_utility.trace('Error in ' || gv_procedure_name ||
132: to_char(sqlcode) || '-' || sqlerrm);
133: raise hr_utility.hr_error;
134:
135: END get_payroll_action_info;

Line 133: raise hr_utility.hr_error;

129: EXCEPTION
130: when others then
131: hr_utility.trace('Error in ' || gv_procedure_name ||
132: to_char(sqlcode) || '-' || sqlerrm);
133: raise hr_utility.hr_error;
134:
135: END get_payroll_action_info;
136:
137: /* Overloaded for the bug 10399514 */

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

181: lv_state1 pay_payroll_actions.report_qualifier%type;
182: lv_report_cat1 pay_report_format_mappings_f.report_format%type;
183:
184: BEGIN
185: hr_utility.trace('Entered get_payroll_action_info');
186: open c_payroll_action_info(p_payroll_action_id);
187: fetch c_payroll_action_info into ln_pre_org_id,
188: ln_person_id,
189: lv_sin,

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

196: lv_state1,
197: lv_report_cat1;
198: close c_payroll_action_info;
199:
200: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
201: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
202: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
203: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
204: hr_utility.trace('lv_sin = ' || lv_sin);

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

197: lv_report_cat1;
198: close c_payroll_action_info;
199:
200: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
201: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
202: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
203: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
204: hr_utility.trace('lv_sin = ' || lv_sin);
205: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));

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

198: close c_payroll_action_info;
199:
200: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
201: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
202: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
203: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
204: hr_utility.trace('lv_sin = ' || lv_sin);
205: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
206: hr_utility.trace('lv_year = ' || lv_year);

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

199:
200: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
201: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
202: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
203: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
204: hr_utility.trace('lv_sin = ' || lv_sin);
205: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
206: hr_utility.trace('lv_year = ' || lv_year);
207: hr_utility.trace('lv_report_type1 = '|| lv_report_type1);

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

200: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
201: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
202: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
203: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
204: hr_utility.trace('lv_sin = ' || lv_sin);
205: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
206: hr_utility.trace('lv_year = ' || lv_year);
207: hr_utility.trace('lv_report_type1 = '|| lv_report_type1);
208: hr_utility.trace('lv_state1 = ' || lv_state1);

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

201: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
202: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
203: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
204: hr_utility.trace('lv_sin = ' || lv_sin);
205: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
206: hr_utility.trace('lv_year = ' || lv_year);
207: hr_utility.trace('lv_report_type1 = '|| lv_report_type1);
208: hr_utility.trace('lv_state1 = ' || lv_state1);
209: hr_utility.trace('lv_report_cat1 = '|| lv_report_cat1);

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

202: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
203: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
204: hr_utility.trace('lv_sin = ' || lv_sin);
205: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
206: hr_utility.trace('lv_year = ' || lv_year);
207: hr_utility.trace('lv_report_type1 = '|| lv_report_type1);
208: hr_utility.trace('lv_state1 = ' || lv_state1);
209: hr_utility.trace('lv_report_cat1 = '|| lv_report_cat1);
210:

Line 207: hr_utility.trace('lv_report_type1 = '|| lv_report_type1);

203: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
204: hr_utility.trace('lv_sin = ' || lv_sin);
205: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
206: hr_utility.trace('lv_year = ' || lv_year);
207: hr_utility.trace('lv_report_type1 = '|| lv_report_type1);
208: hr_utility.trace('lv_state1 = ' || lv_state1);
209: hr_utility.trace('lv_report_cat1 = '|| lv_report_cat1);
210:
211: p_end_date := ld_end_date;

Line 208: hr_utility.trace('lv_state1 = ' || lv_state1);

204: hr_utility.trace('lv_sin = ' || lv_sin);
205: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
206: hr_utility.trace('lv_year = ' || lv_year);
207: hr_utility.trace('lv_report_type1 = '|| lv_report_type1);
208: hr_utility.trace('lv_state1 = ' || lv_state1);
209: hr_utility.trace('lv_report_cat1 = '|| lv_report_cat1);
210:
211: p_end_date := ld_end_date;
212: p_start_date := ld_start_date;

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

205: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
206: hr_utility.trace('lv_year = ' || lv_year);
207: hr_utility.trace('lv_report_type1 = '|| lv_report_type1);
208: hr_utility.trace('lv_state1 = ' || lv_state1);
209: hr_utility.trace('lv_report_cat1 = '|| lv_report_cat1);
210:
211: p_end_date := ld_end_date;
212: p_start_date := ld_start_date;
213: p_business_group_id := ln_business_group_id;

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

218: p_report_type := lv_report_type1;
219: p_state := lv_state1;
220: p_report_cat := lv_report_cat1;
221:
222: hr_utility.trace('Leaving get_payroll_action_info');
223:
224: EXCEPTION
225: when others then
226: hr_utility.trace('Error in ' || gv_procedure_name ||

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

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

Line 228: raise hr_utility.hr_error;

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

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

257: lv_record_name varchar2(80);
258: lv_message varchar2(100) := null;
259:
260: BEGIN
261: hr_utility.trace('Entered eoy_range_cursor');
262: hr_utility.trace('p_payroll_action_id = ' ||
263: to_char(p_payroll_action_id));
264:
265: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id

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

258: lv_message varchar2(100) := null;
259:
260: BEGIN
261: hr_utility.trace('Entered eoy_range_cursor');
262: hr_utility.trace('p_payroll_action_id = ' ||
263: to_char(p_payroll_action_id));
264:
265: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
266: ,p_start_date => ld_start_date

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

278: from per_all_assignments_f asg
279: where person_id = ' || to_char(ln_person_id) ||
280: ' and :p_payroll_action_id > 0';
281:
282: hr_utility.trace('Range for person_id not null');
283:
284: elsif ln_asg_set is not null then
285:
286: lv_sql_string :=

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

292: and asgset.include_or_exclude = ''I''
293: and :payroll_action_id > 0
294: order by paf.person_id';
295:
296: hr_utility.trace('Range for asg_set not null');
297:
298: else
299:
300: lv_record_name := 'Provincial Amendment Pre-Process';

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

312: where person_id = 0
313: and :p_payroll_action_id > 0
314: order by asg.person_id ';
315:
316: hr_utility.trace('No person is selected as ln_person_id and ln_asg_set are null');
317:
318: end if;
319:
320: p_sqlstr := lv_sql_string;

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

317:
318: end if;
319:
320: p_sqlstr := lv_sql_string;
321: hr_utility.trace('p_sqlstr = ' ||p_sqlstr);
322:
323: hr_utility.trace('Leaving eoy_range_cursor');
324: END eoy_range_cursor;
325:

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

319:
320: p_sqlstr := lv_sql_string;
321: hr_utility.trace('p_sqlstr = ' ||p_sqlstr);
322:
323: hr_utility.trace('Leaving eoy_range_cursor');
324: END eoy_range_cursor;
325:
326: /************************************************************
327: Name : eoy_action_creation

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

500: ,lv_state
501: ,lv_report_cat
502: -- Added for bug 10399514
503: ,ln_asg_act_to_lock;
504: hr_utility.trace('lv_report_type ='||lv_report_type);
505: hr_utility.trace('lv_state='||lv_state);
506: hr_utility.trace('lv_report_cat='||lv_report_cat);
507: hr_utility.trace('ln_primary_assignment_id ='||
508: to_char(ln_primary_assignment_id));

Line 505: hr_utility.trace('lv_state='||lv_state);

501: ,lv_report_cat
502: -- Added for bug 10399514
503: ,ln_asg_act_to_lock;
504: hr_utility.trace('lv_report_type ='||lv_report_type);
505: hr_utility.trace('lv_state='||lv_state);
506: hr_utility.trace('lv_report_cat='||lv_report_cat);
507: hr_utility.trace('ln_primary_assignment_id ='||
508: to_char(ln_primary_assignment_id));
509: hr_utility.trace('ln_asg_act_to_lock ='||

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

502: -- Added for bug 10399514
503: ,ln_asg_act_to_lock;
504: hr_utility.trace('lv_report_type ='||lv_report_type);
505: hr_utility.trace('lv_state='||lv_state);
506: hr_utility.trace('lv_report_cat='||lv_report_cat);
507: hr_utility.trace('ln_primary_assignment_id ='||
508: to_char(ln_primary_assignment_id));
509: hr_utility.trace('ln_asg_act_to_lock ='||
510: to_char(ln_asg_act_to_lock));

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

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

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

505: hr_utility.trace('lv_state='||lv_state);
506: hr_utility.trace('lv_report_cat='||lv_report_cat);
507: hr_utility.trace('ln_primary_assignment_id ='||
508: to_char(ln_primary_assignment_id));
509: hr_utility.trace('ln_asg_act_to_lock ='||
510: to_char(ln_asg_act_to_lock));
511:
512: if get_prev_rl1_amend_dtls%notfound then
513:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

550: hr_utility.trace('New RL1 Amendment Action = ' ||
551: to_char(ln_rl1amend_asg_action));
552:
553: /* Insert into pay_assignment_actions. */
554: -- hr_utility.trace('creating asg. action');
555: hr_nonrun_asact.insact(ln_rl1amend_asg_action
556: ,ln_primary_assignment_id
557: ,p_payroll_action_id
558: ,p_chunk

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

619: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
620:
621: ln_person_id_sel := 0;
622:
623: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
624: hr_utility.trace('End Person ='||to_char(p_end_person_id));
625: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
626: hr_utility.trace('EOY Pactid ='||to_char(ln_eoy_pactid));
627:

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

620:
621: ln_person_id_sel := 0;
622:
623: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
624: hr_utility.trace('End Person ='||to_char(p_end_person_id));
625: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
626: hr_utility.trace('EOY Pactid ='||to_char(ln_eoy_pactid));
627:
628: -- Code modification for bug 10399514 starts here

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

621: ln_person_id_sel := 0;
622:
623: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
624: hr_utility.trace('End Person ='||to_char(p_end_person_id));
625: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
626: hr_utility.trace('EOY Pactid ='||to_char(ln_eoy_pactid));
627:
628: -- Code modification for bug 10399514 starts here
629: /* Initializing variable */

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

622:
623: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
624: hr_utility.trace('End Person ='||to_char(p_end_person_id));
625: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
626: hr_utility.trace('EOY Pactid ='||to_char(ln_eoy_pactid));
627:
628: -- Code modification for bug 10399514 starts here
629: /* Initializing variable */
630: lv_person_on := FALSE ;

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

646: p_report_qualifier => lv_state,
647: p_report_category => lv_report_cat) ;
648:
649: if lv_person_on then
650: hr_utility.trace('opening c_selected_asg_set_range CURSOR');
651: open c_selected_asg_set_range (p_start_person_id
652: ,p_end_person_id
653: ,ln_asg_set);
654: else

Line 655: hr_utility.trace('opening c_selected_asg_set');

651: open c_selected_asg_set_range (p_start_person_id
652: ,p_end_person_id
653: ,ln_asg_set);
654: else
655: hr_utility.trace('opening c_selected_asg_set');
656: open c_selected_asg_set (p_start_person_id
657: ,p_end_person_id
658: ,ln_asg_set);
659: end if ;

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

662:
663: loop
664: -- Code modification for bug 10399514 starts here
665: if lv_person_on then
666: hr_utility.trace('fetching from c_selected_asg_set_range CURSOR');
667: fetch c_selected_asg_set_range into ln_person_id_sel ;
668: if c_selected_asg_set_range%notfound then
669: hr_utility.trace('No Person found for reporting in this chunk');
670: exit;

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

665: if lv_person_on then
666: hr_utility.trace('fetching from c_selected_asg_set_range CURSOR');
667: fetch c_selected_asg_set_range into ln_person_id_sel ;
668: if c_selected_asg_set_range%notfound then
669: hr_utility.trace('No Person found for reporting in this chunk');
670: exit;
671: end if;
672: else
673: hr_utility.trace('fetching from c_selected_asg_set CURSOR');

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

669: hr_utility.trace('No Person found for reporting in this chunk');
670: exit;
671: end if;
672: else
673: hr_utility.trace('fetching from c_selected_asg_set CURSOR');
674: fetch c_selected_asg_set into ln_person_id_sel ;
675: if c_selected_asg_set%notfound then
676: hr_utility.trace('No Person found for reporting in this chunk');
677: exit;

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

672: else
673: hr_utility.trace('fetching from c_selected_asg_set CURSOR');
674: fetch c_selected_asg_set into ln_person_id_sel ;
675: if c_selected_asg_set%notfound then
676: hr_utility.trace('No Person found for reporting in this chunk');
677: exit;
678: end if;
679: end if ;
680: -- Code modification for bug 10399514 ends here

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

679: end if ;
680: -- Code modification for bug 10399514 ends here
681:
682:
683: hr_utility.trace('ln_person_id after c_selected_asg_set = '||to_char(ln_person_id_sel));
684:
685: action_creation(ln_person_id_sel);
686:
687: end loop;

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

688:
689:
690: -- Code modification for bug 10399514 starts here
691: if lv_person_on then
692: hr_utility.trace('closing close c_selected_asg_set_range CURSOR');
693: close c_selected_asg_set_range;
694: else
695: hr_utility.trace('closing c_selected_asg_set');
696: close c_selected_asg_set;

Line 695: hr_utility.trace('closing c_selected_asg_set');

691: if lv_person_on then
692: hr_utility.trace('closing close c_selected_asg_set_range CURSOR');
693: close c_selected_asg_set_range;
694: else
695: hr_utility.trace('closing c_selected_asg_set');
696: close c_selected_asg_set;
697: end if ;
698: -- Code modification for bug 10399514 ends here
699:

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

733:
734: end get_parameter;
735:
736: Begin
737: --hr_utility.trace_on(null,'RL1AMENDPP');
738: null;
739:
740: end pay_ca_eoy_rl1_amend_arch;