DBA Data[Home] [Help]

APPS.ITG_SYNCITEMINBOUND_PVT dependencies on MTL_INTERFACE_ERRORS

Line 564: FROM mtl_interface_errors

560: IS
561: CURSOR error_messages(p_request_id VARCHAR2,p_table_name VARCHAR2)
562: IS
563: SELECT message_name, substr(error_message,1,2000)
564: FROM mtl_interface_errors
565: WHERE request_id = p_request_id
566: AND upper(table_name) = upper(p_table_name);
567:
568: l_err_msg VARCHAR2(4000);

Line 577: from mtl_interface_errors

573: itg_debug_pub.Add('--- Entering error_transactions ---',2);
574: END IF;
575:
576: select count(*) into l_err_msg
577: from mtl_interface_errors
578: where request_id = p_request_id and
579: upper(table_name) = upper(p_table_name);
580:
581: OPEN error_messages(p_request_id,p_table_name);

Line 612: --DELETE FROM mtl_interface_errors

608: IF (l_Debug_Level <= 2) THEN
609: itg_debug_pub.Add('--- Exiting error_transactions ---',2);
610: END IF;
611: /* no value in doing this, this table can be purged periodically */
612: --DELETE FROM mtl_interface_errors
613: --WHERE request_id = p_request_id
614:
615: EXCEPTION
616: WHEN OTHERS THEN