639: --
640: -- This is only for Date upgrades, do not try Time masks.
641: --
642: IF (l_length = 8) THEN
643: l_date := fnd_date.string_to_date(p_char_in, g_mask_9_8);
644: ELSIF (l_length = 9) THEN
645: l_date := fnd_date.string_to_date(p_char_in, g_mask_9);
646: ELSIF (l_length = 10) THEN
647: l_date := fnd_date.string_to_date(p_char_in, g_mask_11_10);
641: --
642: IF (l_length = 8) THEN
643: l_date := fnd_date.string_to_date(p_char_in, g_mask_9_8);
644: ELSIF (l_length = 9) THEN
645: l_date := fnd_date.string_to_date(p_char_in, g_mask_9);
646: ELSIF (l_length = 10) THEN
647: l_date := fnd_date.string_to_date(p_char_in, g_mask_11_10);
648: ELSIF (l_length = 11) THEN
649: l_date := fnd_date.string_to_date(p_char_in, g_mask_11);
643: l_date := fnd_date.string_to_date(p_char_in, g_mask_9_8);
644: ELSIF (l_length = 9) THEN
645: l_date := fnd_date.string_to_date(p_char_in, g_mask_9);
646: ELSIF (l_length = 10) THEN
647: l_date := fnd_date.string_to_date(p_char_in, g_mask_11_10);
648: ELSIF (l_length = 11) THEN
649: l_date := fnd_date.string_to_date(p_char_in, g_mask_11);
650: ELSIF (l_length = 14) THEN
651: l_date := fnd_date.string_to_date(p_char_in, g_mask_15_14);
645: l_date := fnd_date.string_to_date(p_char_in, g_mask_9);
646: ELSIF (l_length = 10) THEN
647: l_date := fnd_date.string_to_date(p_char_in, g_mask_11_10);
648: ELSIF (l_length = 11) THEN
649: l_date := fnd_date.string_to_date(p_char_in, g_mask_11);
650: ELSIF (l_length = 14) THEN
651: l_date := fnd_date.string_to_date(p_char_in, g_mask_15_14);
652: ELSIF (l_length = 15) THEN
653: l_date := fnd_date.string_to_date(p_char_in, g_mask_15);
647: l_date := fnd_date.string_to_date(p_char_in, g_mask_11_10);
648: ELSIF (l_length = 11) THEN
649: l_date := fnd_date.string_to_date(p_char_in, g_mask_11);
650: ELSIF (l_length = 14) THEN
651: l_date := fnd_date.string_to_date(p_char_in, g_mask_15_14);
652: ELSIF (l_length = 15) THEN
653: l_date := fnd_date.string_to_date(p_char_in, g_mask_15);
654: ELSIF (l_length = 16) THEN
655: l_date := fnd_date.string_to_date(p_char_in, g_mask_17_16);
649: l_date := fnd_date.string_to_date(p_char_in, g_mask_11);
650: ELSIF (l_length = 14) THEN
651: l_date := fnd_date.string_to_date(p_char_in, g_mask_15_14);
652: ELSIF (l_length = 15) THEN
653: l_date := fnd_date.string_to_date(p_char_in, g_mask_15);
654: ELSIF (l_length = 16) THEN
655: l_date := fnd_date.string_to_date(p_char_in, g_mask_17_16);
656: ELSIF (l_length = 17) THEN
657: l_date := fnd_date.string_to_date(p_char_in, g_mask_17);
651: l_date := fnd_date.string_to_date(p_char_in, g_mask_15_14);
652: ELSIF (l_length = 15) THEN
653: l_date := fnd_date.string_to_date(p_char_in, g_mask_15);
654: ELSIF (l_length = 16) THEN
655: l_date := fnd_date.string_to_date(p_char_in, g_mask_17_16);
656: ELSIF (l_length = 17) THEN
657: l_date := fnd_date.string_to_date(p_char_in, g_mask_17);
658: IF (l_date IS NULL) THEN
659: l_date := fnd_date.string_to_date(p_char_in, g_mask_18_17);
653: l_date := fnd_date.string_to_date(p_char_in, g_mask_15);
654: ELSIF (l_length = 16) THEN
655: l_date := fnd_date.string_to_date(p_char_in, g_mask_17_16);
656: ELSIF (l_length = 17) THEN
657: l_date := fnd_date.string_to_date(p_char_in, g_mask_17);
658: IF (l_date IS NULL) THEN
659: l_date := fnd_date.string_to_date(p_char_in, g_mask_18_17);
660: END IF;
661: ELSIF (l_length = 18) THEN
655: l_date := fnd_date.string_to_date(p_char_in, g_mask_17_16);
656: ELSIF (l_length = 17) THEN
657: l_date := fnd_date.string_to_date(p_char_in, g_mask_17);
658: IF (l_date IS NULL) THEN
659: l_date := fnd_date.string_to_date(p_char_in, g_mask_18_17);
660: END IF;
661: ELSIF (l_length = 18) THEN
662: l_date := fnd_date.string_to_date(p_char_in, g_mask_18);
663: ELSIF (l_length = 19) THEN
658: IF (l_date IS NULL) THEN
659: l_date := fnd_date.string_to_date(p_char_in, g_mask_18_17);
660: END IF;
661: ELSIF (l_length = 18) THEN
662: l_date := fnd_date.string_to_date(p_char_in, g_mask_18);
663: ELSIF (l_length = 19) THEN
664: l_date := fnd_date.string_to_date(p_char_in, g_mask_19);
665: IF (l_date IS NULL) THEN
666: l_date := fnd_date.string_to_date(p_char_in, g_mask_20_19);
660: END IF;
661: ELSIF (l_length = 18) THEN
662: l_date := fnd_date.string_to_date(p_char_in, g_mask_18);
663: ELSIF (l_length = 19) THEN
664: l_date := fnd_date.string_to_date(p_char_in, g_mask_19);
665: IF (l_date IS NULL) THEN
666: l_date := fnd_date.string_to_date(p_char_in, g_mask_20_19);
667: END IF;
668: ELSIF (l_length = 20) THEN
662: l_date := fnd_date.string_to_date(p_char_in, g_mask_18);
663: ELSIF (l_length = 19) THEN
664: l_date := fnd_date.string_to_date(p_char_in, g_mask_19);
665: IF (l_date IS NULL) THEN
666: l_date := fnd_date.string_to_date(p_char_in, g_mask_20_19);
667: END IF;
668: ELSIF (l_length = 20) THEN
669: l_date := fnd_date.string_to_date(p_char_in, g_mask_20);
670: ELSE
665: IF (l_date IS NULL) THEN
666: l_date := fnd_date.string_to_date(p_char_in, g_mask_20_19);
667: END IF;
668: ELSIF (l_length = 20) THEN
669: l_date := fnd_date.string_to_date(p_char_in, g_mask_20);
670: ELSE
671: x_error :=
672: set_error(l_func_name,
673: 'Unknown length. Old Value : ''' ||