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 42: hr_utility.trace('Closing temp_lob' );

38: text_size,
39: raw_data);
40:
41: IF dbms_lob.ISOPEN(temp_blob)=1 THEN
42: hr_utility.trace('Closing temp_lob' );
43: dbms_lob.close(temp_blob);
44: hr_utility.trace('Closed temp_lob' );
45: END IF;
46:

Line 44: hr_utility.trace('Closed temp_lob' );

40:
41: IF dbms_lob.ISOPEN(temp_blob)=1 THEN
42: hr_utility.trace('Closing temp_lob' );
43: dbms_lob.close(temp_blob);
44: hr_utility.trace('Closed temp_lob' );
45: END IF;
46:
47: return temp_blob;
48: END;

Line 70: hr_utility.trace('i '||i);

66: begin
67: for rec in c_further_codes(p_assg_actid)
68: loop
69: i:=i+1;
70: hr_utility.trace('i '||i);
71: hr_utility.trace('rec.code '||rec.code);
72: hr_utility.trace('rec.value '||rec.value);
73: g_further_info_list(i).code := rec.code;
74: g_further_info_list(i).amount := rec.value;

Line 71: hr_utility.trace('rec.code '||rec.code);

67: for rec in c_further_codes(p_assg_actid)
68: loop
69: i:=i+1;
70: hr_utility.trace('i '||i);
71: hr_utility.trace('rec.code '||rec.code);
72: hr_utility.trace('rec.value '||rec.value);
73: g_further_info_list(i).code := rec.code;
74: g_further_info_list(i).amount := rec.value;
75: end loop;

Line 72: hr_utility.trace('rec.value '||rec.value);

68: loop
69: i:=i+1;
70: hr_utility.trace('i '||i);
71: hr_utility.trace('rec.code '||rec.code);
72: hr_utility.trace('rec.value '||rec.value);
73: g_further_info_list(i).code := rec.code;
74: g_further_info_list(i).amount := rec.value;
75: end loop;
76: end store_further_information;

Line 84: hr_utility.trace('p_index '||p_index);

80: p_amount in out nocopy varchar2)
81: is
82: begin
83:
84: hr_utility.trace('p_index '||p_index);
85: if g_further_info_list.exists(p_index) then
86: p_code := g_further_info_list(p_index).code;
87: p_amount := g_further_info_list(p_index).amount;
88: else

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

100: p_business_group_id IN OUT NOCOPY NUMBER,
101: p_legislative_param IN OUT NOCOPY VARCHAR2
102: ) IS
103: BEGIN
104: --hr_utility.trace_on('Y','RL2MAG');
105: hr_utility.set_location('pay_ca_rl2_mag.get_report_parameters', 10);
106:
107: SELECT ppa.start_date,
108: ppa.effective_date,

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

101: p_legislative_param IN OUT NOCOPY VARCHAR2
102: ) IS
103: BEGIN
104: --hr_utility.trace_on('Y','RL2MAG');
105: hr_utility.set_location('pay_ca_rl2_mag.get_report_parameters', 10);
106:
107: SELECT ppa.start_date,
108: ppa.effective_date,
109: ppa.business_group_id,

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

116: p_legislative_param
117: FROM pay_payroll_actions ppa
118: WHERE payroll_action_id = p_pactid;
119:
120: hr_utility.set_location('pay_ca_rl2_mag.get_report_parameters', 20);
121:
122: END get_report_parameters;
123:
124: ---------------------------------------------------------------------------

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

180:
181: l_transmitter_org_id := pay_ca_rl2_mag.get_parameter('TRANSMITTER_PRE',
182: l_legislative_parameters);
183:
184: hr_utility.trace('l_transmitter_org_id = ' || to_char(l_transmitter_org_id));
185: hr_utility.trace('p_bg_id = ' || to_char(p_bg_id));
186: hr_utility.trace('p_payroll_action_id = ' || to_char(p_payroll_action_id));
187: hr_utility.trace('p_effective_date = ' || to_char(p_effective_date));
188:

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

181: l_transmitter_org_id := pay_ca_rl2_mag.get_parameter('TRANSMITTER_PRE',
182: l_legislative_parameters);
183:
184: hr_utility.trace('l_transmitter_org_id = ' || to_char(l_transmitter_org_id));
185: hr_utility.trace('p_bg_id = ' || to_char(p_bg_id));
186: hr_utility.trace('p_payroll_action_id = ' || to_char(p_payroll_action_id));
187: hr_utility.trace('p_effective_date = ' || to_char(p_effective_date));
188:
189: OPEN cur_arch_pactid(l_transmitter_org_id);

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

182: l_legislative_parameters);
183:
184: hr_utility.trace('l_transmitter_org_id = ' || to_char(l_transmitter_org_id));
185: hr_utility.trace('p_bg_id = ' || to_char(p_bg_id));
186: hr_utility.trace('p_payroll_action_id = ' || to_char(p_payroll_action_id));
187: hr_utility.trace('p_effective_date = ' || to_char(p_effective_date));
188:
189: OPEN cur_arch_pactid(l_transmitter_org_id);
190: FETCH cur_arch_pactid

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

183:
184: hr_utility.trace('l_transmitter_org_id = ' || to_char(l_transmitter_org_id));
185: hr_utility.trace('p_bg_id = ' || to_char(p_bg_id));
186: hr_utility.trace('p_payroll_action_id = ' || to_char(p_payroll_action_id));
187: hr_utility.trace('p_effective_date = ' || to_char(p_effective_date));
188:
189: OPEN cur_arch_pactid(l_transmitter_org_id);
190: FETCH cur_arch_pactid
191: INTO l_arch_pactid;

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

198: l_arch_pactid,
199: 'CAEOY_RL2_TRANSMITTER_NAME');
200: BEGIN
201:
202: hr_utility.trace('l_transmitter_number = ' || l_transmitter_number);
203: SELECT substr(l_transmitter_number,1,2)
204: INTO dummy1
205: FROM dual;
206:

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

214: FROM dual;
215:
216: EXCEPTION
217: WHEN INVALID_NUMBER THEN
218: hr_utility.set_message(800,'PAY_CA_RL1_INVALID_TRANSMITTER');
219: hr_utility.set_message_token('PRE_NAME',l_transmitter_name);
220: pay_core_utils.push_message(800,'PAY_CA_RL1_INVALID_TRANSMITTER','P');
221: pay_core_utils.push_token('PRE_NAME',l_transmitter_name);
222: hr_utility.raise_error;

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

215:
216: EXCEPTION
217: WHEN INVALID_NUMBER THEN
218: hr_utility.set_message(800,'PAY_CA_RL1_INVALID_TRANSMITTER');
219: hr_utility.set_message_token('PRE_NAME',l_transmitter_name);
220: pay_core_utils.push_message(800,'PAY_CA_RL1_INVALID_TRANSMITTER','P');
221: pay_core_utils.push_token('PRE_NAME',l_transmitter_name);
222: hr_utility.raise_error;
223: END;

Line 222: hr_utility.raise_error;

