eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CA_T4_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 430: hr_utility.trace('In convert_2_xml');

426: ||' '||' '||' '||' '||' '
427: ||'';
428: --new datatype('Y') is added for bug 3891966
429: ELSIF p_datatype = 'Y' then
430: hr_utility.trace('In convert_2_xml');
431: l_output := '<' || trim(p_tag) || ' xml:space="preserve" >'
432: ||lpad(fnd_number.canonical_to_number(trim(to_char(l_data, '999'))),3,0)
433: ||' '||' '||' '||' '||' '
434: ||' '||' '||' '||' '||' '

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

668: --l_transfer_oth4_rep2 := rpad(lpad('.00,',12), 10*12, lpad('.00,',12));
669: l_transfer_oth4_rep3 := rpad(lpad('.00,',12), 4*12, lpad('.00,',12));
670: l_transfer_oth5_rep4 := rpad(lpad('.00,',12), 4*12, lpad('.00,',12));
671:
672: hr_utility.trace('p_assignment_action_id = '||p_assignment_action_id);
673: hr_utility.trace('p_payroll_action_id = '||p_payroll_action_id);
674: hr_utility.trace('p_fail = '||p_fail);
675:
676: for i in 1..t_dbi.COUNT

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

669: l_transfer_oth4_rep3 := rpad(lpad('.00,',12), 4*12, lpad('.00,',12));
670: l_transfer_oth5_rep4 := rpad(lpad('.00,',12), 4*12, lpad('.00,',12));
671:
672: hr_utility.trace('p_assignment_action_id = '||p_assignment_action_id);
673: hr_utility.trace('p_payroll_action_id = '||p_payroll_action_id);
674: hr_utility.trace('p_fail = '||p_fail);
675:
676: for i in 1..t_dbi.COUNT
677: loop

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

670: l_transfer_oth5_rep4 := rpad(lpad('.00,',12), 4*12, lpad('.00,',12));
671:
672: hr_utility.trace('p_assignment_action_id = '||p_assignment_action_id);
673: hr_utility.trace('p_payroll_action_id = '||p_payroll_action_id);
674: hr_utility.trace('p_fail = '||p_fail);
675:
676: for i in 1..t_dbi.COUNT
677: loop
678: l_amt := fnd_number.canonical_to_number(get_dbitem_value_new(p_assignment_action_id,t_dbi(i),p_jusrisdiction));

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

686: l_other_info := CONVERT_2_XML(l_amt, t_tag(i), 'C'); -- Bug 7424296
687: end if;
688: l_cnt := l_cnt+1;
689:
690: hr_utility.trace('l_other_info = '||l_other_info);
691: hr_utility.trace('l_cnt = '||l_cnt);
692:
693: if l_cnt <= 3 then
694: l_write_f30 := l_write_f30||l_other_info;

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

687: end if;
688: l_cnt := l_cnt+1;
689:
690: hr_utility.trace('l_other_info = '||l_other_info);
691: hr_utility.trace('l_cnt = '||l_cnt);
692:
693: if l_cnt <= 3 then
694: l_write_f30 := l_write_f30||l_other_info;
695: elsif l_cnt <=6 then

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

