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

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

121: lv_print varchar2(10);
122: lv_report_type varchar2(50);
123:
124: BEGIN
125: hr_utility.trace('Entered get_payroll_action_info');
126: open c_payroll_action_info(p_payroll_action_id);
127: fetch c_payroll_action_info into ln_tax_unit_id,
128: ln_person_id,
129: ln_asg_set,

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

133: ln_business_group_id,
134: lv_report_type;
135: close c_payroll_action_info;
136:
137: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
138: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
139: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
140: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
141: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));

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

134: lv_report_type;
135: close c_payroll_action_info;
136:
137: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
138: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
139: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
140: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
141: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
142:

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

135: close c_payroll_action_info;
136:
137: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
138: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
139: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
140: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
141: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
142:
143: p_end_date := ld_end_date;

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

136:
137: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
138: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
139: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
140: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
141: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
142:
143: p_end_date := ld_end_date;
144: p_start_date := ld_start_date;

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

137: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
138: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
139: hr_utility.trace('ln_tax_unit_id = '|| to_char(ln_tax_unit_id));
140: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
141: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
142:
143: p_end_date := ld_end_date;
144: p_start_date := ld_start_date;
145: p_business_group_id := ln_business_group_id;

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

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

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

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

Line 158: raise hr_utility.hr_error;

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

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

218: -- Variables declared for bug 10399514
219: l_print_term varchar2(1) := 'N';
220:
221: BEGIN
222: hr_utility.trace('Entered get_payroll_action_info');
223: open c_payroll_action_info(p_payroll_action_id);
224: fetch c_payroll_action_info into ln_tax_unit_id,
225: ln_person_id,
226: ln_asg_set,

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

233: lv_report_cat,
234: l_print_term;
235: close c_payroll_action_info;
236:
237: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
238: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
239: hr_utility.trace('ln_tax_unit_id = ' || to_char(ln_tax_unit_id));
240: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
241: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));

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

234: l_print_term;
235: close c_payroll_action_info;
236:
237: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
238: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
239: hr_utility.trace('ln_tax_unit_id = ' || to_char(ln_tax_unit_id));
240: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
241: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
242: hr_utility.trace('lv_report_type = ' || lv_report_type);

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

235: close c_payroll_action_info;
236:
237: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
238: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
239: hr_utility.trace('ln_tax_unit_id = ' || to_char(ln_tax_unit_id));
240: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
241: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
242: hr_utility.trace('lv_report_type = ' || lv_report_type);
243: hr_utility.trace('lv_report_qualifier = '|| lv_report_qualifier);

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

236:
237: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
238: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
239: hr_utility.trace('ln_tax_unit_id = ' || to_char(ln_tax_unit_id));
240: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
241: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
242: hr_utility.trace('lv_report_type = ' || lv_report_type);
243: hr_utility.trace('lv_report_qualifier = '|| lv_report_qualifier);
244: hr_utility.trace('lv_report_cat = ' || lv_report_cat);

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

237: hr_utility.trace('ld_end_date = ' || to_char(ld_end_date));
238: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
239: hr_utility.trace('ln_tax_unit_id = ' || to_char(ln_tax_unit_id));
240: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
241: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
242: hr_utility.trace('lv_report_type = ' || lv_report_type);
243: hr_utility.trace('lv_report_qualifier = '|| lv_report_qualifier);
244: hr_utility.trace('lv_report_cat = ' || lv_report_cat);
245: hr_utility.trace('l_print_term = ' || l_print_term);

Line 242: hr_utility.trace('lv_report_type = ' || lv_report_type);

238: hr_utility.trace('ld_start_date = ' || to_char(ld_start_date));
239: hr_utility.trace('ln_tax_unit_id = ' || to_char(ln_tax_unit_id));
240: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
241: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
242: hr_utility.trace('lv_report_type = ' || lv_report_type);
243: hr_utility.trace('lv_report_qualifier = '|| lv_report_qualifier);
244: hr_utility.trace('lv_report_cat = ' || lv_report_cat);
245: hr_utility.trace('l_print_term = ' || l_print_term);
246:

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

239: hr_utility.trace('ln_tax_unit_id = ' || to_char(ln_tax_unit_id));
240: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
241: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
242: hr_utility.trace('lv_report_type = ' || lv_report_type);
243: hr_utility.trace('lv_report_qualifier = '|| lv_report_qualifier);
244: hr_utility.trace('lv_report_cat = ' || lv_report_cat);
245: hr_utility.trace('l_print_term = ' || l_print_term);
246:
247: p_end_date := ld_end_date;

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

240: hr_utility.trace('ln_person_id = ' || to_char(ln_person_id));
241: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
242: hr_utility.trace('lv_report_type = ' || lv_report_type);
243: hr_utility.trace('lv_report_qualifier = '|| lv_report_qualifier);
244: hr_utility.trace('lv_report_cat = ' || lv_report_cat);
245: hr_utility.trace('l_print_term = ' || l_print_term);
246:
247: p_end_date := ld_end_date;
248: p_start_date := ld_start_date;

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