218: hr_utility.set_message(800,'PAY_CA_RL1_INVALID_TRANSMITTER');
219: hr_utility.set_message_token('PRE_NAME',l_transmitter_name);
220: pay_core_utils.push_message(800,'PAY_CA_RL1_INVALID_TRANSMITTER','P');
221: pay_core_utils.push_token('PRE_NAME',l_transmitter_name);
222: hr_utility.raise_error;
223: END;
224:
225: l_type_of_package := pay_ca_rl2_mag.get_transmitter_item(p_bg_id,
226: l_arch_pactid,

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

225: l_type_of_package := pay_ca_rl2_mag.get_transmitter_item(p_bg_id,
226: l_arch_pactid,
227: 'CAEOY_RL2_TRANSMITTER_PACKAGE_TYPE');
228:
229: hr_utility.trace('l_type_of_package = ' || l_type_of_package);
230:
231: IF l_type_of_package IS NULL THEN
232: pay_core_utils.push_message(800,'PAY_CA_RL1_MISSING_TYPE_OF_PKG','P');
233: hr_utility.raise_error;

Line 233: hr_utility.raise_error;

229: hr_utility.trace('l_type_of_package = ' || l_type_of_package);
230:
231: IF l_type_of_package IS NULL THEN
232: pay_core_utils.push_message(800,'PAY_CA_RL1_MISSING_TYPE_OF_PKG','P');
233: hr_utility.raise_error;
234: END IF;
235:
236: l_source_of_slips := pay_ca_rl2_mag.get_transmitter_item(p_bg_id,
237: l_arch_pactid,

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

235:
236: l_source_of_slips := pay_ca_rl2_mag.get_transmitter_item(p_bg_id,
237: l_arch_pactid,
238: 'CAEOY_RL2_SOURCE_OF_SLIPS');
239: hr_utility.trace('l_source_of_slips = ' || l_source_of_slips);
240:
241: IF l_source_of_slips IS NULL THEN
242: pay_core_utils.push_message(800,'PAY_CA_RL1_MISSING_RLSLIP_SRC','P');
243: hr_utility.raise_error;

Line 243: hr_utility.raise_error;

239: hr_utility.trace('l_source_of_slips = ' || l_source_of_slips);
240:
241: IF l_source_of_slips IS NULL THEN
242: pay_core_utils.push_message(800,'PAY_CA_RL1_MISSING_RLSLIP_SRC','P');
243: hr_utility.raise_error;
244: END IF;
245:
246: l_address_line1 := pay_ca_rl2_mag.get_transmitter_item(p_bg_id,
247: l_arch_pactid,

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

245:
246: l_address_line1 := pay_ca_rl2_mag.get_transmitter_item(p_bg_id,
247: l_arch_pactid,
248: 'CAEOY_RL2_TRANSMITTER_ADDRESS_LINE1');
249: hr_utility.trace('l_address_line1 = ' || l_address_line1);
250:
251: IF l_address_line1 IS NULL THEN
252: pay_core_utils.push_message(800,'PAY_CA_RL1_MISSING_TRNMTR_ADDR','P');
253: hr_utility.raise_error;

Line 253: hr_utility.raise_error;

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

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

281: p_legislative_param pay_payroll_actions.legislative_parameters%type;
282:
283: BEGIN
284:
285: hr_utility.set_location( 'pay_ca_rl2_mag.range_cursor', 10);
286:
287: get_report_parameters(
288: p_pactid,
289: p_year_start,

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

292: p_business_group_id,
293: p_legislative_param
294: );
295:
296: hr_utility.set_location( 'pay_ca_rl2_mag.range_cursor', 20);
297:
298: p_sqlstr := 'select /*+ leading(ppa_mag,ppa_arch,paa_arch)
299: index(emp.paa_arch,PAY_ASSIGNMENT_ACTIONS_PK)
300: use_hash(emp.ppa_arch,hoi,tran.ppa_arch)

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

324: and to_char(hoi.organization_id) =
325: pycadar_pkg.get_parameter(''PRE_ORGANIZATION_ID'',ppa_arch.legislative_parameters)
326: order by to_number(emp.person_id)' ;
327:
328: hr_utility.set_location( 'pay_ca_rl2_mag.range_cursor',30);
329:
330: END range_cursor;
331:
332: -------------------------------------------------------------------------------

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

410: l_legislative_param pay_payroll_actions.legislative_parameters%type;
411:
412: BEGIN
413:
414: -- hr_utility.trace_on(NULL,'RL2MAG');
415: -- Get the report parameters. These define the report being run.
416: l_prev_payact := -1;
417: hr_utility.set_location( 'pay_ca_rl2_mag.create_assignment_act',10);
418:

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

413:
414: -- hr_utility.trace_on(NULL,'RL2MAG');
415: -- Get the report parameters. These define the report being run.
416: l_prev_payact := -1;
417: hr_utility.set_location( 'pay_ca_rl2_mag.create_assignment_act',10);
418:
419: get_report_parameters(
420: p_pactid,
421: l_year_start,

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

430: l_year_end);
431:
432: --Open the appropriate cursor
433:
434: hr_utility.set_location( 'pay_ca_rl2_mag.create_assignment_act',20);
435: hr_utility.trace('Report type '||l_report_type);
436: IF l_report_type = 'RL2_XML_MAG' THEN
437: OPEN c_all_asg(l_legislative_param,
438: l_business_group_id,

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

431:
432: --Open the appropriate cursor
433:
434: hr_utility.set_location( 'pay_ca_rl2_mag.create_assignment_act',20);
435: hr_utility.trace('Report type '||l_report_type);
436: IF l_report_type = 'RL2_XML_MAG' THEN
437: OPEN c_all_asg(l_legislative_param,
438: l_business_group_id,
439: l_year_end);

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

444: l_effective_end_date,
445: l_assignment_action_id,
446: l_payroll_act;
447:
448: hr_utility.set_location('pay_ca_rl2_mag.create_assignment_act', 30);
449:
450: EXIT WHEN c_all_asg%NOTFOUND;
451:
452: --Create the assignment action for the record

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

453:
454: /* Validating QIN Number information */
455: if l_prev_payact <> l_payroll_act then
456:
457: hr_utility.trace('The payroll action id '||l_payroll_act);
458:
459: l_prev_payact := l_payroll_act;
460: l_emplyer_name := pay_ca_rl2_mag.get_employer_item(l_business_group_id,
461: l_payroll_act,

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

463:
464: l_quebec_no := pay_ca_rl2_mag.get_employer_item(l_business_group_id,
465: l_payroll_act,
466: 'CAEOY_RL2_QUEBEC_BN');
467: hr_utility.trace('The Quebec Number is '||l_quebec_no);
468: l_file_no := substr(l_quebec_no,13,4);
469: l_quebec_no := substr(l_quebec_no ,1,10);
470:
471: /* Fix for Bug# 4038551 */

Line 477: hr_utility.raise_error;

473: length(l_file_no) < 4
474: then
475: pay_core_utils.push_message(801,'PAY_74156_INCORRECT_QIN_INFO','P');
476: pay_core_utils.push_token('PRE_NAME',l_emplyer_name);
477: hr_utility.raise_error;
478: end if;
479:
480:
481: /* Erroring out the RL2 Electronic Interface if any of the

Line 490: hr_utility.raise_error;

486: 'CAEOY_RL2_EMPLOYER_ADDRESS_LINE1');
487: if l_addr_line = ' '
488: then
489: pay_core_utils.push_message(800,'PAY_CA_RL2_MISSING_ADDRESS','P');
490: hr_utility.raise_error;
491: end if;
492: hr_utility.trace('First 10 digits of the QIN: '||l_quebec_no);
493: l_return := validate_quebec_number(l_quebec_no,l_emplyer_name);
494:

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

488: then
489: pay_core_utils.push_message(800,'PAY_CA_RL2_MISSING_ADDRESS','P');
490: hr_utility.raise_error;
491: end if;
492: hr_utility.trace('First 10 digits of the QIN: '||l_quebec_no);
493: l_return := validate_quebec_number(l_quebec_no,l_emplyer_name);
494:
495: end if ;
496: hr_utility.trace('Assignment Fetched - ');

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

492: hr_utility.trace('First 10 digits of the QIN: '||l_quebec_no);
493: l_return := validate_quebec_number(l_quebec_no,l_emplyer_name);
494:
495: end if ;
496: hr_utility.trace('Assignment Fetched - ');
497: hr_utility.trace('Assignment Id : '|| to_char(l_assignment_id));
498: hr_utility.trace('Person Id : '|| to_char(l_person_id));
499: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
500: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date));

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

493: l_return := validate_quebec_number(l_quebec_no,l_emplyer_name);
494:
495: end if ;
496: hr_utility.trace('Assignment Fetched - ');
497: hr_utility.trace('Assignment Id : '|| to_char(l_assignment_id));
498: hr_utility.trace('Person Id : '|| to_char(l_person_id));
499: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
500: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date));
501:

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

494:
495: end if ;
496: hr_utility.trace('Assignment Fetched - ');
497: hr_utility.trace('Assignment Id : '|| to_char(l_assignment_id));
498: hr_utility.trace('Person Id : '|| to_char(l_person_id));
499: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
500: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date));
501:
502: hr_utility.set_location('pay_ca_rl2_mag.create_assignment_act', 40);

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

495: end if ;
496: hr_utility.trace('Assignment Fetched - ');
497: hr_utility.trace('Assignment Id : '|| to_char(l_assignment_id));
498: hr_utility.trace('Person Id : '|| to_char(l_person_id));
499: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
500: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date));
501:
502: hr_utility.set_location('pay_ca_rl2_mag.create_assignment_act', 40);
503:

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

496: hr_utility.trace('Assignment Fetched - ');
497: hr_utility.trace('Assignment Id : '|| to_char(l_assignment_id));
498: hr_utility.trace('Person Id : '|| to_char(l_person_id));
499: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
500: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date));
501:
502: hr_utility.set_location('pay_ca_rl2_mag.create_assignment_act', 40);
503:
504: SELECT pay_assignment_actions_s.nextval

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

498: hr_utility.trace('Person Id : '|| to_char(l_person_id));
499: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
500: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date));
501:
502: hr_utility.set_location('pay_ca_rl2_mag.create_assignment_act', 40);
503:
504: SELECT pay_assignment_actions_s.nextval
505: INTO lockingactid
506: FROM dual;

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

504: SELECT pay_assignment_actions_s.nextval
505: INTO lockingactid
506: FROM dual;
507:
508: hr_utility.set_location('pay_ca_rl2_mag.create_assignment_act', 50);
509: hr_nonrun_asact.insact(lockingactid,
510: l_assignment_id,
511: p_pactid,
512: p_chunk,

Line 518: -- hr_utility.trace('updating asg. action');

514:
515: /* Update the serial number column with the person id
516: */
517:
518: -- hr_utility.trace('updating asg. action');
519:
520: update pay_assignment_actions aa
521: set aa.serial_number = to_char(l_person_id)
522: where aa.assignment_action_id = lockingactid;

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

520: update pay_assignment_actions aa
521: set aa.serial_number = to_char(l_person_id)
522: where aa.assignment_action_id = lockingactid;
523:
524: hr_utility.set_location('pay_ca_rl2_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_mag.create_assignment_act', 70);

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

524: hr_utility.set_location('pay_ca_rl2_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_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:

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_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:
533: END LOOP;

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_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:
533: END LOOP;
534: CLOSE c_all_asg;

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

527:
528: hr_utility.set_location('pay_ca_rl2_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:
533: END LOOP;
534: CLOSE c_all_asg;
535:

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

912: lNoConcepteur NUMBER;
913: l_VersionSchema VARCHAR2(20);
914: BEGIN
915:
916: hr_utility.trace('XML Transmitter');
917:
918:
919: SELECT
920: fnd_global.local_chr(13) || fnd_global.local_chr(10)

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

962: l_legislative_param
963: );
964:
965:
966: hr_utility.trace('XML Transmitter: l_taxation_year = ' || l_taxation_year);
967: hr_utility.trace('XML Transmitter: l_payroll_Action_id = ' || to_char(l_payroll_actid));
968:
969: OPEN c_trans_info(l_business_grpid,
970: l_payroll_actid);

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

963: );
964:
965:
966: hr_utility.trace('XML Transmitter: l_taxation_year = ' || l_taxation_year);
967: hr_utility.trace('XML Transmitter: l_payroll_Action_id = ' || to_char(l_payroll_actid));
968:
969: OPEN c_trans_info(l_business_grpid,
970: l_payroll_actid);
971: FETCH c_trans_info

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

993:
994: CLOSE c_trans_info;
995: -- Annee
996: tab_transmitter(lAnnee) := '' || l_taxation_year || '' ||EOL;
997: hr_utility.trace('tab_transmitter(lAnnee) = ' || tab_transmitter(lAnnee));
998:
999: -- TypeEnvoi
1000: tab_transmitter(lTypeEnvoi) := '' ||
1001: convert_special_char(l_trans_package_type) || '' || EOL;

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

998:
999: -- TypeEnvoi
1000: tab_transmitter(lTypeEnvoi) := '' ||
1001: convert_special_char(l_trans_package_type) || '' || EOL;
1002: hr_utility.trace('tab_transmitter(lTypeEnvoi) = ' ||
1003: tab_transmitter(lTypeEnvoi));
1004:
1005: tab_transmitter(lProvenance) := '' ||
1006: convert_special_char(l_source_of_slips) || '' || EOL;

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

1004:
1005: tab_transmitter(lProvenance) := '' ||
1006: convert_special_char(l_source_of_slips) || '' || EOL;
1007:
1008: hr_utility.trace('tab_transmitter(lProvenance) = ' || tab_transmitter(lProvenance));
1009:
1010: tab_transmitter(lNo) := '' ||
1011: convert_special_char(l_trans_number) || '' || EOL;
1012:

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

1009:
1010: tab_transmitter(lNo) := '' ||
1011: convert_special_char(l_trans_number) || '' || EOL;
1012:
1013: hr_utility.trace('tab_transmitter(lNo) = ' || tab_transmitter(lNo));
1014:
1015:
1016: IF l_trans_type_indicator IS NOT NULL AND
1017: l_trans_type_indicator <> '0' THEN

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

1020: ELSE
1021: tab_transmitter(lType) := NULL;
1022: END IF;
1023:
1024: hr_utility.trace('tab_transmitter(lType) = ' || tab_transmitter(lType));
1025:
1026: tab_transmitter(lNom1) := '' ||
1027: convert_special_char(substr(l_trans_name,1,30)) || '' || EOL;
1028:

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

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

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

1034: ELSE
1035: tab_transmitter(lNom2) := NULL;
1036: END IF;
1037:
1038: hr_utility.trace('tab_transmitter(lNom2) = ' || tab_transmitter(lNom2));
1039:
1040:
1041: tab_transmitter(lLigne1) := '' ||
1042: convert_special_char(substr(l_trans_address_line1,1,30)) || '' || EOL;

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

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

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

1051: ELSE
1052: tab_transmitter(lLigne2) := NULL;
1053: END IF;
1054:
1055: hr_utility.trace('tab_transmitter(lLigne2) = ' || tab_transmitter(lLigne2));
1056:
1057:
1058: IF (l_trans_city IS NOT NULL AND
1059: l_trans_city <> ' ') THEN

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

1062: ELSE
1063: tab_transmitter(lVille) := NULL;
1064: END IF;
1065:
1066: hr_utility.trace('tab_transmitter(lVille) = ' || tab_transmitter(lVille));
1067:
1068: IF (l_trans_province IS NOT NULL AND
1069: l_trans_province <> ' ') THEN
1070: tab_transmitter(lProvince) := '' ||

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

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

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

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

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

1093: ELSE
1094: tab_transmitter(lNom) := NULL;
1095: END IF;
1096:
1097: hr_utility.trace('tab_transmitter(lNom) = ' || tab_transmitter(lNom));
1098:
1099:
1100: IF (l_trans_tech_contact_code IS NOT NULL AND
1101: l_trans_tech_contact_code <> '000' ) THEN

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

1105: ELSE
1106: tab_transmitter(lIndRegional) := NULL;
1107: END IF;
1108:
1109: hr_utility.trace('tab_transmitter(lIndRegional) = ' || tab_transmitter(lIndRegional));
1110:
1111: IF (l_trans_tech_contact_phone IS NOT NULL AND
1112: l_trans_tech_contact_phone <> '0000000' ) THEN
1113: l_Informatique_tag := 'Y';

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

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

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

1126: '' || EOL;
1127: ELSE
1128: tab_transmitter(lPosteTel) := NULL;
1129: END IF;
1130: hr_utility.trace('tab_transmitter(lPosteTel) = ' ||
1131: tab_transmitter(lPosteTel));
1132:
1133:
1134: IF (l_trans_tech_contact_lang IS NOT NULL AND

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

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

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

1158: '' || EOL;
1159: ELSE
1160: tab_transmitter(lAIndRegional) := NULL;
1161: END IF;
1162: hr_utility.trace('tab_transmitter(lAIndRegional) = ' || tab_transmitter(lAIndRegional));
1163:
1164:
1165: IF (l_trans_acct_contact_phone IS NOT NULL AND
1166: l_trans_acct_contact_phone <> '0000000' ) THEN

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

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

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

1180: '' || EOL;
1181: ELSE
1182: tab_transmitter(lAPosteTel) := NULL;
1183: END IF;
1184: hr_utility.trace('tab_transmitter(lAPosteTel) = ' ||
1185: tab_transmitter(lAPosteTel));
1186:
1187: IF (l_trans_acct_contact_lang IS NOT NULL AND
1188: l_trans_acct_contact_lang <> ' ' ) THEN

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

1219: --- End 6736354
1220:
1221: tab_transmitter(lNoConcepteur) := ''||convert_special_char(l_authorization_no)||''||EOL;
1222:
1223: hr_utility.trace('tab_transmitter(lALangue) = ' || tab_transmitter(lALangue));
1224:
1225: IF l_Informatique_tag = 'Y' AND
1226: l_Comptabilite_tag = 'Y' THEN
1227: l_tech_accnt_info := '' || EOL ||

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

1286: l_tech_accnt_info || EOL ||
1287: tab_transmitter(lNoConcepteur) ||
1288: '

' || EOL;
1289:
1290: --hr_utility.trace('l_final_xml_string = ' || l_final_xml_string);
1291:
1292: pay_core_files.write_to_magtape_lob(l_final_xml_string);
1293: END;
1294: END xml_transmitter_record;

Line 1352: --hr_utility.trace_on(null,'Raaji');

1348: AND emp.business_group_id = emp2.business_group_id
1349: AND emp.payroll_action_id = tran.payroll_action_id;
1350:
1351: BEGIN
1352: --hr_utility.trace_on(null,'Raaji');
1353: hr_utility.trace('In get_final_xml 10');
1354: hr_utility.trace('p_arch_action_id '||p_arch_action_id);
1355: hr_utility.trace('p_taxation_year '||p_taxation_year);
1356: hr_utility.trace('p_rep_type '||p_rep_type);

Line 1353: hr_utility.trace('In get_final_xml 10');

1349: AND emp.payroll_action_id = tran.payroll_action_id;
1350:
1351: BEGIN
1352: --hr_utility.trace_on(null,'Raaji');
1353: hr_utility.trace('In get_final_xml 10');
1354: hr_utility.trace('p_arch_action_id '||p_arch_action_id);
1355: hr_utility.trace('p_taxation_year '||p_taxation_year);
1356: hr_utility.trace('p_rep_type '||p_rep_type);
1357:

Line 1354: hr_utility.trace('p_arch_action_id '||p_arch_action_id);

1350:
1351: BEGIN
1352: --hr_utility.trace_on(null,'Raaji');
1353: hr_utility.trace('In get_final_xml 10');
1354: hr_utility.trace('p_arch_action_id '||p_arch_action_id);
1355: hr_utility.trace('p_taxation_year '||p_taxation_year);
1356: hr_utility.trace('p_rep_type '||p_rep_type);
1357:
1358: EOL := fnd_global.local_chr(13) || fnd_global.local_chr(10);

Line 1355: hr_utility.trace('p_taxation_year '||p_taxation_year);

1351: BEGIN
1352: --hr_utility.trace_on(null,'Raaji');
1353: hr_utility.trace('In get_final_xml 10');
1354: hr_utility.trace('p_arch_action_id '||p_arch_action_id);
1355: hr_utility.trace('p_taxation_year '||p_taxation_year);
1356: hr_utility.trace('p_rep_type '||p_rep_type);
1357:
1358: EOL := fnd_global.local_chr(13) || fnd_global.local_chr(10);
1359: hr_utility.trace('In get_final_xml 20');

Line 1356: hr_utility.trace('p_rep_type '||p_rep_type);

1352: --hr_utility.trace_on(null,'Raaji');
1353: hr_utility.trace('In get_final_xml 10');
1354: hr_utility.trace('p_arch_action_id '||p_arch_action_id);
1355: hr_utility.trace('p_taxation_year '||p_taxation_year);
1356: hr_utility.trace('p_rep_type '||p_rep_type);
1357:
1358: EOL := fnd_global.local_chr(13) || fnd_global.local_chr(10);
1359: hr_utility.trace('In get_final_xml 20');
1360:

Line 1359: hr_utility.trace('In get_final_xml 20');

1355: hr_utility.trace('p_taxation_year '||p_taxation_year);
1356: hr_utility.trace('p_rep_type '||p_rep_type);
1357:
1358: EOL := fnd_global.local_chr(13) || fnd_global.local_chr(10);
1359: hr_utility.trace('In get_final_xml 20');
1360:
1361: open c_payroll_asgid(p_arch_action_id);
1362: fetch c_payroll_asgid into l_arch_pay_actid,l_asg_id;
1363: close c_payroll_asgid;

Line 1385: hr_utility.trace('dbms_lob.getlength(p_xml_blob) ' ||dbms_lob.getlength(p_xml_blob));

1381: 'Y',
1382: 'get_final_xml',
1383: p_xml_blob);
1384:
1385: hr_utility.trace('dbms_lob.getlength(p_xml_blob) ' ||dbms_lob.getlength(p_xml_blob));
1386: hr_utility.trace('1. final 1. XML l_final_xml '||
1387: dbms_lob.substr(l_final_xml,dbms_lob.getlength(l_final_xml),1));
1388: hr_utility.trace('In get_final_xml 30');
1389:

Line 1386: hr_utility.trace('1. final 1. XML l_final_xml '||

1382: 'get_final_xml',
1383: p_xml_blob);
1384:
1385: hr_utility.trace('dbms_lob.getlength(p_xml_blob) ' ||dbms_lob.getlength(p_xml_blob));
1386: hr_utility.trace('1. final 1. XML l_final_xml '||
1387: dbms_lob.substr(l_final_xml,dbms_lob.getlength(l_final_xml),1));
1388: hr_utility.trace('In get_final_xml 30');
1389:
1390: l_is_temp_final_xml := dbms_lob.istemporary(l_final_xml);

Line 1388: hr_utility.trace('In get_final_xml 30');

1384:
1385: hr_utility.trace('dbms_lob.getlength(p_xml_blob) ' ||dbms_lob.getlength(p_xml_blob));
1386: hr_utility.trace('1. final 1. XML l_final_xml '||
1387: dbms_lob.substr(l_final_xml,dbms_lob.getlength(l_final_xml),1));
1388: hr_utility.trace('In get_final_xml 30');
1389:
1390: l_is_temp_final_xml := dbms_lob.istemporary(l_final_xml);
1391: hr_utility.trace('Istemporary(l_xml_string) ' ||l_is_temp_final_xml );
1392:

Line 1391: hr_utility.trace('Istemporary(l_xml_string) ' ||l_is_temp_final_xml );

1387: dbms_lob.substr(l_final_xml,dbms_lob.getlength(l_final_xml),1));
1388: hr_utility.trace('In get_final_xml 30');
1389:
1390: l_is_temp_final_xml := dbms_lob.istemporary(l_final_xml);
1391: hr_utility.trace('Istemporary(l_xml_string) ' ||l_is_temp_final_xml );
1392:
1393: IF l_is_temp_final_xml = 1 THEN
1394: DBMS_LOB.FREETEMPORARY(l_final_xml);
1395: END IF;

Line 1401: hr_utility.trace('In get_final_xml 40');

1397: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);
1398: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);
1399: l_final_xml := append_to_lob(l_header_xml_string);
1400: dbms_lob.append(l_final_xml,p_xml_blob);
1401: hr_utility.trace('In get_final_xml 40');
1402:
1403: l_trailer_xml := ''||EOL;
1404:
1405: hr_utility.trace('In get_final_xml 50');

Line 1405: hr_utility.trace('In get_final_xml 50');

1401: hr_utility.trace('In get_final_xml 40');
1402:
1403: l_trailer_xml := ''||EOL;
1404:
1405: hr_utility.trace('In get_final_xml 50');
1406: dbms_lob.createtemporary(l_temp_blob,false,DBMS_LOB.CALL);
1407: dbms_lob.open(l_temp_blob,dbms_lob.lob_readwrite);
1408: l_temp_blob := append_to_lob(l_trailer_xml);
1409: dbms_lob.append(l_final_xml,l_temp_blob);

Line 1412: hr_utility.trace('Closing l_final_xml' );

1408: l_temp_blob := append_to_lob(l_trailer_xml);
1409: dbms_lob.append(l_final_xml,l_temp_blob);
1410:
1411: IF DBMS_LOB.isopen(l_final_xml) = 1 THEN
1412: hr_utility.trace('Closing l_final_xml' );
1413: dbms_lob.close(l_final_xml);
1414: END IF;
1415: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
1416: hr_utility.trace('Closing p_xml_blob' );

Line 1416: hr_utility.trace('Closing p_xml_blob' );

1412: hr_utility.trace('Closing l_final_xml' );
1413: dbms_lob.close(l_final_xml);
1414: END IF;
1415: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
1416: hr_utility.trace('Closing p_xml_blob' );
1417: dbms_lob.close(p_xml_blob);
1418: END IF;
1419: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN
1420: hr_utility.trace('Closing l_temp_blob' );

Line 1420: hr_utility.trace('Closing l_temp_blob' );

1416: hr_utility.trace('Closing p_xml_blob' );
1417: dbms_lob.close(p_xml_blob);
1418: END IF;
1419: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN
1420: hr_utility.trace('Closing l_temp_blob' );
1421: dbms_lob.close(l_temp_blob);
1422: END IF;
1423: hr_utility.trace('In get_final_xml 60');
1424: else

Line 1423: hr_utility.trace('In get_final_xml 60');

1419: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN
1420: hr_utility.trace('Closing l_temp_blob' );
1421: dbms_lob.close(l_temp_blob);
1422: END IF;
1423: hr_utility.trace('In get_final_xml 60');
1424: else
1425: hr_utility.trace('Negative employee');
1426: OPEN cur_get_meaning('NEG');
1427: FETCH cur_get_meaning

Line 1425: hr_utility.trace('Negative employee');

1421: dbms_lob.close(l_temp_blob);
1422: END IF;
1423: hr_utility.trace('In get_final_xml 60');
1424: else
1425: hr_utility.trace('Negative employee');
1426: OPEN cur_get_meaning('NEG');
1427: FETCH cur_get_meaning
1428: INTO l_err_msg;
1429: CLOSE cur_get_meaning;

Line 1433: hr_utility.trace('Istemporary(l_xml_string) ' ||l_is_temp_final_xml );

1429: CLOSE cur_get_meaning;
1430:
1431: l_err_msg := 'Error:'||l_err_msg;
1432: l_is_temp_final_xml := dbms_lob.istemporary(l_final_xml);
1433: hr_utility.trace('Istemporary(l_xml_string) ' ||l_is_temp_final_xml );
1434:
1435: IF l_is_temp_final_xml = 1 THEN
1436: DBMS_LOB.FREETEMPORARY(l_final_xml);
1437: END IF;

Line 1442: hr_utility.trace('In get_final_xml 61');

1438:
1439: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);
1440: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);
1441: l_final_xml := append_to_lob(l_err_msg);
1442: hr_utility.trace('In get_final_xml 61');
1443: IF DBMS_LOB.isopen(l_final_xml) = 1 THEN
1444: hr_utility.trace('Closing l_final_xml' );
1445: dbms_lob.close(l_final_xml);
1446: END IF;

Line 1444: hr_utility.trace('Closing l_final_xml' );

1440: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);
1441: l_final_xml := append_to_lob(l_err_msg);
1442: hr_utility.trace('In get_final_xml 61');
1443: IF DBMS_LOB.isopen(l_final_xml) = 1 THEN
1444: hr_utility.trace('Closing l_final_xml' );
1445: dbms_lob.close(l_final_xml);
1446: END IF;
1447: hr_utility.trace('In get_final_xml 62');
1448: end if;

Line 1447: hr_utility.trace('In get_final_xml 62');

1443: IF DBMS_LOB.isopen(l_final_xml) = 1 THEN
1444: hr_utility.trace('Closing l_final_xml' );
1445: dbms_lob.close(l_final_xml);
1446: END IF;
1447: hr_utility.trace('In get_final_xml 62');
1448: end if;
1449: hr_utility.trace('In get_final_xml 65');
1450: --hr_utility.trace_off();
1451: return l_final_xml;

Line 1449: hr_utility.trace('In get_final_xml 65');

1445: dbms_lob.close(l_final_xml);
1446: END IF;
1447: hr_utility.trace('In get_final_xml 62');
1448: end if;
1449: hr_utility.trace('In get_final_xml 65');
1450: --hr_utility.trace_off();
1451: return l_final_xml;
1452:
1453: exception

