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