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

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

432: CLOSE c_tax_ein;
433: l_package_error_status := 'Y';
434: hr_utility.trace('A_TAX_UNIT_EMPLOYER_IDENTIFICATION_NUMBER missing ');
435: message_text := 'EIN ID missing ';
436: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
437: pay_core_utils.push_token('record_name',message_preprocess);
438: pay_core_utils.push_token('description',message_text);
439: hr_utility.raise_error;
440: ELSE

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

433: l_package_error_status := 'Y';
434: hr_utility.trace('A_TAX_UNIT_EMPLOYER_IDENTIFICATION_NUMBER missing ');
435: message_text := 'EIN ID missing ';
436: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
437: pay_core_utils.push_token('record_name',message_preprocess);
438: pay_core_utils.push_token('description',message_text);
439: hr_utility.raise_error;
440: ELSE
441: CLOSE c_tax_ein;

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

434: hr_utility.trace('A_TAX_UNIT_EMPLOYER_IDENTIFICATION_NUMBER missing ');
435: message_text := 'EIN ID missing ';
436: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
437: pay_core_utils.push_token('record_name',message_preprocess);
438: pay_core_utils.push_token('description',message_text);
439: hr_utility.raise_error;
440: ELSE
441: CLOSE c_tax_ein;
442: END IF;

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

450: l_package_error_status := 'Y';
451: /* message to user - Database item missing */
452: hr_utility.trace('Database item for balacne missing ');
453: message_text := '-Database item missing ';
454: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
455: pay_core_utils.push_token('record_name',message_preprocess);
456: pay_core_utils.push_token('description',message_text);
457: hr_utility.raise_error;
458: ELSE

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

451: /* message to user - Database item missing */
452: hr_utility.trace('Database item for balacne missing ');
453: message_text := '-Database item missing ';
454: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
455: pay_core_utils.push_token('record_name',message_preprocess);
456: pay_core_utils.push_token('description',message_text);
457: hr_utility.raise_error;
458: ELSE
459: CLOSE c_user_entity_id_of_bal;

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

452: hr_utility.trace('Database item for balacne missing ');
453: message_text := '-Database item missing ';
454: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
455: pay_core_utils.push_token('record_name',message_preprocess);
456: pay_core_utils.push_token('description',message_text);
457: hr_utility.raise_error;
458: ELSE
459: CLOSE c_user_entity_id_of_bal;
460: END IF;

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

464: IF c_context_tax_unit_id%NOTFOUND THEN
465: CLOSE c_context_tax_unit_id;
466: /* message to user -- unable to find the context_id for tax_unit_id */
467: message_text := 'Context_id value for tax_unit_id missing';
468: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
469: pay_core_utils.push_token('record_name',message_preprocess);
470: pay_core_utils.push_token('description',message_text);
471: hr_utility.raise_error;
472: ELSE

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

465: CLOSE c_context_tax_unit_id;
466: /* message to user -- unable to find the context_id for tax_unit_id */
467: message_text := 'Context_id value for tax_unit_id missing';
468: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
469: pay_core_utils.push_token('record_name',message_preprocess);
470: pay_core_utils.push_token('description',message_text);
471: hr_utility.raise_error;
472: ELSE
473: CLOSE c_context_tax_unit_id;

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

466: /* message to user -- unable to find the context_id for tax_unit_id */
467: message_text := 'Context_id value for tax_unit_id missing';
468: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
469: pay_core_utils.push_token('record_name',message_preprocess);
470: pay_core_utils.push_token('description',message_text);
471: hr_utility.raise_error;
472: ELSE
473: CLOSE c_context_tax_unit_id;
474: END IF;

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

480: /* message to User -- Unable to find to context_id for jurisdiction */
481:
482: message_text := 'Context_id value for jurisdiction missing';
483: hr_utility.trace('Contxt_id value for jurisdction_id missing');
484: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
485: pay_core_utils.push_token('record_name',message_preprocess);
486: pay_core_utils.push_token('description',message_text);
487: hr_utility.raise_error;
488: ELSE

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

481:
482: message_text := 'Context_id value for jurisdiction missing';
483: hr_utility.trace('Contxt_id value for jurisdction_id missing');
484: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
485: pay_core_utils.push_token('record_name',message_preprocess);
486: pay_core_utils.push_token('description',message_text);
487: hr_utility.raise_error;
488: ELSE
489: CLOSE c_context_jurisdiction;

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

