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

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

146: lv_prov_cd varchar2(5);
147: lv_report_type varchar2(50);
148:
149: BEGIN
150: hr_utility.trace('Entered get_payroll_action_info');
151: open c_payroll_action_info(p_payroll_action_id);
152: fetch c_payroll_action_info into ln_tax_unit_id,
153: ln_person_id,
154: ln_asg_set,

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

159: lv_prov_cd,
160: lv_report_type;
161: close c_payroll_action_info;
162:
163: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
164: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
165: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
166: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
167: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));

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

160: lv_report_type;
161: close c_payroll_action_info;
162:
163: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
164: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
165: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
166: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
167: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
168: hr_utility.trace('lv_prov_cd = ' || lv_prov_cd);

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

161: close c_payroll_action_info;
162:
163: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
164: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
165: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
166: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
167: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
168: hr_utility.trace('lv_prov_cd = ' || lv_prov_cd);
169:

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

162:
163: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
164: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
165: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
166: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
167: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
168: hr_utility.trace('lv_prov_cd = ' || lv_prov_cd);
169:
170: p_end_date := ld_end_date;

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

163: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
164: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
165: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
166: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
167: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
168: hr_utility.trace('lv_prov_cd = ' || lv_prov_cd);
169:
170: p_end_date := ld_end_date;
171: p_start_date := ld_start_date;

Line 168: hr_utility.trace('lv_prov_cd = ' || lv_prov_cd);

164: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
165: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
166: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
167: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
168: hr_utility.trace('lv_prov_cd = ' || lv_prov_cd);
169:
170: p_end_date := ld_end_date;
171: p_start_date := ld_start_date;
172: p_business_group_id := ln_business_group_id;

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

176: p_print := lv_print;
177: p_prov_cd := lv_prov_cd;
178: p_report_type := lv_report_type;
179:
180: hr_utility.trace('Leaving get_payroll_action_info');
181:
182: EXCEPTION
183: when others then
184: hr_utility.trace('Error in ' || gv_procedure_name ||

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

180: hr_utility.trace('Leaving get_payroll_action_info');
181:
182: EXCEPTION
183: when others then
184: hr_utility.trace('Error in ' || gv_procedure_name ||
185: to_char(sqlcode) || '-' || sqlerrm);
186: raise hr_utility.hr_error;
187:
188: END get_payroll_action_info;

Line 186: raise hr_utility.hr_error;

182: EXCEPTION
183: when others then
184: hr_utility.trace('Error in ' || gv_procedure_name ||
185: to_char(sqlcode) || '-' || sqlerrm);
186: raise hr_utility.hr_error;
187:
188: END get_payroll_action_info;
189:
190: --Added for bug 10399514

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

240: -- Variables declared for bug 10399514
241: l_print_term varchar2(1) := 'N';
242:
243: BEGIN
244: hr_utility.trace('Entered get_payroll_action_info');
245: open c_payroll_action_info(p_payroll_action_id);
246: fetch c_payroll_action_info into ln_tax_unit_id,
247: ln_person_id,
248: ln_asg_set,

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

256: lv_report_cat,
257: l_print_term;
258: close c_payroll_action_info;
259:
260: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
261: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
262: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
263: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
264: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));

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

257: l_print_term;
258: close c_payroll_action_info;
259:
260: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
261: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
262: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
263: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
264: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
265: hr_utility.trace('lv_prov_cd = ' || lv_prov_cd);

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

258: close c_payroll_action_info;
259:
260: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
261: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
262: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
263: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
264: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
265: hr_utility.trace('lv_prov_cd = ' || lv_prov_cd);
266: hr_utility.trace('lv_report_qualifier = '|| lv_report_qualifier);

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

259:
260: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
261: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
262: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
263: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
264: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
265: hr_utility.trace('lv_prov_cd = ' || lv_prov_cd);
266: hr_utility.trace('lv_report_qualifier = '|| lv_report_qualifier);
267: hr_utility.trace('lv_report_cat = ' || lv_report_cat);

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

260: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
261: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
262: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
263: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
264: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
265: hr_utility.trace('lv_prov_cd = ' || lv_prov_cd);
266: hr_utility.trace('lv_report_qualifier = '|| lv_report_qualifier);
267: hr_utility.trace('lv_report_cat = ' || lv_report_cat);
268: hr_utility.trace('l_print_term = ' || l_print_term);

Line 265: hr_utility.trace('lv_prov_cd = ' || lv_prov_cd);

261: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
262: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
263: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
264: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
265: hr_utility.trace('lv_prov_cd = ' || lv_prov_cd);
266: hr_utility.trace('lv_report_qualifier = '|| lv_report_qualifier);
267: hr_utility.trace('lv_report_cat = ' || lv_report_cat);
268: hr_utility.trace('l_print_term = ' || l_print_term);
269:

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

262: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
263: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
264: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
265: hr_utility.trace('lv_prov_cd = ' || lv_prov_cd);
266: hr_utility.trace('lv_report_qualifier = '|| lv_report_qualifier);
267: hr_utility.trace('lv_report_cat = ' || lv_report_cat);
268: hr_utility.trace('l_print_term = ' || l_print_term);
269:
270: p_end_date := ld_end_date;

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

263: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
264: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
265: hr_utility.trace('lv_prov_cd = ' || lv_prov_cd);
266: hr_utility.trace('lv_report_qualifier = '|| lv_report_qualifier);
267: hr_utility.trace('lv_report_cat = ' || lv_report_cat);
268: hr_utility.trace('l_print_term = ' || l_print_term);
269:
270: p_end_date := ld_end_date;
271: p_start_date := ld_start_date;

Line 268: hr_utility.trace('l_print_term = ' || l_print_term);

264: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
265: hr_utility.trace('lv_prov_cd = ' || lv_prov_cd);
266: hr_utility.trace('lv_report_qualifier = '|| lv_report_qualifier);
267: hr_utility.trace('lv_report_cat = ' || lv_report_cat);
268: hr_utility.trace('l_print_term = ' || l_print_term);
269:
270: p_end_date := ld_end_date;
271: p_start_date := ld_start_date;
272: p_business_group_id := ln_business_group_id;

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