938: p_transfer_oth5_rep4 := l_transfer_oth5_rep4;
939: -- Modification for bug 10097860 ends here.
940:
941: /*
942: hr_utility.trace('p_cnt = '|| l_cnt);
943: hr_utility.trace('p_oth_rep1 = '|| l_oth_rep1);
944: hr_utility.trace('p_oth_rep2 = '|| l_oth_rep2);
945: hr_utility.trace('p_oth_rep3 = '|| l_oth_rep3);
946: hr_utility.trace('write_f30 = '|| l_write_f30);

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

939: -- Modification for bug 10097860 ends here.
940:
941: /*
942: hr_utility.trace('p_cnt = '|| l_cnt);
943: hr_utility.trace('p_oth_rep1 = '|| l_oth_rep1);
944: hr_utility.trace('p_oth_rep2 = '|| l_oth_rep2);
945: hr_utility.trace('p_oth_rep3 = '|| l_oth_rep3);
946: hr_utility.trace('write_f30 = '|| l_write_f30);
947: hr_utility.trace('p_write_f31 = '|| l_write_f31);

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

940:
941: /*
942: hr_utility.trace('p_cnt = '|| l_cnt);
943: hr_utility.trace('p_oth_rep1 = '|| l_oth_rep1);
944: hr_utility.trace('p_oth_rep2 = '|| l_oth_rep2);
945: hr_utility.trace('p_oth_rep3 = '|| l_oth_rep3);
946: hr_utility.trace('write_f30 = '|| l_write_f30);
947: hr_utility.trace('p_write_f31 = '|| l_write_f31);
948: hr_utility.trace('p_transfer_other_info1_str1 = '|| l_transfer_other_info1_str1);

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

941: /*
942: hr_utility.trace('p_cnt = '|| l_cnt);
943: hr_utility.trace('p_oth_rep1 = '|| l_oth_rep1);
944: hr_utility.trace('p_oth_rep2 = '|| l_oth_rep2);
945: hr_utility.trace('p_oth_rep3 = '|| l_oth_rep3);
946: hr_utility.trace('write_f30 = '|| l_write_f30);
947: hr_utility.trace('p_write_f31 = '|| l_write_f31);
948: hr_utility.trace('p_transfer_other_info1_str1 = '|| l_transfer_other_info1_str1);
949: hr_utility.trace('p_transfer_other_info1_str2 = '|| l_transfer_other_info1_str2);

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

942: hr_utility.trace('p_cnt = '|| l_cnt);
943: hr_utility.trace('p_oth_rep1 = '|| l_oth_rep1);
944: hr_utility.trace('p_oth_rep2 = '|| l_oth_rep2);
945: hr_utility.trace('p_oth_rep3 = '|| l_oth_rep3);
946: hr_utility.trace('write_f30 = '|| l_write_f30);
947: hr_utility.trace('p_write_f31 = '|| l_write_f31);
948: hr_utility.trace('p_transfer_other_info1_str1 = '|| l_transfer_other_info1_str1);
949: hr_utility.trace('p_transfer_other_info1_str2 = '|| l_transfer_other_info1_str2);
950: hr_utility.trace('p_transfer_other_info1_str3 = '|| l_transfer_other_info1_str3);

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

943: hr_utility.trace('p_oth_rep1 = '|| l_oth_rep1);
944: hr_utility.trace('p_oth_rep2 = '|| l_oth_rep2);
945: hr_utility.trace('p_oth_rep3 = '|| l_oth_rep3);
946: hr_utility.trace('write_f30 = '|| l_write_f30);
947: hr_utility.trace('p_write_f31 = '|| l_write_f31);
948: hr_utility.trace('p_transfer_other_info1_str1 = '|| l_transfer_other_info1_str1);
949: hr_utility.trace('p_transfer_other_info1_str2 = '|| l_transfer_other_info1_str2);
950: hr_utility.trace('p_transfer_other_info1_str3 = '|| l_transfer_other_info1_str3);
951: hr_utility.trace('p_transfer_other_info2_str1 = '|| l_transfer_other_info2_str1);

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

944: hr_utility.trace('p_oth_rep2 = '|| l_oth_rep2);
945: hr_utility.trace('p_oth_rep3 = '|| l_oth_rep3);
946: hr_utility.trace('write_f30 = '|| l_write_f30);
947: hr_utility.trace('p_write_f31 = '|| l_write_f31);
948: hr_utility.trace('p_transfer_other_info1_str1 = '|| l_transfer_other_info1_str1);
949: hr_utility.trace('p_transfer_other_info1_str2 = '|| l_transfer_other_info1_str2);
950: hr_utility.trace('p_transfer_other_info1_str3 = '|| l_transfer_other_info1_str3);
951: hr_utility.trace('p_transfer_other_info2_str1 = '|| l_transfer_other_info2_str1);
952: hr_utility.trace('p_transfer_other_info2_str2 = '|| l_transfer_other_info2_str2);

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

945: hr_utility.trace('p_oth_rep3 = '|| l_oth_rep3);
946: hr_utility.trace('write_f30 = '|| l_write_f30);
947: hr_utility.trace('p_write_f31 = '|| l_write_f31);
948: hr_utility.trace('p_transfer_other_info1_str1 = '|| l_transfer_other_info1_str1);
949: hr_utility.trace('p_transfer_other_info1_str2 = '|| l_transfer_other_info1_str2);
950: hr_utility.trace('p_transfer_other_info1_str3 = '|| l_transfer_other_info1_str3);
951: hr_utility.trace('p_transfer_other_info2_str1 = '|| l_transfer_other_info2_str1);
952: hr_utility.trace('p_transfer_other_info2_str2 = '|| l_transfer_other_info2_str2);
953: hr_utility.trace('p_transfer_other_info2_str3 = '|| l_transfer_other_info2_str3);

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

946: hr_utility.trace('write_f30 = '|| l_write_f30);
947: hr_utility.trace('p_write_f31 = '|| l_write_f31);
948: hr_utility.trace('p_transfer_other_info1_str1 = '|| l_transfer_other_info1_str1);
949: hr_utility.trace('p_transfer_other_info1_str2 = '|| l_transfer_other_info1_str2);
950: hr_utility.trace('p_transfer_other_info1_str3 = '|| l_transfer_other_info1_str3);
951: hr_utility.trace('p_transfer_other_info2_str1 = '|| l_transfer_other_info2_str1);
952: hr_utility.trace('p_transfer_other_info2_str2 = '|| l_transfer_other_info2_str2);
953: hr_utility.trace('p_transfer_other_info2_str3 = '|| l_transfer_other_info2_str3);
954: hr_utility.trace('p_transfer_other_info3_str1 = '|| l_transfer_other_info3_str1);

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

947: hr_utility.trace('p_write_f31 = '|| l_write_f31);
948: hr_utility.trace('p_transfer_other_info1_str1 = '|| l_transfer_other_info1_str1);
949: hr_utility.trace('p_transfer_other_info1_str2 = '|| l_transfer_other_info1_str2);
950: hr_utility.trace('p_transfer_other_info1_str3 = '|| l_transfer_other_info1_str3);
951: hr_utility.trace('p_transfer_other_info2_str1 = '|| l_transfer_other_info2_str1);
952: hr_utility.trace('p_transfer_other_info2_str2 = '|| l_transfer_other_info2_str2);
953: hr_utility.trace('p_transfer_other_info2_str3 = '|| l_transfer_other_info2_str3);
954: hr_utility.trace('p_transfer_other_info3_str1 = '|| l_transfer_other_info3_str1);
955: hr_utility.trace('p_transfer_other_info3_str2 = '|| l_transfer_other_info3_str2);

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

948: hr_utility.trace('p_transfer_other_info1_str1 = '|| l_transfer_other_info1_str1);
949: hr_utility.trace('p_transfer_other_info1_str2 = '|| l_transfer_other_info1_str2);
950: hr_utility.trace('p_transfer_other_info1_str3 = '|| l_transfer_other_info1_str3);
951: hr_utility.trace('p_transfer_other_info2_str1 = '|| l_transfer_other_info2_str1);
952: hr_utility.trace('p_transfer_other_info2_str2 = '|| l_transfer_other_info2_str2);
953: hr_utility.trace('p_transfer_other_info2_str3 = '|| l_transfer_other_info2_str3);
954: hr_utility.trace('p_transfer_other_info3_str1 = '|| l_transfer_other_info3_str1);
955: hr_utility.trace('p_transfer_other_info3_str2 = '|| l_transfer_other_info3_str2);
956: hr_utility.trace('p_transfer_other_info3_str3 = '|| l_transfer_other_info3_str3);

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

949: hr_utility.trace('p_transfer_other_info1_str2 = '|| l_transfer_other_info1_str2);
950: hr_utility.trace('p_transfer_other_info1_str3 = '|| l_transfer_other_info1_str3);
951: hr_utility.trace('p_transfer_other_info2_str1 = '|| l_transfer_other_info2_str1);
952: hr_utility.trace('p_transfer_other_info2_str2 = '|| l_transfer_other_info2_str2);
953: hr_utility.trace('p_transfer_other_info2_str3 = '|| l_transfer_other_info2_str3);
954: hr_utility.trace('p_transfer_other_info3_str1 = '|| l_transfer_other_info3_str1);
955: hr_utility.trace('p_transfer_other_info3_str2 = '|| l_transfer_other_info3_str2);
956: hr_utility.trace('p_transfer_other_info3_str3 = '|| l_transfer_other_info3_str3);
957: hr_utility.trace('p_transfer_other_info4_str1 = '|| l_transfer_other_info4_str1);

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

950: hr_utility.trace('p_transfer_other_info1_str3 = '|| l_transfer_other_info1_str3);
951: hr_utility.trace('p_transfer_other_info2_str1 = '|| l_transfer_other_info2_str1);
952: hr_utility.trace('p_transfer_other_info2_str2 = '|| l_transfer_other_info2_str2);
953: hr_utility.trace('p_transfer_other_info2_str3 = '|| l_transfer_other_info2_str3);
954: hr_utility.trace('p_transfer_other_info3_str1 = '|| l_transfer_other_info3_str1);
955: hr_utility.trace('p_transfer_other_info3_str2 = '|| l_transfer_other_info3_str2);
956: hr_utility.trace('p_transfer_other_info3_str3 = '|| l_transfer_other_info3_str3);
957: hr_utility.trace('p_transfer_other_info4_str1 = '|| l_transfer_other_info4_str1);
958: hr_utility.trace('p_transfer_other_info4_str2 = '|| l_transfer_other_info4_str2);

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

951: hr_utility.trace('p_transfer_other_info2_str1 = '|| l_transfer_other_info2_str1);
952: hr_utility.trace('p_transfer_other_info2_str2 = '|| l_transfer_other_info2_str2);
953: hr_utility.trace('p_transfer_other_info2_str3 = '|| l_transfer_other_info2_str3);
954: hr_utility.trace('p_transfer_other_info3_str1 = '|| l_transfer_other_info3_str1);
955: hr_utility.trace('p_transfer_other_info3_str2 = '|| l_transfer_other_info3_str2);
956: hr_utility.trace('p_transfer_other_info3_str3 = '|| l_transfer_other_info3_str3);
957: hr_utility.trace('p_transfer_other_info4_str1 = '|| l_transfer_other_info4_str1);
958: hr_utility.trace('p_transfer_other_info4_str2 = '|| l_transfer_other_info4_str2);
959: hr_utility.trace('p_transfer_other_info4_str3 = '|| l_transfer_other_info4_str3);

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

952: hr_utility.trace('p_transfer_other_info2_str2 = '|| l_transfer_other_info2_str2);
953: hr_utility.trace('p_transfer_other_info2_str3 = '|| l_transfer_other_info2_str3);
954: hr_utility.trace('p_transfer_other_info3_str1 = '|| l_transfer_other_info3_str1);
955: hr_utility.trace('p_transfer_other_info3_str2 = '|| l_transfer_other_info3_str2);
956: hr_utility.trace('p_transfer_other_info3_str3 = '|| l_transfer_other_info3_str3);
957: hr_utility.trace('p_transfer_other_info4_str1 = '|| l_transfer_other_info4_str1);
958: hr_utility.trace('p_transfer_other_info4_str2 = '|| l_transfer_other_info4_str2);
959: hr_utility.trace('p_transfer_other_info4_str3 = '|| l_transfer_other_info4_str3);
960: hr_utility.trace('p_transfer_oth1_rep1 = '|| l_transfer_oth1_rep1);

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

953: hr_utility.trace('p_transfer_other_info2_str3 = '|| l_transfer_other_info2_str3);
954: hr_utility.trace('p_transfer_other_info3_str1 = '|| l_transfer_other_info3_str1);
955: hr_utility.trace('p_transfer_other_info3_str2 = '|| l_transfer_other_info3_str2);
956: hr_utility.trace('p_transfer_other_info3_str3 = '|| l_transfer_other_info3_str3);
957: hr_utility.trace('p_transfer_other_info4_str1 = '|| l_transfer_other_info4_str1);
958: hr_utility.trace('p_transfer_other_info4_str2 = '|| l_transfer_other_info4_str2);
959: hr_utility.trace('p_transfer_other_info4_str3 = '|| l_transfer_other_info4_str3);
960: hr_utility.trace('p_transfer_oth1_rep1 = '|| l_transfer_oth1_rep1);
961: hr_utility.trace('p_transfer_oth1_rep2 = '|| l_transfer_oth1_rep2);

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

954: hr_utility.trace('p_transfer_other_info3_str1 = '|| l_transfer_other_info3_str1);
955: hr_utility.trace('p_transfer_other_info3_str2 = '|| l_transfer_other_info3_str2);
956: hr_utility.trace('p_transfer_other_info3_str3 = '|| l_transfer_other_info3_str3);
957: hr_utility.trace('p_transfer_other_info4_str1 = '|| l_transfer_other_info4_str1);
958: hr_utility.trace('p_transfer_other_info4_str2 = '|| l_transfer_other_info4_str2);
959: hr_utility.trace('p_transfer_other_info4_str3 = '|| l_transfer_other_info4_str3);
960: hr_utility.trace('p_transfer_oth1_rep1 = '|| l_transfer_oth1_rep1);
961: hr_utility.trace('p_transfer_oth1_rep2 = '|| l_transfer_oth1_rep2);
962: hr_utility.trace('p_transfer_oth1_rep3 = '|| l_transfer_oth1_rep3);

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

955: hr_utility.trace('p_transfer_other_info3_str2 = '|| l_transfer_other_info3_str2);
956: hr_utility.trace('p_transfer_other_info3_str3 = '|| l_transfer_other_info3_str3);
957: hr_utility.trace('p_transfer_other_info4_str1 = '|| l_transfer_other_info4_str1);
958: hr_utility.trace('p_transfer_other_info4_str2 = '|| l_transfer_other_info4_str2);
959: hr_utility.trace('p_transfer_other_info4_str3 = '|| l_transfer_other_info4_str3);
960: hr_utility.trace('p_transfer_oth1_rep1 = '|| l_transfer_oth1_rep1);
961: hr_utility.trace('p_transfer_oth1_rep2 = '|| l_transfer_oth1_rep2);
962: hr_utility.trace('p_transfer_oth1_rep3 = '|| l_transfer_oth1_rep3);
963: hr_utility.trace('p_transfer_oth2_rep2 = '|| l_transfer_oth2_rep2);

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

956: hr_utility.trace('p_transfer_other_info3_str3 = '|| l_transfer_other_info3_str3);
957: hr_utility.trace('p_transfer_other_info4_str1 = '|| l_transfer_other_info4_str1);
958: hr_utility.trace('p_transfer_other_info4_str2 = '|| l_transfer_other_info4_str2);
959: hr_utility.trace('p_transfer_other_info4_str3 = '|| l_transfer_other_info4_str3);
960: hr_utility.trace('p_transfer_oth1_rep1 = '|| l_transfer_oth1_rep1);
961: hr_utility.trace('p_transfer_oth1_rep2 = '|| l_transfer_oth1_rep2);
962: hr_utility.trace('p_transfer_oth1_rep3 = '|| l_transfer_oth1_rep3);
963: hr_utility.trace('p_transfer_oth2_rep2 = '|| l_transfer_oth2_rep2);
964: hr_utility.trace('p_transfer_oth2_rep3 = '|| l_transfer_oth2_rep3);

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

957: hr_utility.trace('p_transfer_other_info4_str1 = '|| l_transfer_other_info4_str1);
958: hr_utility.trace('p_transfer_other_info4_str2 = '|| l_transfer_other_info4_str2);
959: hr_utility.trace('p_transfer_other_info4_str3 = '|| l_transfer_other_info4_str3);
960: hr_utility.trace('p_transfer_oth1_rep1 = '|| l_transfer_oth1_rep1);
961: hr_utility.trace('p_transfer_oth1_rep2 = '|| l_transfer_oth1_rep2);
962: hr_utility.trace('p_transfer_oth1_rep3 = '|| l_transfer_oth1_rep3);
963: hr_utility.trace('p_transfer_oth2_rep2 = '|| l_transfer_oth2_rep2);
964: hr_utility.trace('p_transfer_oth2_rep3 = '|| l_transfer_oth2_rep3);
965: hr_utility.trace('p_transfer_oth3_rep2 = '|| l_transfer_oth3_rep2);

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

958: hr_utility.trace('p_transfer_other_info4_str2 = '|| l_transfer_other_info4_str2);
959: hr_utility.trace('p_transfer_other_info4_str3 = '|| l_transfer_other_info4_str3);
960: hr_utility.trace('p_transfer_oth1_rep1 = '|| l_transfer_oth1_rep1);
961: hr_utility.trace('p_transfer_oth1_rep2 = '|| l_transfer_oth1_rep2);
962: hr_utility.trace('p_transfer_oth1_rep3 = '|| l_transfer_oth1_rep3);
963: hr_utility.trace('p_transfer_oth2_rep2 = '|| l_transfer_oth2_rep2);
964: hr_utility.trace('p_transfer_oth2_rep3 = '|| l_transfer_oth2_rep3);
965: hr_utility.trace('p_transfer_oth3_rep2 = '|| l_transfer_oth3_rep2);
966: hr_utility.trace('p_transfer_oth3_rep3 = '|| l_transfer_oth3_rep3);

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

959: hr_utility.trace('p_transfer_other_info4_str3 = '|| l_transfer_other_info4_str3);
960: hr_utility.trace('p_transfer_oth1_rep1 = '|| l_transfer_oth1_rep1);
961: hr_utility.trace('p_transfer_oth1_rep2 = '|| l_transfer_oth1_rep2);
962: hr_utility.trace('p_transfer_oth1_rep3 = '|| l_transfer_oth1_rep3);
963: hr_utility.trace('p_transfer_oth2_rep2 = '|| l_transfer_oth2_rep2);
964: hr_utility.trace('p_transfer_oth2_rep3 = '|| l_transfer_oth2_rep3);
965: hr_utility.trace('p_transfer_oth3_rep2 = '|| l_transfer_oth3_rep2);
966: hr_utility.trace('p_transfer_oth3_rep3 = '|| l_transfer_oth3_rep3);
967: hr_utility.trace('p_transfer_oth4_rep3 = '|| l_transfer_oth4_rep3);

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

960: hr_utility.trace('p_transfer_oth1_rep1 = '|| l_transfer_oth1_rep1);
961: hr_utility.trace('p_transfer_oth1_rep2 = '|| l_transfer_oth1_rep2);
962: hr_utility.trace('p_transfer_oth1_rep3 = '|| l_transfer_oth1_rep3);
963: hr_utility.trace('p_transfer_oth2_rep2 = '|| l_transfer_oth2_rep2);
964: hr_utility.trace('p_transfer_oth2_rep3 = '|| l_transfer_oth2_rep3);
965: hr_utility.trace('p_transfer_oth3_rep2 = '|| l_transfer_oth3_rep2);
966: hr_utility.trace('p_transfer_oth3_rep3 = '|| l_transfer_oth3_rep3);
967: hr_utility.trace('p_transfer_oth4_rep3 = '|| l_transfer_oth4_rep3);
968: hr_utility.trace('p_transfer_oth5_rep4 = '|| l_transfer_oth5_rep4);

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

961: hr_utility.trace('p_transfer_oth1_rep2 = '|| l_transfer_oth1_rep2);
962: hr_utility.trace('p_transfer_oth1_rep3 = '|| l_transfer_oth1_rep3);
963: hr_utility.trace('p_transfer_oth2_rep2 = '|| l_transfer_oth2_rep2);
964: hr_utility.trace('p_transfer_oth2_rep3 = '|| l_transfer_oth2_rep3);
965: hr_utility.trace('p_transfer_oth3_rep2 = '|| l_transfer_oth3_rep2);
966: hr_utility.trace('p_transfer_oth3_rep3 = '|| l_transfer_oth3_rep3);
967: hr_utility.trace('p_transfer_oth4_rep3 = '|| l_transfer_oth4_rep3);
968: hr_utility.trace('p_transfer_oth5_rep4 = '|| l_transfer_oth5_rep4);
969: */

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

