DBA Data[Home] [Help]

APPS.EGO_IMPORT_UTIL_PVT dependencies on MTL_INTERFACE_ERRORS

Line 3777: INSERT INTO MTL_INTERFACE_ERRORS

3773:
3774: FND_MESSAGE.SET_TOKEN('SS_REF', p_item_detail_tbl(i).SOURCE_SYSTEM_REFERENCE);
3775: l_msg_text := FND_MESSAGE.GET;
3776:
3777: INSERT INTO MTL_INTERFACE_ERRORS
3778: (
3779: TRANSACTION_ID,
3780: UNIQUE_ID,
3781: ORGANIZATION_ID,

Line 6398: FROM mtl_interface_errors

6394: BEGIN
6395:
6396: BEGIN
6397: SELECT error_message BULK COLLECT INTO l_item_err_table
6398: FROM mtl_interface_errors
6399: WHERE transaction_id IN ( SELECT transaction_id
6400: FROM mtl_system_items_interface
6401: WHERE set_process_id = p_batch_id
6402: AND process_flag = 3);

Line 6410: FROM mtl_interface_errors

6406: END;
6407:
6408: BEGIN
6409: SELECT error_message BULK COLLECT INTO l_rev_err_table
6410: FROM mtl_interface_errors
6411: WHERE transaction_id IN ( SELECT transaction_id
6412: FROM mtl_item_revisions_interface
6413: WHERE set_process_id = p_batch_id
6414: AND process_flag = 3);

Line 6422: FROM mtl_interface_errors

6418: END;
6419:
6420: BEGIN
6421: SELECT error_message BULK COLLECT INTO l_uda_err_table
6422: FROM mtl_interface_errors
6423: WHERE transaction_id IN ( SELECT transaction_id
6424: FROM EGO_ITM_USR_ATTR_INTRFC
6425: WHERE data_set_id = p_batch_id
6426: AND process_status = 3);