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_MMREF_REPORTING dependencies on PAY_CORE_UTILS

Line 503: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

499: CLOSE c_tax_ein;
500: l_package_error_status := 'Y';
501: hr_utility.trace('A_TAX_UNIT_EMPLOYER_IDENTIFICATION_NUMBER missing ');
502: message_text := 'EIN ID missing ';
503: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
504: pay_core_utils.push_token('record_name',message_preprocess);
505: pay_core_utils.push_token('description',message_text);
506: hr_utility.raise_error;
507: ELSE

Line 504: pay_core_utils.push_token('record_name',message_preprocess);

500: l_package_error_status := 'Y';
501: hr_utility.trace('A_TAX_UNIT_EMPLOYER_IDENTIFICATION_NUMBER missing ');
502: message_text := 'EIN ID missing ';
503: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
504: pay_core_utils.push_token('record_name',message_preprocess);
505: pay_core_utils.push_token('description',message_text);
506: hr_utility.raise_error;
507: ELSE
508: CLOSE c_tax_ein;

Line 505: pay_core_utils.push_token('description',message_text);

501: hr_utility.trace('A_TAX_UNIT_EMPLOYER_IDENTIFICATION_NUMBER missing ');
502: message_text := 'EIN ID missing ';
503: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
504: pay_core_utils.push_token('record_name',message_preprocess);
505: pay_core_utils.push_token('description',message_text);
506: hr_utility.raise_error;
507: ELSE
508: CLOSE c_tax_ein;
509: END IF;

Line 521: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

517: l_package_error_status := 'Y';
518: /* message to user - Database item missing */
519: hr_utility.trace('Database item for balacne missing ');
520: message_text := '-Database item missing ';
521: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
522: pay_core_utils.push_token('record_name',message_preprocess);
523: pay_core_utils.push_token('description',message_text);
524: hr_utility.raise_error;
525: ELSE

Line 522: pay_core_utils.push_token('record_name',message_preprocess);

518: /* message to user - Database item missing */
519: hr_utility.trace('Database item for balacne missing ');
520: message_text := '-Database item missing ';
521: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
522: pay_core_utils.push_token('record_name',message_preprocess);
523: pay_core_utils.push_token('description',message_text);
524: hr_utility.raise_error;
525: ELSE
526: CLOSE c_user_entity_id_of_bal;

Line 523: pay_core_utils.push_token('description',message_text);

519: hr_utility.trace('Database item for balacne missing ');
520: message_text := '-Database item missing ';
521: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
522: pay_core_utils.push_token('record_name',message_preprocess);
523: pay_core_utils.push_token('description',message_text);
524: hr_utility.raise_error;
525: ELSE
526: CLOSE c_user_entity_id_of_bal;
527: END IF;

Line 535: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

531: IF c_context_tax_unit_id%NOTFOUND THEN
532: CLOSE c_context_tax_unit_id;
533: /* message to user -- unable to find the context_id for tax_unit_id */
534: message_text := 'Context_id value for tax_unit_id missing';
535: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
536: pay_core_utils.push_token('record_name',message_preprocess);
537: pay_core_utils.push_token('description',message_text);
538: hr_utility.raise_error;
539: ELSE

Line 536: pay_core_utils.push_token('record_name',message_preprocess);

532: CLOSE c_context_tax_unit_id;
533: /* message to user -- unable to find the context_id for tax_unit_id */
534: message_text := 'Context_id value for tax_unit_id missing';
535: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
536: pay_core_utils.push_token('record_name',message_preprocess);
537: pay_core_utils.push_token('description',message_text);
538: hr_utility.raise_error;
539: ELSE
540: CLOSE c_context_tax_unit_id;

Line 537: pay_core_utils.push_token('description',message_text);

533: /* message to user -- unable to find the context_id for tax_unit_id */
534: message_text := 'Context_id value for tax_unit_id missing';
535: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
536: pay_core_utils.push_token('record_name',message_preprocess);
537: pay_core_utils.push_token('description',message_text);
538: hr_utility.raise_error;
539: ELSE
540: CLOSE c_context_tax_unit_id;
541: END IF;

