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

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

144: l_lockingactid_check pay_assignment_actions.assignment_action_id%TYPE;
145: l_payroll_act NUMBER;
146:
147: BEGIN
148: hr_utility.trace('+=========================================================+');
149: hr_utility.set_location( 'pay_ca_t4a_cancel_mag.action_creation',10);
150: get_report_parameters(
151: p_pactid,
152: l_legislative_parameters,

Line 149: hr_utility.set_location( 'pay_ca_t4a_cancel_mag.action_creation',10);

145: l_payroll_act NUMBER;
146:
147: BEGIN
148: hr_utility.trace('+=========================================================+');
149: hr_utility.set_location( 'pay_ca_t4a_cancel_mag.action_creation',10);
150: get_report_parameters(
151: p_pactid,
152: l_legislative_parameters,
153: l_year_end,

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

155: l_business_group_id);
156:
157: l_trans_gre := pay_ca_t4a_cancel_mag.get_parameter('TRANSMITTER_GRE',
158: l_legislative_parameters);
159: hr_utility.trace('l_trans_gre ='||l_trans_gre);
160: l_validate_gre := validate_gre_data(l_trans_gre, to_char(l_year_end,'YYYY'));
161: IF l_validate_gre = '1' THEN
162: hr_utility.raise_error;
163: END IF;

Line 162: hr_utility.raise_error;

158: l_legislative_parameters);
159: hr_utility.trace('l_trans_gre ='||l_trans_gre);
160: l_validate_gre := validate_gre_data(l_trans_gre, to_char(l_year_end,'YYYY'));
161: IF l_validate_gre = '1' THEN
162: hr_utility.raise_error;
163: END IF;
164: hr_utility.set_location( 'pay_ca_t4a_cancel_mag.action_creation',15);
165: l_asg_set_id := to_number(pay_ca_t4a_cancel_mag.get_parameter('ASG_SET_ID',
166: l_legislative_parameters));

Line 164: hr_utility.set_location( 'pay_ca_t4a_cancel_mag.action_creation',15);

160: l_validate_gre := validate_gre_data(l_trans_gre, to_char(l_year_end,'YYYY'));
161: IF l_validate_gre = '1' THEN
162: hr_utility.raise_error;
163: END IF;
164: hr_utility.set_location( 'pay_ca_t4a_cancel_mag.action_creation',15);
165: l_asg_set_id := to_number(pay_ca_t4a_cancel_mag.get_parameter('ASG_SET_ID',
166: l_legislative_parameters));
167: hr_utility.trace('l_assignment_set_id ='||l_asg_set_id);
168: --

Line 167: hr_utility.trace('l_assignment_set_id ='||l_asg_set_id);

163: END IF;
164: hr_utility.set_location( 'pay_ca_t4a_cancel_mag.action_creation',15);
165: l_asg_set_id := to_number(pay_ca_t4a_cancel_mag.get_parameter('ASG_SET_ID',
166: l_legislative_parameters));
167: hr_utility.trace('l_assignment_set_id ='||l_asg_set_id);
168: --
169: IF l_asg_set_id IS NOT NULL THEN
170: OPEN c_all_asg_in_asgset;
171: ELSE

Line 183: hr_utility.set_location('pay_ca_t4a_cancel_mag.action_creation', 20);

179: l_tax_unit_id,
180: l_effective_end_date,
181: l_assignment_action_id,
182: l_payroll_act;
183: hr_utility.set_location('pay_ca_t4a_cancel_mag.action_creation', 20);
184: EXIT WHEN c_all_asg_in_asgset%NOTFOUND;
185: ELSE
186: FETCH c_all_asg INTO l_person_id,
187: l_assignment_id,

Line 192: hr_utility.set_location('pay_ca_t4a_cancel_mag.action_creation', 25);

188: l_tax_unit_id,
189: l_effective_end_date,
190: l_assignment_action_id,
191: l_payroll_act;
192: hr_utility.set_location('pay_ca_t4a_cancel_mag.action_creation', 25);
193: EXIT WHEN c_all_asg%NOTFOUND;
194: END IF;
195:
196: hr_utility.trace('+------------------------------------------------+');

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

192: hr_utility.set_location('pay_ca_t4a_cancel_mag.action_creation', 25);
193: EXIT WHEN c_all_asg%NOTFOUND;
194: END IF;
195:
196: hr_utility.trace('+------------------------------------------------+');
197: hr_utility.trace('Fetched Assignment ID : '|| to_char(l_assignment_id));
198: hr_utility.trace('Person ID : '|| to_char(l_person_id));
199: hr_utility.trace('Tax Unit ID : '|| to_char(l_tax_unit_id));
200: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date,'DD-Mon-YYYY'));

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

193: EXIT WHEN c_all_asg%NOTFOUND;
194: END IF;
195:
196: hr_utility.trace('+------------------------------------------------+');
197: hr_utility.trace('Fetched Assignment ID : '|| to_char(l_assignment_id));
198: hr_utility.trace('Person ID : '|| to_char(l_person_id));
199: hr_utility.trace('Tax Unit ID : '|| to_char(l_tax_unit_id));
200: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date,'DD-Mon-YYYY'));
201: hr_utility.trace('x------------------------------------------------x');

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

194: END IF;
195:
196: hr_utility.trace('+------------------------------------------------+');
197: hr_utility.trace('Fetched Assignment ID : '|| to_char(l_assignment_id));
198: hr_utility.trace('Person ID : '|| to_char(l_person_id));
199: hr_utility.trace('Tax Unit ID : '|| to_char(l_tax_unit_id));
200: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date,'DD-Mon-YYYY'));
201: hr_utility.trace('x------------------------------------------------x');
202: SELECT pay_assignment_actions_s.nextval

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

195:
196: hr_utility.trace('+------------------------------------------------+');
197: hr_utility.trace('Fetched Assignment ID : '|| to_char(l_assignment_id));
198: hr_utility.trace('Person ID : '|| to_char(l_person_id));
199: hr_utility.trace('Tax Unit ID : '|| to_char(l_tax_unit_id));
200: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date,'DD-Mon-YYYY'));
201: hr_utility.trace('x------------------------------------------------x');
202: SELECT pay_assignment_actions_s.nextval
203: INTO lockingactid

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

196: hr_utility.trace('+------------------------------------------------+');
197: hr_utility.trace('Fetched Assignment ID : '|| to_char(l_assignment_id));
198: hr_utility.trace('Person ID : '|| to_char(l_person_id));
199: hr_utility.trace('Tax Unit ID : '|| to_char(l_tax_unit_id));
200: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date,'DD-Mon-YYYY'));
201: hr_utility.trace('x------------------------------------------------x');
202: SELECT pay_assignment_actions_s.nextval
203: INTO lockingactid
204: FROM dual;

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

