DBA Data[Home] [Help]

APPS.FEM_SOURCE_DATA_LOADER_PKG dependencies on FEM_DIMENSION_UTIL_PKG

Line 1010: FEM_DIMENSION_UTIL_PKG.register_data_location

1006: END IF;
1007:
1008: -- Register Data Location
1009: BEGIN
1010: FEM_DIMENSION_UTIL_PKG.register_data_location
1011: (p_request_id => p_request_id,
1012: p_object_id => p_object_id,
1013: p_table_name => p_table_name,
1014: p_ledger_id => p_ledger_id,

Line 1026: p_msg_text => 'Call to FEM_DIMENSION_UTIL_PKG.register_data_location '

1022:
1023: FEM_ENGINES_PKG.Tech_Message
1024: (p_severity => G_LOG_LEVEL_STATEMENT,
1025: p_module => C_MODULE,
1026: p_msg_text => 'Call to FEM_DIMENSION_UTIL_PKG.register_data_location '
1027: ||'failed unexpectedly.');
1028: RAISE;
1029: END;
1030:

Line 1140: l_global_vs_combo_id := FEM_DIMENSION_UTIL_PKG.GLOBAL_VS_COMBO_ID

1136:
1137: --
1138: -- lookup the global value set combination id tied to the ledger
1139: --
1140: l_global_vs_combo_id := FEM_DIMENSION_UTIL_PKG.GLOBAL_VS_COMBO_ID
1141: (p_encoded => G_FALSE,
1142: x_return_status => x_return_status,
1143: x_msg_count => l_msg_count,
1144: x_msg_data => l_msg_data,

Line 3075: FEM_DIMENSION_UTIL_PKG.register_data_location

3071: -- and rows loaded is greater than 0.
3072: --
3073: IF l_num_rows_rejected = 0 AND l_num_rows_loaded > 0 THEN
3074: BEGIN
3075: FEM_DIMENSION_UTIL_PKG.register_data_location
3076: (p_request_id => p_request_id,
3077: p_object_id => p_object_id,
3078: p_table_name => p_table_name,
3079: p_ledger_id => p_ledger_id,

Line 3094: p_msg_text => 'Call to FEM_DIMENSION_UTIL_PKG.register_data_location '

3090: WHEN others THEN
3091: FEM_ENGINES_PKG.Tech_Message
3092: (p_severity => G_LOG_LEVEL_STATEMENT,
3093: p_module => C_MODULE,
3094: p_msg_text => 'Call to FEM_DIMENSION_UTIL_PKG.register_data_location '
3095: ||'failed unexpectedly.');
3096: RAISE;
3097: END;
3098:

Line 3795: FEM_DIMENSION_UTIL_PKG.get_dim_attr_id_ver_id

3791: p_msg_text => 'Dimension ID of Ledger dimenions is '
3792: ||to_char(l_ledger_dim_id));
3793: END IF;
3794:
3795: FEM_DIMENSION_UTIL_PKG.get_dim_attr_id_ver_id
3796: (p_dim_id => l_ledger_dim_id,
3797: p_attr_label => 'CAL_PERIOD_HIER_OBJ_DEF_ID',
3798: x_attr_id => l_dim_attr_id,
3799: x_ver_id => l_dim_attr_ver_id,

Line 3806: p_msg_text => 'FEM_DIMENSION_UTIL_PKG.get_dim_attr_id_ver_id'

3802: IF G_LOG_LEVEL_STATEMENT >= g_log_current_level THEN
3803: FEM_ENGINES_PKG.TECH_MESSAGE(
3804: p_severity => G_LOG_LEVEL_STATEMENT,
3805: p_module => C_MODULE,
3806: p_msg_text => 'FEM_DIMENSION_UTIL_PKG.get_dim_attr_id_ver_id'
3807: ||'(CAL_PERIOD_HIER_OBJ_DEF_ID) returned with error code of '
3808: ||to_char(l_return_code));
3809: END IF;
3810:

Line 4091: FEM_DIMENSION_UTIL_PKG.get_dim_attr_id_ver_id

4087: END IF;
4088:
4089: -- Retrieve the CAL_PERIOD_END_DATE attribute of the Cal Period ID
4090: -- and set it into a package variable.
4091: FEM_DIMENSION_UTIL_PKG.get_dim_attr_id_ver_id
4092: (p_dim_id => l_cal_per_dim_id,
4093: p_attr_label => 'CAL_PERIOD_END_DATE',
4094: x_attr_id => l_dim_attr_id,
4095: x_ver_id => l_dim_attr_ver_id,

Line 4102: p_msg_text => 'FEM_DIMENSION_UTIL_PKG.get_dim_attr_id_ver_id'

4098: IF G_LOG_LEVEL_STATEMENT >= g_log_current_level THEN
4099: FEM_ENGINES_PKG.TECH_MESSAGE(
4100: p_severity => G_LOG_LEVEL_STATEMENT,
4101: p_module => C_MODULE,
4102: p_msg_text => 'FEM_DIMENSION_UTIL_PKG.get_dim_attr_id_ver_id'
4103: ||'(CAL_PERIOD_END_DATE) returned with error code of '
4104: ||to_char(l_return_code));
4105: END IF;
4106:

Line 4138: FEM_DIMENSION_UTIL_PKG.get_dim_attr_id_ver_id

4134: END;
4135:
4136: -- Get the Calendar Period Number from the GL_PERIOD_NUM attribute of the
4137: -- Cal Period ID and set it into a package variable.
4138: FEM_DIMENSION_UTIL_PKG.get_dim_attr_id_ver_id
4139: (p_dim_id => l_cal_per_dim_id,
4140: p_attr_label => 'GL_PERIOD_NUM',
4141: x_attr_id => l_dim_attr_id,
4142: x_ver_id => l_dim_attr_ver_id,

Line 4149: p_msg_text => 'FEM_DIMENSION_UTIL_PKG.get_dim_attr_id_ver_id'

4145: IF G_LOG_LEVEL_STATEMENT >= g_log_current_level THEN
4146: FEM_ENGINES_PKG.TECH_MESSAGE(
4147: p_severity => G_LOG_LEVEL_STATEMENT,
4148: p_module => C_MODULE,
4149: p_msg_text => 'FEM_DIMENSION_UTIL_PKG.get_dim_attr_id_ver_id'
4150: ||'(CGL_PERIOD_NUM) returned with error code of '
4151: ||to_char(l_return_code));
4152: END IF;
4153:

Line 4369: FEM_DIMENSION_UTIL_PKG.get_dim_attr_id_ver_id

4365: p_msg_text => 'Dimension ID of Dataset dimenions is '
4366: ||to_char(l_dataset_dim_id));
4367: END IF;
4368:
4369: FEM_DIMENSION_UTIL_PKG.get_dim_attr_id_ver_id
4370: (p_dim_id => l_dataset_dim_id,
4371: p_attr_label => 'DATASET_BALANCE_TYPE_CODE',
4372: x_attr_id => l_dim_attr_id,
4373: x_ver_id => l_dim_attr_ver_id,

Line 4380: p_msg_text => 'FEM_DIMENSION_UTIL_PKG.get_dim_attr_id_ver_id'

4376: IF G_LOG_LEVEL_STATEMENT >= g_log_current_level THEN
4377: FEM_ENGINES_PKG.TECH_MESSAGE(
4378: p_severity => G_LOG_LEVEL_STATEMENT,
4379: p_module => C_MODULE,
4380: p_msg_text => 'FEM_DIMENSION_UTIL_PKG.get_dim_attr_id_ver_id'
4381: ||'(DATASET_BALANCE_TYPE_CODE) returned with error code of '
4382: ||to_char(l_return_code));
4383: END IF;
4384: