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

Line 113: --hr_utility.trace_on('Y','RL2AMD');

109: p_business_group_id IN OUT NOCOPY NUMBER,
110: p_legislative_param IN OUT NOCOPY VARCHAR2
111: ) IS
112: BEGIN
113: --hr_utility.trace_on('Y','RL2AMD');
114: hr_utility.set_location('pay_ca_rl2_amend_mag.get_report_parameters', 10);
115:
116: SELECT ppa.start_date,
117: ppa.effective_date,

Line 114: hr_utility.set_location('pay_ca_rl2_amend_mag.get_report_parameters', 10);

110: p_legislative_param IN OUT NOCOPY VARCHAR2
111: ) IS
112: BEGIN
113: --hr_utility.trace_on('Y','RL2AMD');
114: hr_utility.set_location('pay_ca_rl2_amend_mag.get_report_parameters', 10);
115:
116: SELECT ppa.start_date,
117: ppa.effective_date,
118: ppa.business_group_id,

Line 129: hr_utility.set_location('pay_ca_rl2_amend_mag.get_report_parameters', 20);

125: p_legislative_param
126: FROM pay_payroll_actions ppa
127: WHERE payroll_action_id = p_pactid;
128:
129: hr_utility.set_location('pay_ca_rl2_amend_mag.get_report_parameters', 20);
130:
131: END get_report_parameters;
132:
133: ---------------------------------------------------------------------------

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

200:
201: l_transmitter_org_id := pay_ca_rl2_mag.get_parameter('TRANSMITTER_PRE',
202: l_legislative_parameters);
203:
204: hr_utility.trace('l_transmitter_org_id = ' || to_char(l_transmitter_org_id));
205: hr_utility.trace('p_bg_id = ' || to_char(p_bg_id));
206: hr_utility.trace('p_payroll_action_id = ' || to_char(p_payroll_action_id));
207: hr_utility.trace('p_effective_date = ' || to_char(p_effective_date));
208:

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

201: l_transmitter_org_id := pay_ca_rl2_mag.get_parameter('TRANSMITTER_PRE',
202: l_legislative_parameters);
203:
204: hr_utility.trace('l_transmitter_org_id = ' || to_char(l_transmitter_org_id));
205: hr_utility.trace('p_bg_id = ' || to_char(p_bg_id));
206: hr_utility.trace('p_payroll_action_id = ' || to_char(p_payroll_action_id));
207: hr_utility.trace('p_effective_date = ' || to_char(p_effective_date));
208:
209: OPEN cur_arch_pactid(l_transmitter_org_id);

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

202: l_legislative_parameters);
203:
204: hr_utility.trace('l_transmitter_org_id = ' || to_char(l_transmitter_org_id));
205: hr_utility.trace('p_bg_id = ' || to_char(p_bg_id));
206: hr_utility.trace('p_payroll_action_id = ' || to_char(p_payroll_action_id));
207: hr_utility.trace('p_effective_date = ' || to_char(p_effective_date));
208:
209: OPEN cur_arch_pactid(l_transmitter_org_id);
210: FETCH cur_arch_pactid

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

203:
204: hr_utility.trace('l_transmitter_org_id = ' || to_char(l_transmitter_org_id));
205: hr_utility.trace('p_bg_id = ' || to_char(p_bg_id));
206: hr_utility.trace('p_payroll_action_id = ' || to_char(p_payroll_action_id));
207: hr_utility.trace('p_effective_date = ' || to_char(p_effective_date));
208:
209: OPEN cur_arch_pactid(l_transmitter_org_id);
210: FETCH cur_arch_pactid
211: INTO l_arch_pactid;

Line 226: hr_utility.trace('l_transmitter_number = ' || l_transmitter_number);

222:
223:
224: BEGIN
225:
226: hr_utility.trace('l_transmitter_number = ' || l_transmitter_number);
227: SELECT substr(l_transmitter_number,1,2)
228: INTO dummy1
229: FROM dual;
230:

Line 242: hr_utility.set_message(800,'PAY_CA_RL1_INVALID_TRANSMITTER');

238: FROM dual;
239:
240: EXCEPTION
241: WHEN INVALID_NUMBER THEN
242: hr_utility.set_message(800,'PAY_CA_RL1_INVALID_TRANSMITTER');
243: hr_utility.set_message_token('PRE_NAME',l_transmitter_name);
244: pay_core_utils.push_message(800,'PAY_CA_RL1_INVALID_TRANSMITTER','P');
245: pay_core_utils.push_token('PRE_NAME',l_transmitter_name);
246: hr_utility.raise_error;

Line 243: hr_utility.set_message_token('PRE_NAME',l_transmitter_name);

239:
240: EXCEPTION
241: WHEN INVALID_NUMBER THEN
242: hr_utility.set_message(800,'PAY_CA_RL1_INVALID_TRANSMITTER');
243: hr_utility.set_message_token('PRE_NAME',l_transmitter_name);
244: pay_core_utils.push_message(800,'PAY_CA_RL1_INVALID_TRANSMITTER','P');
245: pay_core_utils.push_token('PRE_NAME',l_transmitter_name);
246: hr_utility.raise_error;
247: END;

Line 246: hr_utility.raise_error;

242: hr_utility.set_message(800,'PAY_CA_RL1_INVALID_TRANSMITTER');
243: hr_utility.set_message_token('PRE_NAME',l_transmitter_name);
244: pay_core_utils.push_message(800,'PAY_CA_RL1_INVALID_TRANSMITTER','P');
245: pay_core_utils.push_token('PRE_NAME',l_transmitter_name);
246: hr_utility.raise_error;
247: END;
248:
249: hr_utility.trace('l_type_of_package = ' || l_type_of_package);
250:

Line 249: hr_utility.trace('l_type_of_package = ' || l_type_of_package);

245: pay_core_utils.push_token('PRE_NAME',l_transmitter_name);
246: hr_utility.raise_error;
247: END;
248:
249: hr_utility.trace('l_type_of_package = ' || l_type_of_package);
250:
251: IF l_type_of_package IS NULL THEN
252: pay_core_utils.push_message(800,'PAY_CA_RL1_MISSING_TYPE_OF_PKG','P');
253: hr_utility.raise_error;

Line 253: hr_utility.raise_error;

249: hr_utility.trace('l_type_of_package = ' || l_type_of_package);
250:
251: IF l_type_of_package IS NULL THEN
252: pay_core_utils.push_message(800,'PAY_CA_RL1_MISSING_TYPE_OF_PKG','P');
253: hr_utility.raise_error;
254: END IF;
255:
256: hr_utility.trace('l_source_of_slips = ' || l_source_of_slips);
257:

Line 256: hr_utility.trace('l_source_of_slips = ' || l_source_of_slips);

252: pay_core_utils.push_message(800,'PAY_CA_RL1_MISSING_TYPE_OF_PKG','P');
253: hr_utility.raise_error;
254: END IF;
255:
256: hr_utility.trace('l_source_of_slips = ' || l_source_of_slips);
257:
258: IF l_source_of_slips IS NULL THEN
259: pay_core_utils.push_message(800,'PAY_CA_RL1_MISSING_RLSLIP_SRC','P');
260: hr_utility.raise_error;

Line 260: hr_utility.raise_error;

256: hr_utility.trace('l_source_of_slips = ' || l_source_of_slips);
257:
258: IF l_source_of_slips IS NULL THEN
259: pay_core_utils.push_message(800,'PAY_CA_RL1_MISSING_RLSLIP_SRC','P');
260: hr_utility.raise_error;
261: END IF;
262:
263: hr_utility.trace('l_address_line1 = ' || l_address_line1);
264:

Line 263: hr_utility.trace('l_address_line1 = ' || l_address_line1);

259: pay_core_utils.push_message(800,'PAY_CA_RL1_MISSING_RLSLIP_SRC','P');
260: hr_utility.raise_error;
261: END IF;
262:
263: hr_utility.trace('l_address_line1 = ' || l_address_line1);
264:
265: IF l_address_line1 IS NULL THEN
266: pay_core_utils.push_message(800,'PAY_CA_RL1_MISSING_TRNMTR_ADDR','P');
267: hr_utility.raise_error;

Line 267: hr_utility.raise_error;

263: hr_utility.trace('l_address_line1 = ' || l_address_line1);
264:
265: IF l_address_line1 IS NULL THEN
266: pay_core_utils.push_message(800,'PAY_CA_RL1_MISSING_TRNMTR_ADDR','P');
267: hr_utility.raise_error;
268: END IF;
269:
270: END;
271:

Line 299: hr_utility.set_location( 'pay_ca_rl2_amend_mag.range_cursor', 10);