241: hr_utility.trace('ln_asg_set = ' || to_char(ln_asg_set));
242: hr_utility.trace('lv_report_type = ' || lv_report_type);
243: hr_utility.trace('lv_report_qualifier = '|| lv_report_qualifier);
244: hr_utility.trace('lv_report_cat = ' || lv_report_cat);
245: hr_utility.trace('l_print_term = ' || l_print_term);
246:
247: p_end_date := ld_end_date;
248: p_start_date := ld_start_date;
249: p_business_group_id := ln_business_group_id;

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

255: p_state := lv_report_qualifier;
256: p_report_cat := lv_report_cat;
257: p_print_term := l_print_term;
258:
259: hr_utility.trace('Leaving get_payroll_action_info');
260:
261: EXCEPTION
262: when others then
263: hr_utility.trace('Error in ' || gv_procedure_name ||

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

259: hr_utility.trace('Leaving get_payroll_action_info');
260:
261: EXCEPTION
262: when others then
263: hr_utility.trace('Error in ' || gv_procedure_name ||
264: to_char(sqlcode) || '-' || sqlerrm);
265: raise hr_utility.hr_error;
266:
267: END get_payroll_action_info;

Line 265: raise hr_utility.hr_error;

261: EXCEPTION
262: when others then
263: hr_utility.trace('Error in ' || gv_procedure_name ||
264: to_char(sqlcode) || '-' || sqlerrm);
265: raise hr_utility.hr_error;
266:
267: END get_payroll_action_info;
268:
269: /******************************************************************

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

291: ln_year number;
292: lv_report_type varchar2(50);
293:
294: BEGIN
295: hr_utility.trace('Entered range_cursor');
296: hr_utility.trace('p_payroll_action_id = ' ||
297: to_char(p_payroll_action_id));
298:
299: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id

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

292: lv_report_type varchar2(50);
293:
294: BEGIN
295: hr_utility.trace('Entered range_cursor');
296: hr_utility.trace('p_payroll_action_id = ' ||
297: to_char(p_payroll_action_id));
298:
299: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
300: ,p_start_date => ld_start_date

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

307: ,p_report_type => lv_report_type);
308:
309: ln_year := to_number(to_char(ld_end_date,'YYYY'));
310:
311: hr_utility.trace('Checking for Preprocess Agent GRE setup');
312:
313: if ln_person_id is not null then
314:
315: lv_sql_string :=

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

317: from per_assignments_f asg
318: where person_id = ' || ln_person_id ||
319: ' and :p_payroll_action_id > 0';
320:
321: hr_utility.trace('Range for person_id not null');
322:
323: elsif ln_asg_set is not null then
324:
325: lv_sql_string :=

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

331: and asgset.include_or_exclude = ''I''
332: and :p_payroll_action_id > 0
333: order by paf.person_id ';
334:
335: hr_utility.trace('Range for asg_set not null');
336:
337: elsif ln_tax_unit_id is not NULL then
338:
339: lv_sql_string :=

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

371:
372: end if;
373:
374: p_sqlstr := lv_sql_string;
375: hr_utility.trace('p_sqlstr = ' ||p_sqlstr);
376:
377: hr_utility.trace('Leaving range_cursor');
378:
379: END range_cursor;

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

373:
374: p_sqlstr := lv_sql_string;
375: hr_utility.trace('p_sqlstr = ' ||p_sqlstr);
376:
377: hr_utility.trace('Leaving range_cursor');
378:
379: END range_cursor;
380:
381:

Line 890: hr_utility.trace('get_latest_t4a_amendpdf_dtls not found');

886: fetch get_warning_dtls_for_ee into lv_full_name
887: ,lv_employee_number;
888: close get_warning_dtls_for_ee;
889:
890: hr_utility.trace('get_latest_t4a_amendpdf_dtls not found');
891: hr_utility.trace('p_person_id :'||to_char(p_person_id));
892:
893: lv_record_name := 'T4A Amendment PDF Report';
894: lv_message := 'T4A Amend Preprocess was not run for this employee';

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

887: ,lv_employee_number;
888: close get_warning_dtls_for_ee;
889:
890: hr_utility.trace('get_latest_t4a_amendpdf_dtls not found');
891: hr_utility.trace('p_person_id :'||to_char(p_person_id));
892:
893: lv_record_name := 'T4A Amendment PDF Report';
894: lv_message := 'T4A Amend Preprocess was not run for this employee';
895:

Line 919: hr_utility.trace('lv_fed_amend_flag : '||lv_fed_amend_flag);

915: loop -- check amend flag for each province
916:
917: lv_fed_amend_flag := 'N';
918: fetch c_get_fed_amend_flag into lv_fed_amend_flag;
919: hr_utility.trace('lv_fed_amend_flag : '||lv_fed_amend_flag);
920: exit when c_get_fed_amend_flag%NOTFOUND;
921:
922: if c_get_fed_amend_flag%FOUND then
923:

Line 937: hr_utility.trace('get_latest_t4a_amendpdf_dtls found ');

933: fetch get_yepp_pact_id into ln_yepp_pact_id;
934: close get_yepp_pact_id;
935:
936: /* Create an assignment action for this person */
937: hr_utility.trace('get_latest_t4a_amendpdf_dtls found ');
938: hr_utility.trace('Report Type: '||lv_report_type);
939:
940: if nvl(pay_us_employee_payslip_web.get_doc_eit('T4APDF',
941: 'PRINT',

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

934: close get_yepp_pact_id;
935:
936: /* Create an assignment action for this person */
937: hr_utility.trace('get_latest_t4a_amendpdf_dtls found ');
938: hr_utility.trace('Report Type: '||lv_report_type);
939:
940: if nvl(pay_us_employee_payslip_web.get_doc_eit('T4APDF',
941: 'PRINT',
942: 'ASSIGNMENT',

Line 950: hr_utility.trace('New T4A Amend Action = ' ||

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

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

975:
976: update pay_assignment_actions aa
977: set aa.serial_number = ln_serial_number
978: where aa.assignment_action_id = ln_t4a_amend_reg_asg_action;
979: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,1,14));
980: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,15,14));
981:
982:
983: --Added to lock the Amend Archiver

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

976: update pay_assignment_actions aa
977: set aa.serial_number = ln_serial_number
978: where aa.assignment_action_id = ln_t4a_amend_reg_asg_action;
979: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,1,14));
980: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,15,14));
981:
982:
983: --Added to lock the Amend Archiver
984: hr_nonrun_asact.insint(ln_t4a_amend_reg_asg_action

Line 986: hr_utility.trace('Locking Action'||ln_t4a_amend_reg_asg_action);

982:
983: --Added to lock the Amend Archiver
984: hr_nonrun_asact.insint(ln_t4a_amend_reg_asg_action
985: ,ln_asg_act_to_lock);
986: hr_utility.trace('Locking Action'||ln_t4a_amend_reg_asg_action);
987: hr_utility.trace('ln_serial_number :' || ln_serial_number);
988: hr_utility.trace('Locked Action = ' || to_char(ln_asg_act_to_lock));
989: end if; -- T4APDF
990:

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

983: --Added to lock the Amend Archiver
984: hr_nonrun_asact.insint(ln_t4a_amend_reg_asg_action
985: ,ln_asg_act_to_lock);
986: hr_utility.trace('Locking Action'||ln_t4a_amend_reg_asg_action);
987: hr_utility.trace('ln_serial_number :' || ln_serial_number);
988: hr_utility.trace('Locked Action = ' || to_char(ln_asg_act_to_lock));
989: end if; -- T4APDF
990:
991: end if; -- lv_fed_amend_flag = 'Y'

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

984: hr_nonrun_asact.insint(ln_t4a_amend_reg_asg_action
985: ,ln_asg_act_to_lock);
986: hr_utility.trace('Locking Action'||ln_t4a_amend_reg_asg_action);
987: hr_utility.trace('ln_serial_number :' || ln_serial_number);
988: hr_utility.trace('Locked Action = ' || to_char(ln_asg_act_to_lock));
989: end if; -- T4APDF
990:
991: end if; -- lv_fed_amend_flag = 'Y'
992:

Line 1047: hr_utility.trace('get_reprint_t4a_amendpdf_dtls not found');

1043: fetch get_warning_dtls_for_ee into lv_full_name
1044: ,lv_employee_number;
1045: close get_warning_dtls_for_ee;
1046:
1047: hr_utility.trace('get_reprint_t4a_amendpdf_dtls not found');
1048: hr_utility.trace('p_person_id :'||to_char(p_person_id));
1049:
1050: lv_record_name := 'T4A Amendment PDF Report';
1051: lv_message := 'Reprint mode will be applicable only when Report was run in Unprint atleast once for the year';

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

1044: ,lv_employee_number;
1045: close get_warning_dtls_for_ee;
1046:
1047: hr_utility.trace('get_reprint_t4a_amendpdf_dtls not found');
1048: hr_utility.trace('p_person_id :'||to_char(p_person_id));
1049:
1050: lv_record_name := 'T4A Amendment PDF Report';
1051: lv_message := 'Reprint mode will be applicable only when Report was run in Unprint atleast once for the year';
1052:

Line 1076: hr_utility.trace('lv_fed_amend_flag : '||lv_fed_amend_flag);

1072: loop -- check amend flag for each province
1073:
1074: lv_fed_amend_flag := 'N';
1075: fetch c_get_fed_amend_flag into lv_fed_amend_flag;
1076: hr_utility.trace('lv_fed_amend_flag : '||lv_fed_amend_flag);
1077: exit when c_get_fed_amend_flag%NOTFOUND;
1078:
1079: if c_get_fed_amend_flag%FOUND then
1080:

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

1090: fetch get_yepp_pact_id into ln_yepp_pact_id;
1091: close get_yepp_pact_id;
1092:
1093: /* Create an assignment action for this person */
1094: hr_utility.trace('get_reprint_t4a_amendpdf_dtls found ');
1095: hr_utility.trace('Report Type: '||lv_report_type);
1096:
1097: if nvl(pay_us_employee_payslip_web.get_doc_eit('T4APDF',
1098: 'PRINT',

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

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

Line 1106: hr_utility.trace('New T4A Amend Action = ' ||

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

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

1131:
1132: update pay_assignment_actions aa
1133: set aa.serial_number = ln_serial_number
1134: where aa.assignment_action_id = ln_t4a_amend_reg_asg_action;
1135: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,1,14));
1136: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,15,14));
1137: end if; -- 'T4APDF'
1138:
1139: end if; -- lv_fed_amend_flag = 'Y'

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

1132: update pay_assignment_actions aa
1133: set aa.serial_number = ln_serial_number
1134: where aa.assignment_action_id = ln_t4a_amend_reg_asg_action;
1135: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,1,14));
1136: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,15,14));
1137: end if; -- 'T4APDF'
1138:
1139: end if; -- lv_fed_amend_flag = 'Y'
1140:

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

1162: open get_latest_t4a_amend_dtls(p_person_id
1163: ,ln_tax_unit_id
1164: ,ld_end_date);
1165:
1166: hr_utility.trace('ln_tax_unit_id :'||to_char(ln_tax_unit_id));
1167: hr_utility.trace('ld_end_date :'||to_char(ld_end_date));
1168: hr_utility.trace('ln_business_group_id :'||to_char(ln_business_group_id));
1169:
1170: loop

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

1163: ,ln_tax_unit_id
1164: ,ld_end_date);
1165:
1166: hr_utility.trace('ln_tax_unit_id :'||to_char(ln_tax_unit_id));
1167: hr_utility.trace('ld_end_date :'||to_char(ld_end_date));
1168: hr_utility.trace('ln_business_group_id :'||to_char(ln_business_group_id));
1169:
1170: loop
1171:

Line 1168: hr_utility.trace('ln_business_group_id :'||to_char(ln_business_group_id));

