DBA Data[Home] [Help]

APPS.EGO_TA_BULKLOAD_PVT dependencies on ERROR_HANDLER

Line 1950: Error_Handler.Add_Error_Message

1946: /* added p_addto_fnd_stack because in case of error ICC API will rollback the TA
1947: so messages will also get rollback. So if it get added to stack we can print and insert
1948: to interface_error table again*/
1949:
1950: Error_Handler.Add_Error_Message
1951: (
1952: p_message_name => 'EGO_ENTITY_API_FAILED'
1953: ,p_application_id => G_APP_NAME
1954: ,p_message_type => G_RET_STS_ERROR

Line 2017: /*error_handler.Add_error_message(p_message_name => 'EGO_ICC_INVALID',p_application_id => 'EGO',

2013: ||'Is not Valid');
2014:
2015: p_ta_intf_tbl(i).process_status := G_ERROR_RECORD;
2016: x_return_status := G_RET_STS_ERROR;
2017: /*error_handler.Add_error_message(p_message_name => 'EGO_ICC_INVALID',p_application_id => 'EGO',
2018: p_token_tbl => g_token_table,p_message_type => g_ret_sts_error,
2019: p_row_identifier => P_ag_tbl(i).transaction_id,
2020: p_entity_code => g_entity_ag,p_table_name => g_entity_ag_tab);*/
2021: END IF;

Line 2042: /*error_handler.Add_error_message(p_message_name => 'EGO_ICC_INVALID',p_application_id => 'EGO',

2038: ||'does not exist in the system');
2039:
2040: p_ta_intf_tbl(i).process_status := G_ERROR_RECORD;
2041: x_return_status := G_RET_STS_ERROR;
2042: /*error_handler.Add_error_message(p_message_name => 'EGO_ICC_INVALID',p_application_id => 'EGO',
2043: p_token_tbl => g_token_table,p_message_type => g_ret_sts_error,
2044: p_row_identifier => P_ag_tbl(i).transaction_id,
2045: p_entity_code => g_entity_ag,p_table_name => g_entity_ag_tab);*/
2046: WHEN OTHERS THEN

Line 2069: /*error_handler.Add_error_message(p_message_name => 'EGO_ICC_INVALID',p_application_id => 'EGO',

2065: ||'does not exist in the system');
2066:
2067: p_ta_intf_tbl(i).process_status := G_ERROR_RECORD;
2068: x_return_status := G_RET_STS_ERROR;
2069: /*error_handler.Add_error_message(p_message_name => 'EGO_ICC_INVALID',p_application_id => 'EGO',
2070: p_token_tbl => g_token_table,p_message_type => g_ret_sts_error,
2071: p_row_identifier => P_ag_tbl(i).transaction_id,
2072: p_entity_code => g_entity_ag,p_table_name => g_entity_ag_tab);*/
2073: WHEN OTHERS THEN

Line 2120: /*error_handler.Add_error_message(p_message_name => 'EGO_ICC_INVALID',p_application_id => 'EGO',

2116: ||'does not exist in the system');
2117:
2118: p_ta_intf_tbl(i).process_status := G_ERROR_RECORD;
2119: x_return_status := G_RET_STS_ERROR;
2120: /*error_handler.Add_error_message(p_message_name => 'EGO_ICC_INVALID',p_application_id => 'EGO',
2121: p_token_tbl => g_token_table,p_message_type => g_ret_sts_error,
2122: p_row_identifier => P_ag_tbl(i).transaction_id,
2123: p_entity_code => g_entity_ag,p_table_name => g_entity_ag_tab);*/
2124: END IF;

Line 2158: /*error_handler.Add_error_message(p_message_name => 'EGO_ICC_INVALID',p_application_id => 'EGO',

2154: ||'does not exist in the system');
2155:
2156: p_ta_intf_tbl(i).process_status := G_ERROR_RECORD;
2157: x_return_status := G_RET_STS_ERROR;
2158: /*error_handler.Add_error_message(p_message_name => 'EGO_ICC_INVALID',p_application_id => 'EGO',
2159: p_token_tbl => g_token_table,p_message_type => g_ret_sts_error,
2160: p_row_identifier => P_ag_tbl(i).transaction_id,
2161: p_entity_code => g_entity_ag,p_table_name => g_entity_ag_tab);*/
2162: END IF;

Line 2192: /*error_handler.Add_error_message(p_message_name => 'EGO_ICC_INVALID',p_application_id => 'EGO',

2188: ||'Unexpected');
2189:
2190: p_ta_intf_tbl(i).process_status := G_ERROR_RECORD;
2191: x_return_status := G_RET_STS_ERROR;
2192: /*error_handler.Add_error_message(p_message_name => 'EGO_ICC_INVALID',p_application_id => 'EGO',
2193: p_token_tbl => g_token_table,p_message_type => g_ret_sts_error,
2194: p_row_identifier => P_ag_tbl(i).transaction_id,
2195: p_entity_code => g_entity_ag,p_table_name => g_entity_ag_tab);*/
2196: WHEN OTHERS THEN

Line 2244: /*error_handler.Add_error_message(p_message_name => 'EGO_ICC_INVALID',p_application_id => 'EGO',

2240: AND p_ta_intf_tbl(i).item_catalog_group_name IS NULL) THEN /*if both ICC_ID and ICC_NAME is NULL*/
2241: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'ERR : ICC Id and ICC_NAME both NULL ');
2242: p_ta_intf_tbl(i).process_status := G_ERROR_RECORD;
2243: x_return_status := G_RET_STS_ERROR;
2244: /*error_handler.Add_error_message(p_message_name => 'EGO_ICC_INVALID',p_application_id => 'EGO',
2245: p_token_tbl => g_token_table,p_message_type => g_ret_sts_error,
2246: p_row_identifier => P_ag_tbl(i).transaction_id,
2247: p_entity_code => g_entity_ag,p_table_name => g_entity_ag_tab);*/
2248:

