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.FND_FLEX_UPGRADE_UTILITIES dependencies on STANDARD

Line 191: /* Bug 3434427 Fixed warning for GSCC Standard. */

187: l_out_industry VARCHAR2(30);
188: l_out_oracle_schema VARCHAR2(30);
189: BEGIN
190:
191: /* Bug 3434427 Fixed warning for GSCC Standard. */
192: /* USed the function below to retrieve oracle_schema */
193: /* and then used it in the Where clause below. */
194: l_value :=FND_INSTALLATION.GET_APP_INFO (p_application_id,
195: l_out_status,

Line 453: -- Function : is_to_standard_number

449: RETURN(FALSE);
450: END set_nls_numeric_characters;
451:
452: -- ======================================================================
453: -- Function : is_to_standard_number
454: -- ======================================================================
455: -- Will be used to convert numbers. (Replace ',' with '.')
456: --
457: -- Error Cases :

Line 474: FUNCTION is_to_standard_number(p_char_in IN VARCHAR2,

470: -- multiple ERROR : value stays same
471: -- 'XXXXXX' 'XXXX.XX'
472: --
473: --
474: FUNCTION is_to_standard_number(p_char_in IN VARCHAR2,
475: x_char_out OUT nocopy VARCHAR2,
476: x_error OUT nocopy VARCHAR2)
477: RETURN BOOLEAN
478: IS

Line 614: x_error := 'is_to_standard_number:Exception : ' || Sqlerrm;

610: RETURN TRUE;
611: EXCEPTION
612: WHEN OTHERS THEN
613: x_char_out := p_char_in;
614: x_error := 'is_to_standard_number:Exception : ' || Sqlerrm;
615: RETURN FALSE;
616: END is_to_standard_number;
617:
618:

Line 616: END is_to_standard_number;

612: WHEN OTHERS THEN
613: x_char_out := p_char_in;
614: x_error := 'is_to_standard_number:Exception : ' || Sqlerrm;
615: RETURN FALSE;
616: END is_to_standard_number;
617:
618:
619: -- ======================================================================
620: -- Function : is_to_standard_date

Line 620: -- Function : is_to_standard_date

616: END is_to_standard_number;
617:
618:
619: -- ======================================================================
620: -- Function : is_to_standard_date
621: -- ======================================================================
622: -- Will be used to convert dates.
623: --
624: FUNCTION is_to_standard_date(p_char_in IN VARCHAR2,

Line 624: FUNCTION is_to_standard_date(p_char_in IN VARCHAR2,

620: -- Function : is_to_standard_date
621: -- ======================================================================
622: -- Will be used to convert dates.
623: --
624: FUNCTION is_to_standard_date(p_char_in IN VARCHAR2,
625: x_char_out OUT nocopy VARCHAR2,
626: x_error OUT nocopy VARCHAR2)
627: RETURN BOOLEAN
628: IS

Line 630: l_func_name VARCHAR2(80) := g_package_name || 'is_to_standard_date';

626: x_error OUT nocopy VARCHAR2)
627: RETURN BOOLEAN
628: IS
629: l_length NUMBER;
630: l_func_name VARCHAR2(80) := g_package_name || 'is_to_standard_date';
631: l_date DATE;
632: BEGIN
633: x_char_out := p_char_in;
634: l_length := Nvl(Length(p_char_in), 0);

Line 694: END is_to_standard_date;

690: set_error(l_func_name,
691: 'Top Level Exception. Old value : ''' ||
692: p_char_in || '''', Sqlerrm);
693: RETURN(FALSE);
694: END is_to_standard_date;
695:
696: -- --------------------------------------------------
697: FUNCTION is_to_standard(p_mode IN VARCHAR2,
698: p_char_in IN VARCHAR2,

Line 697: FUNCTION is_to_standard(p_mode IN VARCHAR2,

693: RETURN(FALSE);
694: END is_to_standard_date;
695:
696: -- --------------------------------------------------
697: FUNCTION is_to_standard(p_mode IN VARCHAR2,
698: p_char_in IN VARCHAR2,
699: x_char_out OUT nocopy VARCHAR2,
700: x_error OUT nocopy VARCHAR2)
701: RETURN BOOLEAN

Line 703: l_func_name VARCHAR2(80) := g_package_name || 'is_to_standard';

699: x_char_out OUT nocopy VARCHAR2,
700: x_error OUT nocopy VARCHAR2)
701: RETURN BOOLEAN
702: IS
703: l_func_name VARCHAR2(80) := g_package_name || 'is_to_standard';
704: BEGIN
705: IF (p_mode = g_number_mode) THEN
706: RETURN(is_to_standard_number(p_char_in, x_char_out, x_error));
707: ELSIF (p_mode = g_date_mode OR

Line 706: RETURN(is_to_standard_number(p_char_in, x_char_out, x_error));

702: IS
703: l_func_name VARCHAR2(80) := g_package_name || 'is_to_standard';
704: BEGIN
705: IF (p_mode = g_number_mode) THEN
706: RETURN(is_to_standard_number(p_char_in, x_char_out, x_error));
707: ELSIF (p_mode = g_date_mode OR
708: p_mode = g_datetime_mode) THEN
709: RETURN(is_to_standard_date(p_char_in, x_char_out, x_error));
710: ELSE

Line 709: RETURN(is_to_standard_date(p_char_in, x_char_out, x_error));

705: IF (p_mode = g_number_mode) THEN
706: RETURN(is_to_standard_number(p_char_in, x_char_out, x_error));
707: ELSIF (p_mode = g_date_mode OR
708: p_mode = g_datetime_mode) THEN
709: RETURN(is_to_standard_date(p_char_in, x_char_out, x_error));
710: ELSE
711: x_error := set_error(l_func_name,
712: 'Unknown Mode : ' || p_mode ,
713: NULL);

Line 722: END is_to_standard;

718: x_error := set_error(l_func_name,
719: 'Top Level Exception.',
720: Sqlerrm);
721: RETURN(FALSE);
722: END is_to_standard;
723:
724:
725: -- ======================================================================
726: -- MESSAGE

Line 931: IF (NOT is_to_standard_date(l_old_vset_rec.minimum_value,

927:
928: --
929: -- New minimum_value, maximum_value and dependant_default_value.
930: --
931: IF (NOT is_to_standard_date(l_old_vset_rec.minimum_value,
932: l_minimum_value, l_error)) THEN
933: message(l_error);
934: message(l_func_name || chr_newline ||
935: 'Minimum Value is not in proper format.' || chr_newline ||

Line 940: IF (NOT is_to_standard_date(l_old_vset_rec.maximum_value,

936: 'Minimum Value : '||l_old_vset_rec.minimum_value||chr_newline ||
937: 'It is set to NULL');
938: l_minimum_value := NULL;
939: END IF;
940: IF (NOT is_to_standard_date(l_old_vset_rec.maximum_value,
941: l_maximum_value, l_error)) THEN
942: message(l_error);
943: message(l_func_name || chr_newline ||
944: 'Maximum Value is not in proper format.' || chr_newline ||

Line 953: IF (NOT is_to_standard_date(l_old_vset_rec.dependant_default_value,

949:
950: l_dependant_default_value := l_old_vset_rec.dependant_default_value;
951: l_dependant_default_meaning := l_old_vset_rec.dependant_default_meaning;
952: IF (l_old_vset_rec.validation_type = 'D') THEN
953: IF (NOT is_to_standard_date(l_old_vset_rec.dependant_default_value,
954: l_dependant_default_value, l_error)) THEN
955: --
956: -- dependant_default_value is required, set it to something.
957: --

Line 1334: message('To value set must be standard type Date or Date/Time.');

1330: END IF;
1331: debug('to_value_set_id : ' || To_char(l_new_vset_rec.flex_value_set_id));
1332:
1333: IF (NOT (l_new_vset_rec.format_type IN ('X', 'Y'))) THEN
1334: message('To value set must be standard type Date or Date/Time.');
1335: RETURN(g_ret_critical_error);
1336: END IF;
1337:
1338: --

Line 1365: IF (NOT is_to_standard_date(srs_rec.default_value,

1361: srs_rec.descriptive_flex_context_code || ':' ||
1362: srs_rec.end_user_column_name);
1363: l_default_value := srs_rec.default_value;
1364: IF (srs_rec.default_type = 'C') THEN
1365: IF (NOT is_to_standard_date(srs_rec.default_value,
1366: l_default_value, l_error)) THEN
1367: --
1368: -- If type is constant then default_value is required,
1369: -- set it to something.

Line 1518: message('To value set must be standard type Date or Date/Time.');

1514: END IF;
1515: debug('to_value_set_id : ' || To_char(l_new_vset_rec.flex_value_set_id));
1516:
1517: IF (NOT (l_new_vset_rec.format_type IN ('X', 'Y'))) THEN
1518: message('To value set must be standard type Date or Date/Time.');
1519: RETURN(g_ret_critical_error);
1520: END IF;
1521:
1522: --

Line 1550: IF (NOT is_to_standard_date(dff_rec.default_value,

1546: dff_rec.descriptive_flex_context_code || ':' ||
1547: dff_rec.end_user_column_name);
1548: l_default_value := dff_rec.default_value;
1549: IF (dff_rec.default_type = 'C') THEN
1550: IF (NOT is_to_standard_date(dff_rec.default_value,
1551: l_default_value, l_error)) THEN
1552: --
1553: -- If type is constant then default_value is required,
1554: -- set it to something.

Line 1706: message('To value set must be standard type Date or Date/Time.');

1702: END IF;
1703: debug('to_value_set_id : ' || To_char(l_new_vset_rec.flex_value_set_id));
1704:
1705: IF (NOT (l_new_vset_rec.format_type IN ('X', 'Y'))) THEN
1706: message('To value set must be standard type Date or Date/Time.');
1707: RETURN(g_ret_critical_error);
1708: END IF;
1709:
1710:

Line 1741: IF (NOT is_to_standard_date(kff_rec.default_value,

1737: kff_rec.id_flex_structure_name || ':' ||
1738: kff_rec.segment_name);
1739: l_default_value := kff_rec.default_value;
1740: IF (kff_rec.default_type = 'C') THEN
1741: IF (NOT is_to_standard_date(kff_rec.default_value,
1742: l_default_value, l_error)) THEN
1743: --
1744: -- If type is constant then default_value is required,
1745: -- set it to something.

Line 2171: IF (NOT is_to_standard(p_mode, l_value_old,

2167: LOOP
2168: FETCH select_cursor INTO l_rowid, l_value_old;
2169: EXIT WHEN select_cursor%NOTFOUND;
2170:
2171: IF (NOT is_to_standard(p_mode, l_value_old,
2172: l_value_new, l_error)) THEN
2173: cp_debug('ERROR: ' || l_error || chr_newline ||
2174: 'ROWID: ' || l_rowid || chr_newline ||
2175: 'VALUE: ''' || l_value_old || '''');

Line 2378: IF (NOT is_to_standard(p_mode, vset_rec.minimum_value,

2374: g_cp_indent := g_cp_indent + 5;
2375: --
2376: -- Update minimum, maximum, and dependant_default_value
2377: --
2378: IF (NOT is_to_standard(p_mode, vset_rec.minimum_value,
2379: l_vc2_tmp1, l_error)) THEN
2380: cp_debug('ERROR: VSET.MINIMUM_VALUE :' ||
2381: vset_rec.minimum_value || ': ' || l_error);
2382: END IF;

Line 2384: IF (NOT is_to_standard(p_mode, vset_rec.maximum_value,

2380: cp_debug('ERROR: VSET.MINIMUM_VALUE :' ||
2381: vset_rec.minimum_value || ': ' || l_error);
2382: END IF;
2383:
2384: IF (NOT is_to_standard(p_mode, vset_rec.maximum_value,
2385: l_vc2_tmp2, l_error)) THEN
2386: cp_debug('ERROR: VSET.MAXIMUM_VALUE :' ||
2387: vset_rec.maximum_value || ': ' || l_error);
2388: END IF;

Line 2390: IF (NOT is_to_standard(p_mode, vset_rec.dependant_default_value,

2386: cp_debug('ERROR: VSET.MAXIMUM_VALUE :' ||
2387: vset_rec.maximum_value || ': ' || l_error);
2388: END IF;
2389:
2390: IF (NOT is_to_standard(p_mode, vset_rec.dependant_default_value,
2391: l_vc2_tmp3, l_error)) THEN
2392: cp_debug('ERROR: VSET.DEPENDANT_DEFAULT_VALUE :' ||
2393: vset_rec.dependant_default_value || ': ' || l_error);
2394: END IF;

Line 2505: IF (NOT is_to_standard(p_mode, val_rec.flex_value,

2501: l_rows_count := 0;
2502: l_upg_count := 0;
2503: FOR val_rec IN val_cur(vset_rec.flex_value_set_id) LOOP
2504: l_rows_count := l_rows_count + 1;
2505: IF (NOT is_to_standard(p_mode, val_rec.flex_value,
2506: l_vc2_tmp1, l_error)) THEN
2507: cp_debug('ERROR: VAL.FLEX_VALUE :' ||
2508: val_rec.flex_value || ': ' || l_error);
2509: END IF;

Line 2539: IF (NOT is_to_standard(p_mode, nhier_rec.parent_flex_value,

2535: l_rows_count := 0;
2536: l_upg_count := 0;
2537: FOR nhier_rec IN nhier_cur(vset_rec.flex_value_set_id) LOOP
2538: l_rows_count := l_rows_count + 1;
2539: IF (NOT is_to_standard(p_mode, nhier_rec.parent_flex_value,
2540: l_vc2_tmp1, l_error)) THEN
2541: cp_debug('ERROR: NHIER.PARENT_FLEX_VALUE :' ||
2542: nhier_rec.parent_flex_value || ': ' || l_error);
2543: END IF;

Line 2544: IF (NOT is_to_standard(p_mode, nhier_rec.child_flex_value_low,

2540: l_vc2_tmp1, l_error)) THEN
2541: cp_debug('ERROR: NHIER.PARENT_FLEX_VALUE :' ||
2542: nhier_rec.parent_flex_value || ': ' || l_error);
2543: END IF;
2544: IF (NOT is_to_standard(p_mode, nhier_rec.child_flex_value_low,
2545: l_vc2_tmp2, l_error)) THEN
2546: cp_debug('ERROR: NHIER.CHILD_FLEX_VALUE_LOW :' ||
2547: nhier_rec.child_flex_value_low || ': ' || l_error);
2548: END IF;

Line 2549: IF (NOT is_to_standard(p_mode, nhier_rec.child_flex_value_high,

2545: l_vc2_tmp2, l_error)) THEN
2546: cp_debug('ERROR: NHIER.CHILD_FLEX_VALUE_LOW :' ||
2547: nhier_rec.child_flex_value_low || ': ' || l_error);
2548: END IF;
2549: IF (NOT is_to_standard(p_mode, nhier_rec.child_flex_value_high,
2550: l_vc2_tmp3, l_error)) THEN
2551: cp_debug('ERROR: NHIER.CHILD_FLEX_VALUE_HIGH :' ||
2552: nhier_rec.child_flex_value_high || ': ' || l_error);
2553: END IF;

Line 2588: IF (NOT is_to_standard(p_mode, hier_rec.parent_flex_value,

2584: l_rows_count := 0;
2585: l_upg_count := 0;
2586: FOR hier_rec IN hier_cur(vset_rec.flex_value_set_id) LOOP
2587: l_rows_count := l_rows_count + 1;
2588: IF (NOT is_to_standard(p_mode, hier_rec.parent_flex_value,
2589: l_vc2_tmp1, l_error)) THEN
2590: cp_debug('ERROR: HIER.PARENT_FLEX_VALUE :' ||
2591: hier_rec.parent_flex_value || ': ' || l_error);
2592: END IF;

Line 2593: IF (NOT is_to_standard(p_mode, hier_rec.child_flex_value_low,

2589: l_vc2_tmp1, l_error)) THEN
2590: cp_debug('ERROR: HIER.PARENT_FLEX_VALUE :' ||
2591: hier_rec.parent_flex_value || ': ' || l_error);
2592: END IF;
2593: IF (NOT is_to_standard(p_mode, hier_rec.child_flex_value_low,
2594: l_vc2_tmp2, l_error)) THEN
2595: cp_debug('ERROR: HIER.CHILD_FLEX_VALUE_LOW :' ||
2596: hier_rec.child_flex_value_low || ': ' || l_error);
2597: END IF;

Line 2598: IF (NOT is_to_standard(p_mode, hier_rec.child_flex_value_high,

2594: l_vc2_tmp2, l_error)) THEN
2595: cp_debug('ERROR: HIER.CHILD_FLEX_VALUE_LOW :' ||
2596: hier_rec.child_flex_value_low || ': ' || l_error);
2597: END IF;
2598: IF (NOT is_to_standard(p_mode, hier_rec.child_flex_value_high,
2599: l_vc2_tmp3, l_error)) THEN
2600: cp_debug('ERROR: HIER.CHILD_FLEX_VALUE_HIGH :' ||
2601: hier_rec.child_flex_value_high || ': ' || l_error);
2602: END IF;

Line 2645: IF (NOT is_to_standard(p_mode, par_rec.parent_flex_value_low,

2641: l_rows_count := 0;
2642: l_upg_count := 0;
2643: FOR par_rec IN par_cur(vset_rec.flex_value_set_id) LOOP
2644: l_rows_count := l_rows_count + 1;
2645: IF (NOT is_to_standard(p_mode, par_rec.parent_flex_value_low,
2646: l_vc2_tmp1, l_error)) THEN
2647: cp_debug('ERROR: PAR.PARENT_FLEX_VALUE_LOW :' ||
2648: par_rec.parent_flex_value_low || ': ' || l_error);
2649: END IF;

Line 2716: IF (NOT is_to_standard(p_mode, dff_rec.default_value,

2712: dff_rec.end_user_column_name);
2713: g_cp_indent := g_cp_indent + 5;
2714:
2715: IF (dff_rec.default_type = 'C') THEN
2716: IF (NOT is_to_standard(p_mode, dff_rec.default_value,
2717: l_vc2_tmp1, l_error)) THEN
2718: cp_debug('ERROR: DFF.DEFAULT_VALUE :' ||
2719: dff_rec.default_value || ': ' || l_error);
2720: END IF;

Line 2876: IF (NOT is_to_standard(p_mode, kff_rec.default_value,

2872: kff_rec.segment_name);
2873: g_cp_indent := g_cp_indent + 5;
2874:
2875: IF (kff_rec.default_type = 'C') THEN
2876: IF (NOT is_to_standard(p_mode, kff_rec.default_value,
2877: l_vc2_tmp1, l_error)) THEN
2878: cp_debug('ERROR: KFF.DEFAULT_VALUE :' ||
2879: kff_rec.default_value || ': ' || l_error);
2880: END IF;

Line 3282: cp_debug('Upgrading All Standard Date and Standard DateTime Value Sets.');

3278: ' FROM fnd_flex_value_sets ' ||
3279: ' WHERE format_type IN (''X'', ''Y'')');
3280: BEGIN
3281: internal_init;
3282: cp_debug('Upgrading All Standard Date and Standard DateTime Value Sets.');
3283: cp_debug(' ');
3284:
3285: cp_init('SESSION_MODE','customer_data');
3286:

Line 3291: p_sub_description => 'Flexfields Upgrade One Standard Date or Standard Date Time Value Set.',

3287: cp_srs_upgrade_all_private
3288: (errbuf => errbuf,
3289: retcode => retcode,
3290: p_sub_program => 'FNDFFUPG_DATE_ONE',
3291: p_sub_description => 'Flexfields Upgrade One Standard Date or Standard Date Time Value Set.',
3292: p_sql_select => l_sql );
3293: EXCEPTION
3294: WHEN OTHERS THEN
3295: retcode := 2;

Line 3368: -- Upgrades One Standard Date Value Set. (called from SRS.)

3364:
3365: -- ======================================================================
3366: -- Procedure : cp_srs_upgrade_date_one
3367: -- ======================================================================
3368: -- Upgrades One Standard Date Value Set. (called from SRS.)
3369: --
3370: PROCEDURE cp_srs_upgrade_date_one(errbuf OUT nocopy VARCHAR2,
3371: retcode OUT nocopy VARCHAR2,
3372: p_flex_value_set_name IN VARCHAR2)

Line 3376: cp_debug('Upgrading One Standard Date or Standard DateTime Value Set.');

3372: p_flex_value_set_name IN VARCHAR2)
3373: IS
3374: BEGIN
3375: internal_init;
3376: cp_debug('Upgrading One Standard Date or Standard DateTime Value Set.');
3377: cp_debug(' ');
3378:
3379: cp_init('SESSION_MODE','customer_data');
3380:

Line 3750: 'sets to Standard Date or Standard DateTime value set. ' ||

3746: 4, Decode
3747: (p_step,
3748: 0, ('-- Clone a value set: ' ||
3749: 'You are about to clone one of the Date or DateTime value ' ||
3750: 'sets to Standard Date or Standard DateTime value set. ' ||
3751: 'We recommend you use _STANDARD as a ' ||
3752: 'new name for your value set. ' ||
3753: 'You will be asked to enter 6 inputs. ' ||
3754: 'Please ignore the last 4 of them.'),

Line 3751: 'We recommend you use _STANDARD as a ' ||

3747: (p_step,
3748: 0, ('-- Clone a value set: ' ||
3749: 'You are about to clone one of the Date or DateTime value ' ||
3750: 'sets to Standard Date or Standard DateTime value set. ' ||
3751: 'We recommend you use _STANDARD as a ' ||
3752: 'new name for your value set. ' ||
3753: 'You will be asked to enter 6 inputs. ' ||
3754: 'Please ignore the last 4 of them.'),
3755: 1, 'Please enter the old value set name :',

Line 3763: 'replaced with Standard Date or Standard DateTime value sets. ' ||

3759: (p_step,
3760: 0, ('-- Upgrade Report Parameters: ' ||
3761: 'You are about to upgrade report parameters which use ' ||
3762: 'Date or DateTime value sets, and these value sets will be ' ||
3763: 'replaced with Standard Date or Standard DateTime value sets. ' ||
3764: 'By using a % sign in the report name, you can upgrade multiple ' ||
3765: 'report parameters. ' ||
3766: 'You will be asked to enter 6 inputs. ' ||
3767: 'Please ignore the last 2 of them.'),

Line 3778: 'replaced with Standard Date or Standard DateTime value sets. ' ||

3774: (p_step,
3775: 0, ('-- Upgrade Descriptive Flexfield Segments: ' ||
3776: 'You are about to upgrade descriptive flexfield segments which ' ||
3777: 'use Date or DateTime value sets, and these value sets will be ' ||
3778: 'replaced with Standard Date or Standard DateTime value sets. ' ||
3779: 'By using a % sign in the descriptive flexfield name, or context ' ||
3780: 'code, you can upgrade multiple descriptive flexfields and/or ' ||
3781: 'contexts. ' ||
3782: 'You will be asked to enter 6 inputs. ' ||

Line 3795: 'replaced with Standard Date or Standard DateTime value sets. ' ||

3791: (p_step,
3792: 0, ('-- Upgrade Key Flexfield Segments: ' ||
3793: 'You are about to upgrade key flexfield segments which use ' ||
3794: 'Date or DateTime value sets, and these value sets will be ' ||
3795: 'replaced with Standard Date or Standard DateTime value sets. ' ||
3796: 'By using a % sign in the structure number or structure name ' ||
3797: 'you can upgrade multiple key flexfield structures. ' ||
3798: 'You will be asked to enter 6 inputs.'),
3799: 1, 'Please enter the application short name :',