279: p_state := lv_report_qualifier;
280: p_report_cat := lv_report_cat;
281: p_print_term := l_print_term;
282:
283: hr_utility.trace('Leaving get_payroll_action_info');
284:
285: EXCEPTION
286: when others then
287: hr_utility.trace('Error in ' || gv_procedure_name ||

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

283: hr_utility.trace('Leaving get_payroll_action_info');
284:
285: EXCEPTION
286: when others then
287: hr_utility.trace('Error in ' || gv_procedure_name ||
288: to_char(sqlcode) || '-' || sqlerrm);
289: raise hr_utility.hr_error;
290:
291: END get_payroll_action_info;

Line 289: raise hr_utility.hr_error;

285: EXCEPTION
286: when others then
287: hr_utility.trace('Error in ' || gv_procedure_name ||
288: to_char(sqlcode) || '-' || sqlerrm);
289: raise hr_utility.hr_error;
290:
291: END get_payroll_action_info;
292:
293:

Line 323: hr_utility.trace('Entered range_cursor');

319: lv_prov_cd varchar2(5);
320: lv_report_type varchar2(50);
321:
322: BEGIN
323: hr_utility.trace('Entered range_cursor');
324: hr_utility.trace('p_payroll_action_id = ' ||
325: to_char(p_payroll_action_id));
326:
327: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id

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

320: lv_report_type varchar2(50);
321:
322: BEGIN
323: hr_utility.trace('Entered range_cursor');
324: hr_utility.trace('p_payroll_action_id = ' ||
325: to_char(p_payroll_action_id));
326:
327: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
328: ,p_start_date => ld_start_date

Line 340: hr_utility.trace('Checking for Preprocess Agent GRE setup');

336: ,p_report_type => lv_report_type);
337:
338: ln_year := to_number(to_char(ld_end_date,'YYYY'));
339:
340: hr_utility.trace('Checking for Preprocess Agent GRE setup');
341:
342: if ln_person_id is not null then
343:
344: lv_sql_string :=

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

346: from per_assignments_f asg
347: where person_id = ' || ln_person_id ||
348: ' and :payroll_action_id > 0';
349:
350: hr_utility.trace('Range for person_id not null');
351:
352: elsif ln_asg_set is not null then
353:
354: lv_sql_string :=

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

360: and asgset.include_or_exclude = ''I''
361: and :payroll_action_id > 0
362: order by paf.person_id';
363:
364: hr_utility.trace('Range for asg_set not null');
365:
366: elsif ln_tax_unit_id is not NULL then
367:
368: lv_sql_string :=

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

400:
401: end if;
402:
403: p_sqlstr := lv_sql_string;
404: hr_utility.trace('p_sqlstr = ' ||p_sqlstr);
405:
406: hr_utility.trace('Leaving range_cursor');
407:
408: END range_cursor;

Line 406: hr_utility.trace('Leaving range_cursor');

402:
403: p_sqlstr := lv_sql_string;
404: hr_utility.trace('p_sqlstr = ' ||p_sqlstr);
405:
406: hr_utility.trace('Leaving range_cursor');
407:
408: END range_cursor;
409:
410:

Line 957: hr_utility.trace('get_latest_t4amendpdf_dtls not found');

953: fetch get_warning_dtls_for_ee into lv_full_name
954: ,lv_employee_number;
955: close get_warning_dtls_for_ee;
956:
957: hr_utility.trace('get_latest_t4amendpdf_dtls not found');
958: hr_utility.trace('p_person_id :'||to_char(p_person_id));
959:
960: lv_record_name := 'T4 Amendment PDF Report';
961: lv_message := 'T4 Amend Preprocess was not run for this employee';

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

954: ,lv_employee_number;
955: close get_warning_dtls_for_ee;
956:
957: hr_utility.trace('get_latest_t4amendpdf_dtls not found');
958: hr_utility.trace('p_person_id :'||to_char(p_person_id));
959:
960: lv_record_name := 'T4 Amendment PDF Report';
961: lv_message := 'T4 Amend Preprocess was not run for this employee';
962:

Line 988: hr_utility.trace('lv_fed_amend_flag : '||lv_fed_amend_flag);

984:
985: lv_fed_amend_flag := 'N';
986: fetch c_get_fed_amend_flag into lv_fed_amend_flag,
987: lv_prov_of_emp;
988: hr_utility.trace('lv_fed_amend_flag : '||lv_fed_amend_flag);
989: hr_utility.trace('lv_prov_of_emp : '||lv_prov_of_emp);
990: exit when c_get_fed_amend_flag%NOTFOUND;
991:
992: if c_get_fed_amend_flag%FOUND then

Line 989: hr_utility.trace('lv_prov_of_emp : '||lv_prov_of_emp);

985: lv_fed_amend_flag := 'N';
986: fetch c_get_fed_amend_flag into lv_fed_amend_flag,
987: lv_prov_of_emp;
988: hr_utility.trace('lv_fed_amend_flag : '||lv_fed_amend_flag);
989: hr_utility.trace('lv_prov_of_emp : '||lv_prov_of_emp);
990: exit when c_get_fed_amend_flag%NOTFOUND;
991:
992: if c_get_fed_amend_flag%FOUND then
993:

Line 1016: hr_utility.trace('get_latest_t4amendpdf_dtls found ');

