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

Line 33: --hr_utility.trace_on('Y','RL2MAG');

29: p_business_group_id IN OUT NOCOPY NUMBER,
30: p_legislative_param IN OUT NOCOPY VARCHAR2
31: ) IS
32: BEGIN
33: --hr_utility.trace_on('Y','RL2MAG');
34: hr_utility.set_location('pay_ca_rl2_mag.get_report_parameters', 10);
35:
36: SELECT ppa.start_date,
37: ppa.effective_date,

Line 34: hr_utility.set_location('pay_ca_rl2_mag.get_report_parameters', 10);

30: p_legislative_param IN OUT NOCOPY VARCHAR2
31: ) IS
32: BEGIN
33: --hr_utility.trace_on('Y','RL2MAG');
34: hr_utility.set_location('pay_ca_rl2_mag.get_report_parameters', 10);
35:
36: SELECT ppa.start_date,
37: ppa.effective_date,
38: ppa.business_group_id,

Line 49: hr_utility.set_location('pay_ca_rl2_mag.get_report_parameters', 20);

45: p_legislative_param
46: FROM pay_payroll_actions ppa
47: WHERE payroll_action_id = p_pactid;
48:
49: hr_utility.set_location('pay_ca_rl2_mag.get_report_parameters', 20);
50:
51: END get_report_parameters;
52:
53: ---------------------------------------------------------------------------

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

109:
110: l_transmitter_org_id := pay_ca_rl2_mag.get_parameter('TRANSMITTER_PRE',
111: l_legislative_parameters);
112:
113: hr_utility.trace('l_transmitter_org_id = ' || to_char(l_transmitter_org_id));
114: hr_utility.trace('p_bg_id = ' || to_char(p_bg_id));
115: hr_utility.trace('p_payroll_action_id = ' || to_char(p_payroll_action_id));
116: hr_utility.trace('p_effective_date = ' || to_char(p_effective_date));
117:

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

110: l_transmitter_org_id := pay_ca_rl2_mag.get_parameter('TRANSMITTER_PRE',
111: l_legislative_parameters);
112:
113: hr_utility.trace('l_transmitter_org_id = ' || to_char(l_transmitter_org_id));
114: hr_utility.trace('p_bg_id = ' || to_char(p_bg_id));
115: hr_utility.trace('p_payroll_action_id = ' || to_char(p_payroll_action_id));
116: hr_utility.trace('p_effective_date = ' || to_char(p_effective_date));
117:
118: OPEN cur_arch_pactid(l_transmitter_org_id);

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

111: l_legislative_parameters);
112:
113: hr_utility.trace('l_transmitter_org_id = ' || to_char(l_transmitter_org_id));
114: hr_utility.trace('p_bg_id = ' || to_char(p_bg_id));
115: hr_utility.trace('p_payroll_action_id = ' || to_char(p_payroll_action_id));
116: hr_utility.trace('p_effective_date = ' || to_char(p_effective_date));
117:
118: OPEN cur_arch_pactid(l_transmitter_org_id);
119: FETCH cur_arch_pactid

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

112:
113: hr_utility.trace('l_transmitter_org_id = ' || to_char(l_transmitter_org_id));
114: hr_utility.trace('p_bg_id = ' || to_char(p_bg_id));
115: hr_utility.trace('p_payroll_action_id = ' || to_char(p_payroll_action_id));
116: hr_utility.trace('p_effective_date = ' || to_char(p_effective_date));
117:
118: OPEN cur_arch_pactid(l_transmitter_org_id);
119: FETCH cur_arch_pactid
120: INTO l_arch_pactid;

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

127: l_arch_pactid,
128: 'CAEOY_RL2_TRANSMITTER_NAME');
129: BEGIN
130:
131: hr_utility.trace('l_transmitter_number = ' || l_transmitter_number);
132: SELECT substr(l_transmitter_number,1,2)
133: INTO dummy1
134: FROM dual;
135:

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

143: FROM dual;
144:
145: EXCEPTION
146: WHEN INVALID_NUMBER THEN
147: hr_utility.set_message(800,'PAY_CA_RL1_INVALID_TRANSMITTER');
148: hr_utility.set_message_token('PRE_NAME',l_transmitter_name);
149: pay_core_utils.push_message(800,'PAY_CA_RL1_INVALID_TRANSMITTER','P');
150: pay_core_utils.push_token('PRE_NAME',l_transmitter_name);
151: hr_utility.raise_error;

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

144:
145: EXCEPTION
146: WHEN INVALID_NUMBER THEN
147: hr_utility.set_message(800,'PAY_CA_RL1_INVALID_TRANSMITTER');
148: hr_utility.set_message_token('PRE_NAME',l_transmitter_name);
149: pay_core_utils.push_message(800,'PAY_CA_RL1_INVALID_TRANSMITTER','P');
150: pay_core_utils.push_token('PRE_NAME',l_transmitter_name);
151: hr_utility.raise_error;
152: END;

Line 151: hr_utility.raise_error;

