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

[Home] [Help]

APPS.PAY_US_MMREF_REPORTING dependencies on PAY_CORE_UTILS

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

484: CLOSE c_tax_ein;
485: l_package_error_status := 'Y';
486: hr_utility.trace('A_TAX_UNIT_EMPLOYER_IDENTIFICATION_NUMBER missing ');
487: message_text := 'EIN ID missing ';
488: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
489: pay_core_utils.push_token('record_name',message_preprocess);
490: pay_core_utils.push_token('description',message_text);
491: hr_utility.raise_error;
492: ELSE

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

485: l_package_error_status := 'Y';
486: hr_utility.trace('A_TAX_UNIT_EMPLOYER_IDENTIFICATION_NUMBER missing ');
487: message_text := 'EIN ID missing ';
488: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
489: pay_core_utils.push_token('record_name',message_preprocess);
490: pay_core_utils.push_token('description',message_text);
491: hr_utility.raise_error;
492: ELSE
493: CLOSE c_tax_ein;

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

486: hr_utility.trace('A_TAX_UNIT_EMPLOYER_IDENTIFICATION_NUMBER missing ');
487: message_text := 'EIN ID missing ';
488: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
489: pay_core_utils.push_token('record_name',message_preprocess);
490: pay_core_utils.push_token('description',message_text);
491: hr_utility.raise_error;
492: ELSE
493: CLOSE c_tax_ein;
494: END IF;

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

502: l_package_error_status := 'Y';
503: /* message to user - Database item missing */
504: hr_utility.trace('Database item for balacne missing ');
505: message_text := '-Database item missing ';
506: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
507: pay_core_utils.push_token('record_name',message_preprocess);
508: pay_core_utils.push_token('description',message_text);
509: hr_utility.raise_error;
510: ELSE

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

503: /* message to user - Database item missing */
504: hr_utility.trace('Database item for balacne missing ');
505: message_text := '-Database item missing ';
506: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
507: pay_core_utils.push_token('record_name',message_preprocess);
508: pay_core_utils.push_token('description',message_text);
509: hr_utility.raise_error;
510: ELSE
511: CLOSE c_user_entity_id_of_bal;

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

504: hr_utility.trace('Database item for balacne missing ');
505: message_text := '-Database item missing ';
506: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
507: pay_core_utils.push_token('record_name',message_preprocess);
508: pay_core_utils.push_token('description',message_text);
509: hr_utility.raise_error;
510: ELSE
511: CLOSE c_user_entity_id_of_bal;
512: END IF;

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

516: IF c_context_tax_unit_id%NOTFOUND THEN
517: CLOSE c_context_tax_unit_id;
518: /* message to user -- unable to find the context_id for tax_unit_id */
519: message_text := 'Context_id value for tax_unit_id missing';
520: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
521: pay_core_utils.push_token('record_name',message_preprocess);
522: pay_core_utils.push_token('description',message_text);
523: hr_utility.raise_error;
524: ELSE

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

517: CLOSE c_context_tax_unit_id;
518: /* message to user -- unable to find the context_id for tax_unit_id */
519: message_text := 'Context_id value for tax_unit_id missing';
520: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
521: pay_core_utils.push_token('record_name',message_preprocess);
522: pay_core_utils.push_token('description',message_text);
523: hr_utility.raise_error;
524: ELSE
525: CLOSE c_context_tax_unit_id;

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

518: /* message to user -- unable to find the context_id for tax_unit_id */
519: message_text := 'Context_id value for tax_unit_id missing';
520: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
521: pay_core_utils.push_token('record_name',message_preprocess);
522: pay_core_utils.push_token('description',message_text);
523: hr_utility.raise_error;
524: ELSE
525: CLOSE c_context_tax_unit_id;
526: END IF;

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

532: /* message to User -- Unable to find to context_id for jurisdiction */
533:
534: message_text := 'Context_id value for jurisdiction missing';
535: hr_utility.trace('Contxt_id value for jurisdction_id missing');
536: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
537: pay_core_utils.push_token('record_name',message_preprocess);
538: pay_core_utils.push_token('description',message_text);
539: hr_utility.raise_error;
540: ELSE

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

