APPS.PAY_CA_EOY_RL2_AMEND_ARCH dependencies on HR_UTILITY

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 127: raise hr_utility.hr_error;

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

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

174: lv_state1 pay_payroll_actions.report_qualifier%type;
175: lv_report_cat1 pay_report_format_mappings_f.report_format%type;
176:
177: BEGIN
178: hr_utility.trace('Entered get_payroll_action_info');
179: open c_payroll_action_info(p_payroll_action_id);
180: fetch c_payroll_action_info into ln_pre_org_id,
181: ln_person_id,
182: lv_sin,

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

189: lv_state1,
190: lv_report_cat1;
191: close c_payroll_action_info;
192:
193: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
194: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
195: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
196: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
197: hr_utility.trace('lv_sin = ' || lv_sin);

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

190: lv_report_cat1;
191: close c_payroll_action_info;
192:
193: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
194: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
195: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
196: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
197: hr_utility.trace('lv_sin = ' || lv_sin);
198: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));

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

191: close c_payroll_action_info;
192:
193: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
194: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
195: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
196: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
197: hr_utility.trace('lv_sin = ' || lv_sin);
198: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
199: hr_utility.trace('lv_year = ' || lv_year);

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

192:
193: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
194: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
195: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
196: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
197: hr_utility.trace('lv_sin = ' || lv_sin);
198: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
199: hr_utility.trace('lv_year = ' || lv_year);
200: hr_utility.trace('lv_report_type1 = '|| lv_report_type1);

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

193: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
194: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
195: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
196: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
197: hr_utility.trace('lv_sin = ' || lv_sin);
198: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
199: hr_utility.trace('lv_year = ' || lv_year);
200: hr_utility.trace('lv_report_type1 = '|| lv_report_type1);
201: hr_utility.trace('lv_state1 = ' || lv_state1);

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

194: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
195: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
196: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
197: hr_utility.trace('lv_sin = ' || lv_sin);
198: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
199: hr_utility.trace('lv_year = ' || lv_year);
200: hr_utility.trace('lv_report_type1 = '|| lv_report_type1);
201: hr_utility.trace('lv_state1 = ' || lv_state1);
202: hr_utility.trace('lv_report_cat1 = '|| lv_report_cat1);

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

195: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
196: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
197: hr_utility.trace('lv_sin = ' || lv_sin);
198: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
199: hr_utility.trace('lv_year = ' || lv_year);
200: hr_utility.trace('lv_report_type1 = '|| lv_report_type1);
201: hr_utility.trace('lv_state1 = ' || lv_state1);
202: hr_utility.trace('lv_report_cat1 = '|| lv_report_cat1);
203:

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

196: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
197: hr_utility.trace('lv_sin = ' || lv_sin);
198: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
199: hr_utility.trace('lv_year = ' || lv_year);
200: hr_utility.trace('lv_report_type1 = '|| lv_report_type1);
201: hr_utility.trace('lv_state1 = ' || lv_state1);
202: hr_utility.trace('lv_report_cat1 = '|| lv_report_cat1);
203:
204: p_end_date := ld_end_date;

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

197: hr_utility.trace('lv_sin = ' || lv_sin);
198: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
199: hr_utility.trace('lv_year = ' || lv_year);
200: hr_utility.trace('lv_report_type1 = '|| lv_report_type1);
201: hr_utility.trace('lv_state1 = ' || lv_state1);
202: hr_utility.trace('lv_report_cat1 = '|| lv_report_cat1);
203:
204: p_end_date := ld_end_date;
205: p_start_date := ld_start_date;

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

198: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
199: hr_utility.trace('lv_year = ' || lv_year);
200: hr_utility.trace('lv_report_type1 = '|| lv_report_type1);
201: hr_utility.trace('lv_state1 = ' || lv_state1);
202: hr_utility.trace('lv_report_cat1 = '|| lv_report_cat1);
203:
204: p_end_date := ld_end_date;
205: p_start_date := ld_start_date;
206: p_business_group_id := ln_business_group_id;

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

