APPS.PAY_CA_EOY_RL2_AMEND_REG dependencies on HR_UTILITY

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

124: lv_print varchar2(10);
125: lv_report_type varchar2(50);
126:
127: BEGIN
128: hr_utility.trace('Entered get_payroll_action_info');
129: open c_payroll_action_info(p_payroll_action_id);
130: fetch c_payroll_action_info into ln_pre_org_id,
131: ln_person_id,
132: ln_asg_set,

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

136: ln_business_group_id,
137: lv_report_type;
138: close c_payroll_action_info;
139:
140: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
141: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
142: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
143: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
144: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));

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

137: lv_report_type;
138: close c_payroll_action_info;
139:
140: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
141: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
142: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
143: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
144: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
145:

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

138: close c_payroll_action_info;
139:
140: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
141: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
142: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
143: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
144: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
145:
146: p_end_date := ld_end_date;

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

139:
140: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
141: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
142: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
143: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
144: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
145:
146: p_end_date := ld_end_date;
147: p_start_date := ld_start_date;

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

140: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
141: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
142: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
143: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
144: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
145:
146: p_end_date := ld_end_date;
147: p_start_date := ld_start_date;
148: p_business_group_id := ln_business_group_id;

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

151: p_asg_set := ln_asg_set;
152: p_print := lv_print;
153: p_report_type := lv_report_type;
154:
155: hr_utility.trace('Leaving get_payroll_action_info');
156:
157: EXCEPTION
158: when others then
159: hr_utility.trace('Error in ' || gv_procedure_name ||

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

155: hr_utility.trace('Leaving get_payroll_action_info');
156:
157: EXCEPTION
158: when others then
159: hr_utility.trace('Error in ' || gv_procedure_name ||
160: to_char(sqlcode) || '-' || sqlerrm);
161: raise hr_utility.hr_error;
162:
163: END get_payroll_action_info;

Line 161: raise hr_utility.hr_error;

157: EXCEPTION
158: when others then
159: hr_utility.trace('Error in ' || gv_procedure_name ||
160: to_char(sqlcode) || '-' || sqlerrm);
161: raise hr_utility.hr_error;
162:
163: END get_payroll_action_info;
164:
165: -- Added for Bug# 10399514

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

209: lv_report_category varchar2(30);
210: l_print_term varchar2(1) := 'N';
211:
212: BEGIN
213: hr_utility.trace('Entered get_payroll_action_info');
214: open c_payroll_action_info(p_payroll_action_id);
215: fetch c_payroll_action_info into ln_pre_org_id,
216: ln_person_id,
217: ln_asg_set,

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

224: lv_report_category,
225: l_print_term;
226: close c_payroll_action_info;
227:
228: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
229: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
230: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
231: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
232: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));

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

225: l_print_term;
226: close c_payroll_action_info;
227:
228: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
229: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
230: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
231: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
232: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
233: hr_utility.trace('lv_report_qualifier = ' || to_char(lv_report_qualifier));

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

226: close c_payroll_action_info;
227:
228: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
229: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
230: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
231: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
232: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
233: hr_utility.trace('lv_report_qualifier = ' || to_char(lv_report_qualifier));
234: hr_utility.trace('lv_report_category = ' || to_char(lv_report_category));

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

227:
228: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
229: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
230: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
231: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
232: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
233: hr_utility.trace('lv_report_qualifier = ' || to_char(lv_report_qualifier));
234: hr_utility.trace('lv_report_category = ' || to_char(lv_report_category));
235: hr_utility.trace('l_print_term = ' || to_char(l_print_term));

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

228: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
229: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
230: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
231: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
232: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
233: hr_utility.trace('lv_report_qualifier = ' || to_char(lv_report_qualifier));
234: hr_utility.trace('lv_report_category = ' || to_char(lv_report_category));
235: hr_utility.trace('l_print_term = ' || to_char(l_print_term));
236:

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

229: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
230: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
231: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
232: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
233: hr_utility.trace('lv_report_qualifier = ' || to_char(lv_report_qualifier));
234: hr_utility.trace('lv_report_category = ' || to_char(lv_report_category));
235: hr_utility.trace('l_print_term = ' || to_char(l_print_term));
236:
237: p_end_date := ld_end_date;

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

230: hr_utility.trace('ln_pre_org_id = ' || to_char(ln_pre_org_id));
231: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
232: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
233: hr_utility.trace('lv_report_qualifier = ' || to_char(lv_report_qualifier));
234: hr_utility.trace('lv_report_category = ' || to_char(lv_report_category));
235: hr_utility.trace('l_print_term = ' || to_char(l_print_term));
236:
237: p_end_date := ld_end_date;
238: p_start_date := ld_start_date;

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

