eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CA_EOY_RL2_CANCEL_PKG dependencies on HR_UTILITY

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

88: lv_prov_cd varchar2(5);
89: lv_report_type varchar2(50);
90:
91: BEGIN
92: hr_utility.trace('Entered get_payroll_action_info');
93: open c_payroll_action_info(p_payroll_action_id);
94: fetch c_payroll_action_info into ln_tax_unit_id,
95: ln_person_id,
96: ln_asg_set,

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

101: lv_prov_cd,
102: lv_report_type;
103: close c_payroll_action_info;
104:
105: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
106: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
107: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
108: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
109: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));

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

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

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

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

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

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

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

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

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

106: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
107: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
108: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
109: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
110: hr_utility.trace('lv_prov_cd = ' || lv_prov_cd);
111:
112: p_end_date := ld_end_date;
113: p_start_date := ld_start_date;
114: p_business_group_id := ln_business_group_id;

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

118: p_print := lv_print;
119: p_prov_cd := lv_prov_cd;
120: p_report_type := lv_report_type;
121:
122: hr_utility.trace('Leaving get_payroll_action_info');
123:
124: EXCEPTION
125: when others then
126: hr_utility.trace('Error in ' || gv_procedure_name ||

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

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

Line 128: raise hr_utility.hr_error;

124: EXCEPTION
125: when others then
126: hr_utility.trace('Error in ' || gv_procedure_name ||
127: to_char(sqlcode) || '-' || sqlerrm);
128: raise hr_utility.hr_error;
129:
130: END get_payroll_action_info;
131:
132: -- Added for Bug# 10399514

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

180: lv_report_category varchar2(30);
181: l_print_term varchar2(1) := 'N';
182:
183: BEGIN
184: hr_utility.trace('Entered get_payroll_action_info');
185: open c_payroll_action_info(p_payroll_action_id);
186: fetch c_payroll_action_info into ln_tax_unit_id,
187: ln_person_id,
188: ln_asg_set,

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

196: lv_report_category,
197: l_print_term;
198: close c_payroll_action_info;
199:
200: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
201: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
202: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
203: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
204: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));

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

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

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

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

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

199:
200: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
201: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
202: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
203: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
204: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
205: hr_utility.trace('lv_prov_cd = ' || lv_prov_cd);
206: hr_utility.trace('lv_report_qualifier = ' || to_char(lv_report_qualifier));
207: hr_utility.trace('lv_report_category = ' || to_char(lv_report_category));

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

200: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
201: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
202: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
203: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
204: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
205: hr_utility.trace('lv_prov_cd = ' || lv_prov_cd);
206: hr_utility.trace('lv_report_qualifier = ' || to_char(lv_report_qualifier));
207: hr_utility.trace('lv_report_category = ' || to_char(lv_report_category));
208: hr_utility.trace('l_print_term = ' || to_char(l_print_term));

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

201: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
202: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
203: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
204: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
205: hr_utility.trace('lv_prov_cd = ' || lv_prov_cd);
206: hr_utility.trace('lv_report_qualifier = ' || to_char(lv_report_qualifier));
207: hr_utility.trace('lv_report_category = ' || to_char(lv_report_category));
208: hr_utility.trace('l_print_term = ' || to_char(l_print_term));
209:

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

202: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
203: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
204: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
205: hr_utility.trace('lv_prov_cd = ' || lv_prov_cd);
206: hr_utility.trace('lv_report_qualifier = ' || to_char(lv_report_qualifier));
207: hr_utility.trace('lv_report_category = ' || to_char(lv_report_category));
208: hr_utility.trace('l_print_term = ' || to_char(l_print_term));
209:
210: p_end_date := ld_end_date;

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

203: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
204: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
205: hr_utility.trace('lv_prov_cd = ' || lv_prov_cd);
206: hr_utility.trace('lv_report_qualifier = ' || to_char(lv_report_qualifier));
207: hr_utility.trace('lv_report_category = ' || to_char(lv_report_category));
208: hr_utility.trace('l_print_term = ' || to_char(l_print_term));
209:
210: p_end_date := ld_end_date;
211: p_start_date := ld_start_date;

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

204: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
205: hr_utility.trace('lv_prov_cd = ' || lv_prov_cd);
206: hr_utility.trace('lv_report_qualifier = ' || to_char(lv_report_qualifier));
207: hr_utility.trace('lv_report_category = ' || to_char(lv_report_category));
208: hr_utility.trace('l_print_term = ' || to_char(l_print_term));
209:
210: p_end_date := ld_end_date;
211: p_start_date := ld_start_date;
212: p_business_group_id := ln_business_group_id;

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

219: p_report_qualifier := lv_report_qualifier;
220: p_report_category := lv_report_category;
221: p_print_term := l_print_term;
222:
223: hr_utility.trace('Leaving get_payroll_action_info');
224:
225: EXCEPTION
226: when others then
227: hr_utility.trace('Error in ' || gv_procedure_name ||

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

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

Line 229: raise hr_utility.hr_error;

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

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

260: lv_prov_cd varchar2(5);
261: lv_report_type varchar2(50);
262:
263: BEGIN
264: hr_utility.trace('Entered range_cursor');
265: hr_utility.trace('p_payroll_action_id = ' ||
266: to_char(p_payroll_action_id));
267:
268: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id

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

261: lv_report_type varchar2(50);
262:
263: BEGIN
264: hr_utility.trace('Entered range_cursor');
265: hr_utility.trace('p_payroll_action_id = ' ||
266: to_char(p_payroll_action_id));
267:
268: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
269: ,p_start_date => ld_start_date

Line 281: hr_utility.trace('Checking for Preprocess Agent PRE setup');

277: ,p_report_type => lv_report_type);
278:
279: ln_year := to_number(to_char(ld_end_date,'YYYY'));
280:
281: hr_utility.trace('Checking for Preprocess Agent PRE setup');
282:
283: if ln_person_id is not null then
284:
285: lv_sql_string :=

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

287: from per_assignments_f asg
288: where person_id = ' || ln_person_id ||
289: ' and :payroll_action_id > 0';
290:
291: hr_utility.trace('Range for person_id not null');
292:
293: elsif ln_asg_set is not null then
294:
295: lv_sql_string :=

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

301: and asgset.include_or_exclude = ''I''
302: and :payroll_action_id > 0
303: order by paf.person_id';
304:
305: hr_utility.trace('Range for asg_set not null');
306:
307: elsif ln_tax_unit_id is not NULL then
308:
309: lv_sql_string :=

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

341:
342: end if;
343:
344: p_sqlstr := lv_sql_string;
345: hr_utility.trace('p_sqlstr = ' ||p_sqlstr);
346:
347: hr_utility.trace('Leaving range_cursor');
348:
349: END range_cursor;

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

343:
344: p_sqlstr := lv_sql_string;
345: hr_utility.trace('p_sqlstr = ' ||p_sqlstr);
346:
347: hr_utility.trace('Leaving range_cursor');
348:
349: END range_cursor;
350:
351:

Line 804: hr_utility.trace('Inside action_creation');

800: l_effective_end_date date; -- Added for the bug 15886428
801:
802: BEGIN
803:
804: hr_utility.trace('Inside action_creation');
805:
806: if lv_print = 'LATEST' then
807: if nvl(l_print_term,'N') = 'Y' then
808: open get_latest_rl2_cancel_term(p_person_id

Line 848: hr_utility.trace('get_latest_rl2_cancel_dtls not found');

844: fetch get_warning_dtls_for_ee into lv_full_name
845: ,lv_employee_number;
846: close get_warning_dtls_for_ee;
847:
848: hr_utility.trace('get_latest_rl2_cancel_dtls not found');
849: hr_utility.trace('p_person_id :'||to_char(p_person_id));
850:
851: lv_record_name := 'RL2 Cancel PDF Report';
852: lv_message := 'Either RL2 PDF or RL2 Amendment PDF were not run for the employee';

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

845: ,lv_employee_number;
846: close get_warning_dtls_for_ee;
847:
848: hr_utility.trace('get_latest_rl2_cancel_dtls not found');
849: hr_utility.trace('p_person_id :'||to_char(p_person_id));
850:
851: lv_record_name := 'RL2 Cancel PDF Report';
852: lv_message := 'Either RL2 PDF or RL2 Amendment PDF were not run for the employee';
853:

Line 871: hr_utility.trace('ln_arch_act_to_lock:'||ln_arch_act_to_lock);

867:
868: if (nvl(l_print_term,'N') = 'Y' and get_latest_rl2_cancel_term%found)
869: or (nvl(l_print_term,'N') = 'N' and get_latest_rl2_cancel_dtls%found) then
870:
871: hr_utility.trace('ln_arch_act_to_lock:'||ln_arch_act_to_lock);
872:
873: open check_arch_action_exists(ln_arch_act_to_lock);
874: fetch check_arch_action_exists into l_arch_asg_action_check;
875: if check_arch_action_exists%notfound then

Line 882: hr_utility.trace('check_arch_action_exists not found');

878: fetch get_warning_dtls_for_ee into lv_full_name
879: ,lv_employee_number;
880: close get_warning_dtls_for_ee;
881:
882: hr_utility.trace('check_arch_action_exists not found');
883: hr_utility.trace('p_person_id :'||to_char(p_person_id));
884: hr_utility.trace('ln_arch_act_to_lock :'||to_char(ln_arch_act_to_lock));
885: hr_utility.trace('lv_report_type :'||lv_report_type);
886: hr_utility.trace('ln_rep_act_to_lock :'||ln_rep_act_to_lock);

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

879: ,lv_employee_number;
880: close get_warning_dtls_for_ee;
881:
882: hr_utility.trace('check_arch_action_exists not found');
883: hr_utility.trace('p_person_id :'||to_char(p_person_id));
884: hr_utility.trace('ln_arch_act_to_lock :'||to_char(ln_arch_act_to_lock));
885: hr_utility.trace('lv_report_type :'||lv_report_type);
886: hr_utility.trace('ln_rep_act_to_lock :'||ln_rep_act_to_lock);
887: lv_record_name := 'rl2 cancel PDF Report';

Line 884: hr_utility.trace('ln_arch_act_to_lock :'||to_char(ln_arch_act_to_lock));

880: close get_warning_dtls_for_ee;
881:
882: hr_utility.trace('check_arch_action_exists not found');
883: hr_utility.trace('p_person_id :'||to_char(p_person_id));
884: hr_utility.trace('ln_arch_act_to_lock :'||to_char(ln_arch_act_to_lock));
885: hr_utility.trace('lv_report_type :'||lv_report_type);
886: hr_utility.trace('ln_rep_act_to_lock :'||ln_rep_act_to_lock);
887: lv_record_name := 'rl2 cancel PDF Report';
888: lv_message := 'Archiver run with assignment action id '||ln_arch_act_to_lock||' is rolled back';

Line 885: hr_utility.trace('lv_report_type :'||lv_report_type);

881:
882: hr_utility.trace('check_arch_action_exists not found');
883: hr_utility.trace('p_person_id :'||to_char(p_person_id));
884: hr_utility.trace('ln_arch_act_to_lock :'||to_char(ln_arch_act_to_lock));
885: hr_utility.trace('lv_report_type :'||lv_report_type);
886: hr_utility.trace('ln_rep_act_to_lock :'||ln_rep_act_to_lock);
887: lv_record_name := 'rl2 cancel PDF Report';
888: lv_message := 'Archiver run with assignment action id '||ln_arch_act_to_lock||' is rolled back';
889:

Line 886: hr_utility.trace('ln_rep_act_to_lock :'||ln_rep_act_to_lock);

882: hr_utility.trace('check_arch_action_exists not found');
883: hr_utility.trace('p_person_id :'||to_char(p_person_id));
884: hr_utility.trace('ln_arch_act_to_lock :'||to_char(ln_arch_act_to_lock));
885: hr_utility.trace('lv_report_type :'||lv_report_type);
886: hr_utility.trace('ln_rep_act_to_lock :'||ln_rep_act_to_lock);
887: lv_record_name := 'rl2 cancel PDF Report';
888: lv_message := 'Archiver run with assignment action id '||ln_arch_act_to_lock||' is rolled back';
889:
890: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','I');

Line 902: hr_utility.trace('lv_negative_bal_flag '||lv_negative_bal_flag);

898: --Negative employeess
899: lv_negative_bal_flag := nvl(pay_ca_archive_utils.get_archive_value(substr(ln_serial_number,3,14),
900: substr(ln_serial_number,1,2),'JURISDICTION_CODE',
901: 'CAEOY_RL2_NEGATIVE_BALANCE_EXISTS'),'N');
902: hr_utility.trace('lv_negative_bal_flag '||lv_negative_bal_flag);
903: if lv_negative_bal_flag = 'Y' then
904: open get_warning_dtls_for_ee(p_person_id);
905: fetch get_warning_dtls_for_ee into lv_full_name
906: ,lv_employee_number;

Line 909: hr_utility.trace('Negative_bal_flag is Y');

905: fetch get_warning_dtls_for_ee into lv_full_name
906: ,lv_employee_number;
907: close get_warning_dtls_for_ee;
908:
909: hr_utility.trace('Negative_bal_flag is Y');
910: hr_utility.trace('p_person_id :'||to_char(p_person_id));
911:
912: lv_record_name := 'RL2 Cancel PDF Report';
913: lv_message := 'This employee has negative balance';

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

906: ,lv_employee_number;
907: close get_warning_dtls_for_ee;
908:
909: hr_utility.trace('Negative_bal_flag is Y');
910: hr_utility.trace('p_person_id :'||to_char(p_person_id));
911:
912: lv_record_name := 'RL2 Cancel PDF Report';
913: lv_message := 'This employee has negative balance';
914:

Line 932: hr_utility.trace('get_latest_rl2_cancel_dtls found ');

928: 'ASSIGNMENT',
929: ln_primary_assignment_id,
930: l_effective_end_date),'Y') = 'Y' then
931: /* Create an assignment action for this person */
932: hr_utility.trace('get_latest_rl2_cancel_dtls found ');
933: hr_utility.trace('Report Type: '||lv_report_type);
934:
935: select pay_assignment_actions_s.nextval
936: into ln_rl2_cancel_asg_action

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