962: hr_utility.trace('p_transfer_oth1_rep3 = '|| l_transfer_oth1_rep3);
963: hr_utility.trace('p_transfer_oth2_rep2 = '|| l_transfer_oth2_rep2);
964: hr_utility.trace('p_transfer_oth2_rep3 = '|| l_transfer_oth2_rep3);
965: hr_utility.trace('p_transfer_oth3_rep2 = '|| l_transfer_oth3_rep2);
966: hr_utility.trace('p_transfer_oth3_rep3 = '|| l_transfer_oth3_rep3);
967: hr_utility.trace('p_transfer_oth4_rep3 = '|| l_transfer_oth4_rep3);
968: hr_utility.trace('p_transfer_oth5_rep4 = '|| l_transfer_oth5_rep4);
969: */
970:

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

963: hr_utility.trace('p_transfer_oth2_rep2 = '|| l_transfer_oth2_rep2);
964: hr_utility.trace('p_transfer_oth2_rep3 = '|| l_transfer_oth2_rep3);
965: hr_utility.trace('p_transfer_oth3_rep2 = '|| l_transfer_oth3_rep2);
966: hr_utility.trace('p_transfer_oth3_rep3 = '|| l_transfer_oth3_rep3);
967: hr_utility.trace('p_transfer_oth4_rep3 = '|| l_transfer_oth4_rep3);
968: hr_utility.trace('p_transfer_oth5_rep4 = '|| l_transfer_oth5_rep4);
969: */
970:
971: return l_write_f30;

Line 968: hr_utility.trace('p_transfer_oth5_rep4 = '|| l_transfer_oth5_rep4);

964: hr_utility.trace('p_transfer_oth2_rep3 = '|| l_transfer_oth2_rep3);
965: hr_utility.trace('p_transfer_oth3_rep2 = '|| l_transfer_oth3_rep2);
966: hr_utility.trace('p_transfer_oth3_rep3 = '|| l_transfer_oth3_rep3);
967: hr_utility.trace('p_transfer_oth4_rep3 = '|| l_transfer_oth4_rep3);
968: hr_utility.trace('p_transfer_oth5_rep4 = '|| l_transfer_oth5_rep4);
969: */
970:
971: return l_write_f30;
972:

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

1046: BEGIN
1047:
1048: /* Fetching the Payroll Action Id for Trasnmitter GRE */
1049:
1050: --hr_utility.trace_on(null,'T4MAG');
1051: hr_utility.trace('Inside the Validation Code');
1052: hr_utility.trace('The Transmitter GRE id passed is '||p_trans);
1053: open c_trans_payid(p_trans,p_year);
1054: fetch c_trans_payid into l_trans_payid,l_bg_id;

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

1047:
1048: /* Fetching the Payroll Action Id for Trasnmitter GRE */
1049:
1050: --hr_utility.trace_on(null,'T4MAG');
1051: hr_utility.trace('Inside the Validation Code');
1052: hr_utility.trace('The Transmitter GRE id passed is '||p_trans);
1053: open c_trans_payid(p_trans,p_year);
1054: fetch c_trans_payid into l_trans_payid,l_bg_id;
1055: IF c_trans_payid%notfound THEN

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