Line 2264: /*error_handler.Add_error_message(p_message_name => 'EGO_ICC_INVALID',p_application_id => 'EGO',

2260: ||'does not exist in the system');
2261:
2262: p_ta_intf_tbl(i).process_status := G_ERROR_RECORD;
2263: x_return_status := G_RET_STS_ERROR;
2264: /*error_handler.Add_error_message(p_message_name => 'EGO_ICC_INVALID',p_application_id => 'EGO',
2265: p_token_tbl => g_token_table,p_message_type => g_ret_sts_error,
2266: p_row_identifier => P_ag_tbl(i).transaction_id,
2267: p_entity_code => g_entity_ag,p_table_name => g_entity_ag_tab);*/
2268: WHEN OTHERS THEN

Line 2293: /*error_handler.Add_error_message(p_message_name => 'EGO_ICC_INVALID',p_application_id => 'EGO',

2289: ||'does not exist in the system');
2290:
2291: p_ta_intf_tbl(i).process_status := G_ERROR_RECORD;
2292: x_return_status := G_RET_STS_ERROR;
2293: /*error_handler.Add_error_message(p_message_name => 'EGO_ICC_INVALID',p_application_id => 'EGO',
2294: p_token_tbl => g_token_table,p_message_type => g_ret_sts_error,
2295: p_row_identifier => P_ag_tbl(i).transaction_id,
2296: p_entity_code => g_entity_ag,p_table_name => g_entity_ag_tab);*/
2297: WHEN OTHERS THEN

Line 2358: /*error_handler.Add_error_message(p_message_name => 'EGO_ICC_INVALID',p_application_id => 'EGO',

2354: ||'does not exist in the system');
2355:
2356: p_ta_intf_tbl(i).process_status := G_ERROR_RECORD;
2357: x_return_status := G_RET_STS_ERROR;
2358: /*error_handler.Add_error_message(p_message_name => 'EGO_ICC_INVALID',p_application_id => 'EGO',
2359: p_token_tbl => g_token_table,p_message_type => g_ret_sts_error,
2360: p_row_identifier => P_ag_tbl(i).transaction_id,
2361: p_entity_code => g_entity_ag,p_table_name => g_entity_ag_tab);*/
2362: WHEN OTHERS THEN

Line 2372: /*error_handler.Add_error_message(p_message_name => 'EGO_ICC_INVALID',p_application_id => 'EGO',

2368: ELSIF (p_ta_intf_tbl(i).attr_id IS NULL AND p_ta_intf_tbl(i).attr_name IS NULL AND p_ta_intf_tbl(i).attr_display_name IS NULL ) THEN
2369: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'ALL Attr_id, Attr_name and Attr_Display Name cannot be NULL for UPDATE,DEL and SYNC');
2370: p_ta_intf_tbl(i).process_status := G_ERROR_RECORD;
2371: x_return_status := G_RET_STS_ERROR;
2372: /*error_handler.Add_error_message(p_message_name => 'EGO_ICC_INVALID',p_application_id => 'EGO',
2373: p_token_tbl => g_token_table,p_message_type => g_ret_sts_error,
2374: p_row_identifier => P_ag_tbl(i).transaction_id,
2375: p_entity_code => g_entity_ag,p_table_name => g_entity_ag_tab);*/
2376:

Line 2399: /*error_handler.Add_error_message(p_message_name => 'EGO_ICC_INVALID',p_application_id => 'EGO',

2395: ||'does not exist in the system');
2396:
2397: p_ta_intf_tbl(i).process_status := G_ERROR_RECORD;
2398: x_return_status := G_RET_STS_ERROR;
2399: /*error_handler.Add_error_message(p_message_name => 'EGO_ICC_INVALID',p_application_id => 'EGO',
2400: p_token_tbl => g_token_table,p_message_type => g_ret_sts_error,
2401: p_row_identifier => P_ag_tbl(i).transaction_id,
2402: p_entity_code => g_entity_ag,p_table_name => g_entity_ag_tab);*/
2403: WHEN OTHERS THEN