533:
534: message_text := 'Context_id value for jurisdiction missing';
535: hr_utility.trace('Contxt_id value for jurisdction_id missing');
536: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
537: pay_core_utils.push_token('record_name',message_preprocess);
538: pay_core_utils.push_token('description',message_text);
539: hr_utility.raise_error;
540: ELSE
541: CLOSE c_context_jurisdiction;

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

534: message_text := 'Context_id value for jurisdiction missing';
535: hr_utility.trace('Contxt_id value for jurisdction_id missing');
536: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
537: pay_core_utils.push_token('record_name',message_preprocess);
538: pay_core_utils.push_token('description',message_text);
539: hr_utility.raise_error;
540: ELSE
541: CLOSE c_context_jurisdiction;
542: eND IF;

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

548: IF c_transmitter%NOTFOUND THEN
549: CLOSE c_transmitter;
550: /* message to user -- transmitter has not been defined for the gre */
551: message_text := 'Transmitter Not denfined';
552: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
553: pay_core_utils.push_token('record_name',message_preprocess);
554: pay_core_utils.push_token('description',message_text);
555: hr_utility.raise_error;
556: ELSE

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

549: CLOSE c_transmitter;
550: /* message to user -- transmitter has not been defined for the gre */
551: message_text := 'Transmitter Not denfined';
552: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
553: pay_core_utils.push_token('record_name',message_preprocess);
554: pay_core_utils.push_token('description',message_text);
555: hr_utility.raise_error;
556: ELSE
557: CLOSE c_transmitter;

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

550: /* message to user -- transmitter has not been defined for the gre */
551: message_text := 'Transmitter Not denfined';
552: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
553: pay_core_utils.push_token('record_name',message_preprocess);
554: pay_core_utils.push_token('description',message_text);
555: hr_utility.raise_error;
556: ELSE
557: CLOSE c_transmitter;
558: END IF;

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

572: CLOSE c_gre_payroll_action;
573: /* message to user -- Transmitter has not been archived */
574: message_text := 'Transmitter not Archived';
575: hr_utility.trace('Transmitter has not been archived');
576: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
577: pay_core_utils.push_token('record_name',message_preprocess);
578: pay_core_utils.push_token('description',message_text);
579: -- hr_utility.raise_error;
580: END IF;

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

573: /* message to user -- Transmitter has not been archived */
574: message_text := 'Transmitter not Archived';
575: hr_utility.trace('Transmitter has not been archived');
576: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
577: pay_core_utils.push_token('record_name',message_preprocess);
578: pay_core_utils.push_token('description',message_text);
579: -- hr_utility.raise_error;
580: END IF;
581: CLOSE c_gre_payroll_action;

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

574: message_text := 'Transmitter not Archived';
575: hr_utility.trace('Transmitter has not been archived');
576: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
577: pay_core_utils.push_token('record_name',message_preprocess);
578: pay_core_utils.push_token('description',message_text);
579: -- hr_utility.raise_error;
580: END IF;
581: CLOSE c_gre_payroll_action;
582:

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

605: INTO l_asg_errored;
606:
607: IF c_arch_errored_asg%FOUND THEN
608: message_text := 'Assignment in Error Conditon for GRE:= ' || to_char(l_gre);
609: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
610: pay_core_utils.push_token('record_name',message_preprocess);
611: pay_core_utils.push_token('description',message_text);
612: --Some of the assignments have Errored
613: l_package_error_status := 'Y';

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

606:
607: IF c_arch_errored_asg%FOUND THEN
608: message_text := 'Assignment in Error Conditon for GRE:= ' || to_char(l_gre);
609: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
610: pay_core_utils.push_token('record_name',message_preprocess);
611: pay_core_utils.push_token('description',message_text);
612: --Some of the assignments have Errored
613: l_package_error_status := 'Y';
614: /* message to user -- assignment has errored out */

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

607: IF c_arch_errored_asg%FOUND THEN
608: message_text := 'Assignment in Error Conditon for GRE:= ' || to_char(l_gre);
609: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
610: pay_core_utils.push_token('record_name',message_preprocess);
611: pay_core_utils.push_token('description',message_text);
612: --Some of the assignments have Errored
613: l_package_error_status := 'Y';
614: /* message to user -- assignment has errored out */
615: --

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

623: FETCH c_arch_retry_pending INTO l_asg_retry_pend;
624: IF c_arch_retry_pending%FOUND THEN
625: --Some of the assignments have been marked for retry
626: message_text := 'Assignment Marked for Retry: GRE_ID := ' || to_char(l_gre);
627: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
628: pay_core_utils.push_token('record_name',message_preprocess);
629: pay_core_utils.push_token('description',message_text);
630: l_package_error_status := 'Y';
631: -- hr_utility.raise_error;

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

624: IF c_arch_retry_pending%FOUND THEN
625: --Some of the assignments have been marked for retry
626: message_text := 'Assignment Marked for Retry: GRE_ID := ' || to_char(l_gre);
627: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
628: pay_core_utils.push_token('record_name',message_preprocess);
629: pay_core_utils.push_token('description',message_text);
630: l_package_error_status := 'Y';
631: -- hr_utility.raise_error;
632:

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

625: --Some of the assignments have been marked for retry
626: message_text := 'Assignment Marked for Retry: GRE_ID := ' || to_char(l_gre);
627: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
628: pay_core_utils.push_token('record_name',message_preprocess);
629: pay_core_utils.push_token('description',message_text);
630: l_package_error_status := 'Y';
631: -- hr_utility.raise_error;
632:
633: END IF;

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

664: l_ein_result := check_er_data(l_payroll_action_id,l_gre);
665:
666: IF l_ein_result = 'N'THEN
667: message_text := 'EIN for GRE:= ' || to_char(l_gre) || 'Not Set';
668: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
669: pay_core_utils.push_token('record_name',message_preprocess);
670: pay_core_utils.push_token('description',message_text);
671: l_package_error_status := 'Y';
672: END IF;

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

665:
666: IF l_ein_result = 'N'THEN
667: message_text := 'EIN for GRE:= ' || to_char(l_gre) || 'Not Set';
668: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
669: pay_core_utils.push_token('record_name',message_preprocess);
670: pay_core_utils.push_token('description',message_text);
671: l_package_error_status := 'Y';
672: END IF;
673: ELSE

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

666: IF l_ein_result = 'N'THEN
667: message_text := 'EIN for GRE:= ' || to_char(l_gre) || 'Not Set';
668: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
669: pay_core_utils.push_token('record_name',message_preprocess);
670: pay_core_utils.push_token('description',message_text);
671: l_package_error_status := 'Y';
672: END IF;
673: ELSE
674: /* If Report type is not Fed so state */

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

679: -- hr_utility.trace('State Tax Rules not Found ');
680: -- /* state Tax Rules have not been Defined */
681: -- message_text := 'State Tax Rules not Defind for GRE '
682: -- || to_char(l_gre) || ' for ' || P_state_abbrev;
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; /* Missing State Tax Rules */

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

680: -- /* state Tax Rules have not been Defined */
681: -- message_text := 'State Tax Rules not Defind for GRE '
682: -- || to_char(l_gre) || ' for ' || P_state_abbrev;
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; /* Missing State Tax Rules */
688: --

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

681: -- message_text := 'State Tax Rules not Defind for GRE '
682: -- || to_char(l_gre) || ' for ' || P_state_abbrev;
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; /* Missing State Tax Rules */
688: --
689: -- close c_chk_archive_state_code;

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

696: /* EIN check Failed */
697: -- IF l_ein_result = 'N'THEN
698: -- hr_utility.trace('ID missing in State Tax Rules' || to_char(l_gre));
699: -- message_text := 'Missing ID in State Tax Rules for GRE:= '|| to_char(l_gre);
700: -- pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
701: -- pay_core_utils.push_token('record_name',message_preprocess);
702: -- pay_core_utils.push_token('description',message_text);
703: -- l_package_error_status := 'Y';
704: -- END IF;

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

697: -- IF l_ein_result = 'N'THEN
698: -- hr_utility.trace('ID missing in State Tax Rules' || to_char(l_gre));
699: -- message_text := 'Missing ID in State Tax Rules for GRE:= '|| to_char(l_gre);
700: -- pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
701: -- pay_core_utils.push_token('record_name',message_preprocess);
702: -- pay_core_utils.push_token('description',message_text);
703: -- l_package_error_status := 'Y';
704: -- END IF;
705: END IF;

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

698: -- hr_utility.trace('ID missing in State Tax Rules' || to_char(l_gre));
699: -- message_text := 'Missing ID in State Tax Rules for GRE:= '|| to_char(l_gre);
700: -- pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
701: -- pay_core_utils.push_token('record_name',message_preprocess);
702: -- pay_core_utils.push_token('description',message_text);
703: -- l_package_error_status := 'Y';
704: -- END IF;
705: END IF;
706:

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

799: hr_utility.trace('Archive_Gre ' || to_char(l_gre));
800: -- Person Found with Balance for given GRE
801: message_text := 'GRE_ID := ' || to_char(l_gre)
802: || ' has People with Balnace > 0';
803: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
804: pay_core_utils.push_token('record_name',message_preprocess);
805: pay_core_utils.push_token('description',message_text);
806:
807: message_text := 'Please Archive GRE With ID := ' || to_char(l_gre) ;

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

800: -- Person Found with Balance for given GRE
801: message_text := 'GRE_ID := ' || to_char(l_gre)
802: || ' has People with Balnace > 0';
803: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
804: pay_core_utils.push_token('record_name',message_preprocess);
805: pay_core_utils.push_token('description',message_text);
806:
807: message_text := 'Please Archive GRE With ID := ' || to_char(l_gre) ;
808: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

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

801: message_text := 'GRE_ID := ' || to_char(l_gre)
802: || ' has People with Balnace > 0';
803: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
804: pay_core_utils.push_token('record_name',message_preprocess);
805: pay_core_utils.push_token('description',message_text);
806:
807: message_text := 'Please Archive GRE With ID := ' || to_char(l_gre) ;
808: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
809: pay_core_utils.push_token('record_name',message_preprocess);

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

804: pay_core_utils.push_token('record_name',message_preprocess);
805: pay_core_utils.push_token('description',message_text);
806:
807: message_text := 'Please Archive GRE With ID := ' || to_char(l_gre) ;
808: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
809: pay_core_utils.push_token('record_name',message_preprocess);
810: l_package_error_status := 'Y';
811: END IF;
812: l_balance_exists := 0;

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

805: pay_core_utils.push_token('description',message_text);
806:
807: message_text := 'Please Archive GRE With ID := ' || to_char(l_gre) ;
808: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
809: pay_core_utils.push_token('record_name',message_preprocess);
810: l_package_error_status := 'Y';
811: END IF;
812: l_balance_exists := 0;
813:

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

825:
826: /* A warning is logged if GRE is not archived Buug # 3069840 */
827: l_package_error_status := 'N';
828: message_text := 'Please Archive GRE With ID := ' || to_char(l_gre) ;
829: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA_WARNING','P');
830: pay_core_utils.push_token('record_name',message_preprocess);
831: pay_core_utils.push_token('description',message_text);
832:
833: END IF; --end if for checking of person balance if the GRE has

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

826: /* A warning is logged if GRE is not archived Buug # 3069840 */
827: l_package_error_status := 'N';
828: message_text := 'Please Archive GRE With ID := ' || to_char(l_gre) ;
829: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA_WARNING','P');
830: pay_core_utils.push_token('record_name',message_preprocess);
831: pay_core_utils.push_token('description',message_text);
832:
833: END IF; --end if for checking of person balance if the GRE has
834: --not been archived.

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

827: l_package_error_status := 'N';
828: message_text := 'Please Archive GRE With ID := ' || to_char(l_gre) ;
829: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA_WARNING','P');
830: pay_core_utils.push_token('record_name',message_preprocess);
831: pay_core_utils.push_token('description',message_text);
832:
833: END IF; --end if for checking of person balance if the GRE has
834: --not been archived.
835:

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