Line 1450: --hr_utility.trace_off();

1446: END IF;
1447: hr_utility.trace('In get_final_xml 62');
1448: end if;
1449: hr_utility.trace('In get_final_xml 65');
1450: --hr_utility.trace_off();
1451: return l_final_xml;
1452:
1453: exception
1454: when others then

Line 1455: hr_utility.trace('In get_final_xml 70');

1451: return l_final_xml;
1452:
1453: exception
1454: when others then
1455: hr_utility.trace('In get_final_xml 70');
1456:
1457: IF dbms_lob.ISOPEN(l_final_xml)=1 THEN
1458: hr_utility.trace('Raising exception and Closing l_final_xml' );
1459: dbms_lob.close(l_final_xml);

Line 1458: hr_utility.trace('Raising exception and Closing l_final_xml' );

1454: when others then
1455: hr_utility.trace('In get_final_xml 70');
1456:
1457: IF dbms_lob.ISOPEN(l_final_xml)=1 THEN
1458: hr_utility.trace('Raising exception and Closing l_final_xml' );
1459: dbms_lob.close(l_final_xml);
1460: END IF;
1461: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
1462: hr_utility.trace('Raising exception and Closing p_xml_string' );

Line 1462: hr_utility.trace('Raising exception and Closing p_xml_string' );

1458: hr_utility.trace('Raising exception and Closing l_final_xml' );
1459: dbms_lob.close(l_final_xml);
1460: END IF;
1461: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
1462: hr_utility.trace('Raising exception and Closing p_xml_string' );
1463: dbms_lob.close(p_xml_blob);
1464: END IF;
1465: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN
1466: hr_utility.trace('Closing l_temp_blob' );

Line 1466: hr_utility.trace('Closing l_temp_blob' );

1462: hr_utility.trace('Raising exception and Closing p_xml_string' );
1463: dbms_lob.close(p_xml_blob);
1464: END IF;
1465: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN
1466: hr_utility.trace('Closing l_temp_blob' );
1467: dbms_lob.close(l_temp_blob);
1468: END IF;
1469: hr_utility.trace('sqleerm ' || SQLERRM);
1470: raise;

Line 1469: hr_utility.trace('sqleerm ' || SQLERRM);

1465: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN
1466: hr_utility.trace('Closing l_temp_blob' );
1467: dbms_lob.close(l_temp_blob);
1468: END IF;
1469: hr_utility.trace('sqleerm ' || SQLERRM);
1470: raise;
1471: END get_final_xml;
1472:
1473:

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