Line 551: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

547: /* message to User -- Unable to find to context_id for jurisdiction */
548:
549: message_text := 'Context_id value for jurisdiction missing';
550: hr_utility.trace('Contxt_id value for jurisdction_id missing');
551: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
552: pay_core_utils.push_token('record_name',message_preprocess);
553: pay_core_utils.push_token('description',message_text);
554: hr_utility.raise_error;
555: ELSE

Line 552: pay_core_utils.push_token('record_name',message_preprocess);

548:
549: message_text := 'Context_id value for jurisdiction missing';
550: hr_utility.trace('Contxt_id value for jurisdction_id missing');
551: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
552: pay_core_utils.push_token('record_name',message_preprocess);
553: pay_core_utils.push_token('description',message_text);
554: hr_utility.raise_error;
555: ELSE
556: CLOSE c_context_jurisdiction;

Line 553: pay_core_utils.push_token('description',message_text);

549: message_text := 'Context_id value for jurisdiction missing';
550: hr_utility.trace('Contxt_id value for jurisdction_id missing');
551: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
552: pay_core_utils.push_token('record_name',message_preprocess);
553: pay_core_utils.push_token('description',message_text);
554: hr_utility.raise_error;
555: ELSE
556: CLOSE c_context_jurisdiction;
557: eND IF;

Line 567: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

563: IF c_transmitter%NOTFOUND THEN
564: CLOSE c_transmitter;
565: /* message to user -- transmitter has not been defined for the gre */
566: message_text := 'Transmitter Not denfined';
567: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
568: pay_core_utils.push_token('record_name',message_preprocess);
569: pay_core_utils.push_token('description',message_text);
570: hr_utility.raise_error;
571: ELSE

Line 568: pay_core_utils.push_token('record_name',message_preprocess);

564: CLOSE c_transmitter;
565: /* message to user -- transmitter has not been defined for the gre */
566: message_text := 'Transmitter Not denfined';
567: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
568: pay_core_utils.push_token('record_name',message_preprocess);
569: pay_core_utils.push_token('description',message_text);
570: hr_utility.raise_error;
571: ELSE
572: CLOSE c_transmitter;

Line 569: pay_core_utils.push_token('description',message_text);

565: /* message to user -- transmitter has not been defined for the gre */
566: message_text := 'Transmitter Not denfined';
567: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
568: pay_core_utils.push_token('record_name',message_preprocess);
569: pay_core_utils.push_token('description',message_text);
570: hr_utility.raise_error;
571: ELSE
572: CLOSE c_transmitter;
573: END IF;

Line 591: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

587: CLOSE c_gre_payroll_action;
588: /* message to user -- Transmitter has not been archived */
589: message_text := 'Transmitter not Archived';
590: hr_utility.trace('Transmitter has not been archived');
591: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
592: pay_core_utils.push_token('record_name',message_preprocess);
593: pay_core_utils.push_token('description',message_text);
594: -- hr_utility.raise_error;
595: END IF;

Line 592: pay_core_utils.push_token('record_name',message_preprocess);

588: /* message to user -- Transmitter has not been archived */
589: message_text := 'Transmitter not Archived';
590: hr_utility.trace('Transmitter has not been archived');
591: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
592: pay_core_utils.push_token('record_name',message_preprocess);
593: pay_core_utils.push_token('description',message_text);
594: -- hr_utility.raise_error;
595: END IF;
596: CLOSE c_gre_payroll_action;

Line 593: pay_core_utils.push_token('description',message_text);

589: message_text := 'Transmitter not Archived';
590: hr_utility.trace('Transmitter has not been archived');
591: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
592: pay_core_utils.push_token('record_name',message_preprocess);
593: pay_core_utils.push_token('description',message_text);
594: -- hr_utility.raise_error;
595: END IF;
596: CLOSE c_gre_payroll_action;
597:

Line 624: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

620: INTO l_asg_errored;
621:
622: IF c_arch_errored_asg%FOUND THEN
623: message_text := 'Assignment in Error Conditon for GRE:= ' || to_char(l_gre);
624: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
625: pay_core_utils.push_token('record_name',message_preprocess);
626: pay_core_utils.push_token('description',message_text);
627: --Some of the assignments have Errored
628: l_package_error_status := 'Y';

Line 625: pay_core_utils.push_token('record_name',message_preprocess);

621:
622: IF c_arch_errored_asg%FOUND THEN
623: message_text := 'Assignment in Error Conditon for GRE:= ' || to_char(l_gre);
624: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
625: pay_core_utils.push_token('record_name',message_preprocess);
626: pay_core_utils.push_token('description',message_text);
627: --Some of the assignments have Errored
628: l_package_error_status := 'Y';
629: /* message to user -- assignment has errored out */

Line 626: pay_core_utils.push_token('description',message_text);

622: IF c_arch_errored_asg%FOUND THEN
623: message_text := 'Assignment in Error Conditon for GRE:= ' || to_char(l_gre);
624: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
625: pay_core_utils.push_token('record_name',message_preprocess);
626: pay_core_utils.push_token('description',message_text);
627: --Some of the assignments have Errored
628: l_package_error_status := 'Y';
629: /* message to user -- assignment has errored out */
630: --

Line 642: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

638: FETCH c_arch_retry_pending INTO l_asg_retry_pend;
639: IF c_arch_retry_pending%FOUND THEN
640: --Some of the assignments have been marked for retry
641: message_text := 'Assignment Marked for Retry: GRE_ID := ' || to_char(l_gre);
642: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
643: pay_core_utils.push_token('record_name',message_preprocess);
644: pay_core_utils.push_token('description',message_text);
645: l_package_error_status := 'Y';
646: -- hr_utility.raise_error;

Line 643: pay_core_utils.push_token('record_name',message_preprocess);

639: IF c_arch_retry_pending%FOUND THEN
640: --Some of the assignments have been marked for retry
641: message_text := 'Assignment Marked for Retry: GRE_ID := ' || to_char(l_gre);
642: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
643: pay_core_utils.push_token('record_name',message_preprocess);
644: pay_core_utils.push_token('description',message_text);
645: l_package_error_status := 'Y';
646: -- hr_utility.raise_error;
647:

Line 644: pay_core_utils.push_token('description',message_text);

640: --Some of the assignments have been marked for retry
641: message_text := 'Assignment Marked for Retry: GRE_ID := ' || to_char(l_gre);
642: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
643: pay_core_utils.push_token('record_name',message_preprocess);
644: pay_core_utils.push_token('description',message_text);
645: l_package_error_status := 'Y';
646: -- hr_utility.raise_error;
647:
648: END IF;

Line 683: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

679: l_ein_result := check_er_data(l_payroll_action_id,l_gre);
680:
681: IF l_ein_result = 'N'THEN
682: message_text := 'EIN for GRE:= ' || to_char(l_gre) || 'Not Set';
683: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
684: pay_core_utils.push_token('record_name',message_preprocess);
685: pay_core_utils.push_token('description',message_text);
686: l_package_error_status := 'Y';
687: END IF;

Line 684: pay_core_utils.push_token('record_name',message_preprocess);

680:
681: IF l_ein_result = 'N'THEN
682: message_text := 'EIN for GRE:= ' || to_char(l_gre) || 'Not Set';
683: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
684: pay_core_utils.push_token('record_name',message_preprocess);
685: pay_core_utils.push_token('description',message_text);
686: l_package_error_status := 'Y';
687: END IF;
688: ELSE

Line 685: pay_core_utils.push_token('description',message_text);

681: IF l_ein_result = 'N'THEN
682: message_text := 'EIN for GRE:= ' || to_char(l_gre) || 'Not Set';
683: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
684: pay_core_utils.push_token('record_name',message_preprocess);
685: pay_core_utils.push_token('description',message_text);
686: l_package_error_status := 'Y';
687: END IF;
688: ELSE
689: /* If Report type is not Fed so state */

Line 698: -- pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

694: -- hr_utility.trace('State Tax Rules not Found ');
695: -- /* state Tax Rules have not been Defined */
696: -- message_text := 'State Tax Rules not Defind for GRE '
697: -- || to_char(l_gre) || ' for ' || P_state_abbrev;
698: -- pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
699: -- pay_core_utils.push_token('record_name',message_preprocess);
700: -- pay_core_utils.push_token('description',message_text);
701: -- l_package_error_status := 'Y';
702: -- END IF; /* Missing State Tax Rules */

Line 699: -- pay_core_utils.push_token('record_name',message_preprocess);

695: -- /* state Tax Rules have not been Defined */
696: -- message_text := 'State Tax Rules not Defind for GRE '
697: -- || to_char(l_gre) || ' for ' || P_state_abbrev;
698: -- pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
699: -- pay_core_utils.push_token('record_name',message_preprocess);
700: -- pay_core_utils.push_token('description',message_text);
701: -- l_package_error_status := 'Y';
702: -- END IF; /* Missing State Tax Rules */
703: --

Line 700: -- pay_core_utils.push_token('description',message_text);

696: -- message_text := 'State Tax Rules not Defind for GRE '
697: -- || to_char(l_gre) || ' for ' || P_state_abbrev;
698: -- pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
699: -- pay_core_utils.push_token('record_name',message_preprocess);
700: -- pay_core_utils.push_token('description',message_text);
701: -- l_package_error_status := 'Y';
702: -- END IF; /* Missing State Tax Rules */
703: --
704: -- close c_chk_archive_state_code;

Line 715: -- pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

711: /* EIN check Failed */
712: -- IF l_ein_result = 'N'THEN
713: -- hr_utility.trace('ID missing in State Tax Rules' || to_char(l_gre));
714: -- message_text := 'Missing ID in State Tax Rules for GRE:= '|| to_char(l_gre);
715: -- pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
716: -- pay_core_utils.push_token('record_name',message_preprocess);
717: -- pay_core_utils.push_token('description',message_text);
718: -- l_package_error_status := 'Y';
719: -- END IF;

Line 716: -- pay_core_utils.push_token('record_name',message_preprocess);

712: -- IF l_ein_result = 'N'THEN
713: -- hr_utility.trace('ID missing in State Tax Rules' || to_char(l_gre));
714: -- message_text := 'Missing ID in State Tax Rules for GRE:= '|| to_char(l_gre);
715: -- pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
716: -- pay_core_utils.push_token('record_name',message_preprocess);
717: -- pay_core_utils.push_token('description',message_text);
718: -- l_package_error_status := 'Y';
719: -- END IF;
720: END IF;

Line 717: -- pay_core_utils.push_token('description',message_text);

713: -- hr_utility.trace('ID missing in State Tax Rules' || to_char(l_gre));
714: -- message_text := 'Missing ID in State Tax Rules for GRE:= '|| to_char(l_gre);
715: -- pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
716: -- pay_core_utils.push_token('record_name',message_preprocess);
717: -- pay_core_utils.push_token('description',message_text);
718: -- l_package_error_status := 'Y';
719: -- END IF;
720: END IF;
721:

Line 818: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

814: hr_utility.trace('Archive_Gre ' || to_char(l_gre));
815: -- Person Found with Balance for given GRE
816: message_text := 'GRE_ID := ' || to_char(l_gre)
817: || ' has People with Balnace > 0';
818: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
819: pay_core_utils.push_token('record_name',message_preprocess);
820: pay_core_utils.push_token('description',message_text);
821:
822: message_text := 'Please Archive GRE With ID := ' || to_char(l_gre) ;

Line 819: pay_core_utils.push_token('record_name',message_preprocess);

815: -- Person Found with Balance for given GRE
816: message_text := 'GRE_ID := ' || to_char(l_gre)
817: || ' has People with Balnace > 0';
818: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
819: pay_core_utils.push_token('record_name',message_preprocess);
820: pay_core_utils.push_token('description',message_text);
821:
822: message_text := 'Please Archive GRE With ID := ' || to_char(l_gre) ;
823: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

