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.EGO_AG_BULKLOAD_PVT dependencies on ERROR_HANDLER

Line 2955: error_handler.Set_bo_identifier(G_BO_IDENTIFIER_AG);

2951: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Entering process_attr_groups');
2952:
2953: x_return_status := G_RET_STS_SUCCESS;
2954:
2955: error_handler.Set_bo_identifier(G_BO_IDENTIFIER_AG);
2956:
2957:
2958:
2959: G_COMMIT := p_commit;

Line 3072: error_handler.Add_error_message(p_message_name => 'EGO_ENTITY_API_FAILED',p_application_id => 'EGO',

3068: G_TOKEN_TABLE(3).Token_Value := 'ego_ext_fwk_pub';
3069: G_TOKEN_TABLE(4).Token_Name := 'Proc_Name';
3070: G_TOKEN_TABLE(4).Token_Value := 'Create_attribute_group';
3071:
3072: error_handler.Add_error_message(p_message_name => 'EGO_ENTITY_API_FAILED',p_application_id => 'EGO',
3073: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
3074: p_row_identifier => P_ag_tbl(i).transaction_id,
3075: p_entity_code => G_ENTITY_AG,p_table_name => G_ENTITY_AG_TAB);
3076:

Line 3077: error_handler.Add_error_message(p_message_text => x_msg_data,p_application_id => 'EGO',

3073: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
3074: p_row_identifier => P_ag_tbl(i).transaction_id,
3075: p_entity_code => G_ENTITY_AG,p_table_name => G_ENTITY_AG_TAB);
3076:
3077: error_handler.Add_error_message(p_message_text => x_msg_data,p_application_id => 'EGO',
3078: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
3079: p_row_identifier => P_ag_tbl(i).transaction_id,
3080: p_entity_code => G_ENTITY_AG,p_table_name => G_ENTITY_AG_TAB);
3081:

Line 3129: error_handler.Add_error_message(p_message_name => 'EGO_ENTITY_API_FAILED',p_application_id => 'EGO',

3125: G_TOKEN_TABLE(3).Token_Value := 'ego_ext_fwk_pub';
3126: G_TOKEN_TABLE(4).Token_Name := 'Proc_Name';
3127: G_TOKEN_TABLE(4).Token_Value := 'Update_attribute_group';
3128:
3129: error_handler.Add_error_message(p_message_name => 'EGO_ENTITY_API_FAILED',p_application_id => 'EGO',
3130: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
3131: p_row_identifier => P_ag_tbl(i).transaction_id,
3132: p_entity_code => G_ENTITY_AG,p_table_name => G_ENTITY_AG_TAB);
3133:

Line 3134: error_handler.Add_error_message(p_message_text => x_msg_data,p_application_id => 'EGO',

3130: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
3131: p_row_identifier => P_ag_tbl(i).transaction_id,
3132: p_entity_code => G_ENTITY_AG,p_table_name => G_ENTITY_AG_TAB);
3133:
3134: error_handler.Add_error_message(p_message_text => x_msg_data,p_application_id => 'EGO',
3135: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
3136: p_row_identifier => P_ag_tbl(i).transaction_id,
3137: p_entity_code => G_ENTITY_AG,p_table_name => G_ENTITY_AG_TAB);
3138:

Line 3174: error_handler.Add_error_message(p_message_name => 'EGO_ENTITY_API_FAILED',p_application_id => 'EGO',

3170: G_TOKEN_TABLE(3).Token_Value := 'ego_ext_fwk_pub';
3171: G_TOKEN_TABLE(4).Token_Name := 'Proc_Name';
3172: G_TOKEN_TABLE(4).Token_Value := 'Delete_attribute_group';
3173:
3174: error_handler.Add_error_message(p_message_name => 'EGO_ENTITY_API_FAILED',p_application_id => 'EGO',
3175: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
3176: p_row_identifier => P_ag_tbl(i).transaction_id,
3177: p_entity_code => G_ENTITY_AG,p_table_name => G_ENTITY_AG_TAB);
3178:

Line 3179: error_handler.Add_error_message(p_message_text => x_msg_data,p_application_id => 'EGO',

3175: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
3176: p_row_identifier => P_ag_tbl(i).transaction_id,
3177: p_entity_code => G_ENTITY_AG,p_table_name => G_ENTITY_AG_TAB);
3178:
3179: error_handler.Add_error_message(p_message_text => x_msg_data,p_application_id => 'EGO',
3180: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
3181: p_row_identifier => P_ag_tbl(i).transaction_id,
3182: p_entity_code => G_ENTITY_AG,p_table_name => G_ENTITY_AG_TAB);
3183:

Line 3254: error_handler.Add_error_message(p_message_name => 'EGO_EF_DL_INVALID_COMB',p_application_id => 'EGO',

3250: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_agdl_tbl(i).transaction_id
3251: ||' (AG,DL) = ('||p_agdl_tbl(i).attr_group_name||','||p_agdl_tbl(i).data_level_name||'). '
3252: ||'The combination of Business Entities choosen is Invalid for Item Level.');
3253:
3254: error_handler.Add_error_message(p_message_name => 'EGO_EF_DL_INVALID_COMB',p_application_id => 'EGO',
3255: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
3256: p_row_identifier => p_agdl_tbl(i).transaction_id,
3257: p_entity_code => G_ENTITY_DL,p_table_name => G_ENTITY_DL_TAB);
3258: END IF;

Line 3282: error_handler.Add_error_message(p_message_name => 'EGO_EF_DL_INVALID_COMB',p_application_id => 'EGO',

3278: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_agdl_tbl(i).transaction_id
3279: ||' (AG,DL) = ('||p_agdl_tbl(i).attr_group_name||','||p_agdl_tbl(i).data_level_name||'). '
3280: ||'The combination of Business Entities choosen is Invalid');
3281:
3282: error_handler.Add_error_message(p_message_name => 'EGO_EF_DL_INVALID_COMB',p_application_id => 'EGO',
3283: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
3284: p_row_identifier => p_agdl_tbl(i).transaction_id,
3285: p_entity_code => G_ENTITY_DL,p_table_name => G_ENTITY_DL_TAB);
3286: END IF;

Line 3310: error_handler.Add_error_message(p_message_name => 'EGO_EF_DL_INVALID_COMB',p_application_id => 'EGO',

3306: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_agdl_tbl(i).transaction_id
3307: ||' (AG,DL) = ('||p_agdl_tbl(i).attr_group_name||','||p_agdl_tbl(i).data_level_name||'). '
3308: ||'The combination of Business Entities choosen is Invalid.');
3309:
3310: error_handler.Add_error_message(p_message_name => 'EGO_EF_DL_INVALID_COMB',p_application_id => 'EGO',
3311: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
3312: p_row_identifier => p_agdl_tbl(i).transaction_id,
3313: p_entity_code => G_ENTITY_DL,p_table_name => G_ENTITY_DL_TAB);
3314: END IF;

Line 3332: error_handler.Add_error_message(p_message_name => 'EGO_EF_DL_AG_EXISTS',p_application_id => 'EGO',

3328: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_agdl_tbl(i).transaction_id||' (AG,DL) = ('
3329: ||p_agdl_tbl(i).attr_group_name||','||p_agdl_tbl(i).data_level_name||'). '
3330: ||'Business entity is already enabled for the attribute group.');
3331:
3332: error_handler.Add_error_message(p_message_name => 'EGO_EF_DL_AG_EXISTS',p_application_id => 'EGO',
3333: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
3334: p_row_identifier => P_agdl_tbl(i).transaction_id,
3335: p_entity_code => G_ENTITY_DL,p_table_name => G_ENTITY_DL_tab);
3336: ELSIF (P_agdl_tbl(i).process_status = G_PROCESS_RECORD) THEN

Line 3383: error_handler.Add_error_message(p_message_name => 'EGO_ENTITY_API_FAILED',p_application_id => 'EGO',

3379: G_TOKEN_TABLE(3).Token_Value := 'ego_ext_fwk_pub';
3380: G_TOKEN_TABLE(4).Token_Name := 'Proc_Name';
3381: G_TOKEN_TABLE(4).Token_Value := 'Sync_dl_assoc';
3382:
3383: error_handler.Add_error_message(p_message_name => 'EGO_ENTITY_API_FAILED',p_application_id => 'EGO',
3384: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
3385: p_row_identifier => P_agdl_tbl(i).transaction_id,
3386: p_entity_code => G_ENTITY_DL,p_table_name => G_ENTITY_DL_tab);
3387:

Line 3388: error_handler.Add_error_message(p_message_text => x_msg_data,p_application_id => 'EGO',

3384: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
3385: p_row_identifier => P_agdl_tbl(i).transaction_id,
3386: p_entity_code => G_ENTITY_DL,p_table_name => G_ENTITY_DL_tab);
3387:
3388: error_handler.Add_error_message(p_message_text => x_msg_data,p_application_id => 'EGO',
3389: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
3390: p_row_identifier => P_agdl_tbl(i).transaction_id,
3391: p_entity_code => G_ENTITY_DL,p_table_name => G_ENTITY_DL_tab);
3392:

Line 3450: error_handler.Set_bo_identifier(G_BO_IDENTIFIER_AG);

3446: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Entering process_attribute');
3447:
3448: x_return_status := G_RET_STS_SUCCESS;
3449:
3450: error_handler.Set_bo_identifier(G_BO_IDENTIFIER_AG);
3451:
3452: IF(p_attr_tbl.COUNT <> 0) THEN
3453:
3454: G_COMMIT := p_commit;

Line 3556: error_handler.Add_error_message(p_message_name => 'EGO_ENTITY_API_FAILED',p_application_id => 'EGO',

3552: G_TOKEN_TABLE(3).Token_Value := 'ego_ext_fwk_pub';
3553: G_TOKEN_TABLE(4).Token_Name := 'Proc_Name';
3554: G_TOKEN_TABLE(4).Token_Value := 'Create_attribute';
3555:
3556: error_handler.Add_error_message(p_message_name => 'EGO_ENTITY_API_FAILED',p_application_id => 'EGO',
3557: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
3558: p_row_identifier => P_attr_tbl(i).transaction_id,
3559: p_entity_code => G_ENTITY_ATTR,p_table_name => G_ENTITY_ATTR_TAB);
3560:

Line 3561: error_handler.Add_error_message(p_message_text => x_msg_data,p_application_id => 'EGO',

3557: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
3558: p_row_identifier => P_attr_tbl(i).transaction_id,
3559: p_entity_code => G_ENTITY_ATTR,p_table_name => G_ENTITY_ATTR_TAB);
3560:
3561: error_handler.Add_error_message(p_message_text => x_msg_data,p_application_id => 'EGO',
3562: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
3563: p_row_identifier => P_attr_tbl(i).transaction_id,
3564: p_entity_code => G_ENTITY_ATTR,p_table_name => G_ENTITY_ATTR_TAB);
3565:

Line 3619: error_handler.Add_error_message(p_message_name => 'EGO_ENTITY_API_FAILED',p_application_id => 'EGO',

3615: G_TOKEN_TABLE(3).Token_Value := 'ego_ext_fwk_pub';
3616: G_TOKEN_TABLE(4).Token_Name := 'Proc_Name';
3617: G_TOKEN_TABLE(4).Token_Value := 'Update_attribute';
3618:
3619: error_handler.Add_error_message(p_message_name => 'EGO_ENTITY_API_FAILED',p_application_id => 'EGO',
3620: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
3621: p_row_identifier => P_attr_tbl(i).transaction_id,
3622: p_entity_code => G_ENTITY_ATTR,p_table_name => G_ENTITY_ATTR_TAB);
3623:

Line 3624: error_handler.Add_error_message(p_message_text => x_msg_data,p_application_id => 'EGO',

3620: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
3621: p_row_identifier => P_attr_tbl(i).transaction_id,
3622: p_entity_code => G_ENTITY_ATTR,p_table_name => G_ENTITY_ATTR_TAB);
3623:
3624: error_handler.Add_error_message(p_message_text => x_msg_data,p_application_id => 'EGO',
3625: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
3626: p_row_identifier => P_attr_tbl(i).transaction_id,
3627: p_entity_code => G_ENTITY_ATTR,p_table_name => G_ENTITY_ATTR_TAB);
3628:

Line 3667: error_handler.Add_error_message(p_message_name => 'EGO_ENTITY_API_FAILED',p_application_id => 'EGO',

3663: G_TOKEN_TABLE(3).Token_Value := 'ego_ext_fwk_pub';
3664: G_TOKEN_TABLE(4).Token_Name := 'Proc_Name';
3665: G_TOKEN_TABLE(4).Token_Value := 'Delete_attribute';
3666:
3667: error_handler.Add_error_message(p_message_name => 'EGO_ENTITY_API_FAILED',p_application_id => 'EGO',
3668: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
3669: p_row_identifier => P_attr_tbl(i).transaction_id,
3670: p_entity_code => G_ENTITY_ATTR,p_table_name => G_ENTITY_ATTR_TAB);
3671:

Line 3672: error_handler.Add_error_message(p_message_text => x_msg_data,p_application_id => 'EGO',

3668: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
3669: p_row_identifier => P_attr_tbl(i).transaction_id,
3670: p_entity_code => G_ENTITY_ATTR,p_table_name => G_ENTITY_ATTR_TAB);
3671:
3672: error_handler.Add_error_message(p_message_text => x_msg_data,p_application_id => 'EGO',
3673: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
3674: p_row_identifier => P_attr_tbl(i).transaction_id,
3675: p_entity_code => G_ENTITY_ATTR,p_table_name => G_ENTITY_ATTR_TAB);
3676:

Line 3738: error_handler.Set_bo_identifier(G_BO_IDENTIFIER_AG);

3734: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Entered import_ag_intf.');
3735:
3736: x_return_status := G_RET_STS_SUCCESS;
3737:
3738: error_handler.Set_bo_identifier(G_BO_IDENTIFIER_AG);
3739:
3740: G_FLOW_TYPE := G_EGO_MD_INTF;
3741:
3742: G_SET_PROCESS_ID := p_set_process_id;

Line 3893: error_handler.Add_error_message(p_message_name => 'EGO_AG_INVALID',p_application_id => 'EGO',

3889: P_ag_tbl(i).process_status := G_ERROR_RECORD;
3890:
3891: x_return_status := G_RET_STS_ERROR;
3892:
3893: error_handler.Add_error_message(p_message_name => 'EGO_AG_INVALID',p_application_id => 'EGO',
3894: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
3895: p_row_identifier => P_ag_tbl(i).transaction_id,
3896: p_entity_code => G_ENTITY_AG,p_table_name => G_ENTITY_AG_TAB);
3897: END IF;

Line 3973: error_handler.Add_error_message(p_message_name => 'EGO_VIEW_PRIV_NOT_EXIST',

3969: P_agdl_tbl(i).process_status := G_ERROR_RECORD;
3970:
3971: x_return_status := G_RET_STS_ERROR;
3972:
3973: error_handler.Add_error_message(p_message_name => 'EGO_VIEW_PRIV_NOT_EXIST',
3974: p_application_id => 'EGO',p_token_tbl => g_token_table,
3975: p_message_type => G_RET_STS_ERROR,p_row_identifier => P_agdl_tbl(i).transaction_id,
3976: p_entity_code => G_ENTITY_DL,p_table_name => G_ENTITY_DL_tab);
3977: WHEN OTHERS THEN

Line 3984: error_handler.Add_error_message(p_message_text => sqlerrm,p_application_id => 'EGO',

3980: ||'Value_to_id_dl_tbl Exception when others smt 2');
3981:
3982: x_return_status := G_RET_STS_UNEXP_ERROR;
3983:
3984: error_handler.Add_error_message(p_message_text => sqlerrm,p_application_id => 'EGO',
3985: p_token_tbl => g_token_table,p_message_type => G_RET_STS_UNEXP_ERROR,
3986: p_row_identifier => P_agdl_tbl(i).transaction_id,
3987: p_entity_code => G_ENTITY_DL,p_table_name => G_ENTITY_DL_tab);
3988:

Line 4018: error_handler.Add_error_message(p_message_name => 'EGO_EDIT_PRIV_NOT_EXIST',

4014: P_agdl_tbl(i).process_status := G_ERROR_RECORD;
4015:
4016: x_return_status := G_RET_STS_ERROR;
4017:
4018: error_handler.Add_error_message(p_message_name => 'EGO_EDIT_PRIV_NOT_EXIST',
4019: p_application_id => 'EGO',p_token_tbl => g_token_table,
4020: p_message_type => G_RET_STS_ERROR,p_row_identifier => P_agdl_tbl(i).transaction_id,
4021: p_entity_code => G_ENTITY_DL,p_table_name => G_ENTITY_DL_tab);
4022: WHEN OTHERS THEN

Line 4029: error_handler.Add_error_message(p_message_text => sqlerrm,p_application_id => 'EGO',

4025: ||'Exception: '||SQLERRM);
4026:
4027: x_return_status := G_RET_STS_UNEXP_ERROR;
4028:
4029: error_handler.Add_error_message(p_message_text => sqlerrm,p_application_id => 'EGO',
4030: p_token_tbl => g_token_table,p_message_type => G_RET_STS_UNEXP_ERROR,
4031: p_row_identifier => P_agdl_tbl(i).transaction_id,
4032: p_entity_code => G_ENTITY_DL,p_table_name => G_ENTITY_DL_tab);
4033:

Line 4062: error_handler.Add_error_message(p_message_name => 'EGO_DL_NOT_EXIST',p_application_id => 'EGO',

4058: P_agdl_tbl(i).process_status := G_ERROR_RECORD;
4059:
4060: x_return_status := G_RET_STS_ERROR;
4061:
4062: error_handler.Add_error_message(p_message_name => 'EGO_DL_NOT_EXIST',p_application_id => 'EGO',
4063: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
4064: p_row_identifier => P_agdl_tbl(i).transaction_id,
4065: p_entity_code => G_ENTITY_DL,p_table_name => G_ENTITY_DL_tab);
4066: WHEN OTHERS THEN

Line 4071: error_handler.Add_error_message(p_message_text => sqlerrm,p_application_id => 'EGO',

4067: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||P_agdl_tbl(i).transaction_id||' (AG,DL) = ('||P_agdl_tbl(i).attr_group_name||','||P_agdl_tbl(i).data_level_name||'). ' ||'Exception: '||SQLERRM);
4068:
4069: x_return_status := G_RET_STS_UNEXP_ERROR;
4070:
4071: error_handler.Add_error_message(p_message_text => sqlerrm,p_application_id => 'EGO',
4072: p_token_tbl => g_token_table,p_message_type => G_RET_STS_UNEXP_ERROR,
4073: p_row_identifier => P_agdl_tbl(i).transaction_id,
4074: p_entity_code => G_ENTITY_DL,p_table_name => G_ENTITY_DL_tab);
4075:

Line 4108: error_handler.Add_error_message(p_message_text => sqlerrm,p_application_id => 'EGO',

4104: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Value_to_id_dl_tbl Exception when others smt 5');
4105:
4106: x_return_status := G_RET_STS_UNEXP_ERROR;
4107:
4108: error_handler.Add_error_message(p_message_text => sqlerrm,p_application_id => 'EGO',
4109: p_token_tbl => g_token_table,p_message_type => G_RET_STS_UNEXP_ERROR,
4110: p_row_identifier => P_agdl_tbl(i).transaction_id,
4111: p_entity_code => G_ENTITY_DL,p_table_name => G_ENTITY_DL_tab);
4112:

Line 4168: error_handler.Add_error_message(p_message_name => 'EGO_AG_INVALID',p_application_id => 'EGO',

4164: x_return_status := G_RET_STS_ERROR;
4165:
4166: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||P_attr_tbl(i).transaction_id||' (AG,ATTR) = ('||P_attr_tbl(i).attr_group_name||','||P_attr_tbl(i).internal_name||'). ' ||'Attribute Group does not exist in the system');
4167:
4168: error_handler.Add_error_message(p_message_name => 'EGO_AG_INVALID',p_application_id => 'EGO',
4169: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
4170: p_row_identifier => P_attr_tbl(i).transaction_id,
4171: p_entity_code => G_ENTITY_ATTR,p_table_name => G_ENTITY_ATTR_TAB);
4172: WHEN OTHERS THEN

Line 4177: error_handler.Add_error_message(p_message_text => sqlerrm,p_application_id => 'EGO',

4173: x_return_status := G_RET_STS_UNEXP_ERROR;
4174:
4175: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||P_attr_tbl(i).transaction_id||' (AG,ATTR) = ('||P_attr_tbl(i).attr_group_name||','||P_attr_tbl(i).internal_name||'). ' ||'Exception: '||SQLERRM);
4176:
4177: error_handler.Add_error_message(p_message_text => sqlerrm,p_application_id => 'EGO',
4178: p_token_tbl => g_token_table,p_message_type => G_RET_STS_UNEXP_ERROR,
4179: p_row_identifier => P_attr_tbl(i).transaction_id,
4180: p_entity_code => G_ENTITY_ATTR,p_table_name => G_ENTITY_ATTR_TAB);
4181:

Line 4230: error_handler.Add_error_message(p_message_name => 'EGO_ATTR_NOT_EXISTS',p_application_id => 'EGO',

4226: x_return_status := G_RET_STS_ERROR;
4227:
4228: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||P_attr_tbl(i).transaction_id||' (AG,ATTR) = ('||P_attr_tbl(i).attr_group_name||','||P_attr_tbl(i).internal_name||'). ' ||'Attribute does not exist in the system');
4229:
4230: error_handler.Add_error_message(p_message_name => 'EGO_ATTR_NOT_EXISTS',p_application_id => 'EGO',
4231: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
4232: p_row_identifier => P_attr_tbl(i).transaction_id,
4233: p_entity_code => G_ENTITY_ATTR,p_table_name => G_ENTITY_ATTR_TAB);
4234: END IF;

Line 4241: error_handler.Add_error_message(p_message_text => sqlerrm,p_application_id => 'EGO',

4237:
4238: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||P_attr_tbl(i).transaction_id||' (AG,ATTR) = ('
4239: ||P_attr_tbl(i).attr_group_name||','||P_attr_tbl(i).internal_name||'). ' ||'Exception: '||SQLERRM);
4240:
4241: error_handler.Add_error_message(p_message_text => sqlerrm,p_application_id => 'EGO',
4242: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
4243: p_row_identifier => P_attr_tbl(i).transaction_id,
4244: p_entity_code => G_ENTITY_ATTR,p_table_name => G_ENTITY_ATTR_TAB);
4245:

Line 4273: error_handler.Add_error_message(p_message_name => 'EGO_EF_BC_SEL_EXI_VALUE',p_application_id => 'EGO',

4269: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||P_attr_tbl(i).transaction_id||' (AG,ATTR,VS) = ('
4270: ||P_attr_tbl(i).attr_group_name||','||P_attr_tbl(i).internal_name||','||P_attr_tbl(i).flex_value_set_name||'). '
4271: ||'Value Set does not exist');
4272:
4273: error_handler.Add_error_message(p_message_name => 'EGO_EF_BC_SEL_EXI_VALUE',p_application_id => 'EGO',
4274: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
4275: p_row_identifier => P_attr_tbl(i).transaction_id,
4276: p_entity_code => G_ENTITY_ATTR,p_table_name => G_ENTITY_ATTR_TAB);
4277: WHEN OTHERS THEN

Line 4284: error_handler.Add_error_message(p_message_text => sqlerrm,p_application_id => 'EGO',

4280: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||P_attr_tbl(i).transaction_id||' (AG,ATTR,VS) = ('
4281: ||P_attr_tbl(i).attr_group_name||','||P_attr_tbl(i).internal_name||','||P_attr_tbl(i).flex_value_set_name||'). '
4282: ||'Exception : '||SQLERRM);
4283:
4284: error_handler.Add_error_message(p_message_text => sqlerrm,p_application_id => 'EGO',
4285: p_token_tbl => g_token_table,p_message_type => G_RET_STS_UNEXP_ERROR,
4286: p_row_identifier => P_attr_tbl(i).transaction_id,
4287: p_entity_code => G_ENTITY_ATTR,p_table_name => G_ENTITY_ATTR_TAB);
4288:

Line 4368: error_handler.Add_error_message(p_message_name => 'EGO_EF_SIN_COL_VAL',p_application_id => 'EGO',

4364: x_return_status := G_RET_STS_ERROR;
4365:
4366: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||P_ag_tbl(i).transaction_id||' (AG) = ('||P_ag_tbl(i).attr_group_name||'). ' ||'Number of columns is not within acceptable range for Single Row Attribute group');
4367:
4368: error_handler.Add_error_message(p_message_name => 'EGO_EF_SIN_COL_VAL',p_application_id => 'EGO',
4369: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
4370: p_row_identifier => P_ag_tbl(i).transaction_id,
4371: p_entity_code => G_ENTITY_AG,p_table_name => G_ENTITY_AG_TAB);
4372:

Line 4388: error_handler.Add_error_message(p_message_name => 'EGO_EF_MUL_COL_VAL',p_application_id => 'EGO',

4384: x_return_status := G_RET_STS_ERROR;
4385:
4386: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||P_ag_tbl(i).transaction_id||' (AG) = ('||P_ag_tbl(i).attr_group_name||'). ' ||'Number of columns is not within acceptable range for Multi Row Attribute group');
4387:
4388: error_handler.Add_error_message(p_message_name => 'EGO_EF_MUL_COL_VAL',p_application_id => 'EGO',
4389: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
4390: p_row_identifier => P_ag_tbl(i).transaction_id,
4391: p_entity_code => G_ENTITY_AG,p_table_name => G_ENTITY_AG_TAB);
4392: END IF;

Line 4406: error_handler.Add_error_message(p_message_name => 'EGO_EF_ROW_VAL',p_application_id => 'EGO',

4402: x_return_status := G_RET_STS_ERROR;
4403:
4404: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||P_ag_tbl(i).transaction_id||' (AG) = ('||P_ag_tbl(i).attr_group_name||'). ' ||'Number of columns is not within acceptable range for Multi Row Attribute group');
4405:
4406: error_handler.Add_error_message(p_message_name => 'EGO_EF_ROW_VAL',p_application_id => 'EGO',
4407: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
4408: p_row_identifier => P_ag_tbl(i).transaction_id,
4409: p_entity_code => G_ENTITY_AG,p_table_name => G_ENTITY_AG_TAB);
4410: END IF;

Line 4424: error_handler.Add_error_message(p_message_name => 'EGO_MULROW_VAR_COMB',p_application_id => 'EGO',

4420: x_return_status := G_RET_STS_ERROR;
4421:
4422: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||P_ag_tbl(i).transaction_id||' (AG) = ('||P_ag_tbl(i).attr_group_name||'). ' ||'Invalid MultiRow Variant combination');
4423:
4424: error_handler.Add_error_message(p_message_name => 'EGO_MULROW_VAR_COMB',p_application_id => 'EGO',
4425: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
4426: p_row_identifier => P_ag_tbl(i).transaction_id,
4427: p_entity_code => G_ENTITY_AG,p_table_name => G_ENTITY_AG_TAB);
4428: END IF;

Line 4454: error_handler.Add_error_message(p_message_name => 'EGO_UPD_BEHAVIOUR',p_application_id => 'EGO',

4450: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '|| P_ag_tbl(i).transaction_id ||
4451: ' (AG) = ('||P_ag_tbl(i).attr_group_name||'). ' ||
4452: ' Updating the behaviour of attribute group is not allowed');
4453:
4454: error_handler.Add_error_message(p_message_name => 'EGO_UPD_BEHAVIOUR',p_application_id => 'EGO',
4455: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
4456: p_row_identifier => P_ag_tbl(i).transaction_id,
4457: p_entity_code => G_ENTITY_AG,p_table_name => G_ENTITY_AG_TAB);
4458:

Line 4503: error_handler.Add_error_message(p_message_name => 'EGO_INVALID_PRE_EVENT',p_application_id => 'EGO',

4499: x_return_status := G_RET_STS_ERROR;
4500:
4501: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_agdl_tbl(i).transaction_id||' (AG,DL) = ('||p_agdl_tbl(i).attr_group_name||','||p_agdl_tbl(i).data_level_name||'). ' ||'Invalid Pre event flag.');
4502:
4503: error_handler.Add_error_message(p_message_name => 'EGO_INVALID_PRE_EVENT',p_application_id => 'EGO',
4504: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
4505: p_row_identifier => p_agdl_tbl(i).transaction_id,
4506: p_entity_code => G_ENTITY_DL,p_table_name => G_ENTITY_DL_TAB);
4507: END IF;

Line 4520: error_handler.Add_error_message(p_message_name => 'EGO_INVALID_POST_EVENT',p_application_id => 'EGO',

4516:
4517: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_agdl_tbl(i).transaction_id||' (AG,DL) = ('
4518: ||p_agdl_tbl(i).attr_group_name||','||p_agdl_tbl(i).data_level_name||'). ' ||'Invalid post event flag.');
4519:
4520: error_handler.Add_error_message(p_message_name => 'EGO_INVALID_POST_EVENT',p_application_id => 'EGO',
4521: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
4522: p_row_identifier => p_agdl_tbl(i).transaction_id,
4523: p_entity_code => G_ENTITY_DL,p_table_name => G_ENTITY_DL_TAB);
4524: END IF;

Line 4552: error_handler.Add_error_message(p_message_name => 'EGO_EF_DL_REQD_AG',p_application_id => 'EGO',

4548: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_agdl_tbl(i).transaction_id||' (AG,DL) = ('
4549: ||p_agdl_tbl(i).attr_group_name||','||p_agdl_tbl(i).data_level_name||'). '
4550: ||'Cannot delete the business entity since there is only one business entity');
4551:
4552: error_handler.Add_error_message(p_message_name => 'EGO_EF_DL_REQD_AG',p_application_id => 'EGO',
4553: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
4554: p_row_identifier => p_agdl_tbl(i).transaction_id,
4555: p_entity_code => G_ENTITY_DL,p_table_name => G_ENTITY_DL_TAB);
4556: END IF;

Line 4568: error_handler.Add_error_message(p_message_name => 'EGO_DL_NOT_ASSOC',p_application_id => 'EGO',

4564: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_agdl_tbl(i).transaction_id||' (AG,DL) = ('
4565: ||p_agdl_tbl(i).attr_group_name||','||p_agdl_tbl(i).data_level_name||'). '
4566: ||'Cannot delete the business entity since its not associated to the AG');
4567:
4568: error_handler.Add_error_message(p_message_name => 'EGO_DL_NOT_ASSOC',p_application_id => 'EGO',
4569: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
4570: p_row_identifier => p_agdl_tbl(i).transaction_id,
4571: p_entity_code => G_ENTITY_DL,p_table_name => G_ENTITY_DL_TAB);
4572: WHEN OTHERS THEN

Line 4578: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => 'EGO',

4574:
4575: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_agdl_tbl(i).transaction_id||' (AG,DL) = ('
4576: ||p_agdl_tbl(i).attr_group_name||','||p_agdl_tbl(i).data_level_name||'). ' ||'Exception -'||SQLERRM);
4577:
4578: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => 'EGO',
4579: p_token_tbl => g_token_table,p_message_type => G_RET_STS_UNEXP_ERROR,
4580: p_row_identifier => p_agdl_tbl(i).transaction_id,
4581: p_entity_code => G_ENTITY_DL,p_table_name => G_ENTITY_DL_TAB);
4582: END;

Line 4602: error_handler.Add_error_message(p_message_name => 'EGO_AG_NOT_EXIST',p_application_id => 'EGO',

4598:
4599: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_agdl_tbl(i).transaction_id||' (AG,DL) = ('
4600: ||p_agdl_tbl(i).attr_group_name||','||p_agdl_tbl(i).data_level_name||'). ' ||'Attribute group does not exist');
4601:
4602: error_handler.Add_error_message(p_message_name => 'EGO_AG_NOT_EXIST',p_application_id => 'EGO',
4603: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
4604: p_row_identifier => p_agdl_tbl(i).transaction_id,
4605: p_entity_code => G_ENTITY_DL,p_table_name => G_ENTITY_DL_TAB);
4606: WHEN OTHERS THEN

Line 4612: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => 'EGO',

4608:
4609: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_agdl_tbl(i).transaction_id||' (AG,DL) = ('
4610: ||p_agdl_tbl(i).attr_group_name||','||p_agdl_tbl(i).data_level_name||'). ' ||'Exception -'||SQLERRM);
4611:
4612: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => 'EGO',
4613: p_token_tbl => g_token_table,p_message_type => G_RET_STS_UNEXP_ERROR,
4614: p_row_identifier => p_agdl_tbl(i).transaction_id,
4615: p_entity_code => G_ENTITY_DL,p_table_name => G_ENTITY_DL_TAB);
4616: END;

Line 4669: error_handler.Add_error_message(p_message_name => 'EGO_ATTR_MANDATORY',p_application_id => 'EGO',

4665:
4666: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_attr_tbl(i).transaction_id||' (AG,ATTR) = ('
4667: ||p_attr_tbl(i).attr_group_name||','||p_attr_tbl(i).internal_name||'). ' ||'Mandatory columns for the attribute are not populated');
4668:
4669: error_handler.Add_error_message(p_message_name => 'EGO_ATTR_MANDATORY',p_application_id => 'EGO',
4670: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
4671: p_row_identifier => p_attr_tbl(i).transaction_id,
4672: p_entity_code => G_ENTITY_ATTR,p_table_name => G_ENTITY_ATTR_TAB);
4673: END IF;

Line 4692: error_handler.Add_error_message(p_message_name => 'EGO_DATA_TYPE_INVALID',p_application_id => 'EGO',

4688:
4689: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_attr_tbl(i).transaction_id||' (AG,ATTR) = ('
4690: ||p_attr_tbl(i).attr_group_name||','||p_attr_tbl(i).internal_name||'). ' ||'Data type populated is invalid');
4691:
4692: error_handler.Add_error_message(p_message_name => 'EGO_DATA_TYPE_INVALID',p_application_id => 'EGO',
4693: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
4694: p_row_identifier => p_attr_tbl(i).transaction_id,
4695: p_entity_code => G_ENTITY_ATTR,p_table_name => G_ENTITY_ATTR_TAB);
4696: END IF;

Line 4724: error_handler.Add_error_message(p_message_name => 'EGO_DT_DISP_COMB_INVALID',p_application_id => 'EGO',

4720:
4721: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_attr_tbl(i).transaction_id||' (AG,ATTR) = ('
4722: ||p_attr_tbl(i).attr_group_name||','||p_attr_tbl(i).internal_name||'). ' ||'Data type and display as combination is invalid');
4723:
4724: error_handler.Add_error_message(p_message_name => 'EGO_DT_DISP_COMB_INVALID',p_application_id => 'EGO',
4725: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
4726: p_row_identifier => p_attr_tbl(i).transaction_id,
4727: p_entity_code => G_ENTITY_ATTR,p_table_name => G_ENTITY_ATTR_TAB);
4728: END IF;

Line 4742: error_handler.Add_error_message(p_message_name => 'EGO_VALUE_SET_REQUIRED',p_application_id => 'EGO',

4738:
4739: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_attr_tbl(i).transaction_id||' (AG,ATTR) = ('
4740: ||p_attr_tbl(i).attr_group_name||','||p_attr_tbl(i).internal_name||'). ' ||'Value Set is mandatory for particular display');
4741:
4742: error_handler.Add_error_message(p_message_name => 'EGO_VALUE_SET_REQUIRED',p_application_id => 'EGO',
4743: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
4744: p_row_identifier => p_attr_tbl(i).transaction_id,
4745: p_entity_code => G_ENTITY_ATTR,p_table_name => G_ENTITY_ATTR_TAB);
4746: END IF;

Line 4759: error_handler.Add_error_message(p_message_name => 'EGO_DYN_URL_MANDATORY',p_application_id => 'EGO',

4755:
4756: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_attr_tbl(i).transaction_id||' (AG,ATTR) = ('
4757: ||p_attr_tbl(i).attr_group_name||','||p_attr_tbl(i).internal_name||'). ' ||'Value Set is mandatory for particular display');
4758:
4759: error_handler.Add_error_message(p_message_name => 'EGO_DYN_URL_MANDATORY',p_application_id => 'EGO',
4760: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
4761: p_row_identifier => p_attr_tbl(i).transaction_id,
4762: p_entity_code => G_ENTITY_ATTR,p_table_name => G_ENTITY_ATTR_TAB);
4763: END IF;

Line 4783: error_handler.Add_error_message(p_message_name => 'EGO_EF_CR_ATTR_DUP_SEQ_ERR',p_application_id => 'EGO',

4779:
4780: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_attr_tbl(i).transaction_id||' (AG,ATTR) = ('
4781: ||p_attr_tbl(i).attr_group_name||','||p_attr_tbl(i).internal_name||'). ' ||'SEQUENCE already exists in the system - CREATE');
4782:
4783: error_handler.Add_error_message(p_message_name => 'EGO_EF_CR_ATTR_DUP_SEQ_ERR',p_application_id => 'EGO',
4784: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
4785: p_row_identifier => p_attr_tbl(i).transaction_id,
4786: p_entity_code => G_ENTITY_ATTR,p_table_name => G_ENTITY_ATTR_TAB);
4787:

Line 4800: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => 'EGO',

4796:
4797: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_attr_tbl(i).transaction_id||' (AG,ATTR) = ('
4798: ||p_attr_tbl(i).attr_group_name||','||p_attr_tbl(i).internal_name||'). ' ||'Exception - '||SQLERRM);
4799:
4800: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => 'EGO',
4801: p_token_tbl => g_token_table,p_message_type => G_RET_STS_UNEXP_ERROR,
4802: p_row_identifier => p_attr_tbl(i).transaction_id,
4803: p_entity_code => G_ENTITY_ATTR,p_table_name => G_ENTITY_ATTR_TAB);
4804: END;

Line 4841: error_handler.Add_error_message(p_message_name => 'EGO_EF_UP_ATTR_DUP_SEQ_ERR',p_application_id => 'EGO',

4837:
4838: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_attr_tbl(i).transaction_id||' (AG,ATTR) = ('
4839: ||p_attr_tbl(i).attr_group_name||','||p_attr_tbl(i).internal_name||'). ' ||'SEQUENCE already exists in the system - UPDATE');
4840:
4841: error_handler.Add_error_message(p_message_name => 'EGO_EF_UP_ATTR_DUP_SEQ_ERR',p_application_id => 'EGO',
4842: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
4843: p_row_identifier => p_attr_tbl(i).transaction_id,
4844: p_entity_code => G_ENTITY_ATTR,p_table_name => G_ENTITY_ATTR_TAB);
4845:

Line 4855: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => 'EGO',

4851:
4852: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_attr_tbl(i).transaction_id||' (AG,ATTR) = ('
4853: ||p_attr_tbl(i).attr_group_name||','||p_attr_tbl(i).internal_name||'). ' ||'Exception - '||SQLERRM);
4854:
4855: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => 'EGO',
4856: p_token_tbl => g_token_table,p_message_type => G_RET_STS_UNEXP_ERROR,
4857: p_row_identifier => p_attr_tbl(i).transaction_id,
4858: p_entity_code => G_ENTITY_ATTR,p_table_name => G_ENTITY_ATTR_TAB);
4859: END;

Line 4880: error_handler.Add_error_message(p_message_name => 'EGO_EF_CR_ATTR_DUP_COL_ERR',p_application_id => 'EGO',

4876:
4877: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_attr_tbl(i).transaction_id||' (AG,ATTR) = ('
4878: ||p_attr_tbl(i).attr_group_name||','||p_attr_tbl(i).internal_name||'). ' ||'SEQUENCE already exists in the system - CREATE');
4879:
4880: error_handler.Add_error_message(p_message_name => 'EGO_EF_CR_ATTR_DUP_COL_ERR',p_application_id => 'EGO',
4881: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
4882: p_row_identifier => p_attr_tbl(i).transaction_id,
4883: p_entity_code => G_ENTITY_ATTR,p_table_name => G_ENTITY_ATTR_TAB);
4884:

Line 4897: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => 'EGO',

4893:
4894: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_attr_tbl(i).transaction_id||' (AG,ATTR) = ('
4895: ||p_attr_tbl(i).attr_group_name||','||p_attr_tbl(i).internal_name||'). ' ||'Exception - '||SQLERRM);
4896:
4897: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => 'EGO',
4898: p_token_tbl => g_token_table,p_message_type => G_RET_STS_UNEXP_ERROR,
4899: p_row_identifier => p_attr_tbl(i).transaction_id,
4900: p_entity_code => G_ENTITY_ATTR,p_table_name => G_ENTITY_ATTR_TAB);
4901: END;

Line 4939: error_handler.Add_error_message(p_message_name => 'EGO_EF_UP_ATTR_DUP_SEQ_ERR',p_application_id => 'EGO',

4935:
4936: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_attr_tbl(i).transaction_id||' (AG,ATTR) = ('
4937: ||p_attr_tbl(i).attr_group_name||','||p_attr_tbl(i).internal_name||'). ' ||'SEQUENCE already exists in the system - UPDATE');
4938:
4939: error_handler.Add_error_message(p_message_name => 'EGO_EF_UP_ATTR_DUP_SEQ_ERR',p_application_id => 'EGO',
4940: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
4941: p_row_identifier => p_attr_tbl(i).transaction_id,
4942: p_entity_code => G_ENTITY_ATTR,p_table_name => G_ENTITY_ATTR_TAB);
4943:

Line 4954: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => 'EGO',

4950:
4951: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_attr_tbl(i).transaction_id||' (AG,ATTR) = ('
4952: ||p_attr_tbl(i).attr_group_name||','||p_attr_tbl(i).internal_name||'). ' ||'Exception - '||SQLERRM);
4953:
4954: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => 'EGO',
4955: p_token_tbl => g_token_table,p_message_type => G_RET_STS_UNEXP_ERROR,
4956: p_row_identifier => p_attr_tbl(i).transaction_id,
4957: p_entity_code => G_ENTITY_ATTR,p_table_name => G_ENTITY_ATTR_TAB);
4958: END;