Line 2421: /*error_handler.Add_error_message(p_message_name => 'EGO_ICC_INVALID',p_application_id => 'EGO',

2417: OR p_ta_intf_tbl(i).Attr_id IS NOT NULL ) THEN /*if association_id or attr_id is NOT NULL*/
2418: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'ERR : Association_Is and Attr_id shud be NULL for CREATE');
2419: p_ta_intf_tbl(i).process_status := G_ERROR_RECORD;
2420: x_return_status := G_RET_STS_ERROR;
2421: /*error_handler.Add_error_message(p_message_name => 'EGO_ICC_INVALID',p_application_id => 'EGO',
2422: p_token_tbl => g_token_table,p_message_type => g_ret_sts_error,
2423: p_row_identifier => P_ag_tbl(i).transaction_id,
2424: p_entity_code => g_entity_ag,p_table_name => g_entity_ag_tab);*/
2425:

Line 2433: /*error_handler.Add_error_message(p_message_name => 'EGO_ICC_INVALID',p_application_id => 'EGO',

2429: OR (p_ta_intf_tbl(i).SEQUENCE IS NULL)) THEN /* if ICC_ID provided doesn't exists*/
2430: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Attr_Name and ATT_DISPLAY_NAM and Seq shud not be NULL for CREATE');
2431: p_ta_intf_tbl(i).process_status := G_ERROR_RECORD;
2432: x_return_status := G_RET_STS_ERROR;
2433: /*error_handler.Add_error_message(p_message_name => 'EGO_ICC_INVALID',p_application_id => 'EGO',
2434: p_token_tbl => g_token_table,p_message_type => g_ret_sts_error,
2435: p_row_identifier => P_ag_tbl(i).transaction_id,
2436: p_entity_code => g_entity_ag,p_table_name => g_entity_ag_tab);*/
2437:

Line 2442: /*error_handler.Add_error_message(p_message_name => 'EGO_ICC_INVALID',p_application_id => 'EGO',

2438: ELSIF (p_ta_intf_tbl(i).icc_version_number IS NULL) THEN /*If ICC version is NULL while create*/
2439: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'ERR : ICC_VERSION_NUMBER cannot be NULL while CREATE');
2440: p_ta_intf_tbl(i).process_status := G_ERROR_RECORD;
2441: x_return_status := G_RET_STS_ERROR;
2442: /*error_handler.Add_error_message(p_message_name => 'EGO_ICC_INVALID',p_application_id => 'EGO',
2443: p_token_tbl => g_token_table,p_message_type => g_ret_sts_error,
2444: p_row_identifier => P_ag_tbl(i).transaction_id,
2445: p_entity_code => g_entity_ag,p_table_name => g_entity_ag_tab);*/
2446:

Line 2469: /*error_handler.Add_error_message(p_message_name => 'EGO_ICC_INVALID',p_application_id => 'EGO',

2465:
2466: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Icc_Version_Number greater than zero not allowed while UPDATE and DELETE');
2467: p_ta_intf_tbl(i).process_status := G_ERROR_RECORD;
2468: x_return_status := G_RET_STS_ERROR;
2469: /*error_handler.Add_error_message(p_message_name => 'EGO_ICC_INVALID',p_application_id => 'EGO',
2470: p_token_tbl => g_token_table,p_message_type => g_ret_sts_error,
2471: p_row_identifier => P_ag_tbl(i).transaction_id,
2472: p_entity_code => g_entity_ag,p_table_name => g_entity_ag_tab);*/
2473: END IF;

Line 2930: Error_Handler.Add_Error_Message

2926: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'End Transact_Trans_Attrs');
2927: EXCEPTION
2928: WHEN e_ta_int_name_exist THEN
2929: x_return_status := G_RET_STS_ERROR;
2930: Error_Handler.Add_Error_Message
2931: (
2932: p_message_name => 'EGO_EF_INTERNAL_NAME_UNIQUE'
2933: ,p_application_id => G_APP_NAME
2934: ,p_message_type => G_RET_STS_ERROR

Line 2944: Error_Handler.Add_Error_Message

2940: );
2941:
2942: WHEN e_ta_disp_name_exist THEN
2943: x_return_status := G_RET_STS_ERROR;
2944: Error_Handler.Add_Error_Message
2945: (
2946: p_message_name => 'EGO_TA_DISPLAY_NAME_UNIQUE'
2947: ,p_application_id => G_APP_NAME
2948: ,p_message_type => G_RET_STS_ERROR

Line 2958: Error_Handler.Add_Error_Message

2954: );
2955:
2956: WHEN e_ta_sequence_exist THEN
2957: x_return_status := G_RET_STS_ERROR;
2958: Error_Handler.Add_Error_Message
2959: (
2960: p_message_name => 'EGO_EF_CR_ATTR_DUP_SEQ_ERR'
2961: ,p_application_id => G_APP_NAME
2962: ,p_message_type => G_RET_STS_ERROR