1048: /* Fetching the Payroll Action Id for Trasnmitter GRE */
1049:
1050: --hr_utility.trace_on(null,'T4MAG');
1051: hr_utility.trace('Inside the Validation Code');
1052: hr_utility.trace('The Transmitter GRE id passed is '||p_trans);
1053: open c_trans_payid(p_trans,p_year);
1054: fetch c_trans_payid into l_trans_payid,l_bg_id;
1055: IF c_trans_payid%notfound THEN
1056: close c_trans_payid;

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

1053: open c_trans_payid(p_trans,p_year);
1054: fetch c_trans_payid into l_trans_payid,l_bg_id;
1055: IF c_trans_payid%notfound THEN
1056: close c_trans_payid;
1057: hr_utility.trace('The Transmitter GRE id not found '||p_trans);
1058: hr_utility.raise_error;
1059: return '1';
1060: else
1061: close c_trans_payid;

Line 1058: hr_utility.raise_error;

1054: fetch c_trans_payid into l_trans_payid,l_bg_id;
1055: IF c_trans_payid%notfound THEN
1056: close c_trans_payid;
1057: hr_utility.trace('The Transmitter GRE id not found '||p_trans);
1058: hr_utility.raise_error;
1059: return '1';
1060: else
1061: close c_trans_payid;
1062: END IF;

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

1060: else
1061: close c_trans_payid;
1062: END IF;
1063:
1064: hr_utility.trace('Fetched the Payroll Id for transmitter GRE'|| l_trans_payid);
1065: hr_utility.trace('The Reporting Year is '||p_year);
1066:
1067: /*Fetching the Trasnmitter Level Data */
1068:

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

1061: close c_trans_payid;
1062: END IF;
1063:
1064: hr_utility.trace('Fetched the Payroll Id for transmitter GRE'|| l_trans_payid);
1065: hr_utility.trace('The Reporting Year is '||p_year);
1066:
1067: /*Fetching the Trasnmitter Level Data */
1068:
1069: l_trans_no := get_arch_val(l_trans_payid, 'CAEOY_TRANSMITTER_NUMBER');

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

1084: OPEN c_gre_name(to_number(p_trans));
1085: FETCH c_gre_name INTO l_trans_name;
1086: CLOSE c_gre_name;
1087:
1088: hr_utility.trace('Transmitter Number '||l_trans_no);
1089: hr_utility.trace('Tech Name '||l_tech_name);
1090: hr_utility.trace('Tech Email '||l_tech_email);
1091: hr_utility.trace('Tech Phno '||l_tech_phno);
1092: hr_utility.trace('Tech area '||l_tech_area);

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

1085: FETCH c_gre_name INTO l_trans_name;
1086: CLOSE c_gre_name;
1087:
1088: hr_utility.trace('Transmitter Number '||l_trans_no);
1089: hr_utility.trace('Tech Name '||l_tech_name);
1090: hr_utility.trace('Tech Email '||l_tech_email);
1091: hr_utility.trace('Tech Phno '||l_tech_phno);
1092: hr_utility.trace('Tech area '||l_tech_area);
1093: hr_utility.trace('Tech Lang '||l_lang);

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