839:
840: IF l_package_error_status = 'Y' THEN
841: hr_utility.trace('Error Condition Found');
842: message_text := 'Error Condition detected ' ;
843: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
844: pay_core_utils.push_token('record_name',message_preprocess);
845: pay_core_utils.push_token('description',message_text);
846:
847: message_text := 'Pay Message line and log have more Details' ;

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

840: IF l_package_error_status = 'Y' THEN
841: hr_utility.trace('Error Condition Found');
842: message_text := 'Error Condition detected ' ;
843: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
844: pay_core_utils.push_token('record_name',message_preprocess);
845: pay_core_utils.push_token('description',message_text);
846:
847: message_text := 'Pay Message line and log have more Details' ;
848: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

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

841: hr_utility.trace('Error Condition Found');
842: message_text := 'Error Condition detected ' ;
843: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
844: pay_core_utils.push_token('record_name',message_preprocess);
845: pay_core_utils.push_token('description',message_text);
846:
847: message_text := 'Pay Message line and log have more Details' ;
848: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
849: pay_core_utils.push_token('record_name',message_preprocess);

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

844: pay_core_utils.push_token('record_name',message_preprocess);
845: pay_core_utils.push_token('description',message_text);
846:
847: message_text := 'Pay Message line and log have more Details' ;
848: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
849: pay_core_utils.push_token('record_name',message_preprocess);
850: pay_core_utils.push_token('description',message_text);
851: hr_utility.raise_error;
852: END IF;

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

845: pay_core_utils.push_token('description',message_text);
846:
847: message_text := 'Pay Message line and log have more Details' ;
848: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
849: pay_core_utils.push_token('record_name',message_preprocess);
850: pay_core_utils.push_token('description',message_text);
851: hr_utility.raise_error;
852: END IF;
853:

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

846:
847: message_text := 'Pay Message line and log have more Details' ;
848: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
849: pay_core_utils.push_token('record_name',message_preprocess);
850: pay_core_utils.push_token('description',message_text);
851: hr_utility.raise_error;
852: END IF;
853:
854: IF l_no_of_gres_picked = 0 THEN

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

855: --It means that no archived GRE was
856: --found for the Organization. This is an error.
857:
858: message_text := 'No GRE was picked for Magnetic Tape';
859: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
860: pay_core_utils.push_token('record_name',message_preprocess);
861: pay_core_utils.push_token('description',message_text);
862: hr_utility.raise_error;
863: END IF;

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

856: --found for the Organization. This is an error.
857:
858: message_text := 'No GRE was picked for Magnetic Tape';
859: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
860: pay_core_utils.push_token('record_name',message_preprocess);
861: pay_core_utils.push_token('description',message_text);
862: hr_utility.raise_error;
863: END IF;
864:

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

857:
858: message_text := 'No GRE was picked for Magnetic Tape';
859: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
860: pay_core_utils.push_token('record_name',message_preprocess);
861: pay_core_utils.push_token('description',message_text);
862: hr_utility.raise_error;
863: END IF;
864:
865: RETURN TRUE;

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

1893:
1894: IF l_ein_status = 'N' THEN
1895: message_preprocess := 'Pre-Process Check-';
1896: message_text := 'EIN or Tax Unit Name Missing ';
1897: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1898: pay_core_utils.push_token('record_name',message_preprocess);
1899: pay_core_utils.push_token('description',message_text);
1900: END IF;
1901:

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

1894: IF l_ein_status = 'N' THEN
1895: message_preprocess := 'Pre-Process Check-';
1896: message_text := 'EIN or Tax Unit Name Missing ';
1897: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1898: pay_core_utils.push_token('record_name',message_preprocess);
1899: pay_core_utils.push_token('description',message_text);
1900: END IF;
1901:
1902: return l_ein_status ;

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