211: p_report_type := lv_report_type1;
212: p_state := lv_state1;
213: p_report_cat := lv_report_cat1;
214:
215: hr_utility.trace('Leaving get_payroll_action_info');
216:
217: EXCEPTION
218: when others then
219: hr_utility.trace('Error in ' || gv_procedure_name ||

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

215: hr_utility.trace('Leaving get_payroll_action_info');
216:
217: EXCEPTION
218: when others then
219: hr_utility.trace('Error in ' || gv_procedure_name ||
220: to_char(sqlcode) || '-' || sqlerrm);
221: raise hr_utility.hr_error;
222:
223: END get_payroll_action_info;

Line 221: raise hr_utility.hr_error;

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

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

248: lv_record_name varchar2(80);
249: lv_message varchar2(100) := null;
250:
251: BEGIN
252: hr_utility.trace('Entered eoy_range_cursor');
253: hr_utility.trace('p_payroll_action_id = ' ||
254: to_char(p_payroll_action_id));
255:
256: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id

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

249: lv_message varchar2(100) := null;
250:
251: BEGIN
252: hr_utility.trace('Entered eoy_range_cursor');
253: hr_utility.trace('p_payroll_action_id = ' ||
254: to_char(p_payroll_action_id));
255:
256: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
257: ,p_start_date => ld_start_date

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

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

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

283: and asgset.include_or_exclude = ''I''
284: and :payroll_action_id > 0
285: order by paf.person_id';
286:
287: hr_utility.trace('Range for asg_set not null');
288:
289: else
290:
291: lv_record_name := 'Provincial Amendment Pre-Process';

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

303: where person_id = 0
304: and :p_payroll_action_id > 0
305: order by asg.person_id ';
306:
307: hr_utility.trace('No person is selected as ln_person_id and ln_asg_set are null');
308:
309: end if;
310:
311: p_sqlstr := lv_sql_string;

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

308:
309: end if;
310:
311: p_sqlstr := lv_sql_string;
312: hr_utility.trace('p_sqlstr = ' ||p_sqlstr);
313:
314: hr_utility.trace('Leaving eoy_range_cursor');
315: END eoy_range_cursor;
316:

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

310:
311: p_sqlstr := lv_sql_string;
312: hr_utility.trace('p_sqlstr = ' ||p_sqlstr);
313:
314: hr_utility.trace('Leaving eoy_range_cursor');
315: END eoy_range_cursor;
316:
317:
318: /************************************************************

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

486: ,lv_state
487: ,lv_report_cat
488: -- Added for bug 10399514
489: ,ln_asg_act_to_lock;
490: hr_utility.trace('lv_report_type ='||lv_report_type);
491: hr_utility.trace('ln_primary_assignment_id ='||
492: to_char(ln_primary_assignment_id));
493: hr_utility.trace('ln_asg_act_to_lock ='||
494: to_char(ln_asg_act_to_lock));

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

487: ,lv_report_cat
488: -- Added for bug 10399514
489: ,ln_asg_act_to_lock;
490: hr_utility.trace('lv_report_type ='||lv_report_type);
491: hr_utility.trace('ln_primary_assignment_id ='||
492: to_char(ln_primary_assignment_id));
493: hr_utility.trace('ln_asg_act_to_lock ='||
494: to_char(ln_asg_act_to_lock));
495:

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

489: ,ln_asg_act_to_lock;
490: hr_utility.trace('lv_report_type ='||lv_report_type);
491: hr_utility.trace('ln_primary_assignment_id ='||
492: to_char(ln_primary_assignment_id));
493: hr_utility.trace('ln_asg_act_to_lock ='||
494: to_char(ln_asg_act_to_lock));
495:
496: if get_prev_rl2_amend_dtls%notfound then
497:

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

494: to_char(ln_asg_act_to_lock));
495:
496: if get_prev_rl2_amend_dtls%notfound then
497:
498: hr_utility.trace('get_prev_rl2_amend_dtls Not Found');
499: hr_utility.trace('Warning Message Generated');
500: hr_utility.trace('p_person_id ='||to_char(p_person_id));
501:
502: open get_warning_dtls_for_ee(p_person_id);

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

495:
496: if get_prev_rl2_amend_dtls%notfound then
497:
498: hr_utility.trace('get_prev_rl2_amend_dtls Not Found');
499: hr_utility.trace('Warning Message Generated');
500: hr_utility.trace('p_person_id ='||to_char(p_person_id));
501:
502: open get_warning_dtls_for_ee(p_person_id);
503: fetch get_warning_dtls_for_ee into lv_full_name

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

496: if get_prev_rl2_amend_dtls%notfound then
497:
498: hr_utility.trace('get_prev_rl2_amend_dtls Not Found');
499: hr_utility.trace('Warning Message Generated');
500: hr_utility.trace('p_person_id ='||to_char(p_person_id));
501:
502: open get_warning_dtls_for_ee(p_person_id);
503: fetch get_warning_dtls_for_ee into lv_full_name
504: ,lv_national_identifier;

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

502: open get_warning_dtls_for_ee(p_person_id);
503: fetch get_warning_dtls_for_ee into lv_full_name
504: ,lv_national_identifier;
505:
506: hr_utility.trace('lv_full_name ='||lv_full_name);
507: hr_utility.trace('lv_national_identifier ='||lv_national_identifier);
508:
509: lv_name := lv_full_name || ', SIN '||lv_national_identifier;
510:

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

503: fetch get_warning_dtls_for_ee into lv_full_name
504: ,lv_national_identifier;
505:
506: hr_utility.trace('lv_full_name ='||lv_full_name);
507: hr_utility.trace('lv_national_identifier ='||lv_national_identifier);
508:
509: lv_name := lv_full_name || ', SIN '||lv_national_identifier;
510:
511: close get_warning_dtls_for_ee;

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

522: end if;
523:
524:
525: if get_prev_rl2_amend_dtls%found then
526: hr_utility.trace('get_prev_rl2_amend_dtls Found');
527:
528: if lv_report_type in ('RL2', 'CAEOY_RL2_AMEND_PP') then
529:
530: /* Create an assignment action for this person */

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

530: /* Create an assignment action for this person */
531: select pay_assignment_actions_s.nextval
532: into ln_rl2amend_asg_action
533: from dual;
534: hr_utility.trace('New RL2 Amendment Action = ' ||
535: to_char(ln_rl2amend_asg_action));
536:
537: /* Insert into pay_assignment_actions. */
538: -- hr_utility.trace('creating asg. action');

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

534: hr_utility.trace('New RL2 Amendment Action = ' ||
535: to_char(ln_rl2amend_asg_action));
536:
537: /* Insert into pay_assignment_actions. */
538: -- hr_utility.trace('creating asg. action');
539: hr_nonrun_asact.insact(ln_rl2amend_asg_action
540: ,ln_primary_assignment_id
541: ,p_payroll_action_id
542: ,p_chunk

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

546: so that the RL2 Amendment report will not have
547: to do an additional checking against the assignment
548: table */
549:
550: -- hr_utility.trace('updating asg. action');
551:
552: update pay_assignment_actions aa
553: set aa.serial_number = to_char(p_person_id)
554: where aa.assignment_action_id = ln_rl2amend_asg_action;

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

555:
556: /* Interlock the YEPP or Previous RL2 Amendment Archiver
557: action for current RL2 Amendment Pre-process action */
558:
559: hr_utility.trace('Locking Action = ' || to_char(ln_rl2amend_asg_action));
560: hr_utility.trace('Locked Action = ' || to_char(ln_asg_act_to_lock));
561: hr_nonrun_asact.insint(ln_rl2amend_asg_action
562: ,ln_asg_act_to_lock);
563:

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

556: /* Interlock the YEPP or Previous RL2 Amendment Archiver
557: action for current RL2 Amendment Pre-process action */
558:
559: hr_utility.trace('Locking Action = ' || to_char(ln_rl2amend_asg_action));
560: hr_utility.trace('Locked Action = ' || to_char(ln_asg_act_to_lock));
561: hr_nonrun_asact.insint(ln_rl2amend_asg_action
562: ,ln_asg_act_to_lock);
563:
564: end if; /* report type */

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

565:
566: end if; /* employee found*/
567:
568: close get_prev_rl2_amend_dtls;
569: hr_utility.trace('closed get_prev_rl2_amend_dtls');
570: END action_creation;
571:
572: BEGIN
573:

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

570: END action_creation;
571:
572: BEGIN
573:
574: hr_utility.trace('Entered eoy_action_creation ');
575: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
576: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
577: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
578: hr_utility.trace('p_chunk = ' || to_char(p_chunk));

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

571:
572: BEGIN
573:
574: hr_utility.trace('Entered eoy_action_creation ');
575: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
576: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
577: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
578: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
579:

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

572: BEGIN
573:
574: hr_utility.trace('Entered eoy_action_creation ');
575: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
576: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
577: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
578: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
579:
580: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id

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

573:
574: hr_utility.trace('Entered eoy_action_creation ');
575: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
576: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
577: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
578: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
579:
580: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
581: ,p_start_date => ld_start_date

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

574: hr_utility.trace('Entered eoy_action_creation ');
575: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
576: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
577: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
578: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
579:
580: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
581: ,p_start_date => ld_start_date
582: ,p_end_date => ld_end_date

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

592: /* PERSON ID IS NOT NULL */
593:
594: if ln_person_id is not null then
595:
596: hr_utility.trace('Entered PersonId logic');
597: action_creation(p_start_person_id);
598:
599: elsif ln_asg_set is not null then
600:

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

597: action_creation(p_start_person_id);
598:
599: elsif ln_asg_set is not null then
600:
601: hr_utility.trace('Entered Asg Set logic');
602: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
603:
604: ln_person_id_sel := 0;
605:

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

598:
599: elsif ln_asg_set is not null then
600:
601: hr_utility.trace('Entered Asg Set logic');
602: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
603:
604: ln_person_id_sel := 0;
605:
606: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));

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

