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.FEM_DIMENSION_UTIL_PKG dependencies on FEM_DIMENSION_UTIL_PKG

Line 1: PACKAGE BODY FEM_DIMENSION_UTIL_PKG AS

1: PACKAGE BODY FEM_DIMENSION_UTIL_PKG AS
2: --$Header: FEMDIMAPB.plb 120.16.12000000.3 2007/08/08 16:16:46 gdonthir ship $
3: /*==========================================================================+
4: | Copyright (c) 1997 Oracle Corporation, Redwood Shores, CA, USA |
5: | All rights reserved. |

Line 11: | NAME fem_dimension_util_pkg

7: | FILENAME
8: |
9: | FEMDIMAPB.plb
10: |
11: | NAME fem_dimension_util_pkg
12: |
13: | DESCRIPTION
14: |
15: | Package Body for fem_dimension_util_pkg

Line 15: | Package Body for fem_dimension_util_pkg

11: | NAME fem_dimension_util_pkg
12: |
13: | DESCRIPTION
14: |
15: | Package Body for fem_dimension_util_pkg
16: |
17: | HISTORY
18: |
19: | 16-JUN-03 SSista Added APIs for Local VS Combo ID

Line 120: c_module_pkg CONSTANT VARCHAR2(80) := 'fem.plsql.fem_dimension_util_pkg';

116:
117: c_user_id CONSTANT NUMBER := FND_GLOBAL.USER_ID;
118: c_login_id NUMBER := FND_GLOBAL.Login_Id;
119:
120: c_module_pkg CONSTANT VARCHAR2(80) := 'fem.plsql.fem_dimension_util_pkg';
121: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FEM_DIMENSION_UTIL_PKG';
122:
123: f_set_status BOOLEAN;
124:

Line 121: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FEM_DIMENSION_UTIL_PKG';

117: c_user_id CONSTANT NUMBER := FND_GLOBAL.USER_ID;
118: c_login_id NUMBER := FND_GLOBAL.Login_Id;
119:
120: c_module_pkg CONSTANT VARCHAR2(80) := 'fem.plsql.fem_dimension_util_pkg';
121: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FEM_DIMENSION_UTIL_PKG';
122:
123: f_set_status BOOLEAN;
124:
125: c_log_level_1 CONSTANT NUMBER := fnd_log.level_statement;

Line 323: v_dim_name := FEM_Dimension_Util_Pkg.Get_Dimension_Name(

319: ELSE
320: v_ledger_id := p_ledger_id;
321: END IF;
322:
323: v_dim_name := FEM_Dimension_Util_Pkg.Get_Dimension_Name(
324: p_dim_label => 'LEDGER');
325:
326: IF (v_ledger_id is NULL)
327: THEN

Line 352: v_token_value := FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(

348: WHERE attribute_id = f.attribute_id
349: AND default_version_flag = 'Y');
350: EXCEPTION
351: WHEN no_data_found THEN
352: v_token_value := FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(
353: p_dim_label => 'LEDGER',
354: p_attr_label => 'GLOBAL_VS_COMBO');
355: x_err_code := 2;
356: x_num_msg := x_num_msg + 1;

Line 439: v_dim_name := FEM_Dimension_Util_Pkg.Get_Dimension_Name(

435: ELSE
436: v_ledger_id := p_ledger_id;
437: END IF;
438:
439: v_dim_name := FEM_Dimension_Util_Pkg.Get_Dimension_Name(
440: p_dim_label => 'LEDGER');
441:
442: IF (v_ledger_id is NULL)
443: THEN

Line 466: v_token_value := FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(

462: WHERE attribute_id = f.attribute_id
463: AND default_version_flag = 'Y');
464: EXCEPTION
465: WHEN no_data_found THEN
466: v_token_value := FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(
467: p_dim_label => 'LEDGER',
468: p_attr_label => 'GLOBAL_VS_COMBO');
469: RAISE e_no_value_found;
470: END;

Line 746: v_token_value := FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(

742: WHERE attribute_id = f.attribute_id
743: AND default_version_flag = 'Y');
744: EXCEPTION
745: WHEN no_data_found THEN
746: v_token_value := FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(
747: p_dim_label => 'LEDGER',
748: p_attr_label => 'GLOBAL_VS_COMBO');
749: FEM_ENGINES_PKG.Put_Message(
750: p_app_name => 'FEM',

Line 766: v_token_value := FEM_Dimension_Util_Pkg.Get_Dimension_Name(

762:
763: g_cache_dim_vs_id := v_dim_vs_id;
764: EXCEPTION
765: WHEN no_data_found THEN
766: v_token_value := FEM_Dimension_Util_Pkg.Get_Dimension_Name(
767: p_dim_label => 'VALUE_SET');
768: FEM_ENGINES_PKG.Put_Message(
769: p_app_name => 'FEM',
770: p_msg_name => 'FEM_NO_VALUE_FOUND_ERR',

Line 830: v_token_value := FEM_Dimension_Util_Pkg.Get_Dimension_Name(

826: WHERE global_vs_combo_id = v_global_vs_id
827: AND dimension_id = p_dimension_id;
828: EXCEPTION
829: WHEN no_data_found THEN
830: v_token_value := FEM_Dimension_Util_Pkg.Get_Dimension_Name(
831: p_dim_label => 'VALUE_SET');
832: v_token_trans := 'N';
833: x_err_code := 2;
834: x_num_msg := x_num_msg + 1;

Line 923: v_token_value := FEM_Dimension_Util_Pkg.Get_Dimension_Name(

919: WHERE global_vs_combo_id = v_global_vs_id
920: AND dimension_id = p_dimension_id;
921: EXCEPTION
922: WHEN no_data_found THEN
923: v_token_value := FEM_Dimension_Util_Pkg.Get_Dimension_Name(
924: p_dim_label => 'VALUE_SET');
925: v_token_trans := 'N';
926: RAISE e_no_value_found;
927: END;

Line 1106: 'fem.plsql.fem_dimension_util_pkg.relative_cal_period_id';

1102: p_base_cal_period_id IN NUMBER
1103: ) RETURN NUMBER
1104: IS
1105: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1106: 'fem.plsql.fem_dimension_util_pkg.relative_cal_period_id';
1107: C_LIMIT CONSTANT NUMBER := 10000; -- fetch limit
1108: e_unexp EXCEPTION;
1109:
1110: TYPE cal_period_tbl_type IS TABLE OF FEM_CAL_PERIODS_B.cal_period_id%TYPE;

Line 1251: p_msg_text => 'FEM_Dimension_Util_Pkg.get_dim_attr_id_ver_id'

1247: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1248: FEM_ENGINES_PKG.TECH_MESSAGE(
1249: p_severity => FND_LOG.level_statement,
1250: p_module => C_MODULE,
1251: p_msg_text => 'FEM_Dimension_Util_Pkg.get_dim_attr_id_ver_id'
1252: ||'(INCLUDE_ADJ_PERIOD_FLAG) returned with return code of '
1253: ||to_char(v_return_code));
1254: END IF;
1255:

Line 1380: p_msg_text => 'FEM_Dimension_Util_Pkg.get_dim_attr_id_ver_id '

1376: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1377: FEM_ENGINES_PKG.TECH_MESSAGE(
1378: p_severity => FND_LOG.level_statement,
1379: p_module => C_MODULE,
1380: p_msg_text => 'FEM_Dimension_Util_Pkg.get_dim_attr_id_ver_id '
1381: ||'(INCLUDE_ADJ_PERIOD_FLAG) returned with error code of '
1382: ||to_char(v_return_code));
1383: END IF;
1384:

Line 2770: v_token_value := FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(

2766: AND V.version_id = T.version_id
2767: AND V.default_version_flag = 'Y';
2768: EXCEPTION
2769: WHEN no_data_found THEN
2770: v_token_value := FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(
2771: p_dim_label => 'TIME_GROUP_TYPE',
2772: p_attr_label => 'PERIODS_IN_YEAR');
2773: RAISE e_no_value_found;
2774: WHEN too_many_rows THEN

Line 2775: v_token_value := FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(

2771: p_dim_label => 'TIME_GROUP_TYPE',
2772: p_attr_label => 'PERIODS_IN_YEAR');
2773: RAISE e_no_value_found;
2774: WHEN too_many_rows THEN
2775: v_token_value := FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(
2776: p_dim_label => 'TIME_GROUP_TYPE',
2777: p_attr_label => 'PERIODS_IN_YEAR');
2778: RAISE e_many_values_found;
2779: END;

Line 2783: -- v_token_value := FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(

2779: END;
2780:
2781: -- IF (p_period_num > v_num_of_periods)
2782: -- THEN
2783: -- v_token_value := FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(
2784: -- p_dim_label => 'CAL_PERIOD',
2785: -- p_attr_label => 'GL_PERIOD_NUM');
2786: -- v_attr_value := TO_CHAR(p_period_num);
2787: -- RAISE e_bad_param_value;

Line 2801: v_token_value := FEM_Dimension_Util_Pkg.Get_Dimension_Name(

2797: FROM fem_calendars_b
2798: WHERE calendar_id = p_calendar_id;
2799: EXCEPTION
2800: WHEN no_data_found THEN
2801: v_token_value := FEM_Dimension_Util_Pkg.Get_Dimension_Name(
2802: p_dim_label => 'CALENDAR');
2803: v_attr_value := TO_CHAR(p_calendar_id);
2804: RAISE e_bad_param_value;
2805: END;

Line 2915: v_token_value := FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(

2911: AND V.version_id = T.version_id
2912: AND V.default_version_flag = 'Y';
2913: EXCEPTION
2914: WHEN no_data_found THEN
2915: v_token_value := FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(
2916: p_dim_label => 'TIME_GROUP_TYPE',
2917: p_attr_label => 'PERIODS_IN_YEAR');
2918: RAISE e_no_value_found;
2919: WHEN too_many_rows THEN

Line 2920: v_token_value := FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(

2916: p_dim_label => 'TIME_GROUP_TYPE',
2917: p_attr_label => 'PERIODS_IN_YEAR');
2918: RAISE e_no_value_found;
2919: WHEN too_many_rows THEN
2920: v_token_value := FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(
2921: p_dim_label => 'TIME_GROUP_TYPE',
2922: p_attr_label => 'PERIODS_IN_YEAR');
2923: RAISE e_many_values_found;
2924: END;

Line 2928: -- v_token_value := FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(

2924: END;
2925:
2926: -- IF (p_period_num > v_num_of_periods)
2927: -- THEN
2928: -- v_token_value := FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(
2929: -- p_dim_label => 'CAL_PERIOD',
2930: -- p_attr_label => 'GL_PERIOD_NUM');
2931: -- v_attr_value := TO_CHAR(p_period_num);
2932: -- RAISE e_bad_param_value;

Line 2946: v_token_value := FEM_Dimension_Util_Pkg.Get_Dimension_Name(

2942: FROM fem_calendars_b
2943: WHERE calendar_id = p_calendar_id;
2944: EXCEPTION
2945: WHEN no_data_found THEN
2946: v_token_value := FEM_Dimension_Util_Pkg.Get_Dimension_Name(
2947: p_dim_label => 'CALENDAR');
2948: v_attr_value := TO_CHAR(p_calendar_id);
2949: RAISE e_bad_param_value;
2950: END;

Line 3066: 'fem.plsql.fem_dimension_util_pkg.generate_default_load_member(1)';

3062: )
3063: IS
3064:
3065: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
3066: 'fem.plsql.fem_dimension_util_pkg.generate_default_load_member(1)';
3067: C_API_NAME CONSTANT VARCHAR2(30) := 'Genereate_Default_Load_Member';
3068:
3069: v_sql VARCHAR2(8191);
3070: v_member_code VARCHAR2(250);

Line 3305: v_member_code := FEM_Dimension_Util_Pkg.Generate_Member_ID (

3301: -- the default member display code is hard coded
3302: v_member_dc := 'Default';
3303:
3304: IF v_member_id_method_code = 'FUNCTION' THEN
3305: v_member_code := FEM_Dimension_Util_Pkg.Generate_Member_ID (
3306: p_api_version => 1.0,
3307: p_init_msg_list => c_false,
3308: p_commit => c_false,
3309: p_encoded => p_encoded,

Line 3422: p_value2 => FEM_Dimension_Util_Pkg.Get_Dimension_Name(

3418: p_token1 => 'VALUE',
3419: p_value1 => v_member_code,
3420: p_trans1 => 'N',
3421: p_token2 => 'DIMENSION',
3422: p_value2 => FEM_Dimension_Util_Pkg.Get_Dimension_Name(
3423: p_dim_id => v_dim_id));
3424: RAISE e_error;
3425: END;
3426:

Line 3613: 'fem.plsql.fem_dimension_util_pkg.generate_default_load_member(2)';

3609: p_vs_id IN NUMBER
3610: )
3611: IS
3612: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
3613: 'fem.plsql.fem_dimension_util_pkg.generate_default_load_member(2)';
3614: C_API_NAME CONSTANT VARCHAR2(30) := 'Genereate_Default_Load_Member';
3615:
3616: v_dim_label FEM_DIMENSIONS_B.dimension_varchar_label%TYPE;
3617: v_def_load_id NUMBER;

Line 3726: p_msg_text => 'Call to FEM_Dimension_Util_Pkg.Generate_Default_Load_Member(1)'

3722: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3723: FEM_ENGINES_PKG.TECH_MESSAGE(
3724: p_severity => FND_LOG.level_statement,
3725: p_module => C_MODULE,
3726: p_msg_text => 'Call to FEM_Dimension_Util_Pkg.Generate_Default_Load_Member(1)'
3727: ||' returned with status: '||x_return_status);
3728: END IF;
3729: RAISE e_error;
3730: END IF;

Line 3794: 'fem.plsql.fem_dimension_util_pkg.generate_default_load_member(3)';

3790: x_msg_data OUT NOCOPY VARCHAR2
3791: )
3792: IS
3793: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
3794: 'fem.plsql.fem_dimension_util_pkg.generate_default_load_member(3)';
3795: C_API_NAME CONSTANT VARCHAR2(30) := 'Genereate_Default_Load_Member';
3796:
3797: v_member_code VARCHAR2(250);
3798: v_exception_flag BOOLEAN;

Line 4039: v_ds_cd := FEM_Dimension_Util_Pkg.Generate_Member_ID(

4035: INTO v_dim_id
4036: FROM fem_dimensions_b
4037: WHERE dimension_varchar_label = c_dim_label;
4038:
4039: v_ds_cd := FEM_Dimension_Util_Pkg.Generate_Member_ID(
4040: p_dim_id => v_dim_id,
4041: x_err_code => v_err_code,
4042: x_num_msg => v_num_msg);
4043: IF (v_err_code > 0)

Line 4365: p_value1 => FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(

4361: FEM_ENGINES_PKG.Put_Message(
4362: p_app_name => 'FEM',
4363: p_msg_name => 'FEM_BAD_PARAM_VALUE_ERR',
4364: p_token1 => 'PARAM',
4365: p_value1 => FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(
4366: p_attr_id => v_attr_id),
4367: p_token2 => 'VALUE',
4368: p_value2 => v_attr_value);
4369: x_err_code := 2;

Line 4378: p_value1 => FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(

4374: FEM_ENGINES_PKG.Put_Message(
4375: p_app_name => 'FEM',
4376: p_msg_name => 'FEM_NULL_PARAM_VALUE_ERR',
4377: p_token1 => 'PARAM',
4378: p_value1 => FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(
4379: p_attr_id => v_attr_id));
4380: x_err_code := 2;
4381: x_num_msg := x_num_msg + 1;
4382:

Line 4389: p_value1 => FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(

4385: FEM_ENGINES_PKG.Put_Message(
4386: p_app_name => 'FEM',
4387: p_msg_name => 'FEM_NO_VERSION_NAME_ERR',
4388: p_token1 => 'ENTITY',
4389: p_value1 => FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(
4390: p_attr_id => v_attr_id));
4391: x_err_code := 2;
4392: x_num_msg := x_num_msg + 1;
4393:

Line 4507: v_ds_cd := FEM_Dimension_Util_Pkg.Generate_Member_ID(

4503: INTO v_dim_id
4504: FROM fem_dimensions_b
4505: WHERE dimension_varchar_label = c_dim_label;
4506:
4507: v_ds_cd := FEM_Dimension_Util_Pkg.Generate_Member_ID(
4508: p_api_version => p_api_version,
4509: p_init_msg_list => c_false,
4510: p_commit => c_false,
4511: p_encoded => p_encoded,

Line 4846: p_value1 => FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(

4842: FEM_ENGINES_PKG.Put_Message(
4843: p_app_name => 'FEM',
4844: p_msg_name => 'FEM_BAD_PARAM_VALUE_ERR',
4845: p_token1 => 'PARAM',
4846: p_value1 => FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(
4847: p_attr_id => v_attr_id),
4848: p_token2 => 'VALUE',
4849: p_value2 => v_attr_value);
4850: FND_MSG_PUB.Count_and_Get(

Line 4862: p_value1 => FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(

4858: FEM_ENGINES_PKG.Put_Message(
4859: p_app_name => 'FEM',
4860: p_msg_name => 'FEM_NULL_PARAM_VALUE_ERR',
4861: p_token1 => 'PARAM',
4862: p_value1 => FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(
4863: p_attr_id => v_attr_id));
4864: FND_MSG_PUB.Count_and_Get(
4865: p_encoded => p_encoded,
4866: p_count => x_msg_count,

Line 4876: p_value1 => FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(

4872: FEM_ENGINES_PKG.Put_Message(
4873: p_app_name => 'FEM',
4874: p_msg_name => 'FEM_NO_VERSION_NAME_ERR',
4875: p_token1 => 'ENTITY',
4876: p_value1 => FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(
4877: p_attr_id => v_attr_id));
4878: FND_MSG_PUB.Count_and_Get(
4879: p_encoded => p_encoded,
4880: p_count => x_msg_count,

Line 5003: v_lg_id := FEM_Dimension_Util_Pkg.Generate_Member_ID(

4999: INTO v_dim_id
5000: FROM fem_dimensions_b
5001: WHERE dimension_varchar_label = c_dim_label;
5002:
5003: v_lg_id := FEM_Dimension_Util_Pkg.Generate_Member_ID(
5004: p_dim_id => v_dim_id,
5005: x_err_code => v_err_code,
5006: x_num_msg => v_num_msg);
5007: IF (v_err_code > 0)

Line 5374: p_value1 => FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(

5370: FEM_ENGINES_PKG.Put_Message(
5371: p_app_name => 'FEM',
5372: p_msg_name => 'FEM_BAD_PARAM_VALUE_ERR',
5373: p_token1 => 'PARAM',
5374: p_value1 => FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(
5375: p_attr_id => v_attr_id),
5376: p_trans1 => 'n',
5377: p_token2 => 'VALUE',
5378: p_value2 => v_attr_value);

Line 5388: p_value1 => FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(

5384: FEM_ENGINES_PKG.Put_Message(
5385: p_app_name => 'FEM',
5386: p_msg_name => 'FEM_NULL_PARAM_VALUE_ERR',
5387: p_token1 => 'PARAM',
5388: p_value1 => FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(
5389: p_attr_id => v_attr_id));
5390: x_err_code := 2;
5391: x_num_msg := x_num_msg + 1;
5392:

Line 5399: p_value1 => FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(

5395: FEM_ENGINES_PKG.Put_Message(
5396: p_app_name => 'FEM',
5397: p_msg_name => 'FEM_NO_VERSION_NAME_ERR',
5398: p_token1 => 'ENTITY',
5399: p_value1 => FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(
5400: p_attr_id => v_attr_id));
5401: x_err_code := 2;
5402: x_num_msg := x_num_msg + 1;
5403:

Line 5537: v_lg_id := FEM_Dimension_Util_Pkg.Generate_Member_ID(

5533: INTO v_dim_id
5534: FROM fem_dimensions_b
5535: WHERE dimension_varchar_label = c_dim_label;
5536:
5537: v_lg_id := FEM_Dimension_Util_Pkg.Generate_Member_ID(
5538: p_api_version => p_api_version,
5539: p_init_msg_list => c_false,
5540: p_commit => c_false,
5541: p_encoded => p_encoded,

Line 5921: p_value1 => FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(

5917: FEM_ENGINES_PKG.Put_Message(
5918: p_app_name => 'FEM',
5919: p_msg_name => 'FEM_BAD_PARAM_VALUE_ERR',
5920: p_token1 => 'PARAM',
5921: p_value1 => FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(
5922: p_attr_id => v_attr_id),
5923: p_token2 => 'VALUE',
5924: p_value2 => v_attr_value);
5925: FND_MSG_PUB.Count_and_Get(

Line 5937: p_value1 => FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(

5933: FEM_ENGINES_PKG.Put_Message(
5934: p_app_name => 'FEM',
5935: p_msg_name => 'FEM_NULL_PARAM_VALUE_ERR',
5936: p_token1 => 'PARAM',
5937: p_value1 => FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(
5938: p_attr_id => v_attr_id));
5939: FND_MSG_PUB.Count_and_Get(
5940: p_encoded => p_encoded,
5941: p_count => x_msg_count,

Line 5951: p_value1 => FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(

5947: FEM_ENGINES_PKG.Put_Message(
5948: p_app_name => 'FEM',
5949: p_msg_name => 'FEM_NO_VERSION_NAME_ERR',
5950: p_token1 => 'ENTITY',
5951: p_value1 => FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(
5952: p_attr_id => v_attr_id));
5953: FND_MSG_PUB.Count_and_Get(
5954: p_encoded => p_encoded,
5955: p_count => x_msg_count,

Line 6102: v_budget_id := FEM_Dimension_Util_Pkg.Generate_Member_ID(

6098: INTO v_budget_dimension_id
6099: FROM fem_dimensions_b
6100: WHERE dimension_varchar_label = c_budget_label;
6101:
6102: v_budget_id := FEM_Dimension_Util_Pkg.Generate_Member_ID(
6103: p_api_version => p_api_version,
6104: p_init_msg_list => c_false,
6105: p_commit => c_false,
6106: p_encoded => p_encoded,

Line 6410: p_value1 => FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(

6406: FEM_ENGINES_PKG.Put_Message(
6407: p_app_name => 'FEM',
6408: p_msg_name => 'FEM_BAD_PARAM_VALUE_ERR',
6409: p_token1 => 'PARAM',
6410: p_value1 => FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(
6411: p_attr_id => v_attribute_id),
6412: p_token2 => 'VALUE',
6413: p_value2 => v_attr_assign_value);
6414: FND_MSG_PUB.Count_and_Get(

Line 6426: p_value1 => FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(

6422: FEM_ENGINES_PKG.Put_Message(
6423: p_app_name => 'FEM',
6424: p_msg_name => 'FEM_NULL_PARAM_VALUE_ERR',
6425: p_token1 => 'PARAM',
6426: p_value1 => FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(
6427: p_attr_id => v_attribute_id));
6428: FND_MSG_PUB.Count_and_Get(
6429: p_encoded => p_encoded,
6430: p_count => x_msg_count,

Line 6440: p_value1 => FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(

6436: FEM_ENGINES_PKG.Put_Message(
6437: p_app_name => 'FEM',
6438: p_msg_name => 'FEM_NO_VERSION_NAME_ERR',
6439: p_token1 => 'ENTITY',
6440: p_value1 => FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(
6441: p_attr_id => v_attribute_id));
6442: FND_MSG_PUB.Count_and_Get(
6443: p_encoded => p_encoded,
6444: p_count => x_msg_count,

Line 6896: p_value1 => FEM_Dimension_Util_Pkg.Get_Dimension_Name(

6892: FEM_Engines_Pkg.Put_Message(
6893: p_app_name => 'FEM',
6894: p_msg_name => 'FEM_DUP_REG_MEMBER_ERR',
6895: p_token1 => 'DIMENSION',
6896: p_value1 => FEM_Dimension_Util_Pkg.Get_Dimension_Name(
6897: p_dim_id => v_dim_id),
6898: p_trans1 => 'N',
6899: p_token2 => 'VALUE',
6900: p_value2 => p_budget_id);

Line 6913: p_value1 => FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(

6909: FEM_ENGINES_PKG.Put_Message(
6910: p_app_name => 'FEM',
6911: p_msg_name => 'FEM_BAD_PARAM_VALUE_ERR',
6912: p_token1 => 'PARAM',
6913: p_value1 => FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(
6914: p_attr_id => v_attribute_id),
6915: p_token2 => 'VALUE',
6916: p_value2 => v_attr_assign_value);
6917: FND_MSG_PUB.Count_and_Get(

Line 6929: p_value1 => FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(

6925: FEM_ENGINES_PKG.Put_Message(
6926: p_app_name => 'FEM',
6927: p_msg_name => 'FEM_NULL_PARAM_VALUE_ERR',
6928: p_token1 => 'PARAM',
6929: p_value1 => FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(
6930: p_attr_id => v_attribute_id));
6931: FND_MSG_PUB.Count_and_Get(
6932: p_encoded => p_encoded,
6933: p_count => x_msg_count,

Line 6943: p_value1 => FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(

6939: FEM_ENGINES_PKG.Put_Message(
6940: p_app_name => 'FEM',
6941: p_msg_name => 'FEM_NO_VERSION_NAME_ERR',
6942: p_token1 => 'ENTITY',
6943: p_value1 => FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(
6944: p_attr_id => v_attribute_id));
6945: FND_MSG_PUB.Count_and_Get(
6946: p_encoded => p_encoded,
6947: p_count => x_msg_count,

Line 7482: p_value1 => FEM_Dimension_Util_Pkg.Get_Dimension_Name(

7478: FEM_Engines_Pkg.Put_Message(
7479: p_app_name => 'FEM',
7480: p_msg_name => 'FEM_DUP_REG_MEMBER_ERR',
7481: p_token1 => 'DIMENSION',
7482: p_value1 => FEM_Dimension_Util_Pkg.Get_Dimension_Name(
7483: p_dim_id => v_dim_id),
7484: p_trans1 => 'N',
7485: p_token2 => 'VALUE',
7486: p_value2 => p_ledger_id);

Line 7499: p_value1 => FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(

7495: FEM_ENGINES_PKG.Put_Message(
7496: p_app_name => 'FEM',
7497: p_msg_name => 'FEM_BAD_PARAM_VALUE_ERR',
7498: p_token1 => 'PARAM',
7499: p_value1 => FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(
7500: p_attr_id => v_attr_id),
7501: p_token2 => 'VALUE',
7502: p_value2 => v_attr_value);
7503: FND_MSG_PUB.Count_and_Get(

Line 7515: p_value1 => FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(

7511: FEM_ENGINES_PKG.Put_Message(
7512: p_app_name => 'FEM',
7513: p_msg_name => 'FEM_NULL_PARAM_VALUE_ERR',
7514: p_token1 => 'PARAM',
7515: p_value1 => FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(
7516: p_attr_id => v_attr_id));
7517: FND_MSG_PUB.Count_and_Get(
7518: p_encoded => p_encoded,
7519: p_count => x_msg_count,

Line 7529: p_value1 => FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(

7525: FEM_ENGINES_PKG.Put_Message(
7526: p_app_name => 'FEM',
7527: p_msg_name => 'FEM_NO_VERSION_NAME_ERR',
7528: p_token1 => 'ENTITY',
7529: p_value1 => FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(
7530: p_attr_id => v_attr_id));
7531: FND_MSG_PUB.Count_and_Get(
7532: p_encoded => p_encoded,
7533: p_count => x_msg_count,

Line 7646: v_enc_type_id := FEM_Dimension_Util_Pkg.Generate_Member_ID(

7642: INTO v_dim_id
7643: FROM fem_dimensions_b
7644: WHERE dimension_varchar_label = c_dim_label;
7645:
7646: v_enc_type_id := FEM_Dimension_Util_Pkg.Generate_Member_ID(
7647: p_api_version => p_api_version,
7648: p_init_msg_list => c_false,
7649: p_commit => c_false,
7650: p_encoded => p_encoded,

Line 7974: p_value1 => FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(

7970: FEM_ENGINES_PKG.Put_Message(
7971: p_app_name => 'FEM',
7972: p_msg_name => 'FEM_BAD_PARAM_VALUE_ERR',
7973: p_token1 => 'PARAM',
7974: p_value1 => FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(
7975: p_attr_id => v_attr_id),
7976: p_token2 => 'VALUE',
7977: p_value2 => v_attr_value);
7978: FND_MSG_PUB.Count_and_Get(

Line 7990: p_value1 => FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(

7986: FEM_ENGINES_PKG.Put_Message(
7987: p_app_name => 'FEM',
7988: p_msg_name => 'FEM_NULL_PARAM_VALUE_ERR',
7989: p_token1 => 'PARAM',
7990: p_value1 => FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(
7991: p_attr_id => v_attr_id));
7992: FND_MSG_PUB.Count_and_Get(
7993: p_encoded => p_encoded,
7994: p_count => x_msg_count,

Line 8004: p_value1 => FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(

8000: FEM_ENGINES_PKG.Put_Message(
8001: p_app_name => 'FEM',
8002: p_msg_name => 'FEM_NO_VERSION_NAME_ERR',
8003: p_token1 => 'ENTITY',
8004: p_value1 => FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(
8005: p_attr_id => v_attr_id));
8006: FND_MSG_PUB.Count_and_Get(
8007: p_encoded => p_encoded,
8008: p_count => x_msg_count,

Line 8453: p_value1 => FEM_Dimension_Util_Pkg.Get_Dimension_Name(

8449: FEM_Engines_Pkg.Put_Message(
8450: p_app_name => 'FEM',
8451: p_msg_name => 'FEM_DUP_REG_MEMBER_ERR',
8452: p_token1 => 'DIMENSION',
8453: p_value1 => FEM_Dimension_Util_Pkg.Get_Dimension_Name(
8454: p_dim_id => v_dim_id),
8455: p_trans1 => 'N',
8456: p_token2 => 'VALUE',
8457: p_value2 => p_enc_type_id);

Line 8470: p_value1 => FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(

8466: FEM_ENGINES_PKG.Put_Message(
8467: p_app_name => 'FEM',
8468: p_msg_name => 'FEM_BAD_PARAM_VALUE_ERR',
8469: p_token1 => 'PARAM',
8470: p_value1 => FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(
8471: p_attr_id => v_attr_id),
8472: p_token2 => 'VALUE',
8473: p_value2 => v_attr_value);
8474: FND_MSG_PUB.Count_and_Get(

Line 8486: p_value1 => FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(

8482: FEM_ENGINES_PKG.Put_Message(
8483: p_app_name => 'FEM',
8484: p_msg_name => 'FEM_NULL_PARAM_VALUE_ERR',
8485: p_token1 => 'PARAM',
8486: p_value1 => FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(
8487: p_attr_id => v_attr_id));
8488: FND_MSG_PUB.Count_and_Get(
8489: p_encoded => p_encoded,
8490: p_count => x_msg_count,

Line 8500: p_value1 => FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(

8496: FEM_ENGINES_PKG.Put_Message(
8497: p_app_name => 'FEM',
8498: p_msg_name => 'FEM_NO_VERSION_NAME_ERR',
8499: p_token1 => 'ENTITY',
8500: p_value1 => FEM_Dimension_Util_Pkg.Get_Dim_Attr_Name(
8501: p_attr_id => v_attr_id));
8502: FND_MSG_PUB.Count_and_Get(
8503: p_encoded => p_encoded,
8504: p_count => x_msg_count,

Line 8758: 'fem.plsql.fem_dimension_util_pkg.get_dim_member_id';

8754: ) RETURN VARCHAR2
8755: IS
8756:
8757: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
8758: 'fem.plsql.fem_dimension_util_pkg.get_dim_member_id';
8759:
8760: v_dim_id NUMBER;
8761: v_vs_id NUMBER;
8762: v_mem_b_tab VARCHAR2(30);

Line 8789: FEM_Dimension_Util_Pkg.Validate_OA_Params (

8785:
8786: ---------------------------
8787: -- Verify the OA parameters
8788: ---------------------------
8789: FEM_Dimension_Util_Pkg.Validate_OA_Params (
8790: p_api_version => c_api_version,
8791: p_init_msg_list => p_init_msg_list,
8792: p_commit => p_commit,
8793: p_encoded => p_encoded,

Line 9241: 'fem.plsql.fem_dimension_util_pkg.get_default_dim_member';

9237: )
9238: IS
9239:
9240: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
9241: 'fem.plsql.fem_dimension_util_pkg.get_default_dim_member';
9242: C_API_VERSION CONSTANT NUMBER := 1.0;
9243: C_API_NAME CONSTANT VARCHAR2(30) := 'Get_Default_Dim_Member';
9244: e_no_member EXCEPTION;
9245:

Line 9580: 'fem.plsql.fem_dimension_util_pkg.get_default_dim_member.table';

9576: )
9577: IS
9578:
9579: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
9580: 'fem.plsql.fem_dimension_util_pkg.get_default_dim_member.table';
9581: C_API_VERSION CONSTANT NUMBER := 1.0;
9582: C_API_NAME CONSTANT VARCHAR2(30) := 'Get_Default_Dim_Member';
9583:
9584: v_dim_id FEM_DIMENSIONS_B.dimension_id%TYPE;

Line 9964: END FEM_Dimension_Util_Pkg;

9960:
9961:
9962: ---------------------------------------------
9963:
9964: END FEM_Dimension_Util_Pkg;