1012: fetch get_yepp_pact_id into ln_yepp_pact_id;
1013: close get_yepp_pact_id;
1014:
1015: /* Create an assignment action for this person */
1016: hr_utility.trace('get_latest_t4amendpdf_dtls found ');
1017: hr_utility.trace('Report Type: '||lv_report_type);
1018:
1019: if nvl(pay_us_employee_payslip_web.get_doc_eit('T4PDF',
1020: 'PRINT',

Line 1017: hr_utility.trace('Report Type: '||lv_report_type);

1013: close get_yepp_pact_id;
1014:
1015: /* Create an assignment action for this person */
1016: hr_utility.trace('get_latest_t4amendpdf_dtls found ');
1017: hr_utility.trace('Report Type: '||lv_report_type);
1018:
1019: if nvl(pay_us_employee_payslip_web.get_doc_eit('T4PDF',
1020: 'PRINT',
1021: 'ASSIGNMENT',

Line 1028: hr_utility.trace('New T4 Amend Action = ' ||

1024: select pay_assignment_actions_s.nextval
1025: into ln_t4amend_reg_asg_action
1026: from dual;
1027:
1028: hr_utility.trace('New T4 Amend Action = ' ||
1029: to_char(ln_t4amend_reg_asg_action));
1030:
1031: /* Insert into pay_assignment_actions. */
1032: hr_nonrun_asact.insact(ln_t4amend_reg_asg_action

Line 1056: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));

1052:
1053: update pay_assignment_actions aa
1054: set aa.serial_number = ln_serial_number
1055: where aa.assignment_action_id = ln_t4amend_reg_asg_action;
1056: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));
1057: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
1058: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
1059:
1060:

Line 1057: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));

1053: update pay_assignment_actions aa
1054: set aa.serial_number = ln_serial_number
1055: where aa.assignment_action_id = ln_t4amend_reg_asg_action;
1056: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));
1057: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
1058: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
1059:
1060:
1061: --Added to lock the Amend Archiver

Line 1058: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));

1054: set aa.serial_number = ln_serial_number
1055: where aa.assignment_action_id = ln_t4amend_reg_asg_action;
1056: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));
1057: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
1058: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
1059:
1060:
1061: --Added to lock the Amend Archiver
1062: hr_nonrun_asact.insint(ln_t4amend_reg_asg_action

Line 1064: hr_utility.trace('Locking Action'||ln_t4amend_reg_asg_action);

1060:
1061: --Added to lock the Amend Archiver
1062: hr_nonrun_asact.insint(ln_t4amend_reg_asg_action
1063: ,ln_asg_act_to_lock);
1064: hr_utility.trace('Locking Action'||ln_t4amend_reg_asg_action);
1065: hr_utility.trace('ln_serial_number :' || ln_serial_number);
1066: hr_utility.trace('Locked Action = ' || to_char(ln_asg_act_to_lock));
1067: end if;
1068:

Line 1065: hr_utility.trace('ln_serial_number :' || ln_serial_number);

1061: --Added to lock the Amend Archiver
1062: hr_nonrun_asact.insint(ln_t4amend_reg_asg_action
1063: ,ln_asg_act_to_lock);
1064: hr_utility.trace('Locking Action'||ln_t4amend_reg_asg_action);
1065: hr_utility.trace('ln_serial_number :' || ln_serial_number);
1066: hr_utility.trace('Locked Action = ' || to_char(ln_asg_act_to_lock));
1067: end if;
1068:
1069: else

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

1062: hr_nonrun_asact.insint(ln_t4amend_reg_asg_action
1063: ,ln_asg_act_to_lock);
1064: hr_utility.trace('Locking Action'||ln_t4amend_reg_asg_action);
1065: hr_utility.trace('ln_serial_number :' || ln_serial_number);
1066: hr_utility.trace('Locked Action = ' || to_char(ln_asg_act_to_lock));
1067: end if;
1068:
1069: else
1070:

Line 1155: hr_utility.trace('get_reprint_t4amendpdf_dtls not found');

1151: fetch get_warning_dtls_for_ee into lv_full_name
1152: ,lv_employee_number;
1153: close get_warning_dtls_for_ee;
1154:
1155: hr_utility.trace('get_reprint_t4amendpdf_dtls not found');
1156: hr_utility.trace('p_person_id :'||to_char(p_person_id));
1157:
1158: lv_record_name := 'T4 Amendment PDF Report';
1159: lv_message := 'As T4 Amendment PDF was not run in Unprint Mode, Reprint mode will not be applicable';

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

1152: ,lv_employee_number;
1153: close get_warning_dtls_for_ee;
1154:
1155: hr_utility.trace('get_reprint_t4amendpdf_dtls not found');
1156: hr_utility.trace('p_person_id :'||to_char(p_person_id));
1157:
1158: lv_record_name := 'T4 Amendment PDF Report';
1159: lv_message := 'As T4 Amendment PDF was not run in Unprint Mode, Reprint mode will not be applicable';
1160:

Line 1185: hr_utility.trace('lv_fed_amend_flag : '||lv_fed_amend_flag);

1181:
1182: lv_fed_amend_flag := 'N';
1183: fetch c_get_fed_amend_flag into lv_fed_amend_flag,
1184: lv_prov_of_emp;
1185: hr_utility.trace('lv_fed_amend_flag : '||lv_fed_amend_flag);
1186: hr_utility.trace('lv_prov_of_emp : '||lv_prov_of_emp);
1187: exit when c_get_fed_amend_flag%NOTFOUND;
1188:
1189: if c_get_fed_amend_flag%FOUND then

Line 1186: hr_utility.trace('lv_prov_of_emp : '||lv_prov_of_emp);

1182: lv_fed_amend_flag := 'N';
1183: fetch c_get_fed_amend_flag into lv_fed_amend_flag,
1184: lv_prov_of_emp;
1185: hr_utility.trace('lv_fed_amend_flag : '||lv_fed_amend_flag);
1186: hr_utility.trace('lv_prov_of_emp : '||lv_prov_of_emp);
1187: exit when c_get_fed_amend_flag%NOTFOUND;
1188:
1189: if c_get_fed_amend_flag%FOUND then
1190:

Line 1204: hr_utility.trace('get_reprint_t4amendpdf_dtls found ');

1200: fetch get_yepp_pact_id into ln_yepp_pact_id;
1201: close get_yepp_pact_id;
1202:
1203: /* Create an assignment action for this person */
1204: hr_utility.trace('get_reprint_t4amendpdf_dtls found ');
1205: hr_utility.trace('Report Type: '||lv_report_type);
1206:
1207: if nvl(pay_us_employee_payslip_web.get_doc_eit('T4PDF',
1208: 'PRINT',

Line 1205: hr_utility.trace('Report Type: '||lv_report_type);

1201: close get_yepp_pact_id;
1202:
1203: /* Create an assignment action for this person */
1204: hr_utility.trace('get_reprint_t4amendpdf_dtls found ');
1205: hr_utility.trace('Report Type: '||lv_report_type);
1206:
1207: if nvl(pay_us_employee_payslip_web.get_doc_eit('T4PDF',
1208: 'PRINT',
1209: 'ASSIGNMENT',

Line 1216: hr_utility.trace('New T4 Amend Action = ' ||

1212: select pay_assignment_actions_s.nextval
1213: into ln_t4amend_reg_asg_action
1214: from dual;
1215:
1216: hr_utility.trace('New T4 Amend Action = ' ||
1217: to_char(ln_t4amend_reg_asg_action));
1218:
1219: /* Insert into pay_assignment_actions. */
1220: hr_nonrun_asact.insact(ln_t4amend_reg_asg_action

Line 1244: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));

1240:
1241: update pay_assignment_actions aa
1242: set aa.serial_number = ln_serial_number
1243: where aa.assignment_action_id = ln_t4amend_reg_asg_action;
1244: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));
1245: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
1246: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
1247: end if; -- PRINT
1248:

Line 1245: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));

1241: update pay_assignment_actions aa
1242: set aa.serial_number = ln_serial_number
1243: where aa.assignment_action_id = ln_t4amend_reg_asg_action;
1244: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));
1245: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
1246: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
1247: end if; -- PRINT
1248:
1249: end if; -- lv_fed_amend_flag = 'Y'