147: hr_utility.set_message(800,'PAY_CA_RL1_INVALID_TRANSMITTER');
148: hr_utility.set_message_token('PRE_NAME',l_transmitter_name);
149: pay_core_utils.push_message(800,'PAY_CA_RL1_INVALID_TRANSMITTER','P');
150: pay_core_utils.push_token('PRE_NAME',l_transmitter_name);
151: hr_utility.raise_error;
152: END;
153:
154: l_type_of_package := pay_ca_rl2_mag.get_transmitter_item(p_bg_id,
155: l_arch_pactid,

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

154: l_type_of_package := pay_ca_rl2_mag.get_transmitter_item(p_bg_id,
155: l_arch_pactid,
156: 'CAEOY_RL2_TRANSMITTER_PACKAGE_TYPE');
157:
158: hr_utility.trace('l_type_of_package = ' || l_type_of_package);
159:
160: IF l_type_of_package IS NULL THEN
161: pay_core_utils.push_message(800,'PAY_CA_RL1_MISSING_TYPE_OF_PKG','P');
162: hr_utility.raise_error;

Line 162: hr_utility.raise_error;

158: hr_utility.trace('l_type_of_package = ' || l_type_of_package);
159:
160: IF l_type_of_package IS NULL THEN
161: pay_core_utils.push_message(800,'PAY_CA_RL1_MISSING_TYPE_OF_PKG','P');
162: hr_utility.raise_error;
163: END IF;
164:
165: l_source_of_slips := pay_ca_rl2_mag.get_transmitter_item(p_bg_id,
166: l_arch_pactid,

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

164:
165: l_source_of_slips := pay_ca_rl2_mag.get_transmitter_item(p_bg_id,
166: l_arch_pactid,
167: 'CAEOY_RL2_SOURCE_OF_SLIPS');
168: hr_utility.trace('l_source_of_slips = ' || l_source_of_slips);
169:
170: IF l_source_of_slips IS NULL THEN
171: pay_core_utils.push_message(800,'PAY_CA_RL1_MISSING_RLSLIP_SRC','P');
172: hr_utility.raise_error;

Line 172: hr_utility.raise_error;

168: hr_utility.trace('l_source_of_slips = ' || l_source_of_slips);
169:
170: IF l_source_of_slips IS NULL THEN
171: pay_core_utils.push_message(800,'PAY_CA_RL1_MISSING_RLSLIP_SRC','P');
172: hr_utility.raise_error;
173: END IF;
174:
175: l_address_line1 := pay_ca_rl2_mag.get_transmitter_item(p_bg_id,
176: l_arch_pactid,

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

174:
175: l_address_line1 := pay_ca_rl2_mag.get_transmitter_item(p_bg_id,
176: l_arch_pactid,
177: 'CAEOY_RL2_TRANSMITTER_ADDRESS_LINE1');
178: hr_utility.trace('l_address_line1 = ' || l_address_line1);
179:
180: IF l_address_line1 IS NULL THEN
181: pay_core_utils.push_message(800,'PAY_CA_RL1_MISSING_TRNMTR_ADDR','P');
182: hr_utility.raise_error;

Line 182: hr_utility.raise_error;

178: hr_utility.trace('l_address_line1 = ' || l_address_line1);
179:
180: IF l_address_line1 IS NULL THEN
181: pay_core_utils.push_message(800,'PAY_CA_RL1_MISSING_TRNMTR_ADDR','P');
182: hr_utility.raise_error;
183: END IF;
184:
185: END;
186:

Line 214: hr_utility.set_location( 'pay_ca_rl2_mag.range_cursor', 10);

210: p_legislative_param pay_payroll_actions.legislative_parameters%type;
211:
212: BEGIN
213:
214: hr_utility.set_location( 'pay_ca_rl2_mag.range_cursor', 10);
215:
216: get_report_parameters(
217: p_pactid,
218: p_year_start,

Line 225: hr_utility.set_location( 'pay_ca_rl2_mag.range_cursor', 20);

221: p_business_group_id,
222: p_legislative_param
223: );
224:
225: hr_utility.set_location( 'pay_ca_rl2_mag.range_cursor', 20);
226:
227: p_sqlstr := 'select distinct to_number(emp.person_id)
228: from pay_ca_eoy_rl2_employee_info_v emp,
229: pay_ca_eoy_rl2_trans_info_v tran,

Line 254: hr_utility.set_location( 'pay_ca_rl2_mag.range_cursor',30);

250: and to_char(hoi.organization_id) =
251: pycadar_pkg.get_parameter(''PRE_ORGANIZATION_ID'',ppa_arch.legislative_parameters)
252: order by to_number(emp.person_id)' ;
253:
254: hr_utility.set_location( 'pay_ca_rl2_mag.range_cursor',30);
255:
256: END range_cursor;
257:
258: -------------------------------------------------------------------------------

Line 340: -- hr_utility.trace_on(NULL,'RL2MAG');

336: l_legislative_param pay_payroll_actions.legislative_parameters%type;
337:
338: BEGIN
339:
340: -- hr_utility.trace_on(NULL,'RL2MAG');
341: -- Get the report parameters. These define the report being run.
342: l_prev_payact := -1;
343: hr_utility.set_location( 'pay_ca_rl2_mag.create_assignment_act',10);
344:

Line 343: hr_utility.set_location( 'pay_ca_rl2_mag.create_assignment_act',10);

339:
340: -- hr_utility.trace_on(NULL,'RL2MAG');
341: -- Get the report parameters. These define the report being run.
342: l_prev_payact := -1;
343: hr_utility.set_location( 'pay_ca_rl2_mag.create_assignment_act',10);
344:
345: get_report_parameters(
346: p_pactid,
347: l_year_start,

Line 360: hr_utility.set_location( 'pay_ca_rl2_mag.create_assignment_act',20);

356: l_year_end);
357:
358: --Open the appropriate cursor
359:
360: hr_utility.set_location( 'pay_ca_rl2_mag.create_assignment_act',20);
361: hr_utility.trace('Report type '||l_report_type);
362: IF l_report_type = 'RL2_XML_MAG' THEN
363: OPEN c_all_asg(l_legislative_param,
364: l_business_group_id,

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

357:
358: --Open the appropriate cursor
359:
360: hr_utility.set_location( 'pay_ca_rl2_mag.create_assignment_act',20);
361: hr_utility.trace('Report type '||l_report_type);
362: IF l_report_type = 'RL2_XML_MAG' THEN
363: OPEN c_all_asg(l_legislative_param,
364: l_business_group_id,
365: l_year_end);

Line 374: hr_utility.set_location('pay_ca_rl2_mag.create_assignment_act', 30);

370: l_effective_end_date,
371: l_assignment_action_id,
372: l_payroll_act;
373:
374: hr_utility.set_location('pay_ca_rl2_mag.create_assignment_act', 30);
375:
376: EXIT WHEN c_all_asg%NOTFOUND;
377:
378: --Create the assignment action for the record

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

379:
380: /* Validating QIN Number information */
381: if l_prev_payact <> l_payroll_act then
382:
383: hr_utility.trace('The payroll action id '||l_payroll_act);
384:
385: l_prev_payact := l_payroll_act;
386: l_emplyer_name := pay_ca_rl2_mag.get_employer_item(l_business_group_id,
387: l_payroll_act,

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

389:
390: l_quebec_no := pay_ca_rl2_mag.get_employer_item(l_business_group_id,
391: l_payroll_act,
392: 'CAEOY_RL2_QUEBEC_BN');
393: hr_utility.trace('The Quebec Number is '||l_quebec_no);
394: l_file_no := substr(l_quebec_no,13,4);
395: l_quebec_no := substr(l_quebec_no ,1,10);
396:
397: /* Fix for Bug# 4038551 */

Line 403: hr_utility.raise_error;

399: length(l_file_no) < 4
400: then
401: pay_core_utils.push_message(801,'PAY_74156_INCORRECT_QIN_INFO','P');
402: pay_core_utils.push_token('PRE_NAME',l_emplyer_name);
403: hr_utility.raise_error;
404: end if;
405:
406:
407: /* Erroring out the RL2 Electronic Interface if any of the

Line 416: hr_utility.raise_error;

412: 'CAEOY_RL2_EMPLOYER_ADDRESS_LINE1');
413: if l_addr_line = ' '
414: then
415: pay_core_utils.push_message(800,'PAY_CA_RL2_MISSING_ADDRESS','P');
416: hr_utility.raise_error;
417: end if;
418: hr_utility.trace('First 10 digits of the QIN: '||l_quebec_no);
419: l_return := validate_quebec_number(l_quebec_no,l_emplyer_name);
420:

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

414: then
415: pay_core_utils.push_message(800,'PAY_CA_RL2_MISSING_ADDRESS','P');
416: hr_utility.raise_error;
417: end if;
418: hr_utility.trace('First 10 digits of the QIN: '||l_quebec_no);
419: l_return := validate_quebec_number(l_quebec_no,l_emplyer_name);
420:
421: end if ;
422: hr_utility.trace('Assignment Fetched - ');

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

418: hr_utility.trace('First 10 digits of the QIN: '||l_quebec_no);
419: l_return := validate_quebec_number(l_quebec_no,l_emplyer_name);
420:
421: end if ;
422: hr_utility.trace('Assignment Fetched - ');
423: hr_utility.trace('Assignment Id : '|| to_char(l_assignment_id));
424: hr_utility.trace('Person Id : '|| to_char(l_person_id));
425: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
426: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date));

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

419: l_return := validate_quebec_number(l_quebec_no,l_emplyer_name);
420:
421: end if ;
422: hr_utility.trace('Assignment Fetched - ');
423: hr_utility.trace('Assignment Id : '|| to_char(l_assignment_id));
424: hr_utility.trace('Person Id : '|| to_char(l_person_id));
425: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
426: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date));
427:

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

420:
421: end if ;
422: hr_utility.trace('Assignment Fetched - ');
423: hr_utility.trace('Assignment Id : '|| to_char(l_assignment_id));
424: hr_utility.trace('Person Id : '|| to_char(l_person_id));
425: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
426: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date));
427:
428: hr_utility.set_location('pay_ca_rl2_mag.create_assignment_act', 40);

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

421: end if ;
422: hr_utility.trace('Assignment Fetched - ');
423: hr_utility.trace('Assignment Id : '|| to_char(l_assignment_id));
424: hr_utility.trace('Person Id : '|| to_char(l_person_id));
425: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
426: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date));
427:
428: hr_utility.set_location('pay_ca_rl2_mag.create_assignment_act', 40);
429:

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

422: hr_utility.trace('Assignment Fetched - ');
423: hr_utility.trace('Assignment Id : '|| to_char(l_assignment_id));
424: hr_utility.trace('Person Id : '|| to_char(l_person_id));
425: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
426: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date));
427:
428: hr_utility.set_location('pay_ca_rl2_mag.create_assignment_act', 40);
429:
430: SELECT pay_assignment_actions_s.nextval

Line 428: hr_utility.set_location('pay_ca_rl2_mag.create_assignment_act', 40);

424: hr_utility.trace('Person Id : '|| to_char(l_person_id));
425: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
426: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date));
427:
428: hr_utility.set_location('pay_ca_rl2_mag.create_assignment_act', 40);
429:
430: SELECT pay_assignment_actions_s.nextval
431: INTO lockingactid
432: FROM dual;

Line 434: hr_utility.set_location('pay_ca_rl2_mag.create_assignment_act', 50);

430: SELECT pay_assignment_actions_s.nextval
431: INTO lockingactid
432: FROM dual;
433:
434: hr_utility.set_location('pay_ca_rl2_mag.create_assignment_act', 50);
435: hr_nonrun_asact.insact(lockingactid,
436: l_assignment_id,
437: p_pactid,
438: p_chunk,

Line 441: hr_utility.set_location('pay_ca_rl2_mag.create_assignment_act', 60);

437: p_pactid,
438: p_chunk,
439: l_tax_unit_id);
440:
441: hr_utility.set_location('pay_ca_rl2_mag.create_assignment_act', 60);
442:
443: hr_nonrun_asact.insint(lockingactid, l_assignment_action_id);
444:
445: hr_utility.set_location('pay_ca_rl2_mag.create_assignment_act', 70);

Line 445: hr_utility.set_location('pay_ca_rl2_mag.create_assignment_act', 70);

441: hr_utility.set_location('pay_ca_rl2_mag.create_assignment_act', 60);
442:
443: hr_nonrun_asact.insint(lockingactid, l_assignment_action_id);
444:
445: hr_utility.set_location('pay_ca_rl2_mag.create_assignment_act', 70);
446: hr_utility.trace('Interlock Created - ');
447: hr_utility.trace('Locking Action : '|| to_char(lockingactid));
448: hr_utility.trace('Locked Action : '|| to_char(l_assignment_action_id));
449:

Line 446: hr_utility.trace('Interlock Created - ');

442:
443: hr_nonrun_asact.insint(lockingactid, l_assignment_action_id);
444:
445: hr_utility.set_location('pay_ca_rl2_mag.create_assignment_act', 70);
446: hr_utility.trace('Interlock Created - ');
447: hr_utility.trace('Locking Action : '|| to_char(lockingactid));
448: hr_utility.trace('Locked Action : '|| to_char(l_assignment_action_id));
449:
450: END LOOP;

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

443: hr_nonrun_asact.insint(lockingactid, l_assignment_action_id);
444:
445: hr_utility.set_location('pay_ca_rl2_mag.create_assignment_act', 70);
446: hr_utility.trace('Interlock Created - ');
447: hr_utility.trace('Locking Action : '|| to_char(lockingactid));
448: hr_utility.trace('Locked Action : '|| to_char(l_assignment_action_id));
449:
450: END LOOP;
451: CLOSE c_all_asg;

Line 448: hr_utility.trace('Locked Action : '|| to_char(l_assignment_action_id));

444:
445: hr_utility.set_location('pay_ca_rl2_mag.create_assignment_act', 70);
446: hr_utility.trace('Interlock Created - ');
447: hr_utility.trace('Locking Action : '|| to_char(lockingactid));
448: hr_utility.trace('Locked Action : '|| to_char(l_assignment_action_id));
449:
450: END LOOP;
451: CLOSE c_all_asg;
452:

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

800: l_authorization_no VARCHAR2(20);
801: lNoConcepteur NUMBER;
802: BEGIN
803:
804: hr_utility.trace('XML Transmitter');
805:
806:
807: SELECT
808: fnd_global.local_chr(13) || fnd_global.local_chr(10)

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

850: l_legislative_param
851: );
852:
853:
854: hr_utility.trace('XML Transmitter: l_taxation_year = ' || l_taxation_year);
855: hr_utility.trace('XML Transmitter: l_payroll_Action_id = ' || to_char(l_payroll_actid));
856:
857: OPEN c_trans_info(l_business_grpid,
858: l_payroll_actid);

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

851: );
852:
853:
854: hr_utility.trace('XML Transmitter: l_taxation_year = ' || l_taxation_year);
855: hr_utility.trace('XML Transmitter: l_payroll_Action_id = ' || to_char(l_payroll_actid));
856:
857: OPEN c_trans_info(l_business_grpid,
858: l_payroll_actid);
859: FETCH c_trans_info

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

881:
882: CLOSE c_trans_info;
883: -- Annee
884: tab_transmitter(lAnnee) := '' || l_taxation_year || '' ||EOL;
885: hr_utility.trace('tab_transmitter(lAnnee) = ' || tab_transmitter(lAnnee));
886:
887: -- TypeEnvoi
888: tab_transmitter(lTypeEnvoi) := '' ||
889: convert_special_char(l_trans_package_type) || '' || EOL;

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

886:
887: -- TypeEnvoi
888: tab_transmitter(lTypeEnvoi) := '' ||
889: convert_special_char(l_trans_package_type) || '' || EOL;
890: hr_utility.trace('tab_transmitter(lTypeEnvoi) = ' ||
891: tab_transmitter(lTypeEnvoi));
892:
893: tab_transmitter(lProvenance) := '' ||
894: convert_special_char(l_source_of_slips) || '' || EOL;

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

892:
893: tab_transmitter(lProvenance) := '' ||
894: convert_special_char(l_source_of_slips) || '' || EOL;
895:
896: hr_utility.trace('tab_transmitter(lProvenance) = ' || tab_transmitter(lProvenance));
897:
898: tab_transmitter(lNo) := '' ||
899: convert_special_char(l_trans_number) || '' || EOL;
900:

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

897:
898: tab_transmitter(lNo) := '' ||
899: convert_special_char(l_trans_number) || '' || EOL;
900:
901: hr_utility.trace('tab_transmitter(lNo) = ' || tab_transmitter(lNo));
902:
903:
904: IF l_trans_type_indicator IS NOT NULL AND
905: l_trans_type_indicator <> '0' THEN

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

908: ELSE
909: tab_transmitter(lType) := NULL;
910: END IF;
911:
912: hr_utility.trace('tab_transmitter(lType) = ' || tab_transmitter(lType));
913:
914: tab_transmitter(lNom1) := '' ||
915: convert_special_char(substr(l_trans_name,1,30)) || '' || EOL;
916:

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

913:
914: tab_transmitter(lNom1) := '' ||
915: convert_special_char(substr(l_trans_name,1,30)) || '' || EOL;
916:
917: hr_utility.trace('tab_transmitter(lNom1) = ' || tab_transmitter(lNom1));
918:
919: l_return := substr(l_trans_name,31,30);
920: IF l_return IS NOT NULL THEN
921: tab_transmitter(lNom2) := '' || convert_special_char(l_return) || '' || EOL;

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

922: ELSE
923: tab_transmitter(lNom2) := NULL;
924: END IF;
925:
926: hr_utility.trace('tab_transmitter(lNom2) = ' || tab_transmitter(lNom2));
927:
928:
929: tab_transmitter(lLigne1) := '' ||
930: convert_special_char(substr(l_trans_address_line1,1,30)) || '' || EOL;

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

928:
929: tab_transmitter(lLigne1) := '' ||
930: convert_special_char(substr(l_trans_address_line1,1,30)) || '' || EOL;
931:
932: hr_utility.trace('tab_transmitter(lLigne1) = ' || tab_transmitter(lLigne1));
933:
934:
935: IF (l_trans_address_line2 IS NOT NULL AND
936: l_trans_address_line2 <> ' ') THEN

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

939: ELSE
940: tab_transmitter(lLigne2) := NULL;
941: END IF;
942:
943: hr_utility.trace('tab_transmitter(lLigne2) = ' || tab_transmitter(lLigne2));
944:
945:
946: IF (l_trans_city IS NOT NULL AND
947: l_trans_city <> ' ') THEN

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

950: ELSE
951: tab_transmitter(lVille) := NULL;
952: END IF;
953:
954: hr_utility.trace('tab_transmitter(lVille) = ' || tab_transmitter(lVille));
955:
956: IF (l_trans_province IS NOT NULL AND
957: l_trans_province <> ' ') THEN
958: tab_transmitter(lProvince) := '' ||

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

960: 'CA_PROVINCE',l_trans_province),1,20)) || '' || EOL;
961: ELSE
962: tab_transmitter(lProvince) := NULL;
963: END IF;
964: hr_utility.trace('tab_transmitter(lProvince) = ' || tab_transmitter(lProvince));
965:
966: IF (l_trans_postal_code IS NOT NULL AND
967: l_trans_postal_code <> ' ') THEN
968: tab_transmitter(lCodePostal) := '' ||

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

969: convert_special_char(substr(l_trans_postal_code,1,6)) || '' || EOL;
970: ELSE
971: tab_transmitter(lCodePostal) := NULL;
972: END IF;
973: hr_utility.trace('tab_transmitter(lCodePostal) = ' || tab_transmitter(lCodePostal));
974:
975:
976: IF (l_trans_tech_contact_name IS NOT NULL AND
977: l_trans_tech_contact_name <> ' ' ) THEN

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

981: ELSE
982: tab_transmitter(lNom) := NULL;
983: END IF;
984:
985: hr_utility.trace('tab_transmitter(lNom) = ' || tab_transmitter(lNom));
986:
987:
988: IF (l_trans_tech_contact_code IS NOT NULL AND
989: l_trans_tech_contact_code <> '000' ) THEN

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

993: ELSE
994: tab_transmitter(lIndRegional) := NULL;
995: END IF;
996:
997: hr_utility.trace('tab_transmitter(lIndRegional) = ' || tab_transmitter(lIndRegional));
998:
999: IF (l_trans_tech_contact_phone IS NOT NULL AND
1000: l_trans_tech_contact_phone <> '0000000' ) THEN
1001: l_Informatique_tag := 'Y';

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

1003: tab_transmitter(lTel) := '' || convert_special_char(l_trans_tech_contact_phone) || '' || EOL;
1004: ELSE
1005: tab_transmitter(lTel) := NULL;
1006: END IF;
1007: hr_utility.trace('tab_transmitter(lTel) = ' || tab_transmitter(lTel));
1008:
1009:
1010: IF (l_trans_tech_contact_extn IS NOT NULL AND
1011: l_trans_tech_contact_extn <> '0000' ) THEN

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

1014: '' || EOL;
1015: ELSE
1016: tab_transmitter(lPosteTel) := NULL;
1017: END IF;
1018: hr_utility.trace('tab_transmitter(lPosteTel) = ' ||
1019: tab_transmitter(lPosteTel));
1020:
1021:
1022: IF (l_trans_tech_contact_lang IS NOT NULL AND

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

1035: convert_special_char(substr(l_trans_acct_contact_name,1,30)) || '' || EOL;
1036: ELSE
1037: tab_transmitter(lANom) := NULL;
1038: END IF;
1039: hr_utility.trace('tab_transmitter(lANom) = ' || tab_transmitter(lANom));
1040:
1041:
1042: IF (l_trans_acct_contact_code IS NOT NULL AND
1043: l_trans_acct_contact_code <> '000' ) THEN

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

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

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

1057: tab_transmitter(lATel) := '' || convert_special_char(l_trans_acct_contact_phone) || '' || EOL;
1058: ELSE
1059: tab_transmitter(lATel) := NULL;
1060: END IF;
1061: hr_utility.trace('tab_transmitter(lATel) = ' || tab_transmitter(lATel));
1062:
1063:
1064: IF (l_trans_acct_contact_extn IS NOT NULL AND
1065: l_trans_acct_contact_extn <> '0000') THEN

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

1068: '' || EOL;
1069: ELSE
1070: tab_transmitter(lAPosteTel) := NULL;
1071: END IF;
1072: hr_utility.trace('tab_transmitter(lAPosteTel) = ' ||
1073: tab_transmitter(lAPosteTel));
1074:
1075: IF (l_trans_acct_contact_lang IS NOT NULL AND
1076: l_trans_acct_contact_lang <> ' ' ) THEN

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

1090: --- End 6736354
1091:
1092: tab_transmitter(lNoConcepteur) := ''||convert_special_char(l_authorization_no)||''||EOL;
1093:
1094: hr_utility.trace('tab_transmitter(lALangue) = ' || tab_transmitter(lALangue));
1095:
1096: IF l_Informatique_tag = 'Y' AND
1097: l_Comptabilite_tag = 'Y' THEN
1098: l_tech_accnt_info := '' || EOL ||

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

1147: l_tech_accnt_info || EOL ||
1148: tab_transmitter(lNoConcepteur) ||
1149: '

' || EOL;
1150:
1151: --hr_utility.trace('l_final_xml_string = ' || l_final_xml_string);
1152:
1153: pay_core_files.write_to_magtape_lob(l_final_xml_string);
1154: END;
1155: END xml_transmitter_record;

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

1459: l_seq_num NUMBER;
1460: l_authorization_code VARCHAR2(100);
1461:
1462: BEGIN
1463: --hr_utility.trace_on(null,'SATIRL2XML');
1464: hr_utility.trace('XML Employee');
1465: l_status := 'Success';
1466: l_all_box_0 := TRUE;
1467: l_count := 0;

Line 1464: hr_utility.trace('XML Employee');

1460: l_authorization_code VARCHAR2(100);
1461:
1462: BEGIN
1463: --hr_utility.trace_on(null,'SATIRL2XML');
1464: hr_utility.trace('XML Employee');
1465: l_status := 'Success';
1466: l_all_box_0 := TRUE;
1467: l_count := 0;
1468: l_format_mask := '99999999999999990.99';

Line 1544: hr_utility.trace('The value of Payroll action id is '||l_rl2pap_pay_actid);

1540: l_rl2pap_pay_actid,
1541: l_asg_id;
1542: close c_get_payroll_asg_actid;
1543:
1544: hr_utility.trace('The value of Payroll action id is '||l_rl2pap_pay_actid);
1545: hr_utility.trace('The value of Assignment action id is '||l_rl2pap_asg_actid);
1546: hr_utility.trace('The value of Assignment id is '||l_asg_id);
1547:
1548: OPEN c_get_employer_info(l_rl2pap_pay_actid,l_business_group_id);

Line 1545: hr_utility.trace('The value of Assignment action id is '||l_rl2pap_asg_actid);

1541: l_asg_id;
1542: close c_get_payroll_asg_actid;
1543:
1544: hr_utility.trace('The value of Payroll action id is '||l_rl2pap_pay_actid);
1545: hr_utility.trace('The value of Assignment action id is '||l_rl2pap_asg_actid);
1546: hr_utility.trace('The value of Assignment id is '||l_asg_id);
1547:
1548: OPEN c_get_employer_info(l_rl2pap_pay_actid,l_business_group_id);
1549: FETCH c_get_employer_info

Line 1546: hr_utility.trace('The value of Assignment id is '||l_asg_id);

1542: close c_get_payroll_asg_actid;
1543:
1544: hr_utility.trace('The value of Payroll action id is '||l_rl2pap_pay_actid);
1545: hr_utility.trace('The value of Assignment action id is '||l_rl2pap_asg_actid);
1546: hr_utility.trace('The value of Assignment id is '||l_asg_id);
1547:
1548: OPEN c_get_employer_info(l_rl2pap_pay_actid,l_business_group_id);
1549: FETCH c_get_employer_info
1550: INTO l_empr_name ,

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

1658: tab_emplyr2(l_counter) := NULL;
1659: END IF;
1660:
1661: end if;
1662: hr_utility.trace('XML Employee: l_mag_asg_action_id = '
1663: || to_char(l_mag_asg_action_id));
1664: hr_utility.trace('XML Employee: Transfer Payroll Action Id '||to_number(pay_magtape_generic.get_parameter_value
1665: ('TRANSFER_PAYROLL_ACTION_ID')));
1666: IF l_rep_type <> 'RL2PAPERPDF' THEN

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

1660:
1661: end if;
1662: hr_utility.trace('XML Employee: l_mag_asg_action_id = '
1663: || to_char(l_mag_asg_action_id));
1664: hr_utility.trace('XML Employee: Transfer Payroll Action Id '||to_number(pay_magtape_generic.get_parameter_value
1665: ('TRANSFER_PAYROLL_ACTION_ID')));
1666: IF l_rep_type <> 'RL2PAPERPDF' THEN
1667: OPEN cur_parameters(l_mag_asg_action_id);
1668: FETCH cur_parameters

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

1674: ELSE
1675: l_arch_action_id := l_rl2pap_asg_actid;
1676: END IF;
1677:
1678: hr_utility.trace('XML Employee: l_arch_action_id = '
1679: || to_char(l_arch_action_id));
1680: hr_utility.trace('XML Employee: l_asg_id = ' || to_char(l_asg_id));
1681: hr_utility.trace('XML Employee: l_date_earned = '
1682: || to_char(l_date_earned));

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

1676: END IF;
1677:
1678: hr_utility.trace('XML Employee: l_arch_action_id = '
1679: || to_char(l_arch_action_id));
1680: hr_utility.trace('XML Employee: l_asg_id = ' || to_char(l_asg_id));
1681: hr_utility.trace('XML Employee: l_date_earned = '
1682: || to_char(l_date_earned));
1683: hr_utility.trace('XML Employee: l_province = ' || l_province);
1684:

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

1677:
1678: hr_utility.trace('XML Employee: l_arch_action_id = '
1679: || to_char(l_arch_action_id));
1680: hr_utility.trace('XML Employee: l_asg_id = ' || to_char(l_asg_id));
1681: hr_utility.trace('XML Employee: l_date_earned = '
1682: || to_char(l_date_earned));
1683: hr_utility.trace('XML Employee: l_province = ' || l_province);
1684:
1685: if l_rep_type = 'RL2PAPERPDF' then

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

1679: || to_char(l_arch_action_id));
1680: hr_utility.trace('XML Employee: l_asg_id = ' || to_char(l_asg_id));
1681: hr_utility.trace('XML Employee: l_date_earned = '
1682: || to_char(l_date_earned));
1683: hr_utility.trace('XML Employee: l_province = ' || l_province);
1684:
1685: if l_rep_type = 'RL2PAPERPDF' then
1686: l_taxation_year
1687: := pay_ca_rl2_mag.get_parameter('TAX_YEAR',

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

1789: tab_employee2(lNoReleve) := '' || convert_special_char(l_rl2_slip_number) ||
1790: '' || EOL;
1791: end if;
1792: END IF;
1793: hr_utility.trace('tab_employee(lNoReleve) = ' || tab_employee(lNoReleve));
1794:
1795: -- NAS
1796: /* Bug Fix 4754891 */
1797: IF (l_employee_sin IS NOT NULL AND

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

1832: tab_employee2(lNAS3) := NULL;
1833:
1834: end if;
1835: END IF;
1836: -- hr_utility.trace('tab_employee(lNAS) = ' || tab_employee(lNAS));
1837:
1838: -- No
1839: IF (l_employee_number IS NOT NULL AND
1840: l_employee_number <> ' ' ) THEN

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

1849: tab_employee1(lNo) := NULL;
1850: tab_employee2(lNo) := NULL;
1851: end if;
1852: END IF;
1853: hr_utility.trace('tab_employee(lNo) = ' || tab_employee(lNo));
1854:
1855: -- NomFamille
1856:
1857: tab_employee(lNomFamille) := '' ||

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

1855: -- NomFamille
1856:
1857: tab_employee(lNomFamille) := '' ||
1858: convert_special_char(substr(l_employee_last_name,1,30)) || '' || EOL;
1859: hr_utility.trace('tab_employee(lNomFamille) = ' || tab_employee(lNomFamille));
1860:
1861: l_full_empname := convert_special_char(substr(l_employee_last_name,1,30));
1862:
1863: -- Prenom

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

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

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

1889: tab_employee1(lNomFamille) := '' ||l_full_empname || '' || EOL;
1890: tab_employee2(lNomFamille) := '' ||l_full_empname || '' || EOL;
1891: end if;
1892:
1893: hr_utility.trace('tab_employee(lInitiale) = ' || tab_employee(lInitiale));
1894:
1895: l_person_id := to_number(l_per_id);
1896:
1897: l_return := pay_ca_emp_address_dtls.get_emp_address(

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

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

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

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

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

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

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

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

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

1947: convert_special_char(substr(l_address_line1,1,30)) || '' || EOL;
1948: tab_employee2(lLigne1) := '' ||
1949: convert_special_char(substr(l_address_line1,1,30)) || '' || EOL;
1950: end if;
1951: hr_utility.trace('tab_employee(lLigne1) = ' || tab_employee(lLigne1));
1952:
1953: -- Address Line 2
1954:
1955: IF ((l_address_line2 IS NOT NULL AND

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

1973: tab_employee1(lVille) := NULL;
1974: tab_employee2(lVille) := NULL;
1975: END IF;
1976: END IF;
1977: --hr_utility.trace('tab_employee(lLigne2) = ' || tab_employee(lLigne2));
1978:
1979: -- Ville (City)
1980: IF l_city IS NOT NULL AND
1981: l_city <> ' ' THEN

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

1986: ELSE
1987: tab_employee(lVille) := NULL;
1988:
1989: END IF;
1990: --hr_utility.trace('tab_employee(lVille) = ' || tab_employee(lVille));
1991:
1992: -- Province
1993: IF l_emp_province IS NOT NULL AND
1994: l_emp_province <> ' ' THEN

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

2012: ELSE
2013: tab_employee(lProvince) := NULL;
2014:
2015: END IF;
2016: hr_utility.trace('tab_employee(lProvince) = ' || tab_employee(lProvince));
2017:
2018: -- Bug# 4754743 fix
2019: -- Postal Code
2020: IF l_postal_code IS NOT NULL AND

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

2027: ELSE
2028: tab_employee(lCodePostal) := NULL;
2029: END IF;
2030:
2031: hr_utility.trace('tab_employee(lCodePostal) = ' || tab_employee(lCodePostal));
2032: l_addr_end_tag := '';
2033:
2034: END IF;
2035:

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

2072: end if;
2073:
2074: -- Summ (Box A)
2075:
2076: hr_utility.trace('The Value of Box A is '|| l_rl2_box_a);
2077: IF TO_NUMBER(l_rl2_box_a) > 9999999.99 THEN
2078: l_status := 'Failed';
2079: l_msg_code := 'AMT_GREATER_THAN_RANGE';
2080: END IF;

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

2100: tab_employee1(lA_PrestRPA_RPNA ) := NULL;
2101: tab_employee2(lA_PrestRPA_RPNA ) := NULL;
2102: end if;
2103: END IF;
2104: hr_utility.trace('tab_employee(lA_PrestRPA_RPNA) = ' ||
2105: tab_employee(lA_PrestRPA_RPNA));
2106:
2107: -- Summ (Box B)
2108:

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

2135: tab_employee2(lB_PrestREER_FERR_RPDB) := NULL;
2136: end if;
2137:
2138: END IF;
2139: hr_utility.trace('tab_employee(lB_PrestREER_FERR_RPDB) = ' ||
2140: tab_employee(lB_PrestREER_FERR_RPDB));
2141:
2142: -- Summ (Box C)
2143:

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

2169: tab_employee2(lC_AutrePaiement ) := NULL;
2170: end if;
2171: END IF;
2172:
2173: hr_utility.trace('tab_employee(lC_AutrePaiement ) = ' ||
2174: tab_employee(lC_AutrePaiement ));
2175:
2176: -- Summ (Box D)
2177:

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

2202: tab_employee1(lD_RembPrimeConjoint) := NULL;
2203: tab_employee2(lD_RembPrimeConjoint) := NULL;
2204: end if;
2205: END IF;
2206: hr_utility.trace('tab_employee(lD_RembPrimeConjoint) = ' ||
2207: tab_employee(lD_RembPrimeConjoint));
2208:
2209: -- (Box E)
2210:

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

2236: tab_employee2(lE_PrestDeces) := NULL;
2237: end if;
2238: END IF;
2239:
2240: hr_utility.trace('tab_employee(lE_PrestDeces) = ' ||
2241: tab_employee(lE_PrestDeces));
2242:
2243: -- (Box F)
2244:

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

2269: tab_employee1(lF_RembCotisInutilise) := NULL;
2270: tab_employee2(lF_RembCotisInutilise) := NULL;
2271: end if;
2272: END IF;
2273: hr_utility.trace('tab_employee(lF_RembCotisInutilise) = ' ||
2274: tab_employee(lF_RembCotisInutilise));
2275:
2276: -- (Box G)
2277:

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

2302: tab_employee1(lG_RevocationREER_FERR) := NULL;
2303: tab_employee2(lG_RevocationREER_FERR) := NULL;
2304: end if;
2305: END IF;
2306: hr_utility.trace('tab_employee(lG_RevocationREER_FERR) = ' ||
2307: tab_employee(lG_RevocationREER_FERR));
2308:
2309: -- (Box H)
2310:

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

2336: tab_employee2(lH_AutreRevenu) := NULL;
2337: end if;
2338: END IF;
2339:
2340: hr_utility.trace('tab_employee(lH_AutreRevenu ) = ' ||
2341: tab_employee(lH_AutreRevenu ));
2342:
2343: -- (Box I)
2344:

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

2369: tab_employee1(lI_DroitDeduction ) := NULL;
2370: tab_employee2(lI_DroitDeduction ) := NULL;
2371: end if;
2372: END IF;
2373: hr_utility.trace('tab_employee(lI_DroitDeduction ) = ' ||
2374: tab_employee(lI_DroitDeduction ));
2375:
2376: -- (Box J)
2377:

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

2402: tab_employee1(lJ_ImpotQueRetenuSource ) := NULL;
2403: tab_employee2(lJ_ImpotQueRetenuSource ) := NULL;
2404: end if;
2405: END IF;
2406: hr_utility.trace('tab_employee(lJ_ImpotQueRetenuSource ) = ' ||
2407: tab_employee(lJ_ImpotQueRetenuSource ));
2408:
2409: -- (Box K)
2410:

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

2435: tab_employee1(lK_RevenuApresDeces ) := NULL;
2436: tab_employee2(lK_RevenuApresDeces ) := NULL;
2437: end if;
2438: END IF;
2439: hr_utility.trace('tab_employee(lK_RevenuApresDeces ) = ' ||
2440: tab_employee(lK_RevenuApresDeces ));
2441:
2442: -- (Box L)
2443:

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

2468: tab_employee1(lL_RetraitREEP ) := NULL;
2469: tab_employee2(lL_RetraitREEP ) := NULL;
2470: end if;
2471: END IF;
2472: hr_utility.trace('tab_employee(lL_RetraitREEP ) = ' ||
2473: tab_employee(lL_RetraitREEP ));
2474:
2475: -- (Box M)
2476:

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

2501: tab_employee1(lM_LibereImpot) := NULL;
2502: tab_employee2(lM_LibereImpot) := NULL;
2503: end if;
2504: END IF;
2505: hr_utility.trace('tab_employee(lM_LibereImpot) = ' ||
2506: tab_employee(lM_LibereImpot));
2507:
2508: -- (Box N)
2509: -- Bug 5569097 Fix.

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

2548: tab_employee2(lN_NASConjoint1) := NULL;
2549: tab_employee2(lN_NASConjoint2) := NULL;
2550: end if;
2551: END IF;
2552: hr_utility.trace('tab_employee(lN_NASConjoint) = ' ||
2553: tab_employee(lN_NASConjoint));
2554:
2555: -- Summ (Box O)
2556:

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

2581: tab_employee1(lO_RetraitRAP ) := NULL;
2582: tab_employee2(lO_RetraitRAP ) := NULL;
2583: end if;
2584: END IF;
2585: hr_utility.trace('Value of Box O');
2586: hr_utility.trace('tab_employee(lO_RetraitRAP ) = ' ||
2587: tab_employee(lO_RetraitRAP ));
2588:
2589: if l_rep_type = 'RL2PAPERPDF' then

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

2582: tab_employee2(lO_RetraitRAP ) := NULL;
2583: end if;
2584: END IF;
2585: hr_utility.trace('Value of Box O');
2586: hr_utility.trace('tab_employee(lO_RetraitRAP ) = ' ||
2587: tab_employee(lO_RetraitRAP ));
2588:
2589: if l_rep_type = 'RL2PAPERPDF' then
2590: tab_employee(lCode_dereleve) := '' ||

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

2607: l_msg_code := 'ALL_BOXES_ZERO';
2608: END IF;
2609:
2610: -- (Provenance1)
2611: hr_utility.trace('The checking for Provenance value ');
2612: hr_utility.trace('The value of Archiver Assignment Action Id '||l_arch_action_id);
2613: hr_utility.trace('The Value of Assignment Id '||l_asg_id);
2614:
2615: hr_utility.trace('The value Of Provenenace : '|| l_rl2_source_of_income);

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

2608: END IF;
2609:
2610: -- (Provenance1)
2611: hr_utility.trace('The checking for Provenance value ');
2612: hr_utility.trace('The value of Archiver Assignment Action Id '||l_arch_action_id);
2613: hr_utility.trace('The Value of Assignment Id '||l_asg_id);
2614:
2615: hr_utility.trace('The value Of Provenenace : '|| l_rl2_source_of_income);
2616: IF l_rl2_source_of_income IS NOT NULL THEN

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

2609:
2610: -- (Provenance1)
2611: hr_utility.trace('The checking for Provenance value ');
2612: hr_utility.trace('The value of Archiver Assignment Action Id '||l_arch_action_id);
2613: hr_utility.trace('The Value of Assignment Id '||l_asg_id);
2614:
2615: hr_utility.trace('The value Of Provenenace : '|| l_rl2_source_of_income);
2616: IF l_rl2_source_of_income IS NOT NULL THEN
2617: tab_employee(lProvenance1 ) := '' ||

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

2611: hr_utility.trace('The checking for Provenance value ');
2612: hr_utility.trace('The value of Archiver Assignment Action Id '||l_arch_action_id);
2613: hr_utility.trace('The Value of Assignment Id '||l_asg_id);
2614:
2615: hr_utility.trace('The value Of Provenenace : '|| l_rl2_source_of_income);
2616: IF l_rl2_source_of_income IS NOT NULL THEN
2617: tab_employee(lProvenance1 ) := '' ||
2618: convert_special_char(l_rl2_source_of_income) || '' || EOL;
2619: if l_rep_type = 'RL2PAPERPDF' then

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

2632: tab_employee1(lProvenance1) := NULL;
2633: tab_employee2(lProvenance1) := NULL;
2634: end if;
2635: END IF;
2636: hr_utility.trace('tab_employee(lProvenance1) = ' ||
2637: tab_employee(lProvenance1));
2638:
2639: OPEN cur_get_meaning(l_msg_code);
2640: FETCH cur_get_meaning

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

2841: tab_employee(lErrorDetails)||
2842: '' || EOL || '' || EOL ||
2843: '' ;
2844:
2845: hr_utility.trace('Just before Printing the file details ');
2846: pay_core_files.write_to_magtape_lob(l_final_xml_string);
2847: ELSE
2848:
2849: IF l_negative_box = 'N' THEN

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

2998: ||l_final_xml_string1
2999: || l_final_xml_string2
3000: || '';
3001:
3002: hr_utility.trace('Just before Printing the file details ');
3003: pay_core_files.write_to_magtape_lob(l_final_xml_string);
3004:
3005: ELSIF l_negative_box = 'Y' THEN
3006: l_final_xml_string :=

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

3035: tab_employee(lNoReleve) ||
3036: tab_employee(lErrorDetails)||
3037: ''||EOL;
3038:
3039: hr_utility.trace('Just before Printing the file details ');
3040: pay_core_files.write_to_magtape_lob(l_final_xml_string);
3041: END IF;
3042: END IF;
3043:

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

3124: l_address_begin_tag varchar2(10);
3125: l_address_end_tag varchar2(10);
3126:
3127: BEGIN
3128: hr_utility.trace('XML Employer');
3129: hr_utility.trace('XML Employer');
3130:
3131: SELECT
3132: fnd_global.local_chr(13) || fnd_global.local_chr(10)

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

3125: l_address_end_tag varchar2(10);
3126:
3127: BEGIN
3128: hr_utility.trace('XML Employer');
3129: hr_utility.trace('XML Employer');
3130:
3131: SELECT
3132: fnd_global.local_chr(13) || fnd_global.local_chr(10)
3133: INTO EOL

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

3161:
3162: tab_employer(lAnnee) := '' || l_taxation_year || '' || EOL;
3163: tab_employer(lNbReleves) := '' || 'Running Total' || '' || EOL;
3164:
3165: hr_utility.trace('The Payroll Action Id : '||l_payroll_actid);
3166: hr_utility.trace('The business group id : '||l_business_grpid);
3167: l_quebec_bn := pay_ca_rl2_mag.get_employer_item(l_business_grpid,
3168: l_payroll_actid,
3169: 'CAEOY_RL2_QUEBEC_BN');

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

3162: tab_employer(lAnnee) := '' || l_taxation_year || '' || EOL;
3163: tab_employer(lNbReleves) := '' || 'Running Total' || '' || EOL;
3164:
3165: hr_utility.trace('The Payroll Action Id : '||l_payroll_actid);
3166: hr_utility.trace('The business group id : '||l_business_grpid);
3167: l_quebec_bn := pay_ca_rl2_mag.get_employer_item(l_business_grpid,
3168: l_payroll_actid,
3169: 'CAEOY_RL2_QUEBEC_BN');
3170: hr_utility.trace('The Quebec Number is '||l_quebec_bn);

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

3166: hr_utility.trace('The business group id : '||l_business_grpid);
3167: l_quebec_bn := pay_ca_rl2_mag.get_employer_item(l_business_grpid,
3168: l_payroll_actid,
3169: 'CAEOY_RL2_QUEBEC_BN');
3170: hr_utility.trace('The Quebec Number is '||l_quebec_bn);
3171: tab_employer(lNold) := '' || convert_special_char(substr(l_quebec_bn,1,10)) ||
3172: '' || EOL;
3173: tab_employer(lTypeDossier) := '' || 'RS' ||
3174: '' || EOL;

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

3174: '' || EOL;
3175:
3176: tab_employer(lNoDossier) := '' || convert_special_char(substr(l_quebec_bn,13,4)) ||
3177: '' || EOL;
3178: hr_utility.trace('The Employer File Number : '|| substr(l_quebec_bn,13,4));
3179: l_employer_name := pay_ca_rl2_mag.get_employer_item(l_business_grpid,
3180: l_payroll_actid,
3181: 'CAEOY_RL2_EMPLOYER_NAME');
3182:

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

3181: 'CAEOY_RL2_EMPLOYER_NAME');
3182:
3183: tab_employer(lNom1) := '' ||
3184: convert_special_char(substr(l_employer_name,1,30)) || '' || EOL;
3185: hr_utility.trace('tab_employer(lNom) = ' || tab_employer(lNom1));
3186:
3187: -- Address Line 1
3188:
3189: l_address_line := pay_ca_rl2_mag.get_employer_item(l_business_grpid,

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

3206: l_address_begin_tag := '';
3207:
3208: tab_employer(lLigne1) := '' ||
3209: convert_special_char(substr(l_address_line,1,30)) || '' || EOL;
3210: hr_utility.trace('tab_employer(lLigne1) = ' || tab_employer(lLigne1));
3211:
3212:
3213: -- Address Line 2
3214:

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

3222: convert_special_char(substr(l_address_line,1,30)) || '' || EOL;
3223: ELSE
3224: tab_employer(lLigne2) := NULL;
3225: END IF;
3226: hr_utility.trace('tab_employer(lLigne2) = ' || tab_employer(lLigne2));
3227:
3228: -- Ville (City)
3229:
3230: l_address_line := pay_ca_rl2_mag.get_employer_item(l_business_grpid,

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

3236: convert_special_char(substr(l_address_line,1,30)) || '' || EOL;
3237: ELSE
3238: tab_employer(lVille) := NULL;
3239: END IF;
3240: hr_utility.trace('tab_employer(lVille) = ' || tab_employer(lVille));
3241:
3242: -- Province
3243:
3244: l_address_line := pay_ca_rl2_mag.get_employer_item(l_business_grpid,

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

3252: l_address_line),1,20)) || '' || EOL;
3253: ELSE
3254: tab_employer(lProvince) := NULL;
3255: END IF;
3256: hr_utility.trace('tab_employer(lProvince) = ' || tab_employer(lProvince));
3257:
3258: -- Postal Code
3259:
3260: l_address_line := pay_ca_rl2_mag.get_employer_item(l_business_grpid,

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

3267: convert_special_char(substr(l_address_line,1,6)) || '' || EOL;
3268: ELSE
3269: tab_employer(lCodePostal) := NULL;
3270: END IF;
3271: hr_utility.trace('tab_employer(lCodePostal) = ' ||
3272: tab_employer(lCodePostal));
3273:
3274: l_address_end_tag := '';
3275:

Line 3377: hr_utility.set_message(801,'PAY_74156_INCORRECT_QIN_INFO');

3373: l_chk_digit := 11 - l_modulus;
3374: end if;
3375:
3376: if l_chk_digit <> l_act_chk_number then
3377: hr_utility.set_message(801,'PAY_74156_INCORRECT_QIN_INFO');
3378: hr_utility.set_message_token('PRE_NAME',p_qin_name);
3379: pay_core_utils.push_message(801,'PAY_74156_INCORRECT_QIN_INFO','P');
3380: pay_core_utils.push_token('PRE_NAME',p_qin_name);
3381: hr_utility.raise_error;

Line 3378: hr_utility.set_message_token('PRE_NAME',p_qin_name);

3374: end if;
3375:
3376: if l_chk_digit <> l_act_chk_number then
3377: hr_utility.set_message(801,'PAY_74156_INCORRECT_QIN_INFO');
3378: hr_utility.set_message_token('PRE_NAME',p_qin_name);
3379: pay_core_utils.push_message(801,'PAY_74156_INCORRECT_QIN_INFO','P');
3380: pay_core_utils.push_token('PRE_NAME',p_qin_name);
3381: hr_utility.raise_error;
3382: end if;

Line 3381: hr_utility.raise_error;

3377: hr_utility.set_message(801,'PAY_74156_INCORRECT_QIN_INFO');
3378: hr_utility.set_message_token('PRE_NAME',p_qin_name);
3379: pay_core_utils.push_message(801,'PAY_74156_INCORRECT_QIN_INFO','P');
3380: pay_core_utils.push_token('PRE_NAME',p_qin_name);
3381: hr_utility.raise_error;
3382: end if;
3383: else
3384:
3385: hr_utility.set_message(801,'PAY_74156_INCORRECT_QIN_INFO');

Line 3385: hr_utility.set_message(801,'PAY_74156_INCORRECT_QIN_INFO');

3381: hr_utility.raise_error;
3382: end if;
3383: else
3384:
3385: hr_utility.set_message(801,'PAY_74156_INCORRECT_QIN_INFO');
3386: hr_utility.set_message_token('PRE_NAME',p_qin_name);
3387: pay_core_utils.push_message(801,'PAY_74156_INCORRECT_QIN_INFO','P');
3388: pay_core_utils.push_token('PRE_NAME',p_qin_name);
3389: hr_utility.raise_error;

Line 3386: hr_utility.set_message_token('PRE_NAME',p_qin_name);

3382: end if;
3383: else
3384:
3385: hr_utility.set_message(801,'PAY_74156_INCORRECT_QIN_INFO');
3386: hr_utility.set_message_token('PRE_NAME',p_qin_name);
3387: pay_core_utils.push_message(801,'PAY_74156_INCORRECT_QIN_INFO','P');
3388: pay_core_utils.push_token('PRE_NAME',p_qin_name);
3389: hr_utility.raise_error;
3390:

Line 3389: hr_utility.raise_error;

3385: hr_utility.set_message(801,'PAY_74156_INCORRECT_QIN_INFO');
3386: hr_utility.set_message_token('PRE_NAME',p_qin_name);
3387: pay_core_utils.push_message(801,'PAY_74156_INCORRECT_QIN_INFO','P');
3388: pay_core_utils.push_token('PRE_NAME',p_qin_name);
3389: hr_utility.raise_error;
3390:
3391: end if;
3392:
3393: return l_chk_digit;

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

3687: l_check_number number;
3688: BEGIN
3689:
3690: l_check_number := mod(p_curr_seq,7);
3691: hr_utility.trace('l_check_number ='|| l_check_number);
3692: l_seq_number := (p_curr_seq * 10) + l_check_number;
3693: hr_utility.trace('l_seq_number ='|| l_seq_number);
3694: return l_seq_number;
3695: END;

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

3689:
3690: l_check_number := mod(p_curr_seq,7);
3691: hr_utility.trace('l_check_number ='|| l_check_number);
3692: l_seq_number := (p_curr_seq * 10) + l_check_number;
3693: hr_utility.trace('l_seq_number ='|| l_seq_number);
3694: return l_seq_number;
3695: END;
3696: END pay_ca_rl2_mag;