482: message_text := 'Context_id value for jurisdiction missing';
483: hr_utility.trace('Contxt_id value for jurisdction_id missing');
484: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
485: pay_core_utils.push_token('record_name',message_preprocess);
486: pay_core_utils.push_token('description',message_text);
487: hr_utility.raise_error;
488: ELSE
489: CLOSE c_context_jurisdiction;
490: END IF;

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

496: IF c_transmitter%NOTFOUND THEN
497: CLOSE c_transmitter;
498: /* message to user -- transmitter has not been defined for the gre */
499: message_text := 'Transmitter Not denfined';
500: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
501: pay_core_utils.push_token('record_name',message_preprocess);
502: pay_core_utils.push_token('description',message_text);
503: hr_utility.raise_error;
504: ELSE

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

497: CLOSE c_transmitter;
498: /* message to user -- transmitter has not been defined for the gre */
499: message_text := 'Transmitter Not denfined';
500: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
501: pay_core_utils.push_token('record_name',message_preprocess);
502: pay_core_utils.push_token('description',message_text);
503: hr_utility.raise_error;
504: ELSE
505: CLOSE c_transmitter;

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

498: /* message to user -- transmitter has not been defined for the gre */
499: message_text := 'Transmitter Not denfined';
500: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
501: pay_core_utils.push_token('record_name',message_preprocess);
502: pay_core_utils.push_token('description',message_text);
503: hr_utility.raise_error;
504: ELSE
505: CLOSE c_transmitter;
506: END IF;

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

520: CLOSE c_gre_payroll_action;
521: /* message to user -- Transmitter has not been archived */
522: message_text := 'Transmitter not Archived';
523: hr_utility.trace('Transmitter has not been archived');
524: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
525: pay_core_utils.push_token('record_name',message_preprocess);
526: pay_core_utils.push_token('description',message_text);
527: -- hr_utility.raise_error;
528: END IF;

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

521: /* message to user -- Transmitter has not been archived */
522: message_text := 'Transmitter not Archived';
523: hr_utility.trace('Transmitter has not been archived');
524: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
525: pay_core_utils.push_token('record_name',message_preprocess);
526: pay_core_utils.push_token('description',message_text);
527: -- hr_utility.raise_error;
528: END IF;
529: CLOSE c_gre_payroll_action;

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

522: message_text := 'Transmitter not Archived';
523: hr_utility.trace('Transmitter has not been archived');
524: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
525: pay_core_utils.push_token('record_name',message_preprocess);
526: pay_core_utils.push_token('description',message_text);
527: -- hr_utility.raise_error;
528: END IF;
529: CLOSE c_gre_payroll_action;
530:

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

553: INTO l_asg_errored;
554:
555: IF c_arch_errored_asg%FOUND THEN
556: message_text := 'Assignment in Error Conditon for GRE:= ' || to_char(l_gre);
557: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
558: pay_core_utils.push_token('record_name',message_preprocess);
559: pay_core_utils.push_token('description',message_text);
560: --Some of the assignments have Errored
561: l_package_error_status := 'Y';

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

554:
555: IF c_arch_errored_asg%FOUND THEN
556: message_text := 'Assignment in Error Conditon for GRE:= ' || to_char(l_gre);
557: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
558: pay_core_utils.push_token('record_name',message_preprocess);
559: pay_core_utils.push_token('description',message_text);
560: --Some of the assignments have Errored
561: l_package_error_status := 'Y';
562: /* message to user -- assignment has errored out */

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

555: IF c_arch_errored_asg%FOUND THEN
556: message_text := 'Assignment in Error Conditon for GRE:= ' || to_char(l_gre);
557: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
558: pay_core_utils.push_token('record_name',message_preprocess);
559: pay_core_utils.push_token('description',message_text);
560: --Some of the assignments have Errored
561: l_package_error_status := 'Y';
562: /* message to user -- assignment has errored out */
563: --

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

571: FETCH c_arch_retry_pending INTO l_asg_retry_pend;
572: IF c_arch_retry_pending%FOUND THEN
573: --Some of the assignments have been marked for retry
574: message_text := 'Assignment Marked for Retry: GRE_ID := ' || to_char(l_gre);
575: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
576: pay_core_utils.push_token('record_name',message_preprocess);
577: pay_core_utils.push_token('description',message_text);
578: l_package_error_status := 'Y';
579: -- hr_utility.raise_error;

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

572: IF c_arch_retry_pending%FOUND THEN
573: --Some of the assignments have been marked for retry
574: message_text := 'Assignment Marked for Retry: GRE_ID := ' || to_char(l_gre);
575: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
576: pay_core_utils.push_token('record_name',message_preprocess);
577: pay_core_utils.push_token('description',message_text);
578: l_package_error_status := 'Y';
579: -- hr_utility.raise_error;
580:

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

573: --Some of the assignments have been marked for retry
574: message_text := 'Assignment Marked for Retry: GRE_ID := ' || to_char(l_gre);
575: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
576: pay_core_utils.push_token('record_name',message_preprocess);
577: pay_core_utils.push_token('description',message_text);
578: l_package_error_status := 'Y';
579: -- hr_utility.raise_error;
580:
581: END IF;

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

612: l_ein_result := check_er_data(l_payroll_action_id,l_gre);
613:
614: IF l_ein_result = 'N'THEN
615: message_text := 'EIN for GRE:= ' || to_char(l_gre) || 'Not Set';
616: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
617: pay_core_utils.push_token('record_name',message_preprocess);
618: pay_core_utils.push_token('description',message_text);
619: l_package_error_status := 'Y';
620: END IF;

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

613:
614: IF l_ein_result = 'N'THEN
615: message_text := 'EIN for GRE:= ' || to_char(l_gre) || 'Not Set';
616: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
617: pay_core_utils.push_token('record_name',message_preprocess);
618: pay_core_utils.push_token('description',message_text);
619: l_package_error_status := 'Y';
620: END IF;
621: ELSE

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

614: IF l_ein_result = 'N'THEN
615: message_text := 'EIN for GRE:= ' || to_char(l_gre) || 'Not Set';
616: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
617: pay_core_utils.push_token('record_name',message_preprocess);
618: pay_core_utils.push_token('description',message_text);
619: l_package_error_status := 'Y';
620: END IF;
621: ELSE
622: /* If Report type is not Fed so state */

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

627: -- hr_utility.trace('State Tax Rules not Found ');
628: -- /* state Tax Rules have not been Defined */
629: -- message_text := 'State Tax Rules not Defind for GRE '
630: -- || to_char(l_gre) || ' for ' || P_state_abbrev;
631: -- pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
632: -- pay_core_utils.push_token('record_name',message_preprocess);
633: -- pay_core_utils.push_token('description',message_text);
634: -- l_package_error_status := 'Y';
635: -- END IF; /* Missing State Tax Rules */

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

628: -- /* state Tax Rules have not been Defined */
629: -- message_text := 'State Tax Rules not Defind for GRE '
630: -- || to_char(l_gre) || ' for ' || P_state_abbrev;
631: -- pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
632: -- pay_core_utils.push_token('record_name',message_preprocess);
633: -- pay_core_utils.push_token('description',message_text);
634: -- l_package_error_status := 'Y';
635: -- END IF; /* Missing State Tax Rules */
636: --

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

629: -- message_text := 'State Tax Rules not Defind for GRE '
630: -- || to_char(l_gre) || ' for ' || P_state_abbrev;
631: -- pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
632: -- pay_core_utils.push_token('record_name',message_preprocess);
633: -- pay_core_utils.push_token('description',message_text);
634: -- l_package_error_status := 'Y';
635: -- END IF; /* Missing State Tax Rules */
636: --
637: -- close c_chk_archive_state_code;

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

644: /* EIN check Failed */
645: -- IF l_ein_result = 'N'THEN
646: -- hr_utility.trace('ID missing in State Tax Rules' || to_char(l_gre));
647: -- message_text := 'Missing ID in State Tax Rules for GRE:= '|| to_char(l_gre);
648: -- pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
649: -- pay_core_utils.push_token('record_name',message_preprocess);
650: -- pay_core_utils.push_token('description',message_text);
651: -- l_package_error_status := 'Y';
652: -- END IF;

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

645: -- IF l_ein_result = 'N'THEN
646: -- hr_utility.trace('ID missing in State Tax Rules' || to_char(l_gre));
647: -- message_text := 'Missing ID in State Tax Rules for GRE:= '|| to_char(l_gre);
648: -- pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
649: -- pay_core_utils.push_token('record_name',message_preprocess);
650: -- pay_core_utils.push_token('description',message_text);
651: -- l_package_error_status := 'Y';
652: -- END IF;
653: END IF;

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

646: -- hr_utility.trace('ID missing in State Tax Rules' || to_char(l_gre));
647: -- message_text := 'Missing ID in State Tax Rules for GRE:= '|| to_char(l_gre);
648: -- pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
649: -- pay_core_utils.push_token('record_name',message_preprocess);
650: -- pay_core_utils.push_token('description',message_text);
651: -- l_package_error_status := 'Y';
652: -- END IF;
653: END IF;
654:

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

744: hr_utility.trace('Archive_Gre ' || to_char(l_gre));
745: -- Person Found with Balance for given GRE
746: message_text := 'GRE_ID := ' || to_char(l_gre)
747: || ' has People with Balnace > 0';
748: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
749: pay_core_utils.push_token('record_name',message_preprocess);
750: pay_core_utils.push_token('description',message_text);
751:
752: message_text := 'Please Archive GRE With ID := ' || to_char(l_gre) ;

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

745: -- Person Found with Balance for given GRE
746: message_text := 'GRE_ID := ' || to_char(l_gre)
747: || ' has People with Balnace > 0';
748: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
749: pay_core_utils.push_token('record_name',message_preprocess);
750: pay_core_utils.push_token('description',message_text);
751:
752: message_text := 'Please Archive GRE With ID := ' || to_char(l_gre) ;
753: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

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

746: message_text := 'GRE_ID := ' || to_char(l_gre)
747: || ' has People with Balnace > 0';
748: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
749: pay_core_utils.push_token('record_name',message_preprocess);
750: pay_core_utils.push_token('description',message_text);
751:
752: message_text := 'Please Archive GRE With ID := ' || to_char(l_gre) ;
753: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
754: pay_core_utils.push_token('record_name',message_preprocess);

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

749: pay_core_utils.push_token('record_name',message_preprocess);
750: pay_core_utils.push_token('description',message_text);
751:
752: message_text := 'Please Archive GRE With ID := ' || to_char(l_gre) ;
753: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
754: pay_core_utils.push_token('record_name',message_preprocess);
755: l_package_error_status := 'Y';
756: END IF;
757: l_balance_exists := 0;

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

750: pay_core_utils.push_token('description',message_text);
751:
752: message_text := 'Please Archive GRE With ID := ' || to_char(l_gre) ;
753: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
754: pay_core_utils.push_token('record_name',message_preprocess);
755: l_package_error_status := 'Y';
756: END IF;
757: l_balance_exists := 0;
758: END LOOP; --Main Loop

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

771: --
772: /* A warning is logged if GRE is not archived Buug # 3069840 */
773: l_package_error_status := 'N';
774: message_text := 'Please Archive GRE With ID := ' || to_char(l_gre) ;
775: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA_WARNING','P');
776: pay_core_utils.push_token('record_name',message_preprocess);
777: pay_core_utils.push_token('description',message_text);
778:
779: END IF; --end if for checking of person balance if the GRE has

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

772: /* A warning is logged if GRE is not archived Buug # 3069840 */
773: l_package_error_status := 'N';
774: message_text := 'Please Archive GRE With ID := ' || to_char(l_gre) ;
775: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA_WARNING','P');
776: pay_core_utils.push_token('record_name',message_preprocess);
777: pay_core_utils.push_token('description',message_text);
778:
779: END IF; --end if for checking of person balance if the GRE has
780: --not been archived.

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

773: l_package_error_status := 'N';
774: message_text := 'Please Archive GRE With ID := ' || to_char(l_gre) ;
775: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA_WARNING','P');
776: pay_core_utils.push_token('record_name',message_preprocess);
777: pay_core_utils.push_token('description',message_text);
778:
779: END IF; --end if for checking of person balance if the GRE has
780: --not been archived.
781: CLOSE c_gre_payroll_action;

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

784:
785: IF l_package_error_status = 'Y' THEN
786: hr_utility.trace('Error Condition Found');
787: message_text := 'Error Condition detected ' ;
788: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
789: pay_core_utils.push_token('record_name',message_preprocess);
790: pay_core_utils.push_token('description',message_text);
791:
792: message_text := 'Pay Message line and log have more Details' ;

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

785: IF l_package_error_status = 'Y' THEN
786: hr_utility.trace('Error Condition Found');
787: message_text := 'Error Condition detected ' ;
788: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
789: pay_core_utils.push_token('record_name',message_preprocess);
790: pay_core_utils.push_token('description',message_text);
791:
792: message_text := 'Pay Message line and log have more Details' ;
793: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

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

786: hr_utility.trace('Error Condition Found');
787: message_text := 'Error Condition detected ' ;
788: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
789: pay_core_utils.push_token('record_name',message_preprocess);
790: pay_core_utils.push_token('description',message_text);
791:
792: message_text := 'Pay Message line and log have more Details' ;
793: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
794: pay_core_utils.push_token('record_name',message_preprocess);

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

789: pay_core_utils.push_token('record_name',message_preprocess);
790: pay_core_utils.push_token('description',message_text);
791:
792: message_text := 'Pay Message line and log have more Details' ;
793: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
794: pay_core_utils.push_token('record_name',message_preprocess);
795: pay_core_utils.push_token('description',message_text);
796: hr_utility.raise_error;
797: END IF;

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

790: pay_core_utils.push_token('description',message_text);
791:
792: message_text := 'Pay Message line and log have more Details' ;
793: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
794: pay_core_utils.push_token('record_name',message_preprocess);
795: pay_core_utils.push_token('description',message_text);
796: hr_utility.raise_error;
797: END IF;
798:

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

791:
792: message_text := 'Pay Message line and log have more Details' ;
793: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
794: pay_core_utils.push_token('record_name',message_preprocess);
795: pay_core_utils.push_token('description',message_text);
796: hr_utility.raise_error;
797: END IF;
798:
799: IF l_no_of_gres_picked = 0 THEN

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

800: --It means that no archived GRE was
801: --found for the Organization. This is an error.
802:
803: message_text := 'No GRE was picked for Magnetic Tape';
804: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
805: pay_core_utils.push_token('record_name',message_preprocess);
806: pay_core_utils.push_token('description',message_text);
807: hr_utility.raise_error;
808: END IF;

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

801: --found for the Organization. This is an error.
802:
803: message_text := 'No GRE was picked for Magnetic Tape';
804: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
805: pay_core_utils.push_token('record_name',message_preprocess);
806: pay_core_utils.push_token('description',message_text);
807: hr_utility.raise_error;
808: END IF;
809:

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

802:
803: message_text := 'No GRE was picked for Magnetic Tape';
804: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
805: pay_core_utils.push_token('record_name',message_preprocess);
806: pay_core_utils.push_token('description',message_text);
807: hr_utility.raise_error;
808: END IF;
809:
810: RETURN TRUE;

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

1311:
1312: IF l_ein_status = 'N' THEN
1313: message_preprocess := 'Pre-Process Check-';
1314: message_text := 'EIN or Tax Unit Name Missing ';
1315: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1316: pay_core_utils.push_token('record_name',message_preprocess);
1317: pay_core_utils.push_token('description',message_text);
1318: END IF;
1319:

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

1312: IF l_ein_status = 'N' THEN
1313: message_preprocess := 'Pre-Process Check-';
1314: message_text := 'EIN or Tax Unit Name Missing ';
1315: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1316: pay_core_utils.push_token('record_name',message_preprocess);
1317: pay_core_utils.push_token('description',message_text);
1318: END IF;
1319:
1320: return l_ein_status ;

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

1313: message_preprocess := 'Pre-Process Check-';
1314: message_text := 'EIN or Tax Unit Name Missing ';
1315: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1316: pay_core_utils.push_token('record_name',message_preprocess);
1317: pay_core_utils.push_token('description',message_text);
1318: END IF;
1319:
1320: return l_ein_status ;
1321:

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

1488: l_message_text := to_char(c1.unit_id) || 'Payroll_action_id ' || to_char(c1.payroll_action);
1489: hr_utility.trace(l_message_preprocess || ' ' || l_message_text) ;
1490: if c_sit_check%notfound then
1491: l_message_text := ' :Missing State Tax Rules For State of :' || p_transfer_state;
1492: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1493: pay_core_utils.push_token('record_name',l_message_preprocess);
1494: pay_core_utils.push_token('description',l_message_text);
1495: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
1496: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );

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

1489: hr_utility.trace(l_message_preprocess || ' ' || l_message_text) ;
1490: if c_sit_check%notfound then
1491: l_message_text := ' :Missing State Tax Rules For State of :' || p_transfer_state;
1492: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1493: pay_core_utils.push_token('record_name',l_message_preprocess);
1494: pay_core_utils.push_token('description',l_message_text);
1495: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
1496: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
1497: l_flag := 'N';

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

1490: if c_sit_check%notfound then
1491: l_message_text := ' :Missing State Tax Rules For State of :' || p_transfer_state;
1492: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1493: pay_core_utils.push_token('record_name',l_message_preprocess);
1494: pay_core_utils.push_token('description',l_message_text);
1495: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
1496: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
1497: l_flag := 'N';
1498: close c_sit_check;

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

1500: if l_info IS NULL THEN
1501: l_flag := 'N';
1502: l_message_text := ' NULL EIN For State of :' || p_transfer_state;
1503: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
1504: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1505: pay_core_utils.push_token('record_name',l_message_preprocess);
1506: pay_core_utils.push_token('description',l_message_text);
1507: end if ;
1508: close c_sit_check;

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

1501: l_flag := 'N';
1502: l_message_text := ' NULL EIN For State of :' || p_transfer_state;
1503: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
1504: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1505: pay_core_utils.push_token('record_name',l_message_preprocess);
1506: pay_core_utils.push_token('description',l_message_text);
1507: end if ;
1508: close c_sit_check;
1509: end if;

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

1502: l_message_text := ' NULL EIN For State of :' || p_transfer_state;
1503: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
1504: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1505: pay_core_utils.push_token('record_name',l_message_preprocess);
1506: pay_core_utils.push_token('description',l_message_text);
1507: end if ;
1508: close c_sit_check;
1509: end if;
1510: END loop;

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

1509: end if;
1510: END loop;
1511: IF l_flag = 'N' THEN
1512: l_message_text := 'Flag N Set for Tax Rule Check ';
1513: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1514: pay_core_utils.push_token('record_name',l_message_preprocess);
1515: pay_core_utils.push_token('description',l_message_text);
1516: u_message_text := 'Error in EIN or State Tax Rule Missing ';
1517: hr_utility.set_message(801, 'HR_7998_ALL_EXEMACRO_MESSAGE');

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

1510: END loop;
1511: IF l_flag = 'N' THEN
1512: l_message_text := 'Flag N Set for Tax Rule Check ';
1513: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1514: pay_core_utils.push_token('record_name',l_message_preprocess);
1515: pay_core_utils.push_token('description',l_message_text);
1516: u_message_text := 'Error in EIN or State Tax Rule Missing ';
1517: hr_utility.set_message(801, 'HR_7998_ALL_EXEMACRO_MESSAGE');
1518: hr_utility.set_message_token('MESSAGE', u_message_text);

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

1511: IF l_flag = 'N' THEN
1512: l_message_text := 'Flag N Set for Tax Rule Check ';
1513: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1514: pay_core_utils.push_token('record_name',l_message_preprocess);
1515: pay_core_utils.push_token('description',l_message_text);
1516: u_message_text := 'Error in EIN or State Tax Rule Missing ';
1517: hr_utility.set_message(801, 'HR_7998_ALL_EXEMACRO_MESSAGE');
1518: hr_utility.set_message_token('MESSAGE', u_message_text);
1519: hr_utility.raise_error;

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

1524: EXCEPTION
1525: WHEN OTHERS THEN
1526: l_message_preprocess := 'Exception ';
1527: l_message_text := 'In State Tax Rules Or EIN Checking ';
1528: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1529: pay_core_utils.push_token('record_name',l_message_preprocess);
1530: pay_core_utils.push_token('description',l_message_text);
1531: u_message_text := 'Exception : State Tax Rules Or EIN Checking ';
1532: hr_utility.set_message(801, 'HR_7998_ALL_EXEMACRO_MESSAGE');

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

1525: WHEN OTHERS THEN
1526: l_message_preprocess := 'Exception ';
1527: l_message_text := 'In State Tax Rules Or EIN Checking ';
1528: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1529: pay_core_utils.push_token('record_name',l_message_preprocess);
1530: pay_core_utils.push_token('description',l_message_text);
1531: u_message_text := 'Exception : State Tax Rules Or EIN Checking ';
1532: hr_utility.set_message(801, 'HR_7998_ALL_EXEMACRO_MESSAGE');
1533: hr_utility.set_message_token('MESSAGE', u_message_text);

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

1526: l_message_preprocess := 'Exception ';
1527: l_message_text := 'In State Tax Rules Or EIN Checking ';
1528: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1529: pay_core_utils.push_token('record_name',l_message_preprocess);
1530: pay_core_utils.push_token('description',l_message_text);
1531: u_message_text := 'Exception : State Tax Rules Or EIN Checking ';
1532: hr_utility.set_message(801, 'HR_7998_ALL_EXEMACRO_MESSAGE');
1533: hr_utility.set_message_token('MESSAGE', u_message_text);
1534: hr_utility.raise_error;