295: p_legislative_param pay_payroll_actions.legislative_parameters%type;
296:
297: BEGIN
298:
299: hr_utility.set_location( 'pay_ca_rl2_amend_mag.range_cursor', 10);
300:
301: get_report_parameters(
302: p_pactid,
303: p_year_start,

Line 310: hr_utility.set_location( 'pay_ca_rl2_amend_mag.range_cursor', 20);

306: p_business_group_id,
307: p_legislative_param
308: );
309:
310: hr_utility.set_location( 'pay_ca_rl2_amend_mag.range_cursor', 20);
311: p_sqlstr := 'select distinct to_number(emp.person_id)
312: from pay_ca_eoy_rl2_employee_info_v emp,
313: pay_ca_eoy_rl2_trans_info_v tran,
314: pay_assignment_actions paa_arch,

Line 337: hr_utility.set_location( 'pay_ca_rl2_amend_mag.range_cursor',30);

333: and hoi.org_information_context =''Prov Reporting Est''
334: and to_char(hoi.organization_id) = pycadar_pkg.get_parameter(''PRE_ORGANIZATION_ID'',ppa_arch.legislative_parameters)
335: order by to_number(emp.person_id)' ;
336:
337: hr_utility.set_location( 'pay_ca_rl2_amend_mag.range_cursor',30);
338:
339: END range_cursor;
340:
341: -------------------------------------------------------------------------------

Line 559: hr_utility.set_location( 'pay_ca_rl2_amend_mag.create_assignment_act',10);

555:
556:
557: -- Get the report parameters. These define the report being run.
558: l_prev_payact := -1;
559: hr_utility.set_location( 'pay_ca_rl2_amend_mag.create_assignment_act',10);
560:
561: get_report_parameters(
562: p_pactid,
563: l_year_start,

Line 576: hr_utility.set_location( 'pay_ca_rl2_amend_mag.create_assignment_act',20);

572: l_year_end);
573:
574: --Open the appropriate cursor
575:
576: hr_utility.set_location( 'pay_ca_rl2_amend_mag.create_assignment_act',20);
577: hr_utility.trace('Report type '||l_report_type);
578: IF l_report_type = 'RL2_AMEND_MAG' THEN
579:
580: OPEN c_all_asg(l_legislative_param,

Line 577: hr_utility.trace('Report type '||l_report_type);

573:
574: --Open the appropriate cursor
575:
576: hr_utility.set_location( 'pay_ca_rl2_amend_mag.create_assignment_act',20);
577: hr_utility.trace('Report type '||l_report_type);
578: IF l_report_type = 'RL2_AMEND_MAG' THEN
579:
580: OPEN c_all_asg(l_legislative_param,
581: l_business_group_id,

Line 592: hr_utility.set_location('pay_ca_rl2_amend_mag.create_assignment_act', 30);

588: l_effective_end_date,
589: l_assignment_action_id,
590: l_payroll_act;
591:
592: hr_utility.set_location('pay_ca_rl2_amend_mag.create_assignment_act', 30);
593:
594: EXIT WHEN c_all_asg%NOTFOUND;
595:
596: --Create the assignment action for the record

Line 601: hr_utility.trace('The payroll action id '||l_payroll_act);

597:
598: /* Validating QIN Number information */
599: if l_prev_payact <> l_payroll_act and l_report_type = 'CAEOY_RL2_AMEND_PP'then
600:
601: hr_utility.trace('The payroll action id '||l_payroll_act);
602:
603: OPEN get_emplyr_info(l_business_group_id,l_payroll_act);
604: FETCH get_emplyr_info
605: INTO l_emplyer_name,

Line 612: hr_utility.trace('The Quebec Number is '||l_quebec_no);

608: CLOSE get_emplyr_info;
609:
610: l_prev_payact := l_payroll_act;
611:
612: hr_utility.trace('The Quebec Number is '||l_quebec_no);
613: l_file_no := substr(l_quebec_no,13,4);
614: l_quebec_no := substr(l_quebec_no ,1,10);
615:
616: /* Fix for Bug# 4038551 */

Line 622: hr_utility.raise_error;

618: length(l_file_no) < 4
619: then
620: pay_core_utils.push_message(801,'PAY_74156_INCORRECT_QIN_INFO','P');
621: pay_core_utils.push_token('PRE_NAME',l_emplyer_name);
622: hr_utility.raise_error;
623: end if;
624:
625:
626: /* Erroring out the RL2 Electronic Interface if any of the

Line 632: hr_utility.raise_error;

628:
629: if l_addr_line = ' '
630: then
631: pay_core_utils.push_message(800,'PAY_CA_RL2_MISSING_ADDRESS','P');
632: hr_utility.raise_error;
633: end if;
634: hr_utility.trace('First 10 digits of the QIN: '||l_quebec_no);
635: l_return := pay_ca_rl2_mag.validate_quebec_number(l_quebec_no,l_emplyer_name);
636:

Line 634: hr_utility.trace('First 10 digits of the QIN: '||l_quebec_no);

630: then
631: pay_core_utils.push_message(800,'PAY_CA_RL2_MISSING_ADDRESS','P');
632: hr_utility.raise_error;
633: end if;
634: hr_utility.trace('First 10 digits of the QIN: '||l_quebec_no);
635: l_return := pay_ca_rl2_mag.validate_quebec_number(l_quebec_no,l_emplyer_name);
636:
637: end if ;
638: hr_utility.trace('Assignment Fetched - ');

Line 638: hr_utility.trace('Assignment Fetched - ');

634: hr_utility.trace('First 10 digits of the QIN: '||l_quebec_no);
635: l_return := pay_ca_rl2_mag.validate_quebec_number(l_quebec_no,l_emplyer_name);
636:
637: end if ;
638: hr_utility.trace('Assignment Fetched - ');
639: hr_utility.trace('Assignment Id : '|| to_char(l_assignment_id));
640: hr_utility.trace('Person Id : '|| to_char(l_person_id));
641: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
642: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date));

Line 639: hr_utility.trace('Assignment Id : '|| to_char(l_assignment_id));

635: l_return := pay_ca_rl2_mag.validate_quebec_number(l_quebec_no,l_emplyer_name);
636:
637: end if ;
638: hr_utility.trace('Assignment Fetched - ');
639: hr_utility.trace('Assignment Id : '|| to_char(l_assignment_id));
640: hr_utility.trace('Person Id : '|| to_char(l_person_id));
641: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
642: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date));
643:

Line 640: hr_utility.trace('Person Id : '|| to_char(l_person_id));

636:
637: end if ;
638: hr_utility.trace('Assignment Fetched - ');
639: hr_utility.trace('Assignment Id : '|| to_char(l_assignment_id));
640: hr_utility.trace('Person Id : '|| to_char(l_person_id));
641: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
642: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date));
643:
644: hr_utility.set_location('pay_ca_rl2_amend_mag.create_assignment_act', 40);

Line 641: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));

637: end if ;
638: hr_utility.trace('Assignment Fetched - ');
639: hr_utility.trace('Assignment Id : '|| to_char(l_assignment_id));
640: hr_utility.trace('Person Id : '|| to_char(l_person_id));
641: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
642: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date));
643:
644: hr_utility.set_location('pay_ca_rl2_amend_mag.create_assignment_act', 40);
645:

Line 642: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date));

638: hr_utility.trace('Assignment Fetched - ');
639: hr_utility.trace('Assignment Id : '|| to_char(l_assignment_id));
640: hr_utility.trace('Person Id : '|| to_char(l_person_id));
641: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
642: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date));
643:
644: hr_utility.set_location('pay_ca_rl2_amend_mag.create_assignment_act', 40);
645:
646: /* Create an assignment action for this person */

Line 644: hr_utility.set_location('pay_ca_rl2_amend_mag.create_assignment_act', 40);

640: hr_utility.trace('Person Id : '|| to_char(l_person_id));
641: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
642: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date));
643:
644: hr_utility.set_location('pay_ca_rl2_amend_mag.create_assignment_act', 40);
645:
646: /* Create an assignment action for this person */
647:
648: select pay_assignment_actions_s.nextval

Line 651: hr_utility.set_location('pay_ca_rl2_amend_mag.create_assignement_act', 50);

