DBA Data[Home] [Help]

APPS.FND_FLEX_UPGRADE_UTILITIES dependencies on FND_DATE

Line 643: l_date := fnd_date.string_to_date(p_char_in, g_mask_9_8);

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);

Line 645: l_date := fnd_date.string_to_date(p_char_in, g_mask_9);

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);

Line 647: l_date := fnd_date.string_to_date(p_char_in, g_mask_11_10);

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);

Line 649: 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);
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);

Line 651: 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_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);

Line 653: 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);
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);

Line 655: 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_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);

Line 657: 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);
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

Line 659: 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_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

Line 662: l_date := fnd_date.string_to_date(p_char_in, g_mask_18);

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);

Line 664: l_date := fnd_date.string_to_date(p_char_in, g_mask_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

Line 666: l_date := fnd_date.string_to_date(p_char_in, g_mask_20_19);

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

Line 669: l_date := fnd_date.string_to_date(p_char_in, g_mask_20);

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 : ''' ||