Line 820: pay_core_utils.push_token('description',message_text);

816: message_text := 'GRE_ID := ' || to_char(l_gre)
817: || ' has People with Balnace > 0';
818: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
819: pay_core_utils.push_token('record_name',message_preprocess);
820: pay_core_utils.push_token('description',message_text);
821:
822: message_text := 'Please Archive GRE With ID := ' || to_char(l_gre) ;
823: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
824: pay_core_utils.push_token('record_name',message_preprocess);

Line 823: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

819: pay_core_utils.push_token('record_name',message_preprocess);
820: pay_core_utils.push_token('description',message_text);
821:
822: message_text := 'Please Archive GRE With ID := ' || to_char(l_gre) ;
823: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
824: pay_core_utils.push_token('record_name',message_preprocess);
825: l_package_error_status := 'Y';
826: END IF;
827: l_balance_exists := 0;

Line 824: pay_core_utils.push_token('record_name',message_preprocess);

820: pay_core_utils.push_token('description',message_text);
821:
822: message_text := 'Please Archive GRE With ID := ' || to_char(l_gre) ;
823: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
824: pay_core_utils.push_token('record_name',message_preprocess);
825: l_package_error_status := 'Y';
826: END IF;
827: l_balance_exists := 0;
828:

Line 844: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA_WARNING','P');

840:
841: /* A warning is logged if GRE is not archived Buug # 3069840 */
842: l_package_error_status := 'N';
843: message_text := 'Please Archive GRE With ID := ' || to_char(l_gre) ;
844: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA_WARNING','P');
845: pay_core_utils.push_token('record_name',message_preprocess);
846: pay_core_utils.push_token('description',message_text);
847:
848: END IF; --end if for checking of person balance if the GRE has

Line 845: pay_core_utils.push_token('record_name',message_preprocess);

841: /* A warning is logged if GRE is not archived Buug # 3069840 */
842: l_package_error_status := 'N';
843: message_text := 'Please Archive GRE With ID := ' || to_char(l_gre) ;
844: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA_WARNING','P');
845: pay_core_utils.push_token('record_name',message_preprocess);
846: pay_core_utils.push_token('description',message_text);
847:
848: END IF; --end if for checking of person balance if the GRE has
849: --not been archived.

Line 846: pay_core_utils.push_token('description',message_text);

842: l_package_error_status := 'N';
843: message_text := 'Please Archive GRE With ID := ' || to_char(l_gre) ;
844: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA_WARNING','P');
845: pay_core_utils.push_token('record_name',message_preprocess);
846: pay_core_utils.push_token('description',message_text);
847:
848: END IF; --end if for checking of person balance if the GRE has
849: --not been archived.
850:

Line 858: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

854:
855: IF l_package_error_status = 'Y' THEN
856: hr_utility.trace('Error Condition Found');
857: message_text := 'Error Condition detected ' ;
858: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
859: pay_core_utils.push_token('record_name',message_preprocess);
860: pay_core_utils.push_token('description',message_text);
861:
862: message_text := 'Pay Message line and log have more Details' ;

Line 859: pay_core_utils.push_token('record_name',message_preprocess);

855: IF l_package_error_status = 'Y' THEN
856: hr_utility.trace('Error Condition Found');
857: message_text := 'Error Condition detected ' ;
858: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
859: pay_core_utils.push_token('record_name',message_preprocess);
860: pay_core_utils.push_token('description',message_text);
861:
862: message_text := 'Pay Message line and log have more Details' ;
863: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

Line 860: pay_core_utils.push_token('description',message_text);

856: hr_utility.trace('Error Condition Found');
857: message_text := 'Error Condition detected ' ;
858: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
859: pay_core_utils.push_token('record_name',message_preprocess);
860: pay_core_utils.push_token('description',message_text);
861:
862: message_text := 'Pay Message line and log have more Details' ;
863: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
864: pay_core_utils.push_token('record_name',message_preprocess);

Line 863: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

859: pay_core_utils.push_token('record_name',message_preprocess);
860: pay_core_utils.push_token('description',message_text);
861:
862: message_text := 'Pay Message line and log have more Details' ;
863: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
864: pay_core_utils.push_token('record_name',message_preprocess);
865: pay_core_utils.push_token('description',message_text);
866: hr_utility.raise_error;
867: END IF;

Line 864: pay_core_utils.push_token('record_name',message_preprocess);

860: pay_core_utils.push_token('description',message_text);
861:
862: message_text := 'Pay Message line and log have more Details' ;
863: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
864: pay_core_utils.push_token('record_name',message_preprocess);
865: pay_core_utils.push_token('description',message_text);
866: hr_utility.raise_error;
867: END IF;
868:

Line 865: pay_core_utils.push_token('description',message_text);

861:
862: message_text := 'Pay Message line and log have more Details' ;
863: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
864: pay_core_utils.push_token('record_name',message_preprocess);
865: pay_core_utils.push_token('description',message_text);
866: hr_utility.raise_error;
867: END IF;
868:
869: IF l_no_of_gres_picked = 0 THEN

Line 874: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

870: --It means that no archived GRE was
871: --found for the Organization. This is an error.
872:
873: message_text := 'No GRE was picked for Magnetic Tape';
874: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
875: pay_core_utils.push_token('record_name',message_preprocess);
876: pay_core_utils.push_token('description',message_text);
877: hr_utility.raise_error;
878: END IF;

Line 875: pay_core_utils.push_token('record_name',message_preprocess);

871: --found for the Organization. This is an error.
872:
873: message_text := 'No GRE was picked for Magnetic Tape';
874: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
875: pay_core_utils.push_token('record_name',message_preprocess);
876: pay_core_utils.push_token('description',message_text);
877: hr_utility.raise_error;
878: END IF;
879:

Line 876: pay_core_utils.push_token('description',message_text);

872:
873: message_text := 'No GRE was picked for Magnetic Tape';
874: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
875: pay_core_utils.push_token('record_name',message_preprocess);
876: pay_core_utils.push_token('description',message_text);
877: hr_utility.raise_error;
878: END IF;
879:
880: RETURN TRUE;

Line 2389: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

2385:
2386: IF l_ein_status = 'N' THEN
2387: message_preprocess := 'Pre-Process Check-';
2388: message_text := 'EIN or Tax Unit Name Missing ';
2389: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
2390: pay_core_utils.push_token('record_name',message_preprocess);
2391: pay_core_utils.push_token('description',message_text);
2392: END IF;
2393:

Line 2390: pay_core_utils.push_token('record_name',message_preprocess);

2386: IF l_ein_status = 'N' THEN
2387: message_preprocess := 'Pre-Process Check-';
2388: message_text := 'EIN or Tax Unit Name Missing ';
2389: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
2390: pay_core_utils.push_token('record_name',message_preprocess);
2391: pay_core_utils.push_token('description',message_text);
2392: END IF;
2393:
2394: return l_ein_status ;

Line 2391: pay_core_utils.push_token('description',message_text);

2387: message_preprocess := 'Pre-Process Check-';
2388: message_text := 'EIN or Tax Unit Name Missing ';
2389: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
2390: pay_core_utils.push_token('record_name',message_preprocess);
2391: pay_core_utils.push_token('description',message_text);
2392: END IF;
2393:
2394: return l_ein_status ;
2395:

Line 2573: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

2569: open c_get_pr_control_num(C1.unit_id);
2570: fetch c_get_pr_control_num INTO l_control_number;
2571: if c_get_pr_control_num%notfound then
2572: l_message_text := 'ERROR: PR 499R Starting Control Number not defined';
2573: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
2574: pay_core_utils.push_token('record_name',l_message_preprocess);
2575: pay_core_utils.push_token('description',l_message_text);
2576: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
2577: l_control_num_flag := 'N';

Line 2574: pay_core_utils.push_token('record_name',l_message_preprocess);