Line 1246: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));

1242: set aa.serial_number = ln_serial_number
1243: where aa.assignment_action_id = ln_t4amend_reg_asg_action;
1244: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));
1245: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
1246: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
1247: end if; -- PRINT
1248:
1249: end if; -- lv_fed_amend_flag = 'Y'
1250:

Line 1290: hr_utility.trace('get_latest_t4amend_dtls not found');

1286: fetch get_warning_dtls_for_ee into lv_full_name
1287: ,lv_employee_number;
1288: close get_warning_dtls_for_ee;
1289:
1290: hr_utility.trace('get_latest_t4amend_dtls not found');
1291: hr_utility.trace('p_person_id :'||to_char(p_person_id));
1292:
1293: if lv_ppr_report_type = 'PYT4PRAMEND' then
1294: lv_record_name := 'T4 Amend Paper Report';

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

1287: ,lv_employee_number;
1288: close get_warning_dtls_for_ee;
1289:
1290: hr_utility.trace('get_latest_t4amend_dtls not found');
1291: hr_utility.trace('p_person_id :'||to_char(p_person_id));
1292:
1293: if lv_ppr_report_type = 'PYT4PRAMEND' then
1294: lv_record_name := 'T4 Amend Paper Report';
1295: else

Line 1324: hr_utility.trace('lv_fed_amend_flag : '||lv_fed_amend_flag);

1320:
1321: lv_fed_amend_flag := 'N';
1322: fetch c_get_fed_amend_flag into lv_fed_amend_flag,
1323: lv_prov_of_emp;
1324: hr_utility.trace('lv_fed_amend_flag : '||lv_fed_amend_flag);
1325: hr_utility.trace('lv_prov_of_emp : '||lv_prov_of_emp);
1326: exit when c_get_fed_amend_flag%NOTFOUND;
1327:
1328: if c_get_fed_amend_flag%FOUND then

Line 1325: hr_utility.trace('lv_prov_of_emp : '||lv_prov_of_emp);

1321: lv_fed_amend_flag := 'N';
1322: fetch c_get_fed_amend_flag into lv_fed_amend_flag,
1323: lv_prov_of_emp;
1324: hr_utility.trace('lv_fed_amend_flag : '||lv_fed_amend_flag);
1325: hr_utility.trace('lv_prov_of_emp : '||lv_prov_of_emp);
1326: exit when c_get_fed_amend_flag%NOTFOUND;
1327:
1328: if c_get_fed_amend_flag%FOUND then
1329:

Line 1343: hr_utility.trace('get_latest_t4amend_dtls found ');

1339: fetch get_yepp_pact_id into ln_yepp_pact_id;
1340: close get_yepp_pact_id;
1341:
1342: /* Create an assignment action for this person */
1343: hr_utility.trace('get_latest_t4amend_dtls found ');
1344: hr_utility.trace('Report Type: '||lv_report_type);
1345:
1346: select pay_assignment_actions_s.nextval
1347: into ln_t4amend_reg_asg_action

Line 1344: hr_utility.trace('Report Type: '||lv_report_type);

1340: close get_yepp_pact_id;
1341:
1342: /* Create an assignment action for this person */
1343: hr_utility.trace('get_latest_t4amend_dtls found ');
1344: hr_utility.trace('Report Type: '||lv_report_type);
1345:
1346: select pay_assignment_actions_s.nextval
1347: into ln_t4amend_reg_asg_action
1348: from dual;

Line 1350: hr_utility.trace('New T4 Amend Action = ' ||

1346: select pay_assignment_actions_s.nextval
1347: into ln_t4amend_reg_asg_action
1348: from dual;
1349:
1350: hr_utility.trace('New T4 Amend Action = ' ||
1351: to_char(ln_t4amend_reg_asg_action));
1352:
1353: /* Insert into pay_assignment_actions. */
1354: hr_nonrun_asact.insact(ln_t4amend_reg_asg_action

Line 1378: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));

1374:
1375: update pay_assignment_actions aa
1376: set aa.serial_number = ln_serial_number
1377: where aa.assignment_action_id = ln_t4amend_reg_asg_action;
1378: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));
1379: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
1380: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
1381:
1382: hr_utility.trace('Locking Action'||ln_t4amend_reg_asg_action);

