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

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

197: -- l_paa_update_check pay_assignment_actions.assignment_action_id%TYPE;
198: l_lockingactid_check pay_assignment_actions.assignment_action_id%TYPE;
199:
200: BEGIN
201: hr_utility.trace('+=========================================================+');
202: hr_utility.set_location( 'pay_ca_t4a_amend_mag.action_creation',10);
203: get_report_parameters(
204: p_pactid,
205: l_legislative_parameters,

Line 202: hr_utility.set_location( 'pay_ca_t4a_amend_mag.action_creation',10);

198: l_lockingactid_check pay_assignment_actions.assignment_action_id%TYPE;
199:
200: BEGIN
201: hr_utility.trace('+=========================================================+');
202: hr_utility.set_location( 'pay_ca_t4a_amend_mag.action_creation',10);
203: get_report_parameters(
204: p_pactid,
205: l_legislative_parameters,
206: l_year_end,

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

208: l_business_group_id);
209:
210: l_trans_gre := pay_ca_t4a_amend_mag.get_parameter('TRANSMITTER_GRE',
211: l_legislative_parameters);
212: hr_utility.trace('l_trans_gre ='||l_trans_gre);
213: --
214: l_validate_gre := validate_gre_data(l_trans_gre, to_char(l_year_end,'YYYY'));
215: IF l_validate_gre = '1' THEN
216: hr_utility.raise_error;

Line 216: hr_utility.raise_error;

212: hr_utility.trace('l_trans_gre ='||l_trans_gre);
213: --
214: l_validate_gre := validate_gre_data(l_trans_gre, to_char(l_year_end,'YYYY'));
215: IF l_validate_gre = '1' THEN
216: hr_utility.raise_error;
217: END IF;
218: --
219: OPEN c_get_ue_id('CAEOY_T4A_AMENDMENT_FLAG');
220: FETCH c_get_ue_id into ln_t4a_amend_flag_ue_id;

Line 230: hr_utility.set_location('pay_ca_t4a_amend_mag.action_creation', 20);

226: l_assignment_id,
227: l_tax_unit_id,
228: l_effective_end_date,
229: l_assignment_action_id;
230: hr_utility.set_location('pay_ca_t4a_amend_mag.action_creation', 20);
231: EXIT WHEN c_all_asg%NOTFOUND;
232:
233: hr_utility.trace('+------------------------------------------------+');
234: hr_utility.trace('Fetched Assignment ID : '|| to_char(l_assignment_id));

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

229: l_assignment_action_id;
230: hr_utility.set_location('pay_ca_t4a_amend_mag.action_creation', 20);
231: EXIT WHEN c_all_asg%NOTFOUND;
232:
233: hr_utility.trace('+------------------------------------------------+');
234: hr_utility.trace('Fetched Assignment ID : '|| to_char(l_assignment_id));
235: hr_utility.trace('Person ID : '|| to_char(l_person_id));
236: hr_utility.trace('Tax Unit ID : '|| to_char(l_tax_unit_id));
237: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date,'DD-Mon-YYYY'));

Line 234: hr_utility.trace('Fetched Assignment ID : '|| to_char(l_assignment_id));

230: hr_utility.set_location('pay_ca_t4a_amend_mag.action_creation', 20);
231: EXIT WHEN c_all_asg%NOTFOUND;
232:
233: hr_utility.trace('+------------------------------------------------+');
234: hr_utility.trace('Fetched Assignment ID : '|| to_char(l_assignment_id));
235: hr_utility.trace('Person ID : '|| to_char(l_person_id));
236: hr_utility.trace('Tax Unit ID : '|| to_char(l_tax_unit_id));
237: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date,'DD-Mon-YYYY'));
238: hr_utility.trace('x------------------------------------------------x');

Line 235: hr_utility.trace('Person ID : '|| to_char(l_person_id));

231: EXIT WHEN c_all_asg%NOTFOUND;
232:
233: hr_utility.trace('+------------------------------------------------+');
234: hr_utility.trace('Fetched Assignment ID : '|| to_char(l_assignment_id));
235: hr_utility.trace('Person ID : '|| to_char(l_person_id));
236: hr_utility.trace('Tax Unit ID : '|| to_char(l_tax_unit_id));
237: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date,'DD-Mon-YYYY'));
238: hr_utility.trace('x------------------------------------------------x');
239: SELECT pay_assignment_actions_s.nextval

Line 236: hr_utility.trace('Tax Unit ID : '|| to_char(l_tax_unit_id));

232:
233: hr_utility.trace('+------------------------------------------------+');
234: hr_utility.trace('Fetched Assignment ID : '|| to_char(l_assignment_id));
235: hr_utility.trace('Person ID : '|| to_char(l_person_id));
236: hr_utility.trace('Tax Unit ID : '|| to_char(l_tax_unit_id));
237: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date,'DD-Mon-YYYY'));
238: hr_utility.trace('x------------------------------------------------x');
239: SELECT pay_assignment_actions_s.nextval
240: INTO lockingactid

Line 237: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date,'DD-Mon-YYYY'));

233: hr_utility.trace('+------------------------------------------------+');
234: hr_utility.trace('Fetched Assignment ID : '|| to_char(l_assignment_id));
235: hr_utility.trace('Person ID : '|| to_char(l_person_id));
236: hr_utility.trace('Tax Unit ID : '|| to_char(l_tax_unit_id));
237: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date,'DD-Mon-YYYY'));
238: hr_utility.trace('x------------------------------------------------x');
239: SELECT pay_assignment_actions_s.nextval
240: INTO lockingactid
241: FROM dual;

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

234: hr_utility.trace('Fetched Assignment ID : '|| to_char(l_assignment_id));
235: hr_utility.trace('Person ID : '|| to_char(l_person_id));
236: hr_utility.trace('Tax Unit ID : '|| to_char(l_tax_unit_id));
237: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date,'DD-Mon-YYYY'));
238: hr_utility.trace('x------------------------------------------------x');
239: SELECT pay_assignment_actions_s.nextval
240: INTO lockingactid
241: FROM dual;
242: hr_utility.trace('New T4A Amend Action = ' ||to_char(lockingactid));

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

238: hr_utility.trace('x------------------------------------------------x');
239: SELECT pay_assignment_actions_s.nextval
240: INTO lockingactid
241: FROM dual;
242: hr_utility.trace('New T4A Amend Action = ' ||to_char(lockingactid));
243:
244: BEGIN
245: OPEN c_get_fed_amend_flag(l_assignment_action_id,
246: ln_t4a_amend_flag_ue_id);

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

247: LOOP -- check amend flag
248: lv_fed_amend_flag := 'N';
249: FETCH c_get_fed_amend_flag into lv_fed_amend_flag;
250: EXIT when c_get_fed_amend_flag%NOTFOUND;
251: hr_utility.trace('Amended : '||lv_fed_amend_flag);
252: IF c_get_fed_amend_flag%FOUND THEN
253: IF lv_fed_amend_flag = 'Y' AND lv_flag_count =0 THEN
254: -- Insert into pay_assignment_actions.
255: -- hr_utility.set_location('pay_ca_t4a_amend_mag.action_creation', 80);

Line 255: -- hr_utility.set_location('pay_ca_t4a_amend_mag.action_creation', 80);

251: hr_utility.trace('Amended : '||lv_fed_amend_flag);
252: IF c_get_fed_amend_flag%FOUND THEN
253: IF lv_fed_amend_flag = 'Y' AND lv_flag_count =0 THEN
254: -- Insert into pay_assignment_actions.
255: -- hr_utility.set_location('pay_ca_t4a_amend_mag.action_creation', 80);
256: hr_nonrun_asact.insact(lockingactid
257: ,l_assignment_id
258: ,p_pactid
259: ,p_chunk

Line 261: -- hr_utility.set_location('pay_ca_t4a_amend_mag.action_creation', 90);

257: ,l_assignment_id
258: ,p_pactid
259: ,p_chunk
260: ,l_tax_unit_id);
261: -- hr_utility.set_location('pay_ca_t4a_amend_mag.action_creation', 90);
262: UPDATE pay_assignment_actions aa
263: SET aa.serial_number = to_char(l_person_id)
264: WHERE aa.assignment_action_id = lockingactid;
265:

Line 266: -- hr_utility.set_location('pay_ca_t4a_amend_mag.action_creation', 100);

262: UPDATE pay_assignment_actions aa
263: SET aa.serial_number = to_char(l_person_id)
264: WHERE aa.assignment_action_id = lockingactid;
265:
266: -- hr_utility.set_location('pay_ca_t4a_amend_mag.action_creation', 100);
267: hr_nonrun_asact.insint(lockingactid ,l_assignment_action_id);
268:
269: hr_utility.trace(to_char(lockingactid)||' locked Amend Archiver ID '||to_char(l_assignment_action_id));
270: lv_flag_count := lv_flag_count + 1;

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

265:
266: -- hr_utility.set_location('pay_ca_t4a_amend_mag.action_creation', 100);
267: hr_nonrun_asact.insint(lockingactid ,l_assignment_action_id);
268:
269: hr_utility.trace(to_char(lockingactid)||' locked Amend Archiver ID '||to_char(l_assignment_action_id));
270: lv_flag_count := lv_flag_count + 1;
271: END IF; -- lv_fed_amend_flag = 'Y'
272: END IF;
273: END LOOP; -- end of check amend flag

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