1086: CLOSE c_gre_name;
1087:
1088: hr_utility.trace('Transmitter Number '||l_trans_no);
1089: hr_utility.trace('Tech Name '||l_tech_name);
1090: hr_utility.trace('Tech Email '||l_tech_email);
1091: hr_utility.trace('Tech Phno '||l_tech_phno);
1092: hr_utility.trace('Tech area '||l_tech_area);
1093: hr_utility.trace('Tech Lang '||l_lang);
1094:

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

1087:
1088: hr_utility.trace('Transmitter Number '||l_trans_no);
1089: hr_utility.trace('Tech Name '||l_tech_name);
1090: hr_utility.trace('Tech Email '||l_tech_email);
1091: hr_utility.trace('Tech Phno '||l_tech_phno);
1092: hr_utility.trace('Tech area '||l_tech_area);
1093: hr_utility.trace('Tech Lang '||l_lang);
1094:
1095: /* Checking for the validity of the above values fetched */

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

1088: hr_utility.trace('Transmitter Number '||l_trans_no);
1089: hr_utility.trace('Tech Name '||l_tech_name);
1090: hr_utility.trace('Tech Email '||l_tech_email);
1091: hr_utility.trace('Tech Phno '||l_tech_phno);
1092: hr_utility.trace('Tech area '||l_tech_area);
1093: hr_utility.trace('Tech Lang '||l_lang);
1094:
1095: /* Checking for the validity of the above values fetched */
1096: hr_utility.trace('Checking the Transmitter No ');

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

1089: hr_utility.trace('Tech Name '||l_tech_name);
1090: hr_utility.trace('Tech Email '||l_tech_email);
1091: hr_utility.trace('Tech Phno '||l_tech_phno);
1092: hr_utility.trace('Tech area '||l_tech_area);
1093: hr_utility.trace('Tech Lang '||l_lang);
1094:
1095: /* Checking for the validity of the above values fetched */
1096: hr_utility.trace('Checking the Transmitter No ');
1097: IF l_trans_no IS NULL

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

1092: hr_utility.trace('Tech area '||l_tech_area);
1093: hr_utility.trace('Tech Lang '||l_lang);
1094:
1095: /* Checking for the validity of the above values fetched */
1096: hr_utility.trace('Checking the Transmitter No ');
1097: IF l_trans_no IS NULL
1098: OR TRANSLATE(l_trans_no,'M0123456789','M9999999999') <> 'MM999999' THEN
1099: hr_utility.trace('Incorrect Transmitter No format');
1100: hr_utility.set_message(801,'PAY_74155_INCORRECT_TRANSMT_NO');

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

1095: /* Checking for the validity of the above values fetched */
1096: hr_utility.trace('Checking the Transmitter No ');
1097: IF l_trans_no IS NULL
1098: OR TRANSLATE(l_trans_no,'M0123456789','M9999999999') <> 'MM999999' THEN
1099: hr_utility.trace('Incorrect Transmitter No format');
1100: hr_utility.set_message(801,'PAY_74155_INCORRECT_TRANSMT_NO');
1101: hr_utility.set_message_token('GRE_NAME',l_trans_name);
1102: pay_core_utils.push_message(801,'PAY_74155_INCORRECT_TRANSMT_NO','P');
1103: pay_core_utils.push_token('GRE_NAME',l_trans_name);

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

1096: hr_utility.trace('Checking the Transmitter No ');
1097: IF l_trans_no IS NULL
1098: OR TRANSLATE(l_trans_no,'M0123456789','M9999999999') <> 'MM999999' THEN
1099: hr_utility.trace('Incorrect Transmitter No format');
1100: hr_utility.set_message(801,'PAY_74155_INCORRECT_TRANSMT_NO');
1101: hr_utility.set_message_token('GRE_NAME',l_trans_name);
1102: pay_core_utils.push_message(801,'PAY_74155_INCORRECT_TRANSMT_NO','P');
1103: pay_core_utils.push_token('GRE_NAME',l_trans_name);
1104: hr_utility.raise_error;

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

1097: IF l_trans_no IS NULL
1098: OR TRANSLATE(l_trans_no,'M0123456789','M9999999999') <> 'MM999999' THEN
1099: hr_utility.trace('Incorrect Transmitter No format');
1100: hr_utility.set_message(801,'PAY_74155_INCORRECT_TRANSMT_NO');
1101: hr_utility.set_message_token('GRE_NAME',l_trans_name);
1102: pay_core_utils.push_message(801,'PAY_74155_INCORRECT_TRANSMT_NO','P');
1103: pay_core_utils.push_token('GRE_NAME',l_trans_name);
1104: hr_utility.raise_error;
1105: return '1';

Line 1104: hr_utility.raise_error;

1100: hr_utility.set_message(801,'PAY_74155_INCORRECT_TRANSMT_NO');
1101: hr_utility.set_message_token('GRE_NAME',l_trans_name);
1102: pay_core_utils.push_message(801,'PAY_74155_INCORRECT_TRANSMT_NO','P');
1103: pay_core_utils.push_token('GRE_NAME',l_trans_name);
1104: hr_utility.raise_error;
1105: return '1';
1106: END IF;
1107:
1108: if l_tech_name is null or

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

1109: l_tech_area is null or
1110: l_tech_phno is null or
1111: l_tech_email is null or
1112: l_lang is null then
1113: hr_utility.trace('Technical contact details missing');
1114: hr_utility.set_message(801,'PAY_74158_INCORRECT_TCHN_INFO');
1115: hr_utility.set_message_token('GRE_NAME',l_trans_name);
1116: pay_core_utils.push_message(801,'PAY_74158_INCORRECT_TCHN_INFO','P');
1117: pay_core_utils.push_token('GRE_NAME',l_trans_name);

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

1110: l_tech_phno is null or
1111: l_tech_email is null or
1112: l_lang is null then
1113: hr_utility.trace('Technical contact details missing');
1114: hr_utility.set_message(801,'PAY_74158_INCORRECT_TCHN_INFO');
1115: hr_utility.set_message_token('GRE_NAME',l_trans_name);
1116: pay_core_utils.push_message(801,'PAY_74158_INCORRECT_TCHN_INFO','P');
1117: pay_core_utils.push_token('GRE_NAME',l_trans_name);
1118: hr_utility.raise_error;

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