602: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
603:
604: ln_person_id_sel := 0;
605:
606: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
607: hr_utility.trace('End Person ='||to_char(p_end_person_id));
608: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
609: hr_utility.trace('EOY Pactid ='||to_char(ln_eoy_pactid));
610: -- Code modification for bug 10399514 starts here

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

603:
604: ln_person_id_sel := 0;
605:
606: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
607: hr_utility.trace('End Person ='||to_char(p_end_person_id));
608: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
609: hr_utility.trace('EOY Pactid ='||to_char(ln_eoy_pactid));
610: -- Code modification for bug 10399514 starts here
611: /* Initializing variable */

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

604: ln_person_id_sel := 0;
605:
606: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
607: hr_utility.trace('End Person ='||to_char(p_end_person_id));
608: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
609: hr_utility.trace('EOY Pactid ='||to_char(ln_eoy_pactid));
610: -- Code modification for bug 10399514 starts here
611: /* Initializing variable */
612: lv_person_on := FALSE ;

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

605:
606: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
607: hr_utility.trace('End Person ='||to_char(p_end_person_id));
608: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
609: hr_utility.trace('EOY Pactid ='||to_char(ln_eoy_pactid));
610: -- Code modification for bug 10399514 starts here
611: /* Initializing variable */
612: lv_person_on := FALSE ;
613: Begin

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