1895: message_preprocess := 'Pre-Process Check-';
1896: message_text := 'EIN or Tax Unit Name Missing ';
1897: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1898: pay_core_utils.push_token('record_name',message_preprocess);
1899: pay_core_utils.push_token('description',message_text);
1900: END IF;
1901:
1902: return l_ein_status ;
1903:

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

2077: open c_get_pr_control_num(C1.unit_id);
2078: fetch c_get_pr_control_num INTO l_control_number;
2079: if c_get_pr_control_num%notfound then
2080: l_message_text := 'ERROR: PR 499R Starting Control Number not defined';
2081: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
2082: pay_core_utils.push_token('record_name',l_message_preprocess);
2083: pay_core_utils.push_token('description',l_message_text);
2084: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
2085: l_control_num_flag := 'N';

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

2078: fetch c_get_pr_control_num INTO l_control_number;
2079: if c_get_pr_control_num%notfound then
2080: l_message_text := 'ERROR: PR 499R Starting Control Number not defined';
2081: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
2082: pay_core_utils.push_token('record_name',l_message_preprocess);
2083: pay_core_utils.push_token('description',l_message_text);
2084: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
2085: l_control_num_flag := 'N';
2086: else

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

2079: if c_get_pr_control_num%notfound then
2080: l_message_text := 'ERROR: PR 499R Starting Control Number not defined';
2081: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
2082: pay_core_utils.push_token('record_name',l_message_preprocess);
2083: pay_core_utils.push_token('description',l_message_text);
2084: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
2085: l_control_num_flag := 'N';
2086: else
2087: if (l_control_number is NULL or l_control_number = 0) then

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

2086: else
2087: if (l_control_number is NULL or l_control_number = 0) then
2088: l_message_text := 'ERROR:PR 499R Starting control Number is NULL';
2089: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
2090: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
2091: pay_core_utils.push_token('record_name',l_message_preprocess);
2092: pay_core_utils.push_token('description',l_message_text);
2093: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
2094: l_control_num_flag := 'N';

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

2087: if (l_control_number is NULL or l_control_number = 0) then
2088: l_message_text := 'ERROR:PR 499R Starting control Number is NULL';
2089: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
2090: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
2091: pay_core_utils.push_token('record_name',l_message_preprocess);
2092: pay_core_utils.push_token('description',l_message_text);
2093: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
2094: l_control_num_flag := 'N';
2095: end if;

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

2088: l_message_text := 'ERROR:PR 499R Starting control Number is NULL';
2089: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
2090: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
2091: pay_core_utils.push_token('record_name',l_message_preprocess);
2092: pay_core_utils.push_token('description',l_message_text);
2093: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
2094: l_control_num_flag := 'N';
2095: end if;
2096: end if;

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

2102: l_message_text := to_char(c1.unit_id) || 'Payroll_action_id ' || to_char(c1.payroll_action);
2103: hr_utility.trace(l_message_preprocess || ' ' || l_message_text) ;
2104: if c_sit_check%notfound then
2105: l_message_text := 'ERROR: Missing State Tax Rules For State of :' || p_transfer_state;
2106: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
2107: pay_core_utils.push_token('record_name',l_message_preprocess);
2108: pay_core_utils.push_token('description',l_message_text);
2109: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
2110: l_flag := 'N';

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

2103: hr_utility.trace(l_message_preprocess || ' ' || l_message_text) ;
2104: if c_sit_check%notfound then
2105: l_message_text := 'ERROR: Missing State Tax Rules For State of :' || p_transfer_state;
2106: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
2107: pay_core_utils.push_token('record_name',l_message_preprocess);
2108: pay_core_utils.push_token('description',l_message_text);
2109: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
2110: l_flag := 'N';
2111: close c_sit_check;

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

2104: if c_sit_check%notfound then
2105: l_message_text := 'ERROR: Missing State Tax Rules For State of :' || p_transfer_state;
2106: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
2107: pay_core_utils.push_token('record_name',l_message_preprocess);
2108: pay_core_utils.push_token('description',l_message_text);
2109: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
2110: l_flag := 'N';
2111: close c_sit_check;
2112: else

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