1164: ,ld_end_date);
1165:
1166: hr_utility.trace('ln_tax_unit_id :'||to_char(ln_tax_unit_id));
1167: hr_utility.trace('ld_end_date :'||to_char(ld_end_date));
1168: hr_utility.trace('ln_business_group_id :'||to_char(ln_business_group_id));
1169:
1170: loop
1171:
1172: fetch get_latest_t4a_amend_dtls into lv_report_type

Line 1185: hr_utility.trace('get_latest_t4a_amend_dtls not found');

1181: fetch get_warning_dtls_for_ee into lv_full_name
1182: ,lv_employee_number;
1183: close get_warning_dtls_for_ee;
1184:
1185: hr_utility.trace('get_latest_t4a_amend_dtls not found');
1186: hr_utility.trace('p_person_id :'||to_char(p_person_id));
1187:
1188: if lv_ppr_report_type = 'PYT4APRAMEND' then
1189: lv_record_name := 'T4A Amend Paper Report';

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

1182: ,lv_employee_number;
1183: close get_warning_dtls_for_ee;
1184:
1185: hr_utility.trace('get_latest_t4a_amend_dtls not found');
1186: hr_utility.trace('p_person_id :'||to_char(p_person_id));
1187:
1188: if lv_ppr_report_type = 'PYT4APRAMEND' then
1189: lv_record_name := 'T4A Amend Paper Report';
1190: else

Line 1220: hr_utility.trace('lv_fed_amend_flag : '||lv_fed_amend_flag);

1216:
1217: fetch c_get_fed_amend_flag into lv_fed_amend_flag;
1218: exit when c_get_fed_amend_flag%NOTFOUND;
1219:
1220: hr_utility.trace('lv_fed_amend_flag : '||lv_fed_amend_flag);
1221:
1222: if c_get_fed_amend_flag%FOUND then
1223:
1224: if lv_fed_amend_flag = 'Y' then

Line 1237: hr_utility.trace('get_latest_t4a_amend_dtls found ');

1233: fetch get_yepp_pact_id into ln_yepp_pact_id;
1234: close get_yepp_pact_id;
1235:
1236: /* Create an assignment action for this person */
1237: hr_utility.trace('get_latest_t4a_amend_dtls found ');
1238: hr_utility.trace('Report Type: '||lv_report_type);
1239:
1240: select pay_assignment_actions_s.nextval
1241: into ln_t4a_amend_reg_asg_action

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

1234: close get_yepp_pact_id;
1235:
1236: /* Create an assignment action for this person */
1237: hr_utility.trace('get_latest_t4a_amend_dtls found ');
1238: hr_utility.trace('Report Type: '||lv_report_type);
1239:
1240: select pay_assignment_actions_s.nextval
1241: into ln_t4a_amend_reg_asg_action
1242: from dual;

Line 1244: hr_utility.trace('New T4A Amend Action = ' ||

1240: select pay_assignment_actions_s.nextval
1241: into ln_t4a_amend_reg_asg_action
1242: from dual;
1243:
1244: hr_utility.trace('New T4A Amend Action = ' ||
1245: to_char(ln_t4a_amend_reg_asg_action));
1246:
1247: /* Insert into pay_assignment_actions. */
1248: hr_nonrun_asact.insact(ln_t4a_amend_reg_asg_action

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

1268: update pay_assignment_actions aa
1269: set aa.serial_number = ln_serial_number
1270: where aa.assignment_action_id = ln_t4a_amend_reg_asg_action;
1271:
1272: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
1273: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
1274:
1275: hr_utility.trace('Locking Action'||ln_t4a_amend_reg_asg_action);
1276: hr_utility.trace('ln_serial_number :' || ln_serial_number);

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

1269: set aa.serial_number = ln_serial_number
1270: where aa.assignment_action_id = ln_t4a_amend_reg_asg_action;
1271:
1272: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
1273: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
1274:
1275: hr_utility.trace('Locking Action'||ln_t4a_amend_reg_asg_action);
1276: hr_utility.trace('ln_serial_number :' || ln_serial_number);
1277:

Line 1275: hr_utility.trace('Locking Action'||ln_t4a_amend_reg_asg_action);

1271:
1272: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
1273: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
1274:
1275: hr_utility.trace('Locking Action'||ln_t4a_amend_reg_asg_action);
1276: hr_utility.trace('ln_serial_number :' || ln_serial_number);
1277:
1278: end if; -- lv_fed_amend_flag = 'Y'
1279:

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

1272: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
1273: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
1274:
1275: hr_utility.trace('Locking Action'||ln_t4a_amend_reg_asg_action);
1276: hr_utility.trace('ln_serial_number :' || ln_serial_number);
1277:
1278: end if; -- lv_fed_amend_flag = 'Y'
1279:
1280: end if; -- c_get_fed_amend_flag%FOUND

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

1298: ln_primary_assignment_id := 0;
1299: ln_asg_act_to_lock := 0;
1300: ln_gre_id_null := 0;
1301:
1302: hr_utility.trace('lv_print :'||lv_print);
1303:
1304: loop
1305: fetch get_all_t4a_amend_dtls into lv_report_type
1306: ,ln_primary_assignment_id

Line 1311: hr_utility.trace('get_all_t4a_amend_dtls not found ');

1307: ,ln_asg_act_to_lock
1308: ,ln_gre_id_null;
1309:
1310: if get_all_t4a_amend_dtls%notfound then
1311: hr_utility.trace('get_all_t4a_amend_dtls not found ');
1312: exit;
1313: end if;
1314:
1315: open c_get_fed_amend_flag(ln_asg_act_to_lock,

Line 1325: hr_utility.trace('lv_fed_amend_flag : '||lv_fed_amend_flag);

1321:
1322: fetch c_get_fed_amend_flag into lv_fed_amend_flag;
1323: exit when c_get_fed_amend_flag%NOTFOUND;
1324:
1325: hr_utility.trace('lv_fed_amend_flag : '||lv_fed_amend_flag);
1326:
1327: if c_get_fed_amend_flag%FOUND then
1328:
1329: if lv_fed_amend_flag = 'Y' then

Line 1342: hr_utility.trace('get_all_t4a_amend_dtls found ');

1338: fetch get_yepp_pact_id into ln_yepp_pact_id;
1339: close get_yepp_pact_id;
1340:
1341:
1342: hr_utility.trace('get_all_t4a_amend_dtls found ');
1343: hr_utility.trace('Report Type: '||lv_report_type);
1344:
1345: /* Create an assignment action for this person */
1346:

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

1339: close get_yepp_pact_id;
1340:
1341:
1342: hr_utility.trace('get_all_t4a_amend_dtls found ');
1343: hr_utility.trace('Report Type: '||lv_report_type);
1344:
1345: /* Create an assignment action for this person */
1346:
1347: select pay_assignment_actions_s.nextval

Line 1351: hr_utility.trace('New T4A Amend Action = ' || ln_t4a_amend_reg_asg_action);

1347: select pay_assignment_actions_s.nextval
1348: into ln_t4a_amend_reg_asg_action
1349: from dual;
1350:
1351: hr_utility.trace('New T4A Amend Action = ' || ln_t4a_amend_reg_asg_action);
1352:
1353: /* Insert into pay_assignment_actions. */
1354: hr_nonrun_asact.insact(ln_t4a_amend_reg_asg_action
1355: ,ln_primary_assignment_id

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

1370: ***********************************************************/
1371: ln_serial_number := lpad(to_char(ln_asg_act_to_lock),14,0)||
1372: lpad(to_char(ln_yepp_pact_id),14,0);
1373:
1374: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
1375: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
1376:
1377: update pay_assignment_actions aa
1378: set aa.serial_number = ln_serial_number

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

1371: ln_serial_number := lpad(to_char(ln_asg_act_to_lock),14,0)||
1372: lpad(to_char(ln_yepp_pact_id),14,0);
1373:
1374: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
1375: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
1376:
1377: update pay_assignment_actions aa
1378: set aa.serial_number = ln_serial_number
1379: where aa.assignment_action_id = ln_t4a_amend_reg_asg_action;

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

1391: end if; /* Else condition of report type PAYCAT4AAMPDF end */
1392: END action_creation;
1393:
1394: BEGIN
1395: hr_utility.trace('Entered action_creation ');
1396: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
1397: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
1398: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
1399: hr_utility.trace('p_chunk = ' || to_char(p_chunk));

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

1392: END action_creation;
1393:
1394: BEGIN
1395: hr_utility.trace('Entered action_creation ');
1396: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
1397: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
1398: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
1399: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
1400:

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

1393:
1394: BEGIN
1395: hr_utility.trace('Entered action_creation ');
1396: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
1397: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
1398: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
1399: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
1400:
1401: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id

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

1394: BEGIN
1395: hr_utility.trace('Entered action_creation ');
1396: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
1397: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
1398: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
1399: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
1400:
1401: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
1402: ,p_start_date => ld_start_date

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

1395: hr_utility.trace('Entered action_creation ');
1396: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
1397: hr_utility.trace('p_start_person_id ='|| to_char(p_start_person_id));
1398: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
1399: hr_utility.trace('p_chunk = ' || to_char(p_chunk));
1400:
1401: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
1402: ,p_start_date => ld_start_date
1403: ,p_end_date => ld_end_date

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

1412: ,p_report_cat => l_report_cat
1413: ,p_print_term => l_print_term);
1414: -- Added for bug 10399514
1415:
1416: hr_utility.trace('lv_ppr_report_type: '||lv_ppr_report_type);
1417:
1418: ln_tax_unit_id := ln_gre_parameter;
1419:
1420: -- Code modification for bug 10399514 start here

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

1444: action_creation(p_start_person_id);
1445:
1446: elsif ln_asg_set is not null then
1447:
1448: hr_utility.trace('Entered Asg Set logic');
1449: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
1450: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1451: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1452:

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

1445:
1446: elsif ln_asg_set is not null then
1447:
1448: hr_utility.trace('Entered Asg Set logic');
1449: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
1450: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1451: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1452:
1453: -- Code modification for bug 10399514 start here

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

1446: elsif ln_asg_set is not null then
1447:
1448: hr_utility.trace('Entered Asg Set logic');
1449: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
1450: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1451: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1452:
1453: -- Code modification for bug 10399514 start here
1454: if l_person_on then

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

1447:
1448: hr_utility.trace('Entered Asg Set logic');
1449: hr_utility.trace('Asg Set ='||to_char(ln_asg_set));
1450: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1451: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1452:
1453: -- Code modification for bug 10399514 start here
1454: if l_person_on then
1455: hr_utility.trace('opening c_selected_asg_set_range CURSOR');

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

1451: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1452:
1453: -- Code modification for bug 10399514 start here
1454: if l_person_on then
1455: hr_utility.trace('opening c_selected_asg_set_range CURSOR');
1456: OPEN c_selected_asg_set_range (p_start_person_id
1457: ,p_end_person_id
1458: ,ln_asg_set
1459: ,ld_end_date);

Line 1461: hr_utility.trace('opening c_selected_asg_set CURSOR');

1457: ,p_end_person_id
1458: ,ln_asg_set
1459: ,ld_end_date);
1460: else
1461: hr_utility.trace('opening c_selected_asg_set CURSOR');
1462: OPEN c_selected_asg_set (p_start_person_id
1463: ,p_end_person_id
1464: ,ln_asg_set
1465: ,ld_end_date);

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

1468: -- Code modification for bug 10399514 ends here
1469: loop
1470: -- Code modification for bug 10399514 starts here
1471: if l_person_on then
1472: hr_utility.trace('fetching from c_selected_asg_set_range CURSOR');
1473: fetch c_selected_asg_set_range
1474: into ln_set_person_id;
1475: exit when c_selected_asg_set_range%NOTFOUND;
1476: else

Line 1477: hr_utility.trace('fetching from c_selected_asg_set CURSOR');

1473: fetch c_selected_asg_set_range
1474: into ln_set_person_id;
1475: exit when c_selected_asg_set_range%NOTFOUND;
1476: else
1477: hr_utility.trace('fetching from c_selected_asg_set CURSOR');
1478: fetch c_selected_asg_set
1479: into ln_set_person_id;
1480: exit when c_selected_asg_set%NOTFOUND;
1481: end if ;

Line 1484: hr_utility.trace('Assignment Set Person ='||to_char(ln_set_person_id));

1480: exit when c_selected_asg_set%NOTFOUND;
1481: end if ;
1482: -- Code modification for bug 10399514 ends here
1483:
1484: hr_utility.trace('Assignment Set Person ='||to_char(ln_set_person_id));
1485: action_creation(ln_set_person_id);
1486:
1487: end loop;
1488: -- Code modification for bug 10399514 starts here

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

1486:
1487: end loop;
1488: -- Code modification for bug 10399514 starts here
1489: if l_person_on then
1490: hr_utility.trace('closing c_selected_asg_set_range CURSOR');
1491: close c_selected_asg_set_range;
1492: else
1493: hr_utility.trace('closing c_selected_asg_set CURSOR');
1494: close c_selected_asg_set;

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

1489: if l_person_on then
1490: hr_utility.trace('closing c_selected_asg_set_range CURSOR');
1491: close c_selected_asg_set_range;
1492: else
1493: hr_utility.trace('closing c_selected_asg_set CURSOR');
1494: close c_selected_asg_set;
1495: end if ;
1496: -- Code modification for bug 10399514 ends here
1497: elsif ln_tax_unit_id is not null then

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

1495: end if ;
1496: -- Code modification for bug 10399514 ends here
1497: elsif ln_tax_unit_id is not null then
1498:
1499: hr_utility.trace('Entered GRE not null logic');
1500: hr_utility.trace('GRE ='||to_char(ln_tax_unit_id));
1501: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1502: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1503:

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

1496: -- Code modification for bug 10399514 ends here
1497: elsif ln_tax_unit_id is not null then
1498:
1499: hr_utility.trace('Entered GRE not null logic');
1500: hr_utility.trace('GRE ='||to_char(ln_tax_unit_id));
1501: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1502: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1503:
1504: -- Code modification for bug 10399514 start here

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

1497: elsif ln_tax_unit_id is not null then
1498:
1499: hr_utility.trace('Entered GRE not null logic');
1500: hr_utility.trace('GRE ='||to_char(ln_tax_unit_id));
1501: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1502: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1503:
1504: -- Code modification for bug 10399514 start here
1505: if l_person_on then

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

1498:
1499: hr_utility.trace('Entered GRE not null logic');
1500: hr_utility.trace('GRE ='||to_char(ln_tax_unit_id));
1501: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1502: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1503:
1504: -- Code modification for bug 10399514 start here
1505: if l_person_on then
1506: hr_utility.trace('opening c_all_asg_range CURSOR');

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

1502: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1503:
1504: -- Code modification for bug 10399514 start here
1505: if l_person_on then
1506: hr_utility.trace('opening c_all_asg_range CURSOR');
1507: OPEN c_all_asg_range (ln_business_group_id
1508: ,ln_tax_unit_id
1509: ,ld_end_date
1510: ,p_start_person_id

Line 1513: hr_utility.trace('opening c_all_asg CURSOR');

1509: ,ld_end_date
1510: ,p_start_person_id
1511: ,p_end_person_id);
1512: else
1513: hr_utility.trace('opening c_all_asg CURSOR');
1514: OPEN c_all_asg (ln_business_group_id
1515: ,ln_tax_unit_id
1516: ,ld_end_date
1517: ,p_start_person_id

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

1521: -- Code modification for bug 10399514 ends here
1522: loop
1523: -- Code modification for bug 10399514 starts here
1524: if l_person_on then
1525: hr_utility.trace('fetching from c_all_asg_range CURSOR');
1526: fetch c_all_asg_range
1527: into ln_set_person_id;
1528: exit when c_all_asg_range%NOTFOUND;
1529: else

Line 1530: hr_utility.trace('fetching from c_all_asg CURSOR');

1526: fetch c_all_asg_range
1527: into ln_set_person_id;
1528: exit when c_all_asg_range%NOTFOUND;
1529: else
1530: hr_utility.trace('fetching from c_all_asg CURSOR');
1531: fetch c_all_asg
1532: into ln_set_person_id;
1533: exit when c_all_asg%NOTFOUND;
1534: end if ;

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

1539:
1540: end loop;
1541: -- Code modification for bug 10399514 starts here
1542: if l_person_on then
1543: hr_utility.trace('closing c_all_asg_range CURSOR');
1544: close c_all_asg_range;
1545: else
1546: hr_utility.trace('closing c_all_asg CURSOR');
1547: close c_all_asg;

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

1542: if l_person_on then
1543: hr_utility.trace('closing c_all_asg_range CURSOR');
1544: close c_all_asg_range;
1545: else
1546: hr_utility.trace('closing c_all_asg CURSOR');
1547: close c_all_asg;
1548: end if ;
1549: -- Code modification for bug 10399514 ends here
1550:

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

1549: -- Code modification for bug 10399514 ends here
1550:
1551: else
1552:
1553: hr_utility.trace('Entered All GRE logic');
1554:
1555: open c_all_gres(ln_business_group_id,
1556: ld_end_date);
1557:

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

1559:
1560: fetch c_all_gres into ln_gre_id;
1561:
1562: if c_all_gres%NOTFOUND then
1563: hr_utility.trace('c_all_gres NOT FOUND');
1564: exit;
1565: end if;
1566:
1567: hr_utility.trace('GRE ='||to_char(ln_gre_id));

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

1563: hr_utility.trace('c_all_gres NOT FOUND');
1564: exit;
1565: end if;
1566:
1567: hr_utility.trace('GRE ='||to_char(ln_gre_id));
1568: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1569: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1570:
1571: -- Code modification for bug 10399514 start here

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

1564: exit;
1565: end if;
1566:
1567: hr_utility.trace('GRE ='||to_char(ln_gre_id));
1568: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1569: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1570:
1571: -- Code modification for bug 10399514 start here
1572: if l_person_on then

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

1565: end if;
1566:
1567: hr_utility.trace('GRE ='||to_char(ln_gre_id));
1568: hr_utility.trace('p_start_person_id ='||to_char(p_start_person_id));
1569: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1570:
1571: -- Code modification for bug 10399514 start here
1572: if l_person_on then
1573: hr_utility.trace('opening c_all_asg_range CURSOR');

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

1569: hr_utility.trace('End Person ='||to_char(p_end_person_id));
1570:
1571: -- Code modification for bug 10399514 start here
1572: if l_person_on then
1573: hr_utility.trace('opening c_all_asg_range CURSOR');
1574: OPEN c_all_asg_range (ln_business_group_id
1575: ,ln_gre_id
1576: ,ld_end_date
1577: ,p_start_person_id

Line 1580: hr_utility.trace('opening c_all_asg CURSOR');

1576: ,ld_end_date
1577: ,p_start_person_id
1578: ,p_end_person_id);
1579: else
1580: hr_utility.trace('opening c_all_asg CURSOR');
1581: OPEN c_all_asg (ln_business_group_id
1582: ,ln_gre_id
1583: ,ld_end_date
1584: ,p_start_person_id

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

1590: loop -- c_all_asg
1591:
1592: -- Code modification for bug 10399514 starts here
1593: if l_person_on then
1594: hr_utility.trace('fetching from c_all_asg_range CURSOR');
1595: fetch c_all_asg_range
1596: into ln_set_person_id;
1597: exit when c_all_asg_range%NOTFOUND;
1598: else

Line 1599: hr_utility.trace('fetching from c_all_asg CURSOR');

1595: fetch c_all_asg_range
1596: into ln_set_person_id;
1597: exit when c_all_asg_range%NOTFOUND;
1598: else
1599: hr_utility.trace('fetching from c_all_asg CURSOR');
1600: fetch c_all_asg
1601: into ln_set_person_id;
1602: exit when c_all_asg%NOTFOUND;
1603: end if ;

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

1608:
1609: end loop; -- c_all_asg
1610: -- Code modification for bug 10399514 starts here
1611: if l_person_on then
1612: hr_utility.trace('closing c_all_asg_range CURSOR');
1613: close c_all_asg_range;
1614: else
1615: hr_utility.trace('closing c_all_asg CURSOR');
1616: close c_all_asg;

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

1611: if l_person_on then
1612: hr_utility.trace('closing c_all_asg_range CURSOR');
1613: close c_all_asg_range;
1614: else
1615: hr_utility.trace('closing c_all_asg CURSOR');
1616: close c_all_asg;
1617: end if ;
1618: -- Code modification for bug 10399514 ends here
1619:

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

1635: len out nocopy number
1636: ) is
1637:
1638: begin
1639: hr_utility.trace('Beginning of the sort_action cursor');
1640:
1641: sqlstr := 'select paa1.rowid
1642: from hr_all_organization_units hou,
1643: hr_all_organization_units hou1,

Line 1725: /* hr_utility.trace_on(null,'T4AAMEND_REG'); */

1721:
1722: END get_parameter;
1723:
1724: Begin
1725: /* hr_utility.trace_on(null,'T4AAMEND_REG'); */
1726: null;
1727:
1728:
1729: end pay_ca_eoy_t4a_amend_reg;