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 455: -- Function : is_to_standard_number

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

Line 476: FUNCTION is_to_standard_number(p_char_in IN VARCHAR2,

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

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

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

Line 618: END is_to_standard_number;

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

Line 622: -- Function : is_to_standard_date

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

Line 626: FUNCTION is_to_standard_date(p_char_in IN VARCHAR2,

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

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

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

Line 696: END is_to_standard_date;

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

Line 699: FUNCTION is_to_standard(p_mode IN VARCHAR2,

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

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

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

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

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

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

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

Line 724: END is_to_standard;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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