627: p_report_qualifier => lv_state,
628: p_report_category => lv_report_cat) ;
629:
630: if lv_person_on then
631: hr_utility.trace('opening c_selected_asg_set_range CURSOR');
632: open c_selected_asg_set_range (p_start_person_id
633: ,p_end_person_id
634: ,ln_asg_set);
635: else

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

632: open c_selected_asg_set_range (p_start_person_id
633: ,p_end_person_id
634: ,ln_asg_set);
635: else
636: hr_utility.trace('opening c_selected_asg_set');
637: open c_selected_asg_set (p_start_person_id
638: ,p_end_person_id
639: ,ln_asg_set);
640: end if ;

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

643:
644: loop
645: -- Code modification for bug 10399514 starts here
646: if lv_person_on then
647: hr_utility.trace('fetching from c_selected_asg_set_range CURSOR');
648: fetch c_selected_asg_set_range into ln_person_id_sel ;
649: if c_selected_asg_set_range%notfound then
650: hr_utility.trace('No Person found for reporting in this chunk');
651: exit;

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

646: if lv_person_on then
647: hr_utility.trace('fetching from c_selected_asg_set_range CURSOR');
648: fetch c_selected_asg_set_range into ln_person_id_sel ;
649: if c_selected_asg_set_range%notfound then
650: hr_utility.trace('No Person found for reporting in this chunk');
651: exit;
652: end if;
653: else
654: hr_utility.trace('fetching from c_selected_asg_set CURSOR');

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

650: hr_utility.trace('No Person found for reporting in this chunk');
651: exit;
652: end if;
653: else
654: hr_utility.trace('fetching from c_selected_asg_set CURSOR');
655: fetch c_selected_asg_set into ln_person_id_sel ;
656: if c_selected_asg_set%notfound then
657: hr_utility.trace('No Person found for reporting in this chunk');
658: exit;

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

653: else
654: hr_utility.trace('fetching from c_selected_asg_set CURSOR');
655: fetch c_selected_asg_set into ln_person_id_sel ;
656: if c_selected_asg_set%notfound then
657: hr_utility.trace('No Person found for reporting in this chunk');
658: exit;
659: end if;
660: end if ;
661: -- Code modification for bug 10399514 ends here

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

660: end if ;
661: -- Code modification for bug 10399514 ends here
662:
663:
664: hr_utility.trace('ln_person_id after c_selected_asg_set = '||to_char(ln_person_id_sel));
665:
666: action_creation(ln_person_id_sel);
667:
668: end loop;

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

667:
668: end loop;
669: -- Code modification for bug 10399514 starts here
670: if lv_person_on then
671: hr_utility.trace('closing close c_selected_asg_set_range CURSOR');
672: close c_selected_asg_set_range;
673: else
674: hr_utility.trace('closing c_selected_asg_set');
675: close c_selected_asg_set;

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

670: if lv_person_on then
671: hr_utility.trace('closing close c_selected_asg_set_range CURSOR');
672: close c_selected_asg_set_range;
673: else
674: hr_utility.trace('closing c_selected_asg_set');
675: close c_selected_asg_set;
676: end if ;
677: -- Code modification for bug 10399514 ends here
678: