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

APPS.PAY_CA_EOY_T4_CANCEL_PKG dependencies on HR_UTILITY

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 132: raise hr_utility.hr_error;

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

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

187: -- Variables declared for bug 10399514
188: l_print_term varchar2(1) := 'N';
189:
190: BEGIN
191: hr_utility.trace('Entered get_payroll_action_info');
192: open c_payroll_action_info(p_payroll_action_id);
193: fetch c_payroll_action_info into ln_tax_unit_id,
194: ln_person_id,
195: ln_asg_set,

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

203: lv_report_cat,
204: l_print_term;
205: close c_payroll_action_info;
206:
207: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
208: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
209: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
210: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
211: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));

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

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

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

205: close c_payroll_action_info;
206:
207: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
208: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
209: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
210: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
211: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
212: hr_utility.trace('lv_prov_cd = ' || lv_prov_cd);
213: hr_utility.trace('lv_report_qualifier = '|| lv_report_qualifier);

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

206:
207: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
208: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
209: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
210: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
211: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
212: hr_utility.trace('lv_prov_cd = ' || lv_prov_cd);
213: hr_utility.trace('lv_report_qualifier = '|| lv_report_qualifier);
214: hr_utility.trace('lv_report_cat = ' || lv_report_cat);

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

207: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
208: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
209: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
210: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
211: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
212: hr_utility.trace('lv_prov_cd = ' || lv_prov_cd);
213: hr_utility.trace('lv_report_qualifier = '|| lv_report_qualifier);
214: hr_utility.trace('lv_report_cat = ' || lv_report_cat);
215: hr_utility.trace('l_print_term = ' || l_print_term);

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

208: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
209: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
210: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
211: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
212: hr_utility.trace('lv_prov_cd = ' || lv_prov_cd);
213: hr_utility.trace('lv_report_qualifier = '|| lv_report_qualifier);
214: hr_utility.trace('lv_report_cat = ' || lv_report_cat);
215: hr_utility.trace('l_print_term = ' || l_print_term);
216:

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

209: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
210: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
211: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
212: hr_utility.trace('lv_prov_cd = ' || lv_prov_cd);
213: hr_utility.trace('lv_report_qualifier = '|| lv_report_qualifier);
214: hr_utility.trace('lv_report_cat = ' || lv_report_cat);
215: hr_utility.trace('l_print_term = ' || l_print_term);
216:
217: p_end_date := ld_end_date;

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

210: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
211: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
212: hr_utility.trace('lv_prov_cd = ' || lv_prov_cd);
213: hr_utility.trace('lv_report_qualifier = '|| lv_report_qualifier);
214: hr_utility.trace('lv_report_cat = ' || lv_report_cat);
215: hr_utility.trace('l_print_term = ' || l_print_term);
216:
217: p_end_date := ld_end_date;
218: p_start_date := ld_start_date;

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

211: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
212: hr_utility.trace('lv_prov_cd = ' || lv_prov_cd);
213: hr_utility.trace('lv_report_qualifier = '|| lv_report_qualifier);
214: hr_utility.trace('lv_report_cat = ' || lv_report_cat);
215: hr_utility.trace('l_print_term = ' || l_print_term);
216:
217: p_end_date := ld_end_date;
218: p_start_date := ld_start_date;
219: p_business_group_id := ln_business_group_id;

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

226: p_state := lv_report_qualifier;
227: p_report_cat := lv_report_cat;
228: p_print_term := l_print_term;
229:
230: hr_utility.trace('Leaving get_payroll_action_info');
231:
232: EXCEPTION
233: when others then
234: hr_utility.trace('Error in ' || gv_procedure_name ||

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

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

Line 236: raise hr_utility.hr_error;

232: EXCEPTION
233: when others then
234: hr_utility.trace('Error in ' || gv_procedure_name ||
235: to_char(sqlcode) || '-' || sqlerrm);
236: raise hr_utility.hr_error;
237:
238: END get_payroll_action_info;
239:
240:

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

267: lv_prov_cd varchar2(5);
268: lv_report_type varchar2(50);
269:
270: BEGIN
271: hr_utility.trace('Entered range_cursor');
272: hr_utility.trace('p_payroll_action_id = ' ||
273: to_char(p_payroll_action_id));
274:
275: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id

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

268: lv_report_type varchar2(50);
269:
270: BEGIN
271: hr_utility.trace('Entered range_cursor');
272: hr_utility.trace('p_payroll_action_id = ' ||
273: to_char(p_payroll_action_id));
274:
275: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
276: ,p_start_date => ld_start_date

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

284: ,p_report_type => lv_report_type);
285:
286: ln_year := to_number(to_char(ld_end_date,'YYYY'));
287:
288: hr_utility.trace('Checking for Preprocess Agent GRE setup');
289:
290: if ln_person_id is not null then
291:
292: lv_sql_string :=

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

294: from per_assignments_f asg
295: where person_id = ' || ln_person_id ||
296: ' and :payroll_action_id > 0';
297:
298: hr_utility.trace('Range for person_id not null');
299:
300: elsif ln_asg_set is not null then
301:
302: lv_sql_string :=

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

308: and asgset.include_or_exclude = ''I''
309: and :payroll_action_id > 0
310: order by paf.person_id';
311:
312: hr_utility.trace('Range for asg_set not null');
313:
314: elsif ln_tax_unit_id is not NULL and lv_prov_cd is not NULL then
315:
316: lv_sql_string :=

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

385:
386: end if;
387:
388: p_sqlstr := lv_sql_string;
389: hr_utility.trace('p_sqlstr = ' ||p_sqlstr);
390:
391: hr_utility.trace('Leaving range_cursor');
392:
393: END range_cursor;

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

387:
388: p_sqlstr := lv_sql_string;
389: hr_utility.trace('p_sqlstr = ' ||p_sqlstr);
390:
391: hr_utility.trace('Leaving range_cursor');
392:
393: END range_cursor;
394:
395:

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

845: l_effective_end_date date; -- Added for bug 15886428
846:
847: BEGIN
848:
849: hr_utility.trace('Inside action_creation');
850:
851: if lv_print = 'LATEST' then
852: if nvl(l_print_term,'N') = 'Y' then
853: open get_latest_t4_cancel_term(p_person_id

Line 893: hr_utility.trace('get_latest_t4_cancel_dtls not found');

889: fetch get_warning_dtls_for_ee into lv_full_name
890: ,lv_employee_number;
891: close get_warning_dtls_for_ee;
892:
893: hr_utility.trace('get_latest_t4_cancel_dtls not found');
894: hr_utility.trace('p_person_id :'||to_char(p_person_id));
895:
896: lv_record_name := 'T4 Cancel PDF Report';
897: lv_message := 'Either T4 PDF or T4 Amendment PDF were not run for the employee';

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

890: ,lv_employee_number;
891: close get_warning_dtls_for_ee;
892:
893: hr_utility.trace('get_latest_t4_cancel_dtls not found');
894: hr_utility.trace('p_person_id :'||to_char(p_person_id));
895:
896: lv_record_name := 'T4 Cancel PDF Report';
897: lv_message := 'Either T4 PDF or T4 Amendment PDF were not run for the employee';
898:

Line 931: hr_utility.trace('Archiver Run '||ln_arch_act_to_lock||' rolled back for Report run '||ln_rep_act_to_lock);

927: end if;
928:
929: if l_arch_action_exists = 'N' then
930:
931: hr_utility.trace('Archiver Run '||ln_arch_act_to_lock||' rolled back for Report run '||ln_rep_act_to_lock);
932:
933: open get_warning_dtls_for_ee(p_person_id);
934: fetch get_warning_dtls_for_ee into lv_full_name,lv_employee_number;
935: close get_warning_dtls_for_ee;

Line 952: hr_utility.trace('get_latest_t4_cancel_dtls found ');

948: ln_tax_unit_id := ln_gre_id_null;
949: end if;
950:
951: /* Create an assignment action for this person */
952: hr_utility.trace('get_latest_t4_cancel_dtls found ');
953: hr_utility.trace('Report Type: '||lv_report_type);
954:
955: if nvl(pay_us_employee_payslip_web.get_doc_eit('T4PDF',
956: 'PRINT',

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

949: end if;
950:
951: /* Create an assignment action for this person */
952: hr_utility.trace('get_latest_t4_cancel_dtls found ');
953: hr_utility.trace('Report Type: '||lv_report_type);
954:
955: if nvl(pay_us_employee_payslip_web.get_doc_eit('T4PDF',
956: 'PRINT',
957: 'ASSIGNMENT',

Line 964: hr_utility.trace('New T4 Cancel Action = ' ||

960: select pay_assignment_actions_s.nextval
961: into ln_t4cancel_asg_action
962: from dual;
963:
964: hr_utility.trace('New T4 Cancel Action = ' ||
965: to_char(ln_t4cancel_asg_action));
966:
967: /* Insert into pay_assignment_actions. */
968: hr_nonrun_asact.insact(ln_t4cancel_asg_action

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

988: update pay_assignment_actions aa
989: set aa.serial_number = ln_serial_number
990: where aa.assignment_action_id = ln_t4cancel_asg_action;
991:
992: hr_utility.trace('lv_prov_of_emp :'||substr(ln_serial_number,1,2));
993: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
994: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
995:
996:

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

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

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

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

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

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

Line 1000: hr_utility.trace('Locking Action'||ln_t4cancel_asg_action);

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

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

997: --Added to lock the PDF Report Run
998: hr_nonrun_asact.insint(ln_t4cancel_asg_action,ln_rep_act_to_lock);
999: hr_utility.trace('Locking the PDF Assignment Action');
1000: hr_utility.trace('Locking Action'||ln_t4cancel_asg_action);
1001: hr_utility.trace('Locked Action = ' || to_char(ln_rep_act_to_lock));
1002:
1003: --Added to lock the Archiver
1004: hr_nonrun_asact.insint(ln_t4cancel_asg_action,ln_arch_act_to_lock);
1005: hr_utility.trace('Locking the Archiver Assignment Action');

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

1001: hr_utility.trace('Locked Action = ' || to_char(ln_rep_act_to_lock));
1002:
1003: --Added to lock the Archiver
1004: hr_nonrun_asact.insint(ln_t4cancel_asg_action,ln_arch_act_to_lock);
1005: hr_utility.trace('Locking the Archiver Assignment Action');
1006: hr_utility.trace('Locking Action'||ln_t4cancel_asg_action);
1007: hr_utility.trace('Locked Action = ' || to_char(ln_arch_act_to_lock));
1008: end if;
1009:

Line 1006: hr_utility.trace('Locking Action'||ln_t4cancel_asg_action);

1002:
1003: --Added to lock the Archiver
1004: hr_nonrun_asact.insint(ln_t4cancel_asg_action,ln_arch_act_to_lock);
1005: hr_utility.trace('Locking the Archiver Assignment Action');
1006: hr_utility.trace('Locking Action'||ln_t4cancel_asg_action);
1007: hr_utility.trace('Locked Action = ' || to_char(ln_arch_act_to_lock));
1008: end if;
1009:
1010: end if; /* l_arch_action_exists*/

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

1003: --Added to lock the Archiver
1004: hr_nonrun_asact.insint(ln_t4cancel_asg_action,ln_arch_act_to_lock);
1005: hr_utility.trace('Locking the Archiver Assignment Action');
1006: hr_utility.trace('Locking Action'||ln_t4cancel_asg_action);
1007: hr_utility.trace('Locked Action = ' || to_char(ln_arch_act_to_lock));
1008: end if;
1009:
1010: end if; /* l_arch_action_exists*/
1011:

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

1062: fetch get_warning_dtls_for_ee into lv_full_name
1063: ,lv_employee_number;
1064: close get_warning_dtls_for_ee;
1065:
1066: hr_utility.trace('get_reprint_t4_cancel_dtls not found');
1067: hr_utility.trace('p_person_id :'||to_char(p_person_id));
1068:
1069: lv_record_name := 'T4 Cancel PDF Report';
1070: lv_message := 'As T4 Cancel PDF was not run in Unprint Mode, Reprint mode will not be applicable';

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

1063: ,lv_employee_number;
1064: close get_warning_dtls_for_ee;
1065:
1066: hr_utility.trace('get_reprint_t4_cancel_dtls not found');
1067: hr_utility.trace('p_person_id :'||to_char(p_person_id));
1068:
1069: lv_record_name := 'T4 Cancel PDF Report';
1070: lv_message := 'As T4 Cancel PDF was not run in Unprint Mode, Reprint mode will not be applicable';
1071:

Line 1094: hr_utility.trace('get_reprint_t4_cancel_dtls found ');

1090: end if;
1091:
1092:
1093: /* Create an assignment action for this person */
1094: hr_utility.trace('get_reprint_t4_cancel_dtls found ');
1095: hr_utility.trace('Report Type: '||lv_report_type);
1096:
1097: if nvl(pay_us_employee_payslip_web.get_doc_eit('T4PDF',
1098: 'PRINT',

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

1091:
1092:
1093: /* Create an assignment action for this person */
1094: hr_utility.trace('get_reprint_t4_cancel_dtls found ');
1095: hr_utility.trace('Report Type: '||lv_report_type);
1096:
1097: if nvl(pay_us_employee_payslip_web.get_doc_eit('T4PDF',
1098: 'PRINT',
1099: 'ASSIGNMENT',

Line 1107: hr_utility.trace('New T4 Cancel Action = ' ||

1103: select pay_assignment_actions_s.nextval
1104: into ln_t4cancel_asg_action
1105: from dual;
1106:
1107: hr_utility.trace('New T4 Cancel Action = ' ||
1108: to_char(ln_t4cancel_asg_action));
1109:
1110: /* Insert into pay_assignment_actions. */
1111: hr_nonrun_asact.insact(ln_t4cancel_asg_action

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1173: ,p_report_cat => l_report_cat
1174: ,p_print_term => l_print_term);
1175: -- Added for bug 10399514
1176:
1177: hr_utility.trace('lv_ppr_report_type: '||lv_ppr_report_type);
1178:
1179: ln_tax_unit_id := ln_gre_parameter;
1180:
1181: -- Code modification for bug 10399514 start here

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

1204: action_creation(p_start_person_id);
1205:
1206: elsif ln_asg_set is not null then
1207:
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:
1206: elsif ln_asg_set is not null then
1207:
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: -- Code modification for bug 10399514 start here

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

1206: elsif ln_asg_set is not null then
1207:
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: -- Code modification for bug 10399514 start here
1214: if l_person_on then

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

1207:
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: -- Code modification for bug 10399514 start here
1214: if l_person_on then
1215: hr_utility.trace('opening c_selected_asg_set_range CURSOR');

Line 1215: hr_utility.trace('opening c_selected_asg_set_range CURSOR');

1211: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1212:
1213: -- Code modification for bug 10399514 start here
1214: if l_person_on then
1215: hr_utility.trace('opening c_selected_asg_set_range CURSOR');
1216: open c_selected_asg_set_range (p_start_person_id
1217: ,p_end_person_id
1218: ,ln_asg_set
1219: ,ld_end_date);

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

1221: open c_selected_asg_set (p_start_person_id
1222: ,p_end_person_id
1223: ,ln_asg_set
1224: ,ld_end_date);
1225: hr_utility.trace('Opened cusor c_selected_asg_set');
1226: end if;
1227: -- Code modification for bug 10399514 ends here
1228: loop
1229: -- Code modification for bug 10399514 starts here

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

1227: -- Code modification for bug 10399514 ends here
1228: loop
1229: -- Code modification for bug 10399514 starts here
1230: if l_person_on then
1231: hr_utility.trace('fetching from c_selected_asg_set_range CURSOR');
1232: fetch c_selected_asg_set_range
1233: into ln_set_person_id;
1234: if c_selected_asg_set_range%notfound then
1235: hr_utility.trace('c_selected_asg_set_range not found ');

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

1231: hr_utility.trace('fetching from c_selected_asg_set_range CURSOR');
1232: fetch c_selected_asg_set_range
1233: into ln_set_person_id;
1234: if c_selected_asg_set_range%notfound then
1235: hr_utility.trace('c_selected_asg_set_range not found ');
1236: hr_utility.trace('No Person found for reporting in this chunk');
1237: exit;
1238: end if;
1239: else

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

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

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

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

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

1239: else
1240: fetch c_selected_asg_set into ln_set_person_id;
1241: if c_selected_asg_set%notfound then
1242: hr_utility.trace('c_selected_asg_set not found ');
1243: hr_utility.trace('No Person found for reporting in this chunk');
1244: exit;
1245: end if;
1246: end if;
1247: -- Code modification for bug 10399514 ends here

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

1250:
1251: end loop;
1252: -- Code modification for bug 10399514 starts here
1253: if l_person_on then
1254: hr_utility.trace('closing c_selected_asg_set_range CURSOR');
1255: close c_selected_asg_set_range;
1256: else
1257: hr_utility.trace('closing c_selected_asg_set CURSOR');
1258: close c_selected_asg_set;

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

1253: if l_person_on then
1254: hr_utility.trace('closing c_selected_asg_set_range CURSOR');
1255: close c_selected_asg_set_range;
1256: else
1257: hr_utility.trace('closing c_selected_asg_set CURSOR');
1258: close c_selected_asg_set;
1259: end if ;
1260: -- Code modification for bug 10399514 ends here
1261:

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

1260: -- Code modification for bug 10399514 ends here
1261:
1262: elsif ln_tax_unit_id is not null then
1263:
1264: hr_utility.trace('Entered GRE not null logic');
1265: hr_utility.trace('GRE ='||to_char(ln_tax_unit_id));
1266: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1267: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1268:

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

1261:
1262: elsif ln_tax_unit_id is not null then
1263:
1264: hr_utility.trace('Entered GRE not null logic');
1265: hr_utility.trace('GRE ='||to_char(ln_tax_unit_id));
1266: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1267: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1268:
1269: -- Code modification for bug 10399514 start here

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

1262: elsif ln_tax_unit_id is not null then
1263:
1264: hr_utility.trace('Entered GRE not null logic');
1265: hr_utility.trace('GRE ='||to_char(ln_tax_unit_id));
1266: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1267: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1268:
1269: -- Code modification for bug 10399514 start here
1270: if l_person_on then

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

1263:
1264: hr_utility.trace('Entered GRE not null logic');
1265: hr_utility.trace('GRE ='||to_char(ln_tax_unit_id));
1266: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1267: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1268:
1269: -- Code modification for bug 10399514 start here
1270: if l_person_on then
1271: hr_utility.trace('opening c_all_asg_range CURSOR');

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

1267: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1268:
1269: -- Code modification for bug 10399514 start here
1270: if l_person_on then
1271: hr_utility.trace('opening c_all_asg_range CURSOR');
1272: open c_all_asg_range (ln_business_group_id,
1273: ln_tax_unit_id,
1274: ld_end_date,
1275: p_start_person_id,

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

1279: ln_tax_unit_id,
1280: ld_end_date,
1281: p_start_person_id,
1282: p_end_person_id);
1283: hr_utility.trace('Opened cusor c_all_asg');
1284: end if;
1285: -- Code modification for bug 10399514 ends here
1286: loop
1287: -- Code modification for bug 10399514 start here

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

1287: -- Code modification for bug 10399514 start here
1288: if l_person_on then
1289: fetch c_all_asg_range into ln_set_person_id;
1290: if c_all_asg_range%notfound then
1291: hr_utility.trace('c_all_asg_range not found ');
1292: hr_utility.trace('No Person found for reporting in this chunk');
1293: exit;
1294: end if;
1295: else

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

1288: if l_person_on then
1289: fetch c_all_asg_range into ln_set_person_id;
1290: if c_all_asg_range%notfound then
1291: hr_utility.trace('c_all_asg_range not found ');
1292: hr_utility.trace('No Person found for reporting in this chunk');
1293: exit;
1294: end if;
1295: else
1296: fetch c_all_asg into ln_set_person_id;

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

1294: end if;
1295: else
1296: fetch c_all_asg into ln_set_person_id;
1297: if c_all_asg%notfound then
1298: hr_utility.trace('c_all_asg not found ');
1299: hr_utility.trace('No Person found for reporting in this chunk');
1300: exit;
1301: end if;
1302: end if;

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

1295: else
1296: fetch c_all_asg into ln_set_person_id;
1297: if c_all_asg%notfound then
1298: hr_utility.trace('c_all_asg not found ');
1299: hr_utility.trace('No Person found for reporting in this chunk');
1300: exit;
1301: end if;
1302: end if;
1303: -- Code modification for bug 10399514 ends here

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

1305:
1306: end loop;
1307: -- Code modification for bug 10399514 starts here
1308: if l_person_on then
1309: hr_utility.trace('closing c_all_asg_range CURSOR');
1310: close c_all_asg_range;
1311: else
1312: hr_utility.trace('closing c_all_asg CURSOR');
1313: close c_all_asg;

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

1308: if l_person_on then
1309: hr_utility.trace('closing c_all_asg_range CURSOR');
1310: close c_all_asg_range;
1311: else
1312: hr_utility.trace('closing c_all_asg CURSOR');
1313: close c_all_asg;
1314: end if ;
1315: -- Code modification for bug 10399514 ends here
1316:

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

1315: -- Code modification for bug 10399514 ends here
1316:
1317: else
1318:
1319: hr_utility.trace('Entered All GRE logic');
1320: open c_all_gres(ln_business_group_id,
1321: ld_end_date);
1322: loop -- c_all_gres
1323:

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

1322: loop -- c_all_gres
1323:
1324: fetch c_all_gres into ln_gre_id;
1325: if c_all_gres%NOTFOUND then
1326: hr_utility.trace('c_all_gres NOT FOUND');
1327: exit;
1328: end if;
1329:
1330: hr_utility.trace('GRE ='||to_char(ln_gre_id));

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

1326: hr_utility.trace('c_all_gres NOT FOUND');
1327: exit;
1328: end if;
1329:
1330: hr_utility.trace('GRE ='||to_char(ln_gre_id));
1331: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1332: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1333: -- Code modification for bug 10399514 start here
1334: if l_person_on then

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

1327: exit;
1328: end if;
1329:
1330: hr_utility.trace('GRE ='||to_char(ln_gre_id));
1331: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1332: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1333: -- Code modification for bug 10399514 start here
1334: if l_person_on then
1335: hr_utility.trace('opening c_all_asg_range CURSOR');

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

1328: end if;
1329:
1330: hr_utility.trace('GRE ='||to_char(ln_gre_id));
1331: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1332: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1333: -- Code modification for bug 10399514 start here
1334: if l_person_on then
1335: hr_utility.trace('opening c_all_asg_range CURSOR');
1336: open c_all_asg_range (ln_business_group_id,

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

1331: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1332: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1333: -- Code modification for bug 10399514 start here
1334: if l_person_on then
1335: hr_utility.trace('opening c_all_asg_range CURSOR');
1336: open c_all_asg_range (ln_business_group_id,
1337: ln_gre_id,
1338: ld_end_date,
1339: p_start_person_id,

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

1343: ln_gre_id,
1344: ld_end_date,
1345: p_start_person_id,
1346: p_end_person_id);
1347: hr_utility.trace('Opened cusor c_all_asg');
1348: end if;
1349: -- Code modification for bug 10399514 ends here
1350:
1351: loop -- c_all_asg

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

1350:
1351: loop -- c_all_asg
1352: -- Code modification for bug 10399514 starts here
1353: if l_person_on then
1354: hr_utility.trace('fetching from c_all_asg_range CURSOR');
1355: fetch c_all_asg_range into ln_set_person_id;
1356: if c_all_asg_range%notfound then
1357: hr_utility.trace('c_all_asg not found ');
1358: hr_utility.trace('No Person found for reporting in this chunk');

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

1353: if l_person_on then
1354: hr_utility.trace('fetching from c_all_asg_range CURSOR');
1355: fetch c_all_asg_range into ln_set_person_id;
1356: if c_all_asg_range%notfound then
1357: hr_utility.trace('c_all_asg not found ');
1358: hr_utility.trace('No Person found for reporting in this chunk');
1359: exit;
1360: end if;
1361: else

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

1354: hr_utility.trace('fetching from c_all_asg_range CURSOR');
1355: fetch c_all_asg_range into ln_set_person_id;
1356: if c_all_asg_range%notfound then
1357: hr_utility.trace('c_all_asg not found ');
1358: hr_utility.trace('No Person found for reporting in this chunk');
1359: exit;
1360: end if;
1361: else
1362: fetch c_all_asg into ln_set_person_id;

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

1360: end if;
1361: else
1362: fetch c_all_asg into ln_set_person_id;
1363: if c_all_asg%notfound then
1364: hr_utility.trace('c_all_asg not found ');
1365: hr_utility.trace('No Person found for reporting in this chunk');
1366: exit;
1367: end if;
1368: end if;

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

1361: else
1362: fetch c_all_asg into ln_set_person_id;
1363: if c_all_asg%notfound then
1364: hr_utility.trace('c_all_asg not found ');
1365: hr_utility.trace('No Person found for reporting in this chunk');
1366: exit;
1367: end if;
1368: end if;
1369: -- Code modification for bug 10399514 ends here

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

1373:
1374: end loop; -- c_all_asg
1375: -- Code modification for bug 10399514 starts here
1376: if l_person_on then
1377: hr_utility.trace('closing c_all_asg_range CURSOR');
1378: close c_all_asg_range;
1379: else
1380: hr_utility.trace('closing c_all_asg CURSOR');
1381: close c_all_asg;

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

1376: if l_person_on then
1377: hr_utility.trace('closing c_all_asg_range CURSOR');
1378: close c_all_asg_range;
1379: else
1380: hr_utility.trace('closing c_all_asg CURSOR');
1381: close c_all_asg;
1382: end if ;
1383: -- Code modification for bug 10399514 ends here
1384:

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

1441: from pay_payroll_actions ppa
1442: where ppa.payroll_action_id = payactid;
1443:
1444: exception when no_data_found then
1445: hr_utility.trace('Error in Sort Procedure - getting legislative param');
1446: raise;
1447:
1448: end;
1449:

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

1450: if l_year_end > l_dt then
1451: l_dt := l_year_end;
1452: end if;
1453:
1454: hr_utility.trace('Beginning of the sort_action cursor');
1455:
1456: sqlstr := 'select paa1.rowid
1457: from hr_all_organization_units hou,
1458: hr_all_organization_units hou1,

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

1500: ppf.last_name,first_name';
1501:
1502:
1503: len := length(sqlstr); -- return the length of the string.
1504: hr_utility.trace('End of the sort_Action cursor');
1505:
1506: end sort_action;
1507:
1508:

Line 1542: /* hr_utility.trace_on(null,'T4_CANCEL_PDF'); */

1538:
1539: END get_parameter;
1540: Begin
1541:
1542: /* hr_utility.trace_on(null,'T4_CANCEL_PDF'); */
1543: null;
1544:
1545: end pay_ca_eoy_t4_cancel_pkg;