197: hr_utility.trace('Fetched Assignment ID : '|| to_char(l_assignment_id));
198: hr_utility.trace('Person ID : '|| to_char(l_person_id));
199: hr_utility.trace('Tax Unit ID : '|| to_char(l_tax_unit_id));
200: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date,'DD-Mon-YYYY'));
201: hr_utility.trace('x------------------------------------------------x');
202: SELECT pay_assignment_actions_s.nextval
203: INTO lockingactid
204: FROM dual;
205: hr_utility.trace('New T4A Cancel Action = ' ||to_char(lockingactid));

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

201: hr_utility.trace('x------------------------------------------------x');
202: SELECT pay_assignment_actions_s.nextval
203: INTO lockingactid
204: FROM dual;
205: hr_utility.trace('New T4A Cancel Action = ' ||to_char(lockingactid));
206: hr_utility.set_location('pay_ca_t4a_cancel_mag.action_creation', 30);
207: hr_nonrun_asact.insact(lockingactid
208: ,l_assignment_id
209: ,p_pactid

Line 206: hr_utility.set_location('pay_ca_t4a_cancel_mag.action_creation', 30);

202: SELECT pay_assignment_actions_s.nextval
203: INTO lockingactid
204: FROM dual;
205: hr_utility.trace('New T4A Cancel Action = ' ||to_char(lockingactid));
206: hr_utility.set_location('pay_ca_t4a_cancel_mag.action_creation', 30);
207: hr_nonrun_asact.insact(lockingactid
208: ,l_assignment_id
209: ,p_pactid
210: ,p_chunk

Line 212: hr_utility.set_location('pay_ca_t4a_cancel_mag.action_creation', 40);

208: ,l_assignment_id
209: ,p_pactid
210: ,p_chunk
211: ,l_tax_unit_id);
212: hr_utility.set_location('pay_ca_t4a_cancel_mag.action_creation', 40);
213:
214: UPDATE pay_assignment_actions aa
215: SET aa.serial_number = to_char(l_person_id)
216: WHERE aa.assignment_action_id = lockingactid;

Line 218: hr_utility.set_location('pay_ca_t4a_cancel_mag.action_creation', 50);

214: UPDATE pay_assignment_actions aa
215: SET aa.serial_number = to_char(l_person_id)
216: WHERE aa.assignment_action_id = lockingactid;
217:
218: hr_utility.set_location('pay_ca_t4a_cancel_mag.action_creation', 50);
219: hr_nonrun_asact.insint(lockingactid ,l_assignment_action_id);
220: hr_utility.trace(to_char(lockingactid)||' locked Cancel Archiver ID '||to_char(l_assignment_action_id));
221: hr_utility.trace('x------------------------------------------------x');
222: END LOOP; --c_all_asg loop

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

216: WHERE aa.assignment_action_id = lockingactid;
217:
218: hr_utility.set_location('pay_ca_t4a_cancel_mag.action_creation', 50);
219: hr_nonrun_asact.insint(lockingactid ,l_assignment_action_id);
220: hr_utility.trace(to_char(lockingactid)||' locked Cancel Archiver ID '||to_char(l_assignment_action_id));
221: hr_utility.trace('x------------------------------------------------x');
222: END LOOP; --c_all_asg loop
223: IF l_asg_set_id IS NOT NULL THEN
224: CLOSE c_all_asg_in_asgset;

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

217:
218: hr_utility.set_location('pay_ca_t4a_cancel_mag.action_creation', 50);
219: hr_nonrun_asact.insint(lockingactid ,l_assignment_action_id);
220: hr_utility.trace(to_char(lockingactid)||' locked Cancel Archiver ID '||to_char(l_assignment_action_id));
221: hr_utility.trace('x------------------------------------------------x');
222: END LOOP; --c_all_asg loop
223: IF l_asg_set_id IS NOT NULL THEN
224: CLOSE c_all_asg_in_asgset;
225: ELSE

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

224: CLOSE c_all_asg_in_asgset;
225: ELSE
226: CLOSE c_all_asg;
227: END IF;
228: hr_utility.trace('X=========================================================X');
229: END action_creation;
230: /**************************************************************************/
231: FUNCTION validate_gre_data ( p_trans IN VARCHAR2,
232: p_year IN VARCHAR2)

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

294:
295: BEGIN
296: /* Fetching the Payroll Action Id for Trasnmitter GRE */
297:
298: hr_utility.trace('Inside the Validation Code');
299: hr_utility.trace('The Transmitter GRE id passed is '||p_trans);
300: OPEN c_trans_payid(p_trans,p_year);
301: FETCH c_trans_payid INTO l_trans_payid,l_bg_id;
302: IF c_trans_payid%NOTFOUND THEN

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

295: BEGIN
296: /* Fetching the Payroll Action Id for Trasnmitter GRE */
297:
298: hr_utility.trace('Inside the Validation Code');
299: hr_utility.trace('The Transmitter GRE id passed is '||p_trans);
300: OPEN c_trans_payid(p_trans,p_year);
301: FETCH c_trans_payid INTO l_trans_payid,l_bg_id;
302: IF c_trans_payid%NOTFOUND THEN
303: CLOSE c_trans_payid;

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

300: OPEN c_trans_payid(p_trans,p_year);
301: FETCH c_trans_payid INTO l_trans_payid,l_bg_id;
302: IF c_trans_payid%NOTFOUND THEN
303: CLOSE c_trans_payid;
304: hr_utility.trace('The Transmitter GRE ID not found :'||p_trans);
305: hr_utility.raise_error;
306: RETURN '1';
307: ELSE
308: CLOSE c_trans_payid;

Line 305: hr_utility.raise_error;

301: FETCH c_trans_payid INTO l_trans_payid,l_bg_id;
302: IF c_trans_payid%NOTFOUND THEN
303: CLOSE c_trans_payid;
304: hr_utility.trace('The Transmitter GRE ID not found :'||p_trans);
305: hr_utility.raise_error;
306: RETURN '1';
307: ELSE
308: CLOSE c_trans_payid;
309: END IF;

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

307: ELSE
308: CLOSE c_trans_payid;
309: END IF;
310:
311: hr_utility.trace('Fetched the Payroll Id for transmitter GRE :'|| l_trans_payid);
312: hr_utility.trace('The Reporting Year is '||p_year);
313: /*Fetching the Trasnmitter Level Data */
314:
315: l_trans_no := get_arch_val(l_trans_payid, 'CAEOY_TRANSMITTER_NUMBER');

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

308: CLOSE c_trans_payid;
309: END IF;
310:
311: hr_utility.trace('Fetched the Payroll Id for transmitter GRE :'|| l_trans_payid);
312: hr_utility.trace('The Reporting Year is '||p_year);
313: /*Fetching the Trasnmitter Level Data */
314:
315: l_trans_no := get_arch_val(l_trans_payid, 'CAEOY_TRANSMITTER_NUMBER');
316: l_tech_name := get_arch_val(l_trans_payid, 'CAEOY_TECHNICAL_CONTACT_NAME');

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

326: OPEN c_gre_name(to_number(p_trans));
327: FETCH c_gre_name INTO l_trans_name;
328: CLOSE c_gre_name;
329:
330: hr_utility.trace('Transmitter Number :'||l_trans_no);
331: hr_utility.trace('Tech Name : '||l_tech_name);
332: hr_utility.trace('Tech Area : '||l_tech_area);
333: hr_utility.trace('Tech Phone : '||l_tech_phno);
334: hr_utility.trace('Tech Email : '||l_tech_email);

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

327: FETCH c_gre_name INTO l_trans_name;
328: CLOSE c_gre_name;
329:
330: hr_utility.trace('Transmitter Number :'||l_trans_no);
331: hr_utility.trace('Tech Name : '||l_tech_name);
332: hr_utility.trace('Tech Area : '||l_tech_area);
333: hr_utility.trace('Tech Phone : '||l_tech_phno);
334: hr_utility.trace('Tech Email : '||l_tech_email);
335: hr_utility.trace('Tech Language : '||l_lang);

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

328: CLOSE c_gre_name;
329:
330: hr_utility.trace('Transmitter Number :'||l_trans_no);
331: hr_utility.trace('Tech Name : '||l_tech_name);
332: hr_utility.trace('Tech Area : '||l_tech_area);
333: hr_utility.trace('Tech Phone : '||l_tech_phno);
334: hr_utility.trace('Tech Email : '||l_tech_email);
335: hr_utility.trace('Tech Language : '||l_lang);
336:

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

329:
330: hr_utility.trace('Transmitter Number :'||l_trans_no);
331: hr_utility.trace('Tech Name : '||l_tech_name);
332: hr_utility.trace('Tech Area : '||l_tech_area);
333: hr_utility.trace('Tech Phone : '||l_tech_phno);
334: hr_utility.trace('Tech Email : '||l_tech_email);
335: hr_utility.trace('Tech Language : '||l_lang);
336:
337: /* Checking for the validity of the above values fetched */

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

330: hr_utility.trace('Transmitter Number :'||l_trans_no);
331: hr_utility.trace('Tech Name : '||l_tech_name);
332: hr_utility.trace('Tech Area : '||l_tech_area);
333: hr_utility.trace('Tech Phone : '||l_tech_phno);
334: hr_utility.trace('Tech Email : '||l_tech_email);
335: hr_utility.trace('Tech Language : '||l_lang);
336:
337: /* Checking for the validity of the above values fetched */
338: IF l_trans_no IS NULL

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

331: hr_utility.trace('Tech Name : '||l_tech_name);
332: hr_utility.trace('Tech Area : '||l_tech_area);
333: hr_utility.trace('Tech Phone : '||l_tech_phno);
334: hr_utility.trace('Tech Email : '||l_tech_email);
335: hr_utility.trace('Tech Language : '||l_lang);
336:
337: /* Checking for the validity of the above values fetched */
338: IF l_trans_no IS NULL
339: OR TRANSLATE(l_trans_no,'M0123456789','M9999999999') <> 'MM999999' THEN

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

336:
337: /* Checking for the validity of the above values fetched */
338: IF l_trans_no IS NULL
339: OR TRANSLATE(l_trans_no,'M0123456789','M9999999999') <> 'MM999999' THEN
340: hr_utility.trace('Incorrect Transmitter No format');
341: hr_utility.set_message(801,'PAY_74155_INCORRECT_TRANSMT_NO');
342: hr_utility.set_message_token('GRE_NAME',l_trans_name);
343: pay_core_utils.push_message(801,'PAY_74155_INCORRECT_TRANSMT_NO','P');
344: pay_core_utils.push_token('GRE_NAME',l_trans_name);

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

337: /* Checking for the validity of the above values fetched */
338: IF l_trans_no IS NULL
339: OR TRANSLATE(l_trans_no,'M0123456789','M9999999999') <> 'MM999999' THEN
340: hr_utility.trace('Incorrect Transmitter No format');
341: hr_utility.set_message(801,'PAY_74155_INCORRECT_TRANSMT_NO');
342: hr_utility.set_message_token('GRE_NAME',l_trans_name);
343: pay_core_utils.push_message(801,'PAY_74155_INCORRECT_TRANSMT_NO','P');
344: pay_core_utils.push_token('GRE_NAME',l_trans_name);
345: hr_utility.raise_error;

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

338: IF l_trans_no IS NULL
339: OR TRANSLATE(l_trans_no,'M0123456789','M9999999999') <> 'MM999999' THEN
340: hr_utility.trace('Incorrect Transmitter No format');
341: hr_utility.set_message(801,'PAY_74155_INCORRECT_TRANSMT_NO');
342: hr_utility.set_message_token('GRE_NAME',l_trans_name);
343: pay_core_utils.push_message(801,'PAY_74155_INCORRECT_TRANSMT_NO','P');
344: pay_core_utils.push_token('GRE_NAME',l_trans_name);
345: hr_utility.raise_error;
346: RETURN '1';

Line 345: hr_utility.raise_error;

341: hr_utility.set_message(801,'PAY_74155_INCORRECT_TRANSMT_NO');
342: hr_utility.set_message_token('GRE_NAME',l_trans_name);
343: pay_core_utils.push_message(801,'PAY_74155_INCORRECT_TRANSMT_NO','P');
344: pay_core_utils.push_token('GRE_NAME',l_trans_name);
345: hr_utility.raise_error;
346: RETURN '1';
347: END IF;
348:
349: IF l_tech_name IS NULL OR

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

350: l_tech_area IS NULL OR
351: l_tech_phno IS NULL OR
352: l_tech_email IS NULL OR
353: l_lang IS NULL THEN
354: hr_utility.trace('Technical contact details missing');
355: hr_utility.set_message(801,'PAY_74158_INCORRECT_TCHN_INFO');
356: hr_utility.set_message_token('GRE_NAME',l_trans_name);
357: pay_core_utils.push_message(801,'PAY_74158_INCORRECT_TCHN_INFO','P');
358: pay_core_utils.push_token('GRE_NAME',l_trans_name);

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

351: l_tech_phno IS NULL OR
352: l_tech_email IS NULL OR
353: l_lang IS NULL THEN
354: hr_utility.trace('Technical contact details missing');
355: hr_utility.set_message(801,'PAY_74158_INCORRECT_TCHN_INFO');
356: hr_utility.set_message_token('GRE_NAME',l_trans_name);
357: pay_core_utils.push_message(801,'PAY_74158_INCORRECT_TCHN_INFO','P');
358: pay_core_utils.push_token('GRE_NAME',l_trans_name);
359: hr_utility.raise_error;

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

352: l_tech_email IS NULL OR
353: l_lang IS NULL THEN
354: hr_utility.trace('Technical contact details missing');
355: hr_utility.set_message(801,'PAY_74158_INCORRECT_TCHN_INFO');
356: hr_utility.set_message_token('GRE_NAME',l_trans_name);
357: pay_core_utils.push_message(801,'PAY_74158_INCORRECT_TCHN_INFO','P');
358: pay_core_utils.push_token('GRE_NAME',l_trans_name);
359: hr_utility.raise_error;
360: RETURN '1';

Line 359: hr_utility.raise_error;

355: hr_utility.set_message(801,'PAY_74158_INCORRECT_TCHN_INFO');
356: hr_utility.set_message_token('GRE_NAME',l_trans_name);
357: pay_core_utils.push_message(801,'PAY_74158_INCORRECT_TCHN_INFO','P');
358: pay_core_utils.push_token('GRE_NAME',l_trans_name);
359: hr_utility.raise_error;
360: RETURN '1';
361: END IF;
362:
363: IF l_acc_name IS NULL OR

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

366: l_acc_info_flag := 'N';
367: ELSE
368: l_acc_info_flag := 'Y';
369: END IF;
370: hr_utility.trace('The value of the Flag is '||l_acc_info_flag);
371:
372: /* If Transmitter Level Accounting Information is Missing checking for the GRE level information */
373:
374: OPEN c_all_gres(p_trans,p_year,l_bg_id);

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

373:
374: OPEN c_all_gres(p_trans,p_year,l_bg_id);
375: LOOP
376: FETCH c_all_gres into l_gre_payid, l_gre, l_gre_name;
377: hr_utility.trace('The Gre id fetched is '||l_gre);
378: IF c_all_gres%NOTFOUND THEN
379: CLOSE c_all_gres;
380: EXIT;
381: END IF;

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

379: CLOSE c_all_gres;
380: EXIT;
381: END IF;
382:
383: hr_utility.trace('Before fetching the GREs for this Transmitter '||l_gre||'-'||p_year);
384:
385:
386: IF l_gre <> to_number(p_trans) THEN
387: hr_utility.trace('Inside the loop'||l_gre_payid);

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

383: hr_utility.trace('Before fetching the GREs for this Transmitter '||l_gre||'-'||p_year);
384:
385:
386: IF l_gre <> to_number(p_trans) THEN
387: hr_utility.trace('Inside the loop'||l_gre_payid);
388:
389: hr_utility.trace('Checking GRE level data');
390: hr_utility.trace('The Payroll Action Id for Gre is '|| l_gre_payid);
391: l_bus_no := get_arch_val(l_gre_payid,'CAEOY_EMPLOYER_IDENTIFICATION_NUMBER');

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

385:
386: IF l_gre <> to_number(p_trans) THEN
387: hr_utility.trace('Inside the loop'||l_gre_payid);
388:
389: hr_utility.trace('Checking GRE level data');
390: hr_utility.trace('The Payroll Action Id for Gre is '|| l_gre_payid);
391: l_bus_no := get_arch_val(l_gre_payid,'CAEOY_EMPLOYER_IDENTIFICATION_NUMBER');
392: l_acc_name := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_NAME');
393: l_acc_area := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_AREA_CODE');

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

386: IF l_gre <> to_number(p_trans) THEN
387: hr_utility.trace('Inside the loop'||l_gre_payid);
388:
389: hr_utility.trace('Checking GRE level data');
390: hr_utility.trace('The Payroll Action Id for Gre is '|| l_gre_payid);
391: l_bus_no := get_arch_val(l_gre_payid,'CAEOY_EMPLOYER_IDENTIFICATION_NUMBER');
392: l_acc_name := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_NAME');
393: l_acc_area := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_AREA_CODE');
394: l_acc_phno := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_PHONE');

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

392: l_acc_name := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_NAME');
393: l_acc_area := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_AREA_CODE');
394: l_acc_phno := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_PHONE');
395:
396: hr_utility.trace('Tax unit ID :'||l_tax_unit_id);
397: hr_utility.trace('Acc Name :'||l_acc_name);
398: hr_utility.trace('Acc Area :'||l_acc_area);
399: hr_utility.trace('Acc Phone : '||l_acc_phno);
400: hr_utility.trace('GRE Name :'||l_gre_name);

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

393: l_acc_area := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_AREA_CODE');
394: l_acc_phno := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_PHONE');
395:
396: hr_utility.trace('Tax unit ID :'||l_tax_unit_id);
397: hr_utility.trace('Acc Name :'||l_acc_name);
398: hr_utility.trace('Acc Area :'||l_acc_area);
399: hr_utility.trace('Acc Phone : '||l_acc_phno);
400: hr_utility.trace('GRE Name :'||l_gre_name);
401:

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

394: l_acc_phno := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_PHONE');
395:
396: hr_utility.trace('Tax unit ID :'||l_tax_unit_id);
397: hr_utility.trace('Acc Name :'||l_acc_name);
398: hr_utility.trace('Acc Area :'||l_acc_area);
399: hr_utility.trace('Acc Phone : '||l_acc_phno);
400: hr_utility.trace('GRE Name :'||l_gre_name);
401:
402: IF l_bus_no IS NULL

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

395:
396: hr_utility.trace('Tax unit ID :'||l_tax_unit_id);
397: hr_utility.trace('Acc Name :'||l_acc_name);
398: hr_utility.trace('Acc Area :'||l_acc_area);
399: hr_utility.trace('Acc Phone : '||l_acc_phno);
400: hr_utility.trace('GRE Name :'||l_gre_name);
401:
402: IF l_bus_no IS NULL
403: OR TRANSLATE(l_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' THEN

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

396: hr_utility.trace('Tax unit ID :'||l_tax_unit_id);
397: hr_utility.trace('Acc Name :'||l_acc_name);
398: hr_utility.trace('Acc Area :'||l_acc_area);
399: hr_utility.trace('Acc Phone : '||l_acc_phno);
400: hr_utility.trace('GRE Name :'||l_gre_name);
401:
402: IF l_bus_no IS NULL
403: OR TRANSLATE(l_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' THEN
404: hr_utility.trace('No Business Number Entereed ');

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

400: hr_utility.trace('GRE Name :'||l_gre_name);
401:
402: IF l_bus_no IS NULL
403: OR TRANSLATE(l_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' THEN
404: hr_utility.trace('No Business Number Entereed ');
405: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
406: hr_utility.set_message_token('GRE_NAME',l_gre_name);
407: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
408: pay_core_utils.push_token('GRE_NAME',l_gre_name);

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

401:
402: IF l_bus_no IS NULL
403: OR TRANSLATE(l_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' THEN
404: hr_utility.trace('No Business Number Entereed ');
405: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
406: hr_utility.set_message_token('GRE_NAME',l_gre_name);
407: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
408: pay_core_utils.push_token('GRE_NAME',l_gre_name);
409: hr_utility.raise_error;

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

402: IF l_bus_no IS NULL
403: OR TRANSLATE(l_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' THEN
404: hr_utility.trace('No Business Number Entereed ');
405: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
406: hr_utility.set_message_token('GRE_NAME',l_gre_name);
407: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
408: pay_core_utils.push_token('GRE_NAME',l_gre_name);
409: hr_utility.raise_error;
410: RETURN '1';

Line 409: hr_utility.raise_error;

405: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
406: hr_utility.set_message_token('GRE_NAME',l_gre_name);
407: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
408: pay_core_utils.push_token('GRE_NAME',l_gre_name);
409: hr_utility.raise_error;
410: RETURN '1';
411: END IF;
412:
413: IF (l_acc_name IS NULL OR

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

413: IF (l_acc_name IS NULL OR
414: l_acc_area IS NULL OR
415: l_acc_phno IS NULL ) AND
416: l_acc_info_flag = 'N' THEN
417: hr_utility.trace('No Accounting Contact info present');
418: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
419: hr_utility.set_message_token('GRE_NAME',l_gre_name);
420: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
421: pay_core_utils.push_token('GRE_NAME',l_gre_name);

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

414: l_acc_area IS NULL OR
415: l_acc_phno IS NULL ) AND
416: l_acc_info_flag = 'N' THEN
417: hr_utility.trace('No Accounting Contact info present');
418: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
419: hr_utility.set_message_token('GRE_NAME',l_gre_name);
420: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
421: pay_core_utils.push_token('GRE_NAME',l_gre_name);
422: hr_utility.raise_error;

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

415: l_acc_phno IS NULL ) AND
416: l_acc_info_flag = 'N' THEN
417: hr_utility.trace('No Accounting Contact info present');
418: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
419: hr_utility.set_message_token('GRE_NAME',l_gre_name);
420: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
421: pay_core_utils.push_token('GRE_NAME',l_gre_name);
422: hr_utility.raise_error;
423: RETURN '1';

Line 422: hr_utility.raise_error;

418: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
419: hr_utility.set_message_token('GRE_NAME',l_gre_name);
420: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
421: pay_core_utils.push_token('GRE_NAME',l_gre_name);
422: hr_utility.raise_error;
423: RETURN '1';
424: END IF;
425:
426: ELSIF l_gre = to_number(p_trans) THEN

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

426: ELSIF l_gre = to_number(p_trans) THEN
427:
428: IF l_trans_bus_no IS NULL
429: OR TRANSLATE(l_trans_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' THEN
430: hr_utility.trace('No Business Number Entereed ');
431: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
432: hr_utility.set_message_token('GRE_NAME',l_trans_name);
433: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
434: pay_core_utils.push_token('GRE_NAME',l_trans_name);

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

427:
428: IF l_trans_bus_no IS NULL
429: OR TRANSLATE(l_trans_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' THEN
430: hr_utility.trace('No Business Number Entereed ');
431: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
432: hr_utility.set_message_token('GRE_NAME',l_trans_name);
433: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
434: pay_core_utils.push_token('GRE_NAME',l_trans_name);
435: hr_utility.raise_error;

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

428: IF l_trans_bus_no IS NULL
429: OR TRANSLATE(l_trans_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' THEN
430: hr_utility.trace('No Business Number Entereed ');
431: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
432: hr_utility.set_message_token('GRE_NAME',l_trans_name);
433: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
434: pay_core_utils.push_token('GRE_NAME',l_trans_name);
435: hr_utility.raise_error;
436: RETURN '1';

Line 435: hr_utility.raise_error;

431: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
432: hr_utility.set_message_token('GRE_NAME',l_trans_name);
433: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
434: pay_core_utils.push_token('GRE_NAME',l_trans_name);
435: hr_utility.raise_error;
436: RETURN '1';
437: END IF;
438:
439: IF l_acc_info_flag = 'N' THEN

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

436: RETURN '1';
437: END IF;
438:
439: IF l_acc_info_flag = 'N' THEN
440: hr_utility.trace('No Accounting Contact info present');
441: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
442: hr_utility.set_message_token('GRE_NAME',l_trans_name);
443: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
444: pay_core_utils.push_token('GRE_NAME',l_trans_name);

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

437: END IF;
438:
439: IF l_acc_info_flag = 'N' THEN
440: hr_utility.trace('No Accounting Contact info present');
441: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
442: hr_utility.set_message_token('GRE_NAME',l_trans_name);
443: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_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:
439: IF l_acc_info_flag = 'N' THEN
440: hr_utility.trace('No Accounting Contact info present');
441: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
442: hr_utility.set_message_token('GRE_NAME',l_trans_name);
443: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_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_74157_INCORRECT_ACNT_INFO');
442: hr_utility.set_message_token('GRE_NAME',l_trans_name);
443: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_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: END IF;
449: END LOOP;

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

569: l_data := REPLACE(l_data, '"' , '&' || 'quot;');
570: --------------------------------------------------------
571: --- P_Datatype: T = Text, N = Number, C=Currency, D=Date
572: --------------------------------------------------------
573: --hr_utility.trace('l_data='||l_data);
574: IF p_datatype = 'T' OR p_datatype = 'D' THEN
575: l_output := '<' || trim(p_tag) || '>' || trim(l_data)
576: || ''||EOL;
577: -- hr_utility.trace('l_output='||l_output);

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

573: --hr_utility.trace('l_data='||l_data);
574: IF p_datatype = 'T' OR p_datatype = 'D' THEN
575: l_output := '<' || trim(p_tag) || '>' || trim(l_data)
576: || ''||EOL;
577: -- hr_utility.trace('l_output='||l_output);
578: ELSIF p_datatype = 'N' OR p_datatype = 'C' THEN
579: IF TRIM(p_format) IS NOT NULL THEN
580: SELECT to_char(to_number(p_data), p_format)
581: INTO l_data FROM dual;

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

585: END IF;
586: l_output := '<' || trim(p_tag) || '>' || trim(l_data)
587: || ''||EOL;
588: END IF;
589: --hr_utility.trace('l_output='||l_output);
590: RETURN l_output;
591: END;
592: /**************************************************************************/
593: FUNCTION get_t4a_pp_regno(p_pactid IN NUMBER,

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

683: T619_lang_cd NUMBER :=18;
684: T619_rpt_tcd NUMBER :=19;
685:
686: BEGIN
687: hr_utility.trace('+==========================================================+');
688: hr_utility.trace('XML Transmitter');
689:
690: begin
691: select max(paa1.payroll_action_id)

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

684: T619_rpt_tcd NUMBER :=19;
685:
686: BEGIN
687: hr_utility.trace('+==========================================================+');
688: hr_utility.trace('XML Transmitter');
689:
690: begin
691: select max(paa1.payroll_action_id)
692: into l_context1

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

701: raise;
702: end;
703:
704: -- l_context1 := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
705: hr_utility.trace('PAYROLL_ACTION_ID l_context1 ='||l_context1);
706:
707: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
708: 'CAEOY_TRANSMITTER_NUMBER');
709: IF l_return IS NULL THEN

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

837: ----
838: IF l_status = FALSE THEN
839: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
840: 'CAEOY_TRANSMITTER_NAME');
841: hr_utility.set_location('Error in T4A Transmitter record',10);
842: hr_utility.set_location('Error in the following fields: ' || l_field_name,20);
843: hr_utility.trace('Technical contact details missing');
844: hr_utility.set_message(801,'PAY_74158_INCORRECT_TCHN_INFO');
845: hr_utility.set_message_token('GRE_NAME',l_return);

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

838: IF l_status = FALSE THEN
839: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
840: 'CAEOY_TRANSMITTER_NAME');
841: hr_utility.set_location('Error in T4A Transmitter record',10);
842: hr_utility.set_location('Error in the following fields: ' || l_field_name,20);
843: hr_utility.trace('Technical contact details missing');
844: hr_utility.set_message(801,'PAY_74158_INCORRECT_TCHN_INFO');
845: hr_utility.set_message_token('GRE_NAME',l_return);
846: pay_core_utils.push_message(801,'PAY_74158_INCORRECT_TCHN_INFO','P');

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

839: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
840: 'CAEOY_TRANSMITTER_NAME');
841: hr_utility.set_location('Error in T4A Transmitter record',10);
842: hr_utility.set_location('Error in the following fields: ' || l_field_name,20);
843: hr_utility.trace('Technical contact details missing');
844: hr_utility.set_message(801,'PAY_74158_INCORRECT_TCHN_INFO');
845: hr_utility.set_message_token('GRE_NAME',l_return);
846: pay_core_utils.push_message(801,'PAY_74158_INCORRECT_TCHN_INFO','P');
847: pay_core_utils.push_token('GRE_NAME',l_return);

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

840: 'CAEOY_TRANSMITTER_NAME');
841: hr_utility.set_location('Error in T4A Transmitter record',10);
842: hr_utility.set_location('Error in the following fields: ' || l_field_name,20);
843: hr_utility.trace('Technical contact details missing');
844: hr_utility.set_message(801,'PAY_74158_INCORRECT_TCHN_INFO');
845: hr_utility.set_message_token('GRE_NAME',l_return);
846: pay_core_utils.push_message(801,'PAY_74158_INCORRECT_TCHN_INFO','P');
847: pay_core_utils.push_token('GRE_NAME',l_return);
848: hr_utility.raise_error;

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

841: hr_utility.set_location('Error in T4A Transmitter record',10);
842: hr_utility.set_location('Error in the following fields: ' || l_field_name,20);
843: hr_utility.trace('Technical contact details missing');
844: hr_utility.set_message(801,'PAY_74158_INCORRECT_TCHN_INFO');
845: hr_utility.set_message_token('GRE_NAME',l_return);
846: pay_core_utils.push_message(801,'PAY_74158_INCORRECT_TCHN_INFO','P');
847: pay_core_utils.push_token('GRE_NAME',l_return);
848: hr_utility.raise_error;
849: END IF;

Line 848: hr_utility.raise_error;

844: hr_utility.set_message(801,'PAY_74158_INCORRECT_TCHN_INFO');
845: hr_utility.set_message_token('GRE_NAME',l_return);
846: pay_core_utils.push_message(801,'PAY_74158_INCORRECT_TCHN_INFO','P');
847: pay_core_utils.push_token('GRE_NAME',l_return);
848: hr_utility.raise_error;
849: END IF;
850: ----
851: l_final_xml := '' || EOL
852: || ''|| EOL||

Line 878: hr_utility.trace(l_final_xml);

874: tab_transmitter(T619_cntc_extn_nbr)||
875: tab_transmitter(T619_cntc_email_area)||
876: '' || EOL||
877: '' || EOL;
878: hr_utility.trace(l_final_xml);
879: pay_core_files.write_to_magtape_lob(l_final_xml);
880: hr_utility.trace('X==========================================================X');
881: END;
882: END t4a_cancel_mag_transmitter;

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

876: '' || EOL||
877: '' || EOL;
878: hr_utility.trace(l_final_xml);
879: pay_core_files.write_to_magtape_lob(l_final_xml);
880: hr_utility.trace('X==========================================================X');
881: END;
882: END t4a_cancel_mag_transmitter;
883: /*****************************************************************************/
884:

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

888: l_final_xml CLOB;
889: l_final_xml_string VARCHAR2(32000);
890: l_is_temp_final_xml VARCHAR2(2);
891: BEGIN
892: hr_utility.trace('+==========================================================+');
893: hr_utility.trace('Entering end_of_file');
894: l_final_xml_string := '';
895:
896: hr_utility.trace(l_final_xml_string );

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

889: l_final_xml_string VARCHAR2(32000);
890: l_is_temp_final_xml VARCHAR2(2);
891: BEGIN
892: hr_utility.trace('+==========================================================+');
893: hr_utility.trace('Entering end_of_file');
894: l_final_xml_string := '';
895:
896: hr_utility.trace(l_final_xml_string );
897: pay_core_files.write_to_magtape_lob(l_final_xml_string);

Line 896: hr_utility.trace(l_final_xml_string );

892: hr_utility.trace('+==========================================================+');
893: hr_utility.trace('Entering end_of_file');
894: l_final_xml_string := '';
895:
896: hr_utility.trace(l_final_xml_string );
897: pay_core_files.write_to_magtape_lob(l_final_xml_string);
898: hr_utility.trace('Exiting end_of_file');
899: hr_utility.trace('X==========================================================X');
900: END;

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

894: l_final_xml_string := '';
895:
896: hr_utility.trace(l_final_xml_string );
897: pay_core_files.write_to_magtape_lob(l_final_xml_string);
898: hr_utility.trace('Exiting end_of_file');
899: hr_utility.trace('X==========================================================X');
900: END;
901: END end_of_file;
902: /*****************************************************************************/

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

895:
896: hr_utility.trace(l_final_xml_string );
897: pay_core_files.write_to_magtape_lob(l_final_xml_string);
898: hr_utility.trace('Exiting end_of_file');
899: hr_utility.trace('X==========================================================X');
900: END;
901: END end_of_file;
902: /*****************************************************************************/
903:

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

908: EOL VARCHAR2(5) := fnd_global.local_chr(13)
909: || fnd_global.local_chr(10);
910:
911: BEGIN
912: hr_utility.trace('+==========================================================+');
913: hr_utility.trace('Entering t4a_amend_employer_start');
914: l_final_xml_string := ''||EOL||''||EOL;
915: hr_utility.trace(l_final_xml_string);
916: pay_core_files.write_to_magtape_lob(l_final_xml_string);

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

909: || fnd_global.local_chr(10);
910:
911: BEGIN
912: hr_utility.trace('+==========================================================+');
913: hr_utility.trace('Entering t4a_amend_employer_start');
914: l_final_xml_string := ''||EOL||''||EOL;
915: hr_utility.trace(l_final_xml_string);
916: pay_core_files.write_to_magtape_lob(l_final_xml_string);
917: hr_utility.trace('Exiting t4a_amend_employer_start');

Line 915: hr_utility.trace(l_final_xml_string);

911: BEGIN
912: hr_utility.trace('+==========================================================+');
913: hr_utility.trace('Entering t4a_amend_employer_start');
914: l_final_xml_string := ''||EOL||''||EOL;
915: hr_utility.trace(l_final_xml_string);
916: pay_core_files.write_to_magtape_lob(l_final_xml_string);
917: hr_utility.trace('Exiting t4a_amend_employer_start');
918: hr_utility.trace('X==========================================================X');
919: END;

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

913: hr_utility.trace('Entering t4a_amend_employer_start');
914: l_final_xml_string := ''||EOL||''||EOL;
915: hr_utility.trace(l_final_xml_string);
916: pay_core_files.write_to_magtape_lob(l_final_xml_string);
917: hr_utility.trace('Exiting t4a_amend_employer_start');
918: hr_utility.trace('X==========================================================X');
919: END;
920: END t4a_cancel_employer_start;
921:

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

914: l_final_xml_string := ''||EOL||''||EOL;
915: hr_utility.trace(l_final_xml_string);
916: pay_core_files.write_to_magtape_lob(l_final_xml_string);
917: hr_utility.trace('Exiting t4a_amend_employer_start');
918: hr_utility.trace('X==========================================================X');
919: END;
920: END t4a_cancel_employer_start;
921:
922: /*****************************************************************************/

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

959: T4ASummary_pprtr_2_sin NUMBER :=20;
960: T4ASummary_rpt_tcd NUMBER :=21;
961:
962: BEGIN
963: hr_utility.trace('+==========================================================+');
964: hr_utility.trace('Entering t4a_amend_employer_record');
965: l_context1 := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
966: l_transfer_pact_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
967: l_transfer_tax_unit_id := pay_magtape_generic.get_parameter_value('TRANSMITTER_GRE');

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

960: T4ASummary_rpt_tcd NUMBER :=21;
961:
962: BEGIN
963: hr_utility.trace('+==========================================================+');
964: hr_utility.trace('Entering t4a_amend_employer_record');
965: l_context1 := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
966: l_transfer_pact_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
967: l_transfer_tax_unit_id := pay_magtape_generic.get_parameter_value('TRANSMITTER_GRE');
968: hr_utility.trace('PAYROLL_ACTION_ID l_context1 = ' ||l_context1);

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

964: hr_utility.trace('Entering t4a_amend_employer_record');
965: l_context1 := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
966: l_transfer_pact_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
967: l_transfer_tax_unit_id := pay_magtape_generic.get_parameter_value('TRANSMITTER_GRE');
968: hr_utility.trace('PAYROLL_ACTION_ID l_context1 = ' ||l_context1);
969: hr_utility.trace('TRANSFER_PAYROLL_ACTION_ID l_transfer_pact_id = ' ||l_transfer_pact_id);
970: hr_utility.trace('TRANSMITTER_GRE l_transfer_tax_unit_id = ' ||l_transfer_tax_unit_id);
971: ----
972: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

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

965: l_context1 := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
966: l_transfer_pact_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
967: l_transfer_tax_unit_id := pay_magtape_generic.get_parameter_value('TRANSMITTER_GRE');
968: hr_utility.trace('PAYROLL_ACTION_ID l_context1 = ' ||l_context1);
969: hr_utility.trace('TRANSFER_PAYROLL_ACTION_ID l_transfer_pact_id = ' ||l_transfer_pact_id);
970: hr_utility.trace('TRANSMITTER_GRE l_transfer_tax_unit_id = ' ||l_transfer_tax_unit_id);
971: ----
972: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
973: 'CAEOY_EMPLOYER_IDENTIFICATION_NUMBER');

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

966: l_transfer_pact_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
967: l_transfer_tax_unit_id := pay_magtape_generic.get_parameter_value('TRANSMITTER_GRE');
968: hr_utility.trace('PAYROLL_ACTION_ID l_context1 = ' ||l_context1);
969: hr_utility.trace('TRANSFER_PAYROLL_ACTION_ID l_transfer_pact_id = ' ||l_transfer_pact_id);
970: hr_utility.trace('TRANSMITTER_GRE l_transfer_tax_unit_id = ' ||l_transfer_tax_unit_id);
971: ----
972: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
973: 'CAEOY_EMPLOYER_IDENTIFICATION_NUMBER');
974: tab_employer(T4ASummary_bn):= convert_2_xml(l_return,'bn');

Line 1128: hr_utility.trace(l_final_xml_string);

1124: ''||EOL||
1125: tab_employer(T4ASummary_rpt_tcd)||
1126: '' || EOL||
1127: ''||EOL||''||EOL;
1128: hr_utility.trace(l_final_xml_string);
1129: pay_core_files.write_to_magtape_lob(l_final_xml_string);
1130: hr_utility.trace('X==========================================================X');
1131: END;
1132: END t4a_cancel_employer_record;

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

1126: '' || EOL||
1127: ''||EOL||''||EOL;
1128: hr_utility.trace(l_final_xml_string);
1129: pay_core_files.write_to_magtape_lob(l_final_xml_string);
1130: hr_utility.trace('X==========================================================X');
1131: END;
1132: END t4a_cancel_employer_record;
1133: /*****************************************************************************/
1134:

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

1236: pay_assignment_actions
1237: WHERE assignment_action_id = p_mag_asg_action_id;
1238:
1239: BEGIN
1240: hr_utility.trace('+==========================================================+');
1241: hr_utility.trace('Employee Record');
1242:
1243: l_payroll_actid := to_number(pay_magtape_generic.get_parameter_value
1244: ('TRANSFER_PAYROLL_ACTION_ID'));

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

1237: WHERE assignment_action_id = p_mag_asg_action_id;
1238:
1239: BEGIN
1240: hr_utility.trace('+==========================================================+');
1241: hr_utility.trace('Employee Record');
1242:
1243: l_payroll_actid := to_number(pay_magtape_generic.get_parameter_value
1244: ('TRANSFER_PAYROLL_ACTION_ID'));
1245: hr_utility.trace('T4A_CANCEL_MAG Payroll action ='||l_payroll_actid);

Line 1245: hr_utility.trace('T4A_CANCEL_MAG Payroll action ='||l_payroll_actid);

1241: hr_utility.trace('Employee Record');
1242:
1243: l_payroll_actid := to_number(pay_magtape_generic.get_parameter_value
1244: ('TRANSFER_PAYROLL_ACTION_ID'));
1245: hr_utility.trace('T4A_CANCEL_MAG Payroll action ='||l_payroll_actid);
1246:
1247: l_mag_asg_action_id := to_number(pay_magtape_generic.get_parameter_value
1248: ('TRANSFER_ACT_ID'));
1249: hr_utility.trace('T4A_CANCEL_MAG Assignment action ='|| to_char(l_mag_asg_action_id));

Line 1249: hr_utility.trace('T4A_CANCEL_MAG Assignment action ='|| to_char(l_mag_asg_action_id));

1245: hr_utility.trace('T4A_CANCEL_MAG Payroll action ='||l_payroll_actid);
1246:
1247: l_mag_asg_action_id := to_number(pay_magtape_generic.get_parameter_value
1248: ('TRANSFER_ACT_ID'));
1249: hr_utility.trace('T4A_CANCEL_MAG Assignment action ='|| to_char(l_mag_asg_action_id));
1250:
1251: OPEN c_get_payroll_asg_actid(l_mag_asg_action_id);
1252: FETCH c_get_payroll_asg_actid INTO l_arch_action_id, l_arch_pay_actid;
1253: CLOSE c_get_payroll_asg_actid;

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

1250:
1251: OPEN c_get_payroll_asg_actid(l_mag_asg_action_id);
1252: FETCH c_get_payroll_asg_actid INTO l_arch_action_id, l_arch_pay_actid;
1253: CLOSE c_get_payroll_asg_actid;
1254: hr_utility.trace('Archiver Assignment action='|| l_arch_action_id);
1255: hr_utility.trace('Archiver Payroll action='|| l_arch_pay_actid);
1256: ----
1257: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1258: ,'CAEOY_T4A_NEGATIVE_BALANCE_EXISTS');

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

1251: OPEN c_get_payroll_asg_actid(l_mag_asg_action_id);
1252: FETCH c_get_payroll_asg_actid INTO l_arch_action_id, l_arch_pay_actid;
1253: CLOSE c_get_payroll_asg_actid;
1254: hr_utility.trace('Archiver Assignment action='|| l_arch_action_id);
1255: hr_utility.trace('Archiver Payroll action='|| l_arch_pay_actid);
1256: ----
1257: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1258: ,'CAEOY_T4A_NEGATIVE_BALANCE_EXISTS');
1259:

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