647:
648: select pay_assignment_actions_s.nextval
649: into lockingactid
650: from dual;
651: hr_utility.set_location('pay_ca_rl2_amend_mag.create_assignement_act', 50);
652: hr_utility.trace('New RL2 Amend Action = ' ||
653: to_char(lockingactid));
654:
655: open get_latest_rl2_amend_dtls(l_person_id,

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

648: select pay_assignment_actions_s.nextval
649: into lockingactid
650: from dual;
651: hr_utility.set_location('pay_ca_rl2_amend_mag.create_assignement_act', 50);
652: hr_utility.trace('New RL2 Amend Action = ' ||
653: to_char(lockingactid));
654:
655: open get_latest_rl2_amend_dtls(l_person_id,
656: --l_tax_unit_id,

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

672: fetch get_warning_dtls_for_ee into lv_full_name
673: ,lv_employee_number;
674: close get_warning_dtls_for_ee;
675:
676: hr_utility.trace('get_latest_rl2_amend_dtls not found');
677: hr_utility.trace('p_person_id :'||to_char(l_person_id));
678:
679:
680: lv_record_name := 'RL2 Amendment Magnetic Media';

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

673: ,lv_employee_number;
674: close get_warning_dtls_for_ee;
675:
676: hr_utility.trace('get_latest_rl2_amend_dtls not found');
677: hr_utility.trace('p_person_id :'||to_char(l_person_id));
678:
679:
680: lv_record_name := 'RL2 Amendment Magnetic Media';
681:

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

700: open c_get_prov_amend_flag(ln_asg_act_to_lock);
701: lv_prov_amend_flag := 'N';
702: fetch c_get_prov_amend_flag into lv_prov_amend_flag;
703:
704: hr_utility.trace('lv_prov_amend_flag : '||lv_prov_amend_flag);
705: if c_get_prov_amend_flag%FOUND then
706: --To make sure that only the latest amendment details are printed
707: if lv_prov_amend_flag = 'Y' AND lv_flag_count = 0 then
708:

Line 727: hr_utility.set_location('pay_ca_rl2_amend_mag.create_assignement_act', 60);

723: set aa.serial_number = to_char(l_person_id)
724: where aa.assignment_action_id = lockingactid;
725:
726: --Added to lock the Amend Archiver
727: hr_utility.set_location('pay_ca_rl2_amend_mag.create_assignement_act', 60);
728: hr_nonrun_asact.insint(lockingactid
729: ,ln_asg_act_to_lock);
730: hr_utility.set_location('pay_ca_rl2_amend_mag.create_assignement_act', 70);
731: hr_utility.trace('Locking Action'||lockingactid);

Line 730: hr_utility.set_location('pay_ca_rl2_amend_mag.create_assignement_act', 70);

726: --Added to lock the Amend Archiver
727: hr_utility.set_location('pay_ca_rl2_amend_mag.create_assignement_act', 60);
728: hr_nonrun_asact.insint(lockingactid
729: ,ln_asg_act_to_lock);
730: hr_utility.set_location('pay_ca_rl2_amend_mag.create_assignement_act', 70);
731: hr_utility.trace('Locking Action'||lockingactid);
732: hr_utility.trace('Locked Action = ' || to_char(ln_asg_act_to_lock));
733: hr_utility.trace('lv_flag_count = ' || to_char(lv_flag_count));
734: lv_flag_count := lv_flag_count + 1;

Line 731: hr_utility.trace('Locking Action'||lockingactid);

727: hr_utility.set_location('pay_ca_rl2_amend_mag.create_assignement_act', 60);
728: hr_nonrun_asact.insint(lockingactid
729: ,ln_asg_act_to_lock);
730: hr_utility.set_location('pay_ca_rl2_amend_mag.create_assignement_act', 70);
731: hr_utility.trace('Locking Action'||lockingactid);
732: hr_utility.trace('Locked Action = ' || to_char(ln_asg_act_to_lock));
733: hr_utility.trace('lv_flag_count = ' || to_char(lv_flag_count));
734: lv_flag_count := lv_flag_count + 1;
735: end if; -- lv_prov_amend_flag = 'Y'

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

728: hr_nonrun_asact.insint(lockingactid
729: ,ln_asg_act_to_lock);
730: hr_utility.set_location('pay_ca_rl2_amend_mag.create_assignement_act', 70);
731: hr_utility.trace('Locking Action'||lockingactid);
732: hr_utility.trace('Locked Action = ' || to_char(ln_asg_act_to_lock));
733: hr_utility.trace('lv_flag_count = ' || to_char(lv_flag_count));
734: lv_flag_count := lv_flag_count + 1;
735: end if; -- lv_prov_amend_flag = 'Y'
736:

Line 733: hr_utility.trace('lv_flag_count = ' || to_char(lv_flag_count));

729: ,ln_asg_act_to_lock);
730: hr_utility.set_location('pay_ca_rl2_amend_mag.create_assignement_act', 70);
731: hr_utility.trace('Locking Action'||lockingactid);
732: hr_utility.trace('Locked Action = ' || to_char(ln_asg_act_to_lock));
733: hr_utility.trace('lv_flag_count = ' || to_char(lv_flag_count));
734: lv_flag_count := lv_flag_count + 1;
735: end if; -- lv_prov_amend_flag = 'Y'
736:
737: end if; -- c_get_prov_amend_flag%FOUND

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

746: if lv_report_type in ('RL2_XML_MAG','RL2_AMEND_MAG') then
747:
748: open c_paa_update_check(lockingactid);
749: fetch c_paa_update_check into l_paa_update_check;
750: hr_utility.trace('l_update_check : '||l_paa_update_check);
751: if c_paa_update_check%FOUND then
752:
753: /***********************************************************
754: ** Update the serial number column with Province_code QC,

Line 764: hr_utility.set_location('pay_ca_rl2_amend_mag.create_assignement_act', 60);

760: set aa.serial_number = to_char(l_person_id)
761: where aa.assignment_action_id = lockingactid;
762:
763: --Added to lock the previous mag Reports
764: hr_utility.set_location('pay_ca_rl2_amend_mag.create_assignement_act', 60);
765: hr_nonrun_asact.insint(lockingactid
766: ,ln_asg_act_to_lock);
767: hr_utility.set_location('pay_ca_rl2_amend_mag.create_assignement_act', 70);
768: hr_utility.trace('Locking Action'||lockingactid);

Line 767: hr_utility.set_location('pay_ca_rl2_amend_mag.create_assignement_act', 70);

763: --Added to lock the previous mag Reports
764: hr_utility.set_location('pay_ca_rl2_amend_mag.create_assignement_act', 60);
765: hr_nonrun_asact.insint(lockingactid
766: ,ln_asg_act_to_lock);
767: hr_utility.set_location('pay_ca_rl2_amend_mag.create_assignement_act', 70);
768: hr_utility.trace('Locking Action'||lockingactid);
769: hr_utility.trace('Locked Action = ' || to_char(ln_asg_act_to_lock));
770:
771: end if; --c_paa_update_check%FOUND

Line 768: hr_utility.trace('Locking Action'||lockingactid);

764: hr_utility.set_location('pay_ca_rl2_amend_mag.create_assignement_act', 60);
765: hr_nonrun_asact.insint(lockingactid
766: ,ln_asg_act_to_lock);
767: hr_utility.set_location('pay_ca_rl2_amend_mag.create_assignement_act', 70);
768: hr_utility.trace('Locking Action'||lockingactid);
769: hr_utility.trace('Locked Action = ' || to_char(ln_asg_act_to_lock));
770:
771: end if; --c_paa_update_check%FOUND
772: close c_paa_update_check;

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

765: hr_nonrun_asact.insint(lockingactid
766: ,ln_asg_act_to_lock);
767: hr_utility.set_location('pay_ca_rl2_amend_mag.create_assignement_act', 70);
768: hr_utility.trace('Locking Action'||lockingactid);
769: hr_utility.trace('Locked Action = ' || to_char(ln_asg_act_to_lock));
770:
771: end if; --c_paa_update_check%FOUND
772: close c_paa_update_check;
773:

Line 908: --hr_utility.trace_on(null,'SATIRL2');

904: lNoConcepteur NUMBER;
905: l_VersionSchema VARCHAR2(20);
906: BEGIN
907:
908: --hr_utility.trace_on(null,'SATIRL2');
909: hr_utility.trace('Inside the Transmitter record proc');
910: hr_utility.trace('XML Transmitter');
911:
912:

Line 909: hr_utility.trace('Inside the Transmitter record proc');

905: l_VersionSchema VARCHAR2(20);
906: BEGIN
907:
908: --hr_utility.trace_on(null,'SATIRL2');
909: hr_utility.trace('Inside the Transmitter record proc');
910: hr_utility.trace('XML Transmitter');
911:
912:
913: SELECT

Line 910: hr_utility.trace('XML Transmitter');

906: BEGIN
907:
908: --hr_utility.trace_on(null,'SATIRL2');
909: hr_utility.trace('Inside the Transmitter record proc');
910: hr_utility.trace('XML Transmitter');
911:
912:
913: SELECT
914: fnd_global.local_chr(13) || fnd_global.local_chr(10)

Line 959: hr_utility.trace('XML Transmitter: l_taxation_year = ' || l_taxation_year);

955: l_legislative_param
956: );
957:
958:
959: hr_utility.trace('XML Transmitter: l_taxation_year = ' || l_taxation_year);
960: hr_utility.trace('XML Transmitter: l_payroll_Action_id = ' || to_char(l_payroll_actid));
961:
962: OPEN c_trans_info(l_business_grpid,
963: l_payroll_actid);

Line 960: hr_utility.trace('XML Transmitter: l_payroll_Action_id = ' || to_char(l_payroll_actid));

956: );
957:
958:
959: hr_utility.trace('XML Transmitter: l_taxation_year = ' || l_taxation_year);
960: hr_utility.trace('XML Transmitter: l_payroll_Action_id = ' || to_char(l_payroll_actid));
961:
962: OPEN c_trans_info(l_business_grpid,
963: l_payroll_actid);
964: FETCH c_trans_info

Line 990: hr_utility.trace('tab_transmitter(lAnnee) = ' || tab_transmitter(lAnnee));

986:
987: CLOSE c_trans_info;
988: -- Annee
989: tab_transmitter(lAnnee) := '' || l_taxation_year || '' ||EOL;
990: hr_utility.trace('tab_transmitter(lAnnee) = ' || tab_transmitter(lAnnee));
991:
992:
993: -- TypeEnvoi
994: tab_transmitter(lTypeEnvoi) := '' ||

Line 997: hr_utility.trace('tab_transmitter(lTypeEnvoi) = ' ||

993: -- TypeEnvoi
994: tab_transmitter(lTypeEnvoi) := '' ||
995: pay_ca_rl2_mag.convert_special_char(l_trans_package_type) || '' || EOL; --Bug 9154497
996:
997: hr_utility.trace('tab_transmitter(lTypeEnvoi) = ' ||
998: tab_transmitter(lTypeEnvoi));
999:
1000: tab_transmitter(lProvenance) := '' ||
1001: pay_ca_rl2_mag.convert_special_char(l_source_of_slips) || '' || EOL;

Line 1003: hr_utility.trace('tab_transmitter(lProvenance) = ' || tab_transmitter(lProvenance));

999:
1000: tab_transmitter(lProvenance) := '' ||
1001: pay_ca_rl2_mag.convert_special_char(l_source_of_slips) || '' || EOL;
1002:
1003: hr_utility.trace('tab_transmitter(lProvenance) = ' || tab_transmitter(lProvenance));
1004:
1005: tab_transmitter(lNo) := '' ||
1006: pay_ca_rl2_mag.convert_special_char(l_trans_number) || '' || EOL;
1007:

Line 1008: hr_utility.trace('tab_transmitter(lNo) = ' || tab_transmitter(lNo));

1004:
1005: tab_transmitter(lNo) := '' ||
1006: pay_ca_rl2_mag.convert_special_char(l_trans_number) || '' || EOL;
1007:
1008: hr_utility.trace('tab_transmitter(lNo) = ' || tab_transmitter(lNo));
1009:
1010:
1011: IF l_trans_type_indicator IS NOT NULL AND
1012: l_trans_type_indicator <> '0' THEN

Line 1019: hr_utility.trace('tab_transmitter(lType) = ' || tab_transmitter(lType));

1015: ELSE
1016: tab_transmitter(lType) := NULL;
1017: END IF;
1018:
1019: hr_utility.trace('tab_transmitter(lType) = ' || tab_transmitter(lType));
1020:
1021: tab_transmitter(lNom1) := '' ||
1022: pay_ca_rl2_mag.convert_special_char(substr(l_trans_name,1,30)) || '' || EOL;
1023:

Line 1024: hr_utility.trace('tab_transmitter(lNom1) = ' || tab_transmitter(lNom1));

1020:
1021: tab_transmitter(lNom1) := '' ||
1022: pay_ca_rl2_mag.convert_special_char(substr(l_trans_name,1,30)) || '' || EOL;
1023:
1024: hr_utility.trace('tab_transmitter(lNom1) = ' || tab_transmitter(lNom1));
1025:
1026: l_return := substr(l_trans_name,31,30);
1027: IF l_return IS NOT NULL THEN
1028: tab_transmitter(lNom2) := '' || pay_ca_rl2_mag.convert_special_char(l_return) || '' || EOL;

Line 1033: hr_utility.trace('tab_transmitter(lNom2) = ' || tab_transmitter(lNom2));

1029: ELSE
1030: tab_transmitter(lNom2) := NULL;
1031: END IF;
1032:
1033: hr_utility.trace('tab_transmitter(lNom2) = ' || tab_transmitter(lNom2));
1034:
1035:
1036: tab_transmitter(lLigne1) := '' ||
1037: pay_ca_rl2_mag.convert_special_char(substr(l_trans_address_line1,1,30)) || '' || EOL;

Line 1039: hr_utility.trace('tab_transmitter(lLigne1) = ' || tab_transmitter(lLigne1));

1035:
1036: tab_transmitter(lLigne1) := '' ||
1037: pay_ca_rl2_mag.convert_special_char(substr(l_trans_address_line1,1,30)) || '' || EOL;
1038:
1039: hr_utility.trace('tab_transmitter(lLigne1) = ' || tab_transmitter(lLigne1));
1040:
1041:
1042: IF (l_trans_address_line2 IS NOT NULL AND
1043: l_trans_address_line2 <> ' ') THEN

Line 1050: hr_utility.trace('tab_transmitter(lLigne2) = ' || tab_transmitter(lLigne2));

1046: ELSE
1047: tab_transmitter(lLigne2) := NULL;
1048: END IF;
1049:
1050: hr_utility.trace('tab_transmitter(lLigne2) = ' || tab_transmitter(lLigne2));
1051:
1052:
1053: IF (l_trans_city IS NOT NULL AND
1054: l_trans_city <> ' ') THEN

Line 1061: hr_utility.trace('tab_transmitter(lVille) = ' || tab_transmitter(lVille));

1057: ELSE
1058: tab_transmitter(lVille) := NULL;
1059: END IF;
1060:
1061: hr_utility.trace('tab_transmitter(lVille) = ' || tab_transmitter(lVille));
1062:
1063: IF (l_trans_province IS NOT NULL AND
1064: l_trans_province <> ' ') THEN
1065: tab_transmitter(lProvince) := '' ||

Line 1071: hr_utility.trace('tab_transmitter(lProvince) = ' || tab_transmitter(lProvince));

1067: 'CA_PROVINCE',l_trans_province),1,20)) || '' || EOL;
1068: ELSE
1069: tab_transmitter(lProvince) := NULL;
1070: END IF;
1071: hr_utility.trace('tab_transmitter(lProvince) = ' || tab_transmitter(lProvince));
1072:
1073: IF (l_trans_postal_code IS NOT NULL AND
1074: l_trans_postal_code <> ' ') THEN
1075: tab_transmitter(lCodePostal) := '' ||

Line 1080: hr_utility.trace('tab_transmitter(lCodePostal) = ' || tab_transmitter(lCodePostal));

1076: pay_ca_rl2_mag.convert_special_char(substr(l_trans_postal_code,1,6)) || '' || EOL;
1077: ELSE
1078: tab_transmitter(lCodePostal) := NULL;
1079: END IF;
1080: hr_utility.trace('tab_transmitter(lCodePostal) = ' || tab_transmitter(lCodePostal));
1081:
1082:
1083: IF (l_trans_tech_contact_name IS NOT NULL AND
1084: l_trans_tech_contact_name <> ' ' ) THEN

Line 1092: hr_utility.trace('tab_transmitter(lNom) = ' || tab_transmitter(lNom));

1088: ELSE
1089: tab_transmitter(lNom) := NULL;
1090: END IF;
1091:
1092: hr_utility.trace('tab_transmitter(lNom) = ' || tab_transmitter(lNom));
1093:
1094:
1095: IF (l_trans_tech_contact_code IS NOT NULL AND
1096: l_trans_tech_contact_code <> '000' ) THEN

Line 1104: hr_utility.trace('tab_transmitter(lIndRegional) = ' || tab_transmitter(lIndRegional));

1100: ELSE
1101: tab_transmitter(lIndRegional) := NULL;
1102: END IF;
1103:
1104: hr_utility.trace('tab_transmitter(lIndRegional) = ' || tab_transmitter(lIndRegional));
1105:
1106: IF (l_trans_tech_contact_phone IS NOT NULL AND
1107: l_trans_tech_contact_phone <> '0000000' ) THEN
1108: l_Informatique_tag := 'Y';

Line 1114: hr_utility.trace('tab_transmitter(lTel) = ' || tab_transmitter(lTel));

1110: tab_transmitter(lTel) := '' || pay_ca_rl2_mag.convert_special_char(l_trans_tech_contact_phone) || '' || EOL;
1111: ELSE
1112: tab_transmitter(lTel) := NULL;
1113: END IF;
1114: hr_utility.trace('tab_transmitter(lTel) = ' || tab_transmitter(lTel));
1115:
1116:
1117: IF (l_trans_tech_contact_extn IS NOT NULL AND
1118: l_trans_tech_contact_extn <> '0000' ) THEN

Line 1125: hr_utility.trace('tab_transmitter(lPosteTel) = ' ||

1121: '' || EOL;
1122: ELSE
1123: tab_transmitter(lPosteTel) := NULL;
1124: END IF;
1125: hr_utility.trace('tab_transmitter(lPosteTel) = ' ||
1126: tab_transmitter(lPosteTel));
1127:
1128:
1129: IF (l_trans_tech_contact_lang IS NOT NULL AND

Line 1146: hr_utility.trace('tab_transmitter(lANom) = ' || tab_transmitter(lANom));

1142: pay_ca_rl2_mag.convert_special_char(substr(l_trans_acct_contact_name,1,30)) || '' || EOL;
1143: ELSE
1144: tab_transmitter(lANom) := NULL;
1145: END IF;
1146: hr_utility.trace('tab_transmitter(lANom) = ' || tab_transmitter(lANom));
1147:
1148:
1149: IF (l_trans_acct_contact_code IS NOT NULL AND
1150: l_trans_acct_contact_code <> '000' ) THEN

Line 1157: hr_utility.trace('tab_transmitter(lAIndRegional) = ' || tab_transmitter(lAIndRegional));

1153: '' || EOL;
1154: ELSE
1155: tab_transmitter(lAIndRegional) := NULL;
1156: END IF;
1157: hr_utility.trace('tab_transmitter(lAIndRegional) = ' || tab_transmitter(lAIndRegional));
1158:
1159:
1160: IF (l_trans_acct_contact_phone IS NOT NULL AND
1161: l_trans_acct_contact_phone <> '0000000' ) THEN

Line 1168: hr_utility.trace('tab_transmitter(lATel) = ' || tab_transmitter(lATel));

1164: tab_transmitter(lATel) := '' || pay_ca_rl2_mag.convert_special_char(l_trans_acct_contact_phone) || '' || EOL;
1165: ELSE
1166: tab_transmitter(lATel) := NULL;
1167: END IF;
1168: hr_utility.trace('tab_transmitter(lATel) = ' || tab_transmitter(lATel));
1169:
1170:
1171: IF (l_trans_acct_contact_extn IS NOT NULL AND
1172: l_trans_acct_contact_extn <> '0000') THEN

Line 1179: hr_utility.trace('tab_transmitter(lAPosteTel) = ' ||

1175: '' || EOL;
1176: ELSE
1177: tab_transmitter(lAPosteTel) := NULL;
1178: END IF;
1179: hr_utility.trace('tab_transmitter(lAPosteTel) = ' ||
1180: tab_transmitter(lAPosteTel));
1181:
1182: IF (l_trans_acct_contact_lang IS NOT NULL AND
1183: l_trans_acct_contact_lang <> ' ' ) THEN

Line 1218: hr_utility.trace('tab_transmitter(lALangue) = ' || tab_transmitter(lALangue));

1214: --- End 6736354
1215:
1216: tab_transmitter(lNoConcepteur) := ''||pay_ca_rl2_mag.convert_special_char(l_authorization_no)||''||EOL;
1217:
1218: hr_utility.trace('tab_transmitter(lALangue) = ' || tab_transmitter(lALangue));
1219:
1220: IF l_Informatique_tag = 'Y' AND
1221: l_Comptabilite_tag = 'Y' THEN
1222: l_tech_accnt_info := '' || EOL ||

Line 1286: --hr_utility.trace('l_final_xml_string = ' || l_final_xml_string);

1282: l_tech_accnt_info || EOL ||
1283: tab_transmitter(lNoConcepteur) ||
1284: '

' || EOL;
1285:
1286: --hr_utility.trace('l_final_xml_string = ' || l_final_xml_string);
1287:
1288: pay_core_files.write_to_magtape_lob(l_final_xml_string);
1289: END;
1290: END xml_transmitter_record;

Line 1667: --hr_utility.trace_on(null,'SATIRL2XML');

1663: l_authorization_code VARCHAR2(100);
1664: l_legislative_parameters pay_payroll_actions.legislative_parameters%type;
1665: l_transmitter_org_id NUMBER;
1666: BEGIN
1667: --hr_utility.trace_on(null,'SATIRL2XML');
1668: hr_utility.trace('Inside the Employee record proc');
1669: l_status := 'Success';
1670: l_all_box_0 := TRUE;
1671: l_count := 0;

Line 1668: hr_utility.trace('Inside the Employee record proc');

1664: l_legislative_parameters pay_payroll_actions.legislative_parameters%type;
1665: l_transmitter_org_id NUMBER;
1666: BEGIN
1667: --hr_utility.trace_on(null,'SATIRL2XML');
1668: hr_utility.trace('Inside the Employee record proc');
1669: l_status := 'Success';
1670: l_all_box_0 := TRUE;
1671: l_count := 0;
1672: l_format_mask := '99999999999999990.99';

Line 1745: hr_utility.trace('XML Employee: l_mag_asg_action_id = '

1741: l_business_group_id,
1742: l_legislative_parameters;
1743: close c_get_report_type;
1744:
1745: hr_utility.trace('XML Employee: l_mag_asg_action_id = '
1746: || to_char(l_mag_asg_action_id));
1747: hr_utility.trace('XML Employee: Transfer Payroll Action Id '||to_number(pay_magtape_generic.get_parameter_value
1748: ('TRANSFER_PAYROLL_ACTION_ID')));
1749:

Line 1747: hr_utility.trace('XML Employee: Transfer Payroll Action Id '||to_number(pay_magtape_generic.get_parameter_value

1743: close c_get_report_type;
1744:
1745: hr_utility.trace('XML Employee: l_mag_asg_action_id = '
1746: || to_char(l_mag_asg_action_id));
1747: hr_utility.trace('XML Employee: Transfer Payroll Action Id '||to_number(pay_magtape_generic.get_parameter_value
1748: ('TRANSFER_PAYROLL_ACTION_ID')));
1749:
1750: OPEN cur_parameters(l_mag_asg_action_id);
1751: FETCH cur_parameters

Line 1759: hr_utility.trace('XML Employee: l_arch_action_id = '

1755: l_date_earned;
1756: -- CLOSE cur_parameters;
1757: if cur_parameters%found then
1758:
1759: hr_utility.trace('XML Employee: l_arch_action_id = '
1760: || to_char(l_arch_action_id));
1761: hr_utility.trace('XML Employee: l_asg_id = ' || to_char(l_asg_id));
1762: hr_utility.trace('XML Employee: l_date_earned = '
1763: || to_char(l_date_earned));

Line 1761: hr_utility.trace('XML Employee: l_asg_id = ' || to_char(l_asg_id));

1757: if cur_parameters%found then
1758:
1759: hr_utility.trace('XML Employee: l_arch_action_id = '
1760: || to_char(l_arch_action_id));
1761: hr_utility.trace('XML Employee: l_asg_id = ' || to_char(l_asg_id));
1762: hr_utility.trace('XML Employee: l_date_earned = '
1763: || to_char(l_date_earned));
1764: hr_utility.trace('XML Employee: l_province = ' || l_province);
1765:

Line 1762: hr_utility.trace('XML Employee: l_date_earned = '

1758:
1759: hr_utility.trace('XML Employee: l_arch_action_id = '
1760: || to_char(l_arch_action_id));
1761: hr_utility.trace('XML Employee: l_asg_id = ' || to_char(l_asg_id));
1762: hr_utility.trace('XML Employee: l_date_earned = '
1763: || to_char(l_date_earned));
1764: hr_utility.trace('XML Employee: l_province = ' || l_province);
1765:
1766: l_taxation_year := pay_magtape_generic.get_parameter_value('REPORTING_YEAR');

Line 1764: hr_utility.trace('XML Employee: l_province = ' || l_province);

1760: || to_char(l_arch_action_id));
1761: hr_utility.trace('XML Employee: l_asg_id = ' || to_char(l_asg_id));
1762: hr_utility.trace('XML Employee: l_date_earned = '
1763: || to_char(l_date_earned));
1764: hr_utility.trace('XML Employee: l_province = ' || l_province);
1765:
1766: l_taxation_year := pay_magtape_generic.get_parameter_value('REPORTING_YEAR');
1767:
1768: --Annee

Line 1831: hr_utility.trace('tab_employee(lNoReleve) = ' || tab_employee(lNoReleve));

1827: tab_employee(lNoReleve) := '' || pay_ca_rl2_mag.convert_special_char(l_rl2_first_slip_number) ||
1828: '' || EOL;
1829:
1830: END IF;
1831: hr_utility.trace('tab_employee(lNoReleve) = ' || tab_employee(lNoReleve));
1832:
1833: -- NAS
1834: /* Bug Fix 4754891 */
1835: IF (l_employee_sin IS NOT NULL AND

Line 1847: -- hr_utility.trace('tab_employee(lNAS) = ' || tab_employee(lNAS));

1843: l_msg_code := 'SIN';
1844: tab_employee(lNAS) := NULL;
1845:
1846: END IF;
1847: -- hr_utility.trace('tab_employee(lNAS) = ' || tab_employee(lNAS));
1848:
1849: -- No
1850: IF (l_employee_number IS NOT NULL AND
1851: l_employee_number <> ' ' ) THEN

Line 1858: hr_utility.trace('tab_employee(lNo) = ' || tab_employee(lNo));

1854: ELSE
1855: tab_employee(lNo) := NULL;
1856:
1857: END IF;
1858: hr_utility.trace('tab_employee(lNo) = ' || tab_employee(lNo));
1859:
1860: -- NomFamille
1861:
1862: tab_employee(lNomFamille) := '' ||

Line 1864: hr_utility.trace('tab_employee(lNomFamille) = ' || tab_employee(lNomFamille));

1860: -- NomFamille
1861:
1862: tab_employee(lNomFamille) := '' ||
1863: pay_ca_rl2_mag.convert_special_char(substr(l_employee_last_name,1,30)) || '' || EOL;
1864: hr_utility.trace('tab_employee(lNomFamille) = ' || tab_employee(lNomFamille));
1865: l_full_empname := pay_ca_rl2_mag.convert_special_char(substr(l_employee_last_name,1,30));
1866: -- Prenom
1867: IF (l_employee_first_name is NOT NULL AND
1868: l_employee_first_name <> ' ') THEN

Line 1877: hr_utility.trace('tab_employee(lPrenom) = ' || tab_employee(lPrenom));

1873: l_msg_code := 'MISSING_EMP_FIRST_NAME';
1874: l_status := 'Failed';
1875: tab_employee(lPrenom) := NULL;
1876: END IF;
1877: hr_utility.trace('tab_employee(lPrenom) = ' || tab_employee(lPrenom));
1878:
1879: -- Initiale
1880:
1881: IF (l_employee_middle_initial is NOT NULL AND

Line 1891: hr_utility.trace('tab_employee(lInitiale) = ' || tab_employee(lInitiale));

1887: tab_employee(lInitiale) := NULL;
1888: END IF;
1889:
1890:
1891: hr_utility.trace('tab_employee(lInitiale) = ' || tab_employee(lInitiale));
1892:
1893: l_person_id := to_number(l_per_id);
1894:
1895: l_return := pay_ca_emp_address_dtls.get_emp_address(

Line 1909: hr_utility.trace('l_person_id = ' || to_char(l_person_id));

1905: -- If Address line 1 is NULL or ' ' then the employee is missing
1906: -- address information - as line 1 is mandatory in the Address form.
1907: -- Need to check data by SS transaction /API.
1908:
1909: hr_utility.trace('l_person_id = ' || to_char(l_person_id));
1910: hr_utility.trace('l_address_line1 = ' || l_address_line1);
1911: hr_utility.trace('l_address_line2 = ' || l_address_line2);
1912: hr_utility.trace('l_postal_code = ' || l_postal_code);
1913:

Line 1910: hr_utility.trace('l_address_line1 = ' || l_address_line1);

1906: -- address information - as line 1 is mandatory in the Address form.
1907: -- Need to check data by SS transaction /API.
1908:
1909: hr_utility.trace('l_person_id = ' || to_char(l_person_id));
1910: hr_utility.trace('l_address_line1 = ' || l_address_line1);
1911: hr_utility.trace('l_address_line2 = ' || l_address_line2);
1912: hr_utility.trace('l_postal_code = ' || l_postal_code);
1913:
1914: /* Bug Fix 4761782 */

Line 1911: hr_utility.trace('l_address_line2 = ' || l_address_line2);

1907: -- Need to check data by SS transaction /API.
1908:
1909: hr_utility.trace('l_person_id = ' || to_char(l_person_id));
1910: hr_utility.trace('l_address_line1 = ' || l_address_line1);
1911: hr_utility.trace('l_address_line2 = ' || l_address_line2);
1912: hr_utility.trace('l_postal_code = ' || l_postal_code);
1913:
1914: /* Bug Fix 4761782 */
1915: -- Address Line 1

Line 1912: hr_utility.trace('l_postal_code = ' || l_postal_code);

1908:
1909: hr_utility.trace('l_person_id = ' || to_char(l_person_id));
1910: hr_utility.trace('l_address_line1 = ' || l_address_line1);
1911: hr_utility.trace('l_address_line2 = ' || l_address_line2);
1912: hr_utility.trace('l_postal_code = ' || l_postal_code);
1913:
1914: /* Bug Fix 4761782 */
1915: -- Address Line 1
1916: IF l_address_line1 IS NOT NULL AND

Line 1937: hr_utility.trace('tab_employee(lLigne1) = ' || tab_employee(lLigne1));

1933:
1934: tab_employee(lLigne1) := '' ||
1935: pay_ca_rl2_mag.convert_special_char(substr(l_address_line1,1,30)) || '' || EOL;
1936:
1937: hr_utility.trace('tab_employee(lLigne1) = ' || tab_employee(lLigne1));
1938:
1939: -- Address Line 2
1940:
1941: IF ((l_address_line2 IS NOT NULL AND

Line 1954: --hr_utility.trace('tab_employee(lLigne2) = ' || tab_employee(lLigne2));

1950:
1951: tab_employee(lLigne2) := NULL;
1952:
1953: END IF;
1954: --hr_utility.trace('tab_employee(lLigne2) = ' || tab_employee(lLigne2));
1955:
1956: -- Ville (City)
1957: IF l_city IS NOT NULL AND
1958: l_city <> ' ' THEN

Line 1967: --hr_utility.trace('tab_employee(lVille) = ' || tab_employee(lVille));

1963: ELSE
1964: tab_employee(lVille) := NULL;
1965:
1966: END IF;
1967: --hr_utility.trace('tab_employee(lVille) = ' || tab_employee(lVille));
1968:
1969: -- Province
1970: IF l_emp_province IS NOT NULL AND
1971: l_emp_province <> ' ' THEN

Line 1993: hr_utility.trace('tab_employee(lProvince) = ' || tab_employee(lProvince));

1989: ELSE
1990: tab_employee(lProvince) := NULL;
1991:
1992: END IF;
1993: hr_utility.trace('tab_employee(lProvince) = ' || tab_employee(lProvince));
1994:
1995: -- Bug# 4754743 fix
1996: -- Postal Code
1997: IF l_postal_code IS NOT NULL AND

Line 2008: hr_utility.trace('tab_employee(lCodePostal) = ' || tab_employee(lCodePostal));

2004: ELSE
2005: tab_employee(lCodePostal) := NULL;
2006: END IF;
2007:
2008: hr_utility.trace('tab_employee(lCodePostal) = ' || tab_employee(lCodePostal));
2009: l_addr_end_tag := '';
2010:
2011: END IF;
2012:

Line 2017: hr_utility.trace('The Value of Box A is '|| l_rl2_box_a);

2013:
2014:
2015: -- Summ (Box A)
2016:
2017: hr_utility.trace('The Value of Box A is '|| l_rl2_box_a);
2018: IF TO_NUMBER(l_rl2_box_a) > 9999999.99 THEN
2019: l_status := 'Failed';
2020: l_msg_code := 'AMT_GREATER_THAN_RANGE';
2021: END IF;

Line 2037: hr_utility.trace('tab_employee(lA_PrestRPA_RPNA) = ' ||

2033: ELSE
2034: tab_employee(lA_PrestRPA_RPNA ) := NULL;
2035:
2036: END IF;
2037: hr_utility.trace('tab_employee(lA_PrestRPA_RPNA) = ' ||
2038: tab_employee(lA_PrestRPA_RPNA));
2039:
2040: -- Summ (Box B)
2041:

Line 2063: hr_utility.trace('tab_employee(lB_PrestREER_FERR_RPDB) = ' ||

2059: tab_employee(lB_PrestREER_FERR_RPDB) := NULL;
2060:
2061:
2062: END IF;
2063: hr_utility.trace('tab_employee(lB_PrestREER_FERR_RPDB) = ' ||
2064: tab_employee(lB_PrestREER_FERR_RPDB));
2065:
2066: -- Summ (Box C)
2067:

Line 2088: hr_utility.trace('tab_employee(lC_AutrePaiement ) = ' ||

2084: tab_employee(lC_AutrePaiement ) := NULL;
2085:
2086: END IF;
2087:
2088: hr_utility.trace('tab_employee(lC_AutrePaiement ) = ' ||
2089: tab_employee(lC_AutrePaiement ));
2090:
2091: -- Summ (Box D)
2092:

Line 2113: hr_utility.trace('tab_employee(lD_RembPrimeConjoint) = ' ||

2109: ELSE
2110: tab_employee(lD_RembPrimeConjoint) := NULL;
2111:
2112: END IF;
2113: hr_utility.trace('tab_employee(lD_RembPrimeConjoint) = ' ||
2114: tab_employee(lD_RembPrimeConjoint));
2115:
2116: -- (Box E)
2117:

Line 2139: hr_utility.trace('tab_employee(lE_PrestDeces) = ' ||

2135: tab_employee(lE_PrestDeces) := NULL;
2136:
2137: END IF;
2138:
2139: hr_utility.trace('tab_employee(lE_PrestDeces) = ' ||
2140: tab_employee(lE_PrestDeces));
2141:
2142: -- (Box F)
2143:

Line 2164: hr_utility.trace('tab_employee(lF_RembCotisInutilise) = ' ||

2160: ELSE
2161: tab_employee(lF_RembCotisInutilise) := NULL;
2162:
2163: END IF;
2164: hr_utility.trace('tab_employee(lF_RembCotisInutilise) = ' ||
2165: tab_employee(lF_RembCotisInutilise));
2166:
2167: -- (Box G)
2168:

Line 2188: hr_utility.trace('tab_employee(lG_RevocationREER_FERR) = ' ||

2184: l_all_box_0 := FALSE;
2185: ELSE
2186: tab_employee(lG_RevocationREER_FERR) := NULL;
2187: END IF;
2188: hr_utility.trace('tab_employee(lG_RevocationREER_FERR) = ' ||
2189: tab_employee(lG_RevocationREER_FERR));
2190:
2191: -- (Box H)
2192:

Line 2214: hr_utility.trace('tab_employee(lH_AutreRevenu ) = ' ||

2210: tab_employee(lH_AutreRevenu) := NULL;
2211:
2212: END IF;
2213:
2214: hr_utility.trace('tab_employee(lH_AutreRevenu ) = ' ||
2215: tab_employee(lH_AutreRevenu ));
2216:
2217: -- (Box I)
2218:

Line 2239: hr_utility.trace('tab_employee(lI_DroitDeduction ) = ' ||

2235: ELSE
2236: tab_employee(lI_DroitDeduction ) := NULL;
2237:
2238: END IF;
2239: hr_utility.trace('tab_employee(lI_DroitDeduction ) = ' ||
2240: tab_employee(lI_DroitDeduction ));
2241:
2242: -- (Box J)
2243:

Line 2264: hr_utility.trace('tab_employee(lJ_ImpotQueRetenuSource ) = ' ||

2260: ELSE
2261: tab_employee(lJ_ImpotQueRetenuSource ) := NULL;
2262:
2263: END IF;
2264: hr_utility.trace('tab_employee(lJ_ImpotQueRetenuSource ) = ' ||
2265: tab_employee(lJ_ImpotQueRetenuSource ));
2266:
2267: -- (Box K)
2268:

Line 2289: hr_utility.trace('tab_employee(lK_RevenuApresDeces ) = ' ||

2285: ELSE
2286: tab_employee(lK_RevenuApresDeces ) := NULL;
2287:
2288: END IF;
2289: hr_utility.trace('tab_employee(lK_RevenuApresDeces ) = ' ||
2290: tab_employee(lK_RevenuApresDeces ));
2291:
2292: -- (Box L)
2293:

Line 2314: hr_utility.trace('tab_employee(lL_RetraitREEP ) = ' ||

2310: ELSE
2311: tab_employee(lL_RetraitREEP ) := NULL;
2312:
2313: END IF;
2314: hr_utility.trace('tab_employee(lL_RetraitREEP ) = ' ||
2315: tab_employee(lL_RetraitREEP ));
2316:
2317: -- (Box M)
2318:

Line 2339: hr_utility.trace('tab_employee(lM_LibereImpot) = ' ||

2335: ELSE
2336: tab_employee(lM_LibereImpot) := NULL;
2337:
2338: END IF;
2339: hr_utility.trace('tab_employee(lM_LibereImpot) = ' ||
2340: tab_employee(lM_LibereImpot));
2341:
2342: -- (Box N)
2343: -- Bug 5569097 Fix.

Line 2357: hr_utility.trace('tab_employee(lN_NASConjoint) = ' ||

2353:
2354: tab_employee(lN_NASConjoint) := NULL;
2355:
2356: END IF;
2357: hr_utility.trace('tab_employee(lN_NASConjoint) = ' ||
2358: tab_employee(lN_NASConjoint));
2359:
2360: -- Summ (Box O)
2361:

Line 2382: hr_utility.trace('Value of Box O');

2378: ELSE
2379: tab_employee(lO_RetraitRAP ) := NULL;
2380:
2381: END IF;
2382: hr_utility.trace('Value of Box O');
2383: hr_utility.trace('tab_employee(lO_RetraitRAP ) = ' ||
2384: tab_employee(lO_RetraitRAP ));
2385:
2386:

Line 2383: hr_utility.trace('tab_employee(lO_RetraitRAP ) = ' ||

2379: tab_employee(lO_RetraitRAP ) := NULL;
2380:
2381: END IF;
2382: hr_utility.trace('Value of Box O');
2383: hr_utility.trace('tab_employee(lO_RetraitRAP ) = ' ||
2384: tab_employee(lO_RetraitRAP ));
2385:
2386:
2387: -- Negative Balance Exists

Line 2401: hr_utility.trace('The checking for Provenance value ');

2397: l_msg_code := 'ALL_BOXES_ZERO';
2398: END IF;
2399:
2400: -- (Provenance1)
2401: hr_utility.trace('The checking for Provenance value ');
2402: hr_utility.trace('The value of Archiver Assignment Action Id '||l_arch_action_id);
2403: hr_utility.trace('The Value of Assignment Id '||l_asg_id);
2404:
2405: hr_utility.trace('The value Of Provenenace : '|| l_rl2_source_of_income);

Line 2402: hr_utility.trace('The value of Archiver Assignment Action Id '||l_arch_action_id);

2398: END IF;
2399:
2400: -- (Provenance1)
2401: hr_utility.trace('The checking for Provenance value ');
2402: hr_utility.trace('The value of Archiver Assignment Action Id '||l_arch_action_id);
2403: hr_utility.trace('The Value of Assignment Id '||l_asg_id);
2404:
2405: hr_utility.trace('The value Of Provenenace : '|| l_rl2_source_of_income);
2406: IF l_rl2_source_of_income IS NOT NULL THEN

Line 2403: hr_utility.trace('The Value of Assignment Id '||l_asg_id);

2399:
2400: -- (Provenance1)
2401: hr_utility.trace('The checking for Provenance value ');
2402: hr_utility.trace('The value of Archiver Assignment Action Id '||l_arch_action_id);
2403: hr_utility.trace('The Value of Assignment Id '||l_asg_id);
2404:
2405: hr_utility.trace('The value Of Provenenace : '|| l_rl2_source_of_income);
2406: IF l_rl2_source_of_income IS NOT NULL THEN
2407: -- changed to for bug 13083624

Line 2405: hr_utility.trace('The value Of Provenenace : '|| l_rl2_source_of_income);

2401: hr_utility.trace('The checking for Provenance value ');
2402: hr_utility.trace('The value of Archiver Assignment Action Id '||l_arch_action_id);
2403: hr_utility.trace('The Value of Assignment Id '||l_asg_id);
2404:
2405: hr_utility.trace('The value Of Provenenace : '|| l_rl2_source_of_income);
2406: IF l_rl2_source_of_income IS NOT NULL THEN
2407: -- changed to for bug 13083624
2408: /* 14701748 YE12P211I RL2 ELECTRONIC INTERFACE CHANGES FOR 2012 */
2409: IF ( l_rl2_source_of_income = 'AUTRE' ) THEN

Line 2424: hr_utility.trace('tab_employee(lProvenance1) = ' ||

2420: */
2421: tab_employee(lProvenance1) := NULL;
2422:
2423: END IF;
2424: hr_utility.trace('tab_employee(lProvenance1) = ' ||
2425: tab_employee(lProvenance1));
2426: l_transmitter_org_id := pay_ca_rl2_mag.get_parameter('TRANSMITTER_PRE',
2427: l_legislative_parameters);
2428:

Line 2781: hr_utility.trace('Just before Printing the file details ');

2777: end loop;
2778: end if;
2779: end if;
2780: /* Bug 14701748 */
2781: hr_utility.trace('Just before Printing the file details ');
2782: pay_core_files.write_to_magtape_lob(l_final_xml_string);
2783: end if; --if cur_parameters%found
2784: CLOSE cur_parameters;
2785:

Line 2829: hr_utility.trace('Inside the Employer Start record proc');

2825:
2826: BEGIN
2827:
2828: l_final_xml_string := '';
2829: hr_utility.trace('Inside the Employer Start record proc');
2830: pay_core_files.write_to_magtape_lob(l_final_xml_string);
2831:
2832: END;
2833: END xml_employer_start;

Line 2890: hr_utility.trace('XML Employer');

2886: WHERE business_group_id = p_business_group_id
2887: AND payroll_action_id = p_pact_id;
2888:
2889: BEGIN
2890: hr_utility.trace('XML Employer');
2891: hr_utility.trace('Inside the Employer Main Record proc');
2892:
2893: SELECT
2894: fnd_global.local_chr(13) || fnd_global.local_chr(10)

Line 2891: hr_utility.trace('Inside the Employer Main Record proc');

2887: AND payroll_action_id = p_pact_id;
2888:
2889: BEGIN
2890: hr_utility.trace('XML Employer');
2891: hr_utility.trace('Inside the Employer Main Record proc');
2892:
2893: SELECT
2894: fnd_global.local_chr(13) || fnd_global.local_chr(10)
2895: INTO EOL

Line 2927: hr_utility.trace('The Payroll Action Id : '||l_payroll_actid);

2923:
2924: tab_employer(lAnnee) := '' || l_taxation_year || '' || EOL;
2925: tab_employer(lNbReleves) := '' || 'Running Total' || '' || EOL;
2926:
2927: hr_utility.trace('The Payroll Action Id : '||l_payroll_actid);
2928: hr_utility.trace('The business group id : '||l_business_grpid);
2929:
2930:
2931: OPEN get_employer_info(l_business_grpid,

Line 2928: hr_utility.trace('The business group id : '||l_business_grpid);

2924: tab_employer(lAnnee) := '' || l_taxation_year || '' || EOL;
2925: tab_employer(lNbReleves) := '' || 'Running Total' || '' || EOL;
2926:
2927: hr_utility.trace('The Payroll Action Id : '||l_payroll_actid);
2928: hr_utility.trace('The business group id : '||l_business_grpid);
2929:
2930:
2931: OPEN get_employer_info(l_business_grpid,
2932: l_payroll_actid);

Line 2943: hr_utility.trace('The Quebec Number is '||l_quebec_bn);

2939: l_city,
2940: l_province,
2941: l_postal_code;
2942:
2943: hr_utility.trace('The Quebec Number is '||l_quebec_bn);
2944: tab_employer(lNold) := '' || pay_ca_rl2_mag.convert_special_char(substr(l_quebec_bn,1,10)) ||
2945: '' || EOL;
2946: tab_employer(lTypeDossier) := '' || 'RS' ||
2947: '' || EOL;

Line 2951: hr_utility.trace('The Employer File Number : '|| substr(l_quebec_bn,13,4));

2947: '' || EOL;
2948:
2949: tab_employer(lNoDossier) := '' || pay_ca_rl2_mag.convert_special_char(substr(l_quebec_bn,13,4)) ||
2950: '' || EOL;
2951: hr_utility.trace('The Employer File Number : '|| substr(l_quebec_bn,13,4));
2952:
2953: tab_employer(lNom1) := '' ||
2954: pay_ca_rl2_mag.convert_special_char(substr(l_employer_name,1,30)) || '' || EOL;
2955: hr_utility.trace('tab_employer(lNom) = ' || tab_employer(lNom1));

Line 2955: hr_utility.trace('tab_employer(lNom) = ' || tab_employer(lNom1));

2951: hr_utility.trace('The Employer File Number : '|| substr(l_quebec_bn,13,4));
2952:
2953: tab_employer(lNom1) := '' ||
2954: pay_ca_rl2_mag.convert_special_char(substr(l_employer_name,1,30)) || '' || EOL;
2955: hr_utility.trace('tab_employer(lNom) = ' || tab_employer(lNom1));
2956:
2957: IF (l_address_line1 IS NULL AND
2958: l_address_line1 <> ' ' ) THEN
2959:

Line 2974: hr_utility.trace('tab_employer(lLigne1) = ' || tab_employer(lLigne1));

2970: l_address_begin_tag := '';
2971:
2972: tab_employer(lLigne1) := '' ||
2973: pay_ca_rl2_mag.convert_special_char(substr(l_address_line1,1,30)) || '' || EOL;
2974: hr_utility.trace('tab_employer(lLigne1) = ' || tab_employer(lLigne1));
2975:
2976:
2977: -- Address Line 2
2978:

Line 2986: hr_utility.trace('tab_employer(lLigne2) = ' || tab_employer(lLigne2));

2982: pay_ca_rl2_mag.convert_special_char(substr(l_address_line2,1,30)) || '' || EOL;
2983: ELSE
2984: tab_employer(lLigne2) := NULL;
2985: END IF;
2986: hr_utility.trace('tab_employer(lLigne2) = ' || tab_employer(lLigne2));
2987:
2988: -- Ville (City)
2989:
2990: IF ( l_city IS NOT NULL AND

Line 2997: hr_utility.trace('tab_employer(lVille) = ' || tab_employer(lVille));

2993: pay_ca_rl2_mag.convert_special_char(substr(l_city,1,30)) || '' || EOL;
2994: ELSE
2995: tab_employer(lVille) := NULL;
2996: END IF;
2997: hr_utility.trace('tab_employer(lVille) = ' || tab_employer(lVille));
2998:
2999: -- Province
3000:
3001: IF ( l_province IS NOT NULL AND

Line 3009: hr_utility.trace('tab_employer(lProvince) = ' || tab_employer(lProvince));

3005: l_province),1,20)) || '' || EOL;
3006: ELSE
3007: tab_employer(lProvince) := NULL;
3008: END IF;
3009: hr_utility.trace('tab_employer(lProvince) = ' || tab_employer(lProvince));
3010:
3011: -- Postal Code
3012:
3013: IF ( l_postal_code IS NOT NULL AND

Line 3020: hr_utility.trace('tab_employer(lCodePostal) = ' ||

3016: pay_ca_rl2_mag.convert_special_char(substr(l_postal_code,1,6)) || '' || EOL;
3017: ELSE
3018: tab_employer(lCodePostal) := NULL;
3019: END IF;
3020: hr_utility.trace('tab_employer(lCodePostal) = ' ||
3021: tab_employer(lCodePostal));
3022:
3023: l_address_end_tag := '';
3024:

Line 3264: hr_utility.trace('l_check_number ='|| l_check_number);

3260: l_check_number number;
3261: BEGIN
3262:
3263: l_check_number := mod(p_curr_seq,7);
3264: hr_utility.trace('l_check_number ='|| l_check_number);
3265: l_seq_number := (p_curr_seq * 10) + l_check_number;
3266: hr_utility.trace('l_seq_number ='|| l_seq_number);
3267: return l_seq_number;
3268: END; */

Line 3266: hr_utility.trace('l_seq_number ='|| l_seq_number);

3262:
3263: l_check_number := mod(p_curr_seq,7);
3264: hr_utility.trace('l_check_number ='|| l_check_number);
3265: l_seq_number := (p_curr_seq * 10) + l_check_number;
3266: hr_utility.trace('l_seq_number ='|| l_seq_number);
3267: return l_seq_number;
3268: END; */
3269:
3270: END pay_ca_rl2_amend_mag;