CALLING XML REPOERTS FROM OAF PAGE THROUGH CONCURRENT PROGRAM
if("generatereport".equals(pageContext.getParameter("event"))){
OADBTransactionImpl txn=(OADBTransactionImpl)am.getOADBTransaction();
OAViewObject vo = (OAViewObject)pageContext.getApplicationModule(webBean).findViewObject("AuctionHeadersAllVO"); //getting view object for AuctionHeadersAllVO
String DocumentNumber=(String)vo.getCurrentRow().getAttribute("DocumentNumber"); //getting document number from current row
int DocumentNumber1=Integer.parseInt(DocumentNumber);
pageContext.writeDiagnostics(this,"DocumentNumber in co:"+DocumentNumber,1); //display document number
/* call the method which runs the concurrent program and returns request id*/
int req_id= submitCPRequest(DocumentNumber,txn);
if(pageContext.isLoggingEnabled(1))
{
pageContext.writeDiagnostics(this,"req_id in CO:"+req_id,1); //display request id
}
//Make application sleep for 15 seconds to finish the concurrent program
try
{
CallableStatement cal=txn.createCallableStatement("begin dbms_lock.sleep(20); end;",1);
cal.execute();
cal.close();
}
catch(Exception e)
{
throw OAException.wrapperException(e);
}
//Get the output file name from the backend table
String file_name=null;
try
{
CallableStatement cal=txn.createCallableStatement("begin select file_name into :1 from FND_CONC_REQ_OUTPUTS where concurrent_request_id=:2; end;",1);
cal.setInt(2,req_id);
cal.registerOutParameter(1,Types.VARCHAR);
cal.execute();
file_name= cal.getString(1);
cal.close();
if(pageContext.isLoggingEnabled(1))
{
pageContext.writeDiagnostics(this,"file_name:"+file_name,1);
}
}
catch(Exception e)
{
//throw OAException.wrapperException(e);
System.out.println("no data found");
}
//Read data from output file and display
DataObject sessionDictionary = (DataObject)pageContext.getNamedDataObject("_SessionParameters");
HttpServletResponse response = (HttpServletResponse)sessionDictionary.selectValue(null,"HttpServletResponse");
String contentDisposition = "attachment;filename="+DocumentNumber+".xls";
response.setHeader("Content-Disposition",contentDisposition);
response.setContentType("application/vnd.ms-excel");
File f=new File(file_name);
// File f=new File("/u02/PROD/inst/apps/MPPMCL_bb02/logs/appl/conc/out/XXMPP_SCM_NIT_PUB_TEMP_878237_1.PDF");
if(pageContext.isLoggingEnabled(1))
{
pageContext.writeDiagnostics(this,"output file:"+f,1);
}
try {
if(pageContext.isLoggingEnabled(1))
{
pageContext.writeDiagnostics(this,"in try block:",1);
}
OutputStream os = response.getOutputStream();
byte[] buf = new byte[8192];
InputStream is = new FileInputStream(f);
int c = 0;
while ((c = is.read(buf, 0, buf.length)) > 0) {
os.write(buf, 0, c);
os.flush();
}
os.close();
is.close();
} catch (IOException e) {
e.printStackTrace();
}
}
}
public int submitCPRequest(String Rfq_num,OADBTransaction tx) {
try {
java.sql.Connection pConncection = tx.getJdbcConnection(); //get JDBC connection object
ConcurrentRequest cr = new ConcurrentRequest(pConncection); // get the concurrentrequest object
String applnName = "XXMPP"; //Application that contains the concurrent program
String cpName = "XXMPPTEQTRPT"; //Concurrent program name
String cpDesc = null; // concurrent Program description
Vector cpArgs = new Vector(); //create an object for vector
cpArgs.addElement(Rfq_num); //pass parameters by using vector
try
{
cr.addLayout("XXMPP","XXMPPTEQTRPT","EN","US","EXCEL",null); //addlayout to the concurrent program
}
catch(Exception e)
{
throw OAException.wrapperException(e);
}
int requestId = cr.submitRequest(applnName, cpName, cpDesc, null, false, cpArgs); //call submitRequest method in ConcurrentRequest class
tx.commit(); //commit
return requestId; //return request id
} catch (RequestSubmissionException e) {
OAException oe = new OAException(e.getMessage());
throw oe;
}
}
