APPS.PAY_CA_EOY_RL1_AMEND_REG dependencies on HR_UTILITY

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

140: lv_print varchar2(10);
141: lv_report_type varchar2(50);
142:
143: BEGIN
144: hr_utility.trace('Entered get_payroll_action_info');
145: open c_payroll_action_info(p_payroll_action_id);
146: fetch c_payroll_action_info into ln_pre_org_id,
147: ln_person_id,
148: ln_asg_set,

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

152: ln_business_group_id,
153: lv_report_type;
154: close c_payroll_action_info;
155:
156: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
157: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
158: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
159: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
160: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));

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

153: lv_report_type;
154: close c_payroll_action_info;
155:
156: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
157: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
158: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
159: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
160: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
161:

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

154: close c_payroll_action_info;
155:
156: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
157: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
158: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
159: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
160: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
161:
162: p_end_date := ld_end_date;

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

155:
156: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
157: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
158: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
159: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
160: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
161:
162: p_end_date := ld_end_date;
163: p_start_date := ld_start_date;

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

156: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
157: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
158: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
159: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
160: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
161:
162: p_end_date := ld_end_date;
163: p_start_date := ld_start_date;
164: p_business_group_id := ln_business_group_id;

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

167: p_asg_set := ln_asg_set;
168: p_print := lv_print;
169: p_report_type := lv_report_type;
170:
171: hr_utility.trace('Leaving get_payroll_action_info');
172:
173: EXCEPTION
174: when others then
175: hr_utility.trace('Error in ' || gv_procedure_name ||

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

171: hr_utility.trace('Leaving get_payroll_action_info');
172:
173: EXCEPTION
174: when others then
175: hr_utility.trace('Error in ' || gv_procedure_name ||
176: to_char(sqlcode) || '-' || sqlerrm);
177: raise hr_utility.hr_error;
178:
179: END get_payroll_action_info;

Line 177: raise hr_utility.hr_error;

173: EXCEPTION
174: when others then
175: hr_utility.trace('Error in ' || gv_procedure_name ||
176: to_char(sqlcode) || '-' || sqlerrm);
177: raise hr_utility.hr_error;
178:
179: END get_payroll_action_info;
180:
181: -- Added for Bug# 10399514

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

225: lv_report_category varchar2(30);
226: l_print_term varchar2(1) := 'N';
227:
228: BEGIN
229: hr_utility.trace('Entered get_payroll_action_info');
230: open c_payroll_action_info(p_payroll_action_id);
231: fetch c_payroll_action_info into ln_pre_org_id,
232: ln_person_id,
233: ln_asg_set,

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

240: lv_report_category,
241: l_print_term;
242: close c_payroll_action_info;
243:
244: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
245: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
246: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
247: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
248: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));

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

241: l_print_term;
242: close c_payroll_action_info;
243:
244: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
245: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
246: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
247: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
248: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
249: hr_utility.trace('lv_report_qualifier = ' || to_char(lv_report_qualifier));

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

242: close c_payroll_action_info;
243:
244: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
245: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
246: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
247: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
248: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
249: hr_utility.trace('lv_report_qualifier = ' || to_char(lv_report_qualifier));
250: hr_utility.trace('lv_report_category = ' || to_char(lv_report_category));

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

243:
244: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
245: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
246: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
247: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
248: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
249: hr_utility.trace('lv_report_qualifier = ' || to_char(lv_report_qualifier));
250: hr_utility.trace('lv_report_category = ' || to_char(lv_report_category));
251: hr_utility.trace('l_print_term = ' || to_char(l_print_term));

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

244: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
245: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
246: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
247: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
248: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
249: hr_utility.trace('lv_report_qualifier = ' || to_char(lv_report_qualifier));
250: hr_utility.trace('lv_report_category = ' || to_char(lv_report_category));
251: hr_utility.trace('l_print_term = ' || to_char(l_print_term));
252:

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

245: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
246: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
247: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
248: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
249: hr_utility.trace('lv_report_qualifier = ' || to_char(lv_report_qualifier));
250: hr_utility.trace('lv_report_category = ' || to_char(lv_report_category));
251: hr_utility.trace('l_print_term = ' || to_char(l_print_term));
252:
253: p_end_date := ld_end_date;

Line 250: hr_utility.trace('lv_report_category = ' || to_char(lv_report_category));

246: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
247: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
248: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
249: hr_utility.trace('lv_report_qualifier = ' || to_char(lv_report_qualifier));
250: hr_utility.trace('lv_report_category = ' || to_char(lv_report_category));
251: hr_utility.trace('l_print_term = ' || to_char(l_print_term));
252:
253: p_end_date := ld_end_date;
254: p_start_date := ld_start_date;

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

247: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
248: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
249: hr_utility.trace('lv_report_qualifier = ' || to_char(lv_report_qualifier));
250: hr_utility.trace('lv_report_category = ' || to_char(lv_report_category));
251: hr_utility.trace('l_print_term = ' || to_char(l_print_term));
252:
253: p_end_date := ld_end_date;
254: p_start_date := ld_start_date;
255: p_business_group_id := ln_business_group_id;

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

261: p_report_qualifier := lv_report_qualifier;
262: p_report_category := lv_report_category;
263: p_print_term := l_print_term;
264:
265: hr_utility.trace('Leaving get_payroll_action_info');
266:
267: EXCEPTION
268: when others then
269: hr_utility.trace('Error in ' || gv_procedure_name ||

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

265: hr_utility.trace('Leaving get_payroll_action_info');
266:
267: EXCEPTION
268: when others then
269: hr_utility.trace('Error in ' || gv_procedure_name ||
270: to_char(sqlcode) || '-' || sqlerrm);
271: raise hr_utility.hr_error;
272:
273: END get_payroll_action_info;

Line 271: raise hr_utility.hr_error;

267: EXCEPTION
268: when others then
269: hr_utility.trace('Error in ' || gv_procedure_name ||
270: to_char(sqlcode) || '-' || sqlerrm);
271: raise hr_utility.hr_error;
272:
273: END get_payroll_action_info;
274:
275:

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

297: ln_year number;
298: lv_report_type varchar2(50);
299:
300: BEGIN
301: hr_utility.trace('Entered range_cursor');
302: hr_utility.trace('p_payroll_action_id = ' ||
303: to_char(p_payroll_action_id));
304:
305: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id

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

298: lv_report_type varchar2(50);
299:
300: BEGIN
301: hr_utility.trace('Entered range_cursor');
302: hr_utility.trace('p_payroll_action_id = ' ||
303: to_char(p_payroll_action_id));
304:
305: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
306: ,p_start_date => ld_start_date

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

321: from per_assignments_f asg
322: where person_id = ' || ln_person_id ||
323: ' and :payroll_action_id > 0';
324:
325: hr_utility.trace('Range for person_id not null');
326:
327: elsif ln_asg_set is not null then
328:
329: lv_sql_string :=

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

335: and asgset.include_or_exclude = ''I''
336: and :payroll_action_id > 0
337: order by paf.person_id';
338:
339: hr_utility.trace('Range for asg_set not null');
340:
341: elsif ln_pre_org_id is not NULL then
342:
343: lv_sql_string :=

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

376:
377: end if;
378:
379: p_sqlstr := lv_sql_string;
380: hr_utility.trace('p_sqlstr = ' ||p_sqlstr);
381:
382: hr_utility.trace('Leaving range_cursor');
383:
384: END range_cursor;

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

378:
379: p_sqlstr := lv_sql_string;
380: hr_utility.trace('p_sqlstr = ' ||p_sqlstr);
381:
382: hr_utility.trace('Leaving range_cursor');
383:
384: END range_cursor;
385:
386:

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

899: open get_latest_rl1_amend_term(p_person_id
900: ,ln_pre_org_id
901: ,ld_end_date
902: ,ln_business_group_id);
903: hr_utility.trace('lv_print :'||lv_print);
904: else
905: open get_latest_rl1_amend_dtls(p_person_id
906: ,ln_pre_org_id
907: ,ld_end_date

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

905: open get_latest_rl1_amend_dtls(p_person_id
906: ,ln_pre_org_id
907: ,ld_end_date
908: ,ln_business_group_id);
909: hr_utility.trace('lv_print :'||lv_print);
910: end if;
911: loop
912:
913: if nvl(l_print_term,'N') = 'Y' then

Line 937: hr_utility.trace('get_latest_rl1_amend_dtls not found');

933: fetch get_warning_dtls_for_ee into lv_full_name
934: ,lv_employee_number;
935: close get_warning_dtls_for_ee;
936:
937: hr_utility.trace('get_latest_rl1_amend_dtls not found');
938: hr_utility.trace('p_person_id :'||to_char(p_person_id));
939:
940: lv_record_name := 'RL1 Amend Paper Report';
941: lv_message := 'RL1 Amend Preprocess was not run for this employee';

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

934: ,lv_employee_number;
935: close get_warning_dtls_for_ee;
936:
937: hr_utility.trace('get_latest_rl1_amend_dtls not found');
938: hr_utility.trace('p_person_id :'||to_char(p_person_id));
939:
940: lv_record_name := 'RL1 Amend Paper Report';
941: lv_message := 'RL1 Amend Preprocess was not run for this employee';
942:

Line 968: hr_utility.trace('lv_prov_amend_flag : '||lv_prov_amend_flag);

964:
965: lv_prov_amend_flag := 'N';
966: fetch c_get_prov_amend_flag into lv_prov_amend_flag,
967: lv_prov_of_emp;
968: hr_utility.trace('lv_prov_amend_flag : '||lv_prov_amend_flag);
969: hr_utility.trace('lv_prov_of_emp : '||lv_prov_of_emp);
970: exit when c_get_prov_amend_flag%NOTFOUND;
971:
972: if c_get_prov_amend_flag%FOUND then

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

965: lv_prov_amend_flag := 'N';
966: fetch c_get_prov_amend_flag into lv_prov_amend_flag,
967: lv_prov_of_emp;
968: hr_utility.trace('lv_prov_amend_flag : '||lv_prov_amend_flag);
969: hr_utility.trace('lv_prov_of_emp : '||lv_prov_of_emp);
970: exit when c_get_prov_amend_flag%NOTFOUND;
971:
972: if c_get_prov_amend_flag%FOUND then
973:

Line 992: hr_utility.trace('New RL1 Amend Action = ' ||

988: select pay_assignment_actions_s.nextval
989: into ln_rl1_amend_reg_asg_action
990: from dual;
991:
992: hr_utility.trace('New RL1 Amend Action = ' ||
993: to_char(ln_rl1_amend_reg_asg_action));
994:
995:
996: open get_yepp_pact_id(ln_business_group_id,

Line 1003: hr_utility.trace('get_latest_rl1_amend_dtls found ');

999: fetch get_yepp_pact_id into ln_yepp_pact_id;
1000: close get_yepp_pact_id;
1001:
1002: /* Create an assignment action for this person */
1003: hr_utility.trace('get_latest_rl1_amend_dtls found ');
1004: hr_utility.trace('Report Type: '||lv_report_type);
1005:
1006: /* Insert into pay_assignment_actions. */
1007: hr_nonrun_asact.insact(ln_rl1_amend_reg_asg_action

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

1000: close get_yepp_pact_id;
1001:
1002: /* Create an assignment action for this person */
1003: hr_utility.trace('get_latest_rl1_amend_dtls found ');
1004: hr_utility.trace('Report Type: '||lv_report_type);
1005:
1006: /* Insert into pay_assignment_actions. */
1007: hr_nonrun_asact.insact(ln_rl1_amend_reg_asg_action
1008: ,ln_primary_assignment_id

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

1026: update pay_assignment_actions aa
1027: set aa.serial_number = ln_serial_number
1028: where aa.assignment_action_id = ln_rl1_amend_reg_asg_action;
1029:
1030: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));
1031: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
1032: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
1033: --Added to lock the Amend Archiver
1034: hr_nonrun_asact.insint(ln_rl1_amend_reg_asg_action

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

1027: set aa.serial_number = ln_serial_number
1028: where aa.assignment_action_id = ln_rl1_amend_reg_asg_action;
1029:
1030: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));
1031: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
1032: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
1033: --Added to lock the Amend Archiver
1034: hr_nonrun_asact.insint(ln_rl1_amend_reg_asg_action
1035: ,ln_asg_act_to_lock);

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

1028: where aa.assignment_action_id = ln_rl1_amend_reg_asg_action;
1029:
1030: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));
1031: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
1032: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
1033: --Added to lock the Amend Archiver
1034: hr_nonrun_asact.insint(ln_rl1_amend_reg_asg_action
1035: ,ln_asg_act_to_lock);
1036:

Line 1037: hr_utility.trace('Locking Action'||ln_rl1_amend_reg_asg_action);

1033: --Added to lock the Amend Archiver
1034: hr_nonrun_asact.insint(ln_rl1_amend_reg_asg_action
1035: ,ln_asg_act_to_lock);
1036:
1037: hr_utility.trace('Locking Action'||ln_rl1_amend_reg_asg_action);
1038: hr_utility.trace('ln_serial_number :' || ln_serial_number);
1039: hr_utility.trace('Locked Action = ' || to_char(ln_asg_act_to_lock));
1040: end if; --pay_us_employee_payslip_web.get_doc_eit
1041:

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

1034: hr_nonrun_asact.insint(ln_rl1_amend_reg_asg_action
1035: ,ln_asg_act_to_lock);
1036:
1037: hr_utility.trace('Locking Action'||ln_rl1_amend_reg_asg_action);
1038: hr_utility.trace('ln_serial_number :' || ln_serial_number);
1039: hr_utility.trace('Locked Action = ' || to_char(ln_asg_act_to_lock));
1040: end if; --pay_us_employee_payslip_web.get_doc_eit
1041:
1042: end if; -- lv_prov_amend_flag = 'Y'

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

1035: ,ln_asg_act_to_lock);
1036:
1037: hr_utility.trace('Locking Action'||ln_rl1_amend_reg_asg_action);
1038: hr_utility.trace('ln_serial_number :' || ln_serial_number);
1039: hr_utility.trace('Locked Action = ' || to_char(ln_asg_act_to_lock));
1040: end if; --pay_us_employee_payslip_web.get_doc_eit
1041:
1042: end if; -- lv_prov_amend_flag = 'Y'
1043:

Line 1056: hr_utility.trace('l_update_check : '||l_paa_update_check);

1052: --To lock the previous Amendment Paper (Unprinted) or Amendment PDF (Unprinted) respectively
1053:
1054: open c_paa_update_check(ln_rl1_amend_reg_asg_action);
1055: fetch c_paa_update_check into l_paa_update_check;
1056: hr_utility.trace('l_update_check : '||l_paa_update_check);
1057: if c_paa_update_check%FOUND then
1058:
1059: if ln_pre_parameter is NULL then
1060: ln_pre_org_id := '';

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

1068: ln_serial_number := lv_prov_of_emp||
1069: lpad(to_char(ln_asg_act_to_lock),14,0)||
1070: lpad(to_char(ln_yepp_pact_id),14,0);
1071:
1072: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));
1073: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
1074: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
1075: --Added to lock the Amend Archiver
1076: hr_nonrun_asact.insint(ln_rl1_amend_reg_asg_action

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

1069: lpad(to_char(ln_asg_act_to_lock),14,0)||
1070: lpad(to_char(ln_yepp_pact_id),14,0);
1071:
1072: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));
1073: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
1074: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
1075: --Added to lock the Amend Archiver
1076: hr_nonrun_asact.insint(ln_rl1_amend_reg_asg_action
1077: ,ln_asg_act_to_lock);

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

1070: lpad(to_char(ln_yepp_pact_id),14,0);
1071:
1072: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));
1073: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
1074: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
1075: --Added to lock the Amend Archiver
1076: hr_nonrun_asact.insint(ln_rl1_amend_reg_asg_action
1077: ,ln_asg_act_to_lock);
1078:

Line 1079: hr_utility.trace('Locking Action'||ln_rl1_amend_reg_asg_action);

1075: --Added to lock the Amend Archiver
1076: hr_nonrun_asact.insint(ln_rl1_amend_reg_asg_action
1077: ,ln_asg_act_to_lock);
1078:
1079: hr_utility.trace('Locking Action'||ln_rl1_amend_reg_asg_action);
1080: hr_utility.trace('ln_serial_number :' || ln_serial_number);
1081: hr_utility.trace('Locked Action = ' || to_char(ln_asg_act_to_lock));
1082:
1083: end if; -- c_paa_update_check%FOUND

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

1076: hr_nonrun_asact.insint(ln_rl1_amend_reg_asg_action
1077: ,ln_asg_act_to_lock);
1078:
1079: hr_utility.trace('Locking Action'||ln_rl1_amend_reg_asg_action);
1080: hr_utility.trace('ln_serial_number :' || ln_serial_number);
1081: hr_utility.trace('Locked Action = ' || to_char(ln_asg_act_to_lock));
1082:
1083: end if; -- c_paa_update_check%FOUND
1084: close c_paa_update_check;

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

1077: ,ln_asg_act_to_lock);
1078:
1079: hr_utility.trace('Locking Action'||ln_rl1_amend_reg_asg_action);
1080: hr_utility.trace('ln_serial_number :' || ln_serial_number);
1081: hr_utility.trace('Locked Action = ' || to_char(ln_asg_act_to_lock));
1082:
1083: end if; -- c_paa_update_check%FOUND
1084: close c_paa_update_check;
1085:

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

1101: open get_all_rl1_amend_dtls(p_person_id
1102: ,ln_pre_org_id
1103: ,ld_end_date
1104: ,ln_business_group_id);
1105: hr_utility.trace('lv_print :'||lv_print);
1106: loop
1107:
1108: fetch get_all_rl1_amend_dtls into lv_report_type
1109: ,ln_primary_assignment_id

Line 1122: hr_utility.trace('get_all_rl1_amend_dtls not found');

1118: fetch get_warning_dtls_for_ee into lv_full_name
1119: ,lv_employee_number;
1120: close get_warning_dtls_for_ee;
1121:
1122: hr_utility.trace('get_all_rl1_amend_dtls not found');
1123: hr_utility.trace('p_person_id :'||to_char(p_person_id));
1124:
1125: lv_record_name := 'RL1 Amend Register Report';
1126: lv_message := 'RL1 Amend Preprocess was not run for this employee';

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

1119: ,lv_employee_number;
1120: close get_warning_dtls_for_ee;
1121:
1122: hr_utility.trace('get_all_rl1_amend_dtls not found');
1123: hr_utility.trace('p_person_id :'||to_char(p_person_id));
1124:
1125: lv_record_name := 'RL1 Amend Register Report';
1126: lv_message := 'RL1 Amend Preprocess was not run for this employee';
1127:

Line 1152: hr_utility.trace('lv_prov_amend_flag : '||lv_prov_amend_flag);

1148:
1149: lv_prov_amend_flag := 'N';
1150: fetch c_get_prov_amend_flag into lv_prov_amend_flag,
1151: lv_prov_of_emp;
1152: hr_utility.trace('lv_prov_amend_flag : '||lv_prov_amend_flag);
1153: hr_utility.trace('lv_prov_of_emp : '||lv_prov_of_emp);
1154: exit when c_get_prov_amend_flag%NOTFOUND;
1155:
1156: if c_get_prov_amend_flag%FOUND then

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

1149: lv_prov_amend_flag := 'N';
1150: fetch c_get_prov_amend_flag into lv_prov_amend_flag,
1151: lv_prov_of_emp;
1152: hr_utility.trace('lv_prov_amend_flag : '||lv_prov_amend_flag);
1153: hr_utility.trace('lv_prov_of_emp : '||lv_prov_of_emp);
1154: exit when c_get_prov_amend_flag%NOTFOUND;
1155:
1156: if c_get_prov_amend_flag%FOUND then
1157:

Line 1171: hr_utility.trace('get_recent_rl1_amend_dtls found ');

1167: fetch get_yepp_pact_id into ln_yepp_pact_id;
1168: close get_yepp_pact_id;
1169:
1170: /* Create an assignment action for this person */
1171: hr_utility.trace('get_recent_rl1_amend_dtls found ');
1172: hr_utility.trace('Report Type: '||lv_report_type);
1173:
1174: select pay_assignment_actions_s.nextval
1175: into ln_rl1_amend_reg_asg_action

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

1168: close get_yepp_pact_id;
1169:
1170: /* Create an assignment action for this person */
1171: hr_utility.trace('get_recent_rl1_amend_dtls found ');
1172: hr_utility.trace('Report Type: '||lv_report_type);
1173:
1174: select pay_assignment_actions_s.nextval
1175: into ln_rl1_amend_reg_asg_action
1176: from dual;

Line 1178: hr_utility.trace('New RL1 Amend Action = ' ||

1174: select pay_assignment_actions_s.nextval
1175: into ln_rl1_amend_reg_asg_action
1176: from dual;
1177:
1178: hr_utility.trace('New RL1 Amend Action = ' ||
1179: to_char(ln_rl1_amend_reg_asg_action));
1180:
1181: /* Insert into pay_assignment_actions. */
1182: hr_nonrun_asact.insact(ln_rl1_amend_reg_asg_action

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

1196: update pay_assignment_actions aa
1197: set aa.serial_number = ln_serial_number
1198: where aa.assignment_action_id = ln_rl1_amend_reg_asg_action;
1199:
1200: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));
1201: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
1202: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
1203:
1204: end if; -- lv_prov_amend_flag = 'Y'

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

1197: set aa.serial_number = ln_serial_number
1198: where aa.assignment_action_id = ln_rl1_amend_reg_asg_action;
1199:
1200: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));
1201: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
1202: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
1203:
1204: end if; -- lv_prov_amend_flag = 'Y'
1205:

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

1198: where aa.assignment_action_id = ln_rl1_amend_reg_asg_action;
1199:
1200: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));
1201: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
1202: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
1203:
1204: end if; -- lv_prov_amend_flag = 'Y'
1205:
1206: end if; -- c_get_prov_amend_flag%FOUND

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

1230: ln_primary_assignment_id := 0;
1231: ln_asg_act_to_lock := 0;
1232: ln_pre_id_null := 0;
1233:
1234: hr_utility.trace('lv_print :'||lv_print);
1235:
1236: loop
1237:
1238: fetch get_all_rl1_amend_dtls into lv_report_type

Line 1244: hr_utility.trace('get_all_rl1_amend_dtls not found ');

1240: ,ln_asg_act_to_lock
1241: ,ln_pre_id_null;
1242:
1243: if get_all_rl1_amend_dtls%notfound then
1244: hr_utility.trace('get_all_rl1_amend_dtls not found ');
1245: exit;
1246: end if;
1247:
1248: open c_get_prov_amend_flag(ln_asg_act_to_lock,

Line 1256: hr_utility.trace('lv_prov_amend_flag : '||lv_prov_amend_flag);

1252:
1253: lv_prov_amend_flag := 'N';
1254: fetch c_get_prov_amend_flag into lv_prov_amend_flag,
1255: lv_prov_of_emp;
1256: hr_utility.trace('lv_prov_amend_flag : '||lv_prov_amend_flag);
1257: hr_utility.trace('lv_prov_of_emp : '||lv_prov_of_emp);
1258: exit when c_get_prov_amend_flag%NOTFOUND;
1259:
1260: if c_get_prov_amend_flag%FOUND then

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

1253: lv_prov_amend_flag := 'N';
1254: fetch c_get_prov_amend_flag into lv_prov_amend_flag,
1255: lv_prov_of_emp;
1256: hr_utility.trace('lv_prov_amend_flag : '||lv_prov_amend_flag);
1257: hr_utility.trace('lv_prov_of_emp : '||lv_prov_of_emp);
1258: exit when c_get_prov_amend_flag%NOTFOUND;
1259:
1260: if c_get_prov_amend_flag%FOUND then
1261:

Line 1274: hr_utility.trace('get_all_rl1_amend_dtls found ');

1270: ld_end_date);
1271: fetch get_yepp_pact_id into ln_yepp_pact_id;
1272: close get_yepp_pact_id;
1273:
1274: hr_utility.trace('get_all_rl1_amend_dtls found ');
1275: hr_utility.trace('Report Type: '||lv_report_type);
1276:
1277: /* Create an assignment action for this person */
1278:

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

1271: fetch get_yepp_pact_id into ln_yepp_pact_id;
1272: close get_yepp_pact_id;
1273:
1274: hr_utility.trace('get_all_rl1_amend_dtls found ');
1275: hr_utility.trace('Report Type: '||lv_report_type);
1276:
1277: /* Create an assignment action for this person */
1278:
1279: select pay_assignment_actions_s.nextval

Line 1282: hr_utility.trace('New RL1 Amend Action = ' || ln_rl1_amend_reg_asg_action);

1278:
1279: select pay_assignment_actions_s.nextval
1280: into ln_rl1_amend_reg_asg_action
1281: from dual;
1282: hr_utility.trace('New RL1 Amend Action = ' || ln_rl1_amend_reg_asg_action);
1283:
1284: /* Insert into pay_assignment_actions. */
1285: hr_nonrun_asact.insact(ln_rl1_amend_reg_asg_action
1286: ,ln_primary_assignment_id

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

1293: end if;
1294: ln_serial_number := lv_prov_of_emp||
1295: lpad(to_char(ln_asg_act_to_lock),14,0)||
1296: lpad(to_char(ln_yepp_pact_id),14,0);
1297: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));
1298: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
1299: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
1300:
1301: update pay_assignment_actions aa

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

1294: ln_serial_number := lv_prov_of_emp||
1295: lpad(to_char(ln_asg_act_to_lock),14,0)||
1296: lpad(to_char(ln_yepp_pact_id),14,0);
1297: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));
1298: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
1299: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
1300:
1301: update pay_assignment_actions aa
1302: set aa.serial_number = ln_serial_number

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

1295: lpad(to_char(ln_asg_act_to_lock),14,0)||
1296: lpad(to_char(ln_yepp_pact_id),14,0);
1297: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));
1298: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
1299: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
1300:
1301: update pay_assignment_actions aa
1302: set aa.serial_number = ln_serial_number
1303: where aa.assignment_action_id = ln_rl1_amend_reg_asg_action;

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

1330: ln_primary_assignment_id := 0;
1331: ln_asg_act_to_lock := 0;
1332: ln_pre_id_null := 0;
1333:
1334: hr_utility.trace('lv_print :'||lv_print);
1335:
1336: loop
1337:
1338: if nvl(l_print_term,'N') = 'Y' then

Line 1346: hr_utility.trace('get_reprint_rl1_amend_term not found ');

1342: ,ln_pre_id_null
1343: ,l_effective_end_date;
1344:
1345: if get_reprint_rl1_amend_term%notfound then
1346: hr_utility.trace('get_reprint_rl1_amend_term not found ');
1347: exit;
1348: end if;
1349: else
1350: fetch get_reprint_rl1_amend_dtls into lv_report_type

Line 1357: hr_utility.trace('get_reprint_rl1_amend_dtls not found ');

1353: ,ln_pre_id_null
1354: ,l_effective_end_date;
1355:
1356: if get_reprint_rl1_amend_dtls%notfound then
1357: hr_utility.trace('get_reprint_rl1_amend_dtls not found ');
1358: exit;
1359: end if;
1360: end if;
1361:

Line 1370: hr_utility.trace('lv_prov_amend_flag : '||lv_prov_amend_flag);

1366:
1367: lv_prov_amend_flag := 'N';
1368: fetch c_get_prov_amend_flag into lv_prov_amend_flag,
1369: lv_prov_of_emp;
1370: hr_utility.trace('lv_prov_amend_flag : '||lv_prov_amend_flag);
1371: hr_utility.trace('lv_prov_of_emp : '||lv_prov_of_emp);
1372: exit when c_get_prov_amend_flag%NOTFOUND;
1373:
1374: if c_get_prov_amend_flag%FOUND then

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

1367: lv_prov_amend_flag := 'N';
1368: fetch c_get_prov_amend_flag into lv_prov_amend_flag,
1369: lv_prov_of_emp;
1370: hr_utility.trace('lv_prov_amend_flag : '||lv_prov_amend_flag);
1371: hr_utility.trace('lv_prov_of_emp : '||lv_prov_of_emp);
1372: exit when c_get_prov_amend_flag%NOTFOUND;
1373:
1374: if c_get_prov_amend_flag%FOUND then
1375:

Line 1388: hr_utility.trace('get_reprint_rl1_amend_dtls found ');

1384: ld_end_date);
1385: fetch get_yepp_pact_id into ln_yepp_pact_id;
1386: close get_yepp_pact_id;
1387:
1388: hr_utility.trace('get_reprint_rl1_amend_dtls found ');
1389: hr_utility.trace('Report Type: '||lv_report_type);
1390:
1391: if nvl(pay_us_employee_payslip_web.get_doc_eit('RL1PDF',
1392: 'PRINT',

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

1385: fetch get_yepp_pact_id into ln_yepp_pact_id;
1386: close get_yepp_pact_id;
1387:
1388: hr_utility.trace('get_reprint_rl1_amend_dtls found ');
1389: hr_utility.trace('Report Type: '||lv_report_type);
1390:
1391: if nvl(pay_us_employee_payslip_web.get_doc_eit('RL1PDF',
1392: 'PRINT',
1393: 'ASSIGNMENT',

Line 1401: hr_utility.trace('New RL1 Amend Action = ' || ln_rl1_amend_reg_asg_action);

1397:
1398: select pay_assignment_actions_s.nextval
1399: into ln_rl1_amend_reg_asg_action
1400: from dual;
1401: hr_utility.trace('New RL1 Amend Action = ' || ln_rl1_amend_reg_asg_action);
1402:
1403: /* Insert into pay_assignment_actions. */
1404: hr_nonrun_asact.insact(ln_rl1_amend_reg_asg_action
1405: ,ln_primary_assignment_id

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

1413:
1414: ln_serial_number := lv_prov_of_emp||
1415: lpad(to_char(ln_asg_act_to_lock),14,0)||
1416: lpad(to_char(ln_yepp_pact_id),14,0);
1417: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));
1418: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
1419: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
1420:
1421: update pay_assignment_actions aa

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

1414: ln_serial_number := lv_prov_of_emp||
1415: lpad(to_char(ln_asg_act_to_lock),14,0)||
1416: lpad(to_char(ln_yepp_pact_id),14,0);
1417: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));
1418: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
1419: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
1420:
1421: update pay_assignment_actions aa
1422: set aa.serial_number = ln_serial_number

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

1415: lpad(to_char(ln_asg_act_to_lock),14,0)||
1416: lpad(to_char(ln_yepp_pact_id),14,0);
1417: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));
1418: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
1419: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
1420:
1421: update pay_assignment_actions aa
1422: set aa.serial_number = ln_serial_number
1423: where aa.assignment_action_id = ln_rl1_amend_reg_asg_action;

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

1442:
1443: END action_creation;
1444:
1445: BEGIN
1446: hr_utility.trace('Entered action_creation ');
1447: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
1448: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
1449: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
1450: hr_utility.trace('p_chunk = ' || to_char(p_chunk));

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

1443: END action_creation;
1444:
1445: BEGIN
1446: hr_utility.trace('Entered action_creation ');
1447: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
1448: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
1449: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
1450: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
1451:

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

1444:
1445: BEGIN
1446: hr_utility.trace('Entered action_creation ');
1447: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
1448: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
1449: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
1450: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
1451:
1452: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id

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

1445: BEGIN
1446: hr_utility.trace('Entered action_creation ');
1447: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
1448: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
1449: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
1450: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
1451:
1452: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
1453: ,p_start_date => ld_start_date

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

1446: hr_utility.trace('Entered action_creation ');
1447: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
1448: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
1449: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
1450: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
1451:
1452: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
1453: ,p_start_date => ld_start_date
1454: ,p_end_date => ld_end_date

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

1461: ,p_report_qualifier => l_state
1462: ,p_report_category => l_report_cat
1463: ,p_print_term => l_print_term);
1464:
1465: hr_utility.trace('lv_ppr_report_type: '||lv_ppr_report_type);
1466:
1467: ln_pre_org_id := ln_pre_parameter;
1468: -- Code modification for bug 10399514 starts here
1469: /* Initializing variable */

Line 1483: hr_utility.trace('l_report_format: '||l_report_format);