929: ln_primary_assignment_id,
930: l_effective_end_date),'Y') = 'Y' then
931: /* Create an assignment action for this person */
932: hr_utility.trace('get_latest_rl2_cancel_dtls found ');
933: hr_utility.trace('Report Type: '||lv_report_type);
934:
935: select pay_assignment_actions_s.nextval
936: into ln_rl2_cancel_asg_action
937: from dual;

Line 939: hr_utility.trace('New rl2 Amend Action = ' ||

935: select pay_assignment_actions_s.nextval
936: into ln_rl2_cancel_asg_action
937: from dual;
938:
939: hr_utility.trace('New rl2 Amend Action = ' ||
940: to_char(ln_rl2_cancel_asg_action));
941:
942: /* Insert into pay_assignment_actions. */
943: hr_nonrun_asact.insact(ln_rl2_cancel_asg_action

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

971: update pay_assignment_actions aa
972: set aa.serial_number = ln_serial_number
973: where aa.assignment_action_id = ln_rl2_cancel_asg_action;
974:
975: hr_utility.trace('lv_prov_of_emp :'||substr(ln_serial_number,1,2));
976: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
977: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
978:
979:

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

972: set aa.serial_number = ln_serial_number
973: where aa.assignment_action_id = ln_rl2_cancel_asg_action;
974:
975: hr_utility.trace('lv_prov_of_emp :'||substr(ln_serial_number,1,2));
976: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
977: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
978:
979:
980: --Added to lock the PDF Report Run

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

973: where aa.assignment_action_id = ln_rl2_cancel_asg_action;
974:
975: hr_utility.trace('lv_prov_of_emp :'||substr(ln_serial_number,1,2));
976: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
977: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
978:
979:
980: --Added to lock the PDF Report Run
981: hr_nonrun_asact.insint(ln_rl2_cancel_asg_action,ln_rep_act_to_lock);

Line 982: hr_utility.trace('Locking the PDF Assignment Action');

978:
979:
980: --Added to lock the PDF Report Run
981: hr_nonrun_asact.insint(ln_rl2_cancel_asg_action,ln_rep_act_to_lock);
982: hr_utility.trace('Locking the PDF Assignment Action');
983: hr_utility.trace('Locking Action'||ln_rl2_cancel_asg_action);
984: hr_utility.trace('Locked Action = ' || to_char(ln_rep_act_to_lock));
985:
986: --Added to lock the Archiver

Line 983: hr_utility.trace('Locking Action'||ln_rl2_cancel_asg_action);

979:
980: --Added to lock the PDF Report Run
981: hr_nonrun_asact.insint(ln_rl2_cancel_asg_action,ln_rep_act_to_lock);
982: hr_utility.trace('Locking the PDF Assignment Action');
983: hr_utility.trace('Locking Action'||ln_rl2_cancel_asg_action);
984: hr_utility.trace('Locked Action = ' || to_char(ln_rep_act_to_lock));
985:
986: --Added to lock the Archiver
987: hr_nonrun_asact.insint(ln_rl2_cancel_asg_action,ln_arch_act_to_lock);

Line 984: hr_utility.trace('Locked Action = ' || to_char(ln_rep_act_to_lock));

980: --Added to lock the PDF Report Run
981: hr_nonrun_asact.insint(ln_rl2_cancel_asg_action,ln_rep_act_to_lock);
982: hr_utility.trace('Locking the PDF Assignment Action');
983: hr_utility.trace('Locking Action'||ln_rl2_cancel_asg_action);
984: hr_utility.trace('Locked Action = ' || to_char(ln_rep_act_to_lock));
985:
986: --Added to lock the Archiver
987: hr_nonrun_asact.insint(ln_rl2_cancel_asg_action,ln_arch_act_to_lock);
988: hr_utility.trace('Locking the Archiver Assignment Action');

Line 988: hr_utility.trace('Locking the Archiver Assignment Action');

984: hr_utility.trace('Locked Action = ' || to_char(ln_rep_act_to_lock));
985:
986: --Added to lock the Archiver
987: hr_nonrun_asact.insint(ln_rl2_cancel_asg_action,ln_arch_act_to_lock);
988: hr_utility.trace('Locking the Archiver Assignment Action');
989: hr_utility.trace('Locking Action'||ln_rl2_cancel_asg_action);
990: hr_utility.trace('Locked Action = ' || to_char(ln_arch_act_to_lock));
991:
992: end if; -- pay_us_employee_payslip_web.get_doc_eit

Line 989: hr_utility.trace('Locking Action'||ln_rl2_cancel_asg_action);

985:
986: --Added to lock the Archiver
987: hr_nonrun_asact.insint(ln_rl2_cancel_asg_action,ln_arch_act_to_lock);
988: hr_utility.trace('Locking the Archiver Assignment Action');
989: hr_utility.trace('Locking Action'||ln_rl2_cancel_asg_action);
990: hr_utility.trace('Locked Action = ' || to_char(ln_arch_act_to_lock));
991:
992: end if; -- pay_us_employee_payslip_web.get_doc_eit
993:

Line 990: hr_utility.trace('Locked Action = ' || to_char(ln_arch_act_to_lock));

986: --Added to lock the Archiver
987: hr_nonrun_asact.insint(ln_rl2_cancel_asg_action,ln_arch_act_to_lock);
988: hr_utility.trace('Locking the Archiver Assignment Action');
989: hr_utility.trace('Locking Action'||ln_rl2_cancel_asg_action);
990: hr_utility.trace('Locked Action = ' || to_char(ln_arch_act_to_lock));
991:
992: end if; -- pay_us_employee_payslip_web.get_doc_eit
993:
994: end if; /* get_latest_rl2_cancel_dtls found*/

Line 1049: hr_utility.trace('get_reprint_rl2_cancel_dtls not found');

1045: fetch get_warning_dtls_for_ee into lv_full_name
1046: ,lv_employee_number;
1047: close get_warning_dtls_for_ee;
1048:
1049: hr_utility.trace('get_reprint_rl2_cancel_dtls not found');
1050: hr_utility.trace('p_person_id :'||to_char(p_person_id));
1051:
1052: lv_record_name := 'rl2 cancel PDF Report';
1053: lv_message := 'As rl2 Cancel PDF was not run in Unprint Mode, Reprint mode will not be applicable';

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

1046: ,lv_employee_number;
1047: close get_warning_dtls_for_ee;
1048:
1049: hr_utility.trace('get_reprint_rl2_cancel_dtls not found');
1050: hr_utility.trace('p_person_id :'||to_char(p_person_id));
1051:
1052: lv_record_name := 'rl2 cancel PDF Report';
1053: lv_message := 'As rl2 Cancel PDF was not run in Unprint Mode, Reprint mode will not be applicable';
1054:

Line 1081: hr_utility.trace('get_reprint_rl2amendpdf_dtls found ');

1077: 'ASSIGNMENT',
1078: ln_primary_assignment_id,
1079: l_effective_end_date),'Y') = 'Y' then
1080: /* Create an assignment action for this person */
1081: hr_utility.trace('get_reprint_rl2amendpdf_dtls found ');
1082: hr_utility.trace('Report Type: '||lv_report_type);
1083:
1084: select pay_assignment_actions_s.nextval
1085: into ln_rl2_cancel_asg_action

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

1078: ln_primary_assignment_id,
1079: l_effective_end_date),'Y') = 'Y' then
1080: /* Create an assignment action for this person */
1081: hr_utility.trace('get_reprint_rl2amendpdf_dtls found ');
1082: hr_utility.trace('Report Type: '||lv_report_type);
1083:
1084: select pay_assignment_actions_s.nextval
1085: into ln_rl2_cancel_asg_action
1086: from dual;

Line 1088: hr_utility.trace('New rl2 Cancel Action = ' ||

1084: select pay_assignment_actions_s.nextval
1085: into ln_rl2_cancel_asg_action
1086: from dual;
1087:
1088: hr_utility.trace('New rl2 Cancel Action = ' ||
1089: to_char(ln_rl2_cancel_asg_action));
1090:
1091: /* Insert into pay_assignment_actions. */
1092: hr_nonrun_asact.insact(ln_rl2_cancel_asg_action

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

1112:
1113: update pay_assignment_actions aa
1114: set aa.serial_number = ln_serial_number
1115: where aa.assignment_action_id = ln_rl2_cancel_asg_action;
1116: hr_utility.trace('lv_prov_of_emp :'||substr(ln_serial_number,1,2));
1117: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
1118: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
1119: end if; -- pay_us_employee_payslip_web.get_doc_eit
1120:

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

1113: update pay_assignment_actions aa
1114: set aa.serial_number = ln_serial_number
1115: where aa.assignment_action_id = ln_rl2_cancel_asg_action;
1116: hr_utility.trace('lv_prov_of_emp :'||substr(ln_serial_number,1,2));
1117: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
1118: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
1119: end if; -- pay_us_employee_payslip_web.get_doc_eit
1120:
1121: end if; /* get_reprint_rl2amendpdf_dtls found*/

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

1114: set aa.serial_number = ln_serial_number
1115: where aa.assignment_action_id = ln_rl2_cancel_asg_action;
1116: hr_utility.trace('lv_prov_of_emp :'||substr(ln_serial_number,1,2));
1117: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
1118: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
1119: end if; -- pay_us_employee_payslip_web.get_doc_eit
1120:
1121: end if; /* get_reprint_rl2amendpdf_dtls found*/
1122:

Line 1132: hr_utility.trace('Leaving action_creation');

1128: close get_reprint_rl2_cancel_dtls;
1129: end if;
1130:
1131: end if; --REPRINT
1132: hr_utility.trace('Leaving action_creation');
1133:
1134: END action_creation;
1135:
1136: BEGIN

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

1133:
1134: END action_creation;
1135:
1136: BEGIN
1137: hr_utility.trace('Entered action_creation ');
1138: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
1139: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
1140: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
1141: hr_utility.trace('p_chunk = ' || to_char(p_chunk));

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

1134: END action_creation;
1135:
1136: BEGIN
1137: hr_utility.trace('Entered action_creation ');
1138: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
1139: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
1140: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
1141: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
1142:

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

1135:
1136: BEGIN
1137: hr_utility.trace('Entered action_creation ');
1138: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
1139: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
1140: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
1141: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
1142:
1143: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id

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

1136: BEGIN
1137: hr_utility.trace('Entered action_creation ');
1138: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
1139: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
1140: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
1141: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
1142:
1143: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
1144: ,p_start_date => ld_start_date

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

1137: hr_utility.trace('Entered action_creation ');
1138: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
1139: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
1140: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
1141: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
1142:
1143: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
1144: ,p_start_date => ld_start_date
1145: ,p_end_date => ld_end_date

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

1153: ,p_report_qualifier => l_state
1154: ,p_report_category => l_report_cat
1155: ,p_print_term => l_print_term);
1156:
1157: hr_utility.trace('lv_ppr_report_type: '||lv_ppr_report_type);
1158:
1159: ln_tax_unit_id := ln_pre_parameter;
1160:
1161: -- Code modification for bug 10399514 starts here

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

1173: When Others Then
1174: l_report_format := Null ;
1175: End ;
1176:
1177: hr_utility.trace('l_report_format: '||l_report_format);
1178: hr_utility.trace('lv_ppr_report_type: '||lv_ppr_report_type);
1179: hr_utility.trace('l_state '||l_state);
1180: hr_utility.trace('l_report_cat: '||l_report_cat);
1181: l_person_on := pay_ac_utility.range_person_on( p_report_type => lv_ppr_report_type,

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

1174: l_report_format := Null ;
1175: End ;
1176:
1177: hr_utility.trace('l_report_format: '||l_report_format);
1178: hr_utility.trace('lv_ppr_report_type: '||lv_ppr_report_type);
1179: hr_utility.trace('l_state '||l_state);
1180: hr_utility.trace('l_report_cat: '||l_report_cat);
1181: l_person_on := pay_ac_utility.range_person_on( p_report_type => lv_ppr_report_type,
1182: p_report_format => l_report_format,

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

1175: End ;
1176:
1177: hr_utility.trace('l_report_format: '||l_report_format);
1178: hr_utility.trace('lv_ppr_report_type: '||lv_ppr_report_type);
1179: hr_utility.trace('l_state '||l_state);
1180: hr_utility.trace('l_report_cat: '||l_report_cat);
1181: l_person_on := pay_ac_utility.range_person_on( p_report_type => lv_ppr_report_type,
1182: p_report_format => l_report_format,
1183: p_report_qualifier => l_state,

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

1176:
1177: hr_utility.trace('l_report_format: '||l_report_format);
1178: hr_utility.trace('lv_ppr_report_type: '||lv_ppr_report_type);
1179: hr_utility.trace('l_state '||l_state);
1180: hr_utility.trace('l_report_cat: '||l_report_cat);
1181: l_person_on := pay_ac_utility.range_person_on( p_report_type => lv_ppr_report_type,
1182: p_report_format => l_report_format,
1183: p_report_qualifier => l_state,
1184: p_report_category => l_report_cat) ;

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

1187: if ln_person_id is not null then
1188: action_creation(p_start_person_id);
1189:
1190: elsif ln_asg_set is not null then
1191: hr_utility.trace('Entered Asg Set logic');
1192: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
1193: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1194: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1195: -- Added for Bug# 10399514

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

1188: action_creation(p_start_person_id);
1189:
1190: elsif ln_asg_set is not null then
1191: hr_utility.trace('Entered Asg Set logic');
1192: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
1193: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1194: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1195: -- Added for Bug# 10399514
1196: if l_person_on then

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

1189:
1190: elsif ln_asg_set is not null then
1191: hr_utility.trace('Entered Asg Set logic');
1192: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
1193: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1194: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1195: -- Added for Bug# 10399514
1196: if l_person_on then
1197: open c_selected_asg_set_range(p_start_person_id

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

1190: elsif ln_asg_set is not null then
1191: hr_utility.trace('Entered Asg Set logic');
1192: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
1193: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1194: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1195: -- Added for Bug# 10399514
1196: if l_person_on then
1197: open c_selected_asg_set_range(p_start_person_id
1198: ,p_end_person_id

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

1197: open c_selected_asg_set_range(p_start_person_id
1198: ,p_end_person_id
1199: ,ln_asg_set
1200: ,ld_end_date);
1201: hr_utility.trace('Opened cusor c_selected_asg_set_range');
1202: else
1203: open c_selected_asg_set (p_start_person_id
1204: ,p_end_person_id
1205: ,ln_asg_set

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

1203: open c_selected_asg_set (p_start_person_id
1204: ,p_end_person_id
1205: ,ln_asg_set
1206: ,ld_end_date);
1207: hr_utility.trace('Opened cusor c_selected_asg_set');
1208: end if;
1209: loop
1210: -- Added for Bug# 10399514
1211: if l_person_on then

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

1210: -- Added for Bug# 10399514
1211: if l_person_on then
1212: fetch c_selected_asg_set_range into ln_set_person_id;
1213: if c_selected_asg_set_range%notfound then
1214: hr_utility.trace('c_selected_asg_set_range not found ');
1215: hr_utility.trace('No Person found for reporting in this chunk');
1216: exit;
1217: end if;
1218: else

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

1211: if l_person_on then
1212: fetch c_selected_asg_set_range into ln_set_person_id;
1213: if c_selected_asg_set_range%notfound then
1214: hr_utility.trace('c_selected_asg_set_range not found ');
1215: hr_utility.trace('No Person found for reporting in this chunk');
1216: exit;
1217: end if;
1218: else
1219: fetch c_selected_asg_set into ln_set_person_id;

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

1217: end if;
1218: else
1219: fetch c_selected_asg_set into ln_set_person_id;
1220: if c_selected_asg_set%notfound then
1221: hr_utility.trace('c_selected_asg_set not found ');
1222: hr_utility.trace('No Person found for reporting in this chunk');
1223: exit;
1224: end if;
1225: end if; --ends 10399514

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

1218: else
1219: fetch c_selected_asg_set into ln_set_person_id;
1220: if c_selected_asg_set%notfound then
1221: hr_utility.trace('c_selected_asg_set not found ');
1222: hr_utility.trace('No Person found for reporting in this chunk');
1223: exit;
1224: end if;
1225: end if; --ends 10399514
1226:

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

1233: end if;
1234:
1235: elsif ln_tax_unit_id is not null then
1236:
1237: hr_utility.trace('Entered PRE not null logic');
1238: hr_utility.trace('PRE ='||to_char(ln_tax_unit_id));
1239: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1240: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1241:

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

1234:
1235: elsif ln_tax_unit_id is not null then
1236:
1237: hr_utility.trace('Entered PRE not null logic');
1238: hr_utility.trace('PRE ='||to_char(ln_tax_unit_id));
1239: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1240: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1241:
1242: -- Added for Bug# 10399514

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

1235: elsif ln_tax_unit_id is not null then
1236:
1237: hr_utility.trace('Entered PRE not null logic');
1238: hr_utility.trace('PRE ='||to_char(ln_tax_unit_id));
1239: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1240: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1241:
1242: -- Added for Bug# 10399514
1243: if l_person_on then

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

1236:
1237: hr_utility.trace('Entered PRE not null logic');
1238: hr_utility.trace('PRE ='||to_char(ln_tax_unit_id));
1239: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1240: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1241:
1242: -- Added for Bug# 10399514
1243: if l_person_on then
1244: open c_all_asg_range(ln_business_group_id,

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

1245: ln_tax_unit_id,
1246: ld_end_date,
1247: p_start_person_id,
1248: p_end_person_id);
1249: hr_utility.trace('Opened cusor c_all_asg_range');
1250: else
1251: open c_all_asg (ln_business_group_id,
1252: ln_tax_unit_id,
1253: ld_end_date,

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

1252: ln_tax_unit_id,
1253: ld_end_date,
1254: p_start_person_id,
1255: p_end_person_id);
1256: hr_utility.trace('Opened cusor c_all_asg');
1257: end if;
1258:
1259: loop
1260: -- Added for Bug# 10399514

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

1260: -- Added for Bug# 10399514
1261: if l_person_on then
1262: fetch c_all_asg_range into ln_set_person_id;
1263: if c_all_asg_range%notfound then
1264: hr_utility.trace('c_all_asg_range not found ');
1265: hr_utility.trace('No Person found for reporting in this chunk');
1266: exit;
1267: end if;
1268: else

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

1261: if l_person_on then
1262: fetch c_all_asg_range into ln_set_person_id;
1263: if c_all_asg_range%notfound then
1264: hr_utility.trace('c_all_asg_range not found ');
1265: hr_utility.trace('No Person found for reporting in this chunk');
1266: exit;
1267: end if;
1268: else
1269: fetch c_all_asg into ln_set_person_id;

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

1267: end if;
1268: else
1269: fetch c_all_asg into ln_set_person_id;
1270: if c_all_asg%notfound then
1271: hr_utility.trace('c_all_asg not found ');
1272: hr_utility.trace('No Person found for reporting in this chunk');
1273: exit;
1274: end if;
1275: end if;

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

1268: else
1269: fetch c_all_asg into ln_set_person_id;
1270: if c_all_asg%notfound then
1271: hr_utility.trace('c_all_asg not found ');
1272: hr_utility.trace('No Person found for reporting in this chunk');
1273: exit;
1274: end if;
1275: end if;
1276:

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

1283: end if;
1284:
1285: else
1286:
1287: hr_utility.trace('Entered All PRE logic');
1288:
1289: open c_all_pres(ln_business_group_id,
1290: ld_end_date);
1291:

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

1292: loop -- c_all_pres
1293:
1294: fetch c_all_pres into ln_pre_id;
1295: if c_all_pres%NOTFOUND then
1296: hr_utility.trace('c_all_pres NOT FOUND');
1297: exit;
1298: end if;
1299:
1300: hr_utility.trace('PRE ='||to_char(ln_pre_id));

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

1296: hr_utility.trace('c_all_pres NOT FOUND');
1297: exit;
1298: end if;
1299:
1300: hr_utility.trace('PRE ='||to_char(ln_pre_id));
1301: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1302: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1303: -- Added for Bug# 10399514
1304: if l_person_on then

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

1297: exit;
1298: end if;
1299:
1300: hr_utility.trace('PRE ='||to_char(ln_pre_id));
1301: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1302: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1303: -- Added for Bug# 10399514
1304: if l_person_on then
1305: open c_all_asg_range(ln_business_group_id,

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

1298: end if;
1299:
1300: hr_utility.trace('PRE ='||to_char(ln_pre_id));
1301: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1302: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1303: -- Added for Bug# 10399514
1304: if l_person_on then
1305: open c_all_asg_range(ln_business_group_id,
1306: ln_pre_id,

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

1306: ln_pre_id,
1307: ld_end_date,
1308: p_start_person_id,
1309: p_end_person_id);
1310: hr_utility.trace('Opened cusor c_all_asg_range');
1311: else
1312: open c_all_asg (ln_business_group_id,
1313: ln_pre_id,
1314: ld_end_date,

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

1313: ln_pre_id,
1314: ld_end_date,
1315: p_start_person_id,
1316: p_end_person_id);
1317: hr_utility.trace('Opened cusor c_all_asg');
1318: end if;
1319:
1320: loop -- c_all_asg
1321: -- Added for Bug# 10399514

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

1321: -- Added for Bug# 10399514
1322: if l_person_on then
1323: fetch c_all_asg_range into ln_set_person_id;
1324: if c_all_asg_range%notfound then
1325: hr_utility.trace('c_all_asg_range not found ');
1326: hr_utility.trace('No Person found for reporting in this chunk');
1327: exit;
1328: end if;
1329: else

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

1322: if l_person_on then
1323: fetch c_all_asg_range into ln_set_person_id;
1324: if c_all_asg_range%notfound then
1325: hr_utility.trace('c_all_asg_range not found ');
1326: hr_utility.trace('No Person found for reporting in this chunk');
1327: exit;
1328: end if;
1329: else
1330: fetch c_all_asg into ln_set_person_id;

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

1328: end if;
1329: else
1330: fetch c_all_asg into ln_set_person_id;
1331: if c_all_asg%notfound then
1332: hr_utility.trace('c_all_asg not found ');
1333: hr_utility.trace('No Person found for reporting in this chunk');
1334: exit;
1335: end if;
1336: end if;

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

1329: else
1330: fetch c_all_asg into ln_set_person_id;
1331: if c_all_asg%notfound then
1332: hr_utility.trace('c_all_asg not found ');
1333: hr_utility.trace('No Person found for reporting in this chunk');
1334: exit;
1335: end if;
1336: end if;
1337:

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

1402: from pay_payroll_actions ppa
1403: where ppa.payroll_action_id = payactid;
1404:
1405: exception when no_data_found then
1406: hr_utility.trace('Error in Sort Procedure - getting legislative param');
1407: raise;
1408:
1409: end;
1410:

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

1411: if l_year_end > l_dt then
1412: l_dt := l_year_end;
1413: end if;
1414:
1415: hr_utility.trace('Beginning of the sort_action cursor');
1416:
1417: sqlstr := 'select paa1.rowid
1418: from hr_all_organization_units hou,
1419: hr_all_organization_units hou1,

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

1461: ppf.last_name,first_name';
1462:
1463:
1464: len := length(sqlstr); -- return the length of the string.
1465: hr_utility.trace('End of the sort_Action cursor');
1466:
1467: end sort_action;
1468:
1469:

Line 1503: -- hr_utility.trace_on(null,'rl2_cancel_PDF');

1499:
1500: END get_parameter;
1501: Begin
1502:
1503: -- hr_utility.trace_on(null,'rl2_cancel_PDF');
1504: null;
1505: end pay_ca_eoy_rl2_cancel_pkg;