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

Line 190: hr_utility.trace('+=========================================================+');

186: lv_flag_count NUMBER := 0;
187: l_lockingactid_check pay_assignment_actions.assignment_action_id%TYPE;
188:
189: BEGIN
190: hr_utility.trace('+=========================================================+');
191: hr_utility.set_location( 'pay_ca_t4_amend_mag.action_creation',10);
192: get_report_parameters(
193: p_pactid,
194: l_legislative_parameters,

Line 191: hr_utility.set_location( 'pay_ca_t4_amend_mag.action_creation',10);

187: l_lockingactid_check pay_assignment_actions.assignment_action_id%TYPE;
188:
189: BEGIN
190: hr_utility.trace('+=========================================================+');
191: hr_utility.set_location( 'pay_ca_t4_amend_mag.action_creation',10);
192: get_report_parameters(
193: p_pactid,
194: l_legislative_parameters,
195: l_year_end,

Line 201: hr_utility.trace('l_trans_gre ='||l_trans_gre);

197: l_business_group_id);
198:
199: l_trans_gre := pay_ca_t4_amend_mag.get_parameter('TRANSMITTER_GRE',
200: l_legislative_parameters);
201: hr_utility.trace('l_trans_gre ='||l_trans_gre);
202: --
203: l_validate_gre := validate_gre_data(l_trans_gre, to_char(l_year_end,'YYYY'));
204: IF l_validate_gre = '1' THEN
205: hr_utility.raise_error;

Line 205: hr_utility.raise_error;

201: hr_utility.trace('l_trans_gre ='||l_trans_gre);
202: --
203: l_validate_gre := validate_gre_data(l_trans_gre, to_char(l_year_end,'YYYY'));
204: IF l_validate_gre = '1' THEN
205: hr_utility.raise_error;
206: END IF;
207: --
208: OPEN c_get_ue_id('CAEOY_T4_AMENDMENT_FLAG');
209: FETCH c_get_ue_id into ln_t4_amend_flag_ue_id;

Line 219: -- hr_utility.set_location('pay_ca_t4_amend_mag.action_creation', 20);

215: l_assignment_id,
216: l_tax_unit_id,
217: l_effective_end_date,
218: l_assignment_action_id;
219: -- hr_utility.set_location('pay_ca_t4_amend_mag.action_creation', 20);
220: EXIT WHEN c_all_asg%NOTFOUND;
221:
222: hr_utility.trace('+------------------------------------------------+');
223: hr_utility.trace('Fetched Assignment: '|| to_char(l_assignment_id)||

Line 222: hr_utility.trace('+------------------------------------------------+');

218: l_assignment_action_id;
219: -- hr_utility.set_location('pay_ca_t4_amend_mag.action_creation', 20);
220: EXIT WHEN c_all_asg%NOTFOUND;
221:
222: hr_utility.trace('+------------------------------------------------+');
223: hr_utility.trace('Fetched Assignment: '|| to_char(l_assignment_id)||
224: ' Person: '|| to_char(l_person_id)||
225: ' Tax Unit: '|| to_char(l_tax_unit_id)||
226: ' End Date: '|| to_char(l_effective_end_date,'DD-Mon-YYYY'));

Line 223: hr_utility.trace('Fetched Assignment: '|| to_char(l_assignment_id)||

219: -- hr_utility.set_location('pay_ca_t4_amend_mag.action_creation', 20);
220: EXIT WHEN c_all_asg%NOTFOUND;
221:
222: hr_utility.trace('+------------------------------------------------+');
223: hr_utility.trace('Fetched Assignment: '|| to_char(l_assignment_id)||
224: ' Person: '|| to_char(l_person_id)||
225: ' Tax Unit: '|| to_char(l_tax_unit_id)||
226: ' End Date: '|| to_char(l_effective_end_date,'DD-Mon-YYYY'));
227:

Line 231: hr_utility.trace('New T4 Amend Action = ' ||to_char(lockingactid));

227:
228: SELECT pay_assignment_actions_s.nextval
229: INTO lockingactid
230: FROM dual;
231: hr_utility.trace('New T4 Amend Action = ' ||to_char(lockingactid));
232:
233: BEGIN
234: OPEN c_get_fed_amend_flag(l_assignment_action_id,
235: ln_t4_amend_flag_ue_id);

Line 240: hr_utility.trace('Amended : '||lv_fed_amend_flag);

236: LOOP -- check amend flag
237: lv_fed_amend_flag := 'N';
238: FETCH c_get_fed_amend_flag into lv_fed_amend_flag;
239: EXIT when c_get_fed_amend_flag%NOTFOUND;
240: hr_utility.trace('Amended : '||lv_fed_amend_flag);
241: IF c_get_fed_amend_flag%FOUND THEN
242: IF lv_fed_amend_flag = 'Y' AND lv_flag_count =0 THEN
243: -- Insert into pay_assignment_actions.
244: -- hr_utility.set_location('pay_ca_t4_amend_mag.action_creation', 80);

Line 244: -- hr_utility.set_location('pay_ca_t4_amend_mag.action_creation', 80);

240: hr_utility.trace('Amended : '||lv_fed_amend_flag);
241: IF c_get_fed_amend_flag%FOUND THEN
242: IF lv_fed_amend_flag = 'Y' AND lv_flag_count =0 THEN
243: -- Insert into pay_assignment_actions.
244: -- hr_utility.set_location('pay_ca_t4_amend_mag.action_creation', 80);
245: hr_nonrun_asact.insact(lockingactid
246: ,l_assignment_id
247: ,p_pactid
248: ,p_chunk

Line 250: -- hr_utility.set_location('pay_ca_t4_amend_mag.action_creation', 90);

246: ,l_assignment_id
247: ,p_pactid
248: ,p_chunk
249: ,l_tax_unit_id);
250: -- hr_utility.set_location('pay_ca_t4_amend_mag.action_creation', 90);
251: UPDATE pay_assignment_actions aa
252: SET aa.serial_number = to_char(l_person_id)
253: WHERE aa.assignment_action_id = lockingactid;
254:

Line 255: -- hr_utility.set_location('pay_ca_t4_amend_mag.action_creation', 100);

251: UPDATE pay_assignment_actions aa
252: SET aa.serial_number = to_char(l_person_id)
253: WHERE aa.assignment_action_id = lockingactid;
254:
255: -- hr_utility.set_location('pay_ca_t4_amend_mag.action_creation', 100);
256: hr_nonrun_asact.insint(lockingactid ,l_assignment_action_id);
257:
258: hr_utility.trace(to_char(lockingactid)||' locked Amend Archiver ID '||to_char(l_assignment_action_id));
259: lv_flag_count := lv_flag_count + 1;

Line 258: hr_utility.trace(to_char(lockingactid)||' locked Amend Archiver ID '||to_char(l_assignment_action_id));

254:
255: -- hr_utility.set_location('pay_ca_t4_amend_mag.action_creation', 100);
256: hr_nonrun_asact.insint(lockingactid ,l_assignment_action_id);
257:
258: hr_utility.trace(to_char(lockingactid)||' locked Amend Archiver ID '||to_char(l_assignment_action_id));
259: lv_flag_count := lv_flag_count + 1;
260: END IF; -- lv_fed_amend_flag = 'Y'
261: END IF;
262: END LOOP; -- end of check amend flag

Line 268: -- hr_utility.trace('l_lockingactid_check : '||l_lockingactid_check);

264: END;
265: lv_flag_count := 0; -- Flag reset to 0 for the new employee
266: OPEN c_lockingactid_check(lockingactid);
267: FETCH c_lockingactid_check into l_lockingactid_check;
268: -- hr_utility.trace('l_lockingactid_check : '||l_lockingactid_check);
269: IF c_lockingactid_check%FOUND THEN
270: OPEN c_prev_mag(l_assignment_id
271: ,l_year_end
272: ,l_tax_unit_id

Line 281: hr_utility.trace(to_char(lockingactid)||' locked '||lv_report_type||' ID '||to_char(ln_asg_act_to_lock));

277: EXIT WHEN c_prev_mag%NOTFOUND;
278: IF c_prev_mag%FOUND THEN
279: BEGIN
280: hr_nonrun_asact.insint(lockingactid ,ln_asg_act_to_lock);
281: hr_utility.trace(to_char(lockingactid)||' locked '||lv_report_type||' ID '||to_char(ln_asg_act_to_lock));
282: END;
283: END IF; --c_prev_mag%Found
284: END LOOP;
285: CLOSE c_prev_mag;

Line 288: hr_utility.trace('x------------------------------------------------x');

284: END LOOP;
285: CLOSE c_prev_mag;
286: END IF; -- c_lockingactid_check%FOUND
287: CLOSE c_lockingactid_check;
288: hr_utility.trace('x------------------------------------------------x');
289: END LOOP; --c_all_asg loop
290: CLOSE c_all_asg;
291: hr_utility.trace('X=========================================================X');
292: END action_creation;

Line 291: hr_utility.trace('X=========================================================X');

287: CLOSE c_lockingactid_check;
288: hr_utility.trace('x------------------------------------------------x');
289: END LOOP; --c_all_asg loop
290: CLOSE c_all_asg;
291: hr_utility.trace('X=========================================================X');
292: END action_creation;
293: /**************************************************************************/
294: FUNCTION validate_gre_data ( p_trans IN VARCHAR2,
295: p_year IN VARCHAR2)

Line 373: hr_utility.trace('Inside the Validation Code');

369:
370: BEGIN
371: /* Fetching the Payroll Action Id for Trasnmitter GRE */
372:
373: hr_utility.trace('Inside the Validation Code');
374: hr_utility.trace('The Transmitter GRE id passed is '||p_trans);
375: OPEN c_trans_payid(p_trans,p_year);
376: FETCH c_trans_payid INTO l_trans_payid,l_bg_id;
377: IF c_trans_payid%NOTFOUND THEN

Line 374: hr_utility.trace('The Transmitter GRE id passed is '||p_trans);

370: BEGIN
371: /* Fetching the Payroll Action Id for Trasnmitter GRE */
372:
373: hr_utility.trace('Inside the Validation Code');
374: hr_utility.trace('The Transmitter GRE id passed is '||p_trans);
375: OPEN c_trans_payid(p_trans,p_year);
376: FETCH c_trans_payid INTO l_trans_payid,l_bg_id;
377: IF c_trans_payid%NOTFOUND THEN
378: CLOSE c_trans_payid;

Line 379: hr_utility.trace('The Transmitter GRE ID not found :'||p_trans);

375: OPEN c_trans_payid(p_trans,p_year);
376: FETCH c_trans_payid INTO l_trans_payid,l_bg_id;
377: IF c_trans_payid%NOTFOUND THEN
378: CLOSE c_trans_payid;
379: hr_utility.trace('The Transmitter GRE ID not found :'||p_trans);
380: hr_utility.raise_error;
381: RETURN '1';
382: ELSE
383: CLOSE c_trans_payid;

Line 380: hr_utility.raise_error;

376: FETCH c_trans_payid INTO l_trans_payid,l_bg_id;
377: IF c_trans_payid%NOTFOUND THEN
378: CLOSE c_trans_payid;
379: hr_utility.trace('The Transmitter GRE ID not found :'||p_trans);
380: hr_utility.raise_error;
381: RETURN '1';
382: ELSE
383: CLOSE c_trans_payid;
384: END IF;

Line 386: hr_utility.trace('Fetched the Payroll Id for transmitter GRE :'|| l_trans_payid);

382: ELSE
383: CLOSE c_trans_payid;
384: END IF;
385:
386: hr_utility.trace('Fetched the Payroll Id for transmitter GRE :'|| l_trans_payid);
387: hr_utility.trace('The Reporting Year is '||p_year);
388: /*Fetching the Trasnmitter Level Data */
389:
390: l_trans_no := get_arch_val(l_trans_payid, 'CAEOY_TRANSMITTER_NUMBER');

Line 387: hr_utility.trace('The Reporting Year is '||p_year);

383: CLOSE c_trans_payid;
384: END IF;
385:
386: hr_utility.trace('Fetched the Payroll Id for transmitter GRE :'|| l_trans_payid);
387: hr_utility.trace('The Reporting Year is '||p_year);
388: /*Fetching the Trasnmitter Level Data */
389:
390: l_trans_no := get_arch_val(l_trans_payid, 'CAEOY_TRANSMITTER_NUMBER');
391: l_tech_name := get_arch_val(l_trans_payid, 'CAEOY_TECHNICAL_CONTACT_NAME');

Line 405: hr_utility.trace('Transmitter Number :'||l_trans_no);

401: OPEN c_gre_name(to_number(p_trans));
402: FETCH c_gre_name INTO l_trans_name;
403: CLOSE c_gre_name;
404:
405: hr_utility.trace('Transmitter Number :'||l_trans_no);
406: hr_utility.trace('Tech Name : '||l_tech_name);
407: hr_utility.trace('Tech Area : '||l_tech_area);
408: hr_utility.trace('Tech Phone : '||l_tech_phno);
409: hr_utility.trace('Tech Email : '||l_tech_email);

Line 406: hr_utility.trace('Tech Name : '||l_tech_name);

402: FETCH c_gre_name INTO l_trans_name;
403: CLOSE c_gre_name;
404:
405: hr_utility.trace('Transmitter Number :'||l_trans_no);
406: hr_utility.trace('Tech Name : '||l_tech_name);
407: hr_utility.trace('Tech Area : '||l_tech_area);
408: hr_utility.trace('Tech Phone : '||l_tech_phno);
409: hr_utility.trace('Tech Email : '||l_tech_email);
410: hr_utility.trace('Tech Language : '||l_lang);

Line 407: hr_utility.trace('Tech Area : '||l_tech_area);

403: CLOSE c_gre_name;
404:
405: hr_utility.trace('Transmitter Number :'||l_trans_no);
406: hr_utility.trace('Tech Name : '||l_tech_name);
407: hr_utility.trace('Tech Area : '||l_tech_area);
408: hr_utility.trace('Tech Phone : '||l_tech_phno);
409: hr_utility.trace('Tech Email : '||l_tech_email);
410: hr_utility.trace('Tech Language : '||l_lang);
411:

Line 408: hr_utility.trace('Tech Phone : '||l_tech_phno);

404:
405: hr_utility.trace('Transmitter Number :'||l_trans_no);
406: hr_utility.trace('Tech Name : '||l_tech_name);
407: hr_utility.trace('Tech Area : '||l_tech_area);
408: hr_utility.trace('Tech Phone : '||l_tech_phno);
409: hr_utility.trace('Tech Email : '||l_tech_email);
410: hr_utility.trace('Tech Language : '||l_lang);
411:
412: /* Checking for the validity of the above values fetched */

Line 409: hr_utility.trace('Tech Email : '||l_tech_email);

405: hr_utility.trace('Transmitter Number :'||l_trans_no);
406: hr_utility.trace('Tech Name : '||l_tech_name);
407: hr_utility.trace('Tech Area : '||l_tech_area);
408: hr_utility.trace('Tech Phone : '||l_tech_phno);
409: hr_utility.trace('Tech Email : '||l_tech_email);
410: hr_utility.trace('Tech Language : '||l_lang);
411:
412: /* Checking for the validity of the above values fetched */
413: IF l_trans_no IS NULL

Line 410: hr_utility.trace('Tech Language : '||l_lang);

406: hr_utility.trace('Tech Name : '||l_tech_name);
407: hr_utility.trace('Tech Area : '||l_tech_area);
408: hr_utility.trace('Tech Phone : '||l_tech_phno);
409: hr_utility.trace('Tech Email : '||l_tech_email);
410: hr_utility.trace('Tech Language : '||l_lang);
411:
412: /* Checking for the validity of the above values fetched */
413: IF l_trans_no IS NULL
414: OR TRANSLATE(l_trans_no,'M0123456789','M9999999999') <> 'MM999999' THEN

Line 415: hr_utility.trace('Incorrect Transmitter No format');

411:
412: /* Checking for the validity of the above values fetched */
413: IF l_trans_no IS NULL
414: OR TRANSLATE(l_trans_no,'M0123456789','M9999999999') <> 'MM999999' THEN
415: hr_utility.trace('Incorrect Transmitter No format');
416: hr_utility.set_message(801,'PAY_74155_INCORRECT_TRANSMT_NO');
417: hr_utility.set_message_token('GRE_NAME',l_trans_name);
418: pay_core_utils.push_message(801,'PAY_74155_INCORRECT_TRANSMT_NO','P');
419: pay_core_utils.push_token('GRE_NAME',l_trans_name);

Line 416: hr_utility.set_message(801,'PAY_74155_INCORRECT_TRANSMT_NO');

412: /* Checking for the validity of the above values fetched */
413: IF l_trans_no IS NULL
414: OR TRANSLATE(l_trans_no,'M0123456789','M9999999999') <> 'MM999999' THEN
415: hr_utility.trace('Incorrect Transmitter No format');
416: hr_utility.set_message(801,'PAY_74155_INCORRECT_TRANSMT_NO');
417: hr_utility.set_message_token('GRE_NAME',l_trans_name);
418: pay_core_utils.push_message(801,'PAY_74155_INCORRECT_TRANSMT_NO','P');
419: pay_core_utils.push_token('GRE_NAME',l_trans_name);
420: hr_utility.raise_error;

Line 417: hr_utility.set_message_token('GRE_NAME',l_trans_name);

413: IF l_trans_no IS NULL
414: OR TRANSLATE(l_trans_no,'M0123456789','M9999999999') <> 'MM999999' THEN
415: hr_utility.trace('Incorrect Transmitter No format');
416: hr_utility.set_message(801,'PAY_74155_INCORRECT_TRANSMT_NO');
417: hr_utility.set_message_token('GRE_NAME',l_trans_name);
418: pay_core_utils.push_message(801,'PAY_74155_INCORRECT_TRANSMT_NO','P');
419: pay_core_utils.push_token('GRE_NAME',l_trans_name);
420: hr_utility.raise_error;
421: RETURN '1';

Line 420: hr_utility.raise_error;

416: hr_utility.set_message(801,'PAY_74155_INCORRECT_TRANSMT_NO');
417: hr_utility.set_message_token('GRE_NAME',l_trans_name);
418: pay_core_utils.push_message(801,'PAY_74155_INCORRECT_TRANSMT_NO','P');
419: pay_core_utils.push_token('GRE_NAME',l_trans_name);
420: hr_utility.raise_error;
421: RETURN '1';
422: END IF;
423:
424: IF l_tech_name IS NULL OR

Line 429: hr_utility.trace('Technical contact details missing');

425: l_tech_area IS NULL OR
426: l_tech_phno IS NULL OR
427: l_tech_email IS NULL OR
428: l_lang IS NULL THEN
429: hr_utility.trace('Technical contact details missing');
430: hr_utility.set_message(801,'PAY_74158_INCORRECT_TCHN_INFO');
431: hr_utility.set_message_token('GRE_NAME',l_trans_name);
432: pay_core_utils.push_message(801,'PAY_74158_INCORRECT_TCHN_INFO','P');
433: pay_core_utils.push_token('GRE_NAME',l_trans_name);

Line 430: hr_utility.set_message(801,'PAY_74158_INCORRECT_TCHN_INFO');

426: l_tech_phno IS NULL OR
427: l_tech_email IS NULL OR
428: l_lang IS NULL THEN
429: hr_utility.trace('Technical contact details missing');
430: hr_utility.set_message(801,'PAY_74158_INCORRECT_TCHN_INFO');
431: hr_utility.set_message_token('GRE_NAME',l_trans_name);
432: pay_core_utils.push_message(801,'PAY_74158_INCORRECT_TCHN_INFO','P');
433: pay_core_utils.push_token('GRE_NAME',l_trans_name);
434: hr_utility.raise_error;

Line 431: hr_utility.set_message_token('GRE_NAME',l_trans_name);

427: l_tech_email IS NULL OR
428: l_lang IS NULL THEN
429: hr_utility.trace('Technical contact details missing');
430: hr_utility.set_message(801,'PAY_74158_INCORRECT_TCHN_INFO');
431: hr_utility.set_message_token('GRE_NAME',l_trans_name);
432: pay_core_utils.push_message(801,'PAY_74158_INCORRECT_TCHN_INFO','P');
433: pay_core_utils.push_token('GRE_NAME',l_trans_name);
434: hr_utility.raise_error;
435: RETURN '1';

Line 434: hr_utility.raise_error;

430: hr_utility.set_message(801,'PAY_74158_INCORRECT_TCHN_INFO');
431: hr_utility.set_message_token('GRE_NAME',l_trans_name);
432: pay_core_utils.push_message(801,'PAY_74158_INCORRECT_TCHN_INFO','P');
433: pay_core_utils.push_token('GRE_NAME',l_trans_name);
434: hr_utility.raise_error;
435: RETURN '1';
436: END IF;
437:
438: IF l_acc_name IS NULL OR

Line 445: hr_utility.trace('The value of the Flag is '||l_acc_info_flag);

441: l_acc_info_flag := 'N';
442: ELSE
443: l_acc_info_flag := 'Y';
444: END IF;
445: hr_utility.trace('The value of the Flag is '||l_acc_info_flag);
446:
447: /* If Transmitter Level Accounting Information is Missing checking for the GRE level information */
448:
449: OPEN c_all_gres(p_trans,p_year,l_bg_id);

Line 452: hr_utility.trace('The Gre id fetched is '||l_gre);

448:
449: OPEN c_all_gres(p_trans,p_year,l_bg_id);
450: LOOP
451: FETCH c_all_gres into l_gre_payid, l_gre, l_gre_name;
452: hr_utility.trace('The Gre id fetched is '||l_gre);
453: IF c_all_gres%NOTFOUND THEN
454: CLOSE c_all_gres;
455: EXIT;
456: END IF;

Line 458: hr_utility.trace('Before fetching the GREs for this Transmitter '||l_gre||'-'||p_year);

454: CLOSE c_all_gres;
455: EXIT;
456: END IF;
457:
458: hr_utility.trace('Before fetching the GREs for this Transmitter '||l_gre||'-'||p_year);
459:
460:
461: IF l_gre <> to_number(p_trans) THEN
462: hr_utility.trace('Inside the loop'||l_gre_payid);

Line 462: hr_utility.trace('Inside the loop'||l_gre_payid);

458: hr_utility.trace('Before fetching the GREs for this Transmitter '||l_gre||'-'||p_year);
459:
460:
461: IF l_gre <> to_number(p_trans) THEN
462: hr_utility.trace('Inside the loop'||l_gre_payid);
463:
464: hr_utility.trace('Checking GRE level data');
465: hr_utility.trace('The Payroll Action Id for Gre is '|| l_gre_payid);
466: l_bus_no := get_arch_val(l_gre_payid,'CAEOY_EMPLOYER_IDENTIFICATION_NUMBER');

Line 464: hr_utility.trace('Checking GRE level data');

460:
461: IF l_gre <> to_number(p_trans) THEN
462: hr_utility.trace('Inside the loop'||l_gre_payid);
463:
464: hr_utility.trace('Checking GRE level data');
465: hr_utility.trace('The Payroll Action Id for Gre is '|| l_gre_payid);
466: l_bus_no := get_arch_val(l_gre_payid,'CAEOY_EMPLOYER_IDENTIFICATION_NUMBER');
467: l_acc_name := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_NAME');
468: l_acc_area := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_AREA_CODE');

Line 465: hr_utility.trace('The Payroll Action Id for Gre is '|| l_gre_payid);

461: IF l_gre <> to_number(p_trans) THEN
462: hr_utility.trace('Inside the loop'||l_gre_payid);
463:
464: hr_utility.trace('Checking GRE level data');
465: hr_utility.trace('The Payroll Action Id for Gre is '|| l_gre_payid);
466: l_bus_no := get_arch_val(l_gre_payid,'CAEOY_EMPLOYER_IDENTIFICATION_NUMBER');
467: l_acc_name := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_NAME');
468: l_acc_area := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_AREA_CODE');
469: l_acc_phno := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_PHONE');

Line 471: hr_utility.trace('Tax unit ID :'||l_tax_unit_id);

467: l_acc_name := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_NAME');
468: l_acc_area := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_AREA_CODE');
469: l_acc_phno := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_PHONE');
470:
471: hr_utility.trace('Tax unit ID :'||l_tax_unit_id);
472: hr_utility.trace('Acc Name :'||l_acc_name);
473: hr_utility.trace('Acc Area :'||l_acc_area);
474: hr_utility.trace('Acc Phone : '||l_acc_phno);
475: hr_utility.trace('GRE Name :'||l_gre_name);

Line 472: hr_utility.trace('Acc Name :'||l_acc_name);

468: l_acc_area := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_AREA_CODE');
469: l_acc_phno := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_PHONE');
470:
471: hr_utility.trace('Tax unit ID :'||l_tax_unit_id);
472: hr_utility.trace('Acc Name :'||l_acc_name);
473: hr_utility.trace('Acc Area :'||l_acc_area);
474: hr_utility.trace('Acc Phone : '||l_acc_phno);
475: hr_utility.trace('GRE Name :'||l_gre_name);
476:

Line 473: hr_utility.trace('Acc Area :'||l_acc_area);

469: l_acc_phno := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_PHONE');
470:
471: hr_utility.trace('Tax unit ID :'||l_tax_unit_id);
472: hr_utility.trace('Acc Name :'||l_acc_name);
473: hr_utility.trace('Acc Area :'||l_acc_area);
474: hr_utility.trace('Acc Phone : '||l_acc_phno);
475: hr_utility.trace('GRE Name :'||l_gre_name);
476:
477: IF l_bus_no IS NULL

Line 474: hr_utility.trace('Acc Phone : '||l_acc_phno);

470:
471: hr_utility.trace('Tax unit ID :'||l_tax_unit_id);
472: hr_utility.trace('Acc Name :'||l_acc_name);
473: hr_utility.trace('Acc Area :'||l_acc_area);
474: hr_utility.trace('Acc Phone : '||l_acc_phno);
475: hr_utility.trace('GRE Name :'||l_gre_name);
476:
477: IF l_bus_no IS NULL
478: OR TRANSLATE(l_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' THEN

Line 475: hr_utility.trace('GRE Name :'||l_gre_name);

471: hr_utility.trace('Tax unit ID :'||l_tax_unit_id);
472: hr_utility.trace('Acc Name :'||l_acc_name);
473: hr_utility.trace('Acc Area :'||l_acc_area);
474: hr_utility.trace('Acc Phone : '||l_acc_phno);
475: hr_utility.trace('GRE Name :'||l_gre_name);
476:
477: IF l_bus_no IS NULL
478: OR TRANSLATE(l_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' THEN
479: hr_utility.trace('No Business Number Entereed ');

Line 479: hr_utility.trace('No Business Number Entereed ');

475: hr_utility.trace('GRE Name :'||l_gre_name);
476:
477: IF l_bus_no IS NULL
478: OR TRANSLATE(l_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' THEN
479: hr_utility.trace('No Business Number Entereed ');
480: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
481: hr_utility.set_message_token('GRE_NAME',l_gre_name);
482: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
483: pay_core_utils.push_token('GRE_NAME',l_gre_name);

Line 480: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');

476:
477: IF l_bus_no IS NULL
478: OR TRANSLATE(l_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' THEN
479: hr_utility.trace('No Business Number Entereed ');
480: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
481: hr_utility.set_message_token('GRE_NAME',l_gre_name);
482: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
483: pay_core_utils.push_token('GRE_NAME',l_gre_name);
484: hr_utility.raise_error;

Line 481: hr_utility.set_message_token('GRE_NAME',l_gre_name);

477: IF l_bus_no IS NULL
478: OR TRANSLATE(l_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' THEN
479: hr_utility.trace('No Business Number Entereed ');
480: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
481: hr_utility.set_message_token('GRE_NAME',l_gre_name);
482: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
483: pay_core_utils.push_token('GRE_NAME',l_gre_name);
484: hr_utility.raise_error;
485: RETURN '1';

Line 484: hr_utility.raise_error;

480: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
481: hr_utility.set_message_token('GRE_NAME',l_gre_name);
482: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
483: pay_core_utils.push_token('GRE_NAME',l_gre_name);
484: hr_utility.raise_error;
485: RETURN '1';
486: END IF;
487:
488: IF (l_acc_name IS NULL OR

Line 492: hr_utility.trace('No Accounting Contact info present');

488: IF (l_acc_name IS NULL OR
489: l_acc_area IS NULL OR
490: l_acc_phno IS NULL ) AND
491: l_acc_info_flag = 'N' THEN
492: hr_utility.trace('No Accounting Contact info present');
493: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
494: hr_utility.set_message_token('GRE_NAME',l_gre_name);
495: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
496: pay_core_utils.push_token('GRE_NAME',l_gre_name);

Line 493: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');

489: l_acc_area IS NULL OR
490: l_acc_phno IS NULL ) AND
491: l_acc_info_flag = 'N' THEN
492: hr_utility.trace('No Accounting Contact info present');
493: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
494: hr_utility.set_message_token('GRE_NAME',l_gre_name);
495: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
496: pay_core_utils.push_token('GRE_NAME',l_gre_name);
497: hr_utility.raise_error;

Line 494: hr_utility.set_message_token('GRE_NAME',l_gre_name);

490: l_acc_phno IS NULL ) AND
491: l_acc_info_flag = 'N' THEN
492: hr_utility.trace('No Accounting Contact info present');
493: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
494: hr_utility.set_message_token('GRE_NAME',l_gre_name);
495: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
496: pay_core_utils.push_token('GRE_NAME',l_gre_name);
497: hr_utility.raise_error;
498: RETURN '1';

Line 497: hr_utility.raise_error;

493: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
494: hr_utility.set_message_token('GRE_NAME',l_gre_name);
495: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
496: pay_core_utils.push_token('GRE_NAME',l_gre_name);
497: hr_utility.raise_error;
498: RETURN '1';
499: END IF;
500:
501: ELSIF l_gre = to_number(p_trans) THEN

Line 505: hr_utility.trace('No Business Number Entereed ');

501: ELSIF l_gre = to_number(p_trans) THEN
502:
503: IF l_trans_bus_no IS NULL
504: OR TRANSLATE(l_trans_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' THEN
505: hr_utility.trace('No Business Number Entereed ');
506: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
507: hr_utility.set_message_token('GRE_NAME',l_trans_name);
508: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
509: pay_core_utils.push_token('GRE_NAME',l_trans_name);

Line 506: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');

502:
503: IF l_trans_bus_no IS NULL
504: OR TRANSLATE(l_trans_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' THEN
505: hr_utility.trace('No Business Number Entereed ');
506: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
507: hr_utility.set_message_token('GRE_NAME',l_trans_name);
508: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
509: pay_core_utils.push_token('GRE_NAME',l_trans_name);
510: hr_utility.raise_error;

Line 507: hr_utility.set_message_token('GRE_NAME',l_trans_name);

503: IF l_trans_bus_no IS NULL
504: OR TRANSLATE(l_trans_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' THEN
505: hr_utility.trace('No Business Number Entereed ');
506: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
507: hr_utility.set_message_token('GRE_NAME',l_trans_name);
508: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
509: pay_core_utils.push_token('GRE_NAME',l_trans_name);
510: hr_utility.raise_error;
511: RETURN '1';

Line 510: hr_utility.raise_error;

506: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
507: hr_utility.set_message_token('GRE_NAME',l_trans_name);
508: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
509: pay_core_utils.push_token('GRE_NAME',l_trans_name);
510: hr_utility.raise_error;
511: RETURN '1';
512: END IF;
513:
514: IF l_acc_info_flag = 'N' THEN

Line 515: hr_utility.trace('No Accounting Contact info present');

511: RETURN '1';
512: END IF;
513:
514: IF l_acc_info_flag = 'N' THEN
515: hr_utility.trace('No Accounting Contact info present');
516: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
517: hr_utility.set_message_token('GRE_NAME',l_trans_name);
518: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
519: pay_core_utils.push_token('GRE_NAME',l_trans_name);

Line 516: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');

512: END IF;
513:
514: IF l_acc_info_flag = 'N' THEN
515: hr_utility.trace('No Accounting Contact info present');
516: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
517: hr_utility.set_message_token('GRE_NAME',l_trans_name);
518: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
519: pay_core_utils.push_token('GRE_NAME',l_trans_name);
520: hr_utility.raise_error;

Line 517: hr_utility.set_message_token('GRE_NAME',l_trans_name);

513:
514: IF l_acc_info_flag = 'N' THEN
515: hr_utility.trace('No Accounting Contact info present');
516: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
517: hr_utility.set_message_token('GRE_NAME',l_trans_name);
518: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
519: pay_core_utils.push_token('GRE_NAME',l_trans_name);
520: hr_utility.raise_error;
521: RETURN '1';

Line 520: hr_utility.raise_error;

516: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
517: hr_utility.set_message_token('GRE_NAME',l_trans_name);
518: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
519: pay_core_utils.push_token('GRE_NAME',l_trans_name);
520: hr_utility.raise_error;
521: RETURN '1';
522: END IF;
523: END IF;
524: END LOOP;

Line 648: --hr_utility.trace('l_data='||l_data);

644: l_data := REPLACE(l_data, '"' , '&' || 'quot;');
645: --------------------------------------------------------
646: --- P_Datatype: T = Text, N = Number, C=Currency, D=Date
647: --------------------------------------------------------
648: --hr_utility.trace('l_data='||l_data);
649: IF p_datatype = 'T' OR p_datatype = 'D' THEN
650: l_output := '<' || trim(p_tag) || '>' || trim(l_data)
651: || ''||EOL;
652: -- hr_utility.trace('l_output='||l_output);

Line 652: -- hr_utility.trace('l_output='||l_output);

648: --hr_utility.trace('l_data='||l_data);
649: IF p_datatype = 'T' OR p_datatype = 'D' THEN
650: l_output := '<' || trim(p_tag) || '>' || trim(l_data)
651: || ''||EOL;
652: -- hr_utility.trace('l_output='||l_output);
653: ELSIF p_datatype = 'N' OR p_datatype = 'C' THEN
654: IF TRIM(p_format) IS NOT NULL THEN
655: SELECT to_char(to_number(p_data), p_format)
656: INTO l_data FROM dual;

Line 672: --hr_utility.trace('l_output='||l_output);

668: else l_data := l_data||'.00';
669: end if;
670: l_output := '<' || trim(p_tag) || '>' || trim(l_data) || '';
671: END IF;
672: --hr_utility.trace('l_output='||l_output);
673: RETURN l_output;
674: END;
675: /**************************************************************************/
676: FUNCTION get_t4_pp_regno(p_pactid IN NUMBER,

Line 763: hr_utility.trace('+==========================================================+');

759: T619_lang_cd NUMBER :=18;
760: T619_rpt_tcd NUMBER :=19;
761:
762: BEGIN
763: hr_utility.trace('+==========================================================+');
764: hr_utility.trace('XML Transmitter');
765:
766:
767: l_context1 := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');

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

760: T619_rpt_tcd NUMBER :=19;
761:
762: BEGIN
763: hr_utility.trace('+==========================================================+');
764: hr_utility.trace('XML Transmitter');
765:
766:
767: l_context1 := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
768: hr_utility.trace('PAYROLL_ACTION_ID l_context1 ='||l_context1);

Line 768: hr_utility.trace('PAYROLL_ACTION_ID l_context1 ='||l_context1);

764: hr_utility.trace('XML Transmitter');
765:
766:
767: l_context1 := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
768: hr_utility.trace('PAYROLL_ACTION_ID l_context1 ='||l_context1);
769:
770: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
771: 'CAEOY_TRANSMITTER_NUMBER');
772: IF l_return IS NULL THEN

Line 900: hr_utility.set_location('Error in T4 Transmitter record',10);

896: tab_transmitter(T619_lang_cd)
897: := convert_2_xml(l_return,'lang_cd');
898: ----
899: IF l_status = FALSE THEN
900: hr_utility.set_location('Error in T4 Transmitter record',10);
901: hr_utility.set_location('Error in the following fields: ' || l_field_name,10);
902: hr_utility.raise_error;
903: END IF;
904: ----

Line 901: hr_utility.set_location('Error in the following fields: ' || l_field_name,10);

897: := convert_2_xml(l_return,'lang_cd');
898: ----
899: IF l_status = FALSE THEN
900: hr_utility.set_location('Error in T4 Transmitter record',10);
901: hr_utility.set_location('Error in the following fields: ' || l_field_name,10);
902: hr_utility.raise_error;
903: END IF;
904: ----
905: l_final_xml := '' || EOL

Line 902: hr_utility.raise_error;

898: ----
899: IF l_status = FALSE THEN
900: hr_utility.set_location('Error in T4 Transmitter record',10);
901: hr_utility.set_location('Error in the following fields: ' || l_field_name,10);
902: hr_utility.raise_error;
903: END IF;
904: ----
905: l_final_xml := '' || EOL
906: || ''|| EOL||

Line 932: hr_utility.trace(l_final_xml);

928: tab_transmitter(T619_cntc_extn_nbr)||
929: tab_transmitter(T619_cntc_email_area)||
930: '' || EOL||
931: '' || EOL;
932: hr_utility.trace(l_final_xml);
933: pay_core_files.write_to_magtape_lob(l_final_xml);
934: hr_utility.trace('X==========================================================X');
935: END;
936: END t4_amend_mag_transmitter;

Line 934: hr_utility.trace('X==========================================================X');

930: '' || EOL||
931: '' || EOL;
932: hr_utility.trace(l_final_xml);
933: pay_core_files.write_to_magtape_lob(l_final_xml);
934: hr_utility.trace('X==========================================================X');
935: END;
936: END t4_amend_mag_transmitter;
937: /*****************************************************************************/
938:

Line 944: hr_utility.trace('+==========================================================+');

940: BEGIN
941: DECLARE
942: l_final_xml_string VARCHAR2(32000);
943: BEGIN
944: hr_utility.trace('+==========================================================+');
945: hr_utility.trace('Entering end_of_file');
946: l_final_xml_string := '';
947:
948: hr_utility.trace(l_final_xml_string );

Line 945: hr_utility.trace('Entering end_of_file');

941: DECLARE
942: l_final_xml_string VARCHAR2(32000);
943: BEGIN
944: hr_utility.trace('+==========================================================+');
945: hr_utility.trace('Entering end_of_file');
946: l_final_xml_string := '';
947:
948: hr_utility.trace(l_final_xml_string );
949: pay_core_files.write_to_magtape_lob(l_final_xml_string);

Line 948: hr_utility.trace(l_final_xml_string );

944: hr_utility.trace('+==========================================================+');
945: hr_utility.trace('Entering end_of_file');
946: l_final_xml_string := '';
947:
948: hr_utility.trace(l_final_xml_string );
949: pay_core_files.write_to_magtape_lob(l_final_xml_string);
950: hr_utility.trace('Exiting end_of_file');
951: hr_utility.trace('X==========================================================X');
952: END;

Line 950: hr_utility.trace('Exiting end_of_file');

946: l_final_xml_string := '';
947:
948: hr_utility.trace(l_final_xml_string );
949: pay_core_files.write_to_magtape_lob(l_final_xml_string);
950: hr_utility.trace('Exiting end_of_file');
951: hr_utility.trace('X==========================================================X');
952: END;
953: END end_of_file;
954: /*****************************************************************************/

Line 951: hr_utility.trace('X==========================================================X');

947:
948: hr_utility.trace(l_final_xml_string );
949: pay_core_files.write_to_magtape_lob(l_final_xml_string);
950: hr_utility.trace('Exiting end_of_file');
951: hr_utility.trace('X==========================================================X');
952: END;
953: END end_of_file;
954: /*****************************************************************************/
955:

Line 964: hr_utility.trace('+==========================================================+');

960: EOL VARCHAR2(5) := fnd_global.local_chr(13)
961: || fnd_global.local_chr(10);
962:
963: BEGIN
964: hr_utility.trace('+==========================================================+');
965: hr_utility.trace('Entering t4_amend_employer_start');
966: l_final_xml_string := ''||EOL||''||EOL;
967: hr_utility.trace(l_final_xml_string);
968: pay_core_files.write_to_magtape_lob(l_final_xml_string);

Line 965: hr_utility.trace('Entering t4_amend_employer_start');

961: || fnd_global.local_chr(10);
962:
963: BEGIN
964: hr_utility.trace('+==========================================================+');
965: hr_utility.trace('Entering t4_amend_employer_start');
966: l_final_xml_string := ''||EOL||''||EOL;
967: hr_utility.trace(l_final_xml_string);
968: pay_core_files.write_to_magtape_lob(l_final_xml_string);
969: hr_utility.trace('Exiting t4_amend_employer_start');

Line 967: hr_utility.trace(l_final_xml_string);

963: BEGIN
964: hr_utility.trace('+==========================================================+');
965: hr_utility.trace('Entering t4_amend_employer_start');
966: l_final_xml_string := ''||EOL||''||EOL;
967: hr_utility.trace(l_final_xml_string);
968: pay_core_files.write_to_magtape_lob(l_final_xml_string);
969: hr_utility.trace('Exiting t4_amend_employer_start');
970: hr_utility.trace('X==========================================================X');
971: END;

Line 969: hr_utility.trace('Exiting t4_amend_employer_start');

965: hr_utility.trace('Entering t4_amend_employer_start');
966: l_final_xml_string := ''||EOL||''||EOL;
967: hr_utility.trace(l_final_xml_string);
968: pay_core_files.write_to_magtape_lob(l_final_xml_string);
969: hr_utility.trace('Exiting t4_amend_employer_start');
970: hr_utility.trace('X==========================================================X');
971: END;
972: END t4_amend_employer_start;
973:

Line 970: hr_utility.trace('X==========================================================X');

966: l_final_xml_string := ''||EOL||''||EOL;
967: hr_utility.trace(l_final_xml_string);
968: pay_core_files.write_to_magtape_lob(l_final_xml_string);
969: hr_utility.trace('Exiting t4_amend_employer_start');
970: hr_utility.trace('X==========================================================X');
971: END;
972: END t4_amend_employer_start;
973:
974: /*****************************************************************************/

Line 1016: hr_utility.trace('+==========================================================+');

1012: T4Summary_pprtr_2_sin NUMBER :=20;
1013: T4Summary_rpt_tcd NUMBER :=21;
1014:
1015: BEGIN
1016: hr_utility.trace('+==========================================================+');
1017: hr_utility.trace('Entering t4_amend_employer_record');
1018: l_context1 := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
1019: l_transfer_pact_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
1020: l_transfer_tax_unit_id := pay_magtape_generic.get_parameter_value('TRANSMITTER_GRE');

Line 1017: hr_utility.trace('Entering t4_amend_employer_record');

1013: T4Summary_rpt_tcd NUMBER :=21;
1014:
1015: BEGIN
1016: hr_utility.trace('+==========================================================+');
1017: hr_utility.trace('Entering t4_amend_employer_record');
1018: l_context1 := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
1019: l_transfer_pact_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
1020: l_transfer_tax_unit_id := pay_magtape_generic.get_parameter_value('TRANSMITTER_GRE');
1021: l_transfer_ei_er_rate := pay_magtape_generic.get_parameter_value('TRANSFER_EI_ER_RATE');

Line 1023: hr_utility.trace('PAYROLL_ACTION_ID l_context1 = ' ||l_context1);

1019: l_transfer_pact_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
1020: l_transfer_tax_unit_id := pay_magtape_generic.get_parameter_value('TRANSMITTER_GRE');
1021: l_transfer_ei_er_rate := pay_magtape_generic.get_parameter_value('TRANSFER_EI_ER_RATE');
1022:
1023: hr_utility.trace('PAYROLL_ACTION_ID l_context1 = ' ||l_context1);
1024: hr_utility.trace('TRANSFER_PAYROLL_ACTION_ID l_transfer_pact_id = ' ||l_transfer_pact_id);
1025: hr_utility.trace('TRANSMITTER_GRE l_transfer_tax_unit_id = ' ||l_transfer_tax_unit_id);
1026: hr_utility.trace('TRANSFER_EI_ER_RATE l_transfer_ei_er_rate = ' ||l_transfer_ei_er_rate);
1027: ----

Line 1024: hr_utility.trace('TRANSFER_PAYROLL_ACTION_ID l_transfer_pact_id = ' ||l_transfer_pact_id);

1020: l_transfer_tax_unit_id := pay_magtape_generic.get_parameter_value('TRANSMITTER_GRE');
1021: l_transfer_ei_er_rate := pay_magtape_generic.get_parameter_value('TRANSFER_EI_ER_RATE');
1022:
1023: hr_utility.trace('PAYROLL_ACTION_ID l_context1 = ' ||l_context1);
1024: hr_utility.trace('TRANSFER_PAYROLL_ACTION_ID l_transfer_pact_id = ' ||l_transfer_pact_id);
1025: hr_utility.trace('TRANSMITTER_GRE l_transfer_tax_unit_id = ' ||l_transfer_tax_unit_id);
1026: hr_utility.trace('TRANSFER_EI_ER_RATE l_transfer_ei_er_rate = ' ||l_transfer_ei_er_rate);
1027: ----
1028: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

Line 1025: hr_utility.trace('TRANSMITTER_GRE l_transfer_tax_unit_id = ' ||l_transfer_tax_unit_id);

1021: l_transfer_ei_er_rate := pay_magtape_generic.get_parameter_value('TRANSFER_EI_ER_RATE');
1022:
1023: hr_utility.trace('PAYROLL_ACTION_ID l_context1 = ' ||l_context1);
1024: hr_utility.trace('TRANSFER_PAYROLL_ACTION_ID l_transfer_pact_id = ' ||l_transfer_pact_id);
1025: hr_utility.trace('TRANSMITTER_GRE l_transfer_tax_unit_id = ' ||l_transfer_tax_unit_id);
1026: hr_utility.trace('TRANSFER_EI_ER_RATE l_transfer_ei_er_rate = ' ||l_transfer_ei_er_rate);
1027: ----
1028: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1029: 'CAEOY_GRE_EI_RATE');

Line 1026: hr_utility.trace('TRANSFER_EI_ER_RATE l_transfer_ei_er_rate = ' ||l_transfer_ei_er_rate);

1022:
1023: hr_utility.trace('PAYROLL_ACTION_ID l_context1 = ' ||l_context1);
1024: hr_utility.trace('TRANSFER_PAYROLL_ACTION_ID l_transfer_pact_id = ' ||l_transfer_pact_id);
1025: hr_utility.trace('TRANSMITTER_GRE l_transfer_tax_unit_id = ' ||l_transfer_tax_unit_id);
1026: hr_utility.trace('TRANSFER_EI_ER_RATE l_transfer_ei_er_rate = ' ||l_transfer_ei_er_rate);
1027: ----
1028: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1029: 'CAEOY_GRE_EI_RATE');
1030: hr_utility.trace('CAEOY_GRE_EI_RATE = ' ||l_return);

Line 1030: hr_utility.trace('CAEOY_GRE_EI_RATE = ' ||l_return);

1026: hr_utility.trace('TRANSFER_EI_ER_RATE l_transfer_ei_er_rate = ' ||l_transfer_ei_er_rate);
1027: ----
1028: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1029: 'CAEOY_GRE_EI_RATE');
1030: hr_utility.trace('CAEOY_GRE_EI_RATE = ' ||l_return);
1031: IF (l_return IS NULL) OR (to_number(l_return) = 0) THEN
1032: tab_employer(EIRate):= convert_2_xml(l_transfer_ei_er_rate,'EIRate');
1033: ELSE
1034: tab_employer(EIRate):= convert_2_xml(l_return,'EIRate');

Line 1172: hr_utility.trace(l_final_xml_string);

1168: ''||EOL||
1169: tab_employer(T4Summary_rpt_tcd)||
1170: '' || EOL||
1171: ''||EOL||''||EOL;
1172: hr_utility.trace(l_final_xml_string);
1173: pay_core_files.write_to_magtape_lob(l_final_xml_string);
1174: hr_utility.trace('X==========================================================X');
1175: END;
1176: END t4_amend_employer_record;

Line 1174: hr_utility.trace('X==========================================================X');

1170: '' || EOL||
1171: ''||EOL||''||EOL;
1172: hr_utility.trace(l_final_xml_string);
1173: pay_core_files.write_to_magtape_lob(l_final_xml_string);
1174: hr_utility.trace('X==========================================================X');
1175: END;
1176: END t4_amend_employer_record;
1177: /*****************************************************************************/
1178:

Line 1354: hr_utility.trace('+==========================================================+');

1350: AND ffc.context_name = 'JURISDICTION_CODE'
1351: AND fai.value='Y';
1352:
1353: BEGIN
1354: hr_utility.trace('+==========================================================+');
1355: hr_utility.trace('Employee Record');
1356: /* DBIs of other info amounts */
1357: tab_other_info_dbi(1) := 'CAEOY_T4_OTHER_INFO_AMOUNT30_PER_JD_GRE_YTD';
1358: tab_other_info_dbi(2) := 'CAEOY_T4_OTHER_INFO_AMOUNT31_PER_JD_GRE_YTD';

Line 1355: hr_utility.trace('Employee Record');

1351: AND fai.value='Y';
1352:
1353: BEGIN
1354: hr_utility.trace('+==========================================================+');
1355: hr_utility.trace('Employee Record');
1356: /* DBIs of other info amounts */
1357: tab_other_info_dbi(1) := 'CAEOY_T4_OTHER_INFO_AMOUNT30_PER_JD_GRE_YTD';
1358: tab_other_info_dbi(2) := 'CAEOY_T4_OTHER_INFO_AMOUNT31_PER_JD_GRE_YTD';
1359: tab_other_info_dbi(3) := 'CAEOY_T4_OTHER_INFO_AMOUNT32_PER_JD_GRE_YTD';

Line 1438: hr_utility.trace('T4_AMEND_MAG Payroll action ='||l_payroll_actid);

1434: tab_other_info_tag(35) := 'vlntr_firefighter_xmpt_amt'; -- for bug 13087483
1435: --
1436: l_payroll_actid := to_number(pay_magtape_generic.get_parameter_value
1437: ('TRANSFER_PAYROLL_ACTION_ID'));
1438: hr_utility.trace('T4_AMEND_MAG Payroll action ='||l_payroll_actid);
1439: --
1440: l_mag_asg_action_id := to_number(pay_magtape_generic.get_parameter_value
1441: ('TRANSFER_ACT_ID'));
1442: hr_utility.trace('T4_AMEND_MAG Assignment action ='|| to_char(l_mag_asg_action_id));

Line 1442: hr_utility.trace('T4_AMEND_MAG Assignment action ='|| to_char(l_mag_asg_action_id));

1438: hr_utility.trace('T4_AMEND_MAG Payroll action ='||l_payroll_actid);
1439: --
1440: l_mag_asg_action_id := to_number(pay_magtape_generic.get_parameter_value
1441: ('TRANSFER_ACT_ID'));
1442: hr_utility.trace('T4_AMEND_MAG Assignment action ='|| to_char(l_mag_asg_action_id));
1443:
1444: --
1445: OPEN c_get_payroll_asg_actid(l_mag_asg_action_id);
1446: FETCH c_get_payroll_asg_actid INTO l_arch_action_id, l_arch_pay_actid;

Line 1448: hr_utility.trace('Archiver Assignment action='|| l_arch_action_id);

1444: --
1445: OPEN c_get_payroll_asg_actid(l_mag_asg_action_id);
1446: FETCH c_get_payroll_asg_actid INTO l_arch_action_id, l_arch_pay_actid;
1447: CLOSE c_get_payroll_asg_actid;
1448: hr_utility.trace('Archiver Assignment action='|| l_arch_action_id);
1449: hr_utility.trace('Archiver Payroll action='|| l_arch_pay_actid);
1450: --
1451: OPEN c_get_max_values(l_payroll_actid);
1452: FETCH c_get_max_values INTO transfer_cpp_max, transfer_ei_max,transfer_ppip_max;

Line 1449: hr_utility.trace('Archiver Payroll action='|| l_arch_pay_actid);

1445: OPEN c_get_payroll_asg_actid(l_mag_asg_action_id);
1446: FETCH c_get_payroll_asg_actid INTO l_arch_action_id, l_arch_pay_actid;
1447: CLOSE c_get_payroll_asg_actid;
1448: hr_utility.trace('Archiver Assignment action='|| l_arch_action_id);
1449: hr_utility.trace('Archiver Payroll action='|| l_arch_pay_actid);
1450: --
1451: OPEN c_get_max_values(l_payroll_actid);
1452: FETCH c_get_max_values INTO transfer_cpp_max, transfer_ei_max,transfer_ppip_max;
1453: CLOSE c_get_max_values;

Line 1454: hr_utility.trace('TRANSFER_CPP_MAX = '||transfer_cpp_max);

1450: --
1451: OPEN c_get_max_values(l_payroll_actid);
1452: FETCH c_get_max_values INTO transfer_cpp_max, transfer_ei_max,transfer_ppip_max;
1453: CLOSE c_get_max_values;
1454: hr_utility.trace('TRANSFER_CPP_MAX = '||transfer_cpp_max);
1455: hr_utility.trace('TRANSFER_EI_MAX = '||transfer_ei_max);
1456: hr_utility.trace('transfer_ppip_max = '||transfer_ppip_max);
1457: --
1458: lv_ei_display_flag := 1;

Line 1455: hr_utility.trace('TRANSFER_EI_MAX = '||transfer_ei_max);

1451: OPEN c_get_max_values(l_payroll_actid);
1452: FETCH c_get_max_values INTO transfer_cpp_max, transfer_ei_max,transfer_ppip_max;
1453: CLOSE c_get_max_values;
1454: hr_utility.trace('TRANSFER_CPP_MAX = '||transfer_cpp_max);
1455: hr_utility.trace('TRANSFER_EI_MAX = '||transfer_ei_max);
1456: hr_utility.trace('transfer_ppip_max = '||transfer_ppip_max);
1457: --
1458: lv_ei_display_flag := 1;
1459: OPEN c_get_t4_ei_earn_display(l_arch_action_id);

Line 1456: hr_utility.trace('transfer_ppip_max = '||transfer_ppip_max);

1452: FETCH c_get_max_values INTO transfer_cpp_max, transfer_ei_max,transfer_ppip_max;
1453: CLOSE c_get_max_values;
1454: hr_utility.trace('TRANSFER_CPP_MAX = '||transfer_cpp_max);
1455: hr_utility.trace('TRANSFER_EI_MAX = '||transfer_ei_max);
1456: hr_utility.trace('transfer_ppip_max = '||transfer_ppip_max);
1457: --
1458: lv_ei_display_flag := 1;
1459: OPEN c_get_t4_ei_earn_display(l_arch_action_id);
1460: FETCH c_get_t4_ei_earn_display INTO lv_ei_display_flag;

Line 1462: hr_utility.trace('lv_ei_display_flag ='||lv_ei_display_flag);

1458: lv_ei_display_flag := 1;
1459: OPEN c_get_t4_ei_earn_display(l_arch_action_id);
1460: FETCH c_get_t4_ei_earn_display INTO lv_ei_display_flag;
1461: CLOSE c_get_t4_ei_earn_display;
1462: hr_utility.trace('lv_ei_display_flag ='||lv_ei_display_flag);
1463:
1464: /*****************************************************************************/
1465: /* T4Slip Tags begin*/
1466: OPEN c_get_person_id(l_mag_asg_action_id);

Line 1469: hr_utility.trace('Person ID ='||l_person_id);

1465: /* T4Slip Tags begin*/
1466: OPEN c_get_person_id(l_mag_asg_action_id);
1467: FETCH c_get_person_id INTO l_person_id;
1468: CLOSE c_get_person_id;
1469: hr_utility.trace('Person ID ='||l_person_id);
1470: ----1
1471: l_return := pay_ca_emp_address_dtls.get_emp_address(l_person_id,
1472: l_address_line1,
1473: l_address_line2,

Line 1559: hr_utility.trace('Jurisdiction Code ='|| to_char(l_jurisdiction_code));

1555: OPEN c_get_amended_jurisdictions(l_arch_action_id);
1556: LOOP -- Loop through each amended jurisdiction of the employee
1557: FETCH c_get_amended_jurisdictions INTO l_jurisdiction_code;
1558: EXIT WHEN c_get_amended_jurisdictions%NOTFOUND;
1559: hr_utility.trace('Jurisdiction Code ='|| to_char(l_jurisdiction_code));
1560: l_status := l_name_status;
1561: l_error_message := l_name_error_message;
1562: l_other_info_count := 0;
1563: l_other_info_sets := 1;

Line 1843: hr_utility.trace('Status = Success');

1839: /* T4_AMT Tags end */
1840: /*****************************************************************************/
1841: /* OTH_INFO Tags begin */
1842: IF l_status THEN
1843: hr_utility.trace('Status = Success');
1844: ELSE
1845: hr_utility.trace('Status = Fail');
1846: END IF;
1847:

Line 1845: hr_utility.trace('Status = Fail');

1841: /* OTH_INFO Tags begin */
1842: IF l_status THEN
1843: hr_utility.trace('Status = Success');
1844: ELSE
1845: hr_utility.trace('Status = Fail');
1846: END IF;
1847:
1848:
1849: FOR i IN 1..tab_other_info_dbi.COUNT LOOP

Line 1895: hr_utility.trace('Other_info_count = '||l_other_info_count ||', Other_info_sets = '||l_other_info_sets);

1891: END IF;
1892: END IF;
1893: END LOOP;
1894:
1895: hr_utility.trace('Other_info_count = '||l_other_info_count ||', Other_info_sets = '||l_other_info_sets);
1896:
1897: /* OTH_INFO Tags end */
1898: /*****************************************************************************/
1899: /* Final XML Generation begin */

Line 1935: hr_utility.trace(l_all_final_xml_string);

1931: END IF;
1932: l_all_final_xml_string := l_all_final_xml_string||l_final_xml_string;
1933: END LOOP;-- End of Loop for amended Jurisdiction.
1934: CLOSE c_get_amended_jurisdictions;
1935: hr_utility.trace(l_all_final_xml_string);
1936: pay_core_files.write_to_magtape_lob(l_all_final_xml_string);
1937: hr_utility.trace('X==========================================================X');
1938:
1939: /* Final XML Generation end */

Line 1937: hr_utility.trace('X==========================================================X');

1933: END LOOP;-- End of Loop for amended Jurisdiction.
1934: CLOSE c_get_amended_jurisdictions;
1935: hr_utility.trace(l_all_final_xml_string);
1936: pay_core_files.write_to_magtape_lob(l_all_final_xml_string);
1937: hr_utility.trace('X==========================================================X');
1938:
1939: /* Final XML Generation end */
1940: /*****************************************************************************/
1941: END;