1561: l_rl2pap_pay_actid,
1562: l_asg_id;
1563: close c_get_payroll_asg_actid;
1564:
1565: hr_utility.trace('The value of Payroll action id is '||l_rl2pap_pay_actid);
1566: hr_utility.trace('The value of Assignment action id is '||l_rl2pap_asg_actid);
1567: hr_utility.trace('The value of Assignment id is '||l_asg_id);
1568: end if;
1569:

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

1562: l_asg_id;
1563: close c_get_payroll_asg_actid;
1564:
1565: hr_utility.trace('The value of Payroll action id is '||l_rl2pap_pay_actid);
1566: hr_utility.trace('The value of Assignment action id is '||l_rl2pap_asg_actid);
1567: hr_utility.trace('The value of Assignment id is '||l_asg_id);
1568: end if;
1569:
1570: IF l_rep_type NOT IN ('RL2PAPERPDF','PAYCARL2AMPDF','PAYCARL2CLPDF') THEN

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

1563: close c_get_payroll_asg_actid;
1564:
1565: hr_utility.trace('The value of Payroll action id is '||l_rl2pap_pay_actid);
1566: hr_utility.trace('The value of Assignment action id is '||l_rl2pap_asg_actid);
1567: hr_utility.trace('The value of Assignment id is '||l_asg_id);
1568: end if;
1569:
1570: IF l_rep_type NOT IN ('RL2PAPERPDF','PAYCARL2AMPDF','PAYCARL2CLPDF') THEN
1571: OPEN cur_parameters(l_mag_asg_action_id);

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

1578: ELSE
1579: l_arch_action_id := l_rl2pap_asg_actid;
1580: END IF;
1581:
1582: hr_utility.trace('XML Employee: l_arch_action_id = '
1583: || to_char(l_arch_action_id));
1584: hr_utility.trace('XML Employee: l_asg_id = ' || to_char(l_asg_id));
1585: hr_utility.trace('XML Employee: l_date_earned = '
1586: || to_char(l_date_earned));

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

1580: END IF;
1581:
1582: hr_utility.trace('XML Employee: l_arch_action_id = '
1583: || to_char(l_arch_action_id));
1584: hr_utility.trace('XML Employee: l_asg_id = ' || to_char(l_asg_id));
1585: hr_utility.trace('XML Employee: l_date_earned = '
1586: || to_char(l_date_earned));
1587:
1588: if l_rep_type = 'RL2PAPERPDF' or l_rep_type='PAYCARL2AMPDF' or l_rep_type='PAYCARL2CLPDF'

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

1581:
1582: hr_utility.trace('XML Employee: l_arch_action_id = '
1583: || to_char(l_arch_action_id));
1584: hr_utility.trace('XML Employee: l_asg_id = ' || to_char(l_asg_id));
1585: hr_utility.trace('XML Employee: l_date_earned = '
1586: || to_char(l_date_earned));
1587:
1588: if l_rep_type = 'RL2PAPERPDF' or l_rep_type='PAYCARL2AMPDF' or l_rep_type='PAYCARL2CLPDF'
1589: then

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

2011: '','','','','','','');
2012: num_further_info number:=0; --ends bug 13545861
2013:
2014: BEGIN
2015: --hr_utility.trace_on(null,'SATIRL2XML');
2016: hr_utility.trace('XML Employee');
2017: l_status := 'Success';
2018: l_all_box_0 := TRUE;
2019: l_count := 0;

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

2012: num_further_info number:=0; --ends bug 13545861
2013:
2014: BEGIN
2015: --hr_utility.trace_on(null,'SATIRL2XML');
2016: hr_utility.trace('XML Employee');
2017: l_status := 'Success';
2018: l_all_box_0 := TRUE;
2019: l_count := 0;
2020: l_format_mask := '99999999999999990.99';

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

2090: INTO l_rl2pap_pay_actid,
2091: l_business_group_id;
2092: CLOSE c_get_payroll_asg_actid;
2093:
2094: hr_utility.trace('The value of Payroll action id is '||l_rl2pap_pay_actid);
2095: hr_utility.trace('The value of l_business_group_id is '||l_business_group_id);
2096:
2097: OPEN c_get_employer_info(l_rl2pap_pay_actid,l_business_group_id);
2098: FETCH c_get_employer_info

Line 2095: hr_utility.trace('The value of l_business_group_id is '||l_business_group_id);

2091: l_business_group_id;
2092: CLOSE c_get_payroll_asg_actid;
2093:
2094: hr_utility.trace('The value of Payroll action id is '||l_rl2pap_pay_actid);
2095: hr_utility.trace('The value of l_business_group_id is '||l_business_group_id);
2096:
2097: OPEN c_get_employer_info(l_rl2pap_pay_actid,l_business_group_id);
2098: FETCH c_get_employer_info
2099: INTO l_empr_name ,

Line 2263: hr_utility.trace('XML Employee: p_arch_action_id = '

2259: END IF;
2260:
2261: end if;
2262:
2263: hr_utility.trace('XML Employee: p_arch_action_id = '
2264: || to_char(p_arch_action_id));
2265: hr_utility.trace('XML Employee: p_asg_id = ' || to_char(p_asg_id));
2266:
2267: --Annee

Line 2265: hr_utility.trace('XML Employee: p_asg_id = ' || to_char(p_asg_id));

2261: end if;
2262:
2263: hr_utility.trace('XML Employee: p_arch_action_id = '
2264: || to_char(p_arch_action_id));
2265: hr_utility.trace('XML Employee: p_asg_id = ' || to_char(p_asg_id));
2266:
2267: --Annee
2268: tab_employee(lAnnee) := '' || p_taxation_year || '' || EOL;
2269: if p_rep_type = 'RL2PAPERPDF' or p_rep_type='PAYCARL2AMPDF' or p_rep_type='PAYCARL2CLPDF'

Line 2413: hr_utility.trace('l_empr_report_yr '||l_empr_report_yr);

2409: l_reporting_year,
2410: 'XMLPROC');
2411: l_first_seq_num := get_slip_seq_no('|',l_seq_num,1); -- 14701748
2412: -- for bug 10420152
2413: hr_utility.trace('l_empr_report_yr '||l_empr_report_yr);
2414: hr_utility.trace('l_seq_num '||l_seq_num);
2415: if (ltrim(rtrim(l_empr_report_yr)) >= '2010') then
2416: hr_utility.trace('p_taxation_year is greater than or equal 2010');
2417: hr_utility.trace('l_first_seq_num (befire) --'||l_first_seq_num);

Line 2414: hr_utility.trace('l_seq_num '||l_seq_num);

2410: 'XMLPROC');
2411: l_first_seq_num := get_slip_seq_no('|',l_seq_num,1); -- 14701748
2412: -- for bug 10420152
2413: hr_utility.trace('l_empr_report_yr '||l_empr_report_yr);
2414: hr_utility.trace('l_seq_num '||l_seq_num);
2415: if (ltrim(rtrim(l_empr_report_yr)) >= '2010') then
2416: hr_utility.trace('p_taxation_year is greater than or equal 2010');
2417: hr_utility.trace('l_first_seq_num (befire) --'||l_first_seq_num);
2418: l_first_seq_num := substr(l_first_seq_num,1,3)||'-'||substr(l_first_seq_num,4,3)||

Line 2416: hr_utility.trace('p_taxation_year is greater than or equal 2010');

2412: -- for bug 10420152
2413: hr_utility.trace('l_empr_report_yr '||l_empr_report_yr);
2414: hr_utility.trace('l_seq_num '||l_seq_num);
2415: if (ltrim(rtrim(l_empr_report_yr)) >= '2010') then
2416: hr_utility.trace('p_taxation_year is greater than or equal 2010');
2417: hr_utility.trace('l_first_seq_num (befire) --'||l_first_seq_num);
2418: l_first_seq_num := substr(l_first_seq_num,1,3)||'-'||substr(l_first_seq_num,4,3)||
2419: '-'||substr(l_first_seq_num,7);
2420: hr_utility.trace('l_first_seq_num (after) --'||l_first_seq_num);

Line 2417: hr_utility.trace('l_first_seq_num (befire) --'||l_first_seq_num);

2413: hr_utility.trace('l_empr_report_yr '||l_empr_report_yr);
2414: hr_utility.trace('l_seq_num '||l_seq_num);
2415: if (ltrim(rtrim(l_empr_report_yr)) >= '2010') then
2416: hr_utility.trace('p_taxation_year is greater than or equal 2010');
2417: hr_utility.trace('l_first_seq_num (befire) --'||l_first_seq_num);
2418: l_first_seq_num := substr(l_first_seq_num,1,3)||'-'||substr(l_first_seq_num,4,3)||
2419: '-'||substr(l_first_seq_num,7);
2420: hr_utility.trace('l_first_seq_num (after) --'||l_first_seq_num);
2421: end if;

Line 2420: hr_utility.trace('l_first_seq_num (after) --'||l_first_seq_num);

2416: hr_utility.trace('p_taxation_year is greater than or equal 2010');
2417: hr_utility.trace('l_first_seq_num (befire) --'||l_first_seq_num);
2418: l_first_seq_num := substr(l_first_seq_num,1,3)||'-'||substr(l_first_seq_num,4,3)||
2419: '-'||substr(l_first_seq_num,7);
2420: hr_utility.trace('l_first_seq_num (after) --'||l_first_seq_num);
2421: end if;
2422:
2423: tab_employee(l_sequence_no) := ''||l_first_seq_num
2424: ||'';

Line 2457: hr_utility.trace('p_taxation_year is greater than or equal 2010');

2453: end if;
2454: ELSE
2455: --for bug 10420152
2456: if (ltrim(rtrim(l_empr_report_yr)) >= '2010') then
2457: hr_utility.trace('p_taxation_year is greater than or equal 2010');
2458: l_rl2_first_slip_number := substr(l_rl2_first_slip_number,1,3)||
2459: '-'||substr(l_rl2_first_slip_number,4,3)||
2460: '-'||substr(l_rl2_first_slip_number,7);
2461: end if;

