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:
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
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,
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;
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;
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;
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
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;
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;
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;
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;
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;
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;
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;
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;
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;
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
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;
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;
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: --
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
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: --
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
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: --
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
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: --
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
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: --
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
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: --
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