Line 1379: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));

1375: update pay_assignment_actions aa
1376: set aa.serial_number = ln_serial_number
1377: where aa.assignment_action_id = ln_t4amend_reg_asg_action;
1378: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));
1379: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
1380: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
1381:
1382: hr_utility.trace('Locking Action'||ln_t4amend_reg_asg_action);
1383: hr_utility.trace('ln_serial_number :' || ln_serial_number);

Line 1380: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));

1376: set aa.serial_number = ln_serial_number
1377: where aa.assignment_action_id = ln_t4amend_reg_asg_action;
1378: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));
1379: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
1380: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
1381:
1382: hr_utility.trace('Locking Action'||ln_t4amend_reg_asg_action);
1383: hr_utility.trace('ln_serial_number :' || ln_serial_number);
1384:

Line 1382: hr_utility.trace('Locking Action'||ln_t4amend_reg_asg_action);

1378: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));
1379: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
1380: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
1381:
1382: hr_utility.trace('Locking Action'||ln_t4amend_reg_asg_action);
1383: hr_utility.trace('ln_serial_number :' || ln_serial_number);
1384:
1385: end if; -- lv_fed_amend_flag = 'Y'
1386:

Line 1383: hr_utility.trace('ln_serial_number :' || ln_serial_number);

1379: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
1380: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
1381:
1382: hr_utility.trace('Locking Action'||ln_t4amend_reg_asg_action);
1383: hr_utility.trace('ln_serial_number :' || ln_serial_number);
1384:
1385: end if; -- lv_fed_amend_flag = 'Y'
1386:
1387: end if; -- c_get_fed_amend_flag%FOUND

Line 1410: hr_utility.trace('lv_print :'||lv_print);

1406: ln_primary_assignment_id := 0;
1407: ln_asg_act_to_lock := 0;
1408: ln_gre_id_null := 0;
1409:
1410: hr_utility.trace('lv_print :'||lv_print);
1411:
1412: loop
1413:
1414: fetch get_all_t4amend_dtls into lv_report_type

Line 1419: hr_utility.trace('get_all_t4amend_dtls not found ');

1415: ,ln_primary_assignment_id
1416: ,ln_asg_act_to_lock
1417: ,ln_gre_id_null;
1418: if get_all_t4amend_dtls%notfound then
1419: hr_utility.trace('get_all_t4amend_dtls not found ');
1420: exit;
1421: end if;
1422:
1423: open c_get_fed_amend_flag(ln_asg_act_to_lock,

Line 1431: hr_utility.trace('lv_fed_amend_flag : '||lv_fed_amend_flag);

1427:
1428: lv_fed_amend_flag := 'N';
1429: fetch c_get_fed_amend_flag into lv_fed_amend_flag,
1430: lv_prov_of_emp;
1431: hr_utility.trace('lv_fed_amend_flag : '||lv_fed_amend_flag);
1432: hr_utility.trace('lv_prov_of_emp : '||lv_prov_of_emp);
1433: exit when c_get_fed_amend_flag%NOTFOUND;
1434:
1435: if c_get_fed_amend_flag%FOUND then

Line 1432: hr_utility.trace('lv_prov_of_emp : '||lv_prov_of_emp);

1428: lv_fed_amend_flag := 'N';
1429: fetch c_get_fed_amend_flag into lv_fed_amend_flag,
1430: lv_prov_of_emp;
1431: hr_utility.trace('lv_fed_amend_flag : '||lv_fed_amend_flag);
1432: hr_utility.trace('lv_prov_of_emp : '||lv_prov_of_emp);
1433: exit when c_get_fed_amend_flag%NOTFOUND;
1434:
1435: if c_get_fed_amend_flag%FOUND then
1436:

Line 1450: hr_utility.trace('get_all_t4amend_dtls found ');

1446: fetch get_yepp_pact_id into ln_yepp_pact_id;
1447: close get_yepp_pact_id;
1448:
1449:
1450: hr_utility.trace('get_all_t4amend_dtls found ');
1451: hr_utility.trace('Report Type: '||lv_report_type);
1452:
1453: /* Create an assignment action for this person */
1454:

Line 1451: hr_utility.trace('Report Type: '||lv_report_type);

1447: close get_yepp_pact_id;
1448:
1449:
1450: hr_utility.trace('get_all_t4amend_dtls found ');
1451: hr_utility.trace('Report Type: '||lv_report_type);
1452:
1453: /* Create an assignment action for this person */
1454:
1455: select pay_assignment_actions_s.nextval

Line 1458: hr_utility.trace('New T4 Amend Action = ' || ln_t4amend_reg_asg_action);

1454:
1455: select pay_assignment_actions_s.nextval
1456: into ln_t4amend_reg_asg_action
1457: from dual;
1458: hr_utility.trace('New T4 Amend Action = ' || ln_t4amend_reg_asg_action);
1459:
1460: /* Insert into pay_assignment_actions. */
1461: hr_nonrun_asact.insact(ln_t4amend_reg_asg_action
1462: ,ln_primary_assignment_id

Line 1481: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));

1477: ***********************************************************/
1478: ln_serial_number := lv_prov_of_emp||
1479: lpad(to_char(ln_asg_act_to_lock),14,0)||
1480: lpad(to_char(ln_yepp_pact_id),14,0);
1481: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));
1482: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
1483: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
1484:
1485: update pay_assignment_actions aa

Line 1482: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));

1478: ln_serial_number := lv_prov_of_emp||
1479: lpad(to_char(ln_asg_act_to_lock),14,0)||
1480: lpad(to_char(ln_yepp_pact_id),14,0);
1481: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));
1482: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
1483: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
1484:
1485: update pay_assignment_actions aa
1486: set aa.serial_number = ln_serial_number

Line 1483: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));

1479: lpad(to_char(ln_asg_act_to_lock),14,0)||
1480: lpad(to_char(ln_yepp_pact_id),14,0);
1481: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));
1482: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
1483: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
1484:
1485: update pay_assignment_actions aa
1486: set aa.serial_number = ln_serial_number
1487: where aa.assignment_action_id = ln_t4amend_reg_asg_action;

Line 1503: hr_utility.trace('Entered action_creation ');

1499:
1500: END action_creation;
1501:
1502: BEGIN
1503: hr_utility.trace('Entered action_creation ');
1504: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
1505: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
1506: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
1507: hr_utility.trace('p_chunk = ' || to_char(p_chunk));

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

1500: END action_creation;
1501:
1502: BEGIN
1503: hr_utility.trace('Entered action_creation ');
1504: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
1505: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
1506: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
1507: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
1508:

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

1501:
1502: BEGIN
1503: hr_utility.trace('Entered action_creation ');
1504: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
1505: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
1506: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
1507: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
1508:
1509: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id

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

1502: BEGIN
1503: hr_utility.trace('Entered action_creation ');
1504: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
1505: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
1506: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
1507: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
1508:
1509: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
1510: ,p_start_date => ld_start_date

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

1503: hr_utility.trace('Entered action_creation ');
1504: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
1505: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
1506: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
1507: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
1508:
1509: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
1510: ,p_start_date => ld_start_date
1511: ,p_end_date => ld_end_date

Line 1525: hr_utility.trace('lv_ppr_report_type: '||lv_ppr_report_type);

1521: ,p_report_cat => l_report_cat
1522: ,p_print_term => l_print_term);
1523: -- Added for bug 10399514
1524:
1525: hr_utility.trace('lv_ppr_report_type: '||lv_ppr_report_type);
1526:
1527: ln_tax_unit_id := ln_gre_parameter;
1528:
1529: -- Code modification for bug 10399514 start here

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

1553: action_creation(p_start_person_id);
1554:
1555: elsif ln_asg_set is not null then
1556:
1557: hr_utility.trace('Entered Asg Set logic');
1558: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
1559: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1560: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1561:

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

1554:
1555: elsif ln_asg_set is not null then
1556:
1557: hr_utility.trace('Entered Asg Set logic');
1558: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
1559: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1560: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1561:
1562: -- Code modification for bug 10399514 start here

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

1555: elsif ln_asg_set is not null then
1556:
1557: hr_utility.trace('Entered Asg Set logic');
1558: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
1559: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1560: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1561:
1562: -- Code modification for bug 10399514 start here
1563: if l_person_on then

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