Line 2526: hr_utility.trace('tab_employee(lNoOrigReleve) = ' || tab_employee(lNoOrigReleve));

2522: '' || EOL;
2523: tab_employee5(lNoOrigReleve) := '' || convert_special_char(l_rl2_first_form_number) ||
2524: '' || EOL;
2525: END IF;
2526: hr_utility.trace('tab_employee(lNoOrigReleve) = ' || tab_employee(lNoOrigReleve));
2527: END IF;
2528:
2529: -- End bug 5046010
2530:

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

2593: tab_employee5(lNAS3) := NULL;
2594:
2595: end if;
2596: END IF;
2597: -- hr_utility.trace('tab_employee(lNAS) = ' || tab_employee(lNAS));
2598:
2599: -- No
2600: IF (l_employee_number IS NOT NULL AND
2601: l_employee_number <> ' ' ) THEN

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

2618: tab_employee4(lNo) := NULL;
2619: tab_employee5(lNo) := NULL;
2620: end if;
2621: END IF;
2622: hr_utility.trace('tab_employee(lNo) = ' || tab_employee(lNo));
2623:
2624: -- NomFamille
2625:
2626: tab_employee(lNomFamille) := '' ||

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

2624: -- NomFamille
2625:
2626: tab_employee(lNomFamille) := '' ||
2627: convert_special_char(substr(l_employee_last_name,1,30)) || '' || EOL;
2628: hr_utility.trace('tab_employee(lNomFamille) = ' || tab_employee(lNomFamille));
2629:
2630: l_full_empname := convert_special_char(substr(l_employee_last_name,1,30));
2631:
2632: -- Prenom

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

