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_CAN_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_can_mag.get_report_parameters', 10);
35:
36: SELECT ppa.start_date,
37: ppa.effective_date,

Line 34: hr_utility.set_location('pay_ca_rl2_can_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_can_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_can_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_can_mag.get_report_parameters', 20);
50:
51: END get_report_parameters;
52:
53: ---------------------------------------------------------------------------

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

120:
121: l_transmitter_org_id := pay_ca_rl2_can_mag.get_parameter('TRANSMITTER_PRE',
122: l_legislative_parameters);
123:
124: hr_utility.trace('l_transmitter_org_id = ' || to_char(l_transmitter_org_id));
125: hr_utility.trace('p_bg_id = ' || to_char(p_bg_id));
126: hr_utility.trace('p_payroll_action_id = ' || to_char(p_payroll_action_id));
127: hr_utility.trace('p_effective_date = ' || to_char(p_effective_date));
128:

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

121: l_transmitter_org_id := pay_ca_rl2_can_mag.get_parameter('TRANSMITTER_PRE',
122: l_legislative_parameters);
123:
124: hr_utility.trace('l_transmitter_org_id = ' || to_char(l_transmitter_org_id));
125: hr_utility.trace('p_bg_id = ' || to_char(p_bg_id));
126: hr_utility.trace('p_payroll_action_id = ' || to_char(p_payroll_action_id));
127: hr_utility.trace('p_effective_date = ' || to_char(p_effective_date));
128:
129: l_mag_pactid := pay_ca_rl1_can_mag.get_parameter('PAY_ACT',

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

122: l_legislative_parameters);
123:
124: hr_utility.trace('l_transmitter_org_id = ' || to_char(l_transmitter_org_id));
125: hr_utility.trace('p_bg_id = ' || to_char(p_bg_id));
126: hr_utility.trace('p_payroll_action_id = ' || to_char(p_payroll_action_id));
127: hr_utility.trace('p_effective_date = ' || to_char(p_effective_date));
128:
129: l_mag_pactid := pay_ca_rl1_can_mag.get_parameter('PAY_ACT',
130: l_legislative_parameters);

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

123:
124: hr_utility.trace('l_transmitter_org_id = ' || to_char(l_transmitter_org_id));
125: hr_utility.trace('p_bg_id = ' || to_char(p_bg_id));
126: hr_utility.trace('p_payroll_action_id = ' || to_char(p_payroll_action_id));
127: hr_utility.trace('p_effective_date = ' || to_char(p_effective_date));
128:
129: l_mag_pactid := pay_ca_rl1_can_mag.get_parameter('PAY_ACT',
130: l_legislative_parameters);
131:

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

133: FETCH c_ppa_report_type
134: INTO l_locked_report_type;
135: CLOSE c_ppa_report_type;
136:
137: hr_utility.trace('l_locked_report_type = ' || l_locked_report_type);
138:
139: OPEN cur_arch_pactid(l_transmitter_org_id, l_locked_report_type);
140: FETCH cur_arch_pactid
141: INTO l_arch_pactid;

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

148: l_arch_pactid,
149: 'CAEOY_RL2_TRANSMITTER_NAME');
150: BEGIN
151:
152: hr_utility.trace('l_transmitter_number = ' || l_transmitter_number);
153: SELECT substr(l_transmitter_number,1,2)
154: INTO dummy1
155: FROM dual;
156:

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

164: FROM dual;
165:
166: EXCEPTION
167: WHEN INVALID_NUMBER THEN
168: hr_utility.set_message(800,'PAY_CA_RL1_INVALID_TRANSMITTER');
169: hr_utility.set_message_token('PRE_NAME',l_transmitter_name);
170: pay_core_utils.push_message(800,'PAY_CA_RL1_INVALID_TRANSMITTER','P');
171: pay_core_utils.push_token('PRE_NAME',l_transmitter_name);
172: hr_utility.raise_error;

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

165:
166: EXCEPTION
167: WHEN INVALID_NUMBER THEN
168: hr_utility.set_message(800,'PAY_CA_RL1_INVALID_TRANSMITTER');
169: hr_utility.set_message_token('PRE_NAME',l_transmitter_name);
170: pay_core_utils.push_message(800,'PAY_CA_RL1_INVALID_TRANSMITTER','P');
171: pay_core_utils.push_token('PRE_NAME',l_transmitter_name);
172: hr_utility.raise_error;
173: END;

Line 172: hr_utility.raise_error;

168: hr_utility.set_message(800,'PAY_CA_RL1_INVALID_TRANSMITTER');
169: hr_utility.set_message_token('PRE_NAME',l_transmitter_name);
170: pay_core_utils.push_message(800,'PAY_CA_RL1_INVALID_TRANSMITTER','P');
171: pay_core_utils.push_token('PRE_NAME',l_transmitter_name);
172: hr_utility.raise_error;
173: END;
174:
175: l_type_of_package := pay_ca_rl2_can_mag.get_transmitter_item(p_bg_id,
176: l_arch_pactid,

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

175: l_type_of_package := pay_ca_rl2_can_mag.get_transmitter_item(p_bg_id,
176: l_arch_pactid,
177: 'CAEOY_RL2_TRANSMITTER_PACKAGE_TYPE');
178:
179: hr_utility.trace('l_type_of_package = ' || l_type_of_package);
180:
181: IF l_type_of_package IS NULL THEN
182: pay_core_utils.push_message(800,'PAY_CA_RL1_MISSING_TYPE_OF_PKG','P');
183: hr_utility.raise_error;

Line 183: hr_utility.raise_error;

179: hr_utility.trace('l_type_of_package = ' || l_type_of_package);
180:
181: IF l_type_of_package IS NULL THEN
182: pay_core_utils.push_message(800,'PAY_CA_RL1_MISSING_TYPE_OF_PKG','P');
183: hr_utility.raise_error;
184: END IF;
185:
186: l_source_of_slips := pay_ca_rl2_can_mag.get_transmitter_item(p_bg_id,
187: l_arch_pactid,

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

185:
186: l_source_of_slips := pay_ca_rl2_can_mag.get_transmitter_item(p_bg_id,
187: l_arch_pactid,
188: 'CAEOY_RL2_SOURCE_OF_SLIPS');
189: hr_utility.trace('l_source_of_slips = ' || l_source_of_slips);
190:
191: IF l_source_of_slips IS NULL THEN
192: pay_core_utils.push_message(800,'PAY_CA_RL1_MISSING_RLSLIP_SRC','P');
193: hr_utility.raise_error;

Line 193: hr_utility.raise_error;

189: hr_utility.trace('l_source_of_slips = ' || l_source_of_slips);
190:
191: IF l_source_of_slips IS NULL THEN
192: pay_core_utils.push_message(800,'PAY_CA_RL1_MISSING_RLSLIP_SRC','P');
193: hr_utility.raise_error;
194: END IF;
195:
196: l_address_line1 := pay_ca_rl2_can_mag.get_transmitter_item(p_bg_id,
197: l_arch_pactid,

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

195:
196: l_address_line1 := pay_ca_rl2_can_mag.get_transmitter_item(p_bg_id,
197: l_arch_pactid,
198: 'CAEOY_RL2_TRANSMITTER_ADDRESS_LINE1');
199: hr_utility.trace('l_address_line1 = ' || l_address_line1);
200:
201: IF l_address_line1 IS NULL THEN
202: pay_core_utils.push_message(800,'PAY_CA_RL1_MISSING_TRNMTR_ADDR','P');
203: hr_utility.raise_error;

Line 203: hr_utility.raise_error;

199: hr_utility.trace('l_address_line1 = ' || l_address_line1);
200:
201: IF l_address_line1 IS NULL THEN
202: pay_core_utils.push_message(800,'PAY_CA_RL1_MISSING_TRNMTR_ADDR','P');
203: hr_utility.raise_error;
204: END IF;
205:
206: END;
207:

Line 235: hr_utility.set_location( 'pay_ca_rl2_can_mag.range_cursor', 10);

231: p_legislative_param pay_payroll_actions.legislative_parameters%type;
232:
233: BEGIN
234:
235: hr_utility.set_location( 'pay_ca_rl2_can_mag.range_cursor', 10);
236:
237: get_report_parameters(
238: p_pactid,
239: p_year_start,

Line 246: hr_utility.set_location( 'pay_ca_rl2_can_mag.range_cursor', 20);

242: p_business_group_id,
243: p_legislative_param
244: );
245:
246: hr_utility.set_location( 'pay_ca_rl2_can_mag.range_cursor', 20);
247:
248: p_sqlstr := 'select distinct paaf.person_id
249: from per_all_assignments_f paaf,
250: pay_payroll_actions ppa,

Line 263: hr_utility.set_location( 'pay_ca_rl2_can_mag.range_cursor',30);

259: nvl(pay_ca_rl2_can_mag.get_parameter(''PER_ID'',ppa1.legislative_parameters),paaf.person_id)
260: order by paaf.person_id';
261: -- order by paaf.person_id clause added for bug 9211063
262:
263: hr_utility.set_location( 'pay_ca_rl2_can_mag.range_cursor',30);
264:
265: END range_cursor;
266:
267: -------------------------------------------------------------------------------

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

401: l_legislative_param pay_payroll_actions.legislative_parameters%type;
402:
403: BEGIN
404:
405: -- hr_utility.trace_on(NULL,'RL2MAG');
406: -- Get the report parameters. These define the report being run.
407: l_prev_payact := -1;
408: hr_utility.set_location( 'pay_ca_rl2_can_mag.create_assignment_act',10);
409:

Line 408: hr_utility.set_location( 'pay_ca_rl2_can_mag.create_assignment_act',10);

404:
405: -- hr_utility.trace_on(NULL,'RL2MAG');
406: -- Get the report parameters. These define the report being run.
407: l_prev_payact := -1;
408: hr_utility.set_location( 'pay_ca_rl2_can_mag.create_assignment_act',10);
409:
410: get_report_parameters(
411: p_pactid,
412: l_year_start,

Line 423: hr_utility.set_location( 'pay_ca_rl2_can_mag.create_assignment_act',20);

419: validate_transmitter_info(p_pactid,
420: l_business_group_id,
421: l_year_end);
422:
423: hr_utility.set_location( 'pay_ca_rl2_can_mag.create_assignment_act',20);
424: hr_utility.trace('Report type '||l_report_type);
425:
426: l_asg_set_id := to_number(pay_ca_rl2_can_mag.get_parameter('ASG_SET_ID',l_legislative_param));
427: hr_utility.trace('Assignment Set Id : '|| to_char(l_asg_set_id));

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

420: l_business_group_id,
421: l_year_end);
422:
423: hr_utility.set_location( 'pay_ca_rl2_can_mag.create_assignment_act',20);
424: hr_utility.trace('Report type '||l_report_type);
425:
426: l_asg_set_id := to_number(pay_ca_rl2_can_mag.get_parameter('ASG_SET_ID',l_legislative_param));
427: hr_utility.trace('Assignment Set Id : '|| to_char(l_asg_set_id));
428:

Line 427: hr_utility.trace('Assignment Set Id : '|| to_char(l_asg_set_id));

423: hr_utility.set_location( 'pay_ca_rl2_can_mag.create_assignment_act',20);
424: hr_utility.trace('Report type '||l_report_type);
425:
426: l_asg_set_id := to_number(pay_ca_rl2_can_mag.get_parameter('ASG_SET_ID',l_legislative_param));
427: hr_utility.trace('Assignment Set Id : '|| to_char(l_asg_set_id));
428:
429: IF l_asg_set_id IS NOT NULL THEN
430: OPEN c_all_asg_in_asgset;
431: ELSE

Line 444: hr_utility.set_location('pay_ca_rl2_can_mag.create_assignement_act', 25);

440: l_effective_end_date,
441: l_assignment_action_id,
442: l_payroll_act;
443:
444: hr_utility.set_location('pay_ca_rl2_can_mag.create_assignement_act', 25);
445:
446: EXIT WHEN c_all_asg_in_asgset%NOTFOUND;
447: ELSE
448: FETCH c_all_asg INTO l_person_id,

Line 455: hr_utility.set_location('pay_ca_rl2_can_mag.create_assignement_act', 30);

451: l_effective_end_date,
452: l_assignment_action_id,
453: l_payroll_act;
454:
455: hr_utility.set_location('pay_ca_rl2_can_mag.create_assignement_act', 30);
456:
457: EXIT WHEN c_all_asg%NOTFOUND;
458: END IF;
459:

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

461:
462: /* Validating QIN Number information */
463: if l_prev_payact <> l_payroll_act then
464:
465: hr_utility.trace('The payroll action id '||l_payroll_act);
466:
467: l_prev_payact := l_payroll_act;
468: l_emplyer_name := pay_ca_rl2_can_mag.get_employer_item(l_business_group_id,
469: l_payroll_act,

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

471:
472: l_quebec_no := pay_ca_rl2_can_mag.get_employer_item(l_business_group_id,
473: l_payroll_act,
474: 'CAEOY_RL2_QUEBEC_BN');
475: hr_utility.trace('The Quebec Number is '||l_quebec_no);
476: l_file_no := substr(l_quebec_no,13,4);
477: l_quebec_no := substr(l_quebec_no ,1,10);
478:
479: /* Fix for Bug# 4038551 */

Line 485: hr_utility.raise_error;

481: length(l_file_no) < 4
482: then
483: pay_core_utils.push_message(801,'PAY_74156_INCORRECT_QIN_INFO','P');
484: pay_core_utils.push_token('PRE_NAME',l_emplyer_name);
485: hr_utility.raise_error;
486: end if;
487:
488:
489: /* Erroring out the RL2 Electronic Interface if any of the

Line 498: hr_utility.raise_error;

494: 'CAEOY_RL2_EMPLOYER_ADDRESS_LINE1');
495: if l_addr_line = ' '
496: then
497: pay_core_utils.push_message(800,'PAY_CA_RL2_MISSING_ADDRESS','P');
498: hr_utility.raise_error;
499: end if;
500: hr_utility.trace('First 10 digits of the QIN: '||l_quebec_no);
501: l_return := validate_quebec_number(l_quebec_no,l_emplyer_name);
502:

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

496: then
497: pay_core_utils.push_message(800,'PAY_CA_RL2_MISSING_ADDRESS','P');
498: hr_utility.raise_error;
499: end if;
500: hr_utility.trace('First 10 digits of the QIN: '||l_quebec_no);
501: l_return := validate_quebec_number(l_quebec_no,l_emplyer_name);
502:
503: end if ;
504:

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

501: l_return := validate_quebec_number(l_quebec_no,l_emplyer_name);
502:
503: end if ;
504:
505: hr_utility.trace('Assignment Fetched - ');
506: hr_utility.trace('Assignment Id : '|| to_char(l_assignment_id));
507: hr_utility.trace('Person Id : '|| to_char(l_person_id));
508: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
509: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date));

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

502:
503: end if ;
504:
505: hr_utility.trace('Assignment Fetched - ');
506: hr_utility.trace('Assignment Id : '|| to_char(l_assignment_id));
507: hr_utility.trace('Person Id : '|| to_char(l_person_id));
508: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
509: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date));
510:

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

503: end if ;
504:
505: hr_utility.trace('Assignment Fetched - ');
506: hr_utility.trace('Assignment Id : '|| to_char(l_assignment_id));
507: hr_utility.trace('Person Id : '|| to_char(l_person_id));
508: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
509: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date));
510:
511: hr_utility.set_location('pay_ca_rl2_can_mag.create_assignment_act', 40);

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

504:
505: hr_utility.trace('Assignment Fetched - ');
506: hr_utility.trace('Assignment Id : '|| to_char(l_assignment_id));
507: hr_utility.trace('Person Id : '|| to_char(l_person_id));
508: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
509: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date));
510:
511: hr_utility.set_location('pay_ca_rl2_can_mag.create_assignment_act', 40);
512:

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

505: hr_utility.trace('Assignment Fetched - ');
506: hr_utility.trace('Assignment Id : '|| to_char(l_assignment_id));
507: hr_utility.trace('Person Id : '|| to_char(l_person_id));
508: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
509: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date));
510:
511: hr_utility.set_location('pay_ca_rl2_can_mag.create_assignment_act', 40);
512:
513: SELECT pay_assignment_actions_s.nextval

Line 511: hr_utility.set_location('pay_ca_rl2_can_mag.create_assignment_act', 40);

507: hr_utility.trace('Person Id : '|| to_char(l_person_id));
508: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
509: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date));
510:
511: hr_utility.set_location('pay_ca_rl2_can_mag.create_assignment_act', 40);
512:
513: SELECT pay_assignment_actions_s.nextval
514: INTO lockingactid
515: FROM dual;

Line 517: hr_utility.set_location('pay_ca_rl2_can_mag.create_assignment_act', 50);

513: SELECT pay_assignment_actions_s.nextval
514: INTO lockingactid
515: FROM dual;
516:
517: hr_utility.set_location('pay_ca_rl2_can_mag.create_assignment_act', 50);
518: hr_nonrun_asact.insact(lockingactid,
519: l_assignment_id,
520: p_pactid,
521: p_chunk,

Line 524: hr_utility.set_location('pay_ca_rl2_can_mag.create_assignment_act', 60);

520: p_pactid,
521: p_chunk,
522: l_tax_unit_id);
523:
524: hr_utility.set_location('pay_ca_rl2_can_mag.create_assignment_act', 60);
525:
526: hr_nonrun_asact.insint(lockingactid, l_assignment_action_id);
527:
528: hr_utility.set_location('pay_ca_rl2_can_mag.create_assignment_act', 70);

Line 528: hr_utility.set_location('pay_ca_rl2_can_mag.create_assignment_act', 70);

524: hr_utility.set_location('pay_ca_rl2_can_mag.create_assignment_act', 60);
525:
526: hr_nonrun_asact.insint(lockingactid, l_assignment_action_id);
527:
528: hr_utility.set_location('pay_ca_rl2_can_mag.create_assignment_act', 70);
529: hr_utility.trace('Interlock Created - ');
530: hr_utility.trace('Locking Action : '|| to_char(lockingactid));
531: hr_utility.trace('Locked Action : '|| to_char(l_assignment_action_id));
532: END LOOP;

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

525:
526: hr_nonrun_asact.insint(lockingactid, l_assignment_action_id);
527:
528: hr_utility.set_location('pay_ca_rl2_can_mag.create_assignment_act', 70);
529: hr_utility.trace('Interlock Created - ');
530: hr_utility.trace('Locking Action : '|| to_char(lockingactid));
531: hr_utility.trace('Locked Action : '|| to_char(l_assignment_action_id));
532: END LOOP;
533:

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

526: hr_nonrun_asact.insint(lockingactid, l_assignment_action_id);
527:
528: hr_utility.set_location('pay_ca_rl2_can_mag.create_assignment_act', 70);
529: hr_utility.trace('Interlock Created - ');
530: hr_utility.trace('Locking Action : '|| to_char(lockingactid));
531: hr_utility.trace('Locked Action : '|| to_char(l_assignment_action_id));
532: END LOOP;
533:
534: IF l_asg_set_id IS NOT NULL THEN

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

527:
528: hr_utility.set_location('pay_ca_rl2_can_mag.create_assignment_act', 70);
529: hr_utility.trace('Interlock Created - ');
530: hr_utility.trace('Locking Action : '|| to_char(lockingactid));
531: hr_utility.trace('Locked Action : '|| to_char(l_assignment_action_id));
532: END LOOP;
533:
534: IF l_asg_set_id IS NOT NULL THEN
535: CLOSE c_all_asg_in_asgset;

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

895: l_rl_package_type VARCHAR2(20);
896:
897: BEGIN
898:
899: hr_utility.trace('XML Transmitter');
900:
901: SELECT
902: fnd_global.local_chr(13) || fnd_global.local_chr(10)
903: INTO EOL

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: -- TypeEnvoi
993: OPEN c_rl_package_type;
994: FETCH c_rl_package_type INTO l_rl_package_type;

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

994: FETCH c_rl_package_type INTO l_rl_package_type;
995: CLOSE c_rl_package_type;
996:
997: tab_transmitter(lTypeEnvoi) := '' ||l_rl_package_type|| '' || EOL;
998: hr_utility.trace('tab_transmitter(lTypeEnvoi) = ' ||
999: tab_transmitter(lTypeEnvoi));
1000:
1001: tab_transmitter(lProvenance) := '' ||
1002: convert_special_char(l_source_of_slips) || '' || EOL;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1215: --- End 6736354
1216:
1217: tab_transmitter(lNoConcepteur) := ''||convert_special_char(l_authorization_no)||''||EOL;
1218:
1219: hr_utility.trace('tab_transmitter(lALangue) = ' || tab_transmitter(lALangue));
1220:
1221: IF l_Informatique_tag = 'Y' AND
1222: l_Comptabilite_tag = 'Y' THEN
1223: 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 1659: hr_utility.trace('XML Employee');

1655: l_legislative_parameters pay_payroll_actions.legislative_parameters%type;
1656:
1657: BEGIN
1658:
1659: hr_utility.trace('XML Employee');
1660: l_status := 'Success';
1661: l_all_box_0 := TRUE;
1662: l_count := 0;
1663: l_format_mask := '99999999999999990.99';

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

1723: l_business_group_id,
1724: l_legislative_parameters;
1725: close c_get_report_type;
1726:
1727: hr_utility.trace('XML Employee: l_mag_asg_action_id = '
1728: || to_char(l_mag_asg_action_id));
1729: hr_utility.trace('XML Employee: Transfer Payroll Action Id '||to_number(pay_magtape_generic.get_parameter_value
1730: ('TRANSFER_PAYROLL_ACTION_ID')));
1731:

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

1725: close c_get_report_type;
1726:
1727: hr_utility.trace('XML Employee: l_mag_asg_action_id = '
1728: || to_char(l_mag_asg_action_id));
1729: hr_utility.trace('XML Employee: Transfer Payroll Action Id '||to_number(pay_magtape_generic.get_parameter_value
1730: ('TRANSFER_PAYROLL_ACTION_ID')));
1731:
1732: OPEN cur_parameters(l_mag_asg_action_id);
1733: FETCH cur_parameters

Line 1741: hr_utility.trace('XML Employee: l_arch_action_id = '|| to_char(l_arch_action_id));

1737: l_date_earned,
1738: l_pre_id;
1739: CLOSE cur_parameters;
1740:
1741: hr_utility.trace('XML Employee: l_arch_action_id = '|| to_char(l_arch_action_id));
1742: hr_utility.trace('XML Employee: l_asg_id = ' || to_char(l_asg_id));
1743: hr_utility.trace('XML Employee: l_date_earned = '|| to_char(l_date_earned));
1744: hr_utility.trace('XML Employee: l_province = '|| l_province);
1745:

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

1738: l_pre_id;
1739: CLOSE cur_parameters;
1740:
1741: hr_utility.trace('XML Employee: l_arch_action_id = '|| to_char(l_arch_action_id));
1742: hr_utility.trace('XML Employee: l_asg_id = ' || to_char(l_asg_id));
1743: hr_utility.trace('XML Employee: l_date_earned = '|| to_char(l_date_earned));
1744: hr_utility.trace('XML Employee: l_province = '|| l_province);
1745:
1746: l_taxation_year := pay_magtape_generic.get_parameter_value('REPORTING_YEAR');

Line 1743: hr_utility.trace('XML Employee: l_date_earned = '|| to_char(l_date_earned));

1739: CLOSE cur_parameters;
1740:
1741: hr_utility.trace('XML Employee: l_arch_action_id = '|| to_char(l_arch_action_id));
1742: hr_utility.trace('XML Employee: l_asg_id = ' || to_char(l_asg_id));
1743: hr_utility.trace('XML Employee: l_date_earned = '|| to_char(l_date_earned));
1744: hr_utility.trace('XML Employee: l_province = '|| l_province);
1745:
1746: l_taxation_year := pay_magtape_generic.get_parameter_value('REPORTING_YEAR');
1747:

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

1740:
1741: hr_utility.trace('XML Employee: l_arch_action_id = '|| to_char(l_arch_action_id));
1742: hr_utility.trace('XML Employee: l_asg_id = ' || to_char(l_asg_id));
1743: hr_utility.trace('XML Employee: l_date_earned = '|| to_char(l_date_earned));
1744: hr_utility.trace('XML Employee: l_province = '|| l_province);
1745:
1746: l_taxation_year := pay_magtape_generic.get_parameter_value('REPORTING_YEAR');
1747:
1748: tab_employee(lAnnee) := '' || l_taxation_year || '' || EOL;

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

1788: /* OPEN cur_rl2_slip_no(to_number(l_per_id), l_taxation_year, l_pre_id);
1789: FETCH cur_rl2_slip_no into l_rl2_org_slip_number;
1790: CLOSE cur_rl2_slip_no; */
1791:
1792: hr_utility.trace('l_person_id = '||l_person_id);
1793: hr_utility.trace('l_taxation_year = '||l_taxation_year);
1794: hr_utility.trace('l_pre_id = '||l_pre_id);
1795:
1796: l_k := 0;

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

1789: FETCH cur_rl2_slip_no into l_rl2_org_slip_number;
1790: CLOSE cur_rl2_slip_no; */
1791:
1792: hr_utility.trace('l_person_id = '||l_person_id);
1793: hr_utility.trace('l_taxation_year = '||l_taxation_year);
1794: hr_utility.trace('l_pre_id = '||l_pre_id);
1795:
1796: l_k := 0;
1797: lv_org_slip_no := NULL;

Line 1794: hr_utility.trace('l_pre_id = '||l_pre_id);

1790: CLOSE cur_rl2_slip_no; */
1791:
1792: hr_utility.trace('l_person_id = '||l_person_id);
1793: hr_utility.trace('l_taxation_year = '||l_taxation_year);
1794: hr_utility.trace('l_pre_id = '||l_pre_id);
1795:
1796: l_k := 0;
1797: lv_org_slip_no := NULL;
1798: OPEN cur_rl2_slip_no(to_number(l_per_id), l_taxation_year, l_pre_id);

Line 1811: hr_utility.trace('lv_org_slip_no = '||lv_org_slip_no);

1807: end if;
1808: end loop;
1809: CLOSE cur_rl2_slip_no;
1810:
1811: hr_utility.trace('lv_org_slip_no = '||lv_org_slip_no);
1812:
1813: IF ( lv_org_slip_no IS NULL) THEN
1814: l_status := 'Failed';
1815: l_msg_code := 'MISSING_SLIP_NO';

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

1818: l_rl2_org_slip_number := pay_ca_rl2_mag.get_slip_seq_no('|',lv_org_slip_no,1);
1819: tab_employee(lNoReleve) := '' || convert_special_char(l_rl2_org_slip_number) ||
1820: '' || EOL;
1821: END IF;
1822: hr_utility.trace('tab_employee(lNoReleve) = ' || tab_employee(lNoReleve));
1823:
1824: -- NAS
1825: /* Bug Fix 4754891 */
1826: IF (l_employee_sin IS NOT NULL AND

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

1830: l_status := 'Failed';
1831: l_msg_code := 'SIN';
1832: tab_employee(lNAS) := NULL;
1833: END IF;
1834: hr_utility.trace('tab_employee(lNAS) = ' || tab_employee(lNAS));
1835:
1836: -- No
1837: IF (l_employee_number IS NOT NULL AND
1838: l_employee_number <> ' ' ) THEN

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

1839: tab_employee(lNo) := '' || convert_special_char(l_employee_number) || '' || EOL;
1840: ELSE
1841: tab_employee(lNo) := NULL;
1842: END IF;
1843: hr_utility.trace('tab_employee(lNo) = ' || tab_employee(lNo));
1844:
1845: -- NomFamille
1846: tab_employee(lNomFamille) := '' ||
1847: convert_special_char(substr(l_employee_last_name,1,30)) || '' || EOL;

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

1844:
1845: -- NomFamille
1846: tab_employee(lNomFamille) := '' ||
1847: convert_special_char(substr(l_employee_last_name,1,30)) || '' || EOL;
1848: hr_utility.trace('tab_employee(lNomFamille) = ' || tab_employee(lNomFamille));
1849:
1850: l_full_empname := convert_special_char(substr(l_employee_last_name,1,30));
1851:
1852: -- Prenom

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

1859: l_msg_code := 'MISSING_EMP_FIRST_NAME';
1860: l_status := 'Failed';
1861: tab_employee(lPrenom) := NULL;
1862: END IF;
1863: hr_utility.trace('tab_employee(lPrenom) = ' || tab_employee(lPrenom));
1864:
1865: -- Initiale
1866: IF (l_employee_middle_initial is NOT NULL AND
1867: l_employee_middle_initial <> ' ') THEN

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

1871: ELSE
1872: tab_employee(lInitiale) := NULL;
1873: END IF;
1874:
1875: hr_utility.trace('tab_employee(lInitiale) = ' || tab_employee(lInitiale));
1876:
1877: l_person_id := to_number(l_per_id);
1878:
1879: l_return := pay_ca_emp_address_dtls.get_emp_address(

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

1889: -- If Address line 1 is NULL or ' ' then the employee is missing
1890: -- address information - as line 1 is mandatory in the Address form.
1891: -- Need to check data by SS transaction /API.
1892:
1893: hr_utility.trace('l_person_id = ' || to_char(l_person_id));
1894: hr_utility.trace('l_address_line1 = ' || l_address_line1);
1895: hr_utility.trace('l_address_line2 = ' || l_address_line2);
1896: hr_utility.trace('l_postal_code = ' || l_postal_code);
1897:

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

1890: -- address information - as line 1 is mandatory in the Address form.
1891: -- Need to check data by SS transaction /API.
1892:
1893: hr_utility.trace('l_person_id = ' || to_char(l_person_id));
1894: hr_utility.trace('l_address_line1 = ' || l_address_line1);
1895: hr_utility.trace('l_address_line2 = ' || l_address_line2);
1896: hr_utility.trace('l_postal_code = ' || l_postal_code);
1897:
1898: /* Bug Fix 4761782 */

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

1891: -- Need to check data by SS transaction /API.
1892:
1893: hr_utility.trace('l_person_id = ' || to_char(l_person_id));
1894: hr_utility.trace('l_address_line1 = ' || l_address_line1);
1895: hr_utility.trace('l_address_line2 = ' || l_address_line2);
1896: hr_utility.trace('l_postal_code = ' || l_postal_code);
1897:
1898: /* Bug Fix 4761782 */
1899: -- Address Line 1

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

1892:
1893: hr_utility.trace('l_person_id = ' || to_char(l_person_id));
1894: hr_utility.trace('l_address_line1 = ' || l_address_line1);
1895: hr_utility.trace('l_address_line2 = ' || l_address_line2);
1896: hr_utility.trace('l_postal_code = ' || l_postal_code);
1897:
1898: /* Bug Fix 4761782 */
1899: -- Address Line 1
1900: IF l_address_line1 IS NOT NULL AND

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

1915: l_addr_begin_tag := '';
1916:
1917: tab_employee(lLigne1) := '' ||
1918: convert_special_char(substr(l_address_line1,1,30)) || '' || EOL;
1919: hr_utility.trace('tab_employee(lLigne1) = ' || tab_employee(lLigne1));
1920:
1921: -- Address Line 2
1922: IF ((l_address_line2 IS NOT NULL AND
1923: l_address_line2 <> ' ' ) OR

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

1928: convert_special_char(substr(l_combined_addr,1,30)) || '' || EOL;
1929: ELSE
1930: tab_employee(lLigne2) := NULL;
1931: END IF;
1932: hr_utility.trace('tab_employee(lLigne2) = ' || tab_employee(lLigne2));
1933:
1934: -- Ville (City)
1935: IF l_city IS NOT NULL AND
1936: l_city <> ' ' THEN

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

1939: l_full_empaddr := convert_special_char(substr(l_city,1,30));
1940: ELSE
1941: tab_employee(lVille) := NULL;
1942: END IF;
1943: hr_utility.trace('tab_employee(lVille) = ' || tab_employee(lVille));
1944:
1945: -- Province
1946: IF l_emp_province IS NOT NULL AND
1947: l_emp_province <> ' ' THEN

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

1965: ELSE
1966: tab_employee(lProvince) := NULL;
1967:
1968: END IF;
1969: hr_utility.trace('tab_employee(lProvince) = ' || tab_employee(lProvince));
1970:
1971: -- Bug# 4754743 fix
1972: -- Postal Code
1973: IF l_postal_code IS NOT NULL AND

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

1979: ELSE
1980: tab_employee(lCodePostal) := NULL;
1981: END IF;
1982:
1983: hr_utility.trace('tab_employee(lCodePostal) = ' || tab_employee(lCodePostal));
1984: l_addr_end_tag := '';
1985:
1986: END IF;
1987:

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

1985:
1986: END IF;
1987:
1988: -- Summ (Box A)
1989: hr_utility.trace('The Value of Box A is '|| l_rl2_box_a);
1990: IF TO_NUMBER(l_rl2_box_a) > 9999999.99 THEN
1991: l_status := 'Failed';
1992: l_msg_code := 'AMT_GREATER_THAN_RANGE';
1993: END IF;

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

2004: l_all_box_0 := FALSE;
2005: ELSE
2006: tab_employee(lA_PrestRPA_RPNA ) := NULL;
2007: END IF;
2008: hr_utility.trace('tab_employee(lA_PrestRPA_RPNA) = ' ||
2009: tab_employee(lA_PrestRPA_RPNA));
2010:
2011: -- Summ (Box B)
2012: IF TO_NUMBER(l_rl2_box_b) > 9999999.99 THEN

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

2026: l_all_box_0 := FALSE;
2027: ELSE
2028: tab_employee(lB_PrestREER_FERR_RPDB) := NULL;
2029: END IF;
2030: hr_utility.trace('tab_employee(lB_PrestREER_FERR_RPDB) = ' ||
2031: tab_employee(lB_PrestREER_FERR_RPDB));
2032:
2033: -- Summ (Box C)
2034: IF TO_NUMBER(l_rl2_box_c) > 9999999.99 THEN

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

2049: ELSE
2050: tab_employee(lC_AutrePaiement ) := NULL;
2051: END IF;
2052:
2053: hr_utility.trace('tab_employee(lC_AutrePaiement ) = ' ||
2054: tab_employee(lC_AutrePaiement ));
2055:
2056: -- Summ (Box D)
2057: IF TO_NUMBER(l_rl2_box_d) > 9999999.99 THEN

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

2071: l_all_box_0 := FALSE;
2072: ELSE
2073: tab_employee(lD_RembPrimeConjoint) := NULL;
2074: END IF;
2075: hr_utility.trace('tab_employee(lD_RembPrimeConjoint) = ' ||
2076: tab_employee(lD_RembPrimeConjoint));
2077:
2078: -- (Box E)
2079: IF TO_NUMBER(l_rl2_box_e) > 9999999.99 THEN

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

2094: ELSE
2095: tab_employee(lE_PrestDeces) := NULL;
2096: END IF;
2097:
2098: hr_utility.trace('tab_employee(lE_PrestDeces) = ' ||
2099: tab_employee(lE_PrestDeces));
2100:
2101: -- (Box F)
2102: IF TO_NUMBER(l_rl2_box_f) > 9999999.99 THEN

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

2116: l_all_box_0 := FALSE;
2117: ELSE
2118: tab_employee(lF_RembCotisInutilise) := NULL;
2119: END IF;
2120: hr_utility.trace('tab_employee(lF_RembCotisInutilise) = ' ||
2121: tab_employee(lF_RembCotisInutilise));
2122:
2123: -- (Box G)
2124: IF TO_NUMBER(l_rl2_box_g) > 9999999.99 THEN

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

2139: ELSE
2140: tab_employee(lG_RevocationREER_FERR) := NULL;
2141:
2142: END IF;
2143: hr_utility.trace('tab_employee(lG_RevocationREER_FERR) = ' ||
2144: tab_employee(lG_RevocationREER_FERR));
2145:
2146: -- (Box H)
2147: IF TO_NUMBER(l_rl2_box_h) > 9999999.99 THEN

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

2162: ELSE
2163: tab_employee(lH_AutreRevenu) := NULL;
2164: END IF;
2165:
2166: hr_utility.trace('tab_employee(lH_AutreRevenu ) = ' ||
2167: tab_employee(lH_AutreRevenu ));
2168:
2169: -- (Box I)
2170: IF TO_NUMBER(l_rl2_box_i) > 9999999.99 THEN

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

2184: l_all_box_0 := FALSE;
2185: ELSE
2186: tab_employee(lI_DroitDeduction ) := NULL;
2187: END IF;
2188: hr_utility.trace('tab_employee(lI_DroitDeduction ) = ' ||
2189: tab_employee(lI_DroitDeduction ));
2190:
2191: -- (Box J)
2192: IF TO_NUMBER(l_rl2_box_j) > 9999999.99 THEN

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

2206: l_all_box_0 := FALSE;
2207: ELSE
2208: tab_employee(lJ_ImpotQueRetenuSource ) := NULL;
2209: END IF;
2210: hr_utility.trace('tab_employee(lJ_ImpotQueRetenuSource ) = ' ||
2211: tab_employee(lJ_ImpotQueRetenuSource ));
2212:
2213: -- (Box K)
2214: IF TO_NUMBER(l_rl2_box_k) > 9999999.99 THEN

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

2228: l_all_box_0 := FALSE;
2229: ELSE
2230: tab_employee(lK_RevenuApresDeces ) := NULL;
2231: END IF;
2232: hr_utility.trace('tab_employee(lK_RevenuApresDeces ) = ' ||
2233: tab_employee(lK_RevenuApresDeces ));
2234:
2235: -- (Box L)
2236: IF TO_NUMBER(l_rl2_box_l) > 9999999.99 THEN

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

2250: l_all_box_0 := FALSE;
2251: ELSE
2252: tab_employee(lL_RetraitREEP ) := NULL;
2253: END IF;
2254: hr_utility.trace('tab_employee(lL_RetraitREEP ) = ' ||
2255: tab_employee(lL_RetraitREEP ));
2256:
2257: -- (Box M)
2258: IF TO_NUMBER(l_rl2_box_m) > 9999999.99 THEN

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

2272: l_all_box_0 := FALSE;
2273: ELSE
2274: tab_employee(lM_LibereImpot) := NULL;
2275: END IF;
2276: hr_utility.trace('tab_employee(lM_LibereImpot) = ' ||
2277: tab_employee(lM_LibereImpot));
2278:
2279: -- (Box N)
2280: -- Bug 5569097 Fix.

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

2284: l_rl2_box_n || '' || EOL;
2285: ELSE
2286: tab_employee(lN_NASConjoint) := NULL;
2287: END IF;
2288: hr_utility.trace('tab_employee(lN_NASConjoint) = ' ||
2289: tab_employee(lN_NASConjoint));
2290:
2291: -- Summ (Box O)
2292: IF TO_NUMBER(l_rl2_box_o) > 999999999.99 THEN

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

2306: l_all_box_0 := FALSE;
2307: ELSE
2308: tab_employee(lO_RetraitRAP ) := NULL;
2309: END IF;
2310: hr_utility.trace('Value of Box O');
2311: hr_utility.trace('tab_employee(lO_RetraitRAP ) = ' ||
2312: tab_employee(lO_RetraitRAP ));
2313:
2314: -- Negative Balance Exists

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

2307: ELSE
2308: tab_employee(lO_RetraitRAP ) := NULL;
2309: END IF;
2310: hr_utility.trace('Value of Box O');
2311: hr_utility.trace('tab_employee(lO_RetraitRAP ) = ' ||
2312: tab_employee(lO_RetraitRAP ));
2313:
2314: -- Negative Balance Exists
2315: IF l_negative_balance_flag = 'Y' THEN

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

2323: l_msg_code := 'ALL_BOXES_ZERO';
2324: END IF;
2325:
2326: -- (Provenance1)
2327: hr_utility.trace('The checking for Provenance value ');
2328: hr_utility.trace('The value of Archiver Assignment Action Id '||l_arch_action_id);
2329: hr_utility.trace('The Value of Assignment Id '||l_asg_id);
2330:
2331: hr_utility.trace('The value Of Provenenace : '|| l_rl2_source_of_income);

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

2324: END IF;
2325:
2326: -- (Provenance1)
2327: hr_utility.trace('The checking for Provenance value ');
2328: hr_utility.trace('The value of Archiver Assignment Action Id '||l_arch_action_id);
2329: hr_utility.trace('The Value of Assignment Id '||l_asg_id);
2330:
2331: hr_utility.trace('The value Of Provenenace : '|| l_rl2_source_of_income);
2332: IF l_rl2_source_of_income IS NOT NULL THEN

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

2325:
2326: -- (Provenance1)
2327: hr_utility.trace('The checking for Provenance value ');
2328: hr_utility.trace('The value of Archiver Assignment Action Id '||l_arch_action_id);
2329: hr_utility.trace('The Value of Assignment Id '||l_asg_id);
2330:
2331: hr_utility.trace('The value Of Provenenace : '|| l_rl2_source_of_income);
2332: IF l_rl2_source_of_income IS NOT NULL THEN
2333: -- changed to for bug 13083624

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

2327: hr_utility.trace('The checking for Provenance value ');
2328: hr_utility.trace('The value of Archiver Assignment Action Id '||l_arch_action_id);
2329: hr_utility.trace('The Value of Assignment Id '||l_asg_id);
2330:
2331: hr_utility.trace('The value Of Provenenace : '|| l_rl2_source_of_income);
2332: IF l_rl2_source_of_income IS NOT NULL THEN
2333: -- changed to for bug 13083624
2334: /* 14701748 YE12P211I RL2 ELECTRONIC INTERFACE CHANGES FOR 2012 */
2335: IF ( l_rl2_source_of_income = 'AUTRE' ) THEN

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

2340: end if;
2341: ELSE
2342: tab_employee(lProvenance1) := NULL;
2343: END IF;
2344: hr_utility.trace('tab_employee(lProvenance1) = ' ||
2345: tab_employee(lProvenance1));
2346:
2347: /* For bug 8888411 */
2348: OPEN c_rl2_src_income(replace(l_rl2_source_of_income,'AUTRE','OTHER'), l_taxation_year);

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

2458: tab_employee(lErrorDetails)||
2459: '' || EOL || '' || EOL ||
2460: '' ;
2461:
2462: hr_utility.trace('Just before Printing the file details ');
2463: pay_core_files.write_to_magtape_lob(l_final_xml_string);*/
2464: /* Bug 14701748 */
2465: further_info_details:= null;
2466:

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

2656: end loop;
2657: end if;
2658: end if;
2659: /* Bug 14701748 */
2660: hr_utility.trace('Just before Printing the file details ');
2661: pay_core_files.write_to_magtape_lob(l_final_xml_string);
2662: END;
2663: END xml_employee_record;
2664:

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

2713: l_address_begin_tag varchar2(10);
2714: l_address_end_tag varchar2(10);
2715:
2716: BEGIN
2717: hr_utility.trace('XML Employer');
2718: hr_utility.trace('XML Employer');
2719:
2720: SELECT
2721: fnd_global.local_chr(13) || fnd_global.local_chr(10)

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

2714: l_address_end_tag varchar2(10);
2715:
2716: BEGIN
2717: hr_utility.trace('XML Employer');
2718: hr_utility.trace('XML Employer');
2719:
2720: SELECT
2721: fnd_global.local_chr(13) || fnd_global.local_chr(10)
2722: INTO EOL

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

2761:
2762: tab_employer(lAnnee) := '' || l_taxation_year || '' || EOL;
2763: tab_employer(lNbReleves) := '' || 'Running Total' || '' || EOL;
2764:
2765: hr_utility.trace('The Payroll Action Id : '||l_payroll_actid);
2766: hr_utility.trace('The business group id : '||l_business_grpid);
2767: l_quebec_bn := pay_ca_rl2_can_mag.get_employer_item(l_business_grpid,
2768: l_payroll_actid,
2769: 'CAEOY_RL2_QUEBEC_BN');

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

2762: tab_employer(lAnnee) := '' || l_taxation_year || '' || EOL;
2763: tab_employer(lNbReleves) := '' || 'Running Total' || '' || EOL;
2764:
2765: hr_utility.trace('The Payroll Action Id : '||l_payroll_actid);
2766: hr_utility.trace('The business group id : '||l_business_grpid);
2767: l_quebec_bn := pay_ca_rl2_can_mag.get_employer_item(l_business_grpid,
2768: l_payroll_actid,
2769: 'CAEOY_RL2_QUEBEC_BN');
2770: hr_utility.trace('The Quebec Number is '||l_quebec_bn);

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

2766: hr_utility.trace('The business group id : '||l_business_grpid);
2767: l_quebec_bn := pay_ca_rl2_can_mag.get_employer_item(l_business_grpid,
2768: l_payroll_actid,
2769: 'CAEOY_RL2_QUEBEC_BN');
2770: hr_utility.trace('The Quebec Number is '||l_quebec_bn);
2771: tab_employer(lNold) := '' || convert_special_char(substr(l_quebec_bn,1,10)) ||
2772: '' || EOL;
2773: tab_employer(lTypeDossier) := '' || 'RS' ||
2774: '' || EOL;

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

2774: '' || EOL;
2775:
2776: tab_employer(lNoDossier) := '' || convert_special_char(substr(l_quebec_bn,13,4)) ||
2777: '' || EOL;
2778: hr_utility.trace('The Employer File Number : '|| substr(l_quebec_bn,13,4));
2779: l_employer_name := pay_ca_rl2_can_mag.get_employer_item(l_business_grpid,
2780: l_payroll_actid,
2781: 'CAEOY_RL2_EMPLOYER_NAME');
2782:

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

2781: 'CAEOY_RL2_EMPLOYER_NAME');
2782:
2783: tab_employer(lNom1) := '' ||
2784: convert_special_char(substr(l_employer_name,1,30)) || '' || EOL;
2785: hr_utility.trace('tab_employer(lNom) = ' || tab_employer(lNom1));
2786:
2787: -- Address Line 1
2788:
2789: l_address_line := pay_ca_rl2_can_mag.get_employer_item(l_business_grpid,

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

2806: l_address_begin_tag := '';
2807:
2808: tab_employer(lLigne1) := '' ||
2809: convert_special_char(substr(l_address_line,1,30)) || '' || EOL;
2810: hr_utility.trace('tab_employer(lLigne1) = ' || tab_employer(lLigne1));
2811:
2812:
2813: -- Address Line 2
2814: l_address_line := pay_ca_rl2_can_mag.get_employer_item(l_business_grpid,

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

2821: convert_special_char(substr(l_address_line,1,30)) || '' || EOL;
2822: ELSE
2823: tab_employer(lLigne2) := NULL;
2824: END IF;
2825: hr_utility.trace('tab_employer(lLigne2) = ' || tab_employer(lLigne2));
2826:
2827: -- Ville (City)
2828: l_address_line := pay_ca_rl2_can_mag.get_employer_item(l_business_grpid,
2829: l_payroll_actid,

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

2834: convert_special_char(substr(l_address_line,1,30)) || '' || EOL;
2835: ELSE
2836: tab_employer(lVille) := NULL;
2837: END IF;
2838: hr_utility.trace('tab_employer(lVille) = ' || tab_employer(lVille));
2839:
2840: -- Province
2841: l_address_line := pay_ca_rl2_can_mag.get_employer_item(l_business_grpid,
2842: l_payroll_actid,

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

2849: l_address_line),1,20)) || '' || EOL;
2850: ELSE
2851: tab_employer(lProvince) := NULL;
2852: END IF;
2853: hr_utility.trace('tab_employer(lProvince) = ' || tab_employer(lProvince));
2854:
2855: -- Postal Code
2856: l_address_line := pay_ca_rl2_can_mag.get_employer_item(l_business_grpid,
2857: l_payroll_actid,

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

2863: convert_special_char(substr(l_address_line,1,6)) || '' || EOL;
2864: ELSE
2865: tab_employer(lCodePostal) := NULL;
2866: END IF;
2867: hr_utility.trace('tab_employer(lCodePostal) = ' ||
2868: tab_employer(lCodePostal));
2869:
2870: l_address_end_tag := '';
2871:

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

2969: l_chk_digit := 11 - l_modulus;
2970: end if;
2971:
2972: if l_chk_digit <> l_act_chk_number then
2973: hr_utility.set_message(801,'PAY_74156_INCORRECT_QIN_INFO');
2974: hr_utility.set_message_token('PRE_NAME',p_qin_name);
2975: pay_core_utils.push_message(801,'PAY_74156_INCORRECT_QIN_INFO','P');
2976: pay_core_utils.push_token('PRE_NAME',p_qin_name);
2977: hr_utility.raise_error;

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

2970: end if;
2971:
2972: if l_chk_digit <> l_act_chk_number then
2973: hr_utility.set_message(801,'PAY_74156_INCORRECT_QIN_INFO');
2974: hr_utility.set_message_token('PRE_NAME',p_qin_name);
2975: pay_core_utils.push_message(801,'PAY_74156_INCORRECT_QIN_INFO','P');
2976: pay_core_utils.push_token('PRE_NAME',p_qin_name);
2977: hr_utility.raise_error;
2978: end if;

Line 2977: hr_utility.raise_error;

2973: hr_utility.set_message(801,'PAY_74156_INCORRECT_QIN_INFO');
2974: hr_utility.set_message_token('PRE_NAME',p_qin_name);
2975: pay_core_utils.push_message(801,'PAY_74156_INCORRECT_QIN_INFO','P');
2976: pay_core_utils.push_token('PRE_NAME',p_qin_name);
2977: hr_utility.raise_error;
2978: end if;
2979: else
2980:
2981: hr_utility.set_message(801,'PAY_74156_INCORRECT_QIN_INFO');

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

2977: hr_utility.raise_error;
2978: end if;
2979: else
2980:
2981: hr_utility.set_message(801,'PAY_74156_INCORRECT_QIN_INFO');
2982: hr_utility.set_message_token('PRE_NAME',p_qin_name);
2983: pay_core_utils.push_message(801,'PAY_74156_INCORRECT_QIN_INFO','P');
2984: pay_core_utils.push_token('PRE_NAME',p_qin_name);
2985: hr_utility.raise_error;

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

2978: end if;
2979: else
2980:
2981: hr_utility.set_message(801,'PAY_74156_INCORRECT_QIN_INFO');
2982: hr_utility.set_message_token('PRE_NAME',p_qin_name);
2983: pay_core_utils.push_message(801,'PAY_74156_INCORRECT_QIN_INFO','P');
2984: pay_core_utils.push_token('PRE_NAME',p_qin_name);
2985: hr_utility.raise_error;
2986:

Line 2985: hr_utility.raise_error;

2981: hr_utility.set_message(801,'PAY_74156_INCORRECT_QIN_INFO');
2982: hr_utility.set_message_token('PRE_NAME',p_qin_name);
2983: pay_core_utils.push_message(801,'PAY_74156_INCORRECT_QIN_INFO','P');
2984: pay_core_utils.push_token('PRE_NAME',p_qin_name);
2985: hr_utility.raise_error;
2986:
2987: end if;
2988:
2989: return l_chk_digit;