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

Line 311: hr_utility.trace('RS. Other State Data.l_length = '||to_char(l_length));

307: IF ((p_record_name = 'RS') AND
308: (p_input_3 = 'Other State Data')
309: ) THEN
310: l_length := 10;
311: hr_utility.trace('RS. Other State Data.l_length = '||to_char(l_length));
312: ELSIF p_record_name = 'RS' THEN
313: --{
314: IF p_report_qualifier = 'NJ' THEN
315: IF ((p_input_3 = 'SDI Withheld') OR

Line 458: hr_utility.trace('Valid Address found ');

454: lpad(' ',22));
455: -- Format for Valid Address
456: IF p_valid_address = 'Y' THEN
457: --{
458: hr_utility.trace('Valid Address found ');
459: hr_utility.trace('Location address '||l_location_addr);
460: hr_utility.trace('Delivery address '||l_delivery_addr);
461: hr_utility.trace('town_or_city '||l_city);
462: hr_utility.trace('postal_code '||p_postal_code);

Line 459: hr_utility.trace('Location address '||l_location_addr);

455: -- Format for Valid Address
456: IF p_valid_address = 'Y' THEN
457: --{
458: hr_utility.trace('Valid Address found ');
459: hr_utility.trace('Location address '||l_location_addr);
460: hr_utility.trace('Delivery address '||l_delivery_addr);
461: hr_utility.trace('town_or_city '||l_city);
462: hr_utility.trace('postal_code '||p_postal_code);
463: hr_utility.trace('State '||l_state);

Line 460: hr_utility.trace('Delivery address '||l_delivery_addr);

456: IF p_valid_address = 'Y' THEN
457: --{
458: hr_utility.trace('Valid Address found ');
459: hr_utility.trace('Location address '||l_location_addr);
460: hr_utility.trace('Delivery address '||l_delivery_addr);
461: hr_utility.trace('town_or_city '||l_city);
462: hr_utility.trace('postal_code '||p_postal_code);
463: hr_utility.trace('State '||l_state);
464: hr_utility.trace('p_country '||p_country);

Line 461: hr_utility.trace('town_or_city '||l_city);

457: --{
458: hr_utility.trace('Valid Address found ');
459: hr_utility.trace('Location address '||l_location_addr);
460: hr_utility.trace('Delivery address '||l_delivery_addr);
461: hr_utility.trace('town_or_city '||l_city);
462: hr_utility.trace('postal_code '||p_postal_code);
463: hr_utility.trace('State '||l_state);
464: hr_utility.trace('p_country '||p_country);
465:

Line 462: hr_utility.trace('postal_code '||p_postal_code);

458: hr_utility.trace('Valid Address found ');
459: hr_utility.trace('Location address '||l_location_addr);
460: hr_utility.trace('Delivery address '||l_delivery_addr);
461: hr_utility.trace('town_or_city '||l_city);
462: hr_utility.trace('postal_code '||p_postal_code);
463: hr_utility.trace('State '||l_state);
464: hr_utility.trace('p_country '||p_country);
465:
466: IF c_item_name = 'EE_ADDRESS' THEN

Line 463: hr_utility.trace('State '||l_state);

459: hr_utility.trace('Location address '||l_location_addr);
460: hr_utility.trace('Delivery address '||l_delivery_addr);
461: hr_utility.trace('town_or_city '||l_city);
462: hr_utility.trace('postal_code '||p_postal_code);
463: hr_utility.trace('State '||l_state);
464: hr_utility.trace('p_country '||p_country);
465:
466: IF c_item_name = 'EE_ADDRESS' THEN
467: l_level := 'A';

Line 464: hr_utility.trace('p_country '||p_country);

460: hr_utility.trace('Delivery address '||l_delivery_addr);
461: hr_utility.trace('town_or_city '||l_city);
462: hr_utility.trace('postal_code '||p_postal_code);
463: hr_utility.trace('State '||l_state);
464: hr_utility.trace('p_country '||p_country);
465:
466: IF c_item_name = 'EE_ADDRESS' THEN
467: l_level := 'A';
468: l_mesg_name := 'PAY_INVALID_EE_FORMAT';

Line 548: hr_utility.trace('Zip or Postal Code is null');

544: --{
545: sp_out_5:= lpad(' ',5); --zip
546: sp_out_8:= lpad(' ',15); -- foreign zip
547: sp_out_6:= lpad(' ', 4); --extension
548: hr_utility.trace('Zip or Postal Code is null');
549: --}
550: END IF;
551: IF ((p_item_name = 'ER_ADDRESS') OR ( p_item_name = 'CR_ADDRESS')) THEN
552: sp_out_10:= p_name;

Line 553: hr_utility.trace('Organization Name = '||p_name);

549: --}
550: END IF;
551: IF ((p_item_name = 'ER_ADDRESS') OR ( p_item_name = 'CR_ADDRESS')) THEN
552: sp_out_10:= p_name;
553: hr_utility.trace('Organization Name = '||p_name);
554: /* Locality_Company_Id */
555: IF ((p_item_name = 'ER_ADDRESS') and (p_local_code = 'PHILA')) THEN
556: sp_out_8:= lpad(NVL(p_locality_company_id,' '),15);
557: END IF;

Line 588: hr_utility.trace('location address '||sp_out_1);

584: l_err :=TRUE;
585: END IF;
586: --}
587: END IF; --p_valid_address
588: hr_utility.trace('location address '||sp_out_1);
589: hr_utility.trace('delivery address '||sp_out_2);
590: hr_utility.trace('City '||sp_out_3);
591: hr_utility.trace('State '||sp_out_4);
592: hr_utility.trace('Zip '||sp_out_5);

Line 589: hr_utility.trace('delivery address '||sp_out_2);

585: END IF;
586: --}
587: END IF; --p_valid_address
588: hr_utility.trace('location address '||sp_out_1);
589: hr_utility.trace('delivery address '||sp_out_2);
590: hr_utility.trace('City '||sp_out_3);
591: hr_utility.trace('State '||sp_out_4);
592: hr_utility.trace('Zip '||sp_out_5);
593: hr_utility.trace('Zip Code Extension '||sp_out_6);

Line 590: hr_utility.trace('City '||sp_out_3);

586: --}
587: END IF; --p_valid_address
588: hr_utility.trace('location address '||sp_out_1);
589: hr_utility.trace('delivery address '||sp_out_2);
590: hr_utility.trace('City '||sp_out_3);
591: hr_utility.trace('State '||sp_out_4);
592: hr_utility.trace('Zip '||sp_out_5);
593: hr_utility.trace('Zip Code Extension '||sp_out_6);
594: hr_utility.trace('Foreign State/Province '||sp_out_7);

Line 591: hr_utility.trace('State '||sp_out_4);

587: END IF; --p_valid_address
588: hr_utility.trace('location address '||sp_out_1);
589: hr_utility.trace('delivery address '||sp_out_2);
590: hr_utility.trace('City '||sp_out_3);
591: hr_utility.trace('State '||sp_out_4);
592: hr_utility.trace('Zip '||sp_out_5);
593: hr_utility.trace('Zip Code Extension '||sp_out_6);
594: hr_utility.trace('Foreign State/Province '||sp_out_7);
595: hr_utility.trace('Foreign Zip '||sp_out_8);

Line 592: hr_utility.trace('Zip '||sp_out_5);

588: hr_utility.trace('location address '||sp_out_1);
589: hr_utility.trace('delivery address '||sp_out_2);
590: hr_utility.trace('City '||sp_out_3);
591: hr_utility.trace('State '||sp_out_4);
592: hr_utility.trace('Zip '||sp_out_5);
593: hr_utility.trace('Zip Code Extension '||sp_out_6);
594: hr_utility.trace('Foreign State/Province '||sp_out_7);
595: hr_utility.trace('Foreign Zip '||sp_out_8);
596: hr_utility.trace('Country '||sp_out_9);

Line 593: hr_utility.trace('Zip Code Extension '||sp_out_6);

589: hr_utility.trace('delivery address '||sp_out_2);
590: hr_utility.trace('City '||sp_out_3);
591: hr_utility.trace('State '||sp_out_4);
592: hr_utility.trace('Zip '||sp_out_5);
593: hr_utility.trace('Zip Code Extension '||sp_out_6);
594: hr_utility.trace('Foreign State/Province '||sp_out_7);
595: hr_utility.trace('Foreign Zip '||sp_out_8);
596: hr_utility.trace('Country '||sp_out_9);
597: IF (p_item_name = 'ER_ADDRESS') THEN

Line 594: hr_utility.trace('Foreign State/Province '||sp_out_7);

590: hr_utility.trace('City '||sp_out_3);
591: hr_utility.trace('State '||sp_out_4);
592: hr_utility.trace('Zip '||sp_out_5);
593: hr_utility.trace('Zip Code Extension '||sp_out_6);
594: hr_utility.trace('Foreign State/Province '||sp_out_7);
595: hr_utility.trace('Foreign Zip '||sp_out_8);
596: hr_utility.trace('Country '||sp_out_9);
597: IF (p_item_name = 'ER_ADDRESS') THEN
598: hr_utility.trace('Organization Name '||sp_out_10);

Line 595: hr_utility.trace('Foreign Zip '||sp_out_8);

591: hr_utility.trace('State '||sp_out_4);
592: hr_utility.trace('Zip '||sp_out_5);
593: hr_utility.trace('Zip Code Extension '||sp_out_6);
594: hr_utility.trace('Foreign State/Province '||sp_out_7);
595: hr_utility.trace('Foreign Zip '||sp_out_8);
596: hr_utility.trace('Country '||sp_out_9);
597: IF (p_item_name = 'ER_ADDRESS') THEN
598: hr_utility.trace('Organization Name '||sp_out_10);
599: ELSE

Line 596: hr_utility.trace('Country '||sp_out_9);

592: hr_utility.trace('Zip '||sp_out_5);
593: hr_utility.trace('Zip Code Extension '||sp_out_6);
594: hr_utility.trace('Foreign State/Province '||sp_out_7);
595: hr_utility.trace('Foreign Zip '||sp_out_8);
596: hr_utility.trace('Country '||sp_out_9);
597: IF (p_item_name = 'ER_ADDRESS') THEN
598: hr_utility.trace('Organization Name '||sp_out_10);
599: ELSE
600: hr_utility.trace('Employee Number '||sp_out_10);

Line 598: hr_utility.trace('Organization Name '||sp_out_10);

594: hr_utility.trace('Foreign State/Province '||sp_out_7);
595: hr_utility.trace('Foreign Zip '||sp_out_8);
596: hr_utility.trace('Country '||sp_out_9);
597: IF (p_item_name = 'ER_ADDRESS') THEN
598: hr_utility.trace('Organization Name '||sp_out_10);
599: ELSE
600: hr_utility.trace('Employee Number '||sp_out_10);
601: END IF;
602: --

Line 600: hr_utility.trace('Employee Number '||sp_out_10);

596: hr_utility.trace('Country '||sp_out_9);
597: IF (p_item_name = 'ER_ADDRESS') THEN
598: hr_utility.trace('Organization Name '||sp_out_10);
599: ELSE
600: hr_utility.trace('Employee Number '||sp_out_10);
601: END IF;
602: --
603: -- Check to include or exclude record on the basis of validity of address
604: --

Line 608: hr_utility.trace('p_validate is Y .error '||p_exclude_from_output);

604: --
605: IF p_validate = 'Y' THEN
606: IF l_err THEN
607: p_exclude_from_output := 'Y';
608: hr_utility.trace('p_validate is Y .error '||p_exclude_from_output);
609: END IF;
610: END IF;
611: IF p_exclude_from_output IS NULL THEN
612: p_exclude_from_output := 'N';

Line 686: hr_utility.trace('Valid Address found ');

682: lpad(' ',22));
683: -- Format for Valid Address
684: IF p_valid_address = 'Y' THEN
685: --{
686: hr_utility.trace('Valid Address found ');
687: hr_utility.trace('Location address '||l_location_addr);
688: hr_utility.trace('Delivery address '||l_delivery_addr);
689: hr_utility.trace('town_or_city '||l_city);
690: hr_utility.trace('postal_code '||p_postal_code);

Line 687: hr_utility.trace('Location address '||l_location_addr);

683: -- Format for Valid Address
684: IF p_valid_address = 'Y' THEN
685: --{
686: hr_utility.trace('Valid Address found ');
687: hr_utility.trace('Location address '||l_location_addr);
688: hr_utility.trace('Delivery address '||l_delivery_addr);
689: hr_utility.trace('town_or_city '||l_city);
690: hr_utility.trace('postal_code '||p_postal_code);
691: hr_utility.trace('State '||l_state);

Line 688: hr_utility.trace('Delivery address '||l_delivery_addr);

684: IF p_valid_address = 'Y' THEN
685: --{
686: hr_utility.trace('Valid Address found ');
687: hr_utility.trace('Location address '||l_location_addr);
688: hr_utility.trace('Delivery address '||l_delivery_addr);
689: hr_utility.trace('town_or_city '||l_city);
690: hr_utility.trace('postal_code '||p_postal_code);
691: hr_utility.trace('State '||l_state);
692: hr_utility.trace('p_country '||p_country);

Line 689: hr_utility.trace('town_or_city '||l_city);

685: --{
686: hr_utility.trace('Valid Address found ');
687: hr_utility.trace('Location address '||l_location_addr);
688: hr_utility.trace('Delivery address '||l_delivery_addr);
689: hr_utility.trace('town_or_city '||l_city);
690: hr_utility.trace('postal_code '||p_postal_code);
691: hr_utility.trace('State '||l_state);
692: hr_utility.trace('p_country '||p_country);
693: hr_utility.trace('phone_number '||p_phone_number);

Line 690: hr_utility.trace('postal_code '||p_postal_code);

686: hr_utility.trace('Valid Address found ');
687: hr_utility.trace('Location address '||l_location_addr);
688: hr_utility.trace('Delivery address '||l_delivery_addr);
689: hr_utility.trace('town_or_city '||l_city);
690: hr_utility.trace('postal_code '||p_postal_code);
691: hr_utility.trace('State '||l_state);
692: hr_utility.trace('p_country '||p_country);
693: hr_utility.trace('phone_number '||p_phone_number);
694:

Line 691: hr_utility.trace('State '||l_state);

687: hr_utility.trace('Location address '||l_location_addr);
688: hr_utility.trace('Delivery address '||l_delivery_addr);
689: hr_utility.trace('town_or_city '||l_city);
690: hr_utility.trace('postal_code '||p_postal_code);
691: hr_utility.trace('State '||l_state);
692: hr_utility.trace('p_country '||p_country);
693: hr_utility.trace('phone_number '||p_phone_number);
694:
695: IF c_item_name = 'EE_ADDRESS' THEN

Line 692: hr_utility.trace('p_country '||p_country);

688: hr_utility.trace('Delivery address '||l_delivery_addr);
689: hr_utility.trace('town_or_city '||l_city);
690: hr_utility.trace('postal_code '||p_postal_code);
691: hr_utility.trace('State '||l_state);
692: hr_utility.trace('p_country '||p_country);
693: hr_utility.trace('phone_number '||p_phone_number);
694:
695: IF c_item_name = 'EE_ADDRESS' THEN
696: l_level := 'A';

Line 693: hr_utility.trace('phone_number '||p_phone_number);

689: hr_utility.trace('town_or_city '||l_city);
690: hr_utility.trace('postal_code '||p_postal_code);
691: hr_utility.trace('State '||l_state);
692: hr_utility.trace('p_country '||p_country);
693: hr_utility.trace('phone_number '||p_phone_number);
694:
695: IF c_item_name = 'EE_ADDRESS' THEN
696: l_level := 'A';
697: l_mesg_name := 'PAY_INVALID_EE_FORMAT';

Line 778: hr_utility.trace('Zip or Postal Code is null');

774: sp_out_5:= lpad(' ',5); --zip
775: sp_out_8:= lpad(' ',15); -- foreign zip
776: sp_out_6:= lpad(' ', 4); --extension
777:
778: hr_utility.trace('Zip or Postal Code is null');
779: --}
780: END IF;
781: IF ((p_item_name = 'ER_ADDRESS') OR ( p_item_name = 'CR_ADDRESS')) THEN
782: sp_out_10:= p_name;

Line 783: hr_utility.trace('Organization Name = '||p_name);

779: --}
780: END IF;
781: IF ((p_item_name = 'ER_ADDRESS') OR ( p_item_name = 'CR_ADDRESS')) THEN
782: sp_out_10:= p_name;
783: hr_utility.trace('Organization Name = '||p_name);
784: /* Locality_Company_Id */
785: IF ((p_item_name = 'ER_ADDRESS') and (p_local_code = 'PHILA')) THEN
786: sp_out_8:= lpad(NVL(p_locality_company_id,' '),15);
787: END IF;

Line 830: hr_utility.trace('location address '||sp_out_1);

826: --It is done only for FLSQWL usage and will be removed from this
827: --variable once value is passed to FL_XML_EMPLOYER_SQWL formula
828: --The zip code extension and phone number are separeted by Pipe | symbol
829:
830: hr_utility.trace('location address '||sp_out_1);
831: hr_utility.trace('delivery address '||sp_out_2);
832: hr_utility.trace('City '||sp_out_3);
833: hr_utility.trace('State '||sp_out_4);
834: hr_utility.trace('Zip '||sp_out_5);

Line 831: hr_utility.trace('delivery address '||sp_out_2);

827: --variable once value is passed to FL_XML_EMPLOYER_SQWL formula
828: --The zip code extension and phone number are separeted by Pipe | symbol
829:
830: hr_utility.trace('location address '||sp_out_1);
831: hr_utility.trace('delivery address '||sp_out_2);
832: hr_utility.trace('City '||sp_out_3);
833: hr_utility.trace('State '||sp_out_4);
834: hr_utility.trace('Zip '||sp_out_5);
835: hr_utility.trace('Zip Code Extension '||substr(sp_out_6,1,4));

Line 832: hr_utility.trace('City '||sp_out_3);

828: --The zip code extension and phone number are separeted by Pipe | symbol
829:
830: hr_utility.trace('location address '||sp_out_1);
831: hr_utility.trace('delivery address '||sp_out_2);
832: hr_utility.trace('City '||sp_out_3);
833: hr_utility.trace('State '||sp_out_4);
834: hr_utility.trace('Zip '||sp_out_5);
835: hr_utility.trace('Zip Code Extension '||substr(sp_out_6,1,4));
836: hr_utility.trace('Phone Number '||substr(sp_out_6,5));

Line 833: hr_utility.trace('State '||sp_out_4);

829:
830: hr_utility.trace('location address '||sp_out_1);
831: hr_utility.trace('delivery address '||sp_out_2);
832: hr_utility.trace('City '||sp_out_3);
833: hr_utility.trace('State '||sp_out_4);
834: hr_utility.trace('Zip '||sp_out_5);
835: hr_utility.trace('Zip Code Extension '||substr(sp_out_6,1,4));
836: hr_utility.trace('Phone Number '||substr(sp_out_6,5));
837: hr_utility.trace('Foreign State/Province '||sp_out_7);

Line 834: hr_utility.trace('Zip '||sp_out_5);

830: hr_utility.trace('location address '||sp_out_1);
831: hr_utility.trace('delivery address '||sp_out_2);
832: hr_utility.trace('City '||sp_out_3);
833: hr_utility.trace('State '||sp_out_4);
834: hr_utility.trace('Zip '||sp_out_5);
835: hr_utility.trace('Zip Code Extension '||substr(sp_out_6,1,4));
836: hr_utility.trace('Phone Number '||substr(sp_out_6,5));
837: hr_utility.trace('Foreign State/Province '||sp_out_7);
838: hr_utility.trace('Foreign Zip '||sp_out_8);

Line 835: hr_utility.trace('Zip Code Extension '||substr(sp_out_6,1,4));

831: hr_utility.trace('delivery address '||sp_out_2);
832: hr_utility.trace('City '||sp_out_3);
833: hr_utility.trace('State '||sp_out_4);
834: hr_utility.trace('Zip '||sp_out_5);
835: hr_utility.trace('Zip Code Extension '||substr(sp_out_6,1,4));
836: hr_utility.trace('Phone Number '||substr(sp_out_6,5));
837: hr_utility.trace('Foreign State/Province '||sp_out_7);
838: hr_utility.trace('Foreign Zip '||sp_out_8);
839: hr_utility.trace('Country '||sp_out_9);

Line 836: hr_utility.trace('Phone Number '||substr(sp_out_6,5));

832: hr_utility.trace('City '||sp_out_3);
833: hr_utility.trace('State '||sp_out_4);
834: hr_utility.trace('Zip '||sp_out_5);
835: hr_utility.trace('Zip Code Extension '||substr(sp_out_6,1,4));
836: hr_utility.trace('Phone Number '||substr(sp_out_6,5));
837: hr_utility.trace('Foreign State/Province '||sp_out_7);
838: hr_utility.trace('Foreign Zip '||sp_out_8);
839: hr_utility.trace('Country '||sp_out_9);
840: IF (p_item_name = 'ER_ADDRESS') THEN

Line 837: hr_utility.trace('Foreign State/Province '||sp_out_7);

833: hr_utility.trace('State '||sp_out_4);
834: hr_utility.trace('Zip '||sp_out_5);
835: hr_utility.trace('Zip Code Extension '||substr(sp_out_6,1,4));
836: hr_utility.trace('Phone Number '||substr(sp_out_6,5));
837: hr_utility.trace('Foreign State/Province '||sp_out_7);
838: hr_utility.trace('Foreign Zip '||sp_out_8);
839: hr_utility.trace('Country '||sp_out_9);
840: IF (p_item_name = 'ER_ADDRESS') THEN
841: hr_utility.trace('Organization Name '||sp_out_10);

Line 838: hr_utility.trace('Foreign Zip '||sp_out_8);

834: hr_utility.trace('Zip '||sp_out_5);
835: hr_utility.trace('Zip Code Extension '||substr(sp_out_6,1,4));
836: hr_utility.trace('Phone Number '||substr(sp_out_6,5));
837: hr_utility.trace('Foreign State/Province '||sp_out_7);
838: hr_utility.trace('Foreign Zip '||sp_out_8);
839: hr_utility.trace('Country '||sp_out_9);
840: IF (p_item_name = 'ER_ADDRESS') THEN
841: hr_utility.trace('Organization Name '||sp_out_10);
842: ELSE

Line 839: hr_utility.trace('Country '||sp_out_9);

835: hr_utility.trace('Zip Code Extension '||substr(sp_out_6,1,4));
836: hr_utility.trace('Phone Number '||substr(sp_out_6,5));
837: hr_utility.trace('Foreign State/Province '||sp_out_7);
838: hr_utility.trace('Foreign Zip '||sp_out_8);
839: hr_utility.trace('Country '||sp_out_9);
840: IF (p_item_name = 'ER_ADDRESS') THEN
841: hr_utility.trace('Organization Name '||sp_out_10);
842: ELSE
843: hr_utility.trace('Employee Number '||sp_out_10);

Line 841: hr_utility.trace('Organization Name '||sp_out_10);

837: hr_utility.trace('Foreign State/Province '||sp_out_7);
838: hr_utility.trace('Foreign Zip '||sp_out_8);
839: hr_utility.trace('Country '||sp_out_9);
840: IF (p_item_name = 'ER_ADDRESS') THEN
841: hr_utility.trace('Organization Name '||sp_out_10);
842: ELSE
843: hr_utility.trace('Employee Number '||sp_out_10);
844: END IF;
845: --

Line 843: hr_utility.trace('Employee Number '||sp_out_10);

839: hr_utility.trace('Country '||sp_out_9);
840: IF (p_item_name = 'ER_ADDRESS') THEN
841: hr_utility.trace('Organization Name '||sp_out_10);
842: ELSE
843: hr_utility.trace('Employee Number '||sp_out_10);
844: END IF;
845: --
846: -- Check to include or exclude record on the basis of validity of address
847: --

Line 851: hr_utility.trace('p_validate is Y .error '||p_exclude_from_output);

847: --
848: IF p_validate = 'Y' THEN
849: IF l_err THEN
850: p_exclude_from_output := 'Y';
851: hr_utility.trace('p_validate is Y .error '||p_exclude_from_output);
852: END IF;
853: END IF;
854: IF p_exclude_from_output IS NULL THEN
855: p_exclude_from_output := 'N';

Line 1014: hr_utility.trace('RA Record Formatting started ');

1010: r_input_38 varchar2(300);
1011: r_input_39 varchar2(300);
1012:
1013: BEGIN
1014: hr_utility.trace('RA Record Formatting started ');
1015: hr_utility.trace(' Format_W2_RA_Record Begin for Company '|| p_input_7);
1016: -- Initializing local variables with parameter value
1017: --{
1018: r_input_2 := p_input_2;

Line 1015: hr_utility.trace(' Format_W2_RA_Record Begin for Company '|| p_input_7);

1011: r_input_39 varchar2(300);
1012:
1013: BEGIN
1014: hr_utility.trace('RA Record Formatting started ');
1015: hr_utility.trace(' Format_W2_RA_Record Begin for Company '|| p_input_7);
1016: -- Initializing local variables with parameter value
1017: --{
1018: r_input_2 := p_input_2;
1019: r_input_3 := p_input_3;

Line 1079: hr_utility.trace('Valid EIN '||l_emp_ein);

1075:
1076: IF p_exclude_from_output = 'Y' THEN
1077: l_exclude_from_output_chk := TRUE;
1078: END IF;
1079: hr_utility.trace('Valid EIN '||l_emp_ein);
1080: -- Validation Ends
1081: --
1082: -- Formatiing Starts
1083:

Line 1143: hr_utility.trace(' l_pin = '||l_pin);

1139: ELSE
1140: --{
1141: /* Bug 4391218 Pos: 12 - 19 (8 characters) */
1142: l_pin := rpad(substr(nvl(p_input_3,' '),1,8),17);
1143: hr_utility.trace(' l_pin = '||l_pin);
1144: --}
1145: END IF;
1146: /*6330489*/
1147: -- IF p_report_qualifier not in ('MO_KNSAS','MO_STLOU','OH_CCAAA','OH_DAYTO','OH_RTCCA','PA_PHILA')

Line 1185: hr_utility.trace('Preferred method of code is correct. it is '||p_input_32);

1181: IF ((p_input_32 = '1' ) OR
1182: (p_input_32 = '2' )
1183: )
1184: THEN
1185: hr_utility.trace('Preferred method of code is correct. it is '||p_input_32);
1186: l_pblm_code:= p_input_32;
1187: ELSE
1188: hr_utility.trace('Preferred method of code is incorrect. it is '||p_input_32);
1189: l_pblm_code:= lpad('2',1);

Line 1188: hr_utility.trace('Preferred method of code is incorrect. it is '||p_input_32);

1184: THEN
1185: hr_utility.trace('Preferred method of code is correct. it is '||p_input_32);
1186: l_pblm_code:= p_input_32;
1187: ELSE
1188: hr_utility.trace('Preferred method of code is incorrect. it is '||p_input_32);
1189: l_pblm_code:= lpad('2',1);
1190: END IF;
1191: -- Bug # 2682428
1192: --

Line 1217: hr_utility.trace('l_preparer_code is correct. it is '||p_input_33);

1213: (p_input_33 = 'L' )OR
1214: (p_input_33 = 'P' )OR
1215: (p_input_33 = 'O' )) THEN
1216: l_preparer_code:= p_input_33;
1217: hr_utility.trace('l_preparer_code is correct. it is '||p_input_33);
1218: ELSE
1219: l_preparer_code:= lpad(' ',1);
1220: hr_utility.trace('l_preparer_code is incorrect. it is '||p_input_33);
1221: END IF;

Line 1220: hr_utility.trace('l_preparer_code is incorrect. it is '||p_input_33);

1216: l_preparer_code:= p_input_33;
1217: hr_utility.trace('l_preparer_code is correct. it is '||p_input_33);
1218: ELSE
1219: l_preparer_code:= lpad(' ',1);
1220: hr_utility.trace('l_preparer_code is incorrect. it is '||p_input_33);
1221: END IF;
1222:
1223: /* fix for bug # 2680189 */
1224: /* IF (p_report_qualifier = 'PA_PHILA') THEN

Line 1348: hr_utility.trace('RA Record of FLAT Type -----');

1344: ||l_preparer_code
1345: ||lpad(' ',12)
1346: ||l_end_of_rec ;
1347: --
1348: hr_utility.trace('RA Record of FLAT Type -----');
1349: ret_str_len:=length(return_value);
1350:
1351: ELSIF p_input_40 = 'CSV' THEN
1352: hr_utility.trace('RA Record of CSV Type formatting Starts ----');

Line 1352: hr_utility.trace('RA Record of CSV Type formatting Starts ----');

1348: hr_utility.trace('RA Record of FLAT Type -----');
1349: ret_str_len:=length(return_value);
1350:
1351: ELSIF p_input_40 = 'CSV' THEN
1352: hr_utility.trace('RA Record of CSV Type formatting Starts ----');
1353: return_value:='RA'||','||p_input_2||','||p_input_3||','||lpad(' ',9) -- Bug# 4391218
1354: ||','||rpad(substr(nvl(p_input_4,'0'),1,1),1)
1355: ||','||rpad(substr(nvl(p_input_5,' '),1,6),6)
1356: ||','||rpad(substr(nvl(p_input_6,' '),1,2),2)

Line 1389: hr_utility.trace(' RA Record of CSV Type formatting Ends----');

1385: ||','||rpad(substr(nvl(p_input_31,' '),1,10),10)
1386: ||','||p_input_32
1387: ||','||p_input_33
1388: ||','||lpad(' ',12);
1389: hr_utility.trace(' RA Record of CSV Type formatting Ends----');
1390: hr_utility.trace(return_value);
1391: END IF;
1392: p_error := l_exclude_from_output_chk;
1393: ret_str_len:=length(return_value);

Line 1390: hr_utility.trace(return_value);

1386: ||','||p_input_32
1387: ||','||p_input_33
1388: ||','||lpad(' ',12);
1389: hr_utility.trace(' RA Record of CSV Type formatting Ends----');
1390: hr_utility.trace(return_value);
1391: END IF;
1392: p_error := l_exclude_from_output_chk;
1393: ret_str_len:=length(return_value);
1394: return return_value;

Line 1554: hr_utility.trace('RV Record Formatting started ');

1550: return_value varchar2(32767);
1551:
1552:
1553: BEGIN
1554: hr_utility.trace('RV Record Formatting started ');
1555: -- Initializing local variables with parameter value
1556: r_input_2 := p_input_2;
1557: r_input_3 := p_input_3;
1558: r_input_4 := p_input_4;

Line 2005: hr_utility.trace('RE Record Formatting started ');

2001: r_input_38 varchar2(300);
2002: r_input_39 varchar2(300);
2003:
2004: BEGIN
2005: hr_utility.trace('RE Record Formatting started ');
2006: -- Initializing local variables with parameter value
2007: --{
2008: r_input_2 := p_input_2;
2009: r_input_3 := p_input_3;

Line 2052: hr_utility.trace('agent indicator is Y');

2048: IF p_record_name = 'RE' THEN -- p_record_name
2049: --{
2050: /* Check for agent indicator code p_input_3 */
2051: IF p_input_3 = 'Y' THEN
2052: hr_utility.trace('agent indicator is Y');
2053: l_agent_indicator := '1';
2054: l_emp_ein := p_input_5;
2055: l_agent_ein := p_input_4;
2056: ELSE

Line 2058: hr_utility.trace('agent indicator is not 1');

2054: l_emp_ein := p_input_5;
2055: l_agent_ein := p_input_4;
2056: ELSE
2057: l_agent_indicator:=lpad(' ','1');
2058: hr_utility.trace('agent indicator is not 1');
2059: l_emp_ein := p_input_4;
2060: l_agent_ein := lpad(' ',9);
2061: END IF;
2062:

Line 2125: hr_utility.trace('before data_validation of ein');

2121: -- not for any of the audit report
2122: --
2123: IF p_input_40 = 'FLAT' THEN
2124: --{
2125: hr_utility.trace('before data_validation of ein');
2126: l_emp_ein :=
2127: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
2128: p_report_type,
2129: p_format,

Line 2167: hr_utility.trace('after data_validation of EIN');

2163: END IF;
2164: --}
2165: END IF; -- agent_indicator
2166:
2167: hr_utility.trace('after data_validation of EIN');
2168: l_input_8 := replace(r_input_8,' ');
2169:
2170: IF l_input_8 IS NOT NULL THEN --Checking Other EIN for validation
2171: --{

Line 2172: hr_utility.trace('before data_validation of other EIN');

2168: l_input_8 := replace(r_input_8,' ');
2169:
2170: IF l_input_8 IS NOT NULL THEN --Checking Other EIN for validation
2171: --{
2172: hr_utility.trace('before data_validation of other EIN');
2173: l_other_ein:= pay_us_reporting_utils_pkg.data_validation(p_effective_date,
2174: p_report_type,
2175: p_format,
2176: p_report_qualifier,

Line 2187: hr_utility.trace('after data_validation of l_other_ein');

2183: p_validate,
2184: p_exclude_from_output,
2185: sp_out_1,
2186: sp_out_2);
2187: hr_utility.trace('after data_validation of l_other_ein');
2188: IF p_exclude_from_output = 'Y' THEN
2189: l_exclude_from_output_chk := TRUE;
2190: END IF;
2191: --}

Line 2345: hr_utility.trace('CHK before Formating Locality Comapny ID ');

2341: END IF;
2342:
2343: IF p_report_qualifier = 'PA_PHILA' THEN
2344: --{
2345: hr_utility.trace('CHK before Formating Locality Comapny ID ');
2346: /* l_bus_tax_acct_number := rpad(replace(replace(nvl
2347: (replace(p_input_17,' '),' '),'/'),'-'),7);
2348: hr_utility.trace('CHK Formatted Locality Comapny ID '
2349: ||l_bus_tax_acct_number); */

Line 2348: hr_utility.trace('CHK Formatted Locality Comapny ID '

2344: --{
2345: hr_utility.trace('CHK before Formating Locality Comapny ID ');
2346: /* l_bus_tax_acct_number := rpad(replace(replace(nvl
2347: (replace(p_input_17,' '),' '),'/'),'-'),7);
2348: hr_utility.trace('CHK Formatted Locality Comapny ID '
2349: ||l_bus_tax_acct_number); */
2350: -- r_input_22 := substr(l_bus_tax_acct_number,1,2);
2351: -- r_input_23 := rpad(substr(l_bus_tax_acct_number,3,7),6);
2352: r_input_22 := lpad(' ',2);

Line 2802: hr_utility.trace('Formatting RW record');

2798: AND EFFECTIVE_END_DATE
2799: AND FED_INFORMATION_CATEGORY = '401K LIMITS';
2800:
2801: BEGIN
2802: hr_utility.trace('Formatting RW record');
2803: hr_utility.trace('Formatting Mode = '||p_input_40);
2804: -- Initializing local variables with parameter value
2805: --{
2806: r_input_2 := p_input_2;

Line 2803: hr_utility.trace('Formatting Mode = '||p_input_40);

2799: AND FED_INFORMATION_CATEGORY = '401K LIMITS';
2800:
2801: BEGIN
2802: hr_utility.trace('Formatting RW record');
2803: hr_utility.trace('Formatting Mode = '||p_input_40);
2804: -- Initializing local variables with parameter value
2805: --{
2806: r_input_2 := p_input_2;
2807: r_input_3 := p_input_3;

Line 3077: hr_utility.trace('l_emp_name_or_number = '||l_emp_name_or_number);

3073: l_emp_number := replace(p_input_39,' ');
3074:
3075: IF l_emp_number IS NULL THEN
3076: l_emp_name_or_number := l_full_name;
3077: hr_utility.trace('l_emp_name_or_number = '||l_emp_name_or_number);
3078: ELSE
3079: l_emp_name_or_number:= l_emp_number;
3080: hr_utility.trace('l_emp_name_or_number = '||l_emp_name_or_number);
3081: END IF;

Line 3080: hr_utility.trace('l_emp_name_or_number = '||l_emp_name_or_number);

3076: l_emp_name_or_number := l_full_name;
3077: hr_utility.trace('l_emp_name_or_number = '||l_emp_name_or_number);
3078: ELSE
3079: l_emp_name_or_number:= l_emp_number;
3080: hr_utility.trace('l_emp_name_or_number = '||l_emp_name_or_number);
3081: END IF;
3082: --
3083: -- Validation for RW Record Start
3084: --

Line 3129: hr_utility.trace(parameter_record(i).p_parameter_name||' = '||

3125:
3126: IF p_exclude_from_output = 'Y' THEN
3127: l_exclude_from_output_chk := TRUE;
3128: END IF;
3129: hr_utility.trace(parameter_record(i).p_parameter_name||' = '||
3130: parameter_record(i).p_output_value);
3131: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
3132:
3133: END LOOP;

Line 3131: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);

3127: l_exclude_from_output_chk := TRUE;
3128: END IF;
3129: hr_utility.trace(parameter_record(i).p_parameter_name||' = '||
3130: parameter_record(i).p_output_value);
3131: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
3132:
3133: END LOOP;
3134:
3135: hr_utility.trace('SS Wage and Tax limit Checking begins.' );

Line 3135: hr_utility.trace('SS Wage and Tax limit Checking begins.' );

3131: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
3132:
3133: END LOOP;
3134:
3135: hr_utility.trace('SS Wage and Tax limit Checking begins.' );
3136: OPEN get_ss_limit(p_effective_date);
3137: LOOP
3138: FETCH get_ss_limit INTO l_ss_wage_limit,
3139: l_ss_tax_limit;

Line 3140: hr_utility.trace('SS Wage Limit '||to_char(l_ss_wage_limit));

3136: OPEN get_ss_limit(p_effective_date);
3137: LOOP
3138: FETCH get_ss_limit INTO l_ss_wage_limit,
3139: l_ss_tax_limit;
3140: hr_utility.trace('SS Wage Limit '||to_char(l_ss_wage_limit));
3141: l_ss_count:= get_ss_limit%ROWCOUNT;
3142: EXIT WHEN get_ss_limit%NOTFOUND ;
3143: END LOOP;
3144: CLOSE get_ss_limit;

Line 3145: hr_utility.trace('No. rows exist for limit '||to_char(l_ss_count));

3141: l_ss_count:= get_ss_limit%ROWCOUNT;
3142: EXIT WHEN get_ss_limit%NOTFOUND ;
3143: END LOOP;
3144: CLOSE get_ss_limit;
3145: hr_utility.trace('No. rows exist for limit '||to_char(l_ss_count));
3146:
3147: IF l_ss_count = 0 THEN
3148: hr_utility.trace('No data found on PAY_US_FEDERAL_TAX_INFO_F '||
3149: 'for Social security wage limits.');

Line 3148: hr_utility.trace('No data found on PAY_US_FEDERAL_TAX_INFO_F '||

3144: CLOSE get_ss_limit;
3145: hr_utility.trace('No. rows exist for limit '||to_char(l_ss_count));
3146:
3147: IF l_ss_count = 0 THEN
3148: hr_utility.trace('No data found on PAY_US_FEDERAL_TAX_INFO_F '||
3149: 'for Social security wage limits.');
3150: ELSIF l_ss_count >1 THEN
3151: hr_utility.trace('Too many rows on PAY_US_FEDERAL_TAX_INFO_F '||
3152: 'for Social security wage limits.');

Line 3151: hr_utility.trace('Too many rows on PAY_US_FEDERAL_TAX_INFO_F '||

3147: IF l_ss_count = 0 THEN
3148: hr_utility.trace('No data found on PAY_US_FEDERAL_TAX_INFO_F '||
3149: 'for Social security wage limits.');
3150: ELSIF l_ss_count >1 THEN
3151: hr_utility.trace('Too many rows on PAY_US_FEDERAL_TAX_INFO_F '||
3152: 'for Social security wage limits.');
3153: ELSIF l_ss_count=1 THEN
3154: --{
3155: IF (to_number(parameter_record(3).p_output_value) > 0 OR

Line 3160: hr_utility.trace('SS Tax w/h, SS Tips, SS Wages are >0 ');

3156: to_number(parameter_record(4).p_output_value) > 0 OR
3157: to_number(parameter_record(7).p_output_value) > 0 )
3158: THEN
3159: --{
3160: hr_utility.trace('SS Tax w/h, SS Tips, SS Wages are >0 ');
3161: IF (to_number(parameter_record(3).p_output_value)+
3162: to_number(parameter_record(7).p_output_value))
3163: > l_ss_wage_limit
3164: THEN

Line 3165: hr_utility.trace('ss_tips+ss_wages is > '||

3161: IF (to_number(parameter_record(3).p_output_value)+
3162: to_number(parameter_record(7).p_output_value))
3163: > l_ss_wage_limit
3164: THEN
3165: hr_utility.trace('ss_tips+ss_wages is > '||
3166: to_char(l_ss_wage_limit));
3167: l_field_description:='the sum of '||
3168: parameter_record(3).p_parameter_name
3169: ||' and '||

Line 3186: hr_utility.trace('SS Tax w/h is > '||

3182:
3183: IF to_number(parameter_record(4).p_output_value)>l_ss_tax_limit
3184: THEN
3185: --{
3186: hr_utility.trace('SS Tax w/h is > '||
3187: to_char(l_ss_tax_limit));
3188: l_err := TRUE;
3189: l_amount:=l_ss_tax_limit/100;
3190: l_description:=' It is greater than '||to_char(l_amount);

Line 3206: hr_utility.trace('After SS Wage/ Tax limit checking ');

3202: END IF; -- negative check
3203: --}
3204: END IF; --l_ss_count
3205:
3206: hr_utility.trace('After SS Wage/ Tax limit checking ');
3207:
3208: IF l_err THEN
3209: IF p_validate = 'Y' THEN
3210: p_exclude_from_output := 'Y';

Line 3303: hr_utility.trace('Before formatting and returning RW record for the flat file');

3299:
3300: END IF;*/
3301:
3302:
3303: hr_utility.trace('Before formatting and returning RW record for the flat file');
3304:
3305: -- Formatting Wage Record for .mf reporting file
3306: --
3307: IF p_report_qualifier = 'IN' THEN

Line 3464: hr_utility.trace('ret_str_len = '||to_char(ret_str_len));

3460: ||rpad(substr(nvl(r_input_36,'0'),1,1),1)
3461: ||rpad(substr(nvl(r_input_37,'0'),1,1),24);
3462: END IF ;
3463: ret_str_len:=length(return_value);
3464: hr_utility.trace('ret_str_len = '||to_char(ret_str_len));
3465: --}
3466: ELSIF p_input_40 = 'CSV' THEN
3467: --{
3468: hr_utility.trace('CSV');

Line 3468: hr_utility.trace('CSV');

3464: hr_utility.trace('ret_str_len = '||to_char(ret_str_len));
3465: --}
3466: ELSIF p_input_40 = 'CSV' THEN
3467: --{
3468: hr_utility.trace('CSV');
3469: return_value :=
3470: 'RW'||','||replace(p_input_2,',')
3471: ||','||replace(p_input_3,',',' ')||','||replace(p_input_4,',',' ')
3472: ||','||replace(p_input_5,',',' ')||','||replace(p_input_6,',',' ')

Line 3520: hr_utility.trace('Formatting BLANK RW Record ');

3516: ||','||lpad(' ',23);
3517: --}
3518: ELSIF p_input_40 = 'BLANK' THEN
3519: --{
3520: hr_utility.trace('Formatting BLANK RW Record ');
3521: return_value :=
3522: ' '||','||' '
3523: ||','||' '||','||' '
3524: ||','||' '||','||' '

Line 3569: hr_utility.trace(return_value);

3565: ||','||lpad(' ',1)
3566: ||','||' '
3567: --||','||' ' Bug 13073346
3568: ||','||' ';
3569: hr_utility.trace(return_value);
3570: --}
3571: END IF;
3572: p_error := l_exclude_from_output_chk;
3573: ret_str_len:=length(return_value);

Line 3735: hr_utility.trace('Formatting RO Record');

3731: r_input_38 varchar2(300);
3732: r_input_39 varchar2(300);
3733:
3734: BEGIN
3735: hr_utility.trace('Formatting RO Record');
3736: hr_utility.trace('Format Mode p_input_40 '||p_input_40);
3737: -- Initializing local variables with parameter value
3738: r_input_2 := p_input_2;
3739: r_input_3 := p_input_3;

Line 3736: hr_utility.trace('Format Mode p_input_40 '||p_input_40);

3732: r_input_39 varchar2(300);
3733:
3734: BEGIN
3735: hr_utility.trace('Formatting RO Record');
3736: hr_utility.trace('Format Mode p_input_40 '||p_input_40);
3737: -- Initializing local variables with parameter value
3738: r_input_2 := p_input_2;
3739: r_input_3 := p_input_3;
3740: r_input_4 := p_input_4;

Line 3839: hr_utility.trace('Before the data validation loop.');

3835: parameter_record(19).p_parameter_name:= 'Designated Roth Contributions under a Governmental Section 457(b) plan';
3836: parameter_record(19).p_parameter_value := p_input_25;
3837:
3838:
3839: hr_utility.trace('Before the data validation loop.');
3840: --
3841: -- This loop used to validation above 17 input values
3842: --
3843: FOR i in 1..19 --Bug 13255564

Line 3846: hr_utility.trace('Value of loop counter i is : ' || to_char(i));

3842: --
3843: FOR i in 1..19 --Bug 13255564
3844: LOOP
3845: --{
3846: hr_utility.trace('Value of loop counter i is : ' || to_char(i));
3847: hr_utility.trace('Input '||parameter_record(i).p_parameter_name||' = '
3848: ||parameter_record(i).p_parameter_value);
3849:
3850: parameter_record(i).p_output_value :=

Line 3847: hr_utility.trace('Input '||parameter_record(i).p_parameter_name||' = '

3843: FOR i in 1..19 --Bug 13255564
3844: LOOP
3845: --{
3846: hr_utility.trace('Value of loop counter i is : ' || to_char(i));
3847: hr_utility.trace('Input '||parameter_record(i).p_parameter_name||' = '
3848: ||parameter_record(i).p_parameter_value);
3849:
3850: parameter_record(i).p_output_value :=
3851: pay_us_reporting_utils_pkg.data_validation( p_effective_date,

Line 3870: hr_utility.trace('Value of i is : ' || to_char(i));

3866: IF p_exclude_from_output = 'Y' THEN
3867: l_exclude_from_output_chk := TRUE;
3868: END IF;
3869:
3870: hr_utility.trace('Value of i is : ' || to_char(i));
3871: hr_utility.trace('Output ' || parameter_record(i).p_parameter_name||' = '
3872: ||parameter_record(i).p_output_value);
3873: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
3874: --}

Line 3871: hr_utility.trace('Output ' || parameter_record(i).p_parameter_name||' = '

3867: l_exclude_from_output_chk := TRUE;
3868: END IF;
3869:
3870: hr_utility.trace('Value of i is : ' || to_char(i));
3871: hr_utility.trace('Output ' || parameter_record(i).p_parameter_name||' = '
3872: ||parameter_record(i).p_output_value);
3873: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
3874: --}
3875: END LOOP; -- End of various Amount validation loop

Line 3873: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);

3869:
3870: hr_utility.trace('Value of i is : ' || to_char(i));
3871: hr_utility.trace('Output ' || parameter_record(i).p_parameter_name||' = '
3872: ||parameter_record(i).p_output_value);
3873: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
3874: --}
3875: END LOOP; -- End of various Amount validation loop
3876: hr_utility.trace('After Amount data validation ');
3877: -- Spouse SSN validation

Line 3876: hr_utility.trace('After Amount data validation ');

3872: ||parameter_record(i).p_output_value);
3873: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
3874: --}
3875: END LOOP; -- End of various Amount validation loop
3876: hr_utility.trace('After Amount data validation ');
3877: -- Spouse SSN validation
3878: IF p_input_20 = 'PR_M' THEN
3879: l_ssn:= replace(replace(p_input_10,' '),'I');
3880: IF l_ssn IS NULL THEN

Line 3905: hr_utility.trace('After Spouse SSN validation. SSN = '||l_ssn);

3901: END IF;
3902: ELSE
3903: l_ssn:=lpad(' ',9);
3904: END IF;
3905: hr_utility.trace('After Spouse SSN validation. SSN = '||l_ssn);
3906: -- This is added for Philadelphia locality
3907: --
3908: IF (p_report_qualifier = 'PA_PHILA') THEN
3909: IF p_input_21 IS NULL THEN

Line 3928: hr_utility.trace('For Philadelphia SSN after validation. = '||l_emp_ssn);

3924: p_validate,
3925: p_exclude_from_output,
3926: sp_out_1,
3927: sp_out_2);
3928: hr_utility.trace('For Philadelphia SSN after validation. = '||l_emp_ssn);
3929: IF p_exclude_from_output = 'Y' THEN
3930: l_exclude_from_output_chk := TRUE;
3931: END IF;
3932: END IF;

Line 4109: hr_utility.trace('length of return_Value RO = '||to_char(ret_str_len));

4105: ||rpad(r_input_19,139);
4106: END IF;
4107:
4108: ret_str_len:=length(return_value);
4109: hr_utility.trace('length of return_Value RO = '||to_char(ret_str_len));
4110: --}
4111: ELSIF p_input_40 = 'CSV' THEN
4112: --{
4113: -- Format Mode CSV

Line 4495: hr_utility.trace('Formatting RS record for W2 reporting');

4491: r_input_38 varchar2(300);
4492: r_input_39 varchar2(300);
4493:
4494: BEGIN
4495: hr_utility.trace('Formatting RS record for W2 reporting');
4496: hr_utility.trace('p_report_qualifier = '||p_report_qualifier);
4497: -- Initializing local variables with parameter value
4498: --{
4499: r_input_2 := p_input_2;

Line 4496: hr_utility.trace('p_report_qualifier = '||p_report_qualifier);

4492: r_input_39 varchar2(300);
4493:
4494: BEGIN
4495: hr_utility.trace('Formatting RS record for W2 reporting');
4496: hr_utility.trace('p_report_qualifier = '||p_report_qualifier);
4497: -- Initializing local variables with parameter value
4498: --{
4499: r_input_2 := p_input_2;
4500: r_input_3 := p_input_3;

Line 4542: hr_utility.trace('l_state_length = '||to_char(l_state_length));

4538: l_state_length := length(replace(p_input_2,' ')); /* Fix for State code.*/
4539: IF l_state_length < 2 THEN
4540: r_input_2 := lpad(replace(p_input_2,' '),2,0);
4541: r_input_26 := lpad(replace(p_input_26,' '),2,0);
4542: hr_utility.trace('l_state_length = '||to_char(l_state_length));
4543: hr_utility.trace('l_state_length < 2.State code r_input_2 = '||r_input_2);
4544: hr_utility.trace('State code r_input_26 = '||r_input_26);
4545: END IF;
4546:

Line 4543: hr_utility.trace('l_state_length < 2.State code r_input_2 = '||r_input_2);

4539: IF l_state_length < 2 THEN
4540: r_input_2 := lpad(replace(p_input_2,' '),2,0);
4541: r_input_26 := lpad(replace(p_input_26,' '),2,0);
4542: hr_utility.trace('l_state_length = '||to_char(l_state_length));
4543: hr_utility.trace('l_state_length < 2.State code r_input_2 = '||r_input_2);
4544: hr_utility.trace('State code r_input_26 = '||r_input_26);
4545: END IF;
4546:
4547: /* Pos:3 - 4 State Code Blank for AL,MA,MD */

Line 4544: hr_utility.trace('State code r_input_26 = '||r_input_26);

4540: r_input_2 := lpad(replace(p_input_2,' '),2,0);
4541: r_input_26 := lpad(replace(p_input_26,' '),2,0);
4542: hr_utility.trace('l_state_length = '||to_char(l_state_length));
4543: hr_utility.trace('l_state_length < 2.State code r_input_2 = '||r_input_2);
4544: hr_utility.trace('State code r_input_26 = '||r_input_26);
4545: END IF;
4546:
4547: /* Pos:3 - 4 State Code Blank for AL,MA,MD */
4548: IF (/*(p_report_qualifier = 'MA') OR 6720319 */

Line 4602: hr_utility.trace('SSN after Validation and Formatting = '||l_ssn);

4598: ELSE
4599: l_ssn := replace(replace(r_input_4,'-'),',');
4600: END IF;
4601:
4602: hr_utility.trace('SSN after Validation and Formatting = '||l_ssn);
4603:
4604: /* Pos:19 - 33 First name
4605: Pos:34 - 48 Middle name
4606: Pos:49 - 68 Last name

Line 4623: hr_utility.trace('l_suffix = '||l_suffix);

4619: l_middle_name := pay_us_reporting_utils_pkg.Character_check(rpad(' ',15));
4620: l_suffix := pay_us_reporting_utils_pkg.Character_check(rpad(' ',4));
4621: end if;
4622: --bug 10266082
4623: hr_utility.trace('l_suffix = '||l_suffix);
4624:
4625: /* Suffix blank for MD,OH_RC,MD_SQWL,MN_SQWL,OH_SQWL */
4626: IF ((p_report_qualifier = 'MD') OR
4627: (p_report_qualifier = 'OH_CCAAA') OR

Line 4640: hr_utility.trace('Pos:69 - 149 blank for state '||p_report_qualifier);

4636: (p_report_qualifier = 'MO') --OR -- Fix for bug # 2149507 Bug # 7572620
4637: -- (p_report_qualifier = 'WV') -- Bug # 3186636
4638: ) THEN
4639: --{
4640: hr_utility.trace('Pos:69 - 149 blank for state '||p_report_qualifier);
4641: l_suffix := lpad(' ',4);
4642: r_input_9 := lpad(' ',22);
4643: r_input_10 := lpad(' ',22);
4644: r_input_11 := lpad(' ',22);

Line 4969: hr_utility.trace('SIT Withheld = '||r_input_28);

4965:
4966: /* SIT withheld for St Louis, MO Local is zero filled */
4967: IF p_report_qualifier = 'MO_STLOU' THEN
4968: r_input_28 := rpad(0,11,0);
4969: hr_utility.trace('SIT Withheld = '||r_input_28);
4970: END IF;
4971:
4972: /* Pos:298 - 307 Other state data AL,MD,OH*/
4973: /* Pos:298-307 State Excess Wages for LA_SQWL. */

Line 4981: hr_utility.trace(' Other state data AL, OH, MD, MS ');

4977: (p_report_qualifier = 'MD') OR
4978: (p_report_qualifier = 'MS')) THEN
4979: --{
4980: If p_input_40 = 'FLAT' THEN
4981: hr_utility.trace(' Other state data AL, OH, MD, MS ');
4982: r_input_29 :=
4983: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
4984: p_report_type,
4985: p_format,

Line 5100: hr_utility.trace('Local Taxable Wages after validation n Formatting '

5096: sp_out_2);
5097: IF p_exclude_from_output = 'Y' THEN
5098: l_exclude_from_output_chk := TRUE;
5099: END IF;
5100: hr_utility.trace('Local Taxable Wages after validation n Formatting '
5101: ||r_input_31);
5102: hr_utility.trace('Local Tax Withhel after validation n Formatting '
5103: ||r_input_32);
5104: END IF;

Line 5102: hr_utility.trace('Local Tax Withhel after validation n Formatting '

5098: l_exclude_from_output_chk := TRUE;
5099: END IF;
5100: hr_utility.trace('Local Taxable Wages after validation n Formatting '
5101: ||r_input_31);
5102: hr_utility.trace('Local Tax Withhel after validation n Formatting '
5103: ||r_input_32);
5104: END IF;
5105: --}
5106: ELSE /* Zero Fill for other States. */

Line 5107: hr_utility.trace('Zero fill for SQWLs. p_report_qualifier = '||p_report_qualifier);

5103: ||r_input_32);
5104: END IF;
5105: --}
5106: ELSE /* Zero Fill for other States. */
5107: hr_utility.trace('Zero fill for SQWLs. p_report_qualifier = '||p_report_qualifier);
5108: r_input_31 := rpad(0,11,0);
5109: r_input_32 := rpad(0,11,0);
5110: hr_utility.trace('r_input_31 '||r_input_31);
5111: hr_utility.trace('r_input_32 '||r_input_32);

Line 5110: hr_utility.trace('r_input_31 '||r_input_31);

5106: ELSE /* Zero Fill for other States. */
5107: hr_utility.trace('Zero fill for SQWLs. p_report_qualifier = '||p_report_qualifier);
5108: r_input_31 := rpad(0,11,0);
5109: r_input_32 := rpad(0,11,0);
5110: hr_utility.trace('r_input_31 '||r_input_31);
5111: hr_utility.trace('r_input_32 '||r_input_32);
5112: END IF;
5113:
5114: /* Pos:309-330 Blank for SC_SQWL. State wages and SIT withheld. */

Line 5111: hr_utility.trace('r_input_32 '||r_input_32);

5107: hr_utility.trace('Zero fill for SQWLs. p_report_qualifier = '||p_report_qualifier);
5108: r_input_31 := rpad(0,11,0);
5109: r_input_32 := rpad(0,11,0);
5110: hr_utility.trace('r_input_31 '||r_input_31);
5111: hr_utility.trace('r_input_32 '||r_input_32);
5112: END IF;
5113:
5114: /* Pos:309-330 Blank for SC_SQWL. State wages and SIT withheld. */
5115: IF (p_report_qualifier in ('AR','ME')) -- To fix bug # 2668250

Line 5177: hr_utility.trace('Federal Advanced EIC after validation n Formatting '

5173: sp_out_2);
5174: IF p_exclude_from_output = 'Y' THEN
5175: l_exclude_from_output_chk := TRUE;
5176: END IF;
5177: hr_utility.trace('Federal Advanced EIC after validation n Formatting '
5178: ||r_input_17);
5179: hr_utility.trace('State Advanced EIC after validation n Formatting '
5180: ||r_input_34);
5181:

Line 5179: hr_utility.trace('State Advanced EIC after validation n Formatting '

5175: l_exclude_from_output_chk := TRUE;
5176: END IF;
5177: hr_utility.trace('Federal Advanced EIC after validation n Formatting '
5178: ||r_input_17);
5179: hr_utility.trace('State Advanced EIC after validation n Formatting '
5180: ||r_input_34);
5181:
5182: r_input_21 := lpad(' ',11);
5183: r_input_22 := lpad(' ',2);

Line 5822: hr_utility.trace('Company Locality Id '||p_input_33);

5818: r_input_30 := rpad(' ',1);
5819: END IF;
5820:
5821: IF p_report_qualifier = 'PA_PHILA' THEN
5822: hr_utility.trace('Company Locality Id '||p_input_33);
5823: r_input_33 := lpad(substr(NVL(p_input_33,' '),1,7),7);
5824: END IF;
5825:
5826: IF p_report_qualifier = 'OH_DAYTO' THEN

Line 5840: hr_utility.trace('Value of Stock Option Amount '||p_input_35);

5836: END IF ; */
5837: END IF ;
5838:
5839: /* Fix for Bug # 2680070 */
5840: hr_utility.trace('Value of Stock Option Amount '||p_input_35);
5841: IF (p_report_qualifier = 'MO_STLOU') THEN
5842: IF (to_number(NVL(p_input_35,'0')) > 0) THEN
5843: r_input_34 := 'STK'||lpad(NVL(p_input_35,'0'),11,'0')||lpad(' ',61);
5844: r_input_35 := lpad(' ',75);

Line 5850: hr_utility.trace('Value of r_input_34 '||r_input_34);

5846: r_input_34 := lpad(' ',3)||rpad('0',11,'0')||lpad(' ',61);
5847: r_input_35 := lpad(' ',75);
5848: END IF;
5849: END IF;
5850: hr_utility.trace('Value of r_input_34 '||r_input_34);
5851:
5852: l_last_field := lpad(' ',25);
5853:
5854: /* if p_report_qualifier = 'WI' THEN -- Bug 9065558

Line 5955: hr_utility.trace('Length of return value = '||to_char(length(return_value)));

5951: ||r_input_35
5952: ||l_last_field
5953: ||l_end_of_rec;
5954:
5955: hr_utility.trace('Length of return value = '||to_char(length(return_value)));
5956: --} End of formatting FLAT Type RS Record
5957: ELSIF p_input_40 = 'CSV' THEN
5958: --{ Start of formatting RS record in CSV format
5959: /* Bug 3180532

Line 6234: -- hr_utility.trace_on(null,'RI_W2') ;

6230: r_input_39 varchar2(300);
6231: r_input_41 varchar2(300); /* Bug# 13351713 */
6232:
6233: BEGIN
6234: -- hr_utility.trace_on(null,'RI_W2') ;
6235: hr_utility.trace('Formatting RT record for W2 reporting');
6236: hr_utility.trace('p_report_qualifier = '||p_report_qualifier);
6237: -- Initializing local variables with parameter value
6238: --{

Line 6235: hr_utility.trace('Formatting RT record for W2 reporting');

6231: r_input_41 varchar2(300); /* Bug# 13351713 */
6232:
6233: BEGIN
6234: -- hr_utility.trace_on(null,'RI_W2') ;
6235: hr_utility.trace('Formatting RT record for W2 reporting');
6236: hr_utility.trace('p_report_qualifier = '||p_report_qualifier);
6237: -- Initializing local variables with parameter value
6238: --{
6239: r_input_2 := p_input_2;

Line 6236: hr_utility.trace('p_report_qualifier = '||p_report_qualifier);

6232:
6233: BEGIN
6234: -- hr_utility.trace_on(null,'RI_W2') ;
6235: hr_utility.trace('Formatting RT record for W2 reporting');
6236: hr_utility.trace('p_report_qualifier = '||p_report_qualifier);
6237: -- Initializing local variables with parameter value
6238: --{
6239: r_input_2 := p_input_2;
6240: r_input_3 := p_input_3;

Line 6533: hr_utility.trace(parameter_record(i).p_parameter_name||' = '

6529: sp_out_2);
6530: IF p_exclude_from_output = 'Y' THEN
6531: l_exclude_from_output_chk := TRUE;
6532: END IF;
6533: hr_utility.trace(parameter_record(i).p_parameter_name||' = '
6534: ||parameter_record(i).p_output_value);
6535: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
6536: END LOOP;
6537:

Line 6535: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);

6531: l_exclude_from_output_chk := TRUE;
6532: END IF;
6533: hr_utility.trace(parameter_record(i).p_parameter_name||' = '
6534: ||parameter_record(i).p_output_value);
6535: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
6536: END LOOP;
6537:
6538: -- Validation Ends here
6539: --

Line 6589: hr_utility.trace('Within RI') ;

6585: ||parameter_record(2).p_output_value;
6586: --}
6587: ELSIF p_report_qualifier = 'RI' THEN
6588: --{
6589: hr_utility.trace('Within RI') ;
6590: return_value := 'RT'||l_input_2
6591: ||parameter_record(1).p_output_value
6592: ||parameter_record(2).p_output_value
6593: ||parameter_record(3).p_output_value

Line 6604: hr_utility.trace('Exiting RI') ;

6600: ||rpad(parameter_record(8).p_output_value,15)
6601: ||lpad(nvl(r_input_41,'0'),15,'0') /* Bug# 13351713 */
6602: ||lpad('0',45,'0')
6603: ||rpad(parameter_record(9).p_output_value,158) ;
6604: hr_utility.trace('Exiting RI') ;
6605: --}
6606: ELSIF p_report_qualifier = 'SC_SQWL' THEN /*2274381.*/
6607: return_value := 'RT'||l_input_2
6608: ||lpad(' ',503);

Line 6728: hr_utility.trace('B4 Calculating length') ;

6724: ||rpad(parameter_record(24).p_output_value,128) ;
6725:
6726: --}
6727: END IF;
6728: hr_utility.trace('B4 Calculating length') ;
6729: ret_str_len:=length(return_value);
6730: --}
6731: ELSIF p_input_40 = 'CSV' THEN
6732: --{

Line 6783: hr_utility.trace('Exiting RT') ;

6779: --}
6780: END IF; -- p_input_40 (i.e. FLAT, CSV)
6781: p_error := l_exclude_from_output_chk;
6782: ret_str_len:=length(return_value);
6783: hr_utility.trace('Exiting RT') ;
6784: return return_value;
6785: END format_W2_RT_record; -- End of Formatting RT record
6786: --
6787: -- Formatting RW record for W2 reporting

Line 6890: hr_utility.trace('Formatting RU Record');

6886: r_input_1 varchar2(300);
6887: r_input_2 varchar2(300);
6888: r_input_3 varchar2(300);
6889: BEGIN
6890: hr_utility.trace('Formatting RU Record');
6891: hr_utility.trace('Format Mode p_input_40 '||p_input_40);
6892: IF p_input_40='FLAT' THEN
6893: --{
6894: IF p_report_qualifier = 'PR' THEN -- Bug # 5668970

Line 6891: hr_utility.trace('Format Mode p_input_40 '||p_input_40);

6887: r_input_2 varchar2(300);
6888: r_input_3 varchar2(300);
6889: BEGIN
6890: hr_utility.trace('Formatting RU Record');
6891: hr_utility.trace('Format Mode p_input_40 '||p_input_40);
6892: IF p_input_40='FLAT' THEN
6893: --{
6894: IF p_report_qualifier = 'PR' THEN -- Bug # 5668970
6895: r_input_6 := rpad('0',15,'0');

Line 6959: --hr_utility.trace('Wages in Ru record: '||p_input_21);

6955: parameter_record(19).p_parameter_name:= 'Designated Roth Contributions under a Governmental Section 457(b) plan';
6956: parameter_record(19).p_parameter_value := p_input_22;
6957:
6958:
6959: --hr_utility.trace('Wages in Ru record: '||p_input_21);
6960: --
6961: -- Validation and Formatting for above fields done in this loop
6962: FOR i in 1..19 -- Bug 13255564
6963: LOOP

Line 6984: hr_utility.trace(parameter_record(i).p_parameter_name||' = '

6980: IF p_exclude_from_output = 'Y' THEN
6981: l_exclude_from_output_chk := TRUE;
6982: END IF;
6983:
6984: hr_utility.trace(parameter_record(i).p_parameter_name||' = '
6985: ||parameter_record(i).p_output_value);
6986: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
6987: END LOOP;
6988: -- Formatting RU record for format mode FLAT

Line 6986: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);

6982: END IF;
6983:
6984: hr_utility.trace(parameter_record(i).p_parameter_name||' = '
6985: ||parameter_record(i).p_output_value);
6986: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
6987: END LOOP;
6988: -- Formatting RU record for format mode FLAT
6989: -- formatting Total no of record
6990: l_input_2 := lpad(substr(nvl(p_input_2,'0'),1,7),7,0);

Line 6997: --hr_utility.trace('Wages in Ru record2: '||r_input_2);

6993: --BUG 10419148
6994: r_input_1:=parameter_record(17).p_output_value;
6995: r_input_2:=rpad(parameter_record(18).p_output_value,225);
6996:
6997: --hr_utility.trace('Wages in Ru record2: '||r_input_2);
6998: --hr_utility.trace('Wages in Ru record3: '||parameter_record(18).p_output_value);
6999:
7000: return_value:='RU'||l_input_2
7001: /* ||parameter_record(1).p_output_value */

Line 6998: --hr_utility.trace('Wages in Ru record3: '||parameter_record(18).p_output_value);

6994: r_input_1:=parameter_record(17).p_output_value;
6995: r_input_2:=rpad(parameter_record(18).p_output_value,225);
6996:
6997: --hr_utility.trace('Wages in Ru record2: '||r_input_2);
6998: --hr_utility.trace('Wages in Ru record3: '||parameter_record(18).p_output_value);
6999:
7000: return_value:='RU'||l_input_2
7001: /* ||parameter_record(1).p_output_value */
7002: ||rpad('0',15,'0') /* 6644795 */

Line 7132: hr_utility.trace('Formatting RF Record');

7128: l_taxes varchar2(100);
7129: sp_out_1 varchar2(100);
7130: sp_out_2 varchar2(100);
7131: BEGIN
7132: hr_utility.trace('Formatting RF Record');
7133: hr_utility.trace('Format Mode p_input_40 '||p_format_mode);
7134: hr_utility.trace('Report Qualifier before Formatting RF Record '
7135: ||p_report_qualifier);
7136: IF ((p_report_qualifier = 'PA_PHILA') OR -- Bug # 2680189

Line 7133: hr_utility.trace('Format Mode p_input_40 '||p_format_mode);

7129: sp_out_1 varchar2(100);
7130: sp_out_2 varchar2(100);
7131: BEGIN
7132: hr_utility.trace('Formatting RF Record');
7133: hr_utility.trace('Format Mode p_input_40 '||p_format_mode);
7134: hr_utility.trace('Report Qualifier before Formatting RF Record '
7135: ||p_report_qualifier);
7136: IF ((p_report_qualifier = 'PA_PHILA') OR -- Bug # 2680189
7137: (p_report_qualifier = 'CO')) THEN -- Bug # 2813555

Line 7134: hr_utility.trace('Report Qualifier before Formatting RF Record '

7130: sp_out_2 varchar2(100);
7131: BEGIN
7132: hr_utility.trace('Formatting RF Record');
7133: hr_utility.trace('Format Mode p_input_40 '||p_format_mode);
7134: hr_utility.trace('Report Qualifier before Formatting RF Record '
7135: ||p_report_qualifier);
7136: IF ((p_report_qualifier = 'PA_PHILA') OR -- Bug # 2680189
7137: (p_report_qualifier = 'CO')) THEN -- Bug # 2813555
7138: --{