2288:
2289: l_base_display_code := TO_CHAR(l_hier_info(l_counter).hier_id) || ': ' || l_data_type_name;
2290: l_analyze_display_code := l_hier_info(l_counter).hier_name || ': ' || l_data_type_name;
2291:
2292: fnd_message.set_name('GCS', 'GCS_HIER_NEW_DATASET_DESC');
2293: fnd_message.set_token('HIER_NAME', l_hier_info(l_counter).hier_name);
2294: fnd_message.set_token('BAL_TYPE', l_base_balance_type);
2295: l_base_description := fnd_message.get;
2296: fnd_message.set_name('GCS', 'GCS_HIER_NEW_DATASET_DESC');
2289: l_base_display_code := TO_CHAR(l_hier_info(l_counter).hier_id) || ': ' || l_data_type_name;
2290: l_analyze_display_code := l_hier_info(l_counter).hier_name || ': ' || l_data_type_name;
2291:
2292: fnd_message.set_name('GCS', 'GCS_HIER_NEW_DATASET_DESC');
2293: fnd_message.set_token('HIER_NAME', l_hier_info(l_counter).hier_name);
2294: fnd_message.set_token('BAL_TYPE', l_base_balance_type);
2295: l_base_description := fnd_message.get;
2296: fnd_message.set_name('GCS', 'GCS_HIER_NEW_DATASET_DESC');
2297: fnd_message.set_token('HIER_NAME', l_hier_info(l_counter).hier_name);
2290: l_analyze_display_code := l_hier_info(l_counter).hier_name || ': ' || l_data_type_name;
2291:
2292: fnd_message.set_name('GCS', 'GCS_HIER_NEW_DATASET_DESC');
2293: fnd_message.set_token('HIER_NAME', l_hier_info(l_counter).hier_name);
2294: fnd_message.set_token('BAL_TYPE', l_base_balance_type);
2295: l_base_description := fnd_message.get;
2296: fnd_message.set_name('GCS', 'GCS_HIER_NEW_DATASET_DESC');
2297: fnd_message.set_token('HIER_NAME', l_hier_info(l_counter).hier_name);
2298: fnd_message.set_token('BAL_TYPE', l_analyze_balance_type);
2291:
2292: fnd_message.set_name('GCS', 'GCS_HIER_NEW_DATASET_DESC');
2293: fnd_message.set_token('HIER_NAME', l_hier_info(l_counter).hier_name);
2294: fnd_message.set_token('BAL_TYPE', l_base_balance_type);
2295: l_base_description := fnd_message.get;
2296: fnd_message.set_name('GCS', 'GCS_HIER_NEW_DATASET_DESC');
2297: fnd_message.set_token('HIER_NAME', l_hier_info(l_counter).hier_name);
2298: fnd_message.set_token('BAL_TYPE', l_analyze_balance_type);
2299: l_analyze_description := fnd_message.get;
2292: fnd_message.set_name('GCS', 'GCS_HIER_NEW_DATASET_DESC');
2293: fnd_message.set_token('HIER_NAME', l_hier_info(l_counter).hier_name);
2294: fnd_message.set_token('BAL_TYPE', l_base_balance_type);
2295: l_base_description := fnd_message.get;
2296: fnd_message.set_name('GCS', 'GCS_HIER_NEW_DATASET_DESC');
2297: fnd_message.set_token('HIER_NAME', l_hier_info(l_counter).hier_name);
2298: fnd_message.set_token('BAL_TYPE', l_analyze_balance_type);
2299: l_analyze_description := fnd_message.get;
2300:
2293: fnd_message.set_token('HIER_NAME', l_hier_info(l_counter).hier_name);
2294: fnd_message.set_token('BAL_TYPE', l_base_balance_type);
2295: l_base_description := fnd_message.get;
2296: fnd_message.set_name('GCS', 'GCS_HIER_NEW_DATASET_DESC');
2297: fnd_message.set_token('HIER_NAME', l_hier_info(l_counter).hier_name);
2298: fnd_message.set_token('BAL_TYPE', l_analyze_balance_type);
2299: l_analyze_description := fnd_message.get;
2300:
2301: -- Create a dataset for the base balance type
2294: fnd_message.set_token('BAL_TYPE', l_base_balance_type);
2295: l_base_description := fnd_message.get;
2296: fnd_message.set_name('GCS', 'GCS_HIER_NEW_DATASET_DESC');
2297: fnd_message.set_token('HIER_NAME', l_hier_info(l_counter).hier_name);
2298: fnd_message.set_token('BAL_TYPE', l_analyze_balance_type);
2299: l_analyze_description := fnd_message.get;
2300:
2301: -- Create a dataset for the base balance type
2302: FEM_DIMENSION_UTIL_PKG.new_dataset(x_err_code => l_base_err_code,
2295: l_base_description := fnd_message.get;
2296: fnd_message.set_name('GCS', 'GCS_HIER_NEW_DATASET_DESC');
2297: fnd_message.set_token('HIER_NAME', l_hier_info(l_counter).hier_name);
2298: fnd_message.set_token('BAL_TYPE', l_analyze_balance_type);
2299: l_analyze_description := fnd_message.get;
2300:
2301: -- Create a dataset for the base balance type
2302: FEM_DIMENSION_UTIL_PKG.new_dataset(x_err_code => l_base_err_code,
2303: x_num_msg => l_base_num_msg,
2487: AND fda.attribute_id = gcs_utility_pkg.get_dimension_attribute('DATASET_CODE-ENCUMBRANCE_TYPE_ID')
2488: AND fda.dataset_code = l_dataset_code;
2489: END IF;
2490:
2491: fnd_message.set_name('GCS', 'GCS_HIER_NEW_DATASET_DESC');
2492: fnd_message.set_token('HIER_NAME', l_hierarchy_name);
2493: fnd_message.set_token('BAL_TYPE', l_base_balance_type);
2494: l_base_description := fnd_message.get;
2495: fnd_message.set_name('GCS', 'GCS_HIER_NEW_DATASET_DESC');
2488: AND fda.dataset_code = l_dataset_code;
2489: END IF;
2490:
2491: fnd_message.set_name('GCS', 'GCS_HIER_NEW_DATASET_DESC');
2492: fnd_message.set_token('HIER_NAME', l_hierarchy_name);
2493: fnd_message.set_token('BAL_TYPE', l_base_balance_type);
2494: l_base_description := fnd_message.get;
2495: fnd_message.set_name('GCS', 'GCS_HIER_NEW_DATASET_DESC');
2496: fnd_message.set_token('HIER_NAME', l_hierarchy_name);
2489: END IF;
2490:
2491: fnd_message.set_name('GCS', 'GCS_HIER_NEW_DATASET_DESC');
2492: fnd_message.set_token('HIER_NAME', l_hierarchy_name);
2493: fnd_message.set_token('BAL_TYPE', l_base_balance_type);
2494: l_base_description := fnd_message.get;
2495: fnd_message.set_name('GCS', 'GCS_HIER_NEW_DATASET_DESC');
2496: fnd_message.set_token('HIER_NAME', l_hierarchy_name);
2497: fnd_message.set_token('BAL_TYPE', l_analyze_balance_type);
2490:
2491: fnd_message.set_name('GCS', 'GCS_HIER_NEW_DATASET_DESC');
2492: fnd_message.set_token('HIER_NAME', l_hierarchy_name);
2493: fnd_message.set_token('BAL_TYPE', l_base_balance_type);
2494: l_base_description := fnd_message.get;
2495: fnd_message.set_name('GCS', 'GCS_HIER_NEW_DATASET_DESC');
2496: fnd_message.set_token('HIER_NAME', l_hierarchy_name);
2497: fnd_message.set_token('BAL_TYPE', l_analyze_balance_type);
2498: l_analyze_description := fnd_message.get;
2491: fnd_message.set_name('GCS', 'GCS_HIER_NEW_DATASET_DESC');
2492: fnd_message.set_token('HIER_NAME', l_hierarchy_name);
2493: fnd_message.set_token('BAL_TYPE', l_base_balance_type);
2494: l_base_description := fnd_message.get;
2495: fnd_message.set_name('GCS', 'GCS_HIER_NEW_DATASET_DESC');
2496: fnd_message.set_token('HIER_NAME', l_hierarchy_name);
2497: fnd_message.set_token('BAL_TYPE', l_analyze_balance_type);
2498: l_analyze_description := fnd_message.get;
2499:
2492: fnd_message.set_token('HIER_NAME', l_hierarchy_name);
2493: fnd_message.set_token('BAL_TYPE', l_base_balance_type);
2494: l_base_description := fnd_message.get;
2495: fnd_message.set_name('GCS', 'GCS_HIER_NEW_DATASET_DESC');
2496: fnd_message.set_token('HIER_NAME', l_hierarchy_name);
2497: fnd_message.set_token('BAL_TYPE', l_analyze_balance_type);
2498: l_analyze_description := fnd_message.get;
2499:
2500: -- Create a dataset for the base balance type
2493: fnd_message.set_token('BAL_TYPE', l_base_balance_type);
2494: l_base_description := fnd_message.get;
2495: fnd_message.set_name('GCS', 'GCS_HIER_NEW_DATASET_DESC');
2496: fnd_message.set_token('HIER_NAME', l_hierarchy_name);
2497: fnd_message.set_token('BAL_TYPE', l_analyze_balance_type);
2498: l_analyze_description := fnd_message.get;
2499:
2500: -- Create a dataset for the base balance type
2501: FEM_DIMENSION_UTIL_PKG.new_dataset(x_err_code => l_base_err_code,
2494: l_base_description := fnd_message.get;
2495: fnd_message.set_name('GCS', 'GCS_HIER_NEW_DATASET_DESC');
2496: fnd_message.set_token('HIER_NAME', l_hierarchy_name);
2497: fnd_message.set_token('BAL_TYPE', l_analyze_balance_type);
2498: l_analyze_description := fnd_message.get;
2499:
2500: -- Create a dataset for the base balance type
2501: FEM_DIMENSION_UTIL_PKG.new_dataset(x_err_code => l_base_err_code,
2502: x_num_msg => l_base_num_msg,
2642: ELSE
2643: l_display_code := TO_CHAR(p_hierarchy_id) || ': ' || l_data_type_name;
2644: END IF;
2645:
2646: fnd_message.set_name('GCS', 'GCS_HIER_NEW_DATASET_DESC');
2647: fnd_message.set_token('HIER_NAME', l_hierarchy_name);
2648: fnd_message.set_token('BAL_TYPE', l_balance_type);
2649: l_description := fnd_message.get;
2650:
2643: l_display_code := TO_CHAR(p_hierarchy_id) || ': ' || l_data_type_name;
2644: END IF;
2645:
2646: fnd_message.set_name('GCS', 'GCS_HIER_NEW_DATASET_DESC');
2647: fnd_message.set_token('HIER_NAME', l_hierarchy_name);
2648: fnd_message.set_token('BAL_TYPE', l_balance_type);
2649: l_description := fnd_message.get;
2650:
2651: UPDATE fem_datasets_b
2644: END IF;
2645:
2646: fnd_message.set_name('GCS', 'GCS_HIER_NEW_DATASET_DESC');
2647: fnd_message.set_token('HIER_NAME', l_hierarchy_name);
2648: fnd_message.set_token('BAL_TYPE', l_balance_type);
2649: l_description := fnd_message.get;
2650:
2651: UPDATE fem_datasets_b
2652: SET dataset_display_code = l_display_code
2645:
2646: fnd_message.set_name('GCS', 'GCS_HIER_NEW_DATASET_DESC');
2647: fnd_message.set_token('HIER_NAME', l_hierarchy_name);
2648: fnd_message.set_token('BAL_TYPE', l_balance_type);
2649: l_description := fnd_message.get;
2650:
2651: UPDATE fem_datasets_b
2652: SET dataset_display_code = l_display_code
2653: WHERE dataset_code = l_dataset_code;
2661: END IF;
2662:
2663: -- Update the fem_ledgers_b/tl tables accordingly by setting proper Ledger Name and Description
2664:
2665: fnd_message.set_name('GCS', 'GCS_HIER_NEW_LEDGER_NAME');
2666: fnd_message.set_token('HIER_NAME', l_hierarchy_name);
2667: l_ledger_name := fnd_message.get;
2668:
2669: fnd_message.set_name('GCS', 'GCS_HIER_NEW_LEDGER_DESC');
2662:
2663: -- Update the fem_ledgers_b/tl tables accordingly by setting proper Ledger Name and Description
2664:
2665: fnd_message.set_name('GCS', 'GCS_HIER_NEW_LEDGER_NAME');
2666: fnd_message.set_token('HIER_NAME', l_hierarchy_name);
2667: l_ledger_name := fnd_message.get;
2668:
2669: fnd_message.set_name('GCS', 'GCS_HIER_NEW_LEDGER_DESC');
2670: fnd_message.set_token('HIER_NAME', l_hierarchy_name);
2663: -- Update the fem_ledgers_b/tl tables accordingly by setting proper Ledger Name and Description
2664:
2665: fnd_message.set_name('GCS', 'GCS_HIER_NEW_LEDGER_NAME');
2666: fnd_message.set_token('HIER_NAME', l_hierarchy_name);
2667: l_ledger_name := fnd_message.get;
2668:
2669: fnd_message.set_name('GCS', 'GCS_HIER_NEW_LEDGER_DESC');
2670: fnd_message.set_token('HIER_NAME', l_hierarchy_name);
2671: l_ledger_desc := fnd_message.get;
2665: fnd_message.set_name('GCS', 'GCS_HIER_NEW_LEDGER_NAME');
2666: fnd_message.set_token('HIER_NAME', l_hierarchy_name);
2667: l_ledger_name := fnd_message.get;
2668:
2669: fnd_message.set_name('GCS', 'GCS_HIER_NEW_LEDGER_DESC');
2670: fnd_message.set_token('HIER_NAME', l_hierarchy_name);
2671: l_ledger_desc := fnd_message.get;
2672:
2673: UPDATE fem_ledgers_b
2666: fnd_message.set_token('HIER_NAME', l_hierarchy_name);
2667: l_ledger_name := fnd_message.get;
2668:
2669: fnd_message.set_name('GCS', 'GCS_HIER_NEW_LEDGER_DESC');
2670: fnd_message.set_token('HIER_NAME', l_hierarchy_name);
2671: l_ledger_desc := fnd_message.get;
2672:
2673: UPDATE fem_ledgers_b
2674: SET ledger_display_code = l_ledger_name
2667: l_ledger_name := fnd_message.get;
2668:
2669: fnd_message.set_name('GCS', 'GCS_HIER_NEW_LEDGER_DESC');
2670: fnd_message.set_token('HIER_NAME', l_hierarchy_name);
2671: l_ledger_desc := fnd_message.get;
2672:
2673: UPDATE fem_ledgers_b
2674: SET ledger_display_code = l_ledger_name
2675: WHERE ledger_id = l_ledger_id;