1556:
1557: hr_utility.trace('Entered Asg Set logic');
1558: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
1559: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1560: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1561:
1562: -- Code modification for bug 10399514 start here
1563: if l_person_on then
1564: open c_selected_asg_set_range (p_start_person_id

Line 1568: hr_utility.trace('Opened cusor c_selected_asg_set_range');

1564: open c_selected_asg_set_range (p_start_person_id
1565: ,p_end_person_id
1566: ,ln_asg_set
1567: ,ld_end_date);
1568: hr_utility.trace('Opened cusor c_selected_asg_set_range');
1569: else
1570: open c_selected_asg_set (p_start_person_id
1571: ,p_end_person_id
1572: ,ln_asg_set

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

1570: open c_selected_asg_set (p_start_person_id
1571: ,p_end_person_id
1572: ,ln_asg_set
1573: ,ld_end_date);
1574: hr_utility.trace('Opened cusor c_selected_asg_set');
1575: end if;
1576: -- Code modification for bug 10399514 ends here
1577: loop
1578: -- Code modification for bug 10399514 starts here

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

1576: -- Code modification for bug 10399514 ends here
1577: loop
1578: -- Code modification for bug 10399514 starts here
1579: if l_person_on then
1580: hr_utility.trace('fetching from c_selected_asg_set_range CURSOR');
1581: fetch c_selected_asg_set_range
1582: into ln_set_person_id;
1583: if c_selected_asg_set_range%notfound then
1584: hr_utility.trace('c_selected_asg_set_range not found ');

Line 1584: hr_utility.trace('c_selected_asg_set_range not found ');

1580: hr_utility.trace('fetching from c_selected_asg_set_range CURSOR');
1581: fetch c_selected_asg_set_range
1582: into ln_set_person_id;
1583: if c_selected_asg_set_range%notfound then
1584: hr_utility.trace('c_selected_asg_set_range not found ');
1585: hr_utility.trace('No Person found for reporting in this chunk');
1586: exit;
1587: end if;
1588: else

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

1581: fetch c_selected_asg_set_range
1582: into ln_set_person_id;
1583: if c_selected_asg_set_range%notfound then
1584: hr_utility.trace('c_selected_asg_set_range not found ');
1585: hr_utility.trace('No Person found for reporting in this chunk');
1586: exit;
1587: end if;
1588: else
1589: fetch c_selected_asg_set into ln_set_person_id;

Line 1591: hr_utility.trace('c_selected_asg_set not found ');

1587: end if;
1588: else
1589: fetch c_selected_asg_set into ln_set_person_id;
1590: if c_selected_asg_set%notfound then
1591: hr_utility.trace('c_selected_asg_set not found ');
1592: hr_utility.trace('No Person found for reporting in this chunk');
1593: exit;
1594: end if;
1595: end if;

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

1588: else
1589: fetch c_selected_asg_set into ln_set_person_id;
1590: if c_selected_asg_set%notfound then
1591: hr_utility.trace('c_selected_asg_set not found ');
1592: hr_utility.trace('No Person found for reporting in this chunk');
1593: exit;
1594: end if;
1595: end if;
1596:

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

1597: action_creation(ln_set_person_id);
1598: end loop;
1599: -- Code modification for bug 10399514 starts here
1600: if l_person_on then
1601: hr_utility.trace('closing c_selected_asg_set_range CURSOR');
1602: close c_selected_asg_set_range;
1603: else
1604: hr_utility.trace('closing c_selected_asg_set CURSOR');
1605: close c_selected_asg_set;

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

1600: if l_person_on then
1601: hr_utility.trace('closing c_selected_asg_set_range CURSOR');
1602: close c_selected_asg_set_range;
1603: else
1604: hr_utility.trace('closing c_selected_asg_set CURSOR');
1605: close c_selected_asg_set;
1606: end if ;
1607: -- Code modification for bug 10399514 ends here
1608:

Line 1611: hr_utility.trace('Entered GRE not null logic');

1607: -- Code modification for bug 10399514 ends here
1608:
1609: elsif ln_tax_unit_id is not null then
1610:
1611: hr_utility.trace('Entered GRE not null logic');
1612: hr_utility.trace('GRE ='||to_char(ln_tax_unit_id));
1613: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1614: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1615:

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

1608:
1609: elsif ln_tax_unit_id is not null then
1610:
1611: hr_utility.trace('Entered GRE not null logic');
1612: hr_utility.trace('GRE ='||to_char(ln_tax_unit_id));
1613: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1614: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1615:
1616: -- Code modification for bug 10399514 start here

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

1609: elsif ln_tax_unit_id is not null then
1610:
1611: hr_utility.trace('Entered GRE not null logic');
1612: hr_utility.trace('GRE ='||to_char(ln_tax_unit_id));
1613: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1614: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1615:
1616: -- Code modification for bug 10399514 start here
1617: if l_person_on then

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

1610:
1611: hr_utility.trace('Entered GRE not null logic');
1612: hr_utility.trace('GRE ='||to_char(ln_tax_unit_id));
1613: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1614: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1615:
1616: -- Code modification for bug 10399514 start here
1617: if l_person_on then
1618: hr_utility.trace('opening c_all_asg_range CURSOR');

Line 1618: hr_utility.trace('opening c_all_asg_range CURSOR');

1614: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1615:
1616: -- Code modification for bug 10399514 start here
1617: if l_person_on then
1618: hr_utility.trace('opening c_all_asg_range CURSOR');
1619: open c_all_asg_range (ln_business_group_id,
1620: ln_tax_unit_id,
1621: ld_end_date,
1622: p_start_person_id,

Line 1630: hr_utility.trace('Opened cusor c_all_asg');

1626: ln_tax_unit_id,
1627: ld_end_date,
1628: p_start_person_id,
1629: p_end_person_id);
1630: hr_utility.trace('Opened cusor c_all_asg');
1631: end if;
1632: -- Code modification for bug 10399514 ends here
1633:
1634: loop

Line 1637: hr_utility.trace('fetching from c_all_asg_range CURSOR');

1633:
1634: loop
1635: -- Code modification for bug 10399514 starts here
1636: if l_person_on then
1637: hr_utility.trace('fetching from c_all_asg_range CURSOR');
1638: fetch c_all_asg_range into ln_set_person_id;
1639: if c_all_asg_range%notfound then
1640: hr_utility.trace('c_all_asg not found ');
1641: hr_utility.trace('No Person found for reporting in this chunk');

Line 1640: hr_utility.trace('c_all_asg not found ');

1636: if l_person_on then
1637: hr_utility.trace('fetching from c_all_asg_range CURSOR');
1638: fetch c_all_asg_range into ln_set_person_id;
1639: if c_all_asg_range%notfound then
1640: hr_utility.trace('c_all_asg not found ');
1641: hr_utility.trace('No Person found for reporting in this chunk');
1642: exit;
1643: end if;
1644: else

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

1637: hr_utility.trace('fetching from c_all_asg_range CURSOR');
1638: fetch c_all_asg_range into ln_set_person_id;
1639: if c_all_asg_range%notfound then
1640: hr_utility.trace('c_all_asg not found ');
1641: hr_utility.trace('No Person found for reporting in this chunk');
1642: exit;
1643: end if;
1644: else
1645: fetch c_all_asg into ln_set_person_id;

Line 1647: hr_utility.trace('c_all_asg not found ');

1643: end if;
1644: else
1645: fetch c_all_asg into ln_set_person_id;
1646: if c_all_asg%notfound then
1647: hr_utility.trace('c_all_asg not found ');
1648: hr_utility.trace('No Person found for reporting in this chunk');
1649: exit;
1650: end if;
1651: end if;

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

1644: else
1645: fetch c_all_asg into ln_set_person_id;
1646: if c_all_asg%notfound then
1647: hr_utility.trace('c_all_asg not found ');
1648: hr_utility.trace('No Person found for reporting in this chunk');
1649: exit;
1650: end if;
1651: end if;
1652: -- Code modification for bug 10399514 ends here

Line 1659: hr_utility.trace('closing c_all_asg_range CURSOR');

1655:
1656: end loop;
1657: -- Code modification for bug 10399514 starts here
1658: if l_person_on then
1659: hr_utility.trace('closing c_all_asg_range CURSOR');
1660: close c_all_asg_range;
1661: else
1662: hr_utility.trace('closing c_all_asg CURSOR');
1663: close c_all_asg;

Line 1662: hr_utility.trace('closing c_all_asg CURSOR');

1658: if l_person_on then
1659: hr_utility.trace('closing c_all_asg_range CURSOR');
1660: close c_all_asg_range;
1661: else
1662: hr_utility.trace('closing c_all_asg CURSOR');
1663: close c_all_asg;
1664: end if ;
1665: -- Code modification for bug 10399514 ends here
1666:

Line 1669: hr_utility.trace('Entered All GRE logic');

1665: -- Code modification for bug 10399514 ends here
1666:
1667: else
1668:
1669: hr_utility.trace('Entered All GRE logic');
1670:
1671: open c_all_gres(ln_business_group_id,
1672: ld_end_date);
1673:

Line 1678: hr_utility.trace('c_all_gres NOT FOUND');

1674: loop -- c_all_gres
1675:
1676: fetch c_all_gres into ln_gre_id;
1677: if c_all_gres%NOTFOUND then
1678: hr_utility.trace('c_all_gres NOT FOUND');
1679: exit;
1680: end if;
1681:
1682: hr_utility.trace('GRE ='||to_char(ln_gre_id));

Line 1682: hr_utility.trace('GRE ='||to_char(ln_gre_id));

1678: hr_utility.trace('c_all_gres NOT FOUND');
1679: exit;
1680: end if;
1681:
1682: hr_utility.trace('GRE ='||to_char(ln_gre_id));
1683: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1684: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1685:
1686: -- Code modification for bug 10399514 start here

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

1679: exit;
1680: end if;
1681:
1682: hr_utility.trace('GRE ='||to_char(ln_gre_id));
1683: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1684: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1685:
1686: -- Code modification for bug 10399514 start here
1687: if l_person_on then

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

1680: end if;
1681:
1682: hr_utility.trace('GRE ='||to_char(ln_gre_id));
1683: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1684: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1685:
1686: -- Code modification for bug 10399514 start here
1687: if l_person_on then
1688: hr_utility.trace('opening c_all_asg_range CURSOR');

Line 1688: hr_utility.trace('opening c_all_asg_range CURSOR');

1684: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1685:
1686: -- Code modification for bug 10399514 start here
1687: if l_person_on then
1688: hr_utility.trace('opening c_all_asg_range CURSOR');
1689: open c_all_asg_range (ln_business_group_id,
1690: ln_gre_id,
1691: ld_end_date,
1692: p_start_person_id,

Line 1700: hr_utility.trace('Opened cusor c_all_asg');

1696: ln_gre_id,
1697: ld_end_date,
1698: p_start_person_id,
1699: p_end_person_id);
1700: hr_utility.trace('Opened cusor c_all_asg');
1701: end if;
1702: -- Code modification for bug 10399514 ends here
1703:
1704: loop -- c_all_asg

Line 1707: hr_utility.trace('fetching from c_all_asg_range CURSOR');

1703:
1704: loop -- c_all_asg
1705: -- Code modification for bug 10399514 starts here
1706: if l_person_on then
1707: hr_utility.trace('fetching from c_all_asg_range CURSOR');
1708: fetch c_all_asg_range into ln_set_person_id;
1709: if c_all_asg_range%notfound then
1710: hr_utility.trace('c_all_asg not found ');
1711: hr_utility.trace('No Person found for reporting in this chunk');

Line 1710: hr_utility.trace('c_all_asg not found ');

1706: if l_person_on then
1707: hr_utility.trace('fetching from c_all_asg_range CURSOR');
1708: fetch c_all_asg_range into ln_set_person_id;
1709: if c_all_asg_range%notfound then
1710: hr_utility.trace('c_all_asg not found ');
1711: hr_utility.trace('No Person found for reporting in this chunk');
1712: exit;
1713: end if;
1714: else

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

1707: hr_utility.trace('fetching from c_all_asg_range CURSOR');
1708: fetch c_all_asg_range into ln_set_person_id;
1709: if c_all_asg_range%notfound then
1710: hr_utility.trace('c_all_asg not found ');
1711: hr_utility.trace('No Person found for reporting in this chunk');
1712: exit;
1713: end if;
1714: else
1715: fetch c_all_asg into ln_set_person_id;

Line 1717: hr_utility.trace('c_all_asg not found ');

1713: end if;
1714: else
1715: fetch c_all_asg into ln_set_person_id;
1716: if c_all_asg%notfound then
1717: hr_utility.trace('c_all_asg not found ');
1718: hr_utility.trace('No Person found for reporting in this chunk');
1719: exit;
1720: end if;
1721: end if;

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

1714: else
1715: fetch c_all_asg into ln_set_person_id;
1716: if c_all_asg%notfound then
1717: hr_utility.trace('c_all_asg not found ');
1718: hr_utility.trace('No Person found for reporting in this chunk');
1719: exit;
1720: end if;
1721: end if;
1722: -- Code modification for bug 10399514 ends here

Line 1730: hr_utility.trace('closing c_all_asg_range CURSOR');

1726:
1727: end loop; -- c_all_asg
1728: -- Code modification for bug 10399514 starts here
1729: if l_person_on then
1730: hr_utility.trace('closing c_all_asg_range CURSOR');
1731: close c_all_asg_range;
1732: else
1733: hr_utility.trace('closing c_all_asg CURSOR');
1734: close c_all_asg;

Line 1733: hr_utility.trace('closing c_all_asg CURSOR');

1729: if l_person_on then
1730: hr_utility.trace('closing c_all_asg_range CURSOR');
1731: close c_all_asg_range;
1732: else
1733: hr_utility.trace('closing c_all_asg CURSOR');
1734: close c_all_asg;
1735: end if ;
1736: -- Code modification for bug 10399514 ends here
1737:

Line 1797: hr_utility.trace('Error in Sort Procedure - getting legislative param');

1793: from pay_payroll_actions ppa
1794: where ppa.payroll_action_id = payactid;
1795:
1796: exception when no_data_found then
1797: hr_utility.trace('Error in Sort Procedure - getting legislative param');
1798: raise;
1799:
1800: end;
1801:

Line 1806: hr_utility.trace('Beginning of the sort_action cursor');

1802: if l_year_end > l_dt then
1803: l_dt := l_year_end;
1804: end if;
1805:
1806: hr_utility.trace('Beginning of the sort_action cursor');
1807:
1808: sqlstr := 'select paa1.rowid
1809: from hr_all_organization_units hou,
1810: hr_all_organization_units hou1,

Line 1856: hr_utility.trace('End of the sort_Action cursor');

1852: ppf.last_name,first_name';
1853:
1854:
1855: len := length(sqlstr); -- return the length of the string.
1856: hr_utility.trace('End of the sort_Action cursor');
1857:
1858: end sort_action;
1859:
1860:

Line 1893: /* hr_utility.trace_on(null,'T4AMEND_REG'); */

1889: return par_value;
1890:
1891: END get_parameter;
1892: Begin
1893: /* hr_utility.trace_on(null,'T4AMEND_REG'); */
1894: null;
1895:
1896:
1897: end pay_ca_eoy_t4_amend_reg;