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

Line 32: hr_utility.set_location

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

Line 47: hr_utility.set_location

43: p_report_type,
44: p_legislative_parameters
45: FROM pay_payroll_actions ppa
46: WHERE payroll_action_id = p_pactid;
47: hr_utility.set_location
48: ('pay_ca_t4a_mag.get_report_parameters', 20);
49:
50: END get_report_parameters;
51:

Line 104: hr_utility.set_location( 'pay_ca_t4a_mag.range_cursor', 10);

100: l_tax_year VARCHAR2(10);
101:
102: BEGIN
103:
104: hr_utility.set_location( 'pay_ca_t4a_mag.range_cursor', 10);
105:
106: get_report_parameters(
107: p_pactid,
108: p_year_start,

Line 120: hr_utility.trace('l_tax_year ='||l_tax_year);

116: l_person_id_ue_id := get_user_entity_id('CAEOY_PERSON_ID');
117: l_tax_year := pay_ca_t4a_mag.get_parameter('REPORTING_YEAR',
118: l_legislative_parameters);
119:
120: hr_utility.trace('l_tax_year ='||l_tax_year);
121: hr_utility.set_location( 'pay_ca_t4a_mag.range_cursor', 20);
122:
123: /* Removed the join from 'Where clause' that checks
124: whether GRE has the 'Fed Magnetic Reporting' information or not */

Line 121: hr_utility.set_location( 'pay_ca_t4a_mag.range_cursor', 20);

117: l_tax_year := pay_ca_t4a_mag.get_parameter('REPORTING_YEAR',
118: l_legislative_parameters);
119:
120: hr_utility.trace('l_tax_year ='||l_tax_year);
121: hr_utility.set_location( 'pay_ca_t4a_mag.range_cursor', 20);
122:
123: /* Removed the join from 'Where clause' that checks
124: whether GRE has the 'Fed Magnetic Reporting' information or not */
125:

Line 150: hr_utility.set_location( 'pay_ca_t4a_mag.range_cursor', 30);

146: ' and fai1.context1 = paa.assignment_action_id
147: and fai1.user_entity_id = '||l_person_id_ue_id||
148: ' order by to_number(fai1.value)';
149:
150: hr_utility.set_location( 'pay_ca_t4a_mag.range_cursor', 30);
151:
152: END range_cursor;
153:
154: --

Line 243: hr_utility.set_location( 'pay_ca_t4a_mag.create_assignement_act',10);

239: BEGIN
240:
241: -- Get the report parameters. These define the report being run.
242:
243: hr_utility.set_location( 'pay_ca_t4a_mag.create_assignement_act',10);
244:
245: get_report_parameters(
246: p_pactid,
247: l_year_start,

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

249: l_report_type,
250: l_business_group_id,
251: l_legislative_parameters
252: );
253: --hr_utility.trace_on(null,'T4MAG');
254: l_trans_gre := pay_ca_t4a_mag.get_parameter('TRANSMITTER_GRE',
255: l_legislative_parameters);
256: hr_utility.trace('l_trans_gre ='||l_trans_gre);
257: l_validate_gre := pay_ca_t4a_mag.validate_gre_data(l_trans_gre, to_char(l_year_end,'YYYY'));

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

252: );
253: --hr_utility.trace_on(null,'T4MAG');
254: l_trans_gre := pay_ca_t4a_mag.get_parameter('TRANSMITTER_GRE',
255: l_legislative_parameters);
256: hr_utility.trace('l_trans_gre ='||l_trans_gre);
257: l_validate_gre := pay_ca_t4a_mag.validate_gre_data(l_trans_gre, to_char(l_year_end,'YYYY'));
258:
259: hr_utility.set_location( 'pay_ca_t4a_mag.create_assignement_act',20);
260:

Line 259: hr_utility.set_location( 'pay_ca_t4a_mag.create_assignement_act',20);

255: l_legislative_parameters);
256: hr_utility.trace('l_trans_gre ='||l_trans_gre);
257: l_validate_gre := pay_ca_t4a_mag.validate_gre_data(l_trans_gre, to_char(l_year_end,'YYYY'));
258:
259: hr_utility.set_location( 'pay_ca_t4a_mag.create_assignement_act',20);
260:
261: if l_validate_gre = '1' then
262: hr_utility.raise_error;
263: end if;

Line 262: hr_utility.raise_error;

258:
259: hr_utility.set_location( 'pay_ca_t4a_mag.create_assignement_act',20);
260:
261: if l_validate_gre = '1' then
262: hr_utility.raise_error;
263: end if;
264:
265: IF l_report_type = 'MAG_T4A' THEN
266: OPEN c_all_asg;

Line 273: hr_utility.set_location('pay_ca_t4a_mag.create_assignement_act', 30);

269: l_assignment_id,
270: l_tax_unit_id,
271: l_effective_end_date,
272: l_assignment_action_id;
273: hr_utility.set_location('pay_ca_t4a_mag.create_assignement_act', 30);
274: EXIT WHEN c_all_asg%NOTFOUND;
275:
276:
277: --Create the assignment action for the record

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

275:
276:
277: --Create the assignment action for the record
278:
279: hr_utility.trace('Assignment Fetched - ');
280: hr_utility.trace('Assignment Id : '||
281: to_char(l_assignment_id));
282: hr_utility.trace('Person Id : '|| to_char(l_person_id));
283: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));