1266: /* T4ASlip Tags begin*/
1267: OPEN c_get_person_id(l_mag_asg_action_id);
1268: FETCH c_get_person_id INTO l_person_id;
1269: CLOSE c_get_person_id;
1270: hr_utility.trace('Person ID ='||l_person_id);
1271: ----1
1272: l_return := pay_ca_emp_address_dtls.get_emp_address(l_person_id,
1273: l_address_line1,
1274: l_address_line2,

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

1525: tab_other_info_tag(47) := 'lsp_dpsp_nelg_amt';
1526: tab_other_info_tag(48) := 'lsp_nrgst_pens_amt';
1527:
1528: IF l_status THEN
1529: hr_utility.trace('Status = Success');
1530: ELSE
1531: hr_utility.trace('Status = Fail');
1532: END IF;
1533:

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

1527:
1528: IF l_status THEN
1529: hr_utility.trace('Status = Success');
1530: ELSE
1531: hr_utility.trace('Status = Fail');
1532: END IF;
1533:
1534:
1535: l_other_info_xml_string(1) := ' ';

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

1543: ,tab_other_info_dbi(i));
1544:
1545: IF nvl(l_return,0)<>0 THEN
1546: l_return_xml := convert_2_xml(l_return ,tab_other_info_tag(i),'C');
1547: hr_utility.trace(tab_other_info_dbi(i)||' => '||l_return_xml);
1548: l_other_info_count := l_other_info_count+1;
1549: IF l_status = FALSE THEN --Error report has single record A02
1550: l_other_info_xml_string(1) := l_other_info_xml_string(1)||l_return_xml;
1551: ELSIF l_status = TRUE THEN --Success report has multiple records

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

1564: END IF;
1565: END IF;
1566: END LOOP;
1567:
1568: hr_utility.trace('Other_info_count = '||l_other_info_count ||', Other_info_sets = '||l_other_info_sets);
1569:
1570: /* OTH_INFO Tags end */
1571: /*****************************************************************************/
1572: /* Final XML Generation begin */

Line 1605: hr_utility.trace(l_final_xml_string);

1601: l_final_xml_string:=l_final_xml_string||''||l_error_message||''
1602: ||EOL||''||EOL;
1603: END IF;
1604:
1605: hr_utility.trace(l_final_xml_string);
1606: pay_core_files.write_to_magtape_lob(l_final_xml_string);
1607: hr_utility.trace('X==========================================================X');
1608:
1609: /* Final XML Generation end */

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

1603: END IF;
1604:
1605: hr_utility.trace(l_final_xml_string);
1606: pay_core_files.write_to_magtape_lob(l_final_xml_string);
1607: hr_utility.trace('X==========================================================X');
1608:
1609: /* Final XML Generation end */
1610: /*****************************************************************************/
1611: END;