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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 130: raise hr_utility.hr_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 231: raise hr_utility.hr_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

814: l_effective_end_date date; --Added for bug 15886428
815:
816: BEGIN
817:
818: hr_utility.trace('Inside action_creation');
819:
820: if lv_print = 'LATEST' then
821: if nvl(l_print_term,'N') = 'Y' then
822: open get_latest_rl1_cancelled_term(p_person_id

Line 862: hr_utility.trace('get_latest_rl1_cancelled_dtls not found');

858: fetch get_warning_dtls_for_ee into lv_full_name
859: ,lv_employee_number;
860: close get_warning_dtls_for_ee;
861:
862: hr_utility.trace('get_latest_rl1_cancelled_dtls not found');
863: hr_utility.trace('p_person_id :'||to_char(p_person_id));
864:
865: lv_record_name := 'RL1 Cancelled PDF Report';
866: lv_message := 'Either RL1 PDF or RL1 Amendment PDF were not run for the employee';

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

859: ,lv_employee_number;
860: close get_warning_dtls_for_ee;
861:
862: hr_utility.trace('get_latest_rl1_cancelled_dtls not found');
863: hr_utility.trace('p_person_id :'||to_char(p_person_id));
864:
865: lv_record_name := 'RL1 Cancelled PDF Report';
866: lv_message := 'Either RL1 PDF or RL1 Amendment PDF were not run for the employee';
867:

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

881:
882: if (nvl(l_print_term,'N') = 'Y' and get_latest_rl1_cancelled_term%found)
883: or (nvl(l_print_term,'N') = 'N' and get_latest_rl1_cancelled_dtls%found) then
884:
885: hr_utility.trace('ln_arch_act_to_lock:'||ln_arch_act_to_lock);
886:
887: open check_arch_action_exists(ln_arch_act_to_lock);
888: fetch check_arch_action_exists into l_arch_asg_action_check;
889: if check_arch_action_exists%notfound then

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

892: fetch get_warning_dtls_for_ee into lv_full_name
893: ,lv_employee_number;
894: close get_warning_dtls_for_ee;
895:
896: hr_utility.trace('check_arch_action_exists not found');
897: hr_utility.trace('p_person_id :'||to_char(p_person_id));
898: hr_utility.trace('ln_arch_act_to_lock :'||to_char(ln_arch_act_to_lock));
899: hr_utility.trace('lv_report_type :'||lv_report_type);
900: hr_utility.trace('ln_rep_act_to_lock :'||ln_rep_act_to_lock);

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

893: ,lv_employee_number;
894: close get_warning_dtls_for_ee;
895:
896: hr_utility.trace('check_arch_action_exists not found');
897: hr_utility.trace('p_person_id :'||to_char(p_person_id));
898: hr_utility.trace('ln_arch_act_to_lock :'||to_char(ln_arch_act_to_lock));
899: hr_utility.trace('lv_report_type :'||lv_report_type);
900: hr_utility.trace('ln_rep_act_to_lock :'||ln_rep_act_to_lock);
901: lv_record_name := 'RL1 Cancelled PDF Report';

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

894: close get_warning_dtls_for_ee;
895:
896: hr_utility.trace('check_arch_action_exists not found');
897: hr_utility.trace('p_person_id :'||to_char(p_person_id));
898: hr_utility.trace('ln_arch_act_to_lock :'||to_char(ln_arch_act_to_lock));
899: hr_utility.trace('lv_report_type :'||lv_report_type);
900: hr_utility.trace('ln_rep_act_to_lock :'||ln_rep_act_to_lock);
901: lv_record_name := 'RL1 Cancelled PDF Report';
902: lv_message := 'Archiver run with assignment action id '||ln_arch_act_to_lock||' is rolled back';

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

895:
896: hr_utility.trace('check_arch_action_exists not found');
897: hr_utility.trace('p_person_id :'||to_char(p_person_id));
898: hr_utility.trace('ln_arch_act_to_lock :'||to_char(ln_arch_act_to_lock));
899: hr_utility.trace('lv_report_type :'||lv_report_type);
900: hr_utility.trace('ln_rep_act_to_lock :'||ln_rep_act_to_lock);
901: lv_record_name := 'RL1 Cancelled PDF Report';
902: lv_message := 'Archiver run with assignment action id '||ln_arch_act_to_lock||' is rolled back';
903:

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

896: hr_utility.trace('check_arch_action_exists not found');
897: hr_utility.trace('p_person_id :'||to_char(p_person_id));
898: hr_utility.trace('ln_arch_act_to_lock :'||to_char(ln_arch_act_to_lock));
899: hr_utility.trace('lv_report_type :'||lv_report_type);
900: hr_utility.trace('ln_rep_act_to_lock :'||ln_rep_act_to_lock);
901: lv_record_name := 'RL1 Cancelled PDF Report';
902: lv_message := 'Archiver run with assignment action id '||ln_arch_act_to_lock||' is rolled back';
903:
904: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','I');

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

912: --Negative employeess
913: lv_negative_bal_flag := nvl(pay_ca_archive_utils.get_archive_value(substr(ln_serial_number,3,14),
914: substr(ln_serial_number,1,2),'JURISDICTION_CODE',
915: 'CAEOY_RL1_NEGATIVE_BALANCE_EXISTS'),'N');
916: hr_utility.trace('lv_negative_bal_flag '||lv_negative_bal_flag);
917: if lv_negative_bal_flag = 'Y' then
918: open get_warning_dtls_for_ee(p_person_id);
919: fetch get_warning_dtls_for_ee into lv_full_name
920: ,lv_employee_number;

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

919: fetch get_warning_dtls_for_ee into lv_full_name
920: ,lv_employee_number;
921: close get_warning_dtls_for_ee;
922:
923: hr_utility.trace('Negative_bal_flag is Y');
924: hr_utility.trace('p_person_id :'||to_char(p_person_id));
925:
926: lv_record_name := 'RL1 Cancelled PDF Report';
927: lv_message := 'This employee has negative balance';

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

920: ,lv_employee_number;
921: close get_warning_dtls_for_ee;
922:
923: hr_utility.trace('Negative_bal_flag is Y');
924: hr_utility.trace('p_person_id :'||to_char(p_person_id));
925:
926: lv_record_name := 'RL1 Cancelled PDF Report';
927: lv_message := 'This employee has negative balance';
928:

Line 940: hr_utility.trace('get_latest_rl1_cancelled_dtls found ');

936: ln_tax_unit_id := ln_pre_id_null;
937: end if;
938:
939: /* Create an assignment action for this person */
940: hr_utility.trace('get_latest_rl1_cancelled_dtls found ');
941: hr_utility.trace('Report Type: '||lv_report_type);
942:
943: if nvl(pay_us_employee_payslip_web.get_doc_eit('RL1PDF',
944: 'PRINT',

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

937: end if;
938:
939: /* Create an assignment action for this person */
940: hr_utility.trace('get_latest_rl1_cancelled_dtls found ');
941: hr_utility.trace('Report Type: '||lv_report_type);
942:
943: if nvl(pay_us_employee_payslip_web.get_doc_eit('RL1PDF',
944: 'PRINT',
945: 'ASSIGNMENT',

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

948: select pay_assignment_actions_s.nextval
949: into ln_rl1_cancelled_asg_action
950: from dual;
951:
952: hr_utility.trace('New RL1 Amend Action = ' ||
953: to_char(ln_rl1_cancelled_asg_action));
954:
955: /* Insert into pay_assignment_actions. */
956: hr_nonrun_asact.insact(ln_rl1_cancelled_asg_action

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

984: update pay_assignment_actions aa
985: set aa.serial_number = ln_serial_number
986: where aa.assignment_action_id = ln_rl1_cancelled_asg_action;
987:
988: hr_utility.trace('lv_prov_of_emp :'||substr(ln_serial_number,1,2));
989: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
990: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
991:
992:

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

985: set aa.serial_number = ln_serial_number
986: where aa.assignment_action_id = ln_rl1_cancelled_asg_action;
987:
988: hr_utility.trace('lv_prov_of_emp :'||substr(ln_serial_number,1,2));
989: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
990: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
991:
992:
993: --Added to lock the PDF Report Run

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

986: where aa.assignment_action_id = ln_rl1_cancelled_asg_action;
987:
988: hr_utility.trace('lv_prov_of_emp :'||substr(ln_serial_number,1,2));
989: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
990: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
991:
992:
993: --Added to lock the PDF Report Run
994: hr_nonrun_asact.insint(ln_rl1_cancelled_asg_action,ln_rep_act_to_lock);

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

991:
992:
993: --Added to lock the PDF Report Run
994: hr_nonrun_asact.insint(ln_rl1_cancelled_asg_action,ln_rep_act_to_lock);
995: hr_utility.trace('Locking the PDF Assignment Action');
996: hr_utility.trace('Locking Action'||ln_rl1_cancelled_asg_action);
997: hr_utility.trace('Locked Action = ' || to_char(ln_rep_act_to_lock));
998:
999: --Added to lock the Archiver

Line 996: hr_utility.trace('Locking Action'||ln_rl1_cancelled_asg_action);

992:
993: --Added to lock the PDF Report Run
994: hr_nonrun_asact.insint(ln_rl1_cancelled_asg_action,ln_rep_act_to_lock);
995: hr_utility.trace('Locking the PDF Assignment Action');
996: hr_utility.trace('Locking Action'||ln_rl1_cancelled_asg_action);
997: hr_utility.trace('Locked Action = ' || to_char(ln_rep_act_to_lock));
998:
999: --Added to lock the Archiver
1000: hr_nonrun_asact.insint(ln_rl1_cancelled_asg_action,ln_arch_act_to_lock);

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

993: --Added to lock the PDF Report Run
994: hr_nonrun_asact.insint(ln_rl1_cancelled_asg_action,ln_rep_act_to_lock);
995: hr_utility.trace('Locking the PDF Assignment Action');
996: hr_utility.trace('Locking Action'||ln_rl1_cancelled_asg_action);
997: hr_utility.trace('Locked Action = ' || to_char(ln_rep_act_to_lock));
998:
999: --Added to lock the Archiver
1000: hr_nonrun_asact.insint(ln_rl1_cancelled_asg_action,ln_arch_act_to_lock);
1001: hr_utility.trace('Locking the Archiver Assignment Action');

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

997: hr_utility.trace('Locked Action = ' || to_char(ln_rep_act_to_lock));
998:
999: --Added to lock the Archiver
1000: hr_nonrun_asact.insint(ln_rl1_cancelled_asg_action,ln_arch_act_to_lock);
1001: hr_utility.trace('Locking the Archiver Assignment Action');
1002: hr_utility.trace('Locking Action'||ln_rl1_cancelled_asg_action);
1003: hr_utility.trace('Locked Action = ' || to_char(ln_arch_act_to_lock));
1004: end if; --pay_us_employee_payslip_web.get_doc_eit
1005:

Line 1002: hr_utility.trace('Locking Action'||ln_rl1_cancelled_asg_action);

998:
999: --Added to lock the Archiver
1000: hr_nonrun_asact.insint(ln_rl1_cancelled_asg_action,ln_arch_act_to_lock);
1001: hr_utility.trace('Locking the Archiver Assignment Action');
1002: hr_utility.trace('Locking Action'||ln_rl1_cancelled_asg_action);
1003: hr_utility.trace('Locked Action = ' || to_char(ln_arch_act_to_lock));
1004: end if; --pay_us_employee_payslip_web.get_doc_eit
1005:
1006: end if; /* get_latest_rl1_cancelled_dtls found*/

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

999: --Added to lock the Archiver
1000: hr_nonrun_asact.insint(ln_rl1_cancelled_asg_action,ln_arch_act_to_lock);
1001: hr_utility.trace('Locking the Archiver Assignment Action');
1002: hr_utility.trace('Locking Action'||ln_rl1_cancelled_asg_action);
1003: hr_utility.trace('Locked Action = ' || to_char(ln_arch_act_to_lock));
1004: end if; --pay_us_employee_payslip_web.get_doc_eit
1005:
1006: end if; /* get_latest_rl1_cancelled_dtls found*/
1007:

Line 1061: hr_utility.trace('get_reprint_rl1_cancelled_dtls not found');

1057: fetch get_warning_dtls_for_ee into lv_full_name
1058: ,lv_employee_number;
1059: close get_warning_dtls_for_ee;
1060:
1061: hr_utility.trace('get_reprint_rl1_cancelled_dtls not found');
1062: hr_utility.trace('p_person_id :'||to_char(p_person_id));
1063:
1064: lv_record_name := 'RL1 Cancelled PDF Report';
1065: lv_message := 'As RL1 Cancel PDF was not run in Unprint Mode, Reprint mode will not be applicable';

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

1058: ,lv_employee_number;
1059: close get_warning_dtls_for_ee;
1060:
1061: hr_utility.trace('get_reprint_rl1_cancelled_dtls not found');
1062: hr_utility.trace('p_person_id :'||to_char(p_person_id));
1063:
1064: lv_record_name := 'RL1 Cancelled PDF Report';
1065: lv_message := 'As RL1 Cancel PDF was not run in Unprint Mode, Reprint mode will not be applicable';
1066:

Line 1089: hr_utility.trace('get_reprint_RL1amendpdf_dtls found ');

1085: end if;
1086:
1087:
1088: /* Create an assignment action for this person */
1089: hr_utility.trace('get_reprint_RL1amendpdf_dtls found ');
1090: hr_utility.trace('Report Type: '||lv_report_type);
1091:
1092: if nvl(pay_us_employee_payslip_web.get_doc_eit('RL1PDF',
1093: 'PRINT',

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

1086:
1087:
1088: /* Create an assignment action for this person */
1089: hr_utility.trace('get_reprint_RL1amendpdf_dtls found ');
1090: hr_utility.trace('Report Type: '||lv_report_type);
1091:
1092: if nvl(pay_us_employee_payslip_web.get_doc_eit('RL1PDF',
1093: 'PRINT',
1094: 'ASSIGNMENT',

Line 1101: hr_utility.trace('New RL1 Cancel Action = ' ||

1097: select pay_assignment_actions_s.nextval
1098: into ln_rl1_cancelled_asg_action
1099: from dual;
1100:
1101: hr_utility.trace('New RL1 Cancel Action = ' ||
1102: to_char(ln_rl1_cancelled_asg_action));
1103:
1104: /* Insert into pay_assignment_actions. */
1105: hr_nonrun_asact.insact(ln_rl1_cancelled_asg_action

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

1129:
1130: update pay_assignment_actions aa
1131: set aa.serial_number = ln_serial_number
1132: where aa.assignment_action_id = ln_rl1_cancelled_asg_action;
1133: hr_utility.trace('lv_prov_of_emp :'||substr(ln_serial_number,1,2));
1134: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
1135: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
1136: end if; --pay_us_employee_payslip_web.get_doc_eit
1137:

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

1130: update pay_assignment_actions aa
1131: set aa.serial_number = ln_serial_number
1132: where aa.assignment_action_id = ln_rl1_cancelled_asg_action;
1133: hr_utility.trace('lv_prov_of_emp :'||substr(ln_serial_number,1,2));
1134: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
1135: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
1136: end if; --pay_us_employee_payslip_web.get_doc_eit
1137:
1138: end if; /* get_reprint_RL1amendpdf_dtls found*/

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

1131: set aa.serial_number = ln_serial_number
1132: where aa.assignment_action_id = ln_rl1_cancelled_asg_action;
1133: hr_utility.trace('lv_prov_of_emp :'||substr(ln_serial_number,1,2));
1134: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
1135: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
1136: end if; --pay_us_employee_payslip_web.get_doc_eit
1137:
1138: end if; /* get_reprint_RL1amendpdf_dtls found*/
1139:

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

1145: close get_reprint_rl1_cancelled_dtls;
1146: end if;
1147:
1148: end if; --REPRINT
1149: hr_utility.trace('Leaving action_creation');
1150:
1151: END action_creation;
1152:
1153: BEGIN

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

1150:
1151: END action_creation;
1152:
1153: BEGIN
1154: hr_utility.trace('Entered action_creation ');
1155: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
1156: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
1157: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
1158: hr_utility.trace('p_chunk = ' || to_char(p_chunk));

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

1151: END action_creation;
1152:
1153: BEGIN
1154: hr_utility.trace('Entered action_creation ');
1155: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
1156: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
1157: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
1158: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
1159:

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

1152:
1153: BEGIN
1154: hr_utility.trace('Entered action_creation ');
1155: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
1156: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
1157: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
1158: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
1159:
1160: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id

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

1153: BEGIN
1154: hr_utility.trace('Entered action_creation ');
1155: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
1156: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
1157: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
1158: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
1159:
1160: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
1161: ,p_start_date => ld_start_date

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

1154: hr_utility.trace('Entered action_creation ');
1155: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
1156: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
1157: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
1158: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
1159:
1160: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
1161: ,p_start_date => ld_start_date
1162: ,p_end_date => ld_end_date

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

1170: ,p_report_qualifier => l_state
1171: ,p_report_category => l_report_cat
1172: ,p_print_term => l_print_term);
1173:
1174: hr_utility.trace('lv_ppr_report_type: '||lv_ppr_report_type);
1175:
1176:
1177: ln_tax_unit_id := ln_pre_parameter;
1178:

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

1191: When Others Then
1192: l_report_format := Null ;
1193: End ;
1194:
1195: hr_utility.trace('l_report_format: '||l_report_format);
1196: hr_utility.trace('lv_ppr_report_type: '||lv_ppr_report_type);
1197: hr_utility.trace('l_state '||l_state);
1198: hr_utility.trace('l_report_cat: '||l_report_cat);
1199: l_person_on := pay_ac_utility.range_person_on( p_report_type => lv_ppr_report_type,

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

1192: l_report_format := Null ;
1193: End ;
1194:
1195: hr_utility.trace('l_report_format: '||l_report_format);
1196: hr_utility.trace('lv_ppr_report_type: '||lv_ppr_report_type);
1197: hr_utility.trace('l_state '||l_state);
1198: hr_utility.trace('l_report_cat: '||l_report_cat);
1199: l_person_on := pay_ac_utility.range_person_on( p_report_type => lv_ppr_report_type,
1200: p_report_format => l_report_format,

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

1193: End ;
1194:
1195: hr_utility.trace('l_report_format: '||l_report_format);
1196: hr_utility.trace('lv_ppr_report_type: '||lv_ppr_report_type);
1197: hr_utility.trace('l_state '||l_state);
1198: hr_utility.trace('l_report_cat: '||l_report_cat);
1199: l_person_on := pay_ac_utility.range_person_on( p_report_type => lv_ppr_report_type,
1200: p_report_format => l_report_format,
1201: p_report_qualifier => l_state,

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

1194:
1195: hr_utility.trace('l_report_format: '||l_report_format);
1196: hr_utility.trace('lv_ppr_report_type: '||lv_ppr_report_type);
1197: hr_utility.trace('l_state '||l_state);
1198: hr_utility.trace('l_report_cat: '||l_report_cat);
1199: l_person_on := pay_ac_utility.range_person_on( p_report_type => lv_ppr_report_type,
1200: p_report_format => l_report_format,
1201: p_report_qualifier => l_state,
1202: p_report_category => l_report_cat) ;

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

1204: if ln_person_id is not null then
1205: action_creation(p_start_person_id);
1206:
1207: elsif ln_asg_set is not null then
1208: hr_utility.trace('Entered Asg Set logic');
1209: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
1210: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1211: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1212:

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

1205: action_creation(p_start_person_id);
1206:
1207: elsif ln_asg_set is not null then
1208: hr_utility.trace('Entered Asg Set logic');
1209: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
1210: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1211: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1212:
1213: if l_person_on then

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

1206:
1207: elsif ln_asg_set is not null then
1208: hr_utility.trace('Entered Asg Set logic');
1209: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
1210: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1211: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1212:
1213: if l_person_on then
1214: open c_selected_asg_set_range(p_start_person_id

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

1207: elsif ln_asg_set is not null then
1208: hr_utility.trace('Entered Asg Set logic');
1209: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
1210: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1211: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1212:
1213: if l_person_on then
1214: open c_selected_asg_set_range(p_start_person_id
1215: ,p_end_person_id

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

1214: open c_selected_asg_set_range(p_start_person_id
1215: ,p_end_person_id
1216: ,ln_asg_set
1217: ,ld_end_date);
1218: hr_utility.trace('Opened cusor c_selected_asg_set_range');
1219: else
1220: open c_selected_asg_set (p_start_person_id
1221: ,p_end_person_id
1222: ,ln_asg_set

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

1220: open c_selected_asg_set (p_start_person_id
1221: ,p_end_person_id
1222: ,ln_asg_set
1223: ,ld_end_date);
1224: hr_utility.trace('Opened cusor c_selected_asg_set');
1225: end if;
1226: loop
1227: -- Added for Bug# 10399514
1228: if l_person_on then

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

1227: -- Added for Bug# 10399514
1228: if l_person_on then
1229: fetch c_selected_asg_set_range into ln_set_person_id;
1230: if c_selected_asg_set_range%notfound then
1231: hr_utility.trace('c_selected_asg_set_range not found ');
1232: hr_utility.trace('No Person found for reporting in this chunk');
1233: exit;
1234: end if;
1235: else

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

1228: if l_person_on then
1229: fetch c_selected_asg_set_range into ln_set_person_id;
1230: if c_selected_asg_set_range%notfound then
1231: hr_utility.trace('c_selected_asg_set_range not found ');
1232: hr_utility.trace('No Person found for reporting in this chunk');
1233: exit;
1234: end if;
1235: else
1236: fetch c_selected_asg_set into ln_set_person_id;

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

1234: end if;
1235: else
1236: fetch c_selected_asg_set into ln_set_person_id;
1237: if c_selected_asg_set%notfound then
1238: hr_utility.trace('c_selected_asg_set not found ');
1239: hr_utility.trace('No Person found for reporting in this chunk');
1240: exit;
1241: end if;
1242: end if; -- l_person_on

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

1235: else
1236: fetch c_selected_asg_set into ln_set_person_id;
1237: if c_selected_asg_set%notfound then
1238: hr_utility.trace('c_selected_asg_set not found ');
1239: hr_utility.trace('No Person found for reporting in this chunk');
1240: exit;
1241: end if;
1242: end if; -- l_person_on
1243:

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

1250: end if;
1251:
1252: elsif ln_tax_unit_id is not null then
1253:
1254: hr_utility.trace('Entered PRE not null logic');
1255: hr_utility.trace('PRE ='||to_char(ln_tax_unit_id));
1256: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1257: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1258:

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

1251:
1252: elsif ln_tax_unit_id is not null then
1253:
1254: hr_utility.trace('Entered PRE not null logic');
1255: hr_utility.trace('PRE ='||to_char(ln_tax_unit_id));
1256: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1257: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1258:
1259: -- Added for Bug# 10399514

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

1252: elsif ln_tax_unit_id is not null then
1253:
1254: hr_utility.trace('Entered PRE not null logic');
1255: hr_utility.trace('PRE ='||to_char(ln_tax_unit_id));
1256: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1257: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1258:
1259: -- Added for Bug# 10399514
1260: if l_person_on then

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

1253:
1254: hr_utility.trace('Entered PRE not null logic');
1255: hr_utility.trace('PRE ='||to_char(ln_tax_unit_id));
1256: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1257: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1258:
1259: -- Added for Bug# 10399514
1260: if l_person_on then
1261: open c_all_asg_range(ln_business_group_id,

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

1262: ln_tax_unit_id,
1263: ld_end_date,
1264: p_start_person_id,
1265: p_end_person_id);
1266: hr_utility.trace('Opened cusor c_all_asg_range');
1267: else
1268: open c_all_asg (ln_business_group_id,
1269: ln_tax_unit_id,
1270: ld_end_date,

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

1269: ln_tax_unit_id,
1270: ld_end_date,
1271: p_start_person_id,
1272: p_end_person_id);
1273: hr_utility.trace('Opened cusor c_all_asg');
1274: end if;
1275: loop
1276: if l_person_on then
1277: fetch c_all_asg_range into ln_set_person_id;

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

1275: loop
1276: if l_person_on then
1277: fetch c_all_asg_range into ln_set_person_id;
1278: if c_all_asg_range%notfound then
1279: hr_utility.trace('c_all_asg_range not found ');
1280: hr_utility.trace('No Person found for reporting in this chunk');
1281: exit;
1282: end if;
1283: else

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

1276: if l_person_on then
1277: fetch c_all_asg_range into ln_set_person_id;
1278: if c_all_asg_range%notfound then
1279: hr_utility.trace('c_all_asg_range not found ');
1280: hr_utility.trace('No Person found for reporting in this chunk');
1281: exit;
1282: end if;
1283: else
1284: fetch c_all_asg into ln_set_person_id;

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

1282: end if;
1283: else
1284: fetch c_all_asg into ln_set_person_id;
1285: if c_all_asg%notfound then
1286: hr_utility.trace('c_all_asg not found ');
1287: hr_utility.trace('No Person found for reporting in this chunk');
1288: exit;
1289: end if;
1290: end if;--l_person_on

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

1283: else
1284: fetch c_all_asg into ln_set_person_id;
1285: if c_all_asg%notfound then
1286: hr_utility.trace('c_all_asg not found ');
1287: hr_utility.trace('No Person found for reporting in this chunk');
1288: exit;
1289: end if;
1290: end if;--l_person_on
1291:

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

1299:
1300:
1301: else
1302:
1303: hr_utility.trace('Entered All PRE logic');
1304:
1305: open c_all_pres(ln_business_group_id,
1306: ld_end_date);
1307:

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

1308: loop -- c_all_pres
1309:
1310: fetch c_all_pres into ln_pre_id;
1311: if c_all_pres%NOTFOUND then
1312: hr_utility.trace('c_all_pres NOT FOUND');
1313: exit;
1314: end if;
1315:
1316: hr_utility.trace('PRE ='||to_char(ln_pre_id));

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

1312: hr_utility.trace('c_all_pres NOT FOUND');
1313: exit;
1314: end if;
1315:
1316: hr_utility.trace('PRE ='||to_char(ln_pre_id));
1317: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1318: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1319: if l_person_on then
1320: open c_all_asg_range(ln_business_group_id,

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

1313: exit;
1314: end if;
1315:
1316: hr_utility.trace('PRE ='||to_char(ln_pre_id));
1317: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1318: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1319: if l_person_on then
1320: open c_all_asg_range(ln_business_group_id,
1321: ln_pre_id,

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

1314: end if;
1315:
1316: hr_utility.trace('PRE ='||to_char(ln_pre_id));
1317: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1318: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1319: if l_person_on then
1320: open c_all_asg_range(ln_business_group_id,
1321: ln_pre_id,
1322: ld_end_date,

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

1321: ln_pre_id,
1322: ld_end_date,
1323: p_start_person_id,
1324: p_end_person_id);
1325: hr_utility.trace('Opened cusor c_all_asg_range');
1326: else
1327: open c_all_asg (ln_business_group_id,
1328: ln_pre_id,
1329: ld_end_date,

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

1328: ln_pre_id,
1329: ld_end_date,
1330: p_start_person_id,
1331: p_end_person_id);
1332: hr_utility.trace('Opened cusor c_all_asg');
1333: end if;
1334:
1335: loop -- c_all_asg
1336: if l_person_on then

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

1335: loop -- c_all_asg
1336: if l_person_on then
1337: fetch c_all_asg_range into ln_set_person_id;
1338: if c_all_asg_range%notfound then
1339: hr_utility.trace('c_all_asg_range not found ');
1340: hr_utility.trace('No Person found for reporting in this chunk');
1341: exit;
1342: end if;
1343: else

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

1336: if l_person_on then
1337: fetch c_all_asg_range into ln_set_person_id;
1338: if c_all_asg_range%notfound then
1339: hr_utility.trace('c_all_asg_range not found ');
1340: hr_utility.trace('No Person found for reporting in this chunk');
1341: exit;
1342: end if;
1343: else
1344: fetch c_all_asg into ln_set_person_id;

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

1342: end if;
1343: else
1344: fetch c_all_asg into ln_set_person_id;
1345: if c_all_asg%notfound then
1346: hr_utility.trace('c_all_asg not found ');
1347: hr_utility.trace('No Person found for reporting in this chunk');
1348: exit;
1349: end if;
1350: end if;--l_person_on

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

1343: else
1344: fetch c_all_asg into ln_set_person_id;
1345: if c_all_asg%notfound then
1346: hr_utility.trace('c_all_asg not found ');
1347: hr_utility.trace('No Person found for reporting in this chunk');
1348: exit;
1349: end if;
1350: end if;--l_person_on
1351:

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

1416: from pay_payroll_actions ppa
1417: where ppa.payroll_action_id = payactid;
1418:
1419: exception when no_data_found then
1420: hr_utility.trace('Error in Sort Procedure - getting legislative param');
1421: raise;
1422:
1423: end;
1424:

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

1425: if l_year_end > l_dt then
1426: l_dt := l_year_end;
1427: end if;
1428:
1429: hr_utility.trace('Beginning of the sort_action cursor');
1430:
1431: sqlstr := 'select paa1.rowid
1432: from hr_all_organization_units hou,
1433: hr_all_organization_units hou1,

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

1475: ppf.last_name,first_name';
1476:
1477:
1478: len := length(sqlstr); -- return the length of the string.
1479: hr_utility.trace('End of the sort_Action cursor');
1480:
1481: end sort_action;
1482:
1483:

Line 1517: -- hr_utility.trace_on(null,'RL1_CANCELLED_PDF');

1513:
1514: END get_parameter;
1515: Begin
1516:
1517: -- hr_utility.trace_on(null,'RL1_CANCELLED_PDF');
1518: null;
1519: end pay_ca_eoy_rl1_cancelled_pkg;