2113: if l_info IS NULL THEN
2114: l_flag := 'N';
2115: l_message_text := 'ERROR: NULL EIN For State of ' || p_transfer_state;
2116: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
2117: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
2118: pay_core_utils.push_token('record_name',l_message_preprocess);
2119: pay_core_utils.push_token('description',l_message_text);
2120: end if ;
2121: close c_sit_check;

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

2114: l_flag := 'N';
2115: l_message_text := 'ERROR: NULL EIN For State of ' || p_transfer_state;
2116: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
2117: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
2118: pay_core_utils.push_token('record_name',l_message_preprocess);
2119: pay_core_utils.push_token('description',l_message_text);
2120: end if ;
2121: close c_sit_check;
2122: end if;

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

2115: l_message_text := 'ERROR: NULL EIN For State of ' || p_transfer_state;
2116: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
2117: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
2118: pay_core_utils.push_token('record_name',l_message_preprocess);
2119: pay_core_utils.push_token('description',l_message_text);
2120: end if ;
2121: close c_sit_check;
2122: end if;
2123: END loop;

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

2122: end if;
2123: END loop;
2124: IF l_flag = 'N' OR l_control_num_flag = 'N' THEN
2125: l_message_text := 'Set your W2 Reporting Rules or State Tax Rules';
2126: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
2127: pay_core_utils.push_token('record_name',l_message_preprocess);
2128: pay_core_utils.push_token('description',l_message_text);
2129: hr_utility.raise_error;
2130: return 'N';

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

2123: END loop;
2124: IF l_flag = 'N' OR l_control_num_flag = 'N' THEN
2125: l_message_text := 'Set your W2 Reporting Rules or State Tax Rules';
2126: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
2127: pay_core_utils.push_token('record_name',l_message_preprocess);
2128: pay_core_utils.push_token('description',l_message_text);
2129: hr_utility.raise_error;
2130: return 'N';
2131: END IF;

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

2124: IF l_flag = 'N' OR l_control_num_flag = 'N' THEN
2125: l_message_text := 'Set your W2 Reporting Rules or State Tax Rules';
2126: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
2127: pay_core_utils.push_token('record_name',l_message_preprocess);
2128: pay_core_utils.push_token('description',l_message_text);
2129: hr_utility.raise_error;
2130: return 'N';
2131: END IF;
2132: return 'Y';

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

2133: EXCEPTION
2134: WHEN OTHERS THEN
2135: l_message_preprocess := 'Exception ';
2136: l_message_text := 'Set your W2 Reporting Rules or State Tax Rules';
2137: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
2138: pay_core_utils.push_token('record_name',l_message_preprocess);
2139: pay_core_utils.push_token('description',l_message_text);
2140: u_message_text := 'Set your W2 Reporting Rules or State Tax Rules';
2141: hr_utility.set_message(801, 'HR_7998_ALL_EXEMACRO_MESSAGE');

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

2134: WHEN OTHERS THEN
2135: l_message_preprocess := 'Exception ';
2136: l_message_text := 'Set your W2 Reporting Rules or State Tax Rules';
2137: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
2138: pay_core_utils.push_token('record_name',l_message_preprocess);
2139: pay_core_utils.push_token('description',l_message_text);
2140: u_message_text := 'Set your W2 Reporting Rules or State Tax Rules';
2141: hr_utility.set_message(801, 'HR_7998_ALL_EXEMACRO_MESSAGE');
2142: hr_utility.set_message_token('MESSAGE', u_message_text);

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

2135: l_message_preprocess := 'Exception ';
2136: l_message_text := 'Set your W2 Reporting Rules or State Tax Rules';
2137: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
2138: pay_core_utils.push_token('record_name',l_message_preprocess);
2139: pay_core_utils.push_token('description',l_message_text);
2140: u_message_text := 'Set your W2 Reporting Rules or State Tax Rules';
2141: hr_utility.set_message(801, 'HR_7998_ALL_EXEMACRO_MESSAGE');
2142: hr_utility.set_message_token('MESSAGE', u_message_text);
2143: hr_utility.raise_error;