Message: Could not Dispatch Work Order

Timestamp: Wed Jun 10 08:40:59 GMT-0400 2015

Layer of the error: DB

Original Call: dispatchWorkOrder

Original Message: faultCode:Server.Processing faultString:'com.mascocs.sd2.exception.MascoException : ORA-01403: no data foundORA-06512: at "APPS.XXMCS_SD_PKG", line 18545ORA-06512: at "APPS.XXMCS_SD_PKG", line 18459ORA-06512: at line 1' faultDetail:'null'

Call stack: java.sql.SQLException: ORA-01403: no data foundORA-06512: at "APPS.XXMCS_SD_PKG", line 18545ORA-06512: at "APPS.XXMCS_SD_PKG", line 18459ORA-06512: at line 1

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639)at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:184)at oracle.jdbc.driver.T4CCallableStatement.execute_for_rows(T4CCallableStatement.java:873)at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1161)at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3001)at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3093)at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4286)at oracle.oc4j.sql.proxy.PreparedStatementBCELProxy.execute(PreparedStatementBCELProxy.java:333)at com.mascocs.sd2.dispatch.dao.OracleDragAndDropDAO.dispatchWorkOrder(OracleDragAndDropDAO.java:103)at com.mascocs.sd2.dispatch.remoting.DragAndDropRemoting.dispatchWorkOrder(DragAndDropRemoting.java:47)at sun.reflect.GeneratedMethodAccessor355.invoke(Unknown Source)at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)at java.lang.reflect.Method.invoke(Method.java:585)at flex.messaging.services.remoting.adapters.JavaAdapter.invoke(JavaAdapter.java:421)at flex.messaging.services.RemotingService.serviceMessage(RemotingService.java:183)at flex.messaging.MessageBroker.routeMessageToService(MessageBroker.java:1503)at flex.messaging.endpoints.AbstractEndpoint.serviceMessage(AbstractEndpoint.java:884)at flex.messaging.endpoints.amf.MessageBrokerFilter.invoke(MessageBrokerFilter.java:121)at flex.messaging.endpoints.amf.LegacyFilter.invoke(LegacyFilter.java:158)at flex.messaging.endpoints.amf.SessionFilter.invoke(SessionFilter.java:44)at flex.messaging.endpoints.amf.BatchProcessFilter.invoke(BatchProcessFilter.java:67)at flex.messaging.endpoints.amf.SerializationFilter.invoke(SerializationFilter.java:146)at flex.messaging.endpoints.BaseHTTPEndpoint.service(BaseHTTPEndpoint.java:278)at flex.messaging.MessageBrokerServlet.service(MessageBrokerServlet.java:322)at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713)at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)at java.lang.Thread.run(Thread.java:595)