1479: Exception
1480: When Others Then
1481: l_report_format := Null ;
1482: End ;
1483: hr_utility.trace('l_report_format: '||l_report_format);
1484: hr_utility.trace('lv_ppr_report_type: '||lv_ppr_report_type);
1485: hr_utility.trace('l_state '||l_state);
1486: hr_utility.trace('l_report_cat: '||l_report_cat);
1487: l_person_on := pay_ac_utility.range_person_on( p_report_type => lv_ppr_report_type,

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

1480: When Others Then
1481: l_report_format := Null ;
1482: End ;
1483: hr_utility.trace('l_report_format: '||l_report_format);
1484: hr_utility.trace('lv_ppr_report_type: '||lv_ppr_report_type);
1485: hr_utility.trace('l_state '||l_state);
1486: hr_utility.trace('l_report_cat: '||l_report_cat);
1487: l_person_on := pay_ac_utility.range_person_on( p_report_type => lv_ppr_report_type,
1488: p_report_format => l_report_format,

Line 1485: hr_utility.trace('l_state '||l_state);

1481: l_report_format := Null ;
1482: End ;
1483: hr_utility.trace('l_report_format: '||l_report_format);
1484: hr_utility.trace('lv_ppr_report_type: '||lv_ppr_report_type);
1485: hr_utility.trace('l_state '||l_state);
1486: hr_utility.trace('l_report_cat: '||l_report_cat);
1487: l_person_on := pay_ac_utility.range_person_on( p_report_type => lv_ppr_report_type,
1488: p_report_format => l_report_format,
1489: p_report_qualifier => l_state,

Line 1486: hr_utility.trace('l_report_cat: '||l_report_cat);

1482: End ;
1483: hr_utility.trace('l_report_format: '||l_report_format);
1484: hr_utility.trace('lv_ppr_report_type: '||lv_ppr_report_type);
1485: hr_utility.trace('l_state '||l_state);
1486: hr_utility.trace('l_report_cat: '||l_report_cat);
1487: l_person_on := pay_ac_utility.range_person_on( p_report_type => lv_ppr_report_type,
1488: p_report_format => l_report_format,
1489: p_report_qualifier => l_state,
1490: p_report_category => l_report_cat) ;

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

1494: action_creation(p_start_person_id);
1495:
1496: elsif ln_asg_set is not null then
1497:
1498: hr_utility.trace('Entered Asg Set logic');
1499: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
1500: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1501: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1502:

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

1495:
1496: elsif ln_asg_set is not null then
1497:
1498: hr_utility.trace('Entered Asg Set logic');
1499: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
1500: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1501: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1502:
1503: if l_person_on then

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

1496: elsif ln_asg_set is not null then
1497:
1498: hr_utility.trace('Entered Asg Set logic');
1499: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
1500: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1501: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1502:
1503: if l_person_on then
1504: open c_selected_asg_set_range(p_start_person_id

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

1497:
1498: hr_utility.trace('Entered Asg Set logic');
1499: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
1500: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1501: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1502:
1503: if l_person_on then
1504: open c_selected_asg_set_range(p_start_person_id
1505: ,p_end_person_id

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

1504: open c_selected_asg_set_range(p_start_person_id
1505: ,p_end_person_id
1506: ,ln_asg_set
1507: ,ld_end_date);
1508: hr_utility.trace('Opened cusor c_selected_asg_set_range');
1509: else
1510: open c_selected_asg_set (p_start_person_id
1511: ,p_end_person_id
1512: ,ln_asg_set

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

1510: open c_selected_asg_set (p_start_person_id
1511: ,p_end_person_id
1512: ,ln_asg_set
1513: ,ld_end_date);
1514: hr_utility.trace('Opened cusor c_selected_asg_set');
1515: end if;
1516: loop
1517: if l_person_on then
1518: fetch c_selected_asg_set_range into ln_set_person_id;

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

1516: loop
1517: if l_person_on then
1518: fetch c_selected_asg_set_range into ln_set_person_id;
1519: if c_selected_asg_set_range%notfound then
1520: hr_utility.trace('c_selected_asg_set_range not found ');
1521: hr_utility.trace('No Person found for reporting in this chunk');
1522: exit;
1523: end if;
1524: else

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

1517: if l_person_on then
1518: fetch c_selected_asg_set_range into ln_set_person_id;
1519: if c_selected_asg_set_range%notfound then
1520: hr_utility.trace('c_selected_asg_set_range not found ');
1521: hr_utility.trace('No Person found for reporting in this chunk');
1522: exit;
1523: end if;
1524: else
1525: fetch c_selected_asg_set into ln_set_person_id;

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

1523: end if;
1524: else
1525: fetch c_selected_asg_set into ln_set_person_id;
1526: if c_selected_asg_set%notfound then
1527: hr_utility.trace('c_selected_asg_set not found ');
1528: hr_utility.trace('No Person found for reporting in this chunk');
1529: exit;
1530: end if;
1531: end if; -- l_person_on

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

1524: else
1525: fetch c_selected_asg_set into ln_set_person_id;
1526: if c_selected_asg_set%notfound then
1527: hr_utility.trace('c_selected_asg_set not found ');
1528: hr_utility.trace('No Person found for reporting in this chunk');
1529: exit;
1530: end if;
1531: end if; -- l_person_on
1532:

Line 1543: hr_utility.trace('Entered PRE not null logic');

1539: end if;
1540:
1541: elsif ln_pre_org_id is not null then
1542:
1543: hr_utility.trace('Entered PRE not null logic');
1544: hr_utility.trace('PRE Organization Id ='||to_char(ln_pre_org_id));
1545: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1546: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1547:

Line 1544: hr_utility.trace('PRE Organization Id ='||to_char(ln_pre_org_id));

1540:
1541: elsif ln_pre_org_id is not null then
1542:
1543: hr_utility.trace('Entered PRE not null logic');
1544: hr_utility.trace('PRE Organization Id ='||to_char(ln_pre_org_id));
1545: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1546: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1547:
1548: if l_person_on then

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

1541: elsif ln_pre_org_id is not null then
1542:
1543: hr_utility.trace('Entered PRE not null logic');
1544: hr_utility.trace('PRE Organization Id ='||to_char(ln_pre_org_id));
1545: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1546: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1547:
1548: if l_person_on then
1549: open c_all_asg_range(ln_business_group_id,

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

1542:
1543: hr_utility.trace('Entered PRE not null logic');
1544: hr_utility.trace('PRE Organization Id ='||to_char(ln_pre_org_id));
1545: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1546: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1547:
1548: if l_person_on then
1549: open c_all_asg_range(ln_business_group_id,
1550: ln_pre_org_id,

Line 1554: hr_utility.trace('Opened cusor c_all_asg_range');

1550: ln_pre_org_id,
1551: ld_end_date,
1552: p_start_person_id,
1553: p_end_person_id);
1554: hr_utility.trace('Opened cusor c_all_asg_range');
1555: else
1556: open c_all_asg (ln_business_group_id,
1557: ln_pre_org_id,
1558: ld_end_date,

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

1557: ln_pre_org_id,
1558: ld_end_date,
1559: p_start_person_id,
1560: p_end_person_id);
1561: hr_utility.trace('Opened cusor c_all_asg');
1562: end if;
1563: loop
1564: if l_person_on then
1565: fetch c_all_asg_range into ln_set_person_id;

Line 1567: hr_utility.trace('c_all_asg_range not found ');

1563: loop
1564: if l_person_on then
1565: fetch c_all_asg_range into ln_set_person_id;
1566: if c_all_asg_range%notfound then
1567: hr_utility.trace('c_all_asg_range not found ');
1568: hr_utility.trace('No Person found for reporting in this chunk');
1569: exit;
1570: end if;
1571: else

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

1564: if l_person_on then
1565: fetch c_all_asg_range into ln_set_person_id;
1566: if c_all_asg_range%notfound then
1567: hr_utility.trace('c_all_asg_range not found ');
1568: hr_utility.trace('No Person found for reporting in this chunk');
1569: exit;
1570: end if;
1571: else
1572: fetch c_all_asg into ln_set_person_id;

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

1570: end if;
1571: else
1572: fetch c_all_asg into ln_set_person_id;
1573: if c_all_asg%notfound then
1574: hr_utility.trace('c_all_asg not found ');
1575: hr_utility.trace('No Person found for reporting in this chunk');
1576: exit;
1577: end if;
1578: end if;--l_person_on

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

1571: else
1572: fetch c_all_asg into ln_set_person_id;
1573: if c_all_asg%notfound then
1574: hr_utility.trace('c_all_asg not found ');
1575: hr_utility.trace('No Person found for reporting in this chunk');
1576: exit;
1577: end if;
1578: end if;--l_person_on
1579:

Line 1590: hr_utility.trace('Entered All PRE logic');

1586: end if;
1587:
1588: else
1589:
1590: hr_utility.trace('Entered All PRE logic');
1591:
1592: open c_all_pres(ln_business_group_id,
1593: ld_end_date);
1594:

Line 1600: hr_utility.trace('c_all_pres NOT FOUND');

1596:
1597: fetch c_all_pres into ln_pre_id;
1598:
1599: if c_all_pres%NOTFOUND then
1600: hr_utility.trace('c_all_pres NOT FOUND');
1601: exit;
1602: end if;
1603:
1604: hr_utility.trace('PRE ='||to_char(ln_pre_id));

Line 1604: hr_utility.trace('PRE ='||to_char(ln_pre_id));

1600: hr_utility.trace('c_all_pres NOT FOUND');
1601: exit;
1602: end if;
1603:
1604: hr_utility.trace('PRE ='||to_char(ln_pre_id));
1605: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1606: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1607:
1608: if l_person_on then

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

1601: exit;
1602: end if;
1603:
1604: hr_utility.trace('PRE ='||to_char(ln_pre_id));
1605: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1606: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1607:
1608: if l_person_on then
1609: open c_all_asg_range(ln_business_group_id,

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

1602: end if;
1603:
1604: hr_utility.trace('PRE ='||to_char(ln_pre_id));
1605: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1606: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1607:
1608: if l_person_on then
1609: open c_all_asg_range(ln_business_group_id,
1610: ln_pre_id,

Line 1614: hr_utility.trace('Opened cusor c_all_asg_range');

1610: ln_pre_id,
1611: ld_end_date,
1612: p_start_person_id,
1613: p_end_person_id);
1614: hr_utility.trace('Opened cusor c_all_asg_range');
1615: else
1616: open c_all_asg (ln_business_group_id,
1617: ln_pre_id,
1618: ld_end_date,

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

1617: ln_pre_id,
1618: ld_end_date,
1619: p_start_person_id,
1620: p_end_person_id);
1621: hr_utility.trace('Opened cusor c_all_asg');
1622: end if;
1623:
1624: loop -- c_all_asg
1625: if l_person_on then

Line 1628: hr_utility.trace('c_all_asg_range not found ');

1624: loop -- c_all_asg
1625: if l_person_on then
1626: fetch c_all_asg_range into ln_set_person_id;
1627: if c_all_asg_range%notfound then
1628: hr_utility.trace('c_all_asg_range not found ');
1629: hr_utility.trace('No Person found for reporting in this chunk');
1630: exit;
1631: end if;
1632: else

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

1625: if l_person_on then
1626: fetch c_all_asg_range into ln_set_person_id;
1627: if c_all_asg_range%notfound then
1628: hr_utility.trace('c_all_asg_range not found ');
1629: hr_utility.trace('No Person found for reporting in this chunk');
1630: exit;
1631: end if;
1632: else
1633: fetch c_all_asg into ln_set_person_id;

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

1631: end if;
1632: else
1633: fetch c_all_asg into ln_set_person_id;
1634: if c_all_asg%notfound then
1635: hr_utility.trace('c_all_asg not found ');
1636: hr_utility.trace('No Person found for reporting in this chunk');
1637: exit;
1638: end if;
1639: end if;--l_person_on

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

1632: else
1633: fetch c_all_asg into ln_set_person_id;
1634: if c_all_asg%notfound then
1635: hr_utility.trace('c_all_asg not found ');
1636: hr_utility.trace('No Person found for reporting in this chunk');
1637: exit;
1638: end if;
1639: end if;--l_person_on
1640:

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

1665: ) is
1666:
1667: begin
1668:
1669: hr_utility.trace('Beginning of the sort_action cursor');
1670:
1671: sqlstr := 'select paa1.rowid /* we need the row id of the assignment actions that are created by PYUGEN */
1672: from hr_all_organization_units hou1,
1673: hr_all_organization_units hou,

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

1708: ,ppf.last_name,ppf.first_name';
1709:
1710:
1711: len := length(sqlstr); -- return the length of the string.
1712: hr_utility.trace('End of the sort_Action cursor');
1713:
1714: end sort_action;
1715:
1716:

Line 1749: /* hr_utility.trace_on(null,'RL1AMEND_REG'); */

1745: return par_value;
1746:
1747: END get_parameter;
1748: Begin
1749: /* hr_utility.trace_on(null,'RL1AMEND_REG'); */
1750: null;
1751:
1752:
1753: end pay_ca_eoy_rl1_amend_reg;