DBA Data[Home] [Help]

APPS.FEM_CONDITIONS_API dependencies on FEM_ENGINES_PKG

Line 1150: /*FEM_ENGINES_PKG.PUT_MESSAGE(

1146: fnd_message.set_token(TOKEN => G_COLUMN_TOKEN, VALUE => l_value, TRANSLATE => FALSE);
1147: fnd_message.set_token(TOKEN => G_TABLE_TOKEN, VALUE =>p_factTable,TRANSLATE => FALSE);
1148: fnd_msg_pub.add_detail(p_message_type => 'W');
1149:
1150: /*FEM_ENGINES_PKG.PUT_MESSAGE(
1151: p_app_name => FEM_APP,
1152: p_msg_name => G_INVALID_COLUMN,
1153: p_token1 => G_COLUMN_TOKEN,
1154: p_value1 => l_value,

Line 1321: /* FEM_ENGINES_PKG.PUT_MESSAGE(

1317: fnd_message.set_name(APPLICATION => FEM_APP,NAME => G_INVALID_COLUMN);
1318: fnd_message.set_token(TOKEN => G_COLUMN_TOKEN, VALUE => l_columnName, TRANSLATE => FALSE);
1319: fnd_message.set_token(TOKEN => G_TABLE_TOKEN, VALUE =>p_factTableName,TRANSLATE => FALSE);
1320: fnd_msg_pub.add_detail(p_message_type => 'W');
1321: /* FEM_ENGINES_PKG.PUT_MESSAGE(
1322: p_app_name => FEM_APP,
1323: p_msg_name => G_INVALID_COLUMN,
1324: p_token1 => G_COLUMN_TOKEN,
1325: p_value1 => l_columnName,

Line 1346: /* FEM_ENGINES_PKG.PUT_MESSAGE(

1342: fnd_message.set_name(APPLICATION => FEM_APP,NAME => G_INVALID_OPERATOR);
1343: fnd_message.set_token(TOKEN => G_OPERATOR_TOKEN, VALUE => l_operator, TRANSLATE => FALSE);
1344: fnd_msg_pub.add_detail(p_message_type => 'W');
1345:
1346: /* FEM_ENGINES_PKG.PUT_MESSAGE(
1347: p_app_name => FEM_APP,
1348: p_msg_name => G_INVALID_OPERATOR,
1349: p_token1 => G_OPERATOR_TOKEN,
1350: p_value1 => l_operator);*/

Line 2169: FEM_ENGINES_PKG.PUT_MESSAGE(

2165: fnd_message.set_token(TOKEN => G_HIERARCHY_TOKEN, VALUE => l_hierarchy_obj_name, TRANSLATE => FALSE);
2166: fnd_msg_pub.add_detail(p_message_type => 'W');
2167:
2168: /*
2169: FEM_ENGINES_PKG.PUT_MESSAGE(
2170: p_app_name => FEM_APP,
2171: p_msg_name => G_INVALID_NODE,
2172: p_token1 => G_NODE_TOKEN,
2173: p_value1 => l_node_tbl(i),

Line 2390: /* FEM_ENGINES_PKG.PUT_MESSAGE(

2386: fnd_message.set_token(TOKEN => G_COLUMN_TOKEN, VALUE => l_dimensionColumn, TRANSLATE => FALSE);
2387: fnd_message.set_token(TOKEN => G_TABLE_TOKEN, VALUE =>p_factTableName,TRANSLATE => FALSE);
2388: fnd_msg_pub.add_detail(p_message_type => 'W');
2389:
2390: /* FEM_ENGINES_PKG.PUT_MESSAGE(
2391: p_app_name => FEM_APP,
2392: p_msg_name => G_INVALID_DIMENSION,
2393: p_token1 => G_COLUMN_TOKEN,
2394: p_value1 => l_dimensionColumn,

Line 2814: FEM_ENGINES_PKG.PUT_MESSAGE(

2810:
2811:
2812: EXCEPTION
2813: WHEN NO_CONDITION_EXCEPTION THEN
2814: FEM_ENGINES_PKG.PUT_MESSAGE(
2815: p_app_name => FEM_APP,
2816: p_msg_name => G_NO_VERSION,
2817: p_token1 => G_CONDITION_TOKEN,
2818: p_value1 => p_condition_obj_id,

Line 2831: FEM_ENGINES_PKG.PUT_MESSAGE(

2827:
2828: WHEN INVALID_FACT_TABLE_EXCEPTION THEN
2829:
2830:
2831: FEM_ENGINES_PKG.PUT_MESSAGE(
2832: p_app_name => FEM_APP,
2833: p_msg_name => G_INVALID_TABLE,
2834: p_token1 => G_TABLE_TOKEN,
2835: p_value1 => p_input_fact_table_name);

Line 2846: FEM_ENGINES_PKG.PUT_MESSAGE(

2842: RETURN;
2843:
2844: WHEN NO_FACT_TABLE_EXCEPTION THEN
2845:
2846: FEM_ENGINES_PKG.PUT_MESSAGE(
2847: p_app_name => FEM_APP,
2848: p_msg_name => G_NO_TABLE);
2849:
2850: FND_MSG_PUB.Count_and_Get(

Line 2859: FEM_ENGINES_PKG. PUT_MESSAGE(

2855:
2856: RETURN;
2857:
2858: WHEN HIER_FLATTENED_EXCEPTION THEN
2859: FEM_ENGINES_PKG. PUT_MESSAGE(
2860: p_app_name => FEM_APP,
2861: p_msg_name => G_HIER_FLATTENED);
2862:
2863: FND_MSG_PUB.Count_and_Get(

Line 2872: FEM_ENGINES_PKG. PUT_MESSAGE(

2868: RETURN;
2869:
2870: WHEN NO_VALID_COMPONENTS_EXCEPTION THEN
2871:
2872: FEM_ENGINES_PKG. PUT_MESSAGE(
2873: p_app_name => FEM_APP,
2874: p_msg_name => G_NO_VALID_COMPS);
2875:
2876: FND_MSG_PUB.Count_and_Get(

Line 2886: FEM_ENGINES_PKG. PUT_MESSAGE(

2882: RETURN;
2883:
2884: WHEN INVALID_DIM_COMP_EXCEPTION THEN
2885:
2886: FEM_ENGINES_PKG. PUT_MESSAGE(
2887: p_app_name => FEM_APP,
2888: p_msg_name => G_INVALID_DIM_COMPONENT,
2889: p_token1 => G_CONDITION_TOKEN,
2890: p_value1 => z_conditionObjectDefName,

Line 2904: FEM_ENGINES_PKG. PUT_MESSAGE(

2900:
2901: RETURN;
2902:
2903: WHEN NO_COMPONENTS_EXCEPTION THEN
2904: FEM_ENGINES_PKG. PUT_MESSAGE(
2905: p_app_name => FEM_APP,
2906: p_msg_name => G_NO_COMPONENTS);
2907:
2908: FND_MSG_PUB.Count_and_Get(

Line 2919: --FEM_ENGINES_PKG.USER_MESSAGE(G_UNHANDLED_EXCEPTION);

2915:
2916: WHEN OTHERS THEN
2917: -- x_err_code := SQLCODE;
2918: -- x_err_msg := G_UNHANDLED_EXCEPTION;
2919: --FEM_ENGINES_PKG.USER_MESSAGE(G_UNHANDLED_EXCEPTION);
2920: FEM_ENGINES_PKG. PUT_MESSAGE(
2921: p_app_name => FEM_APP,
2922: p_msg_name => G_UNHANDLED_EXCEPTION,
2923: p_token1 => G_SQL_ERR_TOKEN,

Line 2920: FEM_ENGINES_PKG. PUT_MESSAGE(

2916: WHEN OTHERS THEN
2917: -- x_err_code := SQLCODE;
2918: -- x_err_msg := G_UNHANDLED_EXCEPTION;
2919: --FEM_ENGINES_PKG.USER_MESSAGE(G_UNHANDLED_EXCEPTION);
2920: FEM_ENGINES_PKG. PUT_MESSAGE(
2921: p_app_name => FEM_APP,
2922: p_msg_name => G_UNHANDLED_EXCEPTION,
2923: p_token1 => G_SQL_ERR_TOKEN,
2924: p_value1 => SQLERRM);

Line 3008: FEM_ENGINES_PKG.User_Message(

3004: THEN
3005: FND_MESSAGE.Set_Encoded(l_msg_data);
3006: l_message := FND_MESSAGE.Get;
3007:
3008: FEM_ENGINES_PKG.User_Message(
3009: p_msg_text => l_message);
3010:
3011:
3012: ELSIF (l_msg_count > 1)

Line 3022: FEM_ENGINES_PKG.User_Message(

3018: p_encoded => FND_API.G_FALSE,
3019: p_data => l_message,
3020: p_msg_index_out => l_msg_out);
3021:
3022: FEM_ENGINES_PKG.User_Message(
3023: p_msg_text => l_message);
3024:
3025: END LOOP;
3026: END IF;

Line 3327: FEM_ENGINES_PKG.PUT_MESSAGE(

3323: EXCEPTION
3324: WHEN NO_CONDITION_EXCEPTION THEN
3325: x_err_code := -1;
3326: x_err_msg := G_NO_VERSION;
3327: FEM_ENGINES_PKG.PUT_MESSAGE(
3328: p_app_name => FEM_APP,
3329: p_msg_name => x_err_msg,
3330: p_token1 => G_CONDITION_TOKEN,
3331: p_value1 => p_condition_obj_id,

Line 3339: FEM_ENGINES_PKG.PUT_MESSAGE(

3335:
3336: WHEN INVALID_FACT_TABLE_EXCEPTION THEN
3337: x_err_code := -1;
3338: x_err_msg := G_INVALID_TABLE;
3339: FEM_ENGINES_PKG.PUT_MESSAGE(
3340: p_app_name => FEM_APP,
3341: p_msg_name => x_err_msg,
3342: p_token1 => G_TABLE_TOKEN,
3343: p_value1 => p_input_fact_table_name);

Line 3349: FEM_ENGINES_PKG.PUT_MESSAGE(

3345:
3346: WHEN NO_FACT_TABLE_EXCEPTION THEN
3347: x_err_code := -1;
3348: x_err_msg := G_NO_TABLE;
3349: FEM_ENGINES_PKG.PUT_MESSAGE(
3350: p_app_name => FEM_APP,
3351: p_msg_name => x_err_msg);
3352: RETURN;
3353:

Line 3357: FEM_ENGINES_PKG.PUT_MESSAGE(

3353:
3354: WHEN HIER_FLATTENED_EXCEPTION THEN
3355: x_err_code := -1;
3356: x_err_msg := G_HIER_FLATTENED;
3357: FEM_ENGINES_PKG.PUT_MESSAGE(
3358: p_app_name => FEM_APP,
3359: p_msg_name => x_err_msg);
3360: RETURN;
3361:

Line 3365: FEM_ENGINES_PKG.PUT_MESSAGE(

3361:
3362: WHEN NO_VALID_COMPONENTS_EXCEPTION THEN
3363: x_err_code := -1;
3364: x_err_msg := G_NO_VALID_COMPS;
3365: FEM_ENGINES_PKG.PUT_MESSAGE(
3366: p_app_name => FEM_APP,
3367: p_msg_name => x_err_msg);
3368: RETURN;
3369:

Line 3373: FEM_ENGINES_PKG.PUT_MESSAGE(

3369:
3370: WHEN NO_COMPONENTS_EXCEPTION THEN
3371: x_err_code := -1;
3372: x_err_msg := G_NO_COMPONENTS;
3373: FEM_ENGINES_PKG.PUT_MESSAGE(
3374: p_app_name => FEM_APP,
3375: p_msg_name => x_err_msg);
3376: RETURN;
3377:

Line 3381: FEM_ENGINES_PKG. PUT_MESSAGE(

3377:
3378: WHEN INVALID_DIM_COMP_EXCEPTION THEN
3379: x_err_code := -1;
3380: x_err_msg := G_INVALID_DIM_COMPONENT;
3381: FEM_ENGINES_PKG. PUT_MESSAGE(
3382: p_app_name => FEM_APP,
3383: p_msg_name => x_err_msg,
3384: p_token1 => G_CONDITION_TOKEN,
3385: p_value1 => z_conditionObjectDefName,

Line 3395: --FEM_ENGINES_PKG.USER_MESSAGE(x_err_msg);

3391:
3392: WHEN OTHERS THEN
3393: x_err_code := SQLCODE;
3394: x_err_msg := G_UNHANDLED_EXCEPTION;
3395: --FEM_ENGINES_PKG.USER_MESSAGE(x_err_msg);
3396: FEM_ENGINES_PKG. PUT_MESSAGE(
3397: p_app_name => FEM_APP,
3398: p_msg_name => G_UNHANDLED_EXCEPTION);
3399: RETURN;

Line 3396: FEM_ENGINES_PKG. PUT_MESSAGE(

3392: WHEN OTHERS THEN
3393: x_err_code := SQLCODE;
3394: x_err_msg := G_UNHANDLED_EXCEPTION;
3395: --FEM_ENGINES_PKG.USER_MESSAGE(x_err_msg);
3396: FEM_ENGINES_PKG. PUT_MESSAGE(
3397: p_app_name => FEM_APP,
3398: p_msg_name => G_UNHANDLED_EXCEPTION);
3399: RETURN;
3400:

Line 3539: FEM_ENGINES_PKG.Tech_Message (

3535: if (FND_API.To_Boolean(p_init_msg_list)) then
3536: FND_MSG_PUB.Initialize;
3537: end if;
3538:
3539: FEM_ENGINES_PKG.Tech_Message (
3540: p_severity => G_LOG_LEVEL_PROCEDURE
3541: ,p_module => G_BLOCK||'.'||l_api_name
3542: ,p_msg_text => 'BEGIN'
3543: );

Line 3549: FEM_ENGINES_PKG.PUT_MESSAGE (

3545: -- Initialize API return status to success
3546: x_return_status := FND_API.G_RET_STS_SUCCESS;
3547:
3548: if (p_dimension_id is null) then
3549: FEM_ENGINES_PKG.PUT_MESSAGE (
3550: p_app_name => G_FEM
3551: ,p_msg_name => G_NULL_PARAM_VALUE_ERR
3552: ,p_token1 => G_PARAM_TOKEN
3553: ,p_value1 => 'p_dimension_id'

Line 3559: FEM_ENGINES_PKG.PUT_MESSAGE (

3555: raise FND_API.G_EXC_ERROR;
3556: end if;
3557:
3558: if (p_hierarchy_object_id is null) then
3559: FEM_ENGINES_PKG.PUT_MESSAGE (
3560: p_app_name => G_FEM
3561: ,p_msg_name => G_NULL_PARAM_VALUE_ERR
3562: ,p_token1 => G_PARAM_TOKEN
3563: ,p_value1 => 'p_hierarchy_object_id'

Line 3569: FEM_ENGINES_PKG.PUT_MESSAGE (

3565: raise FND_API.G_EXC_ERROR;
3566: end if;
3567:
3568: if (p_effective_date is null) then
3569: FEM_ENGINES_PKG.PUT_MESSAGE (
3570: p_app_name => G_FEM
3571: ,p_msg_name => G_NULL_PARAM_VALUE_ERR
3572: ,p_token1 => G_PARAM_TOKEN
3573: ,p_value1 => 'p_effective_date'

Line 3579: FEM_ENGINES_PKG.PUT_MESSAGE (

3575: raise FND_API.G_EXC_ERROR;
3576: end if;
3577:
3578: if (p_relation_code is null) then
3579: FEM_ENGINES_PKG.PUT_MESSAGE (
3580: p_app_name => G_FEM
3581: ,p_msg_name => G_NULL_PARAM_VALUE_ERR
3582: ,p_token1 => G_PARAM_TOKEN
3583: ,p_value1 => 'p_relation_code'

Line 3589: FEM_ENGINES_PKG.PUT_MESSAGE (

3585: raise FND_API.G_EXC_ERROR;
3586: end if;
3587:
3588: if (p_node_id is null) then
3589: FEM_ENGINES_PKG.PUT_MESSAGE (
3590: p_app_name => G_FEM
3591: ,p_msg_name => G_NULL_PARAM_VALUE_ERR
3592: ,p_token1 => G_PARAM_TOKEN
3593: ,p_value1 => 'p_node_id'

Line 3626: FEM_ENGINES_PKG.PUT_MESSAGE (

3622: where a.dimension_id = p_dimension_id;
3623: exception
3624: when others then
3625: -- Invalid Dimension Id
3626: FEM_ENGINES_PKG.PUT_MESSAGE (
3627: p_app_name => G_FEM
3628: ,p_msg_name => G_BAD_DIM_ID_ERR
3629: ,p_token1 => G_DIM_ID_TOKEN
3630: ,p_value1 => p_dimension_id

Line 3637: FEM_ENGINES_PKG.PUT_MESSAGE (

3633: end;
3634:
3635: if (l_hierarchy_table_name is null) then
3636: -- Invalid Dimension
3637: FEM_ENGINES_PKG.PUT_MESSAGE (
3638: p_app_name => G_FEM
3639: ,p_msg_name => G_DIM_BAD_DIM_LABEL
3640: ,p_token1 => G_DIM_LABEL_TOKEN
3641: ,p_value1 => l_dimension_varchar_label

Line 3660: FEM_ENGINES_PKG.PUT_MESSAGE (

3656:
3657: if (l_value_set_id is null) then
3658:
3659: -- Value Set Id cannot be null for VSR dimensions
3660: FEM_ENGINES_PKG.PUT_MESSAGE (
3661: p_app_name => G_FEM
3662: ,p_msg_name => G_NULL_PARAM_VALUE_ERR
3663: ,p_token1 => G_PARAM_TOKEN
3664: ,p_value1 => 'p_value_set_id'

Line 3689: FEM_ENGINES_PKG.PUT_MESSAGE (

3685: from fem_hier_definitions
3686: where hierarchy_obj_def_id = l_hierarchy_obj_def_id;
3687:
3688: if (l_flattened_code <> 'COMPLETED') then
3689: FEM_ENGINES_PKG.PUT_MESSAGE (
3690: p_app_name => G_FEM
3691: ,p_msg_name => G_HIER_FLATTENED
3692: );
3693: raise FND_API.G_EXC_ERROR;

Line 3715: FEM_ENGINES_PKG.PUT_MESSAGE (

3711: ,x_object_name => l_hierarchy_obj_def_name
3712: ,x_folder_name => l_hierarchy_folder_name
3713: );
3714:
3715: FEM_ENGINES_PKG.PUT_MESSAGE (
3716: p_app_name => G_FEM
3717: ,p_msg_name => G_INVALID_NODE
3718: ,p_token1 => G_NODE_TOKEN
3719: ,p_value1 => p_node_id

Line 3753: FEM_ENGINES_PKG.PUT_MESSAGE (

3749: end if;
3750:
3751: if (l_query_string is null) then
3752:
3753: FEM_ENGINES_PKG.PUT_MESSAGE (
3754: p_app_name => G_FEM
3755: ,p_msg_name => G_INVALID_RELATION
3756: ,p_token1 => G_RELATION_TOKEN
3757: ,p_value1 => p_relation_code

Line 3780: FEM_ENGINES_PKG.Tech_Message (

3776: p_count => x_msg_count
3777: ,p_data => x_msg_data
3778: );
3779:
3780: FEM_ENGINES_PKG.Tech_Message (
3781: p_severity => G_LOG_LEVEL_PROCEDURE
3782: ,p_module => G_BLOCK||'.'||l_api_name
3783: ,p_msg_text => 'END'
3784: );