1111: l_tech_email is null or
1112: l_lang is null then
1113: hr_utility.trace('Technical contact details missing');
1114: hr_utility.set_message(801,'PAY_74158_INCORRECT_TCHN_INFO');
1115: hr_utility.set_message_token('GRE_NAME',l_trans_name);
1116: pay_core_utils.push_message(801,'PAY_74158_INCORRECT_TCHN_INFO','P');
1117: pay_core_utils.push_token('GRE_NAME',l_trans_name);
1118: hr_utility.raise_error;
1119: return '1';

Line 1118: hr_utility.raise_error;

1114: hr_utility.set_message(801,'PAY_74158_INCORRECT_TCHN_INFO');
1115: hr_utility.set_message_token('GRE_NAME',l_trans_name);
1116: pay_core_utils.push_message(801,'PAY_74158_INCORRECT_TCHN_INFO','P');
1117: pay_core_utils.push_token('GRE_NAME',l_trans_name);
1118: hr_utility.raise_error;
1119: return '1';
1120: end if;
1121:
1122: if l_acc_name is null or

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

1125: l_acc_info_flag := 'N';
1126: else
1127: l_acc_info_flag := 'Y';
1128: end if;
1129: hr_utility.trace('The value of the Flag is '||l_acc_info_flag);
1130: hr_utility.trace('The value of the bgid '||to_char(l_bg_id));
1131:
1132:
1133: /* Checking for the GRE level information */

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

1126: else
1127: l_acc_info_flag := 'Y';
1128: end if;
1129: hr_utility.trace('The value of the Flag is '||l_acc_info_flag);
1130: hr_utility.trace('The value of the bgid '||to_char(l_bg_id));
1131:
1132:
1133: /* Checking for the GRE level information */
1134:

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

1134:
1135: open c_all_gres(p_trans,p_year,l_bg_id);
1136: loop
1137: fetch c_all_gres into l_gre_payid, l_gre, l_gre_name;
1138: hr_utility.trace('The Gre id fetched is '||l_gre);
1139: if c_all_gres%notfound then
1140: close c_all_gres;
1141: exit;
1142: end if;

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

1140: close c_all_gres;
1141: exit;
1142: end if;
1143:
1144: hr_utility.trace('Before fetching the GREs for this Transmitter '||l_gre||'-'||p_year);
1145:
1146: if l_gre <> to_number(p_trans) then
1147: hr_utility.trace('Inside the loop'||l_gre_payid);
1148: hr_utility.trace('Checking GRE level data');

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

1143:
1144: hr_utility.trace('Before fetching the GREs for this Transmitter '||l_gre||'-'||p_year);
1145:
1146: if l_gre <> to_number(p_trans) then
1147: hr_utility.trace('Inside the loop'||l_gre_payid);
1148: hr_utility.trace('Checking GRE level data');
1149: hr_utility.trace('The Payroll Action Id for Gre is '|| l_gre_payid);
1150: l_bus_no := get_arch_val(l_gre_payid,'CAEOY_EMPLOYER_IDENTIFICATION_NUMBER');
1151: --l_tax_unit_id := get_arch_val(l_gre_payid, 'CAEOY_TAX_UNIT_ID');

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

1144: hr_utility.trace('Before fetching the GREs for this Transmitter '||l_gre||'-'||p_year);
1145:
1146: if l_gre <> to_number(p_trans) then
1147: hr_utility.trace('Inside the loop'||l_gre_payid);
1148: hr_utility.trace('Checking GRE level data');
1149: hr_utility.trace('The Payroll Action Id for Gre is '|| l_gre_payid);
1150: l_bus_no := get_arch_val(l_gre_payid,'CAEOY_EMPLOYER_IDENTIFICATION_NUMBER');
1151: --l_tax_unit_id := get_arch_val(l_gre_payid, 'CAEOY_TAX_UNIT_ID');
1152: l_acc_name := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_NAME');

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

1145:
1146: if l_gre <> to_number(p_trans) then
1147: hr_utility.trace('Inside the loop'||l_gre_payid);
1148: hr_utility.trace('Checking GRE level data');
1149: hr_utility.trace('The Payroll Action Id for Gre is '|| l_gre_payid);
1150: l_bus_no := get_arch_val(l_gre_payid,'CAEOY_EMPLOYER_IDENTIFICATION_NUMBER');
1151: --l_tax_unit_id := get_arch_val(l_gre_payid, 'CAEOY_TAX_UNIT_ID');
1152: l_acc_name := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_NAME');
1153: l_acc_area := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_AREA_CODE');

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

1152: l_acc_name := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_NAME');
1153: l_acc_area := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_AREA_CODE');
1154: l_acc_phno := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_PHONE');
1155:
1156: hr_utility.trace('Tax unit Id'||l_tax_unit_id);
1157: hr_utility.trace('Acc Name '||l_acc_name);
1158: hr_utility.trace('Acc Area '||l_acc_area);
1159: hr_utility.trace('Acc Phone '||l_acc_phno);
1160:

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

1153: l_acc_area := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_AREA_CODE');
1154: l_acc_phno := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_PHONE');
1155:
1156: hr_utility.trace('Tax unit Id'||l_tax_unit_id);
1157: hr_utility.trace('Acc Name '||l_acc_name);
1158: hr_utility.trace('Acc Area '||l_acc_area);
1159: hr_utility.trace('Acc Phone '||l_acc_phno);
1160:
1161: if l_bus_no is null

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