231: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
232: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
233: hr_utility.trace('lv_report_qualifier = ' || to_char(lv_report_qualifier));
234: hr_utility.trace('lv_report_category = ' || to_char(lv_report_category));
235: hr_utility.trace('l_print_term = ' || to_char(l_print_term));
236:
237: p_end_date := ld_end_date;
238: p_start_date := ld_start_date;
239: p_business_group_id := ln_business_group_id;

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

245: p_report_qualifier := lv_report_qualifier;
246: p_report_category := lv_report_category;
247: p_print_term := l_print_term;
248:
249: hr_utility.trace('Leaving get_payroll_action_info');
250:
251: EXCEPTION
252: when others then
253: hr_utility.trace('Error in ' || gv_procedure_name ||

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

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

Line 255: raise hr_utility.hr_error;

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

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

281: ln_year number;
282: lv_report_type varchar2(50);
283:
284: BEGIN
285: hr_utility.trace('Entered range_cursor');
286: hr_utility.trace('p_payroll_action_id = ' ||
287: to_char(p_payroll_action_id));
288:
289: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id

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

282: lv_report_type varchar2(50);
283:
284: BEGIN
285: hr_utility.trace('Entered range_cursor');
286: hr_utility.trace('p_payroll_action_id = ' ||
287: to_char(p_payroll_action_id));
288:
289: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
290: ,p_start_date => ld_start_date

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

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

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

319: and asgset.include_or_exclude = ''I''
320: and :payroll_action_id > 0
321: order by paf.person_id ';
322:
323: hr_utility.trace('Range for asg_set not null');
324:
325: elsif ln_pre_org_id is not NULL then
326:
327: lv_sql_string :=

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

360:
361: end if;
362:
363: p_sqlstr := lv_sql_string;
364: hr_utility.trace('p_sqlstr = ' ||p_sqlstr);
365:
366: END range_cursor;
367:
368:

Line 901: hr_utility.trace('get_latest_rl2_amend_dtls not found');

897: fetch get_warning_dtls_for_ee into lv_full_name,
898: lv_employee_number;
899: close get_warning_dtls_for_ee;
900:
901: hr_utility.trace('get_latest_rl2_amend_dtls not found');
902: hr_utility.trace('p_person_id :'||to_char(p_person_id));
903:
904: lv_record_name := 'RL2 Amend Paper Report';
905: lv_message := 'RL2 Amend Preprocess was not run for this employee';

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

898: lv_employee_number;
899: close get_warning_dtls_for_ee;
900:
901: hr_utility.trace('get_latest_rl2_amend_dtls not found');
902: hr_utility.trace('p_person_id :'||to_char(p_person_id));
903:
904: lv_record_name := 'RL2 Amend Paper Report';
905: lv_message := 'RL2 Amend Preprocess was not run for this employee';
906:

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

925:
926: lv_prov_amend_flag := 'N';
927: fetch c_get_prov_amend_flag into lv_prov_amend_flag;
928:
929: hr_utility.trace('lv_prov_amend_flag : '||lv_prov_amend_flag);
930:
931: if c_get_prov_amend_flag%FOUND then
932:
933: if lv_prov_amend_flag = 'Y' then

Line 956: hr_utility.trace('New RL2 Amend Action = ' ||

952: select pay_assignment_actions_s.nextval
953: into ln_rl2_amend_reg_asg_action
954: from dual;
955:
956: hr_utility.trace('New RL2 Amend Action = ' ||
957: to_char(ln_rl2_amend_reg_asg_action));
958:
959: /* Insert into pay_assignment_actions. */
960: hr_nonrun_asact.insact(ln_rl2_amend_reg_asg_action,

Line 983: hr_utility.trace('Province: '||substr(ln_serial_number,1,2));

979: update pay_assignment_actions aa
980: set aa.serial_number = ln_serial_number
981: where aa.assignment_action_id = ln_rl2_amend_reg_asg_action;
982:
983: hr_utility.trace('Province: '||substr(ln_serial_number,1,2));
984: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
985: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
986: --Added to lock the Amend Archiver
987: hr_nonrun_asact.insint(ln_rl2_amend_reg_asg_action

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

980: set aa.serial_number = ln_serial_number
981: where aa.assignment_action_id = ln_rl2_amend_reg_asg_action;
982:
983: hr_utility.trace('Province: '||substr(ln_serial_number,1,2));
984: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
985: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
986: --Added to lock the Amend Archiver
987: hr_nonrun_asact.insint(ln_rl2_amend_reg_asg_action
988: ,ln_asg_act_to_lock);

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

981: where aa.assignment_action_id = ln_rl2_amend_reg_asg_action;
982:
983: hr_utility.trace('Province: '||substr(ln_serial_number,1,2));
984: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
985: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
986: --Added to lock the Amend Archiver
987: hr_nonrun_asact.insint(ln_rl2_amend_reg_asg_action
988: ,ln_asg_act_to_lock);
989:

Line 990: hr_utility.trace('Locking Action'||ln_rl2_amend_reg_asg_action);

986: --Added to lock the Amend Archiver
987: hr_nonrun_asact.insint(ln_rl2_amend_reg_asg_action
988: ,ln_asg_act_to_lock);
989:
990: hr_utility.trace('Locking Action'||ln_rl2_amend_reg_asg_action);
991: hr_utility.trace('ln_serial_number :' || ln_serial_number);
992: end if; -- pay_us_employee_payslip_web.get_doc_eit
993:
994: end if; -- lv_prov_amend_flag = 'Y'

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

987: hr_nonrun_asact.insint(ln_rl2_amend_reg_asg_action
988: ,ln_asg_act_to_lock);
989:
990: hr_utility.trace('Locking Action'||ln_rl2_amend_reg_asg_action);
991: hr_utility.trace('ln_serial_number :' || ln_serial_number);
992: end if; -- pay_us_employee_payslip_web.get_doc_eit
993:
994: end if; -- lv_prov_amend_flag = 'Y'
995:

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

1002: if lv_report_type = 'PYRL2PRAMEND' or lv_report_type = 'PAYCARL2AMPDF' then -- To lock previous paper (unprinted)
1003:
1004: open c_paa_update_check(ln_rl2_amend_reg_asg_action);
1005: fetch c_paa_update_check into l_paa_update_check;
1006: hr_utility.trace('l_update_check : '||l_paa_update_check);
1007: if c_paa_update_check%FOUND then
1008:
1009: if ln_pre_parameter is NULL then
1010: ln_pre_org_id := '';

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

1013: ln_serial_number := 'QC'||
1014: lpad(to_char(ln_asg_act_to_lock),14,0)||
1015: lpad(to_char(ln_yepp_pact_id),14,0);
1016:
1017: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));
1018: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
1019: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
1020: --Added to lock the Amend Archiver
1021: hr_nonrun_asact.insint(ln_rl2_amend_reg_asg_action

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

1014: lpad(to_char(ln_asg_act_to_lock),14,0)||
1015: lpad(to_char(ln_yepp_pact_id),14,0);
1016:
1017: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));
1018: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
1019: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
1020: --Added to lock the Amend Archiver
1021: hr_nonrun_asact.insint(ln_rl2_amend_reg_asg_action
1022: ,ln_asg_act_to_lock);

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

1015: lpad(to_char(ln_yepp_pact_id),14,0);
1016:
1017: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));
1018: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
1019: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
1020: --Added to lock the Amend Archiver
1021: hr_nonrun_asact.insint(ln_rl2_amend_reg_asg_action
1022: ,ln_asg_act_to_lock);
1023:

Line 1024: hr_utility.trace('Locking Action'||ln_rl2_amend_reg_asg_action);

1020: --Added to lock the Amend Archiver
1021: hr_nonrun_asact.insint(ln_rl2_amend_reg_asg_action
1022: ,ln_asg_act_to_lock);
1023:
1024: hr_utility.trace('Locking Action'||ln_rl2_amend_reg_asg_action);
1025: hr_utility.trace('ln_serial_number :' || ln_serial_number);
1026: hr_utility.trace('Locked Action = ' || to_char(ln_asg_act_to_lock));
1027:
1028: end if; -- c_paa_update_check%FOUND

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

1021: hr_nonrun_asact.insint(ln_rl2_amend_reg_asg_action
1022: ,ln_asg_act_to_lock);
1023:
1024: hr_utility.trace('Locking Action'||ln_rl2_amend_reg_asg_action);
1025: hr_utility.trace('ln_serial_number :' || ln_serial_number);
1026: hr_utility.trace('Locked Action = ' || to_char(ln_asg_act_to_lock));
1027:
1028: end if; -- c_paa_update_check%FOUND
1029: close c_paa_update_check;

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

1022: ,ln_asg_act_to_lock);
1023:
1024: hr_utility.trace('Locking Action'||ln_rl2_amend_reg_asg_action);
1025: hr_utility.trace('ln_serial_number :' || ln_serial_number);
1026: hr_utility.trace('Locked Action = ' || to_char(ln_asg_act_to_lock));
1027:
1028: end if; -- c_paa_update_check%FOUND
1029: close c_paa_update_check;
1030:

Line 1066: hr_utility.trace('get_all_rl2_amend_dtls not found');

1062: fetch get_warning_dtls_for_ee into lv_full_name,
1063: lv_employee_number;
1064: close get_warning_dtls_for_ee;
1065:
1066: hr_utility.trace('get_all_rl2_amend_dtls not found');
1067: hr_utility.trace('p_person_id :'||to_char(p_person_id));
1068:
1069: lv_record_name := 'RL2 Amend Register Report';
1070: lv_message := 'RL2 Amend Preprocess was not run for this employee';

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

1063: lv_employee_number;
1064: close get_warning_dtls_for_ee;
1065:
1066: hr_utility.trace('get_all_rl2_amend_dtls not found');
1067: hr_utility.trace('p_person_id :'||to_char(p_person_id));
1068:
1069: lv_record_name := 'RL2 Amend Register Report';
1070: lv_message := 'RL2 Amend Preprocess was not run for this employee';
1071:

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

1089:
1090: lv_prov_amend_flag := 'N';
1091: fetch c_get_prov_amend_flag into lv_prov_amend_flag;
1092:
1093: hr_utility.trace('lv_prov_amend_flag : '||lv_prov_amend_flag);
1094:
1095: if c_get_prov_amend_flag%FOUND then
1096:
1097: if lv_prov_amend_flag = 'Y' then

Line 1110: hr_utility.trace('get_all_rl2_amend_dtls found ');

1106: fetch get_yepp_pact_id into ln_yepp_pact_id;
1107: close get_yepp_pact_id;
1108:
1109: /* Create an assignment action for this person */
1110: hr_utility.trace('get_all_rl2_amend_dtls found ');
1111: hr_utility.trace('Report Type: '||lv_report_type);
1112:
1113: select pay_assignment_actions_s.nextval
1114: into ln_rl2_amend_reg_asg_action

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

1107: close get_yepp_pact_id;
1108:
1109: /* Create an assignment action for this person */
1110: hr_utility.trace('get_all_rl2_amend_dtls found ');
1111: hr_utility.trace('Report Type: '||lv_report_type);
1112:
1113: select pay_assignment_actions_s.nextval
1114: into ln_rl2_amend_reg_asg_action
1115: from dual;

