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_EXA_SHD dependencies on HR_MESSAGE

Line 571: hr_message.provide_error;

567: --
568: end if;
569: exception
570: when app_exception.application_exception then
571: hr_message.provide_error;
572: hr_utility.trace('*****' || p_territory_code);
573: hr_utility.trace('*****' || hr_message.last_message_name);
574: hr_utility.trace('*****' || hr_message.get_token_value('COLUMN'));
575:

Line 573: hr_utility.trace('*****' || hr_message.last_message_name);

569: exception
570: when app_exception.application_exception then
571: hr_message.provide_error;
572: hr_utility.trace('*****' || p_territory_code);
573: hr_utility.trace('*****' || hr_message.last_message_name);
574: hr_utility.trace('*****' || hr_message.get_token_value('COLUMN'));
575:
576: --
577: -- if any validation fails on a segment, the exception

Line 574: hr_utility.trace('*****' || hr_message.get_token_value('COLUMN'));

570: when app_exception.application_exception then
571: hr_message.provide_error;
572: hr_utility.trace('*****' || p_territory_code);
573: hr_utility.trace('*****' || hr_message.last_message_name);
574: hr_utility.trace('*****' || hr_message.get_token_value('COLUMN'));
575:
576: --
577: -- if any validation fails on a segment, the exception
578: -- HR_FLEX_VALUE_INVALID is thrown,

Line 588: if hr_message.last_message_name = 'HR_FLEX_VALUE_INVALID' then

584: --
585: -- us segment 1
586: --
587: if p_territory_code = 'US' then
588: if hr_message.last_message_name = 'HR_FLEX_VALUE_INVALID' then
589: if hr_message.get_token_value('COLUMN') = 'SEGMENT1' then
590: if (length(p_segment1) > 60) then
591: hr_utility.set_message(801, 'HR_51458_EXA_US_ACCT_NAME_LONG');
592: hr_utility.raise_error;

Line 589: if hr_message.get_token_value('COLUMN') = 'SEGMENT1' then

585: -- us segment 1
586: --
587: if p_territory_code = 'US' then
588: if hr_message.last_message_name = 'HR_FLEX_VALUE_INVALID' then
589: if hr_message.get_token_value('COLUMN') = 'SEGMENT1' then
590: if (length(p_segment1) > 60) then
591: hr_utility.set_message(801, 'HR_51458_EXA_US_ACCT_NAME_LONG');
592: hr_utility.raise_error;
593: end if;

Line 602: if hr_message.last_message_name = 'HR_FLEX_VALUE_INVALID' then

598: --
599: -- us segment 2
600: --
601: if p_territory_code = 'US' then
602: if hr_message.last_message_name = 'HR_FLEX_VALUE_INVALID' then
603: if hr_message.get_token_value('COLUMN') = 'SEGMENT2' then
604: if (length(p_segment1) > 80) then
605: hr_utility.set_message(801, 'HR_51459_EXA_US_ACCT_TYPE_LONG');
606: hr_utility.raise_error;

Line 603: if hr_message.get_token_value('COLUMN') = 'SEGMENT2' then

599: -- us segment 2
600: --
601: if p_territory_code = 'US' then
602: if hr_message.last_message_name = 'HR_FLEX_VALUE_INVALID' then
603: if hr_message.get_token_value('COLUMN') = 'SEGMENT2' then
604: if (length(p_segment1) > 80) then
605: hr_utility.set_message(801, 'HR_51459_EXA_US_ACCT_TYPE_LONG');
606: hr_utility.raise_error;
607: else

Line 639: if hr_message.last_message_name = 'HR_FLEX_VALUE_INVALID' then

635: --
636: -- us segment 3
637: --
638: if p_territory_code = 'US' then
639: if hr_message.last_message_name = 'HR_FLEX_VALUE_INVALID' then
640: if hr_message.get_token_value('COLUMN') = 'SEGMENT3' then
641: if (length(p_segment1) > 60) then
642: hr_utility.set_message(801, 'HR_51461_EXA_US_ACCT_NO_LONG');
643: hr_utility.raise_error;

Line 640: if hr_message.get_token_value('COLUMN') = 'SEGMENT3' then

636: -- us segment 3
637: --
638: if p_territory_code = 'US' then
639: if hr_message.last_message_name = 'HR_FLEX_VALUE_INVALID' then
640: if hr_message.get_token_value('COLUMN') = 'SEGMENT3' then
641: if (length(p_segment1) > 60) then
642: hr_utility.set_message(801, 'HR_51461_EXA_US_ACCT_NO_LONG');
643: hr_utility.raise_error;
644: end if;

Line 653: if hr_message.last_message_name = 'HR_FLEX_VALUE_INVALID' then

649: --
650: -- us segment 4
651: --
652: if p_territory_code = 'US' then
653: if hr_message.last_message_name = 'HR_FLEX_VALUE_INVALID' then
654: if hr_message.get_token_value('COLUMN') = 'SEGMENT4' then
655: if (length(p_segment4) > 9) then
656: hr_utility.set_message(801, 'HR_51462_EXA_US_TRAN_CODE_LONG');
657: hr_utility.raise_error;

Line 654: if hr_message.get_token_value('COLUMN') = 'SEGMENT4' then

650: -- us segment 4
651: --
652: if p_territory_code = 'US' then
653: if hr_message.last_message_name = 'HR_FLEX_VALUE_INVALID' then
654: if hr_message.get_token_value('COLUMN') = 'SEGMENT4' then
655: if (length(p_segment4) > 9) then
656: hr_utility.set_message(801, 'HR_51462_EXA_US_TRAN_CODE_LONG');
657: hr_utility.raise_error;
658: end if;

Line 667: if hr_message.last_message_name = 'HR_FLEX_VALUE_INVALID' then

663: --
664: -- us segment 5
665: --
666: if p_territory_code = 'US' then
667: if hr_message.last_message_name = 'HR_FLEX_VALUE_INVALID' then
668: if hr_message.get_token_value('COLUMN') = 'SEGMENT5' then
669: if (length(p_segment5) > 60) then
670: hr_utility.set_message(801, 'HR_51463_EXA_US_BANK_NAME_LONG');
671: hr_utility.raise_error;

Line 668: if hr_message.get_token_value('COLUMN') = 'SEGMENT5' then

664: -- us segment 5
665: --
666: if p_territory_code = 'US' then
667: if hr_message.last_message_name = 'HR_FLEX_VALUE_INVALID' then
668: if hr_message.get_token_value('COLUMN') = 'SEGMENT5' then
669: if (length(p_segment5) > 60) then
670: hr_utility.set_message(801, 'HR_51463_EXA_US_BANK_NAME_LONG');
671: hr_utility.raise_error;
672: end if;

Line 681: if hr_message.last_message_name = 'HR_FLEX_VALUE_INVALID' then

677: --
678: -- us segment 6
679: --
680: if p_territory_code = 'US' then
681: if hr_message.last_message_name = 'HR_FLEX_VALUE_INVALID' then
682: if hr_message.get_token_value('COLUMN') = 'SEGMENT6' then
683: if (length(p_segment6) > 60) then
684: hr_utility.set_message(801, 'HR_51464_EXA_US_BANK_BRAN_LONG');
685: hr_utility.raise_error;

Line 682: if hr_message.get_token_value('COLUMN') = 'SEGMENT6' then

678: -- us segment 6
679: --
680: if p_territory_code = 'US' then
681: if hr_message.last_message_name = 'HR_FLEX_VALUE_INVALID' then
682: if hr_message.get_token_value('COLUMN') = 'SEGMENT6' then
683: if (length(p_segment6) > 60) then
684: hr_utility.set_message(801, 'HR_51464_EXA_US_BANK_BRAN_LONG');
685: hr_utility.raise_error;
686: end if;

Line 702: if hr_message.last_message_name = 'HR_FLEX_VALUE_INVALID' then

698: --
699: -- gb segment 1
700: --
701: if p_territory_code = 'GB' then
702: if hr_message.last_message_name = 'HR_FLEX_VALUE_INVALID' then
703: if hr_message.get_token_value('COLUMN') = 'SEGMENT1' then
704: if (length(p_segment1) > 30) then
705: hr_utility.set_message(801, 'HR_51416_EXA_BANK_NAME_LONG');
706: hr_utility.raise_error;

Line 703: if hr_message.get_token_value('COLUMN') = 'SEGMENT1' then

699: -- gb segment 1
700: --
701: if p_territory_code = 'GB' then
702: if hr_message.last_message_name = 'HR_FLEX_VALUE_INVALID' then
703: if hr_message.get_token_value('COLUMN') = 'SEGMENT1' then
704: if (length(p_segment1) > 30) then
705: hr_utility.set_message(801, 'HR_51416_EXA_BANK_NAME_LONG');
706: hr_utility.raise_error;
707: else

Line 738: if hr_message.last_message_name = 'HR_FLEX_VALUE_INVALID' then

734: --
735: -- gb segment 2
736: --
737: if p_territory_code = 'GB' then
738: if hr_message.last_message_name = 'HR_FLEX_VALUE_INVALID' then
739: if hr_message.get_token_value('COLUMN') = 'SEGMENT2' then
740: if (length(p_segment1) > 35) then
741: hr_utility.set_message(801, 'HR_51418_EXA_BANK_BRANCH_LONG');
742: hr_utility.raise_error;

Line 739: if hr_message.get_token_value('COLUMN') = 'SEGMENT2' then

735: -- gb segment 2
736: --
737: if p_territory_code = 'GB' then
738: if hr_message.last_message_name = 'HR_FLEX_VALUE_INVALID' then
739: if hr_message.get_token_value('COLUMN') = 'SEGMENT2' then
740: if (length(p_segment1) > 35) then
741: hr_utility.set_message(801, 'HR_51418_EXA_BANK_BRANCH_LONG');
742: hr_utility.raise_error;
743: end if;

Line 752: if hr_message.last_message_name = 'HR_FLEX_VALUE_INVALID' then

748: --
749: -- gb segment 3
750: --
751: if p_territory_code = 'GB' then
752: if hr_message.last_message_name = 'HR_FLEX_VALUE_INVALID' then
753: if hr_message.get_token_value('COLUMN') = 'SEGMENT3' then
754: --
755: -- ensure that the length is 6
756: --

Line 753: if hr_message.get_token_value('COLUMN') = 'SEGMENT3' then

749: -- gb segment 3
750: --
751: if p_territory_code = 'GB' then
752: if hr_message.last_message_name = 'HR_FLEX_VALUE_INVALID' then
753: if hr_message.get_token_value('COLUMN') = 'SEGMENT3' then
754: --
755: -- ensure that the length is 6
756: --
757: if (length(p_segment3) <> 6) then

Line 775: if hr_message.last_message_name = 'HR_FLEX_VALUE_INVALID' then

771: --
772: -- gb segment 4
773: --
774: if p_territory_code = 'GB' then
775: if hr_message.last_message_name = 'HR_FLEX_VALUE_INVALID' then
776: if hr_message.get_token_value('COLUMN') = 'SEGMENT4' then
777: --
778: -- ensure that the length is 8
779: --

Line 776: if hr_message.get_token_value('COLUMN') = 'SEGMENT4' then

772: -- gb segment 4
773: --
774: if p_territory_code = 'GB' then
775: if hr_message.last_message_name = 'HR_FLEX_VALUE_INVALID' then
776: if hr_message.get_token_value('COLUMN') = 'SEGMENT4' then
777: --
778: -- ensure that the length is 8
779: --
780: if (length(p_segment4) <> 8) then

Line 798: if hr_message.last_message_name = 'HR_FLEX_VALUE_INVALID' then

794: --
795: -- gb segment 5
796: --
797: if p_territory_code = 'GB' then
798: if hr_message.last_message_name = 'HR_FLEX_VALUE_INVALID' then
799: if hr_message.get_token_value('COLUMN') = 'SEGMENT5' then
800: --
801: -- ensure that the length does not exceed 18
802: --

Line 799: if hr_message.get_token_value('COLUMN') = 'SEGMENT5' then

795: -- gb segment 5
796: --
797: if p_territory_code = 'GB' then
798: if hr_message.last_message_name = 'HR_FLEX_VALUE_INVALID' then
799: if hr_message.get_token_value('COLUMN') = 'SEGMENT5' then
800: --
801: -- ensure that the length does not exceed 18
802: --
803: if (length(p_segment5) > 18) then

Line 821: if hr_message.last_message_name = 'HR_FLEX_VALUE_INVALID' then

817: --
818: -- gb segment 6
819: --
820: if p_territory_code = 'GB' then
821: if hr_message.last_message_name = 'HR_FLEX_VALUE_INVALID' then
822: if hr_message.get_token_value('COLUMN') = 'SEGMENT6' then
823: --
824: -- ensure that the length does not exceed 1
825: --

Line 822: if hr_message.get_token_value('COLUMN') = 'SEGMENT6' then

818: -- gb segment 6
819: --
820: if p_territory_code = 'GB' then
821: if hr_message.last_message_name = 'HR_FLEX_VALUE_INVALID' then
822: if hr_message.get_token_value('COLUMN') = 'SEGMENT6' then
823: --
824: -- ensure that the length does not exceed 1
825: --
826: if (length(p_segment6) > 1) then

Line 845: if hr_message.last_message_name = 'HR_FLEX_VALUE_INVALID' then

841: --
842: -- gb segment 7
843: --
844: if p_territory_code = 'GB' then
845: if hr_message.last_message_name = 'HR_FLEX_VALUE_INVALID' then
846: if hr_message.get_token_value('COLUMN') = 'SEGMENT7' then
847: --
848: -- ensure that the length does not exceed 18
849: --

Line 846: if hr_message.get_token_value('COLUMN') = 'SEGMENT7' then

842: -- gb segment 7
843: --
844: if p_territory_code = 'GB' then
845: if hr_message.last_message_name = 'HR_FLEX_VALUE_INVALID' then
846: if hr_message.get_token_value('COLUMN') = 'SEGMENT7' then
847: --
848: -- ensure that the length does not exceed 18
849: --
850: if (length(p_segment7) > 18) then

Line 868: if hr_message.last_message_name = 'HR_FLEX_VALUE_INVALID' then

864: --
865: -- gb segment 8
866: --
867: if p_territory_code = 'GB' then
868: if hr_message.last_message_name = 'HR_FLEX_VALUE_INVALID' then
869: if hr_message.get_token_value('COLUMN') = 'SEGMENT8' then
870: --
871: -- ensure that the length does not exceed 20
872: --

Line 869: if hr_message.get_token_value('COLUMN') = 'SEGMENT8' then

865: -- gb segment 8
866: --
867: if p_territory_code = 'GB' then
868: if hr_message.last_message_name = 'HR_FLEX_VALUE_INVALID' then
869: if hr_message.get_token_value('COLUMN') = 'SEGMENT8' then
870: --
871: -- ensure that the length does not exceed 20
872: --
873: if (length(p_segment8) > 20) then