2570: fetch c_get_pr_control_num INTO l_control_number;
2571: if c_get_pr_control_num%notfound then
2572: l_message_text := 'ERROR: PR 499R Starting Control Number not defined';
2573: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
2574: pay_core_utils.push_token('record_name',l_message_preprocess);
2575: pay_core_utils.push_token('description',l_message_text);
2576: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
2577: l_control_num_flag := 'N';
2578: else

Line 2575: pay_core_utils.push_token('description',l_message_text);

2571: if c_get_pr_control_num%notfound then
2572: l_message_text := 'ERROR: PR 499R Starting Control Number not defined';
2573: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
2574: pay_core_utils.push_token('record_name',l_message_preprocess);
2575: pay_core_utils.push_token('description',l_message_text);
2576: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
2577: l_control_num_flag := 'N';
2578: else
2579: if (l_control_number is NULL or l_control_number = 0) then

Line 2582: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

2578: else
2579: if (l_control_number is NULL or l_control_number = 0) then
2580: l_message_text := 'ERROR:PR 499R Starting control Number is NULL';
2581: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
2582: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
2583: pay_core_utils.push_token('record_name',l_message_preprocess);
2584: pay_core_utils.push_token('description',l_message_text);
2585: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
2586: l_control_num_flag := 'N';

Line 2583: pay_core_utils.push_token('record_name',l_message_preprocess);

2579: if (l_control_number is NULL or l_control_number = 0) then
2580: l_message_text := 'ERROR:PR 499R Starting control Number is NULL';
2581: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
2582: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
2583: pay_core_utils.push_token('record_name',l_message_preprocess);
2584: pay_core_utils.push_token('description',l_message_text);
2585: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
2586: l_control_num_flag := 'N';
2587: end if;

Line 2584: pay_core_utils.push_token('description',l_message_text);

2580: l_message_text := 'ERROR:PR 499R Starting control Number is NULL';
2581: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
2582: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
2583: pay_core_utils.push_token('record_name',l_message_preprocess);
2584: pay_core_utils.push_token('description',l_message_text);
2585: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
2586: l_control_num_flag := 'N';
2587: end if;
2588: end if;

Line 2598: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

2594: l_message_text := to_char(c1.unit_id) || 'Payroll_action_id ' || to_char(c1.payroll_action);
2595: hr_utility.trace(l_message_preprocess || ' ' || l_message_text) ;
2596: if c_sit_check%notfound then
2597: l_message_text := 'ERROR: Missing State Tax Rules For State of :' || p_transfer_state;
2598: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
2599: pay_core_utils.push_token('record_name',l_message_preprocess);
2600: pay_core_utils.push_token('description',l_message_text);
2601: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
2602: l_flag := 'N';

Line 2599: pay_core_utils.push_token('record_name',l_message_preprocess);

2595: hr_utility.trace(l_message_preprocess || ' ' || l_message_text) ;
2596: if c_sit_check%notfound then
2597: l_message_text := 'ERROR: Missing State Tax Rules For State of :' || p_transfer_state;
2598: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
2599: pay_core_utils.push_token('record_name',l_message_preprocess);
2600: pay_core_utils.push_token('description',l_message_text);
2601: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
2602: l_flag := 'N';
2603: close c_sit_check;

Line 2600: pay_core_utils.push_token('description',l_message_text);

2596: if c_sit_check%notfound then
2597: l_message_text := 'ERROR: Missing State Tax Rules For State of :' || p_transfer_state;
2598: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
2599: pay_core_utils.push_token('record_name',l_message_preprocess);
2600: pay_core_utils.push_token('description',l_message_text);
2601: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
2602: l_flag := 'N';
2603: close c_sit_check;
2604: else

Line 2609: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

2605: if l_info IS NULL THEN
2606: l_flag := 'N';
2607: l_message_text := 'ERROR: NULL EIN For State of ' || p_transfer_state;
2608: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
2609: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
2610: pay_core_utils.push_token('record_name',l_message_preprocess);
2611: pay_core_utils.push_token('description',l_message_text);
2612: end if ;
2613: close c_sit_check;

Line 2610: pay_core_utils.push_token('record_name',l_message_preprocess);