Line 1117: hr_utility.trace('New RL2 Amend Action = ' ||

1113: select pay_assignment_actions_s.nextval
1114: into ln_rl2_amend_reg_asg_action
1115: from dual;
1116:
1117: hr_utility.trace('New RL2 Amend Action = ' ||
1118: to_char(ln_rl2_amend_reg_asg_action));
1119:
1120: /* Insert into pay_assignment_actions. */
1121: hr_nonrun_asact.insact(ln_rl2_amend_reg_asg_action,

Line 1144: hr_utility.trace('Province: '||substr(ln_serial_number,1,2));

1140: update pay_assignment_actions aa
1141: set aa.serial_number = ln_serial_number
1142: where aa.assignment_action_id = ln_rl2_amend_reg_asg_action;
1143:
1144: hr_utility.trace('Province: '||substr(ln_serial_number,1,2));
1145: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
1146: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
1147:
1148: end if; -- lv_prov_amend_flag = 'Y'

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

1141: set aa.serial_number = ln_serial_number
1142: where aa.assignment_action_id = ln_rl2_amend_reg_asg_action;
1143:
1144: hr_utility.trace('Province: '||substr(ln_serial_number,1,2));
1145: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
1146: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
1147:
1148: end if; -- lv_prov_amend_flag = 'Y'
1149:

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

1142: where aa.assignment_action_id = ln_rl2_amend_reg_asg_action;
1143:
1144: hr_utility.trace('Province: '||substr(ln_serial_number,1,2));
1145: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
1146: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
1147:
1148: end if; -- lv_prov_amend_flag = 'Y'
1149:
1150: end if; -- c_get_prov_amend_flag%FOUND

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

1172: ln_primary_assignment_id := 0;
1173: ln_asg_act_to_lock := 0;
1174: ln_pre_id_null := 0;
1175:
1176: hr_utility.trace('lv_print :'||lv_print);
1177:
1178: loop
1179:
1180: fetch get_all_rl2_amend_dtls into lv_report_type

Line 1186: hr_utility.trace('get_all_rl2_amend_dtls not found ');

1182: ,ln_asg_act_to_lock
1183: ,ln_pre_id_null;
1184:
1185: if get_all_rl2_amend_dtls%notfound then
1186: hr_utility.trace('get_all_rl2_amend_dtls not found ');
1187: exit;
1188: end if;
1189:
1190: open c_get_prov_amend_flag(ln_asg_act_to_lock);

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

1191:
1192: lv_prov_amend_flag := 'N';
1193: fetch c_get_prov_amend_flag into lv_prov_amend_flag;
1194:
1195: hr_utility.trace('lv_prov_amend_flag : '||lv_prov_amend_flag);
1196:
1197: if c_get_prov_amend_flag%FOUND then
1198:
1199: if lv_prov_amend_flag = 'Y' then

Line 1211: hr_utility.trace('get_all_rl2_amend_dtls found ');

1207: ld_end_date);
1208: fetch get_yepp_pact_id into ln_yepp_pact_id;
1209: close get_yepp_pact_id;
1210:
1211: hr_utility.trace('get_all_rl2_amend_dtls found ');
1212: hr_utility.trace('Report Type: '||lv_report_type);
1213:
1214: /* Create an assignment action for this person */
1215:

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

1208: fetch get_yepp_pact_id into ln_yepp_pact_id;
1209: close get_yepp_pact_id;
1210:
1211: hr_utility.trace('get_all_rl2_amend_dtls found ');
1212: hr_utility.trace('Report Type: '||lv_report_type);
1213:
1214: /* Create an assignment action for this person */
1215:
1216: select pay_assignment_actions_s.nextval

Line 1220: hr_utility.trace('New RL2 Amend Action = ' || ln_rl2_amend_reg_asg_action);

1216: select pay_assignment_actions_s.nextval
1217: into ln_rl2_amend_reg_asg_action
1218: from dual;
1219:
1220: hr_utility.trace('New RL2 Amend Action = ' || ln_rl2_amend_reg_asg_action);
1221:
1222: /* Insert into pay_assignment_actions. */
1223: hr_nonrun_asact.insact(ln_rl2_amend_reg_asg_action,
1224: ln_primary_assignment_id,

Line 1237: hr_utility.trace('Province: '||substr(ln_serial_number,1,2));

1233: ln_serial_number := 'QC'||
1234: lpad(to_char(ln_asg_act_to_lock),14,0)||
1235: lpad(to_char(ln_yepp_pact_id),14,0);
1236:
1237: hr_utility.trace('Province: '||substr(ln_serial_number,1,2));
1238: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
1239: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
1240:
1241: update pay_assignment_actions aa

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

1234: lpad(to_char(ln_asg_act_to_lock),14,0)||
1235: lpad(to_char(ln_yepp_pact_id),14,0);
1236:
1237: hr_utility.trace('Province: '||substr(ln_serial_number,1,2));
1238: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
1239: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
1240:
1241: update pay_assignment_actions aa
1242: set aa.serial_number = ln_serial_number

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

1235: lpad(to_char(ln_yepp_pact_id),14,0);
1236:
1237: hr_utility.trace('Province: '||substr(ln_serial_number,1,2));
1238: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
1239: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
1240:
1241: update pay_assignment_actions aa
1242: set aa.serial_number = ln_serial_number
1243: where aa.assignment_action_id = ln_rl2_amend_reg_asg_action;

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

1269: ln_primary_assignment_id := 0;
1270: ln_asg_act_to_lock := 0;
1271: ln_pre_id_null := 0;
1272:
1273: hr_utility.trace('lv_print :'||lv_print);
1274:
1275: loop
1276:
1277: if nvl(l_print_term,'N') = 'Y' then

Line 1284: hr_utility.trace('get_reprint_rl2_amend_dtls not found ');

1280: ,ln_asg_act_to_lock
1281: ,ln_pre_id_null
1282: ,l_effective_end_date;
1283: if get_reprint_rl2_amend_term%notfound then
1284: hr_utility.trace('get_reprint_rl2_amend_dtls not found ');
1285: exit;
1286: end if;
1287: else
1288: fetch get_reprint_rl2_amend_dtls into lv_report_type

Line 1294: hr_utility.trace('get_reprint_rl2_amend_dtls not found ');

1290: ,ln_asg_act_to_lock
1291: ,ln_pre_id_null
1292: ,l_effective_end_date;
1293: if get_reprint_rl2_amend_dtls%notfound then
1294: hr_utility.trace('get_reprint_rl2_amend_dtls not found ');
1295: exit;
1296: end if;
1297: end if;
1298:

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

1299: open c_get_prov_amend_flag(ln_asg_act_to_lock);
1300:
1301: lv_prov_amend_flag := 'N';
1302: fetch c_get_prov_amend_flag into lv_prov_amend_flag;
1303: hr_utility.trace('lv_prov_amend_flag : '||lv_prov_amend_flag);
1304:
1305: if c_get_prov_amend_flag%FOUND then
1306:
1307: if lv_prov_amend_flag = 'Y' then

Line 1319: hr_utility.trace('get_reprint_rl2_amend_dtls found ');

1315: ld_end_date);
1316: fetch get_yepp_pact_id into ln_yepp_pact_id;
1317: close get_yepp_pact_id;
1318:
1319: hr_utility.trace('get_reprint_rl2_amend_dtls found ');
1320: hr_utility.trace('Report Type: '||lv_report_type);
1321:
1322: if nvl(pay_us_employee_payslip_web.get_doc_eit('RL2PDF',
1323: 'PRINT',

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

1316: fetch get_yepp_pact_id into ln_yepp_pact_id;
1317: close get_yepp_pact_id;
1318:
1319: hr_utility.trace('get_reprint_rl2_amend_dtls found ');
1320: hr_utility.trace('Report Type: '||lv_report_type);
1321:
1322: if nvl(pay_us_employee_payslip_web.get_doc_eit('RL2PDF',
1323: 'PRINT',
1324: 'ASSIGNMENT',

Line 1332: hr_utility.trace('New RL2 Amend Action = ' || ln_rl2_amend_reg_asg_action);

1328:
1329: select pay_assignment_actions_s.nextval
1330: into ln_rl2_amend_reg_asg_action
1331: from dual;
1332: hr_utility.trace('New RL2 Amend Action = ' || ln_rl2_amend_reg_asg_action);
1333:
1334: /* Insert into pay_assignment_actions. */
1335: hr_nonrun_asact.insact(ln_rl2_amend_reg_asg_action
1336: ,ln_primary_assignment_id

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

1344:
1345: ln_serial_number := 'QC'||
1346: lpad(to_char(ln_asg_act_to_lock),14,0)||
1347: lpad(to_char(ln_yepp_pact_id),14,0);
1348: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));
1349: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
1350: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
1351:
1352: update pay_assignment_actions aa

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

1345: ln_serial_number := 'QC'||
1346: lpad(to_char(ln_asg_act_to_lock),14,0)||
1347: lpad(to_char(ln_yepp_pact_id),14,0);
1348: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));
1349: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
1350: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
1351:
1352: update pay_assignment_actions aa
1353: set aa.serial_number = ln_serial_number

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

1346: lpad(to_char(ln_asg_act_to_lock),14,0)||
1347: lpad(to_char(ln_yepp_pact_id),14,0);
1348: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));
1349: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
1350: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
1351:
1352: update pay_assignment_actions aa
1353: set aa.serial_number = ln_serial_number
1354: where aa.assignment_action_id = ln_rl2_amend_reg_asg_action;

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

1372:
1373: END action_creation;
1374:
1375: BEGIN
1376: hr_utility.trace('Entered action_creation ');
1377: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
1378: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
1379: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
1380: hr_utility.trace('p_chunk = ' || to_char(p_chunk));

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

1373: END action_creation;
1374:
1375: BEGIN
1376: hr_utility.trace('Entered action_creation ');
1377: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
1378: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
1379: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
1380: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
1381:

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

1374:
1375: BEGIN
1376: hr_utility.trace('Entered action_creation ');
1377: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
1378: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
1379: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
1380: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
1381:
1382: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id

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

1375: BEGIN
1376: hr_utility.trace('Entered action_creation ');
1377: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
1378: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
1379: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
1380: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
1381:
1382: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
1383: ,p_start_date => ld_start_date

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

1376: hr_utility.trace('Entered action_creation ');
1377: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
1378: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
1379: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
1380: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
1381:
1382: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
1383: ,p_start_date => ld_start_date
1384: ,p_end_date => ld_end_date

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

1391: ,p_report_qualifier => l_state
1392: ,p_report_category => l_report_cat
1393: ,p_print_term => l_print_term);
1394:
1395: hr_utility.trace('lv_ppr_report_type: '||lv_ppr_report_type);
1396:
1397: ln_pre_org_id := ln_pre_parameter;
1398:
1399: -- Code modification for bug 10399514 starts here

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