Line 280: hr_utility.trace('Assignment Id : '||

276:
277: --Create the assignment action for the record
278:
279: hr_utility.trace('Assignment Fetched - ');
280: hr_utility.trace('Assignment Id : '||
281: to_char(l_assignment_id));
282: hr_utility.trace('Person Id : '|| to_char(l_person_id));
283: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
284: hr_utility.trace('Effective End Date : '||

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

278:
279: hr_utility.trace('Assignment Fetched - ');
280: hr_utility.trace('Assignment Id : '||
281: to_char(l_assignment_id));
282: hr_utility.trace('Person Id : '|| to_char(l_person_id));
283: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
284: hr_utility.trace('Effective End Date : '||
285: to_char(l_effective_end_date));
286:

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

279: hr_utility.trace('Assignment Fetched - ');
280: hr_utility.trace('Assignment Id : '||
281: to_char(l_assignment_id));
282: hr_utility.trace('Person Id : '|| to_char(l_person_id));
283: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
284: hr_utility.trace('Effective End Date : '||
285: to_char(l_effective_end_date));
286:
287: hr_utility.set_location(

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

280: hr_utility.trace('Assignment Id : '||
281: to_char(l_assignment_id));
282: hr_utility.trace('Person Id : '|| to_char(l_person_id));
283: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
284: hr_utility.trace('Effective End Date : '||
285: to_char(l_effective_end_date));
286:
287: hr_utility.set_location(
288: 'pay_ca_t4a_mag.create_assignement_act', 40);

Line 287: hr_utility.set_location(

283: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
284: hr_utility.trace('Effective End Date : '||
285: to_char(l_effective_end_date));
286:
287: hr_utility.set_location(
288: 'pay_ca_t4a_mag.create_assignement_act', 40);
289:
290: SELECT pay_assignment_actions_s.nextval
291: INTO lockingactid

Line 293: hr_utility.set_location(

289:
290: SELECT pay_assignment_actions_s.nextval
291: INTO lockingactid
292: FROM dual;
293: hr_utility.set_location(
294: 'pay_ca_t4a_mag.create_assignement_act', 50);
295:
296: hr_nonrun_asact.insact(lockingactid, l_assignment_id,
297: p_pactid,p_chunk, l_tax_unit_id);

Line 299: hr_utility.set_location(

295:
296: hr_nonrun_asact.insact(lockingactid, l_assignment_id,
297: p_pactid,p_chunk, l_tax_unit_id);
298:
299: hr_utility.set_location(
300: 'pay_ca_t4a_mag.create_assignement_act', 60);
301:
302: hr_nonrun_asact.insint(lockingactid,
303: l_assignment_action_id);

Line 305: hr_utility.set_location(

301:
302: hr_nonrun_asact.insint(lockingactid,
303: l_assignment_action_id);
304:
305: hr_utility.set_location(
306: 'pay_ca_t4a_mag.create_assignement_act', 70);
307:
308: hr_utility.trace('Interlock Created - ');
309: hr_utility.trace('Locking Action : '||

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

304:
305: hr_utility.set_location(
306: 'pay_ca_t4a_mag.create_assignement_act', 70);
307:
308: hr_utility.trace('Interlock Created - ');
309: hr_utility.trace('Locking Action : '||
310: to_char(lockingactid));
311: hr_utility.trace('Locked Action : '||
312: to_char(l_assignment_action_id));

Line 309: hr_utility.trace('Locking Action : '||

305: hr_utility.set_location(
306: 'pay_ca_t4a_mag.create_assignement_act', 70);
307:
308: hr_utility.trace('Interlock Created - ');
309: hr_utility.trace('Locking Action : '||
310: to_char(lockingactid));
311: hr_utility.trace('Locked Action : '||
312: to_char(l_assignment_action_id));
313:

Line 311: hr_utility.trace('Locked Action : '||

307:
308: hr_utility.trace('Interlock Created - ');
309: hr_utility.trace('Locking Action : '||
310: to_char(lockingactid));
311: hr_utility.trace('Locked Action : '||
312: to_char(l_assignment_action_id));
313:
314: END LOOP;
315: Close c_all_asg;

Line 429: hr_utility.trace('fetch footnote '|| lv_footnote_amount);

425: lv_footnote_amount := '0';
426: open c_get_footnote_amount(p_assignment_action_id,p_footnote_code);
427: fetch c_get_footnote_amount into lv_footnote_amount;
428:
429: hr_utility.trace('fetch footnote '|| lv_footnote_amount);
430:
431: close c_get_footnote_amount;
432:
433: return lv_footnote_amount;

Line 436: hr_utility.trace('fetch no footnote ');

432:
433: return lv_footnote_amount;
434: exception
435: when no_data_found then
436: hr_utility.trace('fetch no footnote ');
437: lv_footnote_amount := '0';
438: return lv_footnote_amount;
439: end get_t4a_footnote_amounts;
440:

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

501: BEGIN
502:
503: /* Fetching the Payroll Action Id for Trasnmitter GRE */
504:
505: --hr_utility.trace_on(null,'T4MAG');
506: hr_utility.trace('Inside the Validation Code');
507: hr_utility.trace('The Transmitter GRE id passed is '||p_trans);
508: open c_trans_payid(p_trans,p_year);
509: fetch c_trans_payid into l_trans_payid,l_bg_id;

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

502:
503: /* Fetching the Payroll Action Id for Trasnmitter GRE */
504:
505: --hr_utility.trace_on(null,'T4MAG');
506: hr_utility.trace('Inside the Validation Code');
507: hr_utility.trace('The Transmitter GRE id passed is '||p_trans);
508: open c_trans_payid(p_trans,p_year);
509: fetch c_trans_payid into l_trans_payid,l_bg_id;
510: IF c_trans_payid%notfound THEN

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

503: /* Fetching the Payroll Action Id for Trasnmitter GRE */
504:
505: --hr_utility.trace_on(null,'T4MAG');
506: hr_utility.trace('Inside the Validation Code');
507: hr_utility.trace('The Transmitter GRE id passed is '||p_trans);
508: open c_trans_payid(p_trans,p_year);
509: fetch c_trans_payid into l_trans_payid,l_bg_id;
510: IF c_trans_payid%notfound THEN
511: close c_trans_payid;

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

508: open c_trans_payid(p_trans,p_year);
509: fetch c_trans_payid into l_trans_payid,l_bg_id;
510: IF c_trans_payid%notfound THEN
511: close c_trans_payid;
512: hr_utility.trace('The Transmitter GRE id not found '||p_trans);
513: hr_utility.raise_error;
514: return '1';
515: else
516: close c_trans_payid;

Line 513: hr_utility.raise_error;

509: fetch c_trans_payid into l_trans_payid,l_bg_id;
510: IF c_trans_payid%notfound THEN
511: close c_trans_payid;
512: hr_utility.trace('The Transmitter GRE id not found '||p_trans);
513: hr_utility.raise_error;
514: return '1';
515: else
516: close c_trans_payid;
517: END IF;

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

515: else
516: close c_trans_payid;
517: END IF;
518:
519: hr_utility.trace('Fetched the Payroll Id for transmitter GRE'|| l_trans_payid);
520: hr_utility.trace('The Reporting Year is '||p_year);
521:
522: /*Fetching the Trasnmitter Level Data */
523:

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

516: close c_trans_payid;
517: END IF;
518:
519: hr_utility.trace('Fetched the Payroll Id for transmitter GRE'|| l_trans_payid);
520: hr_utility.trace('The Reporting Year is '||p_year);
521:
522: /*Fetching the Trasnmitter Level Data */
523:
524: l_trans_no := get_arch_val(l_trans_payid, 'CAEOY_TRANSMITTER_NUMBER');

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

534: OPEN c_gre_name(to_number(p_trans));
535: FETCH c_gre_name INTO l_trans_name;
536: CLOSE c_gre_name;
537:
538: hr_utility.trace('Transmitter Number'||l_trans_no);
539: hr_utility.trace('Tech Name'||l_tech_name);
540: hr_utility.trace('Tech Phno'||l_tech_phno);
541: hr_utility.trace('Tech area'||l_tech_area);
542: hr_utility.trace('Tech Lang'||l_lang);

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

535: FETCH c_gre_name INTO l_trans_name;
536: CLOSE c_gre_name;
537:
538: hr_utility.trace('Transmitter Number'||l_trans_no);
539: hr_utility.trace('Tech Name'||l_tech_name);
540: hr_utility.trace('Tech Phno'||l_tech_phno);
541: hr_utility.trace('Tech area'||l_tech_area);
542: hr_utility.trace('Tech Lang'||l_lang);
543:

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

536: CLOSE c_gre_name;
537:
538: hr_utility.trace('Transmitter Number'||l_trans_no);
539: hr_utility.trace('Tech Name'||l_tech_name);
540: hr_utility.trace('Tech Phno'||l_tech_phno);
541: hr_utility.trace('Tech area'||l_tech_area);
542: hr_utility.trace('Tech Lang'||l_lang);
543:
544: /* Checking for the validity of the above values fetched */

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

537:
538: hr_utility.trace('Transmitter Number'||l_trans_no);
539: hr_utility.trace('Tech Name'||l_tech_name);
540: hr_utility.trace('Tech Phno'||l_tech_phno);
541: hr_utility.trace('Tech area'||l_tech_area);
542: hr_utility.trace('Tech Lang'||l_lang);
543:
544: /* Checking for the validity of the above values fetched */
545: IF l_trans_no IS NULL

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

538: hr_utility.trace('Transmitter Number'||l_trans_no);
539: hr_utility.trace('Tech Name'||l_tech_name);
540: hr_utility.trace('Tech Phno'||l_tech_phno);
541: hr_utility.trace('Tech area'||l_tech_area);
542: hr_utility.trace('Tech Lang'||l_lang);
543:
544: /* Checking for the validity of the above values fetched */
545: IF l_trans_no IS NULL
546: OR TRANSLATE(l_trans_no,'M0123456789','M9999999999') <> 'MM999999' THEN

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

543:
544: /* Checking for the validity of the above values fetched */
545: IF l_trans_no IS NULL
546: OR TRANSLATE(l_trans_no,'M0123456789','M9999999999') <> 'MM999999' THEN
547: hr_utility.trace('Incorrect Transmitter No format');
548: hr_utility.set_message(801,'PAY_74155_INCORRECT_TRANSMT_NO');
549: hr_utility.set_message_token('GRE_NAME',l_trans_name);
550: pay_core_utils.push_message(801,'PAY_74155_INCORRECT_TRANSMT_NO','P');
551: pay_core_utils.push_token('GRE_NAME',l_trans_name);

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

544: /* Checking for the validity of the above values fetched */
545: IF l_trans_no IS NULL
546: OR TRANSLATE(l_trans_no,'M0123456789','M9999999999') <> 'MM999999' THEN
547: hr_utility.trace('Incorrect Transmitter No format');
548: hr_utility.set_message(801,'PAY_74155_INCORRECT_TRANSMT_NO');
549: hr_utility.set_message_token('GRE_NAME',l_trans_name);
550: pay_core_utils.push_message(801,'PAY_74155_INCORRECT_TRANSMT_NO','P');
551: pay_core_utils.push_token('GRE_NAME',l_trans_name);
552: hr_utility.raise_error;

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

545: IF l_trans_no IS NULL
546: OR TRANSLATE(l_trans_no,'M0123456789','M9999999999') <> 'MM999999' THEN
547: hr_utility.trace('Incorrect Transmitter No format');
548: hr_utility.set_message(801,'PAY_74155_INCORRECT_TRANSMT_NO');
549: hr_utility.set_message_token('GRE_NAME',l_trans_name);
550: pay_core_utils.push_message(801,'PAY_74155_INCORRECT_TRANSMT_NO','P');
551: pay_core_utils.push_token('GRE_NAME',l_trans_name);
552: hr_utility.raise_error;
553: return '1';

Line 552: hr_utility.raise_error;

548: hr_utility.set_message(801,'PAY_74155_INCORRECT_TRANSMT_NO');
549: hr_utility.set_message_token('GRE_NAME',l_trans_name);
550: pay_core_utils.push_message(801,'PAY_74155_INCORRECT_TRANSMT_NO','P');
551: pay_core_utils.push_token('GRE_NAME',l_trans_name);
552: hr_utility.raise_error;
553: return '1';
554: END IF;
555:
556: if l_tech_name is null or

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

556: if l_tech_name is null or
557: l_tech_area is null or
558: l_tech_phno is null or
559: l_lang is null then
560: hr_utility.trace('Technical contact details missing');
561: hr_utility.set_message(801,'PAY_74158_INCORRECT_TCHN_INFO');
562: hr_utility.set_message_token('GRE_NAME',l_trans_name);
563: pay_core_utils.push_message(801,'PAY_74158_INCORRECT_TCHN_INFO','P');
564: pay_core_utils.push_token('GRE_NAME',l_trans_name);

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

557: l_tech_area is null or
558: l_tech_phno is null or
559: l_lang is null then
560: hr_utility.trace('Technical contact details missing');
561: hr_utility.set_message(801,'PAY_74158_INCORRECT_TCHN_INFO');
562: hr_utility.set_message_token('GRE_NAME',l_trans_name);
563: pay_core_utils.push_message(801,'PAY_74158_INCORRECT_TCHN_INFO','P');
564: pay_core_utils.push_token('GRE_NAME',l_trans_name);
565: hr_utility.raise_error;

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

558: l_tech_phno is null or
559: l_lang is null then
560: hr_utility.trace('Technical contact details missing');
561: hr_utility.set_message(801,'PAY_74158_INCORRECT_TCHN_INFO');
562: hr_utility.set_message_token('GRE_NAME',l_trans_name);
563: pay_core_utils.push_message(801,'PAY_74158_INCORRECT_TCHN_INFO','P');
564: pay_core_utils.push_token('GRE_NAME',l_trans_name);
565: hr_utility.raise_error;
566: return '1';

Line 565: hr_utility.raise_error;

561: hr_utility.set_message(801,'PAY_74158_INCORRECT_TCHN_INFO');
562: hr_utility.set_message_token('GRE_NAME',l_trans_name);
563: pay_core_utils.push_message(801,'PAY_74158_INCORRECT_TCHN_INFO','P');
564: pay_core_utils.push_token('GRE_NAME',l_trans_name);
565: hr_utility.raise_error;
566: return '1';
567: end if;
568: if l_acc_name is null or
569: l_acc_phno is null or

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

571: l_acc_info_flag := 'N';
572: else
573: l_acc_info_flag := 'Y';
574: end if;
575: hr_utility.trace('The value of the Flag is '||l_acc_info_flag);
576:
577: /* If Transmitter Level Accounting Information is Missing checking for the GRE level information */
578:
579: open c_all_gres(p_trans,p_year,l_bg_id);

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

578:
579: open c_all_gres(p_trans,p_year,l_bg_id);
580: loop
581: fetch c_all_gres into l_gre_payid, l_gre, l_gre_name;
582: hr_utility.trace('The Gre id fetched is '||l_gre);
583: if c_all_gres%notfound then
584: close c_all_gres;
585: exit;
586: end if;

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

584: close c_all_gres;
585: exit;
586: end if;
587:
588: hr_utility.trace('Before fetching the GREs for this Transmitter '||l_gre||'-'||p_year);
589:
590:
591: if l_gre <> to_number(p_trans) then
592: hr_utility.trace('Inside the loop'||l_gre_payid);

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

588: hr_utility.trace('Before fetching the GREs for this Transmitter '||l_gre||'-'||p_year);
589:
590:
591: if l_gre <> to_number(p_trans) then
592: hr_utility.trace('Inside the loop'||l_gre_payid);
593:
594: hr_utility.trace('Checking GRE level data');
595: hr_utility.trace('The Payroll Action Id for Gre is '|| l_gre_payid);
596: l_bus_no := get_arch_val(l_gre_payid,'CAEOY_EMPLOYER_IDENTIFICATION_NUMBER');

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

590:
591: if l_gre <> to_number(p_trans) then
592: hr_utility.trace('Inside the loop'||l_gre_payid);
593:
594: hr_utility.trace('Checking GRE level data');
595: hr_utility.trace('The Payroll Action Id for Gre is '|| l_gre_payid);
596: l_bus_no := get_arch_val(l_gre_payid,'CAEOY_EMPLOYER_IDENTIFICATION_NUMBER');
597: --l_tax_unit_id := get_arch_val(l_gre_payid, 'CAEOY_TAX_UNIT_ID');
598: l_acc_name := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_NAME');

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

591: if l_gre <> to_number(p_trans) then
592: hr_utility.trace('Inside the loop'||l_gre_payid);
593:
594: hr_utility.trace('Checking GRE level data');
595: hr_utility.trace('The Payroll Action Id for Gre is '|| l_gre_payid);
596: l_bus_no := get_arch_val(l_gre_payid,'CAEOY_EMPLOYER_IDENTIFICATION_NUMBER');
597: --l_tax_unit_id := get_arch_val(l_gre_payid, 'CAEOY_TAX_UNIT_ID');
598: l_acc_name := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_NAME');
599: l_acc_area := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_AREA_CODE');

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

598: l_acc_name := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_NAME');
599: l_acc_area := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_AREA_CODE');
600: l_acc_phno := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_PHONE');
601:
602: hr_utility.trace('Tax unit Id'||l_tax_unit_id);
603: hr_utility.trace('Acc Name '||l_acc_name);
604: hr_utility.trace('Acc Area '||l_acc_area);
605: hr_utility.trace('Acc Phone '||l_acc_phno);
606: hr_utility.trace('gre namee '||l_gre_name);

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

599: l_acc_area := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_AREA_CODE');
600: l_acc_phno := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_PHONE');
601:
602: hr_utility.trace('Tax unit Id'||l_tax_unit_id);
603: hr_utility.trace('Acc Name '||l_acc_name);
604: hr_utility.trace('Acc Area '||l_acc_area);
605: hr_utility.trace('Acc Phone '||l_acc_phno);
606: hr_utility.trace('gre namee '||l_gre_name);
607:

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

600: l_acc_phno := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_PHONE');
601:
602: hr_utility.trace('Tax unit Id'||l_tax_unit_id);
603: hr_utility.trace('Acc Name '||l_acc_name);
604: hr_utility.trace('Acc Area '||l_acc_area);
605: hr_utility.trace('Acc Phone '||l_acc_phno);
606: hr_utility.trace('gre namee '||l_gre_name);
607:
608:

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

601:
602: hr_utility.trace('Tax unit Id'||l_tax_unit_id);
603: hr_utility.trace('Acc Name '||l_acc_name);
604: hr_utility.trace('Acc Area '||l_acc_area);
605: hr_utility.trace('Acc Phone '||l_acc_phno);
606: hr_utility.trace('gre namee '||l_gre_name);
607:
608:
609: if l_bus_no is null

Line 606: hr_utility.trace('gre namee '||l_gre_name);

602: hr_utility.trace('Tax unit Id'||l_tax_unit_id);
603: hr_utility.trace('Acc Name '||l_acc_name);
604: hr_utility.trace('Acc Area '||l_acc_area);
605: hr_utility.trace('Acc Phone '||l_acc_phno);
606: hr_utility.trace('gre namee '||l_gre_name);
607:
608:
609: if l_bus_no is null
610: or TRANSLATE(l_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' then

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

607:
608:
609: if l_bus_no is null
610: or TRANSLATE(l_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' then
611: hr_utility.trace('No Business Number Entereed ');
612: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
613: hr_utility.set_message_token('GRE_NAME',l_gre_name);
614: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
615: pay_core_utils.push_token('GRE_NAME',l_gre_name);

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

608:
609: if l_bus_no is null
610: or TRANSLATE(l_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' then
611: hr_utility.trace('No Business Number Entereed ');
612: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
613: hr_utility.set_message_token('GRE_NAME',l_gre_name);
614: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
615: pay_core_utils.push_token('GRE_NAME',l_gre_name);
616: hr_utility.raise_error;

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

609: if l_bus_no is null
610: or TRANSLATE(l_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' then
611: hr_utility.trace('No Business Number Entereed ');
612: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
613: hr_utility.set_message_token('GRE_NAME',l_gre_name);
614: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
615: pay_core_utils.push_token('GRE_NAME',l_gre_name);
616: hr_utility.raise_error;
617: return '1';

Line 616: hr_utility.raise_error;

612: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
613: hr_utility.set_message_token('GRE_NAME',l_gre_name);
614: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
615: pay_core_utils.push_token('GRE_NAME',l_gre_name);
616: hr_utility.raise_error;
617: return '1';
618: end if;
619:
620: if (l_acc_name is null or

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

620: if (l_acc_name is null or
621: l_acc_area is null or
622: l_acc_phno is null ) and
623: l_acc_info_flag = 'N' then
624: hr_utility.trace('No Accounting Contact info present');
625: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
626: hr_utility.set_message_token('GRE_NAME',l_gre_name);
627: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
628: pay_core_utils.push_token('GRE_NAME',l_gre_name);

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

621: l_acc_area is null or
622: l_acc_phno is null ) and
623: l_acc_info_flag = 'N' then
624: hr_utility.trace('No Accounting Contact info present');
625: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
626: hr_utility.set_message_token('GRE_NAME',l_gre_name);
627: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
628: pay_core_utils.push_token('GRE_NAME',l_gre_name);
629: hr_utility.raise_error;

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

622: l_acc_phno is null ) and
623: l_acc_info_flag = 'N' then
624: hr_utility.trace('No Accounting Contact info present');
625: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
626: hr_utility.set_message_token('GRE_NAME',l_gre_name);
627: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
628: pay_core_utils.push_token('GRE_NAME',l_gre_name);
629: hr_utility.raise_error;
630: return '1';

Line 629: hr_utility.raise_error;

625: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
626: hr_utility.set_message_token('GRE_NAME',l_gre_name);
627: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
628: pay_core_utils.push_token('GRE_NAME',l_gre_name);
629: hr_utility.raise_error;
630: return '1';
631: end if;
632:
633: elsif l_gre = to_number(p_trans) then

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

633: elsif l_gre = to_number(p_trans) then
634:
635: if l_trans_bus_no is null
636: or TRANSLATE(l_trans_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' then
637: hr_utility.trace('No Business Number Entereed ');
638: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
639: hr_utility.set_message_token('GRE_NAME',l_trans_name);
640: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
641: pay_core_utils.push_token('GRE_NAME',l_trans_name);

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

634:
635: if l_trans_bus_no is null
636: or TRANSLATE(l_trans_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' then
637: hr_utility.trace('No Business Number Entereed ');
638: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
639: hr_utility.set_message_token('GRE_NAME',l_trans_name);
640: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
641: pay_core_utils.push_token('GRE_NAME',l_trans_name);
642: hr_utility.raise_error;

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

635: if l_trans_bus_no is null
636: or TRANSLATE(l_trans_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' then
637: hr_utility.trace('No Business Number Entereed ');
638: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
639: hr_utility.set_message_token('GRE_NAME',l_trans_name);
640: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
641: pay_core_utils.push_token('GRE_NAME',l_trans_name);
642: hr_utility.raise_error;
643: return '1';

Line 642: hr_utility.raise_error;

638: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
639: hr_utility.set_message_token('GRE_NAME',l_trans_name);
640: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
641: pay_core_utils.push_token('GRE_NAME',l_trans_name);
642: hr_utility.raise_error;
643: return '1';
644: end if;
645: if l_acc_info_flag = 'N' then
646: hr_utility.trace('No Accounting Contact info present');

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

642: hr_utility.raise_error;
643: return '1';
644: end if;
645: if l_acc_info_flag = 'N' then
646: hr_utility.trace('No Accounting Contact info present');
647: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
648: hr_utility.set_message_token('GRE_NAME',l_trans_name);
649: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
650: pay_core_utils.push_token('GRE_NAME',l_trans_name);

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

643: return '1';
644: end if;
645: if l_acc_info_flag = 'N' then
646: hr_utility.trace('No Accounting Contact info present');
647: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
648: hr_utility.set_message_token('GRE_NAME',l_trans_name);
649: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
650: pay_core_utils.push_token('GRE_NAME',l_trans_name);
651: hr_utility.raise_error;

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

644: end if;
645: if l_acc_info_flag = 'N' then
646: hr_utility.trace('No Accounting Contact info present');
647: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
648: hr_utility.set_message_token('GRE_NAME',l_trans_name);
649: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
650: pay_core_utils.push_token('GRE_NAME',l_trans_name);
651: hr_utility.raise_error;
652: return '1';

Line 651: hr_utility.raise_error;

647: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
648: hr_utility.set_message_token('GRE_NAME',l_trans_name);
649: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
650: pay_core_utils.push_token('GRE_NAME',l_trans_name);
651: hr_utility.raise_error;
652: return '1';
653: end if;
654: end if;
655: end loop;