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.

[Home] [Help]

APPS.PAY_CA_T4_MAG dependencies on HR_UTILITY

Line 32: /* hr_utility.trace_on('Y','T4MAG'); */

28: p_business_group_id IN OUT NOCOPY NUMBER,
29: p_legislative_parameters OUT NOCOPY VARCHAR2
30: ) IS
31: BEGIN
32: /* hr_utility.trace_on('Y','T4MAG'); */
33: hr_utility.set_location
34: ('pay_ca_t4_mag.get_report_parameters', 10);
35:
36: SELECT ppa.start_date,

Line 33: hr_utility.set_location

29: p_legislative_parameters OUT NOCOPY VARCHAR2
30: ) IS
31: BEGIN
32: /* hr_utility.trace_on('Y','T4MAG'); */
33: hr_utility.set_location
34: ('pay_ca_t4_mag.get_report_parameters', 10);
35:
36: SELECT ppa.start_date,
37: ppa.effective_date,

Line 49: hr_utility.set_location

45: p_legislative_parameters
46: FROM pay_payroll_actions ppa
47: WHERE payroll_action_id = p_pactid;
48:
49: hr_utility.set_location
50: ('pay_ca_t4_mag.get_report_parameters', 20);
51:
52: END get_report_parameters;
53:

Line 80: hr_utility.set_location( 'pay_ca_t4_mag.range_cursor', 10);

76: l_legislative_parameters VARCHAR2(200);
77:
78: BEGIN
79:
80: hr_utility.set_location( 'pay_ca_t4_mag.range_cursor', 10);
81:
82: get_report_parameters(
83: p_pactid,
84: p_year_start,

Line 91: hr_utility.set_location( 'pay_ca_t4_mag.range_cursor', 20);

87: p_business_group_id,
88: l_legislative_parameters
89: );
90:
91: hr_utility.set_location( 'pay_ca_t4_mag.range_cursor', 20);
92:
93: p_sqlstr := 'select distinct to_number(fai1.value)
94: from ff_archive_items fai1,
95: ff_database_items fdi1,

