[Home] [Help]
2699: l_proc_name CONSTANT VARCHAR2(30) := 'Validate_Func_Param_Mappings';
2700: -- for error logging
2701: --
2702: l_entity_code VARCHAR2(30) := G_ENTITY_ICC_FN_PARAM_MAP;
2703: l_token_table ERROR_HANDLER.Token_Tbl_Type;
2704:
2705: l_function_id ego_func_params_b.function_id%TYPE;
2706: l_func_param_id ego_func_params_b.func_param_id%TYPE;
2707: l_func_params_tbl ego_func_param_map_tbl_type;
2754:
2755: l_token_table(2).token_name := 'ICC_NAME';
2756: l_token_table(2).token_value := p_func_param_assoc_rec.item_catalog_name;
2757:
2758: ERROR_HANDLER.Add_Error_Message(
2759: p_message_name => 'EGO_FUNC_NOT_ASSOC_ICC'
2760: ,p_application_id => G_APPL_NAME
2761: ,p_row_identifier => p_func_param_assoc_rec.transaction_id
2762: ,p_token_tbl => l_token_table
2795:
2796: x_return_status := G_RET_STS_ERROR;
2797: l_token_table(1).token_name := 'PARAM_NAME';
2798: l_token_table(1).token_value := p_func_param_assoc_rec.parameter_name;
2799: ERROR_HANDLER.Add_Error_Message(
2800: p_message_name => 'EGO_MAPPING_DOES_NOT_EXIST'
2801: ,p_application_id => G_APPL_NAME
2802: ,p_token_tbl => l_token_table
2803: ,p_row_identifier => p_func_param_assoc_rec.transaction_id
2842:
2843: IF l_func_param_id IS NULL THEN
2844:
2845: x_return_status := G_RET_STS_ERROR;
2846: ERROR_HANDLER.Add_Error_Message(
2847: p_message_name => 'EGO_ICC_FUNC_UOM_PARAM_INVALID'
2848: ,p_application_id => G_APPL_NAME
2849: ,p_row_identifier => p_func_param_assoc_rec.transaction_id
2850: ,p_entity_code => l_entity_code
2867:
2868: x_return_status := G_RET_STS_ERROR;
2869: l_token_table(1).token_name := 'UOM_PARAM';
2870: l_token_table(1).token_value := p_func_param_assoc_rec.uom_parameter;
2871: ERROR_HANDLER.Add_Error_Message(
2872: p_message_name => 'EGO_ICC_FUNC_UOM_PARAM_INVALID'
2873: ,p_application_id => G_APPL_NAME
2874: ,p_token_tbl => l_token_table
2875: ,p_row_identifier => p_func_param_assoc_rec.transaction_id
2891: x_return_status := G_RET_STS_ERROR;
2892: l_token_table(1).token_name := 'COL_NAME';
2893: l_token_table(1).token_value := 'UOM_PARAM_VALUE_TYPE';
2894:
2895: ERROR_HANDLER.Add_Error_Message(
2896: p_message_name => 'EGO_INVALID_VALUE_FOR_COL'
2897: ,p_application_id => G_APPL_NAME
2898: ,p_row_identifier => p_func_param_assoc_rec.transaction_id
2899: ,p_entity_code => l_entity_code
2909: x_return_status := G_RET_STS_ERROR;
2910: l_token_table(1).token_name := 'MAPPED_ATTR';
2911: l_token_table(1).token_value := p_func_param_assoc_rec.uom_parameter;
2912:
2913: ERROR_HANDLER.Add_Error_Message(
2914: p_message_name => 'EGO_FIXED_UOM_REQUIRED'
2915: ,p_application_id => G_APPL_NAME
2916:
2917: ,p_row_identifier => p_func_param_assoc_rec.transaction_id
3000: l_proc_name CONSTANT VARCHAR2(30) := 'Validate_YesNo_Cols';
3001: -- for error logging
3002: --
3003: l_entity_code VARCHAR2(30) := G_ENTITY_ICC_HEADER;
3004: l_token_table ERROR_HANDLER.Token_Tbl_Type;
3005:
3006: l_return_msg VARCHAR2(4000);
3007: l_return_status VARCHAR2(1);
3008:
3021: x_return_status := G_RET_STS_ERROR;
3022: l_token_table(1).token_name := 'COL_NAME';
3023: l_token_table(1).token_value := 'ENABLED_FLAG';
3024:
3025: ERROR_HANDLER.Add_Error_Message(
3026: p_message_name => 'EGO_INVALID_VALUE_FOR_COL'
3027: ,p_application_id => G_APPL_NAME
3028: ,p_token_tbl => l_token_table
3029: ,p_row_identifier => p_icc_rec.transaction_id
3049: x_return_status := G_RET_STS_ERROR;
3050: l_token_table(1).token_name := 'COL_NAME';
3051: l_token_table(1).token_value := 'ITEM_CREATION_ALLOWED_FLAG';
3052:
3053: ERROR_HANDLER.Add_Error_Message(
3054: p_message_name => 'EGO_INVALID_VALUE_FOR_COL'
3055: ,p_application_id => G_APPL_NAME
3056: ,p_token_tbl => l_token_table
3057: ,p_row_identifier => p_icc_rec.transaction_id
3078: x_return_status := G_RET_STS_ERROR;
3079: l_token_table(1).token_name := 'COL_NAME';
3080: l_token_table(1).token_value := 'ENABLE_KEY_ATTRS_DESC';
3081:
3082: ERROR_HANDLER.Add_Error_Message(
3083: p_message_name => 'EGO_INVALID_VALUE_FOR_COL'
3084: ,p_application_id => G_APPL_NAME
3085: ,p_token_tbl => l_token_table
3086: ,p_row_identifier => p_icc_rec.transaction_id
3105: x_return_status := G_RET_STS_ERROR;
3106: l_token_table(1).token_name := 'COL_NAME';
3107: l_token_table(1).token_value := 'ENABLE_KEY_ATTRS_NUM';
3108:
3109: ERROR_HANDLER.Add_Error_Message(
3110: p_message_name => 'EGO_INVALID_VALUE_FOR_COL'
3111: ,p_application_id => G_APPL_NAME
3112: ,p_token_tbl => l_token_table
3113: ,p_row_identifier => p_icc_rec.transaction_id
3149: l_proc_name CONSTANT VARCHAR2(30) := 'Validate_Func_Related_Cols';
3150: -- for error logging
3151: --
3152: l_entity_code VARCHAR2(30) := G_ENTITY_ICC_HEADER;
3153: l_token_table ERROR_HANDLER.Token_Tbl_Type;
3154:
3155: l_function_id NUMBER := NULL;
3156: l_func_params_tbl ego_func_param_map_tbl_type;
3157:
3174: x_return_status := G_RET_STS_ERROR; -- added bug 9737833
3175: l_token_table(1).token_name := 'ITEM_NUM_GEN_METHOD_TYPE';
3176: l_token_table(1).token_value := p_icc_rec.ITEM_NUM_GEN_METHOD_TYPE;
3177:
3178: ERROR_HANDLER.Add_Error_Message(
3179: p_message_name => 'EGO_FUNC_TYPECODE_INVALID'
3180: ,p_application_id => G_APPL_NAME
3181: ,p_token_tbl => l_token_table
3182: ,p_row_identifier => p_icc_rec.transaction_id
3206: OR
3207: (p_icc_rec.increment_by IS NULL OR p_icc_rec.increment_by = G_MISS_NUM) THEN
3208: x_return_status := G_RET_STS_ERROR;
3209:
3210: ERROR_HANDLER.Add_Error_Message(
3211: p_message_name => 'EGO_ITEM_NUM_FN_COLS_INVALID'
3212: ,p_application_id => G_APPL_NAME
3213:
3214: ,p_row_identifier => p_icc_rec.transaction_id
3221: p_icc_rec.increment_by <= 0 THEN
3222:
3223: x_return_status := G_RET_STS_ERROR;
3224:
3225: ERROR_HANDLER.Add_Error_Message(
3226: p_message_name => 'EGO_ITEM_NUM_FN_COLS_INVALID'
3227: ,p_application_id => G_APPL_NAME
3228: ,p_row_identifier => p_icc_rec.transaction_id
3229: ,p_entity_code => l_entity_code
3229: ,p_entity_code => l_entity_code
3230: ,p_table_name => G_ENTITY_ICC_HEADER_TAB
3231: );
3232:
3233: ERROR_HANDLER.Add_Error_Message(
3234: p_message_name => 'EGO_INPUT_NUMBERS_ONLY'
3235: ,p_application_id => G_APPL_NAME
3236: ,p_row_identifier => p_icc_rec.transaction_id
3237: ,p_entity_code => l_entity_code
3264: ---
3265: if p_icc_rec.ITEM_NUM_FUNCTION_ID IS NULL AND p_icc_rec.ITEM_NUM_GENERATION_FUNCTION IS NULL then
3266: x_return_status := G_RET_STS_ERROR;
3267:
3268: ERROR_HANDLER.Add_Error_Message(
3269: p_message_name => 'EGO_ITEM_NUM_FUNC_INVALID'
3270: ,p_application_id => G_APPL_NAME
3271:
3272: ,p_row_identifier => p_icc_rec.transaction_id
3284: IF l_function_id IS NULL THEN
3285:
3286: x_return_status := G_RET_STS_ERROR;
3287:
3288: ERROR_HANDLER.Add_Error_Message(
3289: p_message_name => 'EGO_ITEM_NUM_FUNC_INVALID'
3290: ,p_application_id => G_APPL_NAME
3291:
3292: ,p_row_identifier => p_icc_rec.transaction_id
3307: IF l_function_id IS NULL THEN
3308:
3309: x_return_status := G_RET_STS_ERROR;
3310:
3311: ERROR_HANDLER.Add_Error_Message(
3312: p_message_name => 'EGO_ITEM_NUM_FUNC_INVALID'
3313: ,p_application_id => G_APPL_NAME
3314: ,p_row_identifier => p_icc_rec.transaction_id
3315: ,p_entity_code => l_entity_code
3339: l_token_table(2).token_name := 'COL_NAME';
3340: l_token_table(2).token_value := 'ITEM_NUM_GEN_METHOD_TYPE';
3341:
3342:
3343: ERROR_HANDLER.Add_Error_Message(
3344: p_message_name => 'EGO_INVALID_VAL_PARENT_MISSING'
3345: ,p_application_id => G_APPL_NAME
3346: ,p_token_tbl => l_token_table
3347: ,p_row_identifier => p_icc_rec.transaction_id
3368: l_token_table(2).token_name := 'COL_NAME';
3369: l_token_table(2).token_value := 'ITEM_NUM_GEN_METHOD_TYPE';
3370:
3371:
3372: ERROR_HANDLER.Add_Error_Message(
3373: p_message_name => 'EGO_INVALID_VAL_PARENT_MISSING'
3374: ,p_application_id => G_APPL_NAME
3375: ,p_token_tbl => l_token_table
3376: ,p_row_identifier => p_icc_rec.transaction_id
3395:
3396: l_token_table(1).token_name := 'ITEM_DESC_GEN_METHOD_TYPE';
3397: l_token_table(1).token_value := p_icc_rec.ITEM_DESC_GEN_METHOD_TYPE;
3398:
3399: ERROR_HANDLER.Add_Error_Message(
3400: p_message_name => 'EGO_FUNC_TYPECODE_INVALID'
3401: ,p_application_id => G_APPL_NAME
3402: ,p_token_tbl => l_token_table
3403:
3419: l_function_id := NULL;
3420: IF p_icc_rec.ITEM_DESC_FUNCTION_ID IS NULL AND p_icc_rec.ITEM_desc_GENERATION_FUNCTION IS NULL then
3421: x_return_status := G_RET_STS_ERROR;
3422:
3423: ERROR_HANDLER.Add_Error_Message(
3424: p_message_name => 'EGO_ITEM_DESC_FUNC_INVALID'
3425: ,p_application_id => G_APPL_NAME
3426:
3427: ,p_row_identifier => p_icc_rec.transaction_id
3438: IF l_function_id IS NULL THEN
3439:
3440: x_return_status := G_RET_STS_ERROR;
3441:
3442: ERROR_HANDLER.Add_Error_Message(
3443: p_message_name => 'EGO_ITEM_DESC_FUNC_INVALID'
3444: ,p_application_id => G_APPL_NAME
3445:
3446: ,p_row_identifier => p_icc_rec.transaction_id
3460: IF l_function_id IS NULL THEN
3461:
3462: x_return_status := G_RET_STS_ERROR;
3463:
3464: ERROR_HANDLER.Add_Error_Message(
3465: p_message_name => 'EGO_ITEM_NUM_FUNC_INVALID'
3466: ,p_application_id => G_APPL_NAME
3467:
3468: ,p_row_identifier => p_icc_rec.transaction_id
3493: l_token_table(2).token_name := 'COL_NAME';
3494: l_token_table(2).token_value := 'ITEM_DESC_GEN_METHOD_TYPE';
3495:
3496:
3497: ERROR_HANDLER.Add_Error_Message(
3498: p_message_name => 'EGO_INVALID_VAL_PARENT_MISSING'
3499: ,p_application_id => G_APPL_NAME
3500: ,p_token_tbl => l_token_table
3501: ,p_row_identifier => p_icc_rec.transaction_id
3522: l_token_table(2).token_name := 'COL_NAME';
3523: l_token_table(2).token_value := 'ITEM_DESC_GEN_METHOD_TYPE';
3524:
3525:
3526: ERROR_HANDLER.Add_Error_Message(
3527: p_message_name => 'EGO_INVALID_VAL_PARENT_MISSING'
3528: ,p_application_id => G_APPL_NAME
3529: ,p_token_tbl => l_token_table
3530: ,p_row_identifier => p_icc_rec.transaction_id
3559: l_proc_name CONSTANT VARCHAR2(30) := 'validate_NIR_Columns';
3560: -- for error logging
3561: --
3562: l_entity_code VARCHAR2(30) := G_ENTITY_ICC_HEADER;
3563: l_token_table ERROR_HANDLER.Token_Tbl_Type;
3564:
3565: l_change_order_type ENG_CHANGE_ORDER_TYPES.change_order_type%TYPE := null;
3566: l_change_type_id NUMBER := NULL;
3567:
3604: x_return_status := G_RET_STS_ERROR;
3605: l_token_table(1).token_name := 'NIR_TYPE';
3606: l_token_table(1).token_value := p_icc_rec.NEW_ITEM_REQUEST_TYPE;
3607:
3608: ERROR_HANDLER.Add_Error_Message(
3609: p_message_name => 'EGO_ICC_NIR_TYPE_INVALID'
3610: ,p_application_id => G_APPL_NAME
3611: ,p_token_tbl => l_token_table
3612: ,p_row_identifier => p_icc_rec.transaction_id
3631: x_return_status := G_RET_STS_ERROR;
3632: l_token_table(1).token_name := 'VALUE';
3633: l_token_table(1).token_value := p_icc_rec.NEW_ITEM_REQ_CHANGE_TYPE_ID;
3634:
3635: ERROR_HANDLER.Add_Error_Message(
3636: p_message_name => 'EGO_CHGTYPE_DOESNOT_EXIST'
3637: ,p_application_id => G_APPL_NAME
3638: ,p_token_tbl => l_token_table
3639: ,p_row_identifier => p_icc_rec.transaction_id
3653: x_return_status := G_RET_STS_ERROR;
3654: l_token_table(1).token_name := 'VALUE';
3655: l_token_table(1).token_value := p_icc_rec.NEW_ITEM_REQUEST_NAME;
3656:
3657: ERROR_HANDLER.Add_Error_Message(
3658: p_message_name => 'EGO_CHGTYPE_DOESNOT_EXIST'
3659: ,p_application_id => G_APPL_NAME
3660: ,p_token_tbl => l_token_table
3661: ,p_row_identifier => p_icc_rec.transaction_id
3672: x_return_status := G_RET_STS_ERROR;
3673: l_token_table(1).token_name := 'VALUE';
3674: l_token_table(1).token_value := p_icc_rec.NEW_ITEM_REQUEST_NAME;
3675:
3676: ERROR_HANDLER.Add_Error_Message(
3677: p_message_name => 'EGO_CHGTYPE_DOESNOT_EXIST'
3678: ,p_application_id => G_APPL_NAME
3679: ,p_token_tbl => l_token_table
3680: ,p_row_identifier => p_icc_rec.transaction_id
3701: l_token_table(2).token_name := 'COL_NAME';
3702: l_token_table(2).token_value := 'NEW_ITEM_REQUEST_TYPE';
3703:
3704:
3705: ERROR_HANDLER.Add_Error_Message(
3706: p_message_name => 'EGO_INVALID_VAL_PARENT_MISSING'
3707: ,p_application_id => G_APPL_NAME
3708: ,p_token_tbl => l_token_table
3709: ,p_row_identifier => p_icc_rec.transaction_id
3730: l_token_table(2).token_name := 'COL_NAME';
3731: l_token_table(2).token_value := 'NEW_ITEM_REQUEST_TYPE';
3732:
3733:
3734: ERROR_HANDLER.Add_Error_Message(
3735: p_message_name => 'EGO_INVALID_VAL_PARENT_MISSING'
3736: ,p_application_id => G_APPL_NAME
3737: ,p_token_tbl => l_token_table
3738: ,p_row_identifier => p_icc_rec.transaction_id
3791: )
3792: IS
3793: l_proc_name CONSTANT VARCHAR2(30) := 'Attribute_Defaulting';
3794: l_null_icc_rec_type EGO_ITEM_CATALOG_PUB.Catalog_Group_Rec_Type := null ;
3795: l_Mesg_Token_tbl Error_Handler.Mesg_Token_Tbl_Type;
3796:
3797:
3798: -- for error logging
3799: --
3797:
3798: -- for error logging
3799: --
3800: l_entity_code VARCHAR2(30) := G_ENTITY_ICC_HEADER;
3801: l_token_table ERROR_HANDLER.Token_Tbl_Type;
3802:
3803:
3804:
3805: BEGIN
3953: IS
3954: l_proc_name CONSTANT VARCHAR2(30) := 'Populate_Null_Cols';
3955:
3956: l_null_icc_rec_type EGO_ITEM_CATALOG_PUB.Catalog_Group_Rec_Type := null ;
3957: l_Mesg_Token_tbl Error_Handler.Mesg_Token_Tbl_Type;
3958:
3959:
3960: -- for error logging
3961: --
3959:
3960: -- for error logging
3961: --
3962: l_entity_code VARCHAR2(30) := G_ENTITY_ICC_HEADER;
3963: l_token_table ERROR_HANDLER.Token_Tbl_Type;
3964:
3965:
3966: BEGIN
3967: write_debug(l_proc_name,'Start');
4637: IS
4638: l_proc_name CONSTANT VARCHAR2(30) := 'Value_To_ID_COnversion';
4639: e_stop_processing EXCEPTION;
4640: l_null_icc_rec_type EGO_ITEM_CATALOG_PUB.Catalog_Group_Rec_Type := null ;
4641: l_Mesg_Token_tbl Error_Handler.Mesg_Token_Tbl_Type;
4642: l_dummy boolean;
4643: l_data_level_id ego_data_level_b.data_level_id%TYPE := NULL;
4644: l_icc_name mtl_item_catalog_groups_b_kfv.padded_concatenated_segments%TYPE := null;
4645: l_association_id ego_obj_ag_assocs_b.association_id%TYPE := null;
4652:
4653: -- for error logging
4654: --
4655: l_entity_code VARCHAR2(30) := null;
4656: l_token_table ERROR_HANDLER.Token_Tbl_Type;
4657:
4658:
4659: BEGIN
4660: write_debug (l_proc_name, 'Start of '||l_proc_name);
4727: IF p_icc_rec.transaction_type = G_TTYPE_UPDATE AND NOT Check_Catalog_CCID (p_icc_rec.item_catalog_group_id) THEN
4728:
4729: l_return_status := G_RET_STS_ERROR;
4730:
4731: ERROR_HANDLER.Add_Error_Message(
4732: p_message_name => 'EGO_ICC_ID_INVALID'
4733: ,p_application_id => G_APPL_NAME
4734: ,p_token_tbl => l_token_table
4735:
4749: IF p_icc_rec.item_catalog_group_id IS NOT NULL THEN
4750:
4751: l_return_status := G_RET_STS_ERROR;
4752:
4753: ERROR_HANDLER.Add_Error_Message(
4754: p_message_name => 'EGO_CATALOG_GROUP_EXISTS'
4755: ,p_application_id => G_APPL_NAME
4756: ,p_token_tbl => l_token_table
4757: ,p_row_identifier => p_icc_rec.transaction_id
4782:
4783: l_token_table(1).TOKEN_NAME := 'ICC_NAME';
4784: l_token_table(1).TOKEN_VALUE := p_icc_rec.parent_catalog_group_name;
4785:
4786: ERROR_HANDLER.Add_Error_Message(
4787: p_message_name => 'EGO_ICC_PARENT_INVALID'
4788: ,p_application_id => G_APPL_NAME
4789: ,p_token_tbl => l_token_table
4790: ,p_row_identifier => p_icc_rec.transaction_id
4805:
4806: l_token_table(1).TOKEN_NAME := 'ICC_NAME';
4807: l_token_table(1).TOKEN_VALUE := p_icc_rec.parent_catalog_group_name;
4808:
4809: ERROR_HANDLER.Add_Error_Message(
4810: p_message_name => 'ICC_PARENT_NO_RELEASE_VER'
4811: ,p_application_id => G_APPL_NAME
4812: ,p_token_tbl => l_token_table
4813: ,p_row_identifier => p_icc_rec.transaction_id
4835: AND Has_Released_Version(p_icc_rec.item_catalog_group_id)
4836: AND G_P4TP_PROFILE_ENABLED
4837: AND NVL(g_old_icc_rec.PARENT_CATALOG_GROUP_ID, -99999) <> p_icc_rec.parent_catalog_group_id THEN
4838:
4839: ERROR_HANDLER.Add_Error_Message(
4840: p_message_name => 'EGO_ICC_DIS_UPD'
4841: ,p_application_id => G_APPL_NAME
4842: ,p_token_tbl => l_token_table
4843: ,p_row_identifier => p_icc_rec.transaction_id
4861: AND Has_OnlyDraft_Version(p_icc_rec.item_catalog_group_id)
4862: AND G_P4TP_PROFILE_ENABLED
4863: AND g_old_icc_rec.PARENT_CATALOG_GROUP_ID <> p_icc_rec.parent_catalog_group_id THEN
4864:
4865: ERROR_HANDLER.Add_Error_Message(
4866: p_message_name => 'EGO_ICC_DIS_UPD'
4867: ,p_application_id => G_APPL_NAME
4868: ,p_token_tbl => l_token_table
4869: ,p_row_identifier => p_icc_rec.transaction_id
4892: IF p_icc_rec.inactive_date IS NOT NULL
4893: AND p_icc_rec.inactive_date <> G_MISS_DATE
4894: AND TRUNC(p_icc_rec.inactive_date) < TRUNC(SYSDATE) THEN
4895:
4896: ERROR_HANDLER.Add_Error_Message(
4897: p_message_name => 'EGO_ENDDATE_EXCEEDS_SYSDATE'
4898: ,p_application_id => G_APPL_NAME
4899: ,p_token_tbl => l_token_table
4900: ,p_row_identifier => p_icc_rec.transaction_id
4977: IF Check_Seeded_AG_Assoc ( p_icc_id => p_ag_assoc_rec.item_catalog_group_id
4978: ,p_attr_grp_id => p_ag_assoc_rec.attr_group_id
4979: ) THEN
4980:
4981: ERROR_HANDLER.Add_Error_Message(
4982: p_message_name => 'EGO_CANNOT_UPDATE_SEEDED_AG'
4983: ,p_application_id => G_APPL_NAME
4984: ,p_row_identifier => p_ag_assoc_rec.transaction_id
4985: ,p_entity_code => l_entity_code
5006: l_token_table(2).TOKEN_NAME := 'ICC_NAME';
5007: l_token_table(2).TOKEN_VALUE := p_ag_assoc_rec.item_catalog_name;
5008:
5009:
5010: ERROR_HANDLER.Add_Error_Message(
5011: p_message_name => 'EGO_AG_ALREADY_ASSOCIATED_ICC'
5012: ,p_application_id => G_APPL_NAME
5013: ,p_token_tbl => l_token_table
5014: ,p_row_identifier => p_ag_assoc_rec.transaction_id
5024:
5025: l_token_table(1).TOKEN_NAME := 'AG_NAME';
5026: l_token_table(1).TOKEN_VALUE := p_ag_assoc_rec.attr_group_name;
5027:
5028: ERROR_HANDLER.Add_Error_Message(
5029: p_message_name => 'EGO_AG_NOT_ASSOCIATED_ICC'
5030: ,p_application_id => G_APPL_NAME
5031: ,p_token_tbl => l_token_table
5032:
5066:
5067: l_token_table(1).TOKEN_NAME := 'entity';
5068: l_token_table(1).TOKEN_VALUE := G_ENTITY_ICC_VERSION;
5069:
5070: ERROR_HANDLER.Add_Error_Message(
5071: p_message_name => 'EGO_TRANS_TYPE_INVALID'
5072: ,p_application_id => G_APPL_NAME
5073: ,p_token_tbl => l_token_table
5074: ,p_row_identifier => p_icc_ver_rec.transaction_id
5092: IF p_icc_ver_rec.item_catalog_group_id IS NOT NULL
5093: AND NOT Check_Catalog_CCID (p_icc_ver_rec.item_catalog_group_id) THEN
5094:
5095: l_return_status := G_RET_STS_ERROR;
5096: ERROR_HANDLER.Add_Error_Message(
5097: p_message_name => 'EGO_ICC_ID_INVALID'
5098: ,p_application_id => G_APPL_NAME
5099: ,p_token_tbl => l_token_table
5100: ,p_row_identifier => p_icc_ver_rec.transaction_id
5114: write_debug (l_proc_name, 'catalog GROUP ID =>'||NVL(p_icc_ver_rec.item_catalog_group_id, -999999));
5115:
5116: IF p_icc_ver_rec.item_catalog_group_id IS NULL THEN
5117: l_return_status := G_RET_STS_ERROR;
5118: ERROR_HANDLER.Add_Error_Message(
5119: p_message_name => 'EGO_ICC_ID_INVALID'
5120: ,p_application_id => G_APPL_NAME
5121: ,p_token_tbl => l_token_table
5122: ,p_row_identifier => p_icc_ver_rec.transaction_id
5156: ---
5157: l_token_table(1).TOKEN_NAME := 'ICC_NAME';
5158: l_token_table(1).TOKEN_VALUE := p_icc_ver_rec.item_catalog_name;
5159:
5160: ERROR_HANDLER.Add_Error_Message(
5161: p_message_name => 'EGO_VER_SEQ_ZERO_ERROR'
5162: ,p_application_id => G_APPL_NAME
5163: ,p_token_tbl => l_token_table
5164: ,p_row_identifier => p_icc_ver_rec.transaction_id
5188:
5189: l_token_table(3).TOKEN_NAME := 'ICC_NAME';
5190: l_token_table(3).TOKEN_VALUE := p_icc_ver_rec.item_catalog_name;
5191:
5192: ERROR_HANDLER.Add_Error_Message(
5193: p_message_name => 'EGO_VER_START_DATE_PAST'
5194: ,p_application_id => G_APPL_NAME
5195: ,p_token_tbl => l_token_table
5196:
5231:
5232: IF x_return_status = G_RET_STS_ERROR THEN
5233: l_return_status := G_RET_STS_ERROR;
5234:
5235: ERROR_HANDLER.Add_Error_Message(
5236: p_message_text => x_return_msg
5237: ,p_application_id => G_APPL_NAME
5238: ,p_token_tbl => l_token_table
5239: ,p_row_identifier => p_icc_ver_rec.transaction_id
5257:
5258: l_token_table(2).TOKEN_NAME := 'PARTY_NAME';
5259: l_token_table(2).TOKEN_VALUE := l_user_name;
5260:
5261: ERROR_HANDLER.Add_Error_Message(
5262: p_message_name => 'EGO_ENTITY_LOCKED'
5263: ,p_application_id => G_APPL_NAME
5264: ,p_token_tbl => l_token_table
5265: ,p_row_identifier => p_icc_ver_rec.transaction_id
5291:
5292: l_token_table(2).TOKEN_NAME := 'ICC_NAME';
5293: l_token_table(2).TOKEN_VALUE := p_icc_ver_rec.item_catalog_name;
5294:
5295: ERROR_HANDLER.Add_Error_Message(
5296: p_message_name => 'EGO_VER_ALREADY_EXISTS_DT'
5297: ,p_application_id => G_APPL_NAME
5298: ,p_token_tbl => l_token_table
5299: ,p_row_identifier => p_icc_ver_rec.transaction_id
5329: l_token_table(2).TOKEN_NAME := 'VER_SEQ';
5330: l_token_table(2).TOKEN_VALUE := p_icc_ver_rec.ver_seq_no;
5331:
5332:
5333: ERROR_HANDLER.Add_Error_Message(
5334: p_message_name => 'EGO_RELATED_TA_FAIL'
5335: ,p_application_id => G_APPL_NAME
5336: ,p_token_tbl => l_token_table
5337: ,p_row_identifier => p_icc_ver_rec.transaction_id
5682: G_TOKEN_TBL(3).Token_Value := 'ego_ext_fwk_pub';
5683: G_TOKEN_TBL(4).Token_Name := 'Proc_Name';
5684: G_TOKEN_TBL(4).Token_Value := 'Create_page';
5685:
5686: error_handler.Add_error_message(p_message_name => 'EGO_ENTITY_API_FAILED',p_application_id => G_EGO_APPLICATION_ID,
5687: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
5688: p_row_identifier => p_icc_rec.transaction_id,
5689: p_entity_code => G_ENTITY_ICC_HEADER,p_table_name => G_ENTITY_ICC_HEADER_TAB);
5690:
5726:
5727: e_skip_record EXCEPTION;
5728: e_unexpected_error EXCEPTION;
5729:
5730: l_token_table ERROR_HANDLER.Token_Tbl_Type;
5731: l_msg_data VARCHAR2(4000);
5732:
5733: BEGIN
5734: x_return_status := G_RET_STS_SUCCESS;
5776: ,x_msg_data => x_return_msg
5777: );
5778: write_debug(l_proc_name, 'action display ret status =>'||x_action_id);
5779: IF x_return_status = G_RET_STS_ERROR THEN
5780: ERROR_HANDLER.Add_Error_Message(
5781: p_message_text => x_return_msg
5782: ,p_application_id => G_APPL_NAME
5783: ,p_row_identifier => p_transaction_id
5784: ,p_entity_code => l_entity_code
5792:
5793:
5794: ELSIF x_return_status = G_RET_STS_ERROR THEN
5795:
5796: ERROR_HANDLER.Add_Error_Message(
5797: p_message_text => x_return_msg
5798: ,p_application_id => G_APPL_NAME
5799: ,p_row_identifier => p_transaction_id
5800: ,p_entity_code => l_entity_code
5826: );
5827: write_debug(l_proc_name, 'action update func id=>'||p_function_id);
5828: IF x_return_status = G_RET_STS_ERROR THEN
5829:
5830: ERROR_HANDLER.Add_Error_Message(
5831: p_message_text => x_return_msg
5832: ,p_application_id => G_APPL_NAME
5833: ,p_row_identifier => p_transaction_id
5834: ,p_entity_code => l_entity_code
5875: );
5876: write_debug(l_proc_name, 'action DELETE STS=>'||x_return_status);
5877: IF x_return_status = G_RET_STS_ERROR THEN
5878:
5879: ERROR_HANDLER.Add_Error_Message(
5880: p_message_text => x_return_msg
5881: ,p_application_id => G_APPL_NAME
5882: ,p_row_identifier => p_transaction_id
5883: ,p_entity_code => l_entity_code
5889: END IF;
5890:
5891: ELSIF x_return_status = G_RET_STS_ERROR THEN
5892:
5893: ERROR_HANDLER.Add_Error_Message(
5894: p_message_text => x_return_msg
5895: ,p_application_id => G_APPL_NAME
5896: ,p_row_identifier => p_transaction_id
5897: ,p_entity_code => l_entity_code
5985: ,x_return_msg => x_return_msg
5986: );
5987: IF x_return_status = G_RET_STS_ERROR THEN
5988:
5989: ERROR_HANDLER.Add_Error_Message(
5990: p_message_text => x_return_msg
5991: ,p_application_id => G_APPL_NAME
5992:
5993: ,p_row_identifier => p_icc_rec.transaction_id
6018: ,x_return_msg => x_return_msg
6019: );
6020: IF x_return_status = G_RET_STS_ERROR THEN
6021:
6022: ERROR_HANDLER.Add_Error_Message(
6023: p_message_text => x_return_msg
6024: ,p_application_id => G_APPL_NAME
6025:
6026: ,p_row_identifier => p_icc_rec.transaction_id
6052: ,x_return_status => x_return_status
6053: ,x_return_msg => x_return_msg
6054: );
6055: IF x_return_status = G_RET_STS_ERROR THEN
6056: ERROR_HANDLER.Add_Error_Message(
6057: p_message_text => x_return_msg
6058: ,p_application_id => G_APPL_NAME
6059: ,p_row_identifier => p_icc_rec.transaction_id
6060: ,p_entity_code => l_entity_code
6084: ,x_return_status => x_return_status
6085: ,x_return_msg => x_return_msg
6086: );
6087: IF x_return_status = G_RET_STS_ERROR THEN
6088: ERROR_HANDLER.Add_Error_Message(
6089: p_message_text => x_return_msg
6090: ,p_application_id => G_APPL_NAME
6091: ,p_row_identifier => p_icc_rec.transaction_id
6092: ,p_entity_code => l_entity_code
6243: ,x_return_msg => x_return_msg
6244: );
6245: IF x_return_status = G_RET_STS_ERROR THEN
6246:
6247: ERROR_HANDLER.Add_Error_Message(
6248: p_message_text => x_return_msg
6249: ,p_application_id => G_APPL_NAME
6250: ,p_row_identifier => p_icc_rec.transaction_id
6251: ,p_entity_code => l_entity_code
6290: write_debug(l_proc_name, 'updating the enable key attrs returned with status ' || x_return_status);
6291:
6292: IF x_return_status = G_RET_STS_ERROR THEN
6293:
6294: ERROR_HANDLER.Add_Error_Message(
6295: p_message_text => x_return_msg
6296: ,p_application_id => G_APPL_NAME
6297: ,p_row_identifier => p_icc_rec.transaction_id
6298: ,p_entity_code => l_entity_code
6400: ,x_return_status => x_return_status
6401: ,x_return_msg => x_return_msg
6402: );
6403: IF x_return_status = G_RET_STS_ERROR THEN
6404: ERROR_HANDLER.Add_Error_Message(
6405: p_message_text => x_return_msg
6406: ,p_application_id => G_APPL_NAME
6407: ,p_row_identifier => p_icc_rec.transaction_id
6408: ,p_entity_code => l_entity_code
6446: write_debug(l_proc_name, 'updating the enable key attrs returned with status ' || x_return_status);
6447:
6448: IF x_return_status = G_RET_STS_ERROR THEN
6449:
6450: ERROR_HANDLER.Add_Error_Message(
6451: p_message_text => x_return_msg
6452: ,p_application_id => G_APPL_NAME
6453: ,p_row_identifier => p_icc_rec.transaction_id
6454: ,p_entity_code => l_entity_code
6645: x_api_icc_tbl EGO_ITEM_CATALOG_PUB.Catalog_Group_Tbl_Type;
6646:
6647: l_grant_guid fnd_grants.grant_guid%TYPE;
6648:
6649: x_message_list Error_Handler.Error_Tbl_Type;
6650: l_message_count NUMBER := 0;
6651: l_error_code NUMBER := 0;
6652:
6653: e_skip_record EXCEPTION;
6653: e_skip_record EXCEPTION;
6654: e_stop_processing EXCEPTION;
6655:
6656: l_entity_code VARCHAR2(30) := G_ENTITY_ICC_HEADER;
6657: l_token_table ERROR_HANDLER.Token_Tbl_Type;
6658: l_count NUMBER;
6659: e_unexpected_error EXCEPTION;
6660:
6661:
6682: );
6683: IF x_return_status = G_RET_STS_ERROR THEN
6684:
6685: write_debug('Attribute_Defaulting', 'Error Messages :');
6686: ERROR_HANDLER.Add_Error_Message(
6687: p_message_text => x_return_msg
6688: ,p_application_id => G_APPL_NAME
6689:
6690: ,p_row_identifier => p_icc_rec.transaction_id
6709: );
6710: IF x_return_status = G_RET_STS_ERROR THEN
6711:
6712: write_debug('Populate_Null_Cols', 'Error Messages :');
6713: ERROR_HANDLER.Add_Error_Message(
6714: p_message_text => x_return_msg
6715: ,p_application_id => G_APPL_NAME
6716:
6717: ,p_row_identifier => p_icc_rec.transaction_id
6739:
6740: --*****************************************************
6741: -- CREATE/UPDATE Base ICC
6742: --*****************************************************
6743: l_entity_code := G_ENTITY_ICC_HEADER; -- for error handler
6744:
6745: EGO_ITEM_CATALOG_PUB.Process_Catalog_Groups
6746: (
6747: p_api_version_number => 1.0
6744:
6745: EGO_ITEM_CATALOG_PUB.Process_Catalog_Groups
6746: (
6747: p_api_version_number => 1.0
6748: , p_init_msg_list => FALSE --- need to be FALSE since this API uses the same error_handler pkg bug 9767869
6749: , p_catalog_group_tbl => l_api_icc_tbl
6750: , p_user_id => G_USER_ID
6751: , x_catalog_group_tbl => x_api_icc_tbl
6752: , x_return_status => x_return_status
6761: write_debug(l_proc_name, 'End EGO_ITEM_CATALOG_PUB.Calling Process_Catalog_Groups msg count=>'||l_message_count);
6762:
6763: IF x_return_status = G_RET_STS_ERROR THEN
6764:
6765: Error_Handler.GET_MESSAGE_LIST(x_message_list=>x_message_list);
6766: write_debug('EGO_ITEM_CATALOG_PUB.Process_Catalog_Groups', 'Error Messages :');
6767:
6768: FOR i IN 1..l_message_count LOOP
6769: write_debug('EGO_ITEM_CATALOG_PUB.Process_Catalog_Groups', x_message_list(i).message_text);
6767:
6768: FOR i IN 1..l_message_count LOOP
6769: write_debug('EGO_ITEM_CATALOG_PUB.Process_Catalog_Groups', x_message_list(i).message_text);
6770:
6771: ERROR_HANDLER.Add_Error_Message(
6772: p_message_text => x_message_list(i).message_text
6773: ,p_application_id => G_APPL_NAME
6774: ,p_row_identifier => p_icc_rec.transaction_id
6775: ,p_entity_code => l_entity_code
6780:
6781: RAISE e_skip_record;
6782: ELSIF x_return_status = G_RET_STS_UNEXP_ERROR THEN
6783:
6784: Error_Handler.GET_MESSAGE_LIST(x_message_list=>x_message_list);
6785: write_debug('EGO_ITEM_CATALOG_PUB.Process_Catalog_Groups', 'Unexpected error');
6786: FOR i IN 1..l_message_count LOOP
6787: write_debug('EGO_ITEM_CATALOG_PUB.Process_Catalog_Groups', x_message_list(i).message_text);
6788:
6785: write_debug('EGO_ITEM_CATALOG_PUB.Process_Catalog_Groups', 'Unexpected error');
6786: FOR i IN 1..l_message_count LOOP
6787: write_debug('EGO_ITEM_CATALOG_PUB.Process_Catalog_Groups', x_message_list(i).message_text);
6788:
6789: ERROR_HANDLER.Add_Error_Message(
6790: p_message_text => x_message_list(i).message_text
6791: ,p_application_id => G_APPL_NAME
6792: ,p_row_identifier => p_icc_rec.transaction_id
6793: ,p_entity_code => l_entity_code
6849:
6850: IF x_return_status = G_RET_STS_ERROR THEN
6851: write_debug('Create_Draft_Version', x_return_msg);
6852:
6853: ERROR_HANDLER.Add_Error_Message(
6854: p_message_text => x_return_msg
6855: ,p_application_id => G_APPL_NAME
6856:
6857: ,p_row_identifier => p_icc_rec.transaction_id
6902: ,p_data => x_return_msg
6903: );
6904:
6905: IF l_count = 1 THEN
6906: ERROR_HANDLER.Add_Error_Message(
6907: p_message_text => 'EGO_SECURITY_PUB.grant_role_guid'||x_return_msg
6908: ,p_application_id => G_APPL_NAME
6909:
6910: ,p_row_identifier => p_icc_rec.transaction_id
6912: ,p_table_name => G_ENTITY_ICC_HEADER_TAB
6913: );
6914: ELSE
6915: FOR i in 1..l_count LOOP
6916: ERROR_HANDLER.Add_Error_Message(
6917: p_message_text => 'EGO_SECURITY_PUB.grant_role_guid'||FND_MSG_PUB.get
6918: ,p_application_id => G_APPL_NAME
6919:
6920: ,p_row_identifier => p_icc_rec.transaction_id
6941: FND_MSG_PUB.count_and_get ( p_count => l_count
6942: ,p_data => x_return_msg
6943: );
6944: IF l_count = 1 THEN
6945: ERROR_HANDLER.Add_Error_Message(
6946: p_message_text => 'EGO_SECURITY_PUB.grant_role_guid'||x_return_msg
6947: ,p_application_id => G_APPL_NAME
6948:
6949: ,p_row_identifier => p_icc_rec.transaction_id
6951: ,p_table_name => G_ENTITY_ICC_HEADER_TAB
6952: );
6953: ELSE
6954: FOR i in 1..l_count LOOP
6955: ERROR_HANDLER.Add_Error_Message(
6956: p_message_text => 'EGO_SECURITY_PUB.grant_role_guid'||FND_MSG_PUB.get
6957: ,p_application_id => G_APPL_NAME
6958:
6959: ,p_row_identifier => p_icc_rec.transaction_id
6975:
6976: --- For both CREATE as well as UPDATE transaction
6977: --- call the versions API to process the respective ICC versions
6978: ---
6979: ERROR_HANDLER.Set_Bo_Identifier(G_BO_IDENTIFIER_ICC);
6980:
6981: WRITE_DEBUG(l_proc_name, 'calling versions in create icc, id , name=>'||p_icc_rec.item_catalog_group_id||','||p_icc_rec.item_catalog_name);
6982:
6983: --- required by versions, when versions are processed per ICC
7086:
7087: e_skip_record EXCEPTION;
7088: e_unexpected_error EXCEPTION;
7089:
7090: l_token_table ERROR_HANDLER.Token_Tbl_Type;
7091: l_msg_data VARCHAR2(4000);
7092:
7093:
7094: BEGIN
7128: ,p_data => l_msg_data
7129: );
7130:
7131: IF l_msg_count = 1 THEN
7132: ERROR_HANDLER.Add_Error_Message(
7133: p_message_text => 'EGO_EXT_FWK_PUB.Create_Association'||x_return_msg
7134: ,p_application_id => G_APPL_NAME
7135:
7136: ,p_row_identifier => p_ag_assoc_rec.transaction_id
7138: ,p_table_name => G_ENTITY_ICC_HEADER_TAB
7139: );
7140: ELSE
7141: FOR i in 1..l_msg_count LOOP
7142: ERROR_HANDLER.Add_Error_Message(
7143: p_message_text => 'EGO_EXT_FWK_PUB.Create_Association'||FND_MSG_PUB.get
7144: ,p_application_id => G_APPL_NAME
7145:
7146: ,p_row_identifier => p_ag_assoc_rec.transaction_id
7179: ,p_data => l_msg_data
7180: );
7181:
7182: IF l_msg_count = 1 THEN
7183: ERROR_HANDLER.Add_Error_Message(
7184: p_message_text => 'EGO_EXT_FWK_PUB.Delete_Association'||x_return_msg
7185: ,p_application_id => G_APPL_NAME
7186:
7187: ,p_row_identifier => p_ag_assoc_rec.transaction_id
7189: ,p_table_name => G_ENTITY_ICC_HEADER_TAB
7190: );
7191: ELSE
7192: FOR i in 1..l_msg_count LOOP
7193: ERROR_HANDLER.Add_Error_Message(
7194: p_message_text => 'EGO_EXT_FWK_PUB.Delete_Association'||FND_MSG_PUB.get
7195: ,p_application_id => G_APPL_NAME
7196:
7197: ,p_row_identifier => p_ag_assoc_rec.transaction_id
7246:
7247: e_skip_record EXCEPTION;
7248: e_unexpected_error EXCEPTION;
7249:
7250: l_token_table ERROR_HANDLER.Token_Tbl_Type;
7251:
7252: CURSOR cur_func_param_count ( p_function_id number)
7253: IS
7254: SELECT COUNT(1) count
7307: ,p_data => l_msg_data
7308: );
7309:
7310: IF l_msg_count = 1 THEN
7311: ERROR_HANDLER.Add_Error_Message(
7312: p_message_text => 'EGO_EXT_FWK_PUB.Create_Mapping'||x_return_msg
7313: ,p_application_id => G_APPL_NAME
7314:
7315: ,p_row_identifier => p_func_param_assoc_rec.transaction_id
7317: ,p_table_name => G_ENTITY_ICC_HEADER_TAB
7318: );
7319: ELSE
7320: FOR i in 1..l_msg_count LOOP
7321: ERROR_HANDLER.Add_Error_Message(
7322: p_message_text => 'EGO_EXT_FWK_PUB.Create_Mapping'||FND_MSG_PUB.get
7323: ,p_application_id => G_APPL_NAME
7324:
7325: ,p_row_identifier => p_func_param_assoc_rec.transaction_id
7363: ,p_data => l_msg_data
7364: );
7365:
7366: IF l_msg_count = 1 THEN
7367: ERROR_HANDLER.Add_Error_Message(
7368: p_message_text => 'EGO_EXT_FWK_PUB.Create_Mapping'||x_return_msg
7369: ,p_application_id => G_APPL_NAME
7370:
7371: ,p_row_identifier => p_func_param_assoc_rec.transaction_id
7373: ,p_table_name => G_ENTITY_ICC_HEADER_TAB
7374: );
7375: ELSE
7376: FOR i in 1..l_msg_count LOOP
7377: ERROR_HANDLER.Add_Error_Message(
7378: p_message_text => 'EGO_EXT_FWK_PUB.Create_Mapping'||FND_MSG_PUB.get
7379: ,p_application_id => G_APPL_NAME
7380:
7381: ,p_row_identifier => p_func_param_assoc_rec.transaction_id
7414: ,p_data => l_msg_data
7415: );
7416:
7417: IF l_msg_count = 1 THEN
7418: ERROR_HANDLER.Add_Error_Message(
7419: p_message_text => 'EGO_EXT_FWK_PUB.Create_Mapping'||x_return_msg
7420: ,p_application_id => G_APPL_NAME
7421:
7422: ,p_row_identifier => p_func_param_assoc_rec.transaction_id
7424: ,p_table_name => G_ENTITY_ICC_HEADER_TAB
7425: );
7426: ELSE
7427: FOR i in 1..l_msg_count LOOP
7428: ERROR_HANDLER.Add_Error_Message(
7429: p_message_text => 'EGO_EXT_FWK_PUB.Create_Mapping'||FND_MSG_PUB.get
7430: ,p_application_id => G_APPL_NAME
7431:
7432: ,p_row_identifier => p_func_param_assoc_rec.transaction_id
7497: IF x_return_status <> G_RET_STS_SUCCESS THEN
7498: FND_MSG_PUB.RESET; --- resets the message index pointer to top of table, since count_and_get is called in above api
7499:
7500: FOR i in 1..l_msg_count LOOP
7501: ERROR_HANDLER.Add_Error_Message(
7502: p_message_text => FND_MSG_PUB.GET ( p_encoded => FND_API.G_FALSE)
7503: ,p_application_id => G_APPL_NAME
7504: ,p_message_type => G_TYPE_ERROR
7505: ,p_row_identifier => p_icc_vers_rec.transaction_id
7559: END IF;
7560:
7561:
7562: ELSIF x_return_status = G_RET_STS_ERROR THEN
7563: ERROR_HANDLER.Add_Error_Message(
7564: p_message_text => x_return_msg
7565: ,p_application_id => G_APPL_NAME
7566: ,p_row_identifier => p_icc_vers_rec.transaction_id
7567: ,p_entity_code => l_entity_code
7892: l_entity_code VARCHAR2(30) := G_ENTITY_ICC_VERSION;
7893:
7894: e_skip_record EXCEPTION;
7895:
7896: l_token_table ERROR_HANDLER.Token_Tbl_Type;
7897: l_max_seq_id NUMBER := 0;
7898: l_max_start_date DATE := null;
7899: l_higher_date DATE := null;
7900: l_lower_date DATE := null;
8047:
8048: l_token_table(2).TOKEN_NAME := 'ICC_NAME';
8049: l_token_table(2).TOKEN_VALUE := p_icc_vers_rec.item_catalog_name;
8050:
8051: ERROR_HANDLER.Set_Bo_Identifier(G_BO_IDENTIFIER_ICC);
8052:
8053: --- Log a generic error for the version not being created
8054: ---
8055: ERROR_HANDLER.Add_Error_Message(
8051: ERROR_HANDLER.Set_Bo_Identifier(G_BO_IDENTIFIER_ICC);
8052:
8053: --- Log a generic error for the version not being created
8054: ---
8055: ERROR_HANDLER.Add_Error_Message(
8056: p_message_name => 'EGO_ICC_VERSION_NOT_CREATED'
8057: ,p_application_id => G_APPL_NAME
8058: ,p_token_tbl => l_token_table
8059: ,p_message_type => G_TYPE_ERROR
8068: l_count := fnd_msg_pub.count_msg;
8069: FND_MSG_PUB.RESET; --- resets the message index pointer to top of table
8070:
8071: FOR i in 1..l_count LOOP
8072: ERROR_HANDLER.Add_Error_Message(
8073: p_message_text => FND_MSG_PUB.GET ( p_encoded => FND_API.G_FALSE) --- bug 9750497, 9756337
8074: ,p_application_id => G_APPL_NAME
8075: ,p_token_tbl => l_token_table
8076: ,p_message_type => G_TYPE_WARNING
8092: p_icc_version_number_intf => p_icc_vers_rec.ver_seq_no,
8093: x_return_status => l_return_status,
8094: x_return_msg => x_return_msg);
8095:
8096: ERROR_HANDLER.Set_Bo_Identifier(G_BO_IDENTIFIER_ICC);
8097: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
8098: l_version_created := FALSE;
8099: RETURN; --- Error message is logged in calling procedure
8100: END IF;
8199:
8200: l_token_table(1).TOKEN_NAME := 'ICC_NAME';
8201: l_token_table(1).TOKEN_VALUE := p_icc_vers_rec.item_catalog_name;
8202:
8203: ERROR_HANDLER.Add_Error_Message(
8204: p_message_name => 'EGO_ICC_NOT_VERSIONED'
8205: ,p_application_id => G_APPL_NAME
8206: ,p_token_tbl => l_token_table
8207: ,p_message_type => G_PROCESS_STATUS_WARNING
8241:
8242: l_token_table(2).TOKEN_NAME := 'ICC_VERSION';
8243: l_token_table(2).TOKEN_VALUE := p_icc_vers_rec.ver_seq_no;
8244:
8245: ERROR_HANDLER.Add_Error_Message(
8246: p_message_name => 'EGO_ICC_NO_TA_CHANGE'
8247: ,p_application_id => G_APPL_NAME
8248: ,p_token_tbl => l_token_table
8249: ,p_message_type => G_PROCESS_STATUS_WARNING
8454:
8455: l_func_params_tbl ego_FN_Param_Obj_Tbl_Type := ego_FN_Param_Obj_Tbl_Type();
8456: l_count_frm_ego_maps NUMBER := 0;
8457: l_count_frm_func_params NUMBER := 0;
8458: l_token_table ERROR_HANDLER.Token_Tbl_Type;
8459: l_entity_code VARCHAR2(30);
8460: l_return_status VARCHAR2(1) := NULL;
8461:
8462: ---
8781: l_token_table(2).TOKEN_NAME := 'ICC_NAME';
8782: l_token_table(2).TOKEN_VALUE := rec_icc_func.item_catalog_name;
8783:
8784:
8785: ERROR_HANDLER.Add_Error_Message(
8786: p_message_name => 'EGO_FUNC_NOT_ASSOC_ICC_PARAM'
8787: ,p_application_id => G_APPL_NAME
8788: ,p_token_tbl => l_token_table
8789: ,p_message_type => G_PROCESS_STATUS_WARNING
9606: IF x_return_status <> G_RET_STS_SUCCESS THEN
9607: FND_MSG_PUB.RESET; --- resets the message index pointer to top of table, since count_and_get is called in above api
9608:
9609: FOR i in 1..l_msg_count LOOP
9610: ERROR_HANDLER.Add_Error_Message(
9611: p_message_text => FND_MSG_PUB.GET ( p_encoded => FND_API.G_FALSE)
9612: ,p_application_id => G_APPL_NAME
9613: ,p_message_type => G_TYPE_ERROR
9614: --,p_row_identifier
9934: ----*************************
9935: --- ICC header
9936: ----*************************
9937: write_debug (l_proc_name, G_ENTITY_ICC_HEADER);
9938: ERROR_HANDLER.Set_Bo_Identifier(G_BO_IDENTIFIER_ICC);
9939:
9940: --- Initialize ICC Header and versions and TAs
9941: ---
9942: Initialize (p_set_process_id, G_ENTITY_ICC_HEADER) ;
10103: RAISE e_unexpected_error;
10104: END IF;
10105: */
10106:
10107: ERROR_HANDLER.Set_Bo_Identifier(G_BO_IDENTIFIER_ICC);
10108: Construct_Colltn_And_Validate ( p_entity => G_ENTITY_ICC_VERSION
10109: , x_return_status => x_return_status
10110: , x_return_msg => x_return_msg
10111: );
10131: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN --- we expect this API to return only S or U.
10132: RAISE e_unexpected_error;
10133: END IF;
10134:
10135: Error_Handler.Log_Error(p_write_err_to_inttable => 'Y', p_write_err_to_conclog => 'Y'); -- bug 12380454
10136: write_debug (l_proc_name, 'End of '||l_proc_name);
10137: EXCEPTION
10138: WHEN e_unexpected_error THEN
10139: write_debug(l_proc_name, x_return_msg);