2639: l_msg_code := 'MISSING_EMP_FIRST_NAME';
2640: l_status := 'Failed';
2641: tab_employee(lPrenom) := NULL;
2642: END IF;
2643: hr_utility.trace('tab_employee(lPrenom) = ' || tab_employee(lPrenom));
2644:
2645: -- Initiale
2646:
2647: IF (l_employee_middle_initial is NOT NULL AND

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

2673: /* Bug 13460512 End */
2674:
2675: end if;
2676:
2677: hr_utility.trace('tab_employee(lInitiale) = ' || tab_employee(lInitiale));
2678:
2679: l_person_id := to_number(l_per_id);
2680:
2681: l_return := pay_ca_emp_address_dtls.get_emp_address(

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

2691: -- If Address line 1 is NULL or ' ' then the employee is missing
2692: -- address information - as line 1 is mandatory in the Address form.
2693: -- Need to check data by SS transaction /API.
2694:
2695: hr_utility.trace('l_person_id = ' || to_char(l_person_id));
2696: hr_utility.trace('l_address_line1 = ' || l_address_line1);
2697: hr_utility.trace('l_address_line2 = ' || l_address_line2);
2698: hr_utility.trace('l_postal_code = ' || l_postal_code);
2699:

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

2692: -- address information - as line 1 is mandatory in the Address form.
2693: -- Need to check data by SS transaction /API.
2694:
2695: hr_utility.trace('l_person_id = ' || to_char(l_person_id));
2696: hr_utility.trace('l_address_line1 = ' || l_address_line1);
2697: hr_utility.trace('l_address_line2 = ' || l_address_line2);
2698: hr_utility.trace('l_postal_code = ' || l_postal_code);
2699:
2700: /* Bug Fix 4761782 */

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

2693: -- Need to check data by SS transaction /API.
2694:
2695: hr_utility.trace('l_person_id = ' || to_char(l_person_id));
2696: hr_utility.trace('l_address_line1 = ' || l_address_line1);
2697: hr_utility.trace('l_address_line2 = ' || l_address_line2);
2698: hr_utility.trace('l_postal_code = ' || l_postal_code);
2699:
2700: /* Bug Fix 4761782 */
2701: -- Address Line 1

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

2694:
2695: hr_utility.trace('l_person_id = ' || to_char(l_person_id));
2696: hr_utility.trace('l_address_line1 = ' || l_address_line1);
2697: hr_utility.trace('l_address_line2 = ' || l_address_line2);
2698: hr_utility.trace('l_postal_code = ' || l_postal_code);
2699:
2700: /* Bug Fix 4761782 */
2701: -- Address Line 1
2702: IF l_address_line1 IS NOT NULL AND

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

2766: convert_special_char(substr(l_address_line1,1,30)) || EOL;
2767: /* End Bug 13460512 */
2768:
2769: end if;
2770: hr_utility.trace('tab_employee(lLigne1) = ' || tab_employee(lLigne1));
2771:
2772: -- Address Line 2
2773:
2774: IF ((l_address_line2 IS NOT NULL AND

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

2822: tab_employee4(lVille) := NULL;
2823: tab_employee5(lVille) := NULL;
2824: END IF;
2825: END IF;
2826: --hr_utility.trace('tab_employee(lLigne2) = ' || tab_employee(lLigne2));
2827:
2828: -- Ville (City)
2829: IF l_city IS NOT NULL AND
2830: l_city <> ' ' THEN

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

2835: ELSE
2836: tab_employee(lVille) := NULL;
2837:
2838: END IF;
2839: --hr_utility.trace('tab_employee(lVille) = ' || tab_employee(lVille));
2840:
2841: -- Province
2842: IF l_emp_province IS NOT NULL AND
2843: l_emp_province <> ' ' THEN

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

2861: ELSE
2862: tab_employee(lProvince) := NULL;
2863:
2864: END IF;
2865: hr_utility.trace('tab_employee(lProvince) = ' || tab_employee(lProvince));
2866:
2867: -- Bug# 4754743 fix
2868: -- Postal Code
2869: IF l_postal_code IS NOT NULL AND

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

2876: ELSE
2877: tab_employee(lCodePostal) := NULL;
2878: END IF;
2879:
2880: hr_utility.trace('tab_employee(lCodePostal) = ' || tab_employee(lCodePostal));
2881: l_addr_end_tag := '';
2882:
2883: END IF;
2884:

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

2964: end if;
2965:
2966: -- Summ (Box A)
2967:
2968: hr_utility.trace('The Value of Box A is '|| l_rl2_box_a);
2969: IF TO_NUMBER(l_rl2_box_a) > 9999999.99 THEN
2970: l_status := 'Failed';
2971: l_msg_code := 'AMT_GREATER_THAN_RANGE';
2972: END IF;

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

3009: tab_employee4(lA_PrestRPA_RPNA ) := NULL;
3010: tab_employee5(lA_PrestRPA_RPNA ) := NULL;
3011: end if;
3012: END IF;
3013: hr_utility.trace('tab_employee(lA_PrestRPA_RPNA) = ' ||
3014: tab_employee(lA_PrestRPA_RPNA));
3015:
3016: -- Summ (Box B)
3017:

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

3055: tab_employee5(lB_PrestREER_FERR_RPDB) := NULL;
3056: end if;
3057:
3058: END IF;
3059: hr_utility.trace('tab_employee(lB_PrestREER_FERR_RPDB) = ' ||
3060: tab_employee(lB_PrestREER_FERR_RPDB));
3061:
3062: -- Summ (Box C)
3063:

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

3100: tab_employee5(lC_AutrePaiement ) := NULL;
3101: end if;
3102: END IF;
3103:
3104: hr_utility.trace('tab_employee(lC_AutrePaiement ) = ' ||
3105: tab_employee(lC_AutrePaiement ));
3106:
3107: -- Summ (Box D)
3108:

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

3144: tab_employee4(lD_RembPrimeConjoint) := NULL;
3145: tab_employee5(lD_RembPrimeConjoint) := NULL;
3146: end if;
3147: END IF;
3148: hr_utility.trace('tab_employee(lD_RembPrimeConjoint) = ' ||
3149: tab_employee(lD_RembPrimeConjoint));
3150:
3151: -- (Box E)
3152:

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

3189: tab_employee5(lE_PrestDeces) := NULL;
3190: end if;
3191: END IF;
3192:
3193: hr_utility.trace('tab_employee(lE_PrestDeces) = ' ||
3194: tab_employee(lE_PrestDeces));
3195:
3196: -- (Box F)
3197:

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

3233: tab_employee4(lF_RembCotisInutilise) := NULL;
3234: tab_employee5(lF_RembCotisInutilise) := NULL;
3235: end if;
3236: END IF;
3237: hr_utility.trace('tab_employee(lF_RembCotisInutilise) = ' ||
3238: tab_employee(lF_RembCotisInutilise));
3239:
3240: -- (Box G)
3241:

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

3277: tab_employee4(lG_RevocationREER_FERR) := NULL;
3278: tab_employee5(lG_RevocationREER_FERR) := NULL;
3279: end if;
3280: END IF;
3281: hr_utility.trace('tab_employee(lG_RevocationREER_FERR) = ' ||
3282: tab_employee(lG_RevocationREER_FERR));
3283:
3284: -- (Box H)
3285:

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

3322: tab_employee5(lH_AutreRevenu) := NULL;
3323: end if;
3324: END IF;
3325:
3326: hr_utility.trace('tab_employee(lH_AutreRevenu ) = ' ||
3327: tab_employee(lH_AutreRevenu ));
3328:
3329: -- (Box I)
3330:

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

3366: tab_employee4(lI_DroitDeduction ) := NULL;
3367: tab_employee5(lI_DroitDeduction ) := NULL;
3368: end if;
3369: END IF;
3370: hr_utility.trace('tab_employee(lI_DroitDeduction ) = ' ||
3371: tab_employee(lI_DroitDeduction ));
3372:
3373: -- (Box J)
3374:

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

3410: tab_employee4(lJ_ImpotQueRetenuSource ) := NULL;
3411: tab_employee5(lJ_ImpotQueRetenuSource ) := NULL;
3412: end if;
3413: END IF;
3414: hr_utility.trace('tab_employee(lJ_ImpotQueRetenuSource ) = ' ||
3415: tab_employee(lJ_ImpotQueRetenuSource ));
3416:
3417: -- (Box K)
3418:

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

3454: tab_employee4(lK_RevenuApresDeces ) := NULL;
3455: tab_employee5(lK_RevenuApresDeces ) := NULL;
3456: end if;
3457: END IF;
3458: hr_utility.trace('tab_employee(lK_RevenuApresDeces ) = ' ||
3459: tab_employee(lK_RevenuApresDeces ));
3460:
3461: -- (Box L)
3462:

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

3498: tab_employee4(lL_RetraitREEP ) := NULL;
3499: tab_employee5(lL_RetraitREEP ) := NULL;
3500: end if;
3501: END IF;
3502: hr_utility.trace('tab_employee(lL_RetraitREEP ) = ' ||
3503: tab_employee(lL_RetraitREEP ));
3504:
3505: -- (Box M)
3506:

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

3542: tab_employee4(lM_LibereImpot) := NULL;
3543: tab_employee5(lM_LibereImpot) := NULL;
3544: end if;
3545: END IF;
3546: hr_utility.trace('tab_employee(lM_LibereImpot) = ' ||
3547: tab_employee(lM_LibereImpot));
3548:
3549: -- (Box N)
3550: -- Bug 5569097 Fix.

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

3616: tab_employee5(lN_NASConjoint1) := NULL;
3617: tab_employee5(lN_NASConjoint2) := NULL;
3618: end if;
3619: END IF;
3620: hr_utility.trace('tab_employee(lN_NASConjoint) = ' ||
3621: tab_employee(lN_NASConjoint));
3622:
3623: -- Summ (Box O)
3624:

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

3660: tab_employee4(lO_RetraitRAP ) := NULL;
3661: tab_employee5(lO_RetraitRAP ) := NULL;
3662: end if;
3663: END IF;
3664: hr_utility.trace('Value of Box O');
3665: hr_utility.trace('tab_employee(lO_RetraitRAP ) = ' ||
3666: tab_employee(lO_RetraitRAP ));
3667:
3668: if p_rep_type = 'RL2PAPERPDF' then

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

3661: tab_employee5(lO_RetraitRAP ) := NULL;
3662: end if;
3663: END IF;
3664: hr_utility.trace('Value of Box O');
3665: hr_utility.trace('tab_employee(lO_RetraitRAP ) = ' ||
3666: tab_employee(lO_RetraitRAP ));
3667:
3668: if p_rep_type = 'RL2PAPERPDF' then
3669: tab_employee(lCode_dereleve) := '' ||

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

3724: l_msg_code := 'ALL_BOXES_ZERO';
3725: END IF;
3726:
3727: -- (Provenance1)
3728: hr_utility.trace('The checking for Provenance value ');
3729: hr_utility.trace('The value of Archiver Assignment Action Id '||p_arch_action_id);
3730: hr_utility.trace('The Value of Assignment Id '||p_asg_id);
3731:
3732: hr_utility.trace('The value Of Provenenace : '|| l_rl2_source_of_income);

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

3725: END IF;
3726:
3727: -- (Provenance1)
3728: hr_utility.trace('The checking for Provenance value ');
3729: hr_utility.trace('The value of Archiver Assignment Action Id '||p_arch_action_id);
3730: hr_utility.trace('The Value of Assignment Id '||p_asg_id);
3731:
3732: hr_utility.trace('The value Of Provenenace : '|| l_rl2_source_of_income);
3733: IF l_rl2_source_of_income IS NOT NULL THEN

Line 3730: hr_utility.trace('The Value of Assignment Id '||p_asg_id);

3726:
3727: -- (Provenance1)
3728: hr_utility.trace('The checking for Provenance value ');
3729: hr_utility.trace('The value of Archiver Assignment Action Id '||p_arch_action_id);
3730: hr_utility.trace('The Value of Assignment Id '||p_asg_id);
3731:
3732: hr_utility.trace('The value Of Provenenace : '|| l_rl2_source_of_income);
3733: IF l_rl2_source_of_income IS NOT NULL THEN
3734: -- changed to for bug 13029973

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

3728: hr_utility.trace('The checking for Provenance value ');
3729: hr_utility.trace('The value of Archiver Assignment Action Id '||p_arch_action_id);
3730: hr_utility.trace('The Value of Assignment Id '||p_asg_id);
3731:
3732: hr_utility.trace('The value Of Provenenace : '|| l_rl2_source_of_income);
3733: IF l_rl2_source_of_income IS NOT NULL THEN
3734: -- changed to for bug 13029973
3735: /* 14701748 YE12P211I RL2 ELECTRONIC INTERFACE CHANGES FOR 2012 */
3736: IF ( p_rep_type ='RL2_XML_MAG' and l_rl2_source_of_income = 'AUTRE' ) THEN

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

3771: tab_employee4(lProvenance1) := NULL;
3772: tab_employee5(lProvenance1) := NULL;
3773: end if;
3774: END IF;
3775: hr_utility.trace('tab_employee(lProvenance1) = ' ||
3776: tab_employee(lProvenance1));
3777:
3778: /* For bug 8888411 */
3779: OPEN c_rl2_src_income(replace(l_rl2_source_of_income,'AUTRE','OTHER'), p_taxation_year);

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

4088: end loop;
4089: end if;
4090: end if;
4091: --l_final_xml_string := l_final_xml_string || l_final_xml_string_fur_inf ;
4092: hr_utility.trace('Just before Printing the file details ');
4093: pay_core_files.write_to_magtape_lob(l_final_xml_string);
4094: /* bug 14701748 */
4095: ELSE
4096:

Line 4362: hr_utility.trace('l_data_page_count1 '||l_data_page_count);

4358:
4359: l_data_page_count :=1;
4360: l_blank_page_flg := 'TRUE';
4361: l_k:=1;l_i:=1; l_m:=0;
4362: hr_utility.trace('l_data_page_count1 '||l_data_page_count);
4363:
4364: if g_further_info_list.count > 0 then
4365: l_final_xml_string6 := ''||EOL;
4366: end if;

Line 4373: hr_utility.trace('(0) l_final_xml_string6--'||l_final_xml_string6);

4369: further_info_count_perpage := 4;
4370: else
4371: further_info_count_perpage := 5;
4372: end if;
4373: hr_utility.trace('(0) l_final_xml_string6--'||l_final_xml_string6);
4374: for l_j in 1..g_further_info_list.count
4375: loop
4376: if l_further_amount(l_j) is not null and (((l_further_code(l_j) <> '201' and to_number(l_further_amount(l_j)) <> 0))
4377: or (l_further_code(l_j)) = '201') then

Line 4382: hr_utility.trace('l_data_page_count2 '||l_data_page_count);

4378: if l_k > further_info_count_perpage then -- if l_k > 5 then 14701748
4379: l_k :=1;
4380: l_m := 1;
4381: l_data_page_count := l_data_page_count+1;
4382: hr_utility.trace('l_data_page_count2 '||l_data_page_count);
4383: end if;
4384: if l_m = 1 then
4385: for i in 1..l_counter loop
4386: hr_utility.trace('(1)l_final_xml_string6--'||l_final_xml_string6);

Line 4386: hr_utility.trace('(1)l_final_xml_string6--'||l_final_xml_string6);

4382: hr_utility.trace('l_data_page_count2 '||l_data_page_count);
4383: end if;
4384: if l_m = 1 then
4385: for i in 1..l_counter loop
4386: hr_utility.trace('(1)l_final_xml_string6--'||l_final_xml_string6);
4387: l_final_xml_string6:= l_final_xml_string6||tab_emplyr3(i)
4388: ||tab_emplyr4(i)
4389: ||tab_emplyr5(i);
4390: end loop;

Line 4391: hr_utility.trace('(2) l_final_xml_string6--'||l_final_xml_string6);

4387: l_final_xml_string6:= l_final_xml_string6||tab_emplyr3(i)
4388: ||tab_emplyr4(i)
4389: ||tab_emplyr5(i);
4390: end loop;
4391: hr_utility.trace('(2) l_final_xml_string6--'||l_final_xml_string6);
4392: /* 14701748 */
4393: rl2_final_slip_number := get_slip_seq_no('|',l_rl2_slip_number,l_data_page_count);
4394: rl2_final_slip_number := substr(rl2_final_slip_number,1,3)||'-'||substr(rl2_final_slip_number,4,3)||
4395: '-'||substr(rl2_final_slip_number,7);

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

4590: ||l_final_xml_string5
4591: ||l_final_xml_string6
4592: ||''||p_print_instruction||'' --Added for 5850067
4593: ||EOL||'';
4594: hr_utility.trace('Just before Printing the file details ');
4595: if trim(called_from) = 'xml_employee_record' then
4596: pay_core_files.write_to_magtape_lob(l_final_xml_string);
4597: else
4598: dbms_lob.createtemporary(l_temp_blob,false,DBMS_LOB.CALL);

Line 4604: hr_utility.trace('Closing l_temp_blob' );

4600:
4601: l_temp_blob := append_to_lob(l_final_xml_string);
4602: dbms_lob.append(p_xml_blob,l_temp_blob);
4603: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN
4604: hr_utility.trace('Closing l_temp_blob' );
4605: dbms_lob.close(l_temp_blob);
4606: END IF;
4607: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
4608: hr_utility.trace('Closing p_xml_blob' );

Line 4608: hr_utility.trace('Closing p_xml_blob' );

4604: hr_utility.trace('Closing l_temp_blob' );
4605: dbms_lob.close(l_temp_blob);
4606: END IF;
4607: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
4608: hr_utility.trace('Closing p_xml_blob' );
4609: dbms_lob.close(p_xml_blob);
4610: hr_utility.trace('closed p_xml_blob');
4611: END IF;
4612: end if;

Line 4610: hr_utility.trace('closed p_xml_blob');

4606: END IF;
4607: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
4608: hr_utility.trace('Closing p_xml_blob' );
4609: dbms_lob.close(p_xml_blob);
4610: hr_utility.trace('closed p_xml_blob');
4611: END IF;
4612: end if;
4613:
4614: ELSIF l_negative_box = 'Y' THEN

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

4659: l_other_details||
4660: tab_employee(lErrorDetails)||
4661: ''||EOL;
4662:
4663: hr_utility.trace('Just before Printing the file details ');
4664: pay_core_files.write_to_magtape_lob(l_final_xml_string);
4665: END IF;
4666: END IF;
4667:

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

4748: l_address_begin_tag varchar2(10);
4749: l_address_end_tag varchar2(10);
4750:
4751: BEGIN
4752: hr_utility.trace('XML Employer');
4753: hr_utility.trace('XML Employer');
4754:
4755: SELECT
4756: fnd_global.local_chr(13) || fnd_global.local_chr(10)

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

4749: l_address_end_tag varchar2(10);
4750:
4751: BEGIN
4752: hr_utility.trace('XML Employer');
4753: hr_utility.trace('XML Employer');
4754:
4755: SELECT
4756: fnd_global.local_chr(13) || fnd_global.local_chr(10)
4757: INTO EOL

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

4785:
4786: tab_employer(lAnnee) := '' || l_taxation_year || '' || EOL;
4787: tab_employer(lNbReleves) := '' || 'Running Total' || '' || EOL;
4788:
4789: hr_utility.trace('The Payroll Action Id : '||l_payroll_actid);
4790: hr_utility.trace('The business group id : '||l_business_grpid);
4791: l_quebec_bn := pay_ca_rl2_mag.get_employer_item(l_business_grpid,
4792: l_payroll_actid,
4793: 'CAEOY_RL2_QUEBEC_BN');

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

4786: tab_employer(lAnnee) := '' || l_taxation_year || '' || EOL;
4787: tab_employer(lNbReleves) := '' || 'Running Total' || '' || EOL;
4788:
4789: hr_utility.trace('The Payroll Action Id : '||l_payroll_actid);
4790: hr_utility.trace('The business group id : '||l_business_grpid);
4791: l_quebec_bn := pay_ca_rl2_mag.get_employer_item(l_business_grpid,
4792: l_payroll_actid,
4793: 'CAEOY_RL2_QUEBEC_BN');
4794: hr_utility.trace('The Quebec Number is '||l_quebec_bn);

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

4790: hr_utility.trace('The business group id : '||l_business_grpid);
4791: l_quebec_bn := pay_ca_rl2_mag.get_employer_item(l_business_grpid,
4792: l_payroll_actid,
4793: 'CAEOY_RL2_QUEBEC_BN');
4794: hr_utility.trace('The Quebec Number is '||l_quebec_bn);
4795: tab_employer(lNold) := '' || convert_special_char(substr(l_quebec_bn,1,10)) ||
4796: '' || EOL;
4797: tab_employer(lTypeDossier) := '' || 'RS' ||
4798: '' || EOL;

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

4798: '' || EOL;
4799:
4800: tab_employer(lNoDossier) := '' || convert_special_char(substr(l_quebec_bn,13,4)) ||
4801: '' || EOL;
4802: hr_utility.trace('The Employer File Number : '|| substr(l_quebec_bn,13,4));
4803: l_employer_name := pay_ca_rl2_mag.get_employer_item(l_business_grpid,
4804: l_payroll_actid,
4805: 'CAEOY_RL2_EMPLOYER_NAME');
4806:

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

4805: 'CAEOY_RL2_EMPLOYER_NAME');
4806:
4807: tab_employer(lNom1) := '' ||
4808: convert_special_char(substr(l_employer_name,1,30)) || '' || EOL;
4809: hr_utility.trace('tab_employer(lNom) = ' || tab_employer(lNom1));
4810:
4811: -- Address Line 1
4812:
4813: l_address_line := pay_ca_rl2_mag.get_employer_item(l_business_grpid,

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

4830: l_address_begin_tag := '';
4831:
4832: tab_employer(lLigne1) := '' ||
4833: convert_special_char(substr(l_address_line,1,30)) || '' || EOL;
4834: hr_utility.trace('tab_employer(lLigne1) = ' || tab_employer(lLigne1));
4835:
4836:
4837: -- Address Line 2
4838:

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

4846: convert_special_char(substr(l_address_line,1,30)) || '' || EOL;
4847: ELSE
4848: tab_employer(lLigne2) := NULL;
4849: END IF;
4850: hr_utility.trace('tab_employer(lLigne2) = ' || tab_employer(lLigne2));
4851:
4852: -- Ville (City)
4853:
4854: l_address_line := pay_ca_rl2_mag.get_employer_item(l_business_grpid,

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

4860: convert_special_char(substr(l_address_line,1,30)) || '' || EOL;
4861: ELSE
4862: tab_employer(lVille) := NULL;
4863: END IF;
4864: hr_utility.trace('tab_employer(lVille) = ' || tab_employer(lVille));
4865:
4866: -- Province
4867:
4868: l_address_line := pay_ca_rl2_mag.get_employer_item(l_business_grpid,

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

4876: l_address_line),1,20)) || '' || EOL;
4877: ELSE
4878: tab_employer(lProvince) := NULL;
4879: END IF;
4880: hr_utility.trace('tab_employer(lProvince) = ' || tab_employer(lProvince));
4881:
4882: -- Postal Code
4883:
4884: l_address_line := pay_ca_rl2_mag.get_employer_item(l_business_grpid,

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

4891: convert_special_char(substr(l_address_line,1,6)) || '' || EOL;
4892: ELSE
4893: tab_employer(lCodePostal) := NULL;
4894: END IF;
4895: hr_utility.trace('tab_employer(lCodePostal) = ' ||
4896: tab_employer(lCodePostal));
4897:
4898: l_address_end_tag := '';
4899:

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

4997: l_chk_digit := 11 - l_modulus;
4998: end if;
4999:
5000: if l_chk_digit <> l_act_chk_number then
5001: hr_utility.set_message(801,'PAY_74156_INCORRECT_QIN_INFO');
5002: hr_utility.set_message_token('PRE_NAME',p_qin_name);
5003: pay_core_utils.push_message(801,'PAY_74156_INCORRECT_QIN_INFO','P');
5004: pay_core_utils.push_token('PRE_NAME',p_qin_name);
5005: hr_utility.raise_error;

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

4998: end if;
4999:
5000: if l_chk_digit <> l_act_chk_number then
5001: hr_utility.set_message(801,'PAY_74156_INCORRECT_QIN_INFO');
5002: hr_utility.set_message_token('PRE_NAME',p_qin_name);
5003: pay_core_utils.push_message(801,'PAY_74156_INCORRECT_QIN_INFO','P');
5004: pay_core_utils.push_token('PRE_NAME',p_qin_name);
5005: hr_utility.raise_error;
5006: end if;

Line 5005: hr_utility.raise_error;

5001: hr_utility.set_message(801,'PAY_74156_INCORRECT_QIN_INFO');
5002: hr_utility.set_message_token('PRE_NAME',p_qin_name);
5003: pay_core_utils.push_message(801,'PAY_74156_INCORRECT_QIN_INFO','P');
5004: pay_core_utils.push_token('PRE_NAME',p_qin_name);
5005: hr_utility.raise_error;
5006: end if;
5007: else
5008:
5009: hr_utility.set_message(801,'PAY_74156_INCORRECT_QIN_INFO');

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

5005: hr_utility.raise_error;
5006: end if;
5007: else
5008:
5009: hr_utility.set_message(801,'PAY_74156_INCORRECT_QIN_INFO');
5010: hr_utility.set_message_token('PRE_NAME',p_qin_name);
5011: pay_core_utils.push_message(801,'PAY_74156_INCORRECT_QIN_INFO','P');
5012: pay_core_utils.push_token('PRE_NAME',p_qin_name);
5013: hr_utility.raise_error;

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

5006: end if;
5007: else
5008:
5009: hr_utility.set_message(801,'PAY_74156_INCORRECT_QIN_INFO');
5010: hr_utility.set_message_token('PRE_NAME',p_qin_name);
5011: pay_core_utils.push_message(801,'PAY_74156_INCORRECT_QIN_INFO','P');
5012: pay_core_utils.push_token('PRE_NAME',p_qin_name);
5013: hr_utility.raise_error;
5014:

Line 5013: hr_utility.raise_error;

5009: hr_utility.set_message(801,'PAY_74156_INCORRECT_QIN_INFO');
5010: hr_utility.set_message_token('PRE_NAME',p_qin_name);
5011: pay_core_utils.push_message(801,'PAY_74156_INCORRECT_QIN_INFO','P');
5012: pay_core_utils.push_token('PRE_NAME',p_qin_name);
5013: hr_utility.raise_error;
5014:
5015: end if;
5016:
5017: return l_chk_digit;

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

5313: l_check_number number;
5314: BEGIN
5315:
5316: l_check_number := mod(p_curr_seq,7);
5317: hr_utility.trace('l_check_number ='|| l_check_number);
5318: l_seq_number := (p_curr_seq * 10) + l_check_number;
5319: hr_utility.trace('l_seq_number ='|| l_seq_number);
5320: return l_seq_number;
5321: END; */

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

5315:
5316: l_check_number := mod(p_curr_seq,7);
5317: hr_utility.trace('l_check_number ='|| l_check_number);
5318: l_seq_number := (p_curr_seq * 10) + l_check_number;
5319: hr_utility.trace('l_seq_number ='|| l_seq_number);
5320: return l_seq_number;
5321: END; */
5322:
5323: END pay_ca_rl2_mag;