Line 116: hr_utility.set_location( 'pay_ca_t4_mag.range_cursor',

112: and fai1.user_entity_id = fdi1.user_entity_id
113: and fdi1.user_name = ''CAEOY_PERSON_ID''
114: order by to_number(fai1.value)' ;
115:
116: hr_utility.set_location( 'pay_ca_t4_mag.range_cursor',
117: 30);
118:
119: END range_cursor;
120:

Line 212: hr_utility.set_location( 'pay_ca_t4_mag.create_assignement_act',10);

208: BEGIN
209:
210: /* Get the report parameters. These define the report being run.*/
211:
212: hr_utility.set_location( 'pay_ca_t4_mag.create_assignement_act',10);
213:
214: get_report_parameters(
215: p_pactid,
216: l_year_start,

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

223: /* Open the appropriate cursor */
224:
225: l_trans_gre := pay_ca_t4a_mag.get_parameter('TRANSMITTER_GRE',
226: l_legislative_parameters);
227: hr_utility.trace('l_trans_gre ='||l_trans_gre);
228: l_validate_gre := pay_ca_t4_mag.validate_gre_data(l_trans_gre, to_char(l_year_end,'YYYY'));
229: hr_utility.set_location( 'pay_ca_t4_mag.create_assignement_act',20);
230:
231: IF l_report_type = 'PYT4MAG' THEN

Line 229: hr_utility.set_location( 'pay_ca_t4_mag.create_assignement_act',20);

225: l_trans_gre := pay_ca_t4a_mag.get_parameter('TRANSMITTER_GRE',
226: l_legislative_parameters);
227: hr_utility.trace('l_trans_gre ='||l_trans_gre);
228: l_validate_gre := pay_ca_t4_mag.validate_gre_data(l_trans_gre, to_char(l_year_end,'YYYY'));
229: hr_utility.set_location( 'pay_ca_t4_mag.create_assignement_act',20);
230:
231: IF l_report_type = 'PYT4MAG' THEN
232: OPEN c_all_asg;
233: LOOP

Line 240: hr_utility.set_location(

236: l_tax_unit_id,
237: l_effective_end_date,
238: l_assignment_action_id;
239:
240: hr_utility.set_location(
241: 'pay_ca_t4_mag.create_assignement_act', 30);
242:
243: EXIT WHEN c_all_asg%NOTFOUND;
244:

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

244:
245:
246: /* Create the assignment action for the record */
247:
248: hr_utility.trace('Assignment Fetched - ');
249: hr_utility.trace('Assignment Id : '|| to_char(l_assignment_id));
250: hr_utility.trace('Person Id : '|| to_char(l_person_id));
251: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
252: hr_utility.trace('Effective End Date : '||

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

245:
246: /* Create the assignment action for the record */
247:
248: hr_utility.trace('Assignment Fetched - ');
249: hr_utility.trace('Assignment Id : '|| to_char(l_assignment_id));
250: hr_utility.trace('Person Id : '|| to_char(l_person_id));
251: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
252: hr_utility.trace('Effective End Date : '||
253: to_char(l_effective_end_date));

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

246: /* Create the assignment action for the record */
247:
248: hr_utility.trace('Assignment Fetched - ');
249: hr_utility.trace('Assignment Id : '|| to_char(l_assignment_id));
250: hr_utility.trace('Person Id : '|| to_char(l_person_id));
251: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
252: hr_utility.trace('Effective End Date : '||
253: to_char(l_effective_end_date));
254:

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

247:
248: hr_utility.trace('Assignment Fetched - ');
249: hr_utility.trace('Assignment Id : '|| to_char(l_assignment_id));
250: hr_utility.trace('Person Id : '|| to_char(l_person_id));
251: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
252: hr_utility.trace('Effective End Date : '||
253: to_char(l_effective_end_date));
254:
255: hr_utility.set_location(

Line 252: hr_utility.trace('Effective End Date : '||

248: hr_utility.trace('Assignment Fetched - ');
249: hr_utility.trace('Assignment Id : '|| to_char(l_assignment_id));
250: hr_utility.trace('Person Id : '|| to_char(l_person_id));
251: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
252: hr_utility.trace('Effective End Date : '||
253: to_char(l_effective_end_date));
254:
255: hr_utility.set_location(
256: 'pay_ca_t4_mag.create_assignement_act', 40);

Line 255: hr_utility.set_location(

251: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
252: hr_utility.trace('Effective End Date : '||
253: to_char(l_effective_end_date));
254:
255: hr_utility.set_location(
256: 'pay_ca_t4_mag.create_assignement_act', 40);
257:
258: SELECT pay_assignment_actions_s.nextval
259: INTO lockingactid

Line 262: hr_utility.set_location(

258: SELECT pay_assignment_actions_s.nextval
259: INTO lockingactid
260: FROM dual;
261:
262: hr_utility.set_location(
263: 'pay_ca_t4_mag.create_assignement_act', 50);
264:
265: hr_nonrun_asact.insact(lockingactid, l_assignment_id, p_pactid,p_chunk, l_tax_unit_id);
266:

Line 267: hr_utility.set_location(

263: 'pay_ca_t4_mag.create_assignement_act', 50);
264:
265: hr_nonrun_asact.insact(lockingactid, l_assignment_id, p_pactid,p_chunk, l_tax_unit_id);
266:
267: hr_utility.set_location(
268: 'pay_ca_t4_mag.create_assignement_act', 60);
269:
270: hr_nonrun_asact.insint(lockingactid, l_assignment_action_id);
271:

Line 272: hr_utility.set_location(

268: 'pay_ca_t4_mag.create_assignement_act', 60);
269:
270: hr_nonrun_asact.insint(lockingactid, l_assignment_action_id);
271:
272: hr_utility.set_location(
273: 'pay_ca_t4_mag.create_assignement_act', 70);
274:
275: hr_utility.trace('Interlock Created - ');
276: hr_utility.trace('Locking Action : '|| to_char(lockingactid));

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

271:
272: hr_utility.set_location(
273: 'pay_ca_t4_mag.create_assignement_act', 70);
274:
275: hr_utility.trace('Interlock Created - ');
276: hr_utility.trace('Locking Action : '|| to_char(lockingactid));
277: hr_utility.trace('Locked Action : '|| to_char(l_assignment_action_id));
278:
279: END LOOP;

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

272: hr_utility.set_location(
273: 'pay_ca_t4_mag.create_assignement_act', 70);
274:
275: hr_utility.trace('Interlock Created - ');
276: hr_utility.trace('Locking Action : '|| to_char(lockingactid));
277: hr_utility.trace('Locked Action : '|| to_char(l_assignment_action_id));
278:
279: END LOOP;
280: Close c_all_asg;

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

273: 'pay_ca_t4_mag.create_assignement_act', 70);
274:
275: hr_utility.trace('Interlock Created - ');
276: hr_utility.trace('Locking Action : '|| to_char(lockingactid));
277: hr_utility.trace('Locked Action : '|| to_char(l_assignment_action_id));
278:
279: END LOOP;
280: Close c_all_asg;
281: END IF;

Line 560: hr_utility.trace('p_assignment_action_id = '||p_assignment_action_id);

556: --l_transfer_oth4_rep1 := rpad(lpad('.00,',12), 10*12, lpad('.00,',12));
557: --l_transfer_oth4_rep2 := rpad(lpad('.00,',12), 10*12, lpad('.00,',12));
558: l_transfer_oth4_rep3 := rpad(lpad('.00,',12), 4*12, lpad('.00,',12));
559:
560: hr_utility.trace('p_assignment_action_id = '||p_assignment_action_id);
561: hr_utility.trace('p_payroll_action_id = '||p_payroll_action_id);
562: hr_utility.trace('p_fail = '||p_fail);
563:
564: for i in 1..t_dbi.COUNT

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

557: --l_transfer_oth4_rep2 := rpad(lpad('.00,',12), 10*12, lpad('.00,',12));
558: l_transfer_oth4_rep3 := rpad(lpad('.00,',12), 4*12, lpad('.00,',12));
559:
560: hr_utility.trace('p_assignment_action_id = '||p_assignment_action_id);
561: hr_utility.trace('p_payroll_action_id = '||p_payroll_action_id);
562: hr_utility.trace('p_fail = '||p_fail);
563:
564: for i in 1..t_dbi.COUNT
565: loop

Line 562: hr_utility.trace('p_fail = '||p_fail);

558: l_transfer_oth4_rep3 := rpad(lpad('.00,',12), 4*12, lpad('.00,',12));
559:
560: hr_utility.trace('p_assignment_action_id = '||p_assignment_action_id);
561: hr_utility.trace('p_payroll_action_id = '||p_payroll_action_id);
562: hr_utility.trace('p_fail = '||p_fail);
563:
564: for i in 1..t_dbi.COUNT
565: loop
566: l_amt := fnd_number.canonical_to_number(get_arch_val(p_assignment_action_id,t_dbi(i)));

Line 575: hr_utility.trace('l_other_info = '||l_other_info);

571: l_other_info := CONVERT_2_XML(l_amt, t_tag(i), 'C'); -- Bug 7424296
572: end if;
573: l_cnt := l_cnt+1;
574:
575: hr_utility.trace('l_other_info = '||l_other_info);
576: hr_utility.trace('l_cnt = '||l_cnt);
577:
578: if l_cnt <= 3 then
579: l_write_f30 := l_write_f30||l_other_info;

Line 576: hr_utility.trace('l_cnt = '||l_cnt);

572: end if;
573: l_cnt := l_cnt+1;
574:
575: hr_utility.trace('l_other_info = '||l_other_info);
576: hr_utility.trace('l_cnt = '||l_cnt);
577:
578: if l_cnt <= 3 then
579: l_write_f30 := l_write_f30||l_other_info;
580: elsif l_cnt <=6 then

Line 746: hr_utility.trace('p_cnt = '|| l_cnt);

742: p_transfer_oth3_rep3 := l_transfer_oth3_rep3;
743: p_transfer_oth4_rep3 := l_transfer_oth4_rep3;
744:
745: /*
746: hr_utility.trace('p_cnt = '|| l_cnt);
747: hr_utility.trace('p_oth_rep1 = '|| l_oth_rep1);
748: hr_utility.trace('p_oth_rep2 = '|| l_oth_rep2);
749: hr_utility.trace('p_oth_rep3 = '|| l_oth_rep3);
750: hr_utility.trace('write_f30 = '|| l_write_f30);

Line 747: hr_utility.trace('p_oth_rep1 = '|| l_oth_rep1);

743: p_transfer_oth4_rep3 := l_transfer_oth4_rep3;
744:
745: /*
746: hr_utility.trace('p_cnt = '|| l_cnt);
747: hr_utility.trace('p_oth_rep1 = '|| l_oth_rep1);
748: hr_utility.trace('p_oth_rep2 = '|| l_oth_rep2);
749: hr_utility.trace('p_oth_rep3 = '|| l_oth_rep3);
750: hr_utility.trace('write_f30 = '|| l_write_f30);
751: hr_utility.trace('p_write_f31 = '|| l_write_f31);

Line 748: hr_utility.trace('p_oth_rep2 = '|| l_oth_rep2);

744:
745: /*
746: hr_utility.trace('p_cnt = '|| l_cnt);
747: hr_utility.trace('p_oth_rep1 = '|| l_oth_rep1);
748: hr_utility.trace('p_oth_rep2 = '|| l_oth_rep2);
749: hr_utility.trace('p_oth_rep3 = '|| l_oth_rep3);
750: hr_utility.trace('write_f30 = '|| l_write_f30);
751: hr_utility.trace('p_write_f31 = '|| l_write_f31);
752: hr_utility.trace('p_transfer_other_info1_str1 = '|| l_transfer_other_info1_str1);

Line 749: hr_utility.trace('p_oth_rep3 = '|| l_oth_rep3);

745: /*
746: hr_utility.trace('p_cnt = '|| l_cnt);
747: hr_utility.trace('p_oth_rep1 = '|| l_oth_rep1);
748: hr_utility.trace('p_oth_rep2 = '|| l_oth_rep2);
749: hr_utility.trace('p_oth_rep3 = '|| l_oth_rep3);
750: hr_utility.trace('write_f30 = '|| l_write_f30);
751: hr_utility.trace('p_write_f31 = '|| l_write_f31);
752: hr_utility.trace('p_transfer_other_info1_str1 = '|| l_transfer_other_info1_str1);
753: hr_utility.trace('p_transfer_other_info1_str2 = '|| l_transfer_other_info1_str2);

Line 750: hr_utility.trace('write_f30 = '|| l_write_f30);

746: hr_utility.trace('p_cnt = '|| l_cnt);
747: hr_utility.trace('p_oth_rep1 = '|| l_oth_rep1);
748: hr_utility.trace('p_oth_rep2 = '|| l_oth_rep2);
749: hr_utility.trace('p_oth_rep3 = '|| l_oth_rep3);
750: hr_utility.trace('write_f30 = '|| l_write_f30);
751: hr_utility.trace('p_write_f31 = '|| l_write_f31);
752: hr_utility.trace('p_transfer_other_info1_str1 = '|| l_transfer_other_info1_str1);
753: hr_utility.trace('p_transfer_other_info1_str2 = '|| l_transfer_other_info1_str2);
754: hr_utility.trace('p_transfer_other_info1_str3 = '|| l_transfer_other_info1_str3);

Line 751: hr_utility.trace('p_write_f31 = '|| l_write_f31);

747: hr_utility.trace('p_oth_rep1 = '|| l_oth_rep1);
748: hr_utility.trace('p_oth_rep2 = '|| l_oth_rep2);
749: hr_utility.trace('p_oth_rep3 = '|| l_oth_rep3);
750: hr_utility.trace('write_f30 = '|| l_write_f30);
751: hr_utility.trace('p_write_f31 = '|| l_write_f31);
752: hr_utility.trace('p_transfer_other_info1_str1 = '|| l_transfer_other_info1_str1);
753: hr_utility.trace('p_transfer_other_info1_str2 = '|| l_transfer_other_info1_str2);
754: hr_utility.trace('p_transfer_other_info1_str3 = '|| l_transfer_other_info1_str3);
755: hr_utility.trace('p_transfer_other_info2_str1 = '|| l_transfer_other_info2_str1);

Line 752: hr_utility.trace('p_transfer_other_info1_str1 = '|| l_transfer_other_info1_str1);

748: hr_utility.trace('p_oth_rep2 = '|| l_oth_rep2);
749: hr_utility.trace('p_oth_rep3 = '|| l_oth_rep3);
750: hr_utility.trace('write_f30 = '|| l_write_f30);
751: hr_utility.trace('p_write_f31 = '|| l_write_f31);
752: hr_utility.trace('p_transfer_other_info1_str1 = '|| l_transfer_other_info1_str1);
753: hr_utility.trace('p_transfer_other_info1_str2 = '|| l_transfer_other_info1_str2);
754: hr_utility.trace('p_transfer_other_info1_str3 = '|| l_transfer_other_info1_str3);
755: hr_utility.trace('p_transfer_other_info2_str1 = '|| l_transfer_other_info2_str1);
756: hr_utility.trace('p_transfer_other_info2_str2 = '|| l_transfer_other_info2_str2);

Line 753: hr_utility.trace('p_transfer_other_info1_str2 = '|| l_transfer_other_info1_str2);

749: hr_utility.trace('p_oth_rep3 = '|| l_oth_rep3);
750: hr_utility.trace('write_f30 = '|| l_write_f30);
751: hr_utility.trace('p_write_f31 = '|| l_write_f31);
752: hr_utility.trace('p_transfer_other_info1_str1 = '|| l_transfer_other_info1_str1);
753: hr_utility.trace('p_transfer_other_info1_str2 = '|| l_transfer_other_info1_str2);
754: hr_utility.trace('p_transfer_other_info1_str3 = '|| l_transfer_other_info1_str3);
755: hr_utility.trace('p_transfer_other_info2_str1 = '|| l_transfer_other_info2_str1);
756: hr_utility.trace('p_transfer_other_info2_str2 = '|| l_transfer_other_info2_str2);
757: hr_utility.trace('p_transfer_other_info2_str3 = '|| l_transfer_other_info2_str3);

Line 754: hr_utility.trace('p_transfer_other_info1_str3 = '|| l_transfer_other_info1_str3);

750: hr_utility.trace('write_f30 = '|| l_write_f30);
751: hr_utility.trace('p_write_f31 = '|| l_write_f31);
752: hr_utility.trace('p_transfer_other_info1_str1 = '|| l_transfer_other_info1_str1);
753: hr_utility.trace('p_transfer_other_info1_str2 = '|| l_transfer_other_info1_str2);
754: hr_utility.trace('p_transfer_other_info1_str3 = '|| l_transfer_other_info1_str3);
755: hr_utility.trace('p_transfer_other_info2_str1 = '|| l_transfer_other_info2_str1);
756: hr_utility.trace('p_transfer_other_info2_str2 = '|| l_transfer_other_info2_str2);
757: hr_utility.trace('p_transfer_other_info2_str3 = '|| l_transfer_other_info2_str3);
758: hr_utility.trace('p_transfer_other_info3_str1 = '|| l_transfer_other_info3_str1);

Line 755: hr_utility.trace('p_transfer_other_info2_str1 = '|| l_transfer_other_info2_str1);

751: hr_utility.trace('p_write_f31 = '|| l_write_f31);
752: hr_utility.trace('p_transfer_other_info1_str1 = '|| l_transfer_other_info1_str1);
753: hr_utility.trace('p_transfer_other_info1_str2 = '|| l_transfer_other_info1_str2);
754: hr_utility.trace('p_transfer_other_info1_str3 = '|| l_transfer_other_info1_str3);
755: hr_utility.trace('p_transfer_other_info2_str1 = '|| l_transfer_other_info2_str1);
756: hr_utility.trace('p_transfer_other_info2_str2 = '|| l_transfer_other_info2_str2);
757: hr_utility.trace('p_transfer_other_info2_str3 = '|| l_transfer_other_info2_str3);
758: hr_utility.trace('p_transfer_other_info3_str1 = '|| l_transfer_other_info3_str1);
759: hr_utility.trace('p_transfer_other_info3_str2 = '|| l_transfer_other_info3_str2);

Line 756: hr_utility.trace('p_transfer_other_info2_str2 = '|| l_transfer_other_info2_str2);

752: hr_utility.trace('p_transfer_other_info1_str1 = '|| l_transfer_other_info1_str1);
753: hr_utility.trace('p_transfer_other_info1_str2 = '|| l_transfer_other_info1_str2);
754: hr_utility.trace('p_transfer_other_info1_str3 = '|| l_transfer_other_info1_str3);
755: hr_utility.trace('p_transfer_other_info2_str1 = '|| l_transfer_other_info2_str1);
756: hr_utility.trace('p_transfer_other_info2_str2 = '|| l_transfer_other_info2_str2);
757: hr_utility.trace('p_transfer_other_info2_str3 = '|| l_transfer_other_info2_str3);
758: hr_utility.trace('p_transfer_other_info3_str1 = '|| l_transfer_other_info3_str1);
759: hr_utility.trace('p_transfer_other_info3_str2 = '|| l_transfer_other_info3_str2);
760: hr_utility.trace('p_transfer_other_info3_str3 = '|| l_transfer_other_info3_str3);

Line 757: hr_utility.trace('p_transfer_other_info2_str3 = '|| l_transfer_other_info2_str3);

753: hr_utility.trace('p_transfer_other_info1_str2 = '|| l_transfer_other_info1_str2);
754: hr_utility.trace('p_transfer_other_info1_str3 = '|| l_transfer_other_info1_str3);
755: hr_utility.trace('p_transfer_other_info2_str1 = '|| l_transfer_other_info2_str1);
756: hr_utility.trace('p_transfer_other_info2_str2 = '|| l_transfer_other_info2_str2);
757: hr_utility.trace('p_transfer_other_info2_str3 = '|| l_transfer_other_info2_str3);
758: hr_utility.trace('p_transfer_other_info3_str1 = '|| l_transfer_other_info3_str1);
759: hr_utility.trace('p_transfer_other_info3_str2 = '|| l_transfer_other_info3_str2);
760: hr_utility.trace('p_transfer_other_info3_str3 = '|| l_transfer_other_info3_str3);
761: hr_utility.trace('p_transfer_other_info4_str1 = '|| l_transfer_other_info4_str1);

Line 758: hr_utility.trace('p_transfer_other_info3_str1 = '|| l_transfer_other_info3_str1);

754: hr_utility.trace('p_transfer_other_info1_str3 = '|| l_transfer_other_info1_str3);
755: hr_utility.trace('p_transfer_other_info2_str1 = '|| l_transfer_other_info2_str1);
756: hr_utility.trace('p_transfer_other_info2_str2 = '|| l_transfer_other_info2_str2);
757: hr_utility.trace('p_transfer_other_info2_str3 = '|| l_transfer_other_info2_str3);
758: hr_utility.trace('p_transfer_other_info3_str1 = '|| l_transfer_other_info3_str1);
759: hr_utility.trace('p_transfer_other_info3_str2 = '|| l_transfer_other_info3_str2);
760: hr_utility.trace('p_transfer_other_info3_str3 = '|| l_transfer_other_info3_str3);
761: hr_utility.trace('p_transfer_other_info4_str1 = '|| l_transfer_other_info4_str1);
762: hr_utility.trace('p_transfer_other_info4_str2 = '|| l_transfer_other_info4_str2);

Line 759: hr_utility.trace('p_transfer_other_info3_str2 = '|| l_transfer_other_info3_str2);

755: hr_utility.trace('p_transfer_other_info2_str1 = '|| l_transfer_other_info2_str1);
756: hr_utility.trace('p_transfer_other_info2_str2 = '|| l_transfer_other_info2_str2);
757: hr_utility.trace('p_transfer_other_info2_str3 = '|| l_transfer_other_info2_str3);
758: hr_utility.trace('p_transfer_other_info3_str1 = '|| l_transfer_other_info3_str1);
759: hr_utility.trace('p_transfer_other_info3_str2 = '|| l_transfer_other_info3_str2);
760: hr_utility.trace('p_transfer_other_info3_str3 = '|| l_transfer_other_info3_str3);
761: hr_utility.trace('p_transfer_other_info4_str1 = '|| l_transfer_other_info4_str1);
762: hr_utility.trace('p_transfer_other_info4_str2 = '|| l_transfer_other_info4_str2);
763: hr_utility.trace('p_transfer_other_info4_str3 = '|| l_transfer_other_info4_str3);

Line 760: hr_utility.trace('p_transfer_other_info3_str3 = '|| l_transfer_other_info3_str3);

756: hr_utility.trace('p_transfer_other_info2_str2 = '|| l_transfer_other_info2_str2);
757: hr_utility.trace('p_transfer_other_info2_str3 = '|| l_transfer_other_info2_str3);
758: hr_utility.trace('p_transfer_other_info3_str1 = '|| l_transfer_other_info3_str1);
759: hr_utility.trace('p_transfer_other_info3_str2 = '|| l_transfer_other_info3_str2);
760: hr_utility.trace('p_transfer_other_info3_str3 = '|| l_transfer_other_info3_str3);
761: hr_utility.trace('p_transfer_other_info4_str1 = '|| l_transfer_other_info4_str1);
762: hr_utility.trace('p_transfer_other_info4_str2 = '|| l_transfer_other_info4_str2);
763: hr_utility.trace('p_transfer_other_info4_str3 = '|| l_transfer_other_info4_str3);
764: hr_utility.trace('p_transfer_oth1_rep1 = '|| l_transfer_oth1_rep1);

Line 761: hr_utility.trace('p_transfer_other_info4_str1 = '|| l_transfer_other_info4_str1);

757: hr_utility.trace('p_transfer_other_info2_str3 = '|| l_transfer_other_info2_str3);
758: hr_utility.trace('p_transfer_other_info3_str1 = '|| l_transfer_other_info3_str1);
759: hr_utility.trace('p_transfer_other_info3_str2 = '|| l_transfer_other_info3_str2);
760: hr_utility.trace('p_transfer_other_info3_str3 = '|| l_transfer_other_info3_str3);
761: hr_utility.trace('p_transfer_other_info4_str1 = '|| l_transfer_other_info4_str1);
762: hr_utility.trace('p_transfer_other_info4_str2 = '|| l_transfer_other_info4_str2);
763: hr_utility.trace('p_transfer_other_info4_str3 = '|| l_transfer_other_info4_str3);
764: hr_utility.trace('p_transfer_oth1_rep1 = '|| l_transfer_oth1_rep1);
765: hr_utility.trace('p_transfer_oth1_rep2 = '|| l_transfer_oth1_rep2);

Line 762: hr_utility.trace('p_transfer_other_info4_str2 = '|| l_transfer_other_info4_str2);

758: hr_utility.trace('p_transfer_other_info3_str1 = '|| l_transfer_other_info3_str1);
759: hr_utility.trace('p_transfer_other_info3_str2 = '|| l_transfer_other_info3_str2);
760: hr_utility.trace('p_transfer_other_info3_str3 = '|| l_transfer_other_info3_str3);
761: hr_utility.trace('p_transfer_other_info4_str1 = '|| l_transfer_other_info4_str1);
762: hr_utility.trace('p_transfer_other_info4_str2 = '|| l_transfer_other_info4_str2);
763: hr_utility.trace('p_transfer_other_info4_str3 = '|| l_transfer_other_info4_str3);
764: hr_utility.trace('p_transfer_oth1_rep1 = '|| l_transfer_oth1_rep1);
765: hr_utility.trace('p_transfer_oth1_rep2 = '|| l_transfer_oth1_rep2);
766: hr_utility.trace('p_transfer_oth1_rep3 = '|| l_transfer_oth1_rep3);

Line 763: hr_utility.trace('p_transfer_other_info4_str3 = '|| l_transfer_other_info4_str3);

759: hr_utility.trace('p_transfer_other_info3_str2 = '|| l_transfer_other_info3_str2);
760: hr_utility.trace('p_transfer_other_info3_str3 = '|| l_transfer_other_info3_str3);
761: hr_utility.trace('p_transfer_other_info4_str1 = '|| l_transfer_other_info4_str1);
762: hr_utility.trace('p_transfer_other_info4_str2 = '|| l_transfer_other_info4_str2);
763: hr_utility.trace('p_transfer_other_info4_str3 = '|| l_transfer_other_info4_str3);
764: hr_utility.trace('p_transfer_oth1_rep1 = '|| l_transfer_oth1_rep1);
765: hr_utility.trace('p_transfer_oth1_rep2 = '|| l_transfer_oth1_rep2);
766: hr_utility.trace('p_transfer_oth1_rep3 = '|| l_transfer_oth1_rep3);
767: hr_utility.trace('p_transfer_oth2_rep2 = '|| l_transfer_oth2_rep2);

Line 764: hr_utility.trace('p_transfer_oth1_rep1 = '|| l_transfer_oth1_rep1);

760: hr_utility.trace('p_transfer_other_info3_str3 = '|| l_transfer_other_info3_str3);
761: hr_utility.trace('p_transfer_other_info4_str1 = '|| l_transfer_other_info4_str1);
762: hr_utility.trace('p_transfer_other_info4_str2 = '|| l_transfer_other_info4_str2);
763: hr_utility.trace('p_transfer_other_info4_str3 = '|| l_transfer_other_info4_str3);
764: hr_utility.trace('p_transfer_oth1_rep1 = '|| l_transfer_oth1_rep1);
765: hr_utility.trace('p_transfer_oth1_rep2 = '|| l_transfer_oth1_rep2);
766: hr_utility.trace('p_transfer_oth1_rep3 = '|| l_transfer_oth1_rep3);
767: hr_utility.trace('p_transfer_oth2_rep2 = '|| l_transfer_oth2_rep2);
768: hr_utility.trace('p_transfer_oth2_rep3 = '|| l_transfer_oth2_rep3);

Line 765: hr_utility.trace('p_transfer_oth1_rep2 = '|| l_transfer_oth1_rep2);

761: hr_utility.trace('p_transfer_other_info4_str1 = '|| l_transfer_other_info4_str1);
762: hr_utility.trace('p_transfer_other_info4_str2 = '|| l_transfer_other_info4_str2);
763: hr_utility.trace('p_transfer_other_info4_str3 = '|| l_transfer_other_info4_str3);
764: hr_utility.trace('p_transfer_oth1_rep1 = '|| l_transfer_oth1_rep1);
765: hr_utility.trace('p_transfer_oth1_rep2 = '|| l_transfer_oth1_rep2);
766: hr_utility.trace('p_transfer_oth1_rep3 = '|| l_transfer_oth1_rep3);
767: hr_utility.trace('p_transfer_oth2_rep2 = '|| l_transfer_oth2_rep2);
768: hr_utility.trace('p_transfer_oth2_rep3 = '|| l_transfer_oth2_rep3);
769: hr_utility.trace('p_transfer_oth3_rep2 = '|| l_transfer_oth3_rep2);

Line 766: hr_utility.trace('p_transfer_oth1_rep3 = '|| l_transfer_oth1_rep3);

762: hr_utility.trace('p_transfer_other_info4_str2 = '|| l_transfer_other_info4_str2);
763: hr_utility.trace('p_transfer_other_info4_str3 = '|| l_transfer_other_info4_str3);
764: hr_utility.trace('p_transfer_oth1_rep1 = '|| l_transfer_oth1_rep1);
765: hr_utility.trace('p_transfer_oth1_rep2 = '|| l_transfer_oth1_rep2);
766: hr_utility.trace('p_transfer_oth1_rep3 = '|| l_transfer_oth1_rep3);
767: hr_utility.trace('p_transfer_oth2_rep2 = '|| l_transfer_oth2_rep2);
768: hr_utility.trace('p_transfer_oth2_rep3 = '|| l_transfer_oth2_rep3);
769: hr_utility.trace('p_transfer_oth3_rep2 = '|| l_transfer_oth3_rep2);
770: hr_utility.trace('p_transfer_oth3_rep3 = '|| l_transfer_oth3_rep3);

Line 767: hr_utility.trace('p_transfer_oth2_rep2 = '|| l_transfer_oth2_rep2);

763: hr_utility.trace('p_transfer_other_info4_str3 = '|| l_transfer_other_info4_str3);
764: hr_utility.trace('p_transfer_oth1_rep1 = '|| l_transfer_oth1_rep1);
765: hr_utility.trace('p_transfer_oth1_rep2 = '|| l_transfer_oth1_rep2);
766: hr_utility.trace('p_transfer_oth1_rep3 = '|| l_transfer_oth1_rep3);
767: hr_utility.trace('p_transfer_oth2_rep2 = '|| l_transfer_oth2_rep2);
768: hr_utility.trace('p_transfer_oth2_rep3 = '|| l_transfer_oth2_rep3);
769: hr_utility.trace('p_transfer_oth3_rep2 = '|| l_transfer_oth3_rep2);
770: hr_utility.trace('p_transfer_oth3_rep3 = '|| l_transfer_oth3_rep3);
771: hr_utility.trace('p_transfer_oth4_rep3 = '|| l_transfer_oth4_rep3);

Line 768: hr_utility.trace('p_transfer_oth2_rep3 = '|| l_transfer_oth2_rep3);

764: hr_utility.trace('p_transfer_oth1_rep1 = '|| l_transfer_oth1_rep1);
765: hr_utility.trace('p_transfer_oth1_rep2 = '|| l_transfer_oth1_rep2);
766: hr_utility.trace('p_transfer_oth1_rep3 = '|| l_transfer_oth1_rep3);
767: hr_utility.trace('p_transfer_oth2_rep2 = '|| l_transfer_oth2_rep2);
768: hr_utility.trace('p_transfer_oth2_rep3 = '|| l_transfer_oth2_rep3);
769: hr_utility.trace('p_transfer_oth3_rep2 = '|| l_transfer_oth3_rep2);
770: hr_utility.trace('p_transfer_oth3_rep3 = '|| l_transfer_oth3_rep3);
771: hr_utility.trace('p_transfer_oth4_rep3 = '|| l_transfer_oth4_rep3);
772:

Line 769: hr_utility.trace('p_transfer_oth3_rep2 = '|| l_transfer_oth3_rep2);

765: hr_utility.trace('p_transfer_oth1_rep2 = '|| l_transfer_oth1_rep2);
766: hr_utility.trace('p_transfer_oth1_rep3 = '|| l_transfer_oth1_rep3);
767: hr_utility.trace('p_transfer_oth2_rep2 = '|| l_transfer_oth2_rep2);
768: hr_utility.trace('p_transfer_oth2_rep3 = '|| l_transfer_oth2_rep3);
769: hr_utility.trace('p_transfer_oth3_rep2 = '|| l_transfer_oth3_rep2);
770: hr_utility.trace('p_transfer_oth3_rep3 = '|| l_transfer_oth3_rep3);
771: hr_utility.trace('p_transfer_oth4_rep3 = '|| l_transfer_oth4_rep3);
772:
773: */

Line 770: hr_utility.trace('p_transfer_oth3_rep3 = '|| l_transfer_oth3_rep3);

766: hr_utility.trace('p_transfer_oth1_rep3 = '|| l_transfer_oth1_rep3);
767: hr_utility.trace('p_transfer_oth2_rep2 = '|| l_transfer_oth2_rep2);
768: hr_utility.trace('p_transfer_oth2_rep3 = '|| l_transfer_oth2_rep3);
769: hr_utility.trace('p_transfer_oth3_rep2 = '|| l_transfer_oth3_rep2);
770: hr_utility.trace('p_transfer_oth3_rep3 = '|| l_transfer_oth3_rep3);
771: hr_utility.trace('p_transfer_oth4_rep3 = '|| l_transfer_oth4_rep3);
772:
773: */
774:

Line 771: hr_utility.trace('p_transfer_oth4_rep3 = '|| l_transfer_oth4_rep3);

767: hr_utility.trace('p_transfer_oth2_rep2 = '|| l_transfer_oth2_rep2);
768: hr_utility.trace('p_transfer_oth2_rep3 = '|| l_transfer_oth2_rep3);
769: hr_utility.trace('p_transfer_oth3_rep2 = '|| l_transfer_oth3_rep2);
770: hr_utility.trace('p_transfer_oth3_rep3 = '|| l_transfer_oth3_rep3);
771: hr_utility.trace('p_transfer_oth4_rep3 = '|| l_transfer_oth4_rep3);
772:
773: */
774:
775: return l_write_f30;

Line 850: --hr_utility.trace_on(null,'T4MAG');

846: BEGIN
847:
848: /* Fetching the Payroll Action Id for Trasnmitter GRE */
849:
850: --hr_utility.trace_on(null,'T4MAG');
851: hr_utility.trace('Inside the Validation Code');
852: hr_utility.trace('The Transmitter GRE id passed is '||p_trans);
853: open c_trans_payid(p_trans,p_year);
854: fetch c_trans_payid into l_trans_payid,l_bg_id;

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

847:
848: /* Fetching the Payroll Action Id for Trasnmitter GRE */
849:
850: --hr_utility.trace_on(null,'T4MAG');
851: hr_utility.trace('Inside the Validation Code');
852: hr_utility.trace('The Transmitter GRE id passed is '||p_trans);
853: open c_trans_payid(p_trans,p_year);
854: fetch c_trans_payid into l_trans_payid,l_bg_id;
855: IF c_trans_payid%notfound THEN

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

848: /* Fetching the Payroll Action Id for Trasnmitter GRE */
849:
850: --hr_utility.trace_on(null,'T4MAG');
851: hr_utility.trace('Inside the Validation Code');
852: hr_utility.trace('The Transmitter GRE id passed is '||p_trans);
853: open c_trans_payid(p_trans,p_year);
854: fetch c_trans_payid into l_trans_payid,l_bg_id;
855: IF c_trans_payid%notfound THEN
856: close c_trans_payid;

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

853: open c_trans_payid(p_trans,p_year);
854: fetch c_trans_payid into l_trans_payid,l_bg_id;
855: IF c_trans_payid%notfound THEN
856: close c_trans_payid;
857: hr_utility.trace('The Transmitter GRE id not found '||p_trans);
858: hr_utility.raise_error;
859: return '1';
860: else
861: close c_trans_payid;

Line 858: hr_utility.raise_error;

854: fetch c_trans_payid into l_trans_payid,l_bg_id;
855: IF c_trans_payid%notfound THEN
856: close c_trans_payid;
857: hr_utility.trace('The Transmitter GRE id not found '||p_trans);
858: hr_utility.raise_error;
859: return '1';
860: else
861: close c_trans_payid;
862: END IF;

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

860: else
861: close c_trans_payid;
862: END IF;
863:
864: hr_utility.trace('Fetched the Payroll Id for transmitter GRE'|| l_trans_payid);
865: hr_utility.trace('The Reporting Year is '||p_year);
866:
867: /*Fetching the Trasnmitter Level Data */
868:

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

861: close c_trans_payid;
862: END IF;
863:
864: hr_utility.trace('Fetched the Payroll Id for transmitter GRE'|| l_trans_payid);
865: hr_utility.trace('The Reporting Year is '||p_year);
866:
867: /*Fetching the Trasnmitter Level Data */
868:
869: l_trans_no := get_arch_val(l_trans_payid, 'CAEOY_TRANSMITTER_NUMBER');

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

879: OPEN c_gre_name(to_number(p_trans));
880: FETCH c_gre_name INTO l_trans_name;
881: CLOSE c_gre_name;
882:
883: hr_utility.trace('Transmitter Number'||l_trans_no);
884: hr_utility.trace('Tech Name'||l_tech_name);
885: hr_utility.trace('Tech Phno'||l_tech_phno);
886: hr_utility.trace('Tech area'||l_tech_area);
887: hr_utility.trace('Tech Lang'||l_lang);

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

880: FETCH c_gre_name INTO l_trans_name;
881: CLOSE c_gre_name;
882:
883: hr_utility.trace('Transmitter Number'||l_trans_no);
884: hr_utility.trace('Tech Name'||l_tech_name);
885: hr_utility.trace('Tech Phno'||l_tech_phno);
886: hr_utility.trace('Tech area'||l_tech_area);
887: hr_utility.trace('Tech Lang'||l_lang);
888:

Line 885: hr_utility.trace('Tech Phno'||l_tech_phno);

881: CLOSE c_gre_name;
882:
883: hr_utility.trace('Transmitter Number'||l_trans_no);
884: hr_utility.trace('Tech Name'||l_tech_name);
885: hr_utility.trace('Tech Phno'||l_tech_phno);
886: hr_utility.trace('Tech area'||l_tech_area);
887: hr_utility.trace('Tech Lang'||l_lang);
888:
889: /* Checking for the validity of the above values fetched */

Line 886: hr_utility.trace('Tech area'||l_tech_area);

882:
883: hr_utility.trace('Transmitter Number'||l_trans_no);
884: hr_utility.trace('Tech Name'||l_tech_name);
885: hr_utility.trace('Tech Phno'||l_tech_phno);
886: hr_utility.trace('Tech area'||l_tech_area);
887: hr_utility.trace('Tech Lang'||l_lang);
888:
889: /* Checking for the validity of the above values fetched */
890: hr_utility.trace('Checking the Transmitter No ');

Line 887: hr_utility.trace('Tech Lang'||l_lang);

883: hr_utility.trace('Transmitter Number'||l_trans_no);
884: hr_utility.trace('Tech Name'||l_tech_name);
885: hr_utility.trace('Tech Phno'||l_tech_phno);
886: hr_utility.trace('Tech area'||l_tech_area);
887: hr_utility.trace('Tech Lang'||l_lang);
888:
889: /* Checking for the validity of the above values fetched */
890: hr_utility.trace('Checking the Transmitter No ');
891: IF l_trans_no IS NULL

Line 890: hr_utility.trace('Checking the Transmitter No ');

886: hr_utility.trace('Tech area'||l_tech_area);
887: hr_utility.trace('Tech Lang'||l_lang);
888:
889: /* Checking for the validity of the above values fetched */
890: hr_utility.trace('Checking the Transmitter No ');
891: IF l_trans_no IS NULL
892: OR TRANSLATE(l_trans_no,'M0123456789','M9999999999') <> 'MM999999' THEN
893: hr_utility.trace('Incorrect Transmitter No format');
894: hr_utility.set_message(801,'PAY_74155_INCORRECT_TRANSMT_NO');

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

889: /* Checking for the validity of the above values fetched */
890: hr_utility.trace('Checking the Transmitter No ');
891: IF l_trans_no IS NULL
892: OR TRANSLATE(l_trans_no,'M0123456789','M9999999999') <> 'MM999999' THEN
893: hr_utility.trace('Incorrect Transmitter No format');
894: hr_utility.set_message(801,'PAY_74155_INCORRECT_TRANSMT_NO');
895: hr_utility.set_message_token('GRE_NAME',l_trans_name);
896: pay_core_utils.push_message(801,'PAY_74155_INCORRECT_TRANSMT_NO','P');
897: pay_core_utils.push_token('GRE_NAME',l_trans_name);

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

890: hr_utility.trace('Checking the Transmitter No ');
891: IF l_trans_no IS NULL
892: OR TRANSLATE(l_trans_no,'M0123456789','M9999999999') <> 'MM999999' THEN
893: hr_utility.trace('Incorrect Transmitter No format');
894: hr_utility.set_message(801,'PAY_74155_INCORRECT_TRANSMT_NO');
895: hr_utility.set_message_token('GRE_NAME',l_trans_name);
896: pay_core_utils.push_message(801,'PAY_74155_INCORRECT_TRANSMT_NO','P');
897: pay_core_utils.push_token('GRE_NAME',l_trans_name);
898: hr_utility.raise_error;

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

891: IF l_trans_no IS NULL
892: OR TRANSLATE(l_trans_no,'M0123456789','M9999999999') <> 'MM999999' THEN
893: hr_utility.trace('Incorrect Transmitter No format');
894: hr_utility.set_message(801,'PAY_74155_INCORRECT_TRANSMT_NO');
895: hr_utility.set_message_token('GRE_NAME',l_trans_name);
896: pay_core_utils.push_message(801,'PAY_74155_INCORRECT_TRANSMT_NO','P');
897: pay_core_utils.push_token('GRE_NAME',l_trans_name);
898: hr_utility.raise_error;
899: return '1';

Line 898: hr_utility.raise_error;

894: hr_utility.set_message(801,'PAY_74155_INCORRECT_TRANSMT_NO');
895: hr_utility.set_message_token('GRE_NAME',l_trans_name);
896: pay_core_utils.push_message(801,'PAY_74155_INCORRECT_TRANSMT_NO','P');
897: pay_core_utils.push_token('GRE_NAME',l_trans_name);
898: hr_utility.raise_error;
899: return '1';
900: END IF;
901:
902: if l_tech_name is null or

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

902: if l_tech_name is null or
903: l_tech_area is null or
904: l_tech_phno is null or
905: l_lang is null then
906: hr_utility.trace('Technical contact details missing');
907: hr_utility.set_message(801,'PAY_74158_INCORRECT_TCHN_INFO');
908: hr_utility.set_message_token('GRE_NAME',l_trans_name);
909: pay_core_utils.push_message(801,'PAY_74158_INCORRECT_TCHN_INFO','P');
910: pay_core_utils.push_token('GRE_NAME',l_trans_name);

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

903: l_tech_area is null or
904: l_tech_phno is null or
905: l_lang is null then
906: hr_utility.trace('Technical contact details missing');
907: hr_utility.set_message(801,'PAY_74158_INCORRECT_TCHN_INFO');
908: hr_utility.set_message_token('GRE_NAME',l_trans_name);
909: pay_core_utils.push_message(801,'PAY_74158_INCORRECT_TCHN_INFO','P');
910: pay_core_utils.push_token('GRE_NAME',l_trans_name);
911: hr_utility.raise_error;

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

904: l_tech_phno is null or
905: l_lang is null then
906: hr_utility.trace('Technical contact details missing');
907: hr_utility.set_message(801,'PAY_74158_INCORRECT_TCHN_INFO');
908: hr_utility.set_message_token('GRE_NAME',l_trans_name);
909: pay_core_utils.push_message(801,'PAY_74158_INCORRECT_TCHN_INFO','P');
910: pay_core_utils.push_token('GRE_NAME',l_trans_name);
911: hr_utility.raise_error;
912: return '1';

Line 911: hr_utility.raise_error;

907: hr_utility.set_message(801,'PAY_74158_INCORRECT_TCHN_INFO');
908: hr_utility.set_message_token('GRE_NAME',l_trans_name);
909: pay_core_utils.push_message(801,'PAY_74158_INCORRECT_TCHN_INFO','P');
910: pay_core_utils.push_token('GRE_NAME',l_trans_name);
911: hr_utility.raise_error;
912: return '1';
913: end if;
914:
915: if l_acc_name is null or

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

918: l_acc_info_flag := 'N';
919: else
920: l_acc_info_flag := 'Y';
921: end if;
922: hr_utility.trace('The value of the Flag is '||l_acc_info_flag);
923: hr_utility.trace('The value of the bgid '||to_char(l_bg_id));
924:
925:
926: /* Checking for the GRE level information */

Line 923: hr_utility.trace('The value of the bgid '||to_char(l_bg_id));

919: else
920: l_acc_info_flag := 'Y';
921: end if;
922: hr_utility.trace('The value of the Flag is '||l_acc_info_flag);
923: hr_utility.trace('The value of the bgid '||to_char(l_bg_id));
924:
925:
926: /* Checking for the GRE level information */
927:

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

927:
928: open c_all_gres(p_trans,p_year,l_bg_id);
929: loop
930: fetch c_all_gres into l_gre_payid, l_gre, l_gre_name;
931: hr_utility.trace('The Gre id fetched is '||l_gre);
932: if c_all_gres%notfound then
933: close c_all_gres;
934: exit;
935: end if;

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

933: close c_all_gres;
934: exit;
935: end if;
936:
937: hr_utility.trace('Before fetching the GREs for this Transmitter '||l_gre||'-'||p_year);
938:
939: if l_gre <> to_number(p_trans) then
940: hr_utility.trace('Inside the loop'||l_gre_payid);
941: hr_utility.trace('Checking GRE level data');

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

936:
937: hr_utility.trace('Before fetching the GREs for this Transmitter '||l_gre||'-'||p_year);
938:
939: if l_gre <> to_number(p_trans) then
940: hr_utility.trace('Inside the loop'||l_gre_payid);
941: hr_utility.trace('Checking GRE level data');
942: hr_utility.trace('The Payroll Action Id for Gre is '|| l_gre_payid);
943: l_bus_no := get_arch_val(l_gre_payid,'CAEOY_EMPLOYER_IDENTIFICATION_NUMBER');
944: --l_tax_unit_id := get_arch_val(l_gre_payid, 'CAEOY_TAX_UNIT_ID');

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

937: hr_utility.trace('Before fetching the GREs for this Transmitter '||l_gre||'-'||p_year);
938:
939: if l_gre <> to_number(p_trans) then
940: hr_utility.trace('Inside the loop'||l_gre_payid);
941: hr_utility.trace('Checking GRE level data');
942: hr_utility.trace('The Payroll Action Id for Gre is '|| l_gre_payid);
943: l_bus_no := get_arch_val(l_gre_payid,'CAEOY_EMPLOYER_IDENTIFICATION_NUMBER');
944: --l_tax_unit_id := get_arch_val(l_gre_payid, 'CAEOY_TAX_UNIT_ID');
945: l_acc_name := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_NAME');

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

938:
939: if l_gre <> to_number(p_trans) then
940: hr_utility.trace('Inside the loop'||l_gre_payid);
941: hr_utility.trace('Checking GRE level data');
942: hr_utility.trace('The Payroll Action Id for Gre is '|| l_gre_payid);
943: l_bus_no := get_arch_val(l_gre_payid,'CAEOY_EMPLOYER_IDENTIFICATION_NUMBER');
944: --l_tax_unit_id := get_arch_val(l_gre_payid, 'CAEOY_TAX_UNIT_ID');
945: l_acc_name := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_NAME');
946: l_acc_area := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_AREA_CODE');

Line 949: hr_utility.trace('Tax unit Id'||l_tax_unit_id);

945: l_acc_name := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_NAME');
946: l_acc_area := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_AREA_CODE');
947: l_acc_phno := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_PHONE');
948:
949: hr_utility.trace('Tax unit Id'||l_tax_unit_id);
950: hr_utility.trace('Acc Name '||l_acc_name);
951: hr_utility.trace('Acc Area '||l_acc_area);
952: hr_utility.trace('Acc Phone '||l_acc_phno);
953:

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

946: l_acc_area := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_AREA_CODE');
947: l_acc_phno := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_PHONE');
948:
949: hr_utility.trace('Tax unit Id'||l_tax_unit_id);
950: hr_utility.trace('Acc Name '||l_acc_name);
951: hr_utility.trace('Acc Area '||l_acc_area);
952: hr_utility.trace('Acc Phone '||l_acc_phno);
953:
954: if l_bus_no is null

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

947: l_acc_phno := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_PHONE');
948:
949: hr_utility.trace('Tax unit Id'||l_tax_unit_id);
950: hr_utility.trace('Acc Name '||l_acc_name);
951: hr_utility.trace('Acc Area '||l_acc_area);
952: hr_utility.trace('Acc Phone '||l_acc_phno);
953:
954: if l_bus_no is null
955: or TRANSLATE(l_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' then

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

948:
949: hr_utility.trace('Tax unit Id'||l_tax_unit_id);
950: hr_utility.trace('Acc Name '||l_acc_name);
951: hr_utility.trace('Acc Area '||l_acc_area);
952: hr_utility.trace('Acc Phone '||l_acc_phno);
953:
954: if l_bus_no is null
955: or TRANSLATE(l_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' then
956: hr_utility.trace('No Business Number Entereed ');

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

952: hr_utility.trace('Acc Phone '||l_acc_phno);
953:
954: if l_bus_no is null
955: or TRANSLATE(l_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' then
956: hr_utility.trace('No Business Number Entereed ');
957: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
958: hr_utility.set_message_token('GRE_NAME',l_gre_name);
959: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
960: pay_core_utils.push_token('GRE_NAME',l_gre_name);

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

953:
954: if l_bus_no is null
955: or TRANSLATE(l_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' then
956: hr_utility.trace('No Business Number Entereed ');
957: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
958: hr_utility.set_message_token('GRE_NAME',l_gre_name);
959: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
960: pay_core_utils.push_token('GRE_NAME',l_gre_name);
961: hr_utility.raise_error;

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

954: if l_bus_no is null
955: or TRANSLATE(l_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' then
956: hr_utility.trace('No Business Number Entereed ');
957: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
958: hr_utility.set_message_token('GRE_NAME',l_gre_name);
959: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
960: pay_core_utils.push_token('GRE_NAME',l_gre_name);
961: hr_utility.raise_error;
962: return '1';

Line 961: hr_utility.raise_error;

957: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
958: hr_utility.set_message_token('GRE_NAME',l_gre_name);
959: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
960: pay_core_utils.push_token('GRE_NAME',l_gre_name);
961: hr_utility.raise_error;
962: return '1';
963: end if;
964:
965: if (l_acc_name is null or

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

965: if (l_acc_name is null or
966: l_acc_area is null or
967: l_acc_phno is null ) and
968: l_acc_info_flag = 'N' then
969: hr_utility.trace('No Accounting Contact info present');
970: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
971: hr_utility.set_message_token('GRE_NAME',l_gre_name);
972: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
973: pay_core_utils.push_token('GRE_NAME',l_gre_name);

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

966: l_acc_area is null or
967: l_acc_phno is null ) and
968: l_acc_info_flag = 'N' then
969: hr_utility.trace('No Accounting Contact info present');
970: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
971: hr_utility.set_message_token('GRE_NAME',l_gre_name);
972: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
973: pay_core_utils.push_token('GRE_NAME',l_gre_name);
974: hr_utility.raise_error;

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

967: l_acc_phno is null ) and
968: l_acc_info_flag = 'N' then
969: hr_utility.trace('No Accounting Contact info present');
970: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
971: hr_utility.set_message_token('GRE_NAME',l_gre_name);
972: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
973: pay_core_utils.push_token('GRE_NAME',l_gre_name);
974: hr_utility.raise_error;
975: return '1';

Line 974: hr_utility.raise_error;

970: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
971: hr_utility.set_message_token('GRE_NAME',l_gre_name);
972: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
973: pay_core_utils.push_token('GRE_NAME',l_gre_name);
974: hr_utility.raise_error;
975: return '1';
976: end if;
977:
978: elsif l_gre = to_number(p_trans) then

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

978: elsif l_gre = to_number(p_trans) then
979:
980: if l_trans_bus_no is null
981: or TRANSLATE(l_trans_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' then
982: hr_utility.trace('No Business Number Entereed ');
983: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
984: hr_utility.set_message_token('GRE_NAME',l_trans_name);
985: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
986: pay_core_utils.push_token('GRE_NAME',l_trans_name);

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

979:
980: if l_trans_bus_no is null
981: or TRANSLATE(l_trans_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' then
982: hr_utility.trace('No Business Number Entereed ');
983: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
984: hr_utility.set_message_token('GRE_NAME',l_trans_name);
985: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
986: pay_core_utils.push_token('GRE_NAME',l_trans_name);
987: hr_utility.raise_error;

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

980: if l_trans_bus_no is null
981: or TRANSLATE(l_trans_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' then
982: hr_utility.trace('No Business Number Entereed ');
983: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
984: hr_utility.set_message_token('GRE_NAME',l_trans_name);
985: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
986: pay_core_utils.push_token('GRE_NAME',l_trans_name);
987: hr_utility.raise_error;
988: return '1';

Line 987: hr_utility.raise_error;

983: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
984: hr_utility.set_message_token('GRE_NAME',l_trans_name);
985: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
986: pay_core_utils.push_token('GRE_NAME',l_trans_name);
987: hr_utility.raise_error;
988: return '1';
989: end if;
990: if l_acc_info_flag = 'N' then
991: hr_utility.trace('No Accounting Contact info present');

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

987: hr_utility.raise_error;
988: return '1';
989: end if;
990: if l_acc_info_flag = 'N' then
991: hr_utility.trace('No Accounting Contact info present');
992: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
993: hr_utility.set_message_token('GRE_NAME',l_trans_name);
994: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
995: pay_core_utils.push_token('GRE_NAME',l_trans_name);

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

988: return '1';
989: end if;
990: if l_acc_info_flag = 'N' then
991: hr_utility.trace('No Accounting Contact info present');
992: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
993: hr_utility.set_message_token('GRE_NAME',l_trans_name);
994: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
995: pay_core_utils.push_token('GRE_NAME',l_trans_name);
996: hr_utility.raise_error;

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

989: end if;
990: if l_acc_info_flag = 'N' then
991: hr_utility.trace('No Accounting Contact info present');
992: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
993: hr_utility.set_message_token('GRE_NAME',l_trans_name);
994: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
995: pay_core_utils.push_token('GRE_NAME',l_trans_name);
996: hr_utility.raise_error;
997: return '1';

Line 996: hr_utility.raise_error;

992: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
993: hr_utility.set_message_token('GRE_NAME',l_trans_name);
994: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
995: pay_core_utils.push_token('GRE_NAME',l_trans_name);
996: hr_utility.raise_error;
997: return '1';
998: end if;
999: end if;
1000: end loop;