1154: l_acc_phno := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_PHONE');
1155:
1156: hr_utility.trace('Tax unit Id'||l_tax_unit_id);
1157: hr_utility.trace('Acc Name '||l_acc_name);
1158: hr_utility.trace('Acc Area '||l_acc_area);
1159: hr_utility.trace('Acc Phone '||l_acc_phno);
1160:
1161: if l_bus_no is null
1162: or TRANSLATE(l_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' then

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

1155:
1156: hr_utility.trace('Tax unit Id'||l_tax_unit_id);
1157: hr_utility.trace('Acc Name '||l_acc_name);
1158: hr_utility.trace('Acc Area '||l_acc_area);
1159: hr_utility.trace('Acc Phone '||l_acc_phno);
1160:
1161: if l_bus_no is null
1162: or TRANSLATE(l_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' then
1163: hr_utility.trace('No Business Number Entereed ');

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

1159: hr_utility.trace('Acc Phone '||l_acc_phno);
1160:
1161: if l_bus_no is null
1162: or TRANSLATE(l_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' then
1163: hr_utility.trace('No Business Number Entereed ');
1164: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
1165: hr_utility.set_message_token('GRE_NAME',l_gre_name);
1166: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
1167: pay_core_utils.push_token('GRE_NAME',l_gre_name);

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

1160:
1161: if l_bus_no is null
1162: or TRANSLATE(l_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' then
1163: hr_utility.trace('No Business Number Entereed ');
1164: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
1165: hr_utility.set_message_token('GRE_NAME',l_gre_name);
1166: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
1167: pay_core_utils.push_token('GRE_NAME',l_gre_name);
1168: hr_utility.raise_error;

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

1161: if l_bus_no is null
1162: or TRANSLATE(l_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' then
1163: hr_utility.trace('No Business Number Entereed ');
1164: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
1165: hr_utility.set_message_token('GRE_NAME',l_gre_name);
1166: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
1167: pay_core_utils.push_token('GRE_NAME',l_gre_name);
1168: hr_utility.raise_error;
1169: return '1';

Line 1168: hr_utility.raise_error;

1164: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
1165: hr_utility.set_message_token('GRE_NAME',l_gre_name);
1166: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
1167: pay_core_utils.push_token('GRE_NAME',l_gre_name);
1168: hr_utility.raise_error;
1169: return '1';
1170: end if;
1171:
1172: if (l_acc_name is null or

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

1172: if (l_acc_name is null or
1173: l_acc_area is null or
1174: l_acc_phno is null ) and
1175: l_acc_info_flag = 'N' then
1176: hr_utility.trace('No Accounting Contact info present');
1177: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
1178: hr_utility.set_message_token('GRE_NAME',l_gre_name);
1179: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
1180: pay_core_utils.push_token('GRE_NAME',l_gre_name);

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

1173: l_acc_area is null or
1174: l_acc_phno is null ) and
1175: l_acc_info_flag = 'N' then
1176: hr_utility.trace('No Accounting Contact info present');
1177: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
1178: hr_utility.set_message_token('GRE_NAME',l_gre_name);
1179: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
1180: pay_core_utils.push_token('GRE_NAME',l_gre_name);
1181: hr_utility.raise_error;

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

1174: l_acc_phno is null ) and
1175: l_acc_info_flag = 'N' then
1176: hr_utility.trace('No Accounting Contact info present');
1177: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
1178: hr_utility.set_message_token('GRE_NAME',l_gre_name);
1179: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
1180: pay_core_utils.push_token('GRE_NAME',l_gre_name);
1181: hr_utility.raise_error;
1182: return '1';

Line 1181: hr_utility.raise_error;

1177: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
1178: hr_utility.set_message_token('GRE_NAME',l_gre_name);
1179: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
1180: pay_core_utils.push_token('GRE_NAME',l_gre_name);
1181: hr_utility.raise_error;
1182: return '1';
1183: end if;
1184:
1185: elsif l_gre = to_number(p_trans) then

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

1185: elsif l_gre = to_number(p_trans) then
1186:
1187: if l_trans_bus_no is null
1188: or TRANSLATE(l_trans_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' then
1189: hr_utility.trace('No Business Number Entereed ');
1190: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
1191: hr_utility.set_message_token('GRE_NAME',l_trans_name);
1192: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
1193: pay_core_utils.push_token('GRE_NAME',l_trans_name);

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

1186:
1187: if l_trans_bus_no is null
1188: or TRANSLATE(l_trans_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' then
1189: hr_utility.trace('No Business Number Entereed ');
1190: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
1191: hr_utility.set_message_token('GRE_NAME',l_trans_name);
1192: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
1193: pay_core_utils.push_token('GRE_NAME',l_trans_name);
1194: hr_utility.raise_error;

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

1187: if l_trans_bus_no is null
1188: or TRANSLATE(l_trans_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' then
1189: hr_utility.trace('No Business Number Entereed ');
1190: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
1191: hr_utility.set_message_token('GRE_NAME',l_trans_name);
1192: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
1193: pay_core_utils.push_token('GRE_NAME',l_trans_name);
1194: hr_utility.raise_error;
1195: return '1';

Line 1194: hr_utility.raise_error;

1190: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
1191: hr_utility.set_message_token('GRE_NAME',l_trans_name);
1192: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
1193: pay_core_utils.push_token('GRE_NAME',l_trans_name);
1194: hr_utility.raise_error;
1195: return '1';
1196: end if;
1197: if l_acc_info_flag = 'N' then
1198: hr_utility.trace('No Accounting Contact info present');

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

1194: hr_utility.raise_error;
1195: return '1';
1196: end if;
1197: if l_acc_info_flag = 'N' then
1198: hr_utility.trace('No Accounting Contact info present');
1199: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
1200: hr_utility.set_message_token('GRE_NAME',l_trans_name);
1201: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
1202: pay_core_utils.push_token('GRE_NAME',l_trans_name);

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

1195: return '1';
1196: end if;
1197: if l_acc_info_flag = 'N' then
1198: hr_utility.trace('No Accounting Contact info present');
1199: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
1200: hr_utility.set_message_token('GRE_NAME',l_trans_name);
1201: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
1202: pay_core_utils.push_token('GRE_NAME',l_trans_name);
1203: hr_utility.raise_error;

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

1196: end if;
1197: if l_acc_info_flag = 'N' then
1198: hr_utility.trace('No Accounting Contact info present');
1199: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
1200: hr_utility.set_message_token('GRE_NAME',l_trans_name);
1201: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
1202: pay_core_utils.push_token('GRE_NAME',l_trans_name);
1203: hr_utility.raise_error;
1204: return '1';

Line 1203: hr_utility.raise_error;

1199: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
1200: hr_utility.set_message_token('GRE_NAME',l_trans_name);
1201: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
1202: pay_core_utils.push_token('GRE_NAME',l_trans_name);
1203: hr_utility.raise_error;
1204: return '1';
1205: end if;
1206: end if;
1207: end loop;