2606: l_flag := 'N';
2607: l_message_text := 'ERROR: NULL EIN For State of ' || p_transfer_state;
2608: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
2609: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
2610: pay_core_utils.push_token('record_name',l_message_preprocess);
2611: pay_core_utils.push_token('description',l_message_text);
2612: end if ;
2613: close c_sit_check;
2614: end if;

Line 2611: pay_core_utils.push_token('description',l_message_text);

2607: l_message_text := 'ERROR: NULL EIN For State of ' || p_transfer_state;
2608: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
2609: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
2610: pay_core_utils.push_token('record_name',l_message_preprocess);
2611: pay_core_utils.push_token('description',l_message_text);
2612: end if ;
2613: close c_sit_check;
2614: end if;
2615: END loop;

Line 2618: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

2614: end if;
2615: END loop;
2616: IF l_flag = 'N' OR l_control_num_flag = 'N' THEN
2617: l_message_text := 'Set your W2 Reporting Rules or State Tax Rules';
2618: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
2619: pay_core_utils.push_token('record_name',l_message_preprocess);
2620: pay_core_utils.push_token('description',l_message_text);
2621: hr_utility.raise_error;
2622: return 'N';

Line 2619: pay_core_utils.push_token('record_name',l_message_preprocess);

2615: END loop;
2616: IF l_flag = 'N' OR l_control_num_flag = 'N' THEN
2617: l_message_text := 'Set your W2 Reporting Rules or State Tax Rules';
2618: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
2619: pay_core_utils.push_token('record_name',l_message_preprocess);
2620: pay_core_utils.push_token('description',l_message_text);
2621: hr_utility.raise_error;
2622: return 'N';
2623: END IF;

Line 2620: pay_core_utils.push_token('description',l_message_text);

2616: IF l_flag = 'N' OR l_control_num_flag = 'N' THEN
2617: l_message_text := 'Set your W2 Reporting Rules or State Tax Rules';
2618: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
2619: pay_core_utils.push_token('record_name',l_message_preprocess);
2620: pay_core_utils.push_token('description',l_message_text);
2621: hr_utility.raise_error;
2622: return 'N';
2623: END IF;
2624: return 'Y';

Line 2629: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

2625: EXCEPTION
2626: WHEN OTHERS THEN
2627: l_message_preprocess := 'Exception ';
2628: l_message_text := 'Set your W2 Reporting Rules or State Tax Rules';
2629: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
2630: pay_core_utils.push_token('record_name',l_message_preprocess);
2631: pay_core_utils.push_token('description',l_message_text);
2632: u_message_text := 'Set your W2 Reporting Rules or State Tax Rules';
2633: hr_utility.set_message(801, 'HR_7998_ALL_EXEMACRO_MESSAGE');

Line 2630: pay_core_utils.push_token('record_name',l_message_preprocess);

2626: WHEN OTHERS THEN
2627: l_message_preprocess := 'Exception ';
2628: l_message_text := 'Set your W2 Reporting Rules or State Tax Rules';
2629: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
2630: pay_core_utils.push_token('record_name',l_message_preprocess);
2631: pay_core_utils.push_token('description',l_message_text);
2632: u_message_text := 'Set your W2 Reporting Rules or State Tax Rules';
2633: hr_utility.set_message(801, 'HR_7998_ALL_EXEMACRO_MESSAGE');
2634: hr_utility.set_message_token('MESSAGE', u_message_text);

Line 2631: pay_core_utils.push_token('description',l_message_text);

2627: l_message_preprocess := 'Exception ';
2628: l_message_text := 'Set your W2 Reporting Rules or State Tax Rules';
2629: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
2630: pay_core_utils.push_token('record_name',l_message_preprocess);
2631: pay_core_utils.push_token('description',l_message_text);
2632: u_message_text := 'Set your W2 Reporting Rules or State Tax Rules';
2633: hr_utility.set_message(801, 'HR_7998_ALL_EXEMACRO_MESSAGE');
2634: hr_utility.set_message_token('MESSAGE', u_message_text);
2635: hr_utility.raise_error;