1410: Exception
1411: When Others Then
1412: l_report_format := Null ;
1413: End ;
1414: hr_utility.trace('l_report_format: '||l_report_format);
1415: hr_utility.trace('lv_ppr_report_type: '||lv_ppr_report_type);
1416: hr_utility.trace('l_state '||l_state);
1417: hr_utility.trace('l_report_cat: '||l_report_cat);
1418: l_person_on := pay_ac_utility.range_person_on( p_report_type => lv_ppr_report_type,

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

1411: When Others Then
1412: l_report_format := Null ;
1413: End ;
1414: hr_utility.trace('l_report_format: '||l_report_format);
1415: hr_utility.trace('lv_ppr_report_type: '||lv_ppr_report_type);
1416: hr_utility.trace('l_state '||l_state);
1417: hr_utility.trace('l_report_cat: '||l_report_cat);
1418: l_person_on := pay_ac_utility.range_person_on( p_report_type => lv_ppr_report_type,
1419: p_report_format => l_report_format,

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

1412: l_report_format := Null ;
1413: End ;
1414: hr_utility.trace('l_report_format: '||l_report_format);
1415: hr_utility.trace('lv_ppr_report_type: '||lv_ppr_report_type);
1416: hr_utility.trace('l_state '||l_state);
1417: hr_utility.trace('l_report_cat: '||l_report_cat);
1418: l_person_on := pay_ac_utility.range_person_on( p_report_type => lv_ppr_report_type,
1419: p_report_format => l_report_format,
1420: p_report_qualifier => l_state,

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

1413: End ;
1414: hr_utility.trace('l_report_format: '||l_report_format);
1415: hr_utility.trace('lv_ppr_report_type: '||lv_ppr_report_type);
1416: hr_utility.trace('l_state '||l_state);
1417: hr_utility.trace('l_report_cat: '||l_report_cat);
1418: l_person_on := pay_ac_utility.range_person_on( p_report_type => lv_ppr_report_type,
1419: p_report_format => l_report_format,
1420: p_report_qualifier => l_state,
1421: p_report_category => l_report_cat) ;

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

1425: action_creation(p_start_person_id);
1426:
1427: elsif ln_asg_set is not null then
1428:
1429: hr_utility.trace('Entered Asg Set logic');
1430: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
1431: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1432: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1433:

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

1426:
1427: elsif ln_asg_set is not null then
1428:
1429: hr_utility.trace('Entered Asg Set logic');
1430: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
1431: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1432: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1433:
1434: -- Added for Bug# 10399514

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

1427: elsif ln_asg_set is not null then
1428:
1429: hr_utility.trace('Entered Asg Set logic');
1430: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
1431: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1432: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1433:
1434: -- Added for Bug# 10399514
1435: if l_person_on then

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

1428:
1429: hr_utility.trace('Entered Asg Set logic');
1430: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
1431: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1432: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1433:
1434: -- Added for Bug# 10399514
1435: if l_person_on then
1436: open c_selected_asg_set_range(p_start_person_id

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

1436: open c_selected_asg_set_range(p_start_person_id
1437: ,p_end_person_id
1438: ,ln_asg_set
1439: ,ld_end_date);
1440: hr_utility.trace('Opened cusor c_selected_asg_set_range');
1441: else
1442: open c_selected_asg_set (p_start_person_id
1443: ,p_end_person_id
1444: ,ln_asg_set

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

1442: open c_selected_asg_set (p_start_person_id
1443: ,p_end_person_id
1444: ,ln_asg_set
1445: ,ld_end_date);
1446: hr_utility.trace('Opened cusor c_selected_asg_set');
1447: end if;
1448: loop
1449: -- Added for Bug# 10399514
1450: if l_person_on then

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

1449: -- Added for Bug# 10399514
1450: if l_person_on then
1451: fetch c_selected_asg_set_range into ln_set_person_id;
1452: if c_selected_asg_set_range%notfound then
1453: hr_utility.trace('c_selected_asg_set_range not found ');
1454: hr_utility.trace('No Person found for reporting in this chunk');
1455: exit;
1456: end if;
1457: else

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

1450: if l_person_on then
1451: fetch c_selected_asg_set_range into ln_set_person_id;
1452: if c_selected_asg_set_range%notfound then
1453: hr_utility.trace('c_selected_asg_set_range not found ');
1454: hr_utility.trace('No Person found for reporting in this chunk');
1455: exit;
1456: end if;
1457: else
1458: fetch c_selected_asg_set into ln_set_person_id;

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

1456: end if;
1457: else
1458: fetch c_selected_asg_set into ln_set_person_id;
1459: if c_selected_asg_set%notfound then
1460: hr_utility.trace('c_selected_asg_set not found ');
1461: hr_utility.trace('No Person found for reporting in this chunk');
1462: exit;
1463: end if;
1464: end if;

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

1457: else
1458: fetch c_selected_asg_set into ln_set_person_id;
1459: if c_selected_asg_set%notfound then
1460: hr_utility.trace('c_selected_asg_set not found ');
1461: hr_utility.trace('No Person found for reporting in this chunk');
1462: exit;
1463: end if;
1464: end if;
1465:

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

1472: end if;
1473:
1474: elsif ln_pre_org_id is not null then
1475:
1476: hr_utility.trace('Entered PRE not null logic');
1477: hr_utility.trace('PRE Organization Id ='||to_char(ln_pre_org_id));
1478: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1479: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1480:

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

1473:
1474: elsif ln_pre_org_id is not null then
1475:
1476: hr_utility.trace('Entered PRE not null logic');
1477: hr_utility.trace('PRE Organization Id ='||to_char(ln_pre_org_id));
1478: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1479: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1480:
1481: -- Added for Bug# 10399514

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

1474: elsif ln_pre_org_id is not null then
1475:
1476: hr_utility.trace('Entered PRE not null logic');
1477: hr_utility.trace('PRE Organization Id ='||to_char(ln_pre_org_id));
1478: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1479: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1480:
1481: -- Added for Bug# 10399514
1482: if l_person_on then

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

1475:
1476: hr_utility.trace('Entered PRE not null logic');
1477: hr_utility.trace('PRE Organization Id ='||to_char(ln_pre_org_id));
1478: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1479: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1480:
1481: -- Added for Bug# 10399514
1482: if l_person_on then
1483: open c_all_asg_range(ln_business_group_id,

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

1484: ln_pre_org_id,
1485: ld_end_date,
1486: p_start_person_id,
1487: p_end_person_id);
1488: hr_utility.trace('Opened cusor c_all_asg_range');
1489: else
1490: open c_all_asg (ln_business_group_id,
1491: ln_pre_org_id,
1492: ld_end_date,

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

1491: ln_pre_org_id,
1492: ld_end_date,
1493: p_start_person_id,
1494: p_end_person_id);
1495: hr_utility.trace('Opened cusor c_all_asg');
1496: end if;
1497:
1498: loop
1499: -- Added for Bug# 10399514

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

1499: -- Added for Bug# 10399514
1500: if l_person_on then
1501: fetch c_all_asg_range into ln_set_person_id;
1502: if c_all_asg_range%notfound then
1503: hr_utility.trace('c_all_asg_range not found ');
1504: hr_utility.trace('No Person found for reporting in this chunk');
1505: exit;
1506: end if;
1507: else

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

1500: if l_person_on then
1501: fetch c_all_asg_range into ln_set_person_id;
1502: if c_all_asg_range%notfound then
1503: hr_utility.trace('c_all_asg_range not found ');
1504: hr_utility.trace('No Person found for reporting in this chunk');
1505: exit;
1506: end if;
1507: else
1508: fetch c_all_asg into ln_set_person_id;

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

1506: end if;
1507: else
1508: fetch c_all_asg into ln_set_person_id;
1509: if c_all_asg%notfound then
1510: hr_utility.trace('c_all_asg not found ');
1511: hr_utility.trace('No Person found for reporting in this chunk');
1512: exit;
1513: end if;
1514: end if;

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

1507: else
1508: fetch c_all_asg into ln_set_person_id;
1509: if c_all_asg%notfound then
1510: hr_utility.trace('c_all_asg not found ');
1511: hr_utility.trace('No Person found for reporting in this chunk');
1512: exit;
1513: end if;
1514: end if;
1515:

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

1522: end if;
1523:
1524: else
1525:
1526: hr_utility.trace('Entered All PRE logic');
1527:
1528: open c_all_pres(ln_business_group_id,
1529: ld_end_date);
1530:

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

1532:
1533: fetch c_all_pres into ln_pre_id;
1534:
1535: if c_all_pres%NOTFOUND then
1536: hr_utility.trace('c_all_pres NOT FOUND');
1537: exit;
1538: end if;
1539:
1540: hr_utility.trace('PRE ='||to_char(ln_pre_id));

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

1536: hr_utility.trace('c_all_pres NOT FOUND');
1537: exit;
1538: end if;
1539:
1540: hr_utility.trace('PRE ='||to_char(ln_pre_id));
1541: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1542: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1543:
1544: -- Added for Bug# 10399514

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

1537: exit;
1538: end if;
1539:
1540: hr_utility.trace('PRE ='||to_char(ln_pre_id));
1541: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1542: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1543:
1544: -- Added for Bug# 10399514
1545: if l_person_on then

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

1538: end if;
1539:
1540: hr_utility.trace('PRE ='||to_char(ln_pre_id));
1541: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1542: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1543:
1544: -- Added for Bug# 10399514
1545: if l_person_on then
1546: open c_all_asg_range(ln_business_group_id,

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

1547: ln_pre_id,
1548: ld_end_date,
1549: p_start_person_id,
1550: p_end_person_id);
1551: hr_utility.trace('Opened cusor c_all_asg_range');
1552: else
1553: open c_all_asg (ln_business_group_id,
1554: ln_pre_id,
1555: ld_end_date,

Line 1558: hr_utility.trace('Opened cursor c_all_asg');

1554: ln_pre_id,
1555: ld_end_date,
1556: p_start_person_id,
1557: p_end_person_id);
1558: hr_utility.trace('Opened cursor c_all_asg');
1559: end if;
1560:
1561: loop -- c_all_asg
1562: -- Added for Bug# 10399514

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

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

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

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

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

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

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

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

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

1603: ) is
1604:
1605: begin
1606:
1607: hr_utility.trace('Beginning of the sort_action cursor');
1608:
1609: sqlstr := 'select paa1.rowid /* we need the row id of the assignment actions that are created by PYUGEN */
1610: from hr_all_organization_units hou1,
1611: hr_all_organization_units hou,

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

1646: ,ppf.last_name,ppf.first_name';
1647:
1648:
1649: len := length(sqlstr); -- return the length of the string.
1650: hr_utility.trace('End of the sort_Action cursor');
1651:
1652: end sort_action;
1653:
1654:

Line 1687: /* hr_utility.trace_on(null,'RL2AMEND_REG'); */

1683: return par_value;
1684:
1685: END get_parameter;
1686: Begin
1687: /* hr_utility.trace_on(null,'RL2AMEND_REG'); */
1688: null;
1689:
1690:
1691: end pay_ca_eoy_rl2_amend_reg;