275: END;
276: lv_flag_count := 0; -- Flag reset to 0 for the new employee
277: OPEN c_lockingactid_check(lockingactid);
278: FETCH c_lockingactid_check into l_lockingactid_check;
279: -- hr_utility.trace('l_lockingactid_check : '||l_lockingactid_check);
280: IF c_lockingactid_check%FOUND THEN
281: OPEN c_prev_mag(l_assignment_id
282: ,l_year_end
283: ,l_tax_unit_id

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

288: EXIT WHEN c_prev_mag%NOTFOUND;
289: IF c_prev_mag%FOUND THEN
290: BEGIN
291: hr_nonrun_asact.insint(lockingactid ,ln_asg_act_to_lock);
292: hr_utility.trace(to_char(lockingactid)||' locked '||lv_report_type||' ID '||to_char(ln_asg_act_to_lock));
293: END;
294: END IF; --Found
295: END LOOP;
296: CLOSE c_prev_mag;

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

295: END LOOP;
296: CLOSE c_prev_mag;
297: END IF; -- c_lockingactid_check%FOUND
298: CLOSE c_lockingactid_check;
299: hr_utility.trace('x------------------------------------------------x');
300: END LOOP; --c_all_asg loop
301: CLOSE c_all_asg;
302: hr_utility.trace('X=========================================================X');
303: END action_creation;

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

298: CLOSE c_lockingactid_check;
299: hr_utility.trace('x------------------------------------------------x');
300: END LOOP; --c_all_asg loop
301: CLOSE c_all_asg;
302: hr_utility.trace('X=========================================================X');
303: END action_creation;
304: /**************************************************************************/
305: FUNCTION validate_gre_data ( p_trans IN VARCHAR2,
306: p_year IN VARCHAR2)

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

380:
381: BEGIN
382: /* Fetching the Payroll Action Id for Trasnmitter GRE */
383:
384: hr_utility.trace('Inside the Validation Code');
385: hr_utility.trace('The Transmitter GRE id passed is '||p_trans);
386: OPEN c_trans_payid(p_trans,p_year);
387: FETCH c_trans_payid INTO l_trans_payid,l_bg_id;
388: IF c_trans_payid%NOTFOUND THEN

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

381: BEGIN
382: /* Fetching the Payroll Action Id for Trasnmitter GRE */
383:
384: hr_utility.trace('Inside the Validation Code');
385: hr_utility.trace('The Transmitter GRE id passed is '||p_trans);
386: OPEN c_trans_payid(p_trans,p_year);
387: FETCH c_trans_payid INTO l_trans_payid,l_bg_id;
388: IF c_trans_payid%NOTFOUND THEN
389: CLOSE c_trans_payid;

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

386: OPEN c_trans_payid(p_trans,p_year);
387: FETCH c_trans_payid INTO l_trans_payid,l_bg_id;
388: IF c_trans_payid%NOTFOUND THEN
389: CLOSE c_trans_payid;
390: hr_utility.trace('The Transmitter GRE ID not found :'||p_trans);
391: hr_utility.raise_error;
392: RETURN '1';
393: ELSE
394: CLOSE c_trans_payid;

Line 391: hr_utility.raise_error;

387: FETCH c_trans_payid INTO l_trans_payid,l_bg_id;
388: IF c_trans_payid%NOTFOUND THEN
389: CLOSE c_trans_payid;
390: hr_utility.trace('The Transmitter GRE ID not found :'||p_trans);
391: hr_utility.raise_error;
392: RETURN '1';
393: ELSE
394: CLOSE c_trans_payid;
395: END IF;

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

393: ELSE
394: CLOSE c_trans_payid;
395: END IF;
396:
397: hr_utility.trace('Fetched the Payroll Id for transmitter GRE :'|| l_trans_payid);
398: hr_utility.trace('The Reporting Year is '||p_year);
399: /*Fetching the Trasnmitter Level Data */
400:
401: l_trans_no := get_arch_val(l_trans_payid, 'CAEOY_TRANSMITTER_NUMBER');

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

394: CLOSE c_trans_payid;
395: END IF;
396:
397: hr_utility.trace('Fetched the Payroll Id for transmitter GRE :'|| l_trans_payid);
398: hr_utility.trace('The Reporting Year is '||p_year);
399: /*Fetching the Trasnmitter Level Data */
400:
401: l_trans_no := get_arch_val(l_trans_payid, 'CAEOY_TRANSMITTER_NUMBER');
402: l_tech_name := get_arch_val(l_trans_payid, 'CAEOY_TECHNICAL_CONTACT_NAME');

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

412: OPEN c_gre_name(to_number(p_trans));
413: FETCH c_gre_name INTO l_trans_name;
414: CLOSE c_gre_name;
415:
416: hr_utility.trace('Transmitter Number :'||l_trans_no);
417: hr_utility.trace('Tech Name : '||l_tech_name);
418: hr_utility.trace('Tech Area : '||l_tech_area);
419: hr_utility.trace('Tech Phone : '||l_tech_phno);
420: hr_utility.trace('Tech Email : '||l_tech_email);

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

413: FETCH c_gre_name INTO l_trans_name;
414: CLOSE c_gre_name;
415:
416: hr_utility.trace('Transmitter Number :'||l_trans_no);
417: hr_utility.trace('Tech Name : '||l_tech_name);
418: hr_utility.trace('Tech Area : '||l_tech_area);
419: hr_utility.trace('Tech Phone : '||l_tech_phno);
420: hr_utility.trace('Tech Email : '||l_tech_email);
421: hr_utility.trace('Tech Language : '||l_lang);

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

414: CLOSE c_gre_name;
415:
416: hr_utility.trace('Transmitter Number :'||l_trans_no);
417: hr_utility.trace('Tech Name : '||l_tech_name);
418: hr_utility.trace('Tech Area : '||l_tech_area);
419: hr_utility.trace('Tech Phone : '||l_tech_phno);
420: hr_utility.trace('Tech Email : '||l_tech_email);
421: hr_utility.trace('Tech Language : '||l_lang);
422:

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

415:
416: hr_utility.trace('Transmitter Number :'||l_trans_no);
417: hr_utility.trace('Tech Name : '||l_tech_name);
418: hr_utility.trace('Tech Area : '||l_tech_area);
419: hr_utility.trace('Tech Phone : '||l_tech_phno);
420: hr_utility.trace('Tech Email : '||l_tech_email);
421: hr_utility.trace('Tech Language : '||l_lang);
422:
423: /* Checking for the validity of the above values fetched */

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

416: hr_utility.trace('Transmitter Number :'||l_trans_no);
417: hr_utility.trace('Tech Name : '||l_tech_name);
418: hr_utility.trace('Tech Area : '||l_tech_area);
419: hr_utility.trace('Tech Phone : '||l_tech_phno);
420: hr_utility.trace('Tech Email : '||l_tech_email);
421: hr_utility.trace('Tech Language : '||l_lang);
422:
423: /* Checking for the validity of the above values fetched */
424: IF l_trans_no IS NULL

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

417: hr_utility.trace('Tech Name : '||l_tech_name);
418: hr_utility.trace('Tech Area : '||l_tech_area);
419: hr_utility.trace('Tech Phone : '||l_tech_phno);
420: hr_utility.trace('Tech Email : '||l_tech_email);
421: hr_utility.trace('Tech Language : '||l_lang);
422:
423: /* Checking for the validity of the above values fetched */
424: IF l_trans_no IS NULL
425: OR TRANSLATE(l_trans_no,'M0123456789','M9999999999') <> 'MM999999' THEN

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

422:
423: /* Checking for the validity of the above values fetched */
424: IF l_trans_no IS NULL
425: OR TRANSLATE(l_trans_no,'M0123456789','M9999999999') <> 'MM999999' THEN
426: hr_utility.trace('Incorrect Transmitter No format');
427: hr_utility.set_message(801,'PAY_74155_INCORRECT_TRANSMT_NO');
428: hr_utility.set_message_token('GRE_NAME',l_trans_name);
429: pay_core_utils.push_message(801,'PAY_74155_INCORRECT_TRANSMT_NO','P');
430: pay_core_utils.push_token('GRE_NAME',l_trans_name);

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

423: /* Checking for the validity of the above values fetched */
424: IF l_trans_no IS NULL
425: OR TRANSLATE(l_trans_no,'M0123456789','M9999999999') <> 'MM999999' THEN
426: hr_utility.trace('Incorrect Transmitter No format');
427: hr_utility.set_message(801,'PAY_74155_INCORRECT_TRANSMT_NO');
428: hr_utility.set_message_token('GRE_NAME',l_trans_name);
429: pay_core_utils.push_message(801,'PAY_74155_INCORRECT_TRANSMT_NO','P');
430: pay_core_utils.push_token('GRE_NAME',l_trans_name);
431: hr_utility.raise_error;

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

424: IF l_trans_no IS NULL
425: OR TRANSLATE(l_trans_no,'M0123456789','M9999999999') <> 'MM999999' THEN
426: hr_utility.trace('Incorrect Transmitter No format');
427: hr_utility.set_message(801,'PAY_74155_INCORRECT_TRANSMT_NO');
428: hr_utility.set_message_token('GRE_NAME',l_trans_name);
429: pay_core_utils.push_message(801,'PAY_74155_INCORRECT_TRANSMT_NO','P');
430: pay_core_utils.push_token('GRE_NAME',l_trans_name);
431: hr_utility.raise_error;
432: RETURN '1';

Line 431: hr_utility.raise_error;

427: hr_utility.set_message(801,'PAY_74155_INCORRECT_TRANSMT_NO');
428: hr_utility.set_message_token('GRE_NAME',l_trans_name);
429: pay_core_utils.push_message(801,'PAY_74155_INCORRECT_TRANSMT_NO','P');
430: pay_core_utils.push_token('GRE_NAME',l_trans_name);
431: hr_utility.raise_error;
432: RETURN '1';
433: END IF;
434:
435: IF l_tech_name IS NULL OR

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

436: l_tech_area IS NULL OR
437: l_tech_phno IS NULL OR
438: l_tech_email IS NULL OR
439: l_lang IS NULL THEN
440: hr_utility.trace('Technical contact details missing');
441: hr_utility.set_message(801,'PAY_74158_INCORRECT_TCHN_INFO');
442: hr_utility.set_message_token('GRE_NAME',l_trans_name);
443: pay_core_utils.push_message(801,'PAY_74158_INCORRECT_TCHN_INFO','P');
444: pay_core_utils.push_token('GRE_NAME',l_trans_name);

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

437: l_tech_phno IS NULL OR
438: l_tech_email IS NULL OR
439: l_lang IS NULL THEN
440: hr_utility.trace('Technical contact details missing');
441: hr_utility.set_message(801,'PAY_74158_INCORRECT_TCHN_INFO');
442: hr_utility.set_message_token('GRE_NAME',l_trans_name);
443: pay_core_utils.push_message(801,'PAY_74158_INCORRECT_TCHN_INFO','P');
444: pay_core_utils.push_token('GRE_NAME',l_trans_name);
445: hr_utility.raise_error;

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

438: l_tech_email IS NULL OR
439: l_lang IS NULL THEN
440: hr_utility.trace('Technical contact details missing');
441: hr_utility.set_message(801,'PAY_74158_INCORRECT_TCHN_INFO');
442: hr_utility.set_message_token('GRE_NAME',l_trans_name);
443: pay_core_utils.push_message(801,'PAY_74158_INCORRECT_TCHN_INFO','P');
444: pay_core_utils.push_token('GRE_NAME',l_trans_name);
445: hr_utility.raise_error;
446: RETURN '1';

Line 445: hr_utility.raise_error;

441: hr_utility.set_message(801,'PAY_74158_INCORRECT_TCHN_INFO');
442: hr_utility.set_message_token('GRE_NAME',l_trans_name);
443: pay_core_utils.push_message(801,'PAY_74158_INCORRECT_TCHN_INFO','P');
444: pay_core_utils.push_token('GRE_NAME',l_trans_name);
445: hr_utility.raise_error;
446: RETURN '1';
447: END IF;
448:
449: IF l_acc_name IS NULL OR

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

452: l_acc_info_flag := 'N';
453: ELSE
454: l_acc_info_flag := 'Y';
455: END IF;
456: hr_utility.trace('The value of the Flag is '||l_acc_info_flag);
457:
458: /* If Transmitter Level Accounting Information is Missing checking for the GRE level information */
459:
460: OPEN c_all_gres(p_trans,p_year,l_bg_id);

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

459:
460: OPEN c_all_gres(p_trans,p_year,l_bg_id);
461: LOOP
462: FETCH c_all_gres into l_gre_payid, l_gre, l_gre_name;
463: hr_utility.trace('The Gre id fetched is '||l_gre);
464: IF c_all_gres%NOTFOUND THEN
465: CLOSE c_all_gres;
466: EXIT;
467: END IF;

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

465: CLOSE c_all_gres;
466: EXIT;
467: END IF;
468:
469: hr_utility.trace('Before fetching the GREs for this Transmitter '||l_gre||'-'||p_year);
470:
471:
472: IF l_gre <> to_number(p_trans) THEN
473: hr_utility.trace('Inside the loop'||l_gre_payid);

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

469: hr_utility.trace('Before fetching the GREs for this Transmitter '||l_gre||'-'||p_year);
470:
471:
472: IF l_gre <> to_number(p_trans) THEN
473: hr_utility.trace('Inside the loop'||l_gre_payid);
474:
475: hr_utility.trace('Checking GRE level data');
476: hr_utility.trace('The Payroll Action Id for Gre is '|| l_gre_payid);
477: l_bus_no := get_arch_val(l_gre_payid,'CAEOY_EMPLOYER_IDENTIFICATION_NUMBER');

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

471:
472: IF l_gre <> to_number(p_trans) THEN
473: hr_utility.trace('Inside the loop'||l_gre_payid);
474:
475: hr_utility.trace('Checking GRE level data');
476: hr_utility.trace('The Payroll Action Id for Gre is '|| l_gre_payid);
477: l_bus_no := get_arch_val(l_gre_payid,'CAEOY_EMPLOYER_IDENTIFICATION_NUMBER');
478: l_acc_name := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_NAME');
479: l_acc_area := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_AREA_CODE');

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

472: IF l_gre <> to_number(p_trans) THEN
473: hr_utility.trace('Inside the loop'||l_gre_payid);
474:
475: hr_utility.trace('Checking GRE level data');
476: hr_utility.trace('The Payroll Action Id for Gre is '|| l_gre_payid);
477: l_bus_no := get_arch_val(l_gre_payid,'CAEOY_EMPLOYER_IDENTIFICATION_NUMBER');
478: l_acc_name := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_NAME');
479: l_acc_area := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_AREA_CODE');
480: l_acc_phno := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_PHONE');

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

478: l_acc_name := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_NAME');
479: l_acc_area := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_AREA_CODE');
480: l_acc_phno := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_PHONE');
481:
482: hr_utility.trace('Tax unit ID :'||l_tax_unit_id);
483: hr_utility.trace('Acc Name :'||l_acc_name);
484: hr_utility.trace('Acc Area :'||l_acc_area);
485: hr_utility.trace('Acc Phone : '||l_acc_phno);
486: hr_utility.trace('GRE Name :'||l_gre_name);

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

479: l_acc_area := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_AREA_CODE');
480: l_acc_phno := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_PHONE');
481:
482: hr_utility.trace('Tax unit ID :'||l_tax_unit_id);
483: hr_utility.trace('Acc Name :'||l_acc_name);
484: hr_utility.trace('Acc Area :'||l_acc_area);
485: hr_utility.trace('Acc Phone : '||l_acc_phno);
486: hr_utility.trace('GRE Name :'||l_gre_name);
487:

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

480: l_acc_phno := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_PHONE');
481:
482: hr_utility.trace('Tax unit ID :'||l_tax_unit_id);
483: hr_utility.trace('Acc Name :'||l_acc_name);
484: hr_utility.trace('Acc Area :'||l_acc_area);
485: hr_utility.trace('Acc Phone : '||l_acc_phno);
486: hr_utility.trace('GRE Name :'||l_gre_name);
487:
488: IF l_bus_no IS NULL

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

481:
482: hr_utility.trace('Tax unit ID :'||l_tax_unit_id);
483: hr_utility.trace('Acc Name :'||l_acc_name);
484: hr_utility.trace('Acc Area :'||l_acc_area);
485: hr_utility.trace('Acc Phone : '||l_acc_phno);
486: hr_utility.trace('GRE Name :'||l_gre_name);
487:
488: IF l_bus_no IS NULL
489: OR TRANSLATE(l_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' THEN

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

482: hr_utility.trace('Tax unit ID :'||l_tax_unit_id);
483: hr_utility.trace('Acc Name :'||l_acc_name);
484: hr_utility.trace('Acc Area :'||l_acc_area);
485: hr_utility.trace('Acc Phone : '||l_acc_phno);
486: hr_utility.trace('GRE Name :'||l_gre_name);
487:
488: IF l_bus_no IS NULL
489: OR TRANSLATE(l_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' THEN
490: hr_utility.trace('No Business Number Entereed ');

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

486: hr_utility.trace('GRE Name :'||l_gre_name);
487:
488: IF l_bus_no IS NULL
489: OR TRANSLATE(l_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' THEN
490: hr_utility.trace('No Business Number Entereed ');
491: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
492: hr_utility.set_message_token('GRE_NAME',l_gre_name);
493: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
494: pay_core_utils.push_token('GRE_NAME',l_gre_name);

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

487:
488: IF l_bus_no IS NULL
489: OR TRANSLATE(l_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' THEN
490: hr_utility.trace('No Business Number Entereed ');
491: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
492: hr_utility.set_message_token('GRE_NAME',l_gre_name);
493: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
494: pay_core_utils.push_token('GRE_NAME',l_gre_name);
495: hr_utility.raise_error;

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

488: IF l_bus_no IS NULL
489: OR TRANSLATE(l_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' THEN
490: hr_utility.trace('No Business Number Entereed ');
491: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
492: hr_utility.set_message_token('GRE_NAME',l_gre_name);
493: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
494: pay_core_utils.push_token('GRE_NAME',l_gre_name);
495: hr_utility.raise_error;
496: RETURN '1';

Line 495: hr_utility.raise_error;

491: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
492: hr_utility.set_message_token('GRE_NAME',l_gre_name);
493: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
494: pay_core_utils.push_token('GRE_NAME',l_gre_name);
495: hr_utility.raise_error;
496: RETURN '1';
497: END IF;
498:
499: IF (l_acc_name IS NULL OR

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

499: IF (l_acc_name IS NULL OR
500: l_acc_area IS NULL OR
501: l_acc_phno IS NULL ) AND
502: l_acc_info_flag = 'N' THEN
503: hr_utility.trace('No Accounting Contact info present');
504: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
505: hr_utility.set_message_token('GRE_NAME',l_gre_name);
506: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
507: pay_core_utils.push_token('GRE_NAME',l_gre_name);

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

500: l_acc_area IS NULL OR
501: l_acc_phno IS NULL ) AND
502: l_acc_info_flag = 'N' THEN
503: hr_utility.trace('No Accounting Contact info present');
504: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
505: hr_utility.set_message_token('GRE_NAME',l_gre_name);
506: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
507: pay_core_utils.push_token('GRE_NAME',l_gre_name);
508: hr_utility.raise_error;

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

501: l_acc_phno IS NULL ) AND
502: l_acc_info_flag = 'N' THEN
503: hr_utility.trace('No Accounting Contact info present');
504: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
505: hr_utility.set_message_token('GRE_NAME',l_gre_name);
506: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
507: pay_core_utils.push_token('GRE_NAME',l_gre_name);
508: hr_utility.raise_error;
509: RETURN '1';

Line 508: hr_utility.raise_error;

504: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
505: hr_utility.set_message_token('GRE_NAME',l_gre_name);
506: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
507: pay_core_utils.push_token('GRE_NAME',l_gre_name);
508: hr_utility.raise_error;
509: RETURN '1';
510: END IF;
511:
512: ELSIF l_gre = to_number(p_trans) THEN

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

512: ELSIF l_gre = to_number(p_trans) THEN
513:
514: IF l_trans_bus_no IS NULL
515: OR TRANSLATE(l_trans_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' THEN
516: hr_utility.trace('No Business Number Entereed ');
517: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
518: hr_utility.set_message_token('GRE_NAME',l_trans_name);
519: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
520: pay_core_utils.push_token('GRE_NAME',l_trans_name);

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

513:
514: IF l_trans_bus_no IS NULL
515: OR TRANSLATE(l_trans_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' THEN
516: hr_utility.trace('No Business Number Entereed ');
517: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
518: hr_utility.set_message_token('GRE_NAME',l_trans_name);
519: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
520: pay_core_utils.push_token('GRE_NAME',l_trans_name);
521: hr_utility.raise_error;

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

514: IF l_trans_bus_no IS NULL
515: OR TRANSLATE(l_trans_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' THEN
516: hr_utility.trace('No Business Number Entereed ');
517: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
518: hr_utility.set_message_token('GRE_NAME',l_trans_name);
519: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
520: pay_core_utils.push_token('GRE_NAME',l_trans_name);
521: hr_utility.raise_error;
522: RETURN '1';

Line 521: hr_utility.raise_error;

517: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
518: hr_utility.set_message_token('GRE_NAME',l_trans_name);
519: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
520: pay_core_utils.push_token('GRE_NAME',l_trans_name);
521: hr_utility.raise_error;
522: RETURN '1';
523: END IF;
524:
525: IF l_acc_info_flag = 'N' THEN

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

522: RETURN '1';
523: END IF;
524:
525: IF l_acc_info_flag = 'N' THEN
526: hr_utility.trace('No Accounting Contact info present');
527: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
528: hr_utility.set_message_token('GRE_NAME',l_trans_name);
529: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
530: pay_core_utils.push_token('GRE_NAME',l_trans_name);

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

523: END IF;
524:
525: IF l_acc_info_flag = 'N' THEN
526: hr_utility.trace('No Accounting Contact info present');
527: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
528: hr_utility.set_message_token('GRE_NAME',l_trans_name);
529: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
530: pay_core_utils.push_token('GRE_NAME',l_trans_name);
531: hr_utility.raise_error;

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

524:
525: IF l_acc_info_flag = 'N' THEN
526: hr_utility.trace('No Accounting Contact info present');
527: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
528: hr_utility.set_message_token('GRE_NAME',l_trans_name);
529: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
530: pay_core_utils.push_token('GRE_NAME',l_trans_name);
531: hr_utility.raise_error;
532: RETURN '1';

Line 531: hr_utility.raise_error;

527: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
528: hr_utility.set_message_token('GRE_NAME',l_trans_name);
529: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
530: pay_core_utils.push_token('GRE_NAME',l_trans_name);
531: hr_utility.raise_error;
532: RETURN '1';
533: END IF;
534: END IF;
535: END LOOP;

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

655: l_data := REPLACE(l_data, '"' , '&' || 'quot;');
656: --------------------------------------------------------
657: --- P_Datatype: T = Text, N = Number, C=Currency, D=Date
658: --------------------------------------------------------
659: --hr_utility.trace('l_data='||l_data);
660: IF p_datatype = 'T' OR p_datatype = 'D' THEN
661: l_output := '<' || trim(p_tag) || '>' || trim(l_data)
662: || ''||EOL;
663: -- hr_utility.trace('l_output='||l_output);

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

659: --hr_utility.trace('l_data='||l_data);
660: IF p_datatype = 'T' OR p_datatype = 'D' THEN
661: l_output := '<' || trim(p_tag) || '>' || trim(l_data)
662: || ''||EOL;
663: -- hr_utility.trace('l_output='||l_output);
664: ELSIF p_datatype = 'N' OR p_datatype = 'C' THEN
665: IF TRIM(p_format) IS NOT NULL THEN
666: SELECT to_char(to_number(p_data), p_format)
667: INTO l_data FROM dual;

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

671: END IF;
672: l_output := '<' || trim(p_tag) || '>' || trim(l_data)
673: || ''||EOL;
674: END IF;
675: --hr_utility.trace('l_output='||l_output);
676: RETURN l_output;
677: END;
678: /**************************************************************************/
679: FUNCTION get_t4a_pp_regno(p_pactid IN NUMBER,

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

769: T619_lang_cd NUMBER :=18;
770: T619_rpt_tcd NUMBER :=19;
771:
772: BEGIN
773: hr_utility.trace('+==========================================================+');
774: hr_utility.trace('XML Transmitter');
775:
776: l_context1 := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
777: hr_utility.trace('PAYROLL_ACTION_ID l_context1 ='||l_context1);

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

770: T619_rpt_tcd NUMBER :=19;
771:
772: BEGIN
773: hr_utility.trace('+==========================================================+');
774: hr_utility.trace('XML Transmitter');
775:
776: l_context1 := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
777: hr_utility.trace('PAYROLL_ACTION_ID l_context1 ='||l_context1);
778:

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

773: hr_utility.trace('+==========================================================+');
774: hr_utility.trace('XML Transmitter');
775:
776: l_context1 := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
777: hr_utility.trace('PAYROLL_ACTION_ID l_context1 ='||l_context1);
778:
779: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
780: 'CAEOY_TRANSMITTER_NUMBER');
781: IF l_return IS NULL THEN

Line 911: hr_utility.set_location('Error in T4A Transmitter record',10);

907: ----
908: IF l_status = FALSE THEN
909: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
910: 'CAEOY_TRANSMITTER_NAME');
911: hr_utility.set_location('Error in T4A Transmitter record',10);
912: hr_utility.set_location('Error in the following fields: ' || l_field_name,20);
913: hr_utility.trace('Technical contact details missing');
914: hr_utility.set_message(801,'PAY_74158_INCORRECT_TCHN_INFO');
915: hr_utility.set_message_token('GRE_NAME',l_return);

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

908: IF l_status = FALSE THEN
909: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
910: 'CAEOY_TRANSMITTER_NAME');
911: hr_utility.set_location('Error in T4A Transmitter record',10);
912: hr_utility.set_location('Error in the following fields: ' || l_field_name,20);
913: hr_utility.trace('Technical contact details missing');
914: hr_utility.set_message(801,'PAY_74158_INCORRECT_TCHN_INFO');
915: hr_utility.set_message_token('GRE_NAME',l_return);
916: pay_core_utils.push_message(801,'PAY_74158_INCORRECT_TCHN_INFO','P');

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

909: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
910: 'CAEOY_TRANSMITTER_NAME');
911: hr_utility.set_location('Error in T4A Transmitter record',10);
912: hr_utility.set_location('Error in the following fields: ' || l_field_name,20);
913: hr_utility.trace('Technical contact details missing');
914: hr_utility.set_message(801,'PAY_74158_INCORRECT_TCHN_INFO');
915: hr_utility.set_message_token('GRE_NAME',l_return);
916: pay_core_utils.push_message(801,'PAY_74158_INCORRECT_TCHN_INFO','P');
917: pay_core_utils.push_token('GRE_NAME',l_return);

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

910: 'CAEOY_TRANSMITTER_NAME');
911: hr_utility.set_location('Error in T4A Transmitter record',10);
912: hr_utility.set_location('Error in the following fields: ' || l_field_name,20);
913: hr_utility.trace('Technical contact details missing');
914: hr_utility.set_message(801,'PAY_74158_INCORRECT_TCHN_INFO');
915: hr_utility.set_message_token('GRE_NAME',l_return);
916: pay_core_utils.push_message(801,'PAY_74158_INCORRECT_TCHN_INFO','P');
917: pay_core_utils.push_token('GRE_NAME',l_return);
918: hr_utility.raise_error;

Line 915: hr_utility.set_message_token('GRE_NAME',l_return);

911: hr_utility.set_location('Error in T4A Transmitter record',10);
912: hr_utility.set_location('Error in the following fields: ' || l_field_name,20);
913: hr_utility.trace('Technical contact details missing');
914: hr_utility.set_message(801,'PAY_74158_INCORRECT_TCHN_INFO');
915: hr_utility.set_message_token('GRE_NAME',l_return);
916: pay_core_utils.push_message(801,'PAY_74158_INCORRECT_TCHN_INFO','P');
917: pay_core_utils.push_token('GRE_NAME',l_return);
918: hr_utility.raise_error;
919: END IF;

Line 918: hr_utility.raise_error;

914: hr_utility.set_message(801,'PAY_74158_INCORRECT_TCHN_INFO');
915: hr_utility.set_message_token('GRE_NAME',l_return);
916: pay_core_utils.push_message(801,'PAY_74158_INCORRECT_TCHN_INFO','P');
917: pay_core_utils.push_token('GRE_NAME',l_return);
918: hr_utility.raise_error;
919: END IF;
920: ----
921: l_final_xml := '' || EOL
922: || ''|| EOL||

Line 948: hr_utility.trace(l_final_xml);

944: tab_transmitter(T619_cntc_extn_nbr)||
945: tab_transmitter(T619_cntc_email_area)||
946: '' || EOL||
947: '' || EOL;
948: hr_utility.trace(l_final_xml);
949: pay_core_files.write_to_magtape_lob(l_final_xml);
950: hr_utility.trace('X==========================================================X');
951: END;
952: END t4a_amend_mag_transmitter;

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

946: '' || EOL||
947: '' || EOL;
948: hr_utility.trace(l_final_xml);
949: pay_core_files.write_to_magtape_lob(l_final_xml);
950: hr_utility.trace('X==========================================================X');
951: END;
952: END t4a_amend_mag_transmitter;
953: /*****************************************************************************/
954:

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

958: l_final_xml CLOB;
959: l_final_xml_string VARCHAR2(32000);
960: l_is_temp_final_xml VARCHAR2(2);
961: BEGIN
962: hr_utility.trace('+==========================================================+');
963: hr_utility.trace('Entering end_of_file');
964: l_final_xml_string := '';
965:
966: hr_utility.trace(l_final_xml_string );

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

959: l_final_xml_string VARCHAR2(32000);
960: l_is_temp_final_xml VARCHAR2(2);
961: BEGIN
962: hr_utility.trace('+==========================================================+');
963: hr_utility.trace('Entering end_of_file');
964: l_final_xml_string := '';
965:
966: hr_utility.trace(l_final_xml_string );
967: pay_core_files.write_to_magtape_lob(l_final_xml_string);

Line 966: hr_utility.trace(l_final_xml_string );

962: hr_utility.trace('+==========================================================+');
963: hr_utility.trace('Entering end_of_file');
964: l_final_xml_string := '';
965:
966: hr_utility.trace(l_final_xml_string );
967: pay_core_files.write_to_magtape_lob(l_final_xml_string);
968: hr_utility.trace('Exiting end_of_file');
969: hr_utility.trace('X==========================================================X');
970: END;

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

964: l_final_xml_string := '';
965:
966: hr_utility.trace(l_final_xml_string );
967: pay_core_files.write_to_magtape_lob(l_final_xml_string);
968: hr_utility.trace('Exiting end_of_file');
969: hr_utility.trace('X==========================================================X');
970: END;
971: END end_of_file;
972: /*****************************************************************************/

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

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

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

978: EOL VARCHAR2(5) := fnd_global.local_chr(13)
979: || fnd_global.local_chr(10);
980:
981: BEGIN
982: hr_utility.trace('+==========================================================+');
983: hr_utility.trace('Entering t4a_amend_employer_start');
984: l_final_xml_string := ''||EOL||''||EOL;
985: hr_utility.trace(l_final_xml_string);
986: pay_core_files.write_to_magtape_lob(l_final_xml_string);

Line 983: hr_utility.trace('Entering t4a_amend_employer_start');

979: || fnd_global.local_chr(10);
980:
981: BEGIN
982: hr_utility.trace('+==========================================================+');
983: hr_utility.trace('Entering t4a_amend_employer_start');
984: l_final_xml_string := ''||EOL||''||EOL;
985: hr_utility.trace(l_final_xml_string);
986: pay_core_files.write_to_magtape_lob(l_final_xml_string);
987: hr_utility.trace('Exiting t4a_amend_employer_start');

Line 985: hr_utility.trace(l_final_xml_string);

981: BEGIN
982: hr_utility.trace('+==========================================================+');
983: hr_utility.trace('Entering t4a_amend_employer_start');
984: l_final_xml_string := ''||EOL||''||EOL;
985: hr_utility.trace(l_final_xml_string);
986: pay_core_files.write_to_magtape_lob(l_final_xml_string);
987: hr_utility.trace('Exiting t4a_amend_employer_start');
988: hr_utility.trace('X==========================================================X');
989: END;

Line 987: hr_utility.trace('Exiting t4a_amend_employer_start');

983: hr_utility.trace('Entering t4a_amend_employer_start');
984: l_final_xml_string := ''||EOL||''||EOL;
985: hr_utility.trace(l_final_xml_string);
986: pay_core_files.write_to_magtape_lob(l_final_xml_string);
987: hr_utility.trace('Exiting t4a_amend_employer_start');
988: hr_utility.trace('X==========================================================X');
989: END;
990: END t4a_amend_employer_start;
991:

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

984: l_final_xml_string := ''||EOL||''||EOL;
985: hr_utility.trace(l_final_xml_string);
986: pay_core_files.write_to_magtape_lob(l_final_xml_string);
987: hr_utility.trace('Exiting t4a_amend_employer_start');
988: hr_utility.trace('X==========================================================X');
989: END;
990: END t4a_amend_employer_start;
991:
992: /*****************************************************************************/

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

1029: T4ASummary_pprtr_2_sin NUMBER :=20;
1030: T4ASummary_rpt_tcd NUMBER :=21;
1031:
1032: BEGIN
1033: hr_utility.trace('+==========================================================+');
1034: hr_utility.trace('Entering t4a_amend_employer_record');
1035: l_context1 := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
1036: l_transfer_pact_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
1037: l_transfer_tax_unit_id := pay_magtape_generic.get_parameter_value('TRANSMITTER_GRE');

Line 1034: hr_utility.trace('Entering t4a_amend_employer_record');

1030: T4ASummary_rpt_tcd NUMBER :=21;
1031:
1032: BEGIN
1033: hr_utility.trace('+==========================================================+');
1034: hr_utility.trace('Entering t4a_amend_employer_record');
1035: l_context1 := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
1036: l_transfer_pact_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
1037: l_transfer_tax_unit_id := pay_magtape_generic.get_parameter_value('TRANSMITTER_GRE');
1038: hr_utility.trace('PAYROLL_ACTION_ID l_context1 = ' ||l_context1);

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

1034: hr_utility.trace('Entering t4a_amend_employer_record');
1035: l_context1 := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
1036: l_transfer_pact_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
1037: l_transfer_tax_unit_id := pay_magtape_generic.get_parameter_value('TRANSMITTER_GRE');
1038: hr_utility.trace('PAYROLL_ACTION_ID l_context1 = ' ||l_context1);
1039: hr_utility.trace('TRANSFER_PAYROLL_ACTION_ID l_transfer_pact_id = ' ||l_transfer_pact_id);
1040: hr_utility.trace('TRANSMITTER_GRE l_transfer_tax_unit_id = ' ||l_transfer_tax_unit_id);
1041: ----
1042: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

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

1035: l_context1 := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
1036: l_transfer_pact_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
1037: l_transfer_tax_unit_id := pay_magtape_generic.get_parameter_value('TRANSMITTER_GRE');
1038: hr_utility.trace('PAYROLL_ACTION_ID l_context1 = ' ||l_context1);
1039: hr_utility.trace('TRANSFER_PAYROLL_ACTION_ID l_transfer_pact_id = ' ||l_transfer_pact_id);
1040: hr_utility.trace('TRANSMITTER_GRE l_transfer_tax_unit_id = ' ||l_transfer_tax_unit_id);
1041: ----
1042: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1043: 'CAEOY_EMPLOYER_IDENTIFICATION_NUMBER');

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

1036: l_transfer_pact_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
1037: l_transfer_tax_unit_id := pay_magtape_generic.get_parameter_value('TRANSMITTER_GRE');
1038: hr_utility.trace('PAYROLL_ACTION_ID l_context1 = ' ||l_context1);
1039: hr_utility.trace('TRANSFER_PAYROLL_ACTION_ID l_transfer_pact_id = ' ||l_transfer_pact_id);
1040: hr_utility.trace('TRANSMITTER_GRE l_transfer_tax_unit_id = ' ||l_transfer_tax_unit_id);
1041: ----
1042: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1043: 'CAEOY_EMPLOYER_IDENTIFICATION_NUMBER');
1044: tab_employer(T4ASummary_bn):= convert_2_xml(l_return,'bn');

Line 1197: hr_utility.trace(l_final_xml_string);

1193: ''||EOL||
1194: tab_employer(T4ASummary_rpt_tcd)||
1195: '' || EOL||
1196: ''||EOL||''||EOL;
1197: hr_utility.trace(l_final_xml_string);
1198: pay_core_files.write_to_magtape_lob(l_final_xml_string);
1199: hr_utility.trace('X==========================================================X');
1200: END;
1201: END t4a_amend_employer_record;

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

1195: '' || EOL||
1196: ''||EOL||''||EOL;
1197: hr_utility.trace(l_final_xml_string);
1198: pay_core_files.write_to_magtape_lob(l_final_xml_string);
1199: hr_utility.trace('X==========================================================X');
1200: END;
1201: END t4a_amend_employer_record;
1202: /*****************************************************************************/
1203:

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

1303: pay_assignment_actions
1304: WHERE assignment_action_id = p_mag_asg_action_id;
1305:
1306: BEGIN
1307: hr_utility.trace('+==========================================================+');
1308: hr_utility.trace('Employee Record');
1309:
1310: l_payroll_actid := to_number(pay_magtape_generic.get_parameter_value
1311: ('TRANSFER_PAYROLL_ACTION_ID'));

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

1304: WHERE assignment_action_id = p_mag_asg_action_id;
1305:
1306: BEGIN
1307: hr_utility.trace('+==========================================================+');
1308: hr_utility.trace('Employee Record');
1309:
1310: l_payroll_actid := to_number(pay_magtape_generic.get_parameter_value
1311: ('TRANSFER_PAYROLL_ACTION_ID'));
1312: hr_utility.trace('T4A_AMEND_MAG Payroll action ='||l_payroll_actid);

Line 1312: hr_utility.trace('T4A_AMEND_MAG Payroll action ='||l_payroll_actid);

1308: hr_utility.trace('Employee Record');
1309:
1310: l_payroll_actid := to_number(pay_magtape_generic.get_parameter_value
1311: ('TRANSFER_PAYROLL_ACTION_ID'));
1312: hr_utility.trace('T4A_AMEND_MAG Payroll action ='||l_payroll_actid);
1313:
1314: l_mag_asg_action_id := to_number(pay_magtape_generic.get_parameter_value
1315: ('TRANSFER_ACT_ID'));
1316: hr_utility.trace('T4A_AMEND_MAG Assignment action ='|| to_char(l_mag_asg_action_id));

Line 1316: hr_utility.trace('T4A_AMEND_MAG Assignment action ='|| to_char(l_mag_asg_action_id));

1312: hr_utility.trace('T4A_AMEND_MAG Payroll action ='||l_payroll_actid);
1313:
1314: l_mag_asg_action_id := to_number(pay_magtape_generic.get_parameter_value
1315: ('TRANSFER_ACT_ID'));
1316: hr_utility.trace('T4A_AMEND_MAG Assignment action ='|| to_char(l_mag_asg_action_id));
1317:
1318: OPEN c_get_payroll_asg_actid(l_mag_asg_action_id);
1319: FETCH c_get_payroll_asg_actid INTO l_arch_action_id, l_arch_pay_actid;
1320: CLOSE c_get_payroll_asg_actid;

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

1317:
1318: OPEN c_get_payroll_asg_actid(l_mag_asg_action_id);
1319: FETCH c_get_payroll_asg_actid INTO l_arch_action_id, l_arch_pay_actid;
1320: CLOSE c_get_payroll_asg_actid;
1321: hr_utility.trace('Archiver Assignment action='|| l_arch_action_id);
1322: hr_utility.trace('Archiver Payroll action='|| l_arch_pay_actid);
1323: ----
1324: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1325: ,'CAEOY_T4A_NEGATIVE_BALANCE_EXISTS');

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

1318: OPEN c_get_payroll_asg_actid(l_mag_asg_action_id);
1319: FETCH c_get_payroll_asg_actid INTO l_arch_action_id, l_arch_pay_actid;
1320: CLOSE c_get_payroll_asg_actid;
1321: hr_utility.trace('Archiver Assignment action='|| l_arch_action_id);
1322: hr_utility.trace('Archiver Payroll action='|| l_arch_pay_actid);
1323: ----
1324: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1325: ,'CAEOY_T4A_NEGATIVE_BALANCE_EXISTS');
1326:

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

1333: /* T4ASlip Tags begin*/
1334: OPEN c_get_person_id(l_mag_asg_action_id);
1335: FETCH c_get_person_id INTO l_person_id;
1336: CLOSE c_get_person_id;
1337: hr_utility.trace('Person ID ='||l_person_id);
1338: ----1
1339: l_return := pay_ca_emp_address_dtls.get_emp_address(l_person_id,
1340: l_address_line1,
1341: l_address_line2,

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

1592: tab_other_info_tag(47) := 'lsp_dpsp_nelg_amt';
1593: tab_other_info_tag(48) := 'lsp_nrgst_pens_amt';
1594:
1595: IF l_status THEN
1596: hr_utility.trace('Status = Success');
1597: ELSE
1598: hr_utility.trace('Status = Fail');
1599: END IF;
1600:

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

1594:
1595: IF l_status THEN
1596: hr_utility.trace('Status = Success');
1597: ELSE
1598: hr_utility.trace('Status = Fail');
1599: END IF;
1600:
1601:
1602: l_other_info_xml_string(1) := ' ';

Line 1614: hr_utility.trace(tab_other_info_dbi(i)||' => '||l_return_xml);

1610: ,tab_other_info_dbi(i));
1611:
1612: IF nvl(l_return,0)<>0 THEN
1613: l_return_xml := convert_2_xml(l_return ,tab_other_info_tag(i),'C');
1614: hr_utility.trace(tab_other_info_dbi(i)||' => '||l_return_xml);
1615: l_other_info_count := l_other_info_count+1;
1616: IF l_status = FALSE THEN --Error report has single record A02
1617: l_other_info_xml_string(1) := l_other_info_xml_string(1)||l_return_xml;
1618: ELSIF l_status = TRUE THEN --Success report has multiple records

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

1631: END IF;
1632: END IF;
1633: END LOOP;
1634:
1635: hr_utility.trace('Other_info_count = '||l_other_info_count ||', Other_info_sets = '||l_other_info_sets);
1636:
1637: /* OTH_INFO Tags end */
1638: /*****************************************************************************/
1639: /* Final XML Generation begin */

Line 1672: hr_utility.trace(l_final_xml_string);

1668: l_final_xml_string:=l_final_xml_string||''||l_error_message||''
1669: ||EOL||''||EOL;
1670: END IF;
1671:
1672: hr_utility.trace(l_final_xml_string);
1673: pay_core_files.write_to_magtape_lob(l_final_xml_string);
1674: hr_utility.trace('X==========================================================X');
1675:
1676: /* Final XML Generation end */

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

1670: END IF;
1671:
1672: hr_utility.trace(l_final_xml_string);
1673: pay_core_files.write_to_magtape_lob(l_final_xml_string);
1674: hr_utility.trace('X==========================================================X');
1675:
1676: /* Final XML Generation end */
1677: /*****************************************************************************/
1678: END;