Line 5017: error_handler.Add_error_message(p_message_name => 'EGO_EF_CR_ATTR_COL_DT_ERR',p_application_id => 'EGO',

5013:
5014: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_attr_tbl(i).transaction_id||' (AG,ATTR) = ('
5015: ||p_attr_tbl(i).attr_group_name||','||p_attr_tbl(i).internal_name||'). ' ||'Column name and data type dont match');
5016:
5017: error_handler.Add_error_message(p_message_name => 'EGO_EF_CR_ATTR_COL_DT_ERR',p_application_id => 'EGO',
5018: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
5019: p_row_identifier => p_attr_tbl(i).transaction_id,
5020: p_entity_code => G_ENTITY_ATTR,p_table_name => G_ENTITY_ATTR_TAB);
5021:

Line 5036: error_handler.Add_error_message(p_message_name => 'EGO_EF_DEFAULT_VAL_LEN_ERR',p_application_id => 'EGO',

5032:
5033: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_attr_tbl(i).transaction_id||' (AG,ATTR) = ('
5034: ||p_attr_tbl(i).attr_group_name||','||p_attr_tbl(i).internal_name||'). ' ||'Default value exceeds the acceptable length');
5035:
5036: error_handler.Add_error_message(p_message_name => 'EGO_EF_DEFAULT_VAL_LEN_ERR',p_application_id => 'EGO',
5037: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
5038: p_row_identifier => p_attr_tbl(i).transaction_id,
5039: p_entity_code => G_ENTITY_ATTR,p_table_name => G_ENTITY_ATTR_TAB);
5040:

Line 5055: error_handler.Add_error_message(p_message_name => 'EGO_EF_CR_ATTR_COL_DT_ERR',p_application_id => 'EGO',

5051:
5052: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_attr_tbl(i).transaction_id||' (AG,ATTR) = ('
5053: ||p_attr_tbl(i).attr_group_name||','||p_attr_tbl(i).internal_name||'). ' ||'Column name and data type dont match');
5054:
5055: error_handler.Add_error_message(p_message_name => 'EGO_EF_CR_ATTR_COL_DT_ERR',p_application_id => 'EGO',
5056: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
5057: p_row_identifier => p_attr_tbl(i).transaction_id,
5058: p_entity_code => G_ENTITY_ATTR,p_table_name => G_ENTITY_ATTR_TAB);
5059: END IF;

Line 5076: error_handler.Add_error_message(p_message_name => 'EGO_INVALID_VALUE_FOR_COL',p_application_id => 'EGO',

5072:
5073: G_TOKEN_TABLE(1).Token_Name := 'COL_NAME';
5074: G_TOKEN_TABLE(1).Token_Value := 'REQUIRED_FLAG';
5075:
5076: error_handler.Add_error_message(p_message_name => 'EGO_INVALID_VALUE_FOR_COL',p_application_id => 'EGO',
5077: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
5078: p_row_identifier => p_attr_tbl(i).transaction_id,
5079: p_entity_code => G_ENTITY_ATTR,p_table_name => G_ENTITY_ATTR_TAB);
5080:

Line 5099: error_handler.Add_error_message(p_message_name => 'EGO_INVALID_VALUE_FOR_COL',p_application_id => 'EGO',

5095:
5096: G_TOKEN_TABLE(1).Token_Name := 'COL_NAME';
5097: G_TOKEN_TABLE(1).Token_Value := 'ENABLED_FLAG';
5098:
5099: error_handler.Add_error_message(p_message_name => 'EGO_INVALID_VALUE_FOR_COL',p_application_id => 'EGO',
5100: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
5101: p_row_identifier => p_attr_tbl(i).transaction_id,
5102: p_entity_code => G_ENTITY_ATTR,p_table_name => G_ENTITY_ATTR_TAB);
5103:

Line 5122: error_handler.Add_error_message(p_message_name => 'EGO_INVALID_VALUE_FOR_COL',p_application_id => 'EGO',

5118:
5119: G_TOKEN_TABLE(1).Token_Name := 'COL_NAME';
5120: G_TOKEN_TABLE(1).Token_Value := 'SECURITY_ENABLED_FLAG';
5121:
5122: error_handler.Add_error_message(p_message_name => 'EGO_INVALID_VALUE_FOR_COL',p_application_id => 'EGO',
5123: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
5124: p_row_identifier => p_attr_tbl(i).transaction_id,
5125: p_entity_code => G_ENTITY_ATTR,p_table_name => G_ENTITY_ATTR_TAB);
5126:

Line 5145: error_handler.Add_error_message(p_message_name => 'EGO_INVALID_VALUE_FOR_COL',p_application_id => 'EGO',

5141:
5142: G_TOKEN_TABLE(1).Token_Name := 'COL_NAME';
5143: G_TOKEN_TABLE(1).Token_Value := 'SEARCH_FLAG';
5144:
5145: error_handler.Add_error_message(p_message_name => 'EGO_INVALID_VALUE_FOR_COL',p_application_id => 'EGO',
5146: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
5147: p_row_identifier => p_attr_tbl(i).transaction_id,
5148: p_entity_code => G_ENTITY_ATTR,p_table_name => G_ENTITY_ATTR_TAB);
5149:

Line 5168: error_handler.Add_error_message(p_message_name => 'EGO_INVALID_VALUE_FOR_COL',p_application_id => 'EGO',

5164:
5165: G_TOKEN_TABLE(1).Token_Name := 'COL_NAME';
5166: G_TOKEN_TABLE(1).Token_Value := 'UNIQUE_KEY_FLAG';
5167:
5168: error_handler.Add_error_message(p_message_name => 'EGO_INVALID_VALUE_FOR_COL',p_application_id => 'EGO',
5169: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
5170: p_row_identifier => p_attr_tbl(i).transaction_id,
5171: p_entity_code => G_ENTITY_ATTR,p_table_name => G_ENTITY_ATTR_TAB);
5172:

Line 5230: error_handler.Add_error_message(p_message_name => 'EGO_TRANS_TYPE_INVALID',p_application_id => 'EGO',

5226: P_ag_tbl(i).process_status := G_ERROR_RECORD;
5227:
5228: x_return_status := G_RET_STS_ERROR;
5229:
5230: error_handler.Add_error_message(p_message_name => 'EGO_TRANS_TYPE_INVALID',p_application_id => 'EGO',
5231: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
5232: p_row_identifier => P_ag_tbl(i).transaction_id,
5233: p_entity_code => G_ENTITY_AG,p_table_name => G_ENTITY_AG_TAB);
5234: END IF;

Line 5244: error_handler.Add_error_message(p_message_name => 'EGO_AG_TYPE_INVALID',p_application_id => 'EGO',

5240: x_return_status := G_RET_STS_ERROR;
5241:
5242: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Attribute group Type passed is incorrect');
5243:
5244: error_handler.Add_error_message(p_message_name => 'EGO_AG_TYPE_INVALID',p_application_id => 'EGO',
5245: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
5246: p_row_identifier => P_ag_tbl(i).transaction_id,
5247: p_entity_code => G_ENTITY_AG,p_table_name => G_ENTITY_AG_TAB);
5248: END IF;

Line 5275: error_handler.Add_error_message(p_message_name => 'EGO_TRANS_TYPE_INVALID',p_application_id => 'EGO',

5271: x_return_status := G_RET_STS_ERROR;
5272:
5273: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Invalid transaction type for DL');
5274:
5275: error_handler.Add_error_message(p_message_name => 'EGO_TRANS_TYPE_INVALID',p_application_id => 'EGO',
5276: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
5277: p_row_identifier => P_agdl_tbl(i).transaction_id,
5278: p_entity_code => G_ENTITY_DL,p_table_name => G_ENTITY_DL_TAB);
5279:

Line 5290: error_handler.Add_error_message(p_message_name => 'EGO_AG_TYPE_INVALID',p_application_id => 'EGO',

5286: x_return_status := G_RET_STS_ERROR;
5287:
5288: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Attribute group Type passed is incorrect');
5289:
5290: error_handler.Add_error_message(p_message_name => 'EGO_AG_TYPE_INVALID',p_application_id => 'EGO',
5291: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
5292: p_row_identifier => P_agdl_tbl(i).transaction_id,
5293: p_entity_code => G_ENTITY_DL,p_table_name => G_ENTITY_DL_TAB);
5294:

Line 5326: error_handler.Add_error_message(p_message_name => 'EGO_AG_INVALID',p_application_id => 'EGO',

5322: x_return_status := G_RET_STS_ERROR;
5323:
5324: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Attribute Group does not exist');
5325:
5326: error_handler.Add_error_message(p_message_name => 'EGO_AG_INVALID',p_application_id => 'EGO',
5327: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
5328: p_row_identifier => P_agdl_tbl(i).transaction_id,
5329: p_entity_code => G_ENTITY_DL,p_table_name => G_ENTITY_DL_TAB);
5330:

Line 5356: error_handler.Add_error_message(p_message_name => 'EGO_AG_INVALID',p_application_id => 'EGO',

5352: P_agdl_tbl(i).process_status := G_ERROR_RECORD;
5353:
5354: x_return_status := G_RET_STS_ERROR;
5355:
5356: error_handler.Add_error_message(p_message_name => 'EGO_AG_INVALID',p_application_id => 'EGO',
5357: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
5358: p_row_identifier => P_agdl_tbl(i).transaction_id,
5359: p_entity_code => G_ENTITY_DL,p_table_name => G_ENTITY_DL_tab);
5360: END IF;

Line 5367: error_handler.Add_error_message(p_message_text => sqlerrm,p_application_id => 'EGO',

5363: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Additional_agdl_validations Exception when others smt 3');
5364:
5365: x_return_status := G_RET_STS_UNEXP_ERROR;
5366:
5367: error_handler.Add_error_message(p_message_text => sqlerrm,p_application_id => 'EGO',
5368: p_token_tbl => g_token_table,p_message_type => G_RET_STS_UNEXP_ERROR,
5369: p_row_identifier => P_agdl_tbl(i).transaction_id,
5370: p_entity_code => G_ENTITY_DL,p_table_name => G_ENTITY_DL_tab);
5371:

Line 5405: error_handler.Add_error_message(p_message_name => 'EGO_EF_DL_REQD_AG',p_application_id => 'EGO',

5401: P_ag_tbl(i).process_status := G_ERROR_RECORD;
5402:
5403: x_return_status := G_RET_STS_ERROR;
5404:
5405: error_handler.Add_error_message(p_message_name => 'EGO_EF_DL_REQD_AG',p_application_id => 'EGO',
5406: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
5407: p_row_identifier => P_agdl_tbl(i).transaction_id,
5408: p_entity_code => G_ENTITY_DL,p_table_name => G_ENTITY_DL_tab);
5409: END IF;

Line 5439: error_handler.Add_error_message(p_message_name => 'EGO_AG_INVALID',p_application_id => 'EGO',

5435: P_ag_tbl(i).process_status := G_ERROR_RECORD;
5436:
5437: x_return_status := G_RET_STS_ERROR;
5438:
5439: error_handler.Add_error_message(p_message_name => 'EGO_AG_INVALID',p_application_id => 'EGO',
5440: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
5441: p_row_identifier => P_ag_tbl(i).transaction_id,
5442: p_entity_code => G_ENTITY_AG,p_table_name => G_ENTITY_AG_TAB);
5443: WHEN OTHERS THEN

Line 5448: error_handler.Add_error_message(p_message_text => sqlerrm,p_application_id => 'EGO',

5444: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Additional_agdl_validations Exception when others smt 5');
5445:
5446: x_return_status := G_RET_STS_UNEXP_ERROR;
5447:
5448: error_handler.Add_error_message(p_message_text => sqlerrm,p_application_id => 'EGO',
5449: p_token_tbl => g_token_table,p_message_type => G_RET_STS_UNEXP_ERROR,
5450: p_row_identifier => P_ag_tbl(i).transaction_id,
5451: p_entity_code => G_ENTITY_AG,p_table_name => G_ENTITY_AG_TAB);
5452:

Line 5475: error_handler.Add_error_message(p_message_name => 'EGO_AG_MANDATORY',p_application_id => 'EGO',

5471: P_agdl_tbl(i).process_status := G_ERROR_RECORD;
5472:
5473: x_return_status := G_RET_STS_ERROR;
5474:
5475: error_handler.Add_error_message(p_message_name => 'EGO_AG_MANDATORY',p_application_id => 'EGO',
5476: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
5477: p_row_identifier => P_ag_tbl(i).transaction_id,
5478: p_entity_code => G_ENTITY_AG,p_table_name => G_ENTITY_AG_TAB);
5479: END IF;

Line 5509: error_handler.Add_error_message(p_message_name => 'EGO_AG_INVALID',p_application_id => 'EGO',

5505: P_agdl_tbl(i).process_status := G_ERROR_RECORD;
5506:
5507: x_return_status := G_RET_STS_ERROR;
5508:
5509: error_handler.Add_error_message(p_message_name => 'EGO_AG_INVALID',p_application_id => 'EGO',
5510: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
5511: p_row_identifier => P_agdl_tbl(i).transaction_id,
5512: p_entity_code => G_ENTITY_DL,p_table_name => G_ENTITY_DL_tab);
5513: WHEN OTHERS THEN

Line 5518: error_handler.Add_error_message(p_message_text => sqlerrm,p_application_id => 'EGO',

5514: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Additional_agdl_validations Exception when others smt 6');
5515:
5516: x_return_status := G_RET_STS_UNEXP_ERROR;
5517:
5518: error_handler.Add_error_message(p_message_text => sqlerrm,p_application_id => 'EGO',
5519: p_token_tbl => g_token_table,p_message_type => G_RET_STS_UNEXP_ERROR,
5520: p_row_identifier => P_agdl_tbl(i).transaction_id,
5521: p_entity_code => G_ENTITY_DL,p_table_name => G_ENTITY_DL_tab);
5522:

Line 5547: error_handler.Add_error_message(p_message_name => 'EGO_VIEW_PRIV_NOT_EXIST',

5543: P_agdl_tbl(i).process_status := G_ERROR_RECORD;
5544:
5545: x_return_status := G_RET_STS_ERROR;
5546:
5547: error_handler.Add_error_message(p_message_name => 'EGO_VIEW_PRIV_NOT_EXIST',
5548: p_application_id => 'EGO',p_token_tbl => g_token_table,
5549: p_message_type => G_RET_STS_ERROR,p_row_identifier => P_agdl_tbl(i).transaction_id,
5550: p_entity_code => G_ENTITY_DL,p_table_name => G_ENTITY_DL_tab);
5551: WHEN OTHERS THEN

Line 5556: error_handler.Add_error_message(p_message_text => sqlerrm,p_application_id => 'EGO',

5552: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Additional_agdl_validations Exception when others smt 7');
5553:
5554: x_return_status := G_RET_STS_UNEXP_ERROR;
5555:
5556: error_handler.Add_error_message(p_message_text => sqlerrm,p_application_id => 'EGO',
5557: p_token_tbl => g_token_table,p_message_type => G_RET_STS_UNEXP_ERROR,
5558: p_row_identifier => P_agdl_tbl(i).transaction_id,
5559: p_entity_code => G_ENTITY_DL,p_table_name => G_ENTITY_DL_tab);
5560:

Line 5584: error_handler.Add_error_message(p_message_name => 'EGO_EDIT_PRIV_NOT_EXIST',

5580: P_agdl_tbl(i).process_status := G_ERROR_RECORD;
5581:
5582: x_return_status := G_RET_STS_ERROR;
5583:
5584: error_handler.Add_error_message(p_message_name => 'EGO_EDIT_PRIV_NOT_EXIST',
5585: p_application_id => 'EGO',p_token_tbl => g_token_table,
5586: p_message_type => G_RET_STS_ERROR,p_row_identifier => P_agdl_tbl(i).transaction_id,
5587: p_entity_code => G_ENTITY_DL,p_table_name => G_ENTITY_DL_tab);
5588: WHEN OTHERS THEN

Line 5593: error_handler.Add_error_message(p_message_text => sqlerrm,p_application_id => 'EGO',

5589: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Additional_agdl_validations Exception when others smt 8');
5590:
5591: x_return_status := G_RET_STS_UNEXP_ERROR;
5592:
5593: error_handler.Add_error_message(p_message_text => sqlerrm,p_application_id => 'EGO',
5594: p_token_tbl => g_token_table,p_message_type => G_RET_STS_UNEXP_ERROR,
5595: p_row_identifier => P_agdl_tbl(i).transaction_id,
5596: p_entity_code => G_ENTITY_DL,p_table_name => G_ENTITY_DL_tab);
5597:

Line 5624: error_handler.Add_error_message(p_message_name => 'EGO_DEFAULTING_INVALID',p_application_id => 'EGO',

5620: P_agdl_tbl(i).process_status := G_ERROR_RECORD;
5621:
5622: x_return_status := G_RET_STS_ERROR;
5623:
5624: error_handler.Add_error_message(p_message_name => 'EGO_DEFAULTING_INVALID',p_application_id => 'EGO',
5625: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
5626: p_row_identifier => P_agdl_tbl(i).transaction_id,
5627: p_entity_code => G_ENTITY_DL,p_table_name => G_ENTITY_DL_tab);
5628: END IF;

Line 5634: error_handler.Add_error_message(p_message_text => sqlerrm,p_application_id => 'EGO',

5630: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Additional_agdl_validations Exception when others smt 9');
5631:
5632: x_return_status := G_RET_STS_UNEXP_ERROR;
5633:
5634: error_handler.Add_error_message(p_message_text => sqlerrm,p_application_id => 'EGO',
5635: p_token_tbl => g_token_table,p_message_type => G_RET_STS_UNEXP_ERROR,
5636: p_row_identifier => P_agdl_tbl(i).transaction_id,
5637: p_entity_code => G_ENTITY_DL,p_table_name => G_ENTITY_DL_tab);
5638:

Line 5665: error_handler.Add_error_message(p_message_name => 'EGO_DEFAULTING_INVALID',p_application_id => 'EGO',

5661: P_agdl_tbl(i).process_status := G_ERROR_RECORD;
5662:
5663: x_return_status := G_RET_STS_ERROR;
5664:
5665: error_handler.Add_error_message(p_message_name => 'EGO_DEFAULTING_INVALID',p_application_id => 'EGO',
5666: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
5667: p_row_identifier => P_agdl_tbl(i).transaction_id,
5668: p_entity_code => G_ENTITY_DL,p_table_name => G_ENTITY_DL_tab);
5669: END IF;

Line 5675: error_handler.Add_error_message(p_message_text => sqlerrm,p_application_id => 'EGO',

5671: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Additional_agdl_validations Exception when others smt 10');
5672:
5673: x_return_status := G_RET_STS_UNEXP_ERROR;
5674:
5675: error_handler.Add_error_message(p_message_text => sqlerrm,p_application_id => 'EGO',
5676: p_token_tbl => g_token_table,p_message_type => G_RET_STS_UNEXP_ERROR,
5677: p_row_identifier => P_agdl_tbl(i).transaction_id,
5678: p_entity_code => G_ENTITY_DL,p_table_name => G_ENTITY_DL_tab);
5679:

Line 5704: error_handler.Add_error_message(p_message_name => 'EGO_DL_NOT_EXIST',p_application_id => 'EGO',

5700: P_agdl_tbl(i).process_status := G_ERROR_RECORD;
5701:
5702: x_return_status := G_RET_STS_ERROR;
5703:
5704: error_handler.Add_error_message(p_message_name => 'EGO_DL_NOT_EXIST',p_application_id => 'EGO',
5705: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
5706: p_row_identifier => P_agdl_tbl(i).transaction_id,
5707: p_entity_code => G_ENTITY_DL,p_table_name => G_ENTITY_DL_tab);
5708: WHEN OTHERS THEN

Line 5713: error_handler.Add_error_message(p_message_text => sqlerrm,p_application_id => 'EGO',

5709: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Additional_agdl_validations Exception when others smt 11');
5710:
5711: x_return_status := G_RET_STS_UNEXP_ERROR;
5712:
5713: error_handler.Add_error_message(p_message_text => sqlerrm,p_application_id => 'EGO',
5714: p_token_tbl => g_token_table,p_message_type => G_RET_STS_UNEXP_ERROR,
5715: p_row_identifier => P_agdl_tbl(i).transaction_id,
5716: p_entity_code => G_ENTITY_DL,p_table_name => G_ENTITY_DL_tab);
5717:

Line 5741: error_handler.Add_error_message(p_message_name => 'EGO_VAR_DL_SKU',p_application_id => 'EGO',

5737: P_agdl_tbl(i).process_status := G_ERROR_RECORD;
5738:
5739: x_return_status := G_RET_STS_ERROR;
5740:
5741: error_handler.Add_error_message(p_message_name => 'EGO_VAR_DL_SKU',p_application_id => 'EGO',
5742: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
5743: p_row_identifier => P_agdl_tbl(i).transaction_id,
5744: p_entity_code => G_ENTITY_DL,p_table_name => G_ENTITY_DL_tab);
5745: END IF;

Line 5752: error_handler.Add_error_message(p_message_name => 'EGO_AG_INVALID',p_application_id => 'EGO',

5748: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Attribute Group is invalid');
5749:
5750: x_return_status := G_RET_STS_ERROR;
5751:
5752: error_handler.Add_error_message(p_message_name => 'EGO_AG_INVALID',p_application_id => 'EGO',
5753: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
5754: p_row_identifier => P_agdl_tbl(i).transaction_id,
5755: p_entity_code => G_ENTITY_DL,p_table_name => G_ENTITY_DL_tab);
5756: WHEN OTHERS THEN

Line 5761: error_handler.Add_error_message(p_message_text => sqlerrm,p_application_id => 'EGO',

5757: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Additional_agdl_validations Exception when others smt 12');
5758:
5759: x_return_status := G_RET_STS_UNEXP_ERROR;
5760:
5761: error_handler.Add_error_message(p_message_text => sqlerrm,p_application_id => 'EGO',
5762: p_token_tbl => g_token_table,p_message_type => G_RET_STS_UNEXP_ERROR,
5763: p_row_identifier => P_agdl_tbl(i).transaction_id,
5764: p_entity_code => G_ENTITY_DL,p_table_name => G_ENTITY_DL_tab);
5765:

Line 5796: error_handler.Add_error_message(p_message_name => 'EGO_VAR_DL_SKU',p_application_id => 'EGO',

5792: P_agdl_tbl(i).process_status := G_ERROR_RECORD;
5793:
5794: x_return_status := G_RET_STS_ERROR;
5795:
5796: error_handler.Add_error_message(p_message_name => 'EGO_VAR_DL_SKU',p_application_id => 'EGO',
5797: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
5798: p_row_identifier => P_agdl_tbl(i).transaction_id,
5799: p_entity_code => G_ENTITY_DL,p_table_name => G_ENTITY_DL_tab);
5800: END IF;

Line 5807: error_handler.Add_error_message(p_message_name => 'EGO_AG_INVALID',p_application_id => 'EGO',

5803: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Attribute group is invalid');
5804:
5805: x_return_status := G_RET_STS_ERROR;
5806:
5807: error_handler.Add_error_message(p_message_name => 'EGO_AG_INVALID',p_application_id => 'EGO',
5808: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
5809: p_row_identifier => P_agdl_tbl(i).transaction_id,
5810: p_entity_code => G_ENTITY_DL,p_table_name => G_ENTITY_DL_tab);
5811: WHEN OTHERS THEN

Line 5816: error_handler.Add_error_message(p_message_text => sqlerrm,p_application_id => 'EGO',

5812: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Additional_agdl_validations Exception when others smt 13');
5813:
5814: x_return_status := G_RET_STS_UNEXP_ERROR;
5815:
5816: error_handler.Add_error_message(p_message_text => sqlerrm,p_application_id => 'EGO',
5817: p_token_tbl => g_token_table,p_message_type => G_RET_STS_UNEXP_ERROR,
5818: p_row_identifier => P_agdl_tbl(i).transaction_id,
5819: p_entity_code => G_ENTITY_DL,p_table_name => G_ENTITY_DL_tab);
5820:

Line 5853: error_handler.Add_error_message(p_message_name => 'EGO_MULROW_SKU',p_application_id => 'EGO',

5849: P_agdl_tbl(i).process_status := G_ERROR_RECORD;
5850:
5851: x_return_status := G_RET_STS_ERROR;
5852:
5853: error_handler.Add_error_message(p_message_name => 'EGO_MULROW_SKU',p_application_id => 'EGO',
5854: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
5855: p_row_identifier => P_agdl_tbl(i).transaction_id,
5856: p_entity_code => G_ENTITY_DL,p_table_name => G_ENTITY_DL_tab);
5857: END IF;

Line 5864: error_handler.Add_error_message(p_message_name => 'EGO_AG_INVALID',p_application_id => 'EGO',

5860: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Attribute group is invalid');
5861:
5862: x_return_status := G_RET_STS_ERROR;
5863:
5864: error_handler.Add_error_message(p_message_name => 'EGO_AG_INVALID',p_application_id => 'EGO',
5865: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
5866: p_row_identifier => P_agdl_tbl(i).transaction_id,
5867: p_entity_code => G_ENTITY_DL,p_table_name => G_ENTITY_DL_tab);
5868: WHEN OTHERS THEN

Line 5873: error_handler.Add_error_message(p_message_text => sqlerrm,p_application_id => 'EGO',

5869: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Additional_agdl_validations Exception when others smt 14');
5870:
5871: x_return_status := G_RET_STS_UNEXP_ERROR;
5872:
5873: error_handler.Add_error_message(p_message_text => sqlerrm,p_application_id => 'EGO',
5874: p_token_tbl => g_token_table,p_message_type => G_RET_STS_UNEXP_ERROR,
5875: p_row_identifier => P_agdl_tbl(i).transaction_id,
5876: p_entity_code => G_ENTITY_DL,p_table_name => G_ENTITY_DL_tab);
5877:

Line 5936: error_handler.Add_error_message(p_message_name => 'EGO_TRANS_TYPE_INVALID',p_application_id => 'EGO',

5932: x_return_status := G_RET_STS_ERROR;
5933:
5934: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Transaction Type passed is incorrect');
5935:
5936: error_handler.Add_error_message(p_message_name => 'EGO_TRANS_TYPE_INVALID',p_application_id => 'EGO',
5937: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
5938: p_row_identifier => P_attr_tbl(i).transaction_id,
5939: p_entity_code => G_ENTITY_ATTR,p_table_name => G_ENTITY_ATTR_TAB);
5940: END IF;

Line 5950: error_handler.Add_error_message(p_message_name => 'EGO_AG_TYPE_INVALID',p_application_id => 'EGO',

5946: x_return_status := G_RET_STS_ERROR;
5947:
5948: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Attribute group Type passed is incorrect');
5949:
5950: error_handler.Add_error_message(p_message_name => 'EGO_AG_TYPE_INVALID',p_application_id => 'EGO',
5951: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
5952: p_row_identifier => P_attr_tbl(i).transaction_id,
5953: p_entity_code => G_ENTITY_ATTR,p_table_name => G_ENTITY_ATTR_TAB);
5954: END IF;

Line 5982: error_handler.Add_error_message(p_message_name => 'EGO_AG_INVALID',p_application_id => 'EGO',

5978: x_return_status := G_RET_STS_ERROR;
5979:
5980: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Attribute Group does not exist');
5981:
5982: error_handler.Add_error_message(p_message_name => 'EGO_AG_INVALID',p_application_id => 'EGO',
5983: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
5984: p_row_identifier => P_attr_tbl(i).transaction_id,
5985: p_entity_code => G_ENTITY_ATTR,p_table_name => G_ENTITY_ATTR_TAB);
5986: WHEN OTHERS THEN

Line 5991: error_handler.Add_error_message(p_message_text => sqlerrm,p_application_id => 'EGO',

5987: x_return_status := G_RET_STS_UNEXP_ERROR;
5988:
5989: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Additional_attr_validations when others smt 1');
5990:
5991: error_handler.Add_error_message(p_message_text => sqlerrm,p_application_id => 'EGO',
5992: p_token_tbl => g_token_table,p_message_type => G_RET_STS_UNEXP_ERROR,
5993: p_row_identifier => P_attr_tbl(i).transaction_id,
5994: p_entity_code => G_ENTITY_ATTR,p_table_name => G_ENTITY_ATTR_TAB);
5995:

Line 6035: error_handler.Add_error_message(p_message_name => 'EGO_ATTR_NOT_EXISTS',p_application_id => 'EGO',

6031: x_return_status := G_RET_STS_ERROR;
6032:
6033: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Attribute does not exist');
6034:
6035: error_handler.Add_error_message(p_message_name => 'EGO_ATTR_NOT_EXISTS',p_application_id => 'EGO',
6036: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
6037: p_row_identifier => P_attr_tbl(i).transaction_id,
6038: p_entity_code => G_ENTITY_ATTR,p_table_name => G_ENTITY_ATTR_TAB);
6039: END IF;

Line 6045: error_handler.Add_error_message(p_message_text => sqlerrm,p_application_id => 'EGO',

6041: x_return_status := G_RET_STS_UNEXP_ERROR;
6042:
6043: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Additional_attr_validations Exception when others smt 2');
6044:
6045: error_handler.Add_error_message(p_message_text => sqlerrm,p_application_id => 'EGO',
6046: p_token_tbl => g_token_table,p_message_type => G_RET_STS_UNEXP_ERROR,
6047: p_row_identifier => P_attr_tbl(i).transaction_id,
6048: p_entity_code => G_ENTITY_ATTR,p_table_name => G_ENTITY_ATTR_TAB);
6049:

Line 6075: error_handler.Add_error_message(p_message_name => 'EGO_EF_BC_SEL_EXI_VALUE',p_application_id => 'EGO',

6071: x_return_status := G_RET_STS_ERROR;
6072:
6073: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Value Set does not exist in the system');
6074:
6075: error_handler.Add_error_message(p_message_name => 'EGO_EF_BC_SEL_EXI_VALUE',p_application_id => 'EGO',
6076: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
6077: p_row_identifier => P_attr_tbl(i).transaction_id,
6078: p_entity_code => G_ENTITY_ATTR,p_table_name => G_ENTITY_ATTR_TAB);
6079: WHEN OTHERS THEN

Line 6085: error_handler.Add_error_message(p_message_text => sqlerrm,p_application_id => 'EGO',

6081:
6082: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Additional_attr_validations Exception when others smt 3');
6083:
6084:
6085: error_handler.Add_error_message(p_message_text => sqlerrm,p_application_id => 'EGO',
6086: p_token_tbl => g_token_table,p_message_type => G_RET_STS_UNEXP_ERROR,
6087: p_row_identifier => P_attr_tbl(i).transaction_id,
6088: p_entity_code => G_ENTITY_ATTR,p_table_name => G_ENTITY_ATTR_TAB);
6089: