ORACLE EBS :Oracle.apps.fnd.cp.request 并发常用JAVA方法

日志打印

package com.xxt.ebs.request;import java.io.File;import javax.xml.parsers.SAXParser;import javax.xml.parsers.SAXParserFactory;import oracle.apps.fnd.cp.request.CpContext;import oracle.apps.fnd.cp.request.JavaConcurrentProgram;import oracle.apps.fnd.cp.request.LogFile;import oracle.apps.fnd.cp.request.OutFile;import oracle.apps.fnd.cp.request.ReqCompletion;import oracle.apps.fnd.util.NameValueType;import oracle.apps.fnd.util.ParameterList;public class CUX_REQUEST_OUTPUT_EXCEL  implements JavaConcurrentProgram{  public void runProgram(CpContext ctx)  {    ParameterList lPara = ctx.getParameterList();    ReqCompletion lrc = ctx.getReqCompletion();    LogFile LOG_FILE = ctx.getLogFile();    String paramName = "";    String paramValue = "";    int request_id = -1;    String excelType = "";    String outFile = "";    String fileName = "";    try    {      //Loger.init(ctx.getLogFile());      while (lPara.hasMoreElements()) {        NameValueType nvt = lPara.nextParameter();        paramName = nvt.getName();        paramValue = nvt.getValue();        if ("REQUEST_ID".equals(paramName.toUpperCase().trim())) {          request_id = Integer.parseInt(paramValue);          //Loger.log("参数:request_id = " + request_id);          LOG_FILE.writeln("参数:request_id = " + request_id, 0);        } else if ("EXCEL_TYPE".equals(paramName.toUpperCase().trim())) {          excelType = paramValue;          //Loger.log("参数:excel_type = " + excelType);          LOG_FILE.writeln("参数:excel_type = " + excelType, 0);        } else if ("OUT_FILE".equals(paramName.toUpperCase().trim())) {          outFile = paramValue;          //Loger.log("参数:out_file = " + outFile);          LOG_FILE.writeln("参数:out_file = " + outFile, 0);        } else if ("FILE_NAME".equals(paramName.toUpperCase().trim())) {          fileName = paramValue;          //Loger.log("参数:file_name = " + fileName);          LOG_FILE.writeln("参数:file_name = " + fileName, 0);        }      }      //Loger.log("开始生成Excel输出.."); LOG_FILE.writeln("开始生成Excel输出..", 0);      if ("".equals(outFile)) {        LOG_FILE.writeln("请求:" + request_id + ",无法找到输出文件..",0);        //Loger.release();        lrc.setCompletion(1, "No output file!!!");      }      else      {        SAXParserFactory parserFactory = SAXParserFactory.newInstance();        SAXParser parser = parserFactory.newSAXParser();        Xml2ExcelHandler h = new Xml2ExcelHandler(fileName, excelType);        parser.parse(outFile, h);        String fileSize = String.valueOf(new File(fileName).length());        LOG_FILE.writeln("fileName=[" + fileName + "],fileSize=" + fileSize,0);        LOG_FILE.writeln("生成Excel输出完成...",0);        //Loger.release();        lrc.setCompletion(0, fileSize);      }    } catch (Exception e) {      LOG_FILE.writeln(e.toString(),0);      //Loger.release();      lrc.setCompletion(2, "Exception Occurs!!!");    }  }}

参数获取，状态回写

package bxj.oracle.apps.ap.java;import java.util.Hashtable;import oracle.apps.fnd.cp.request.CpContext;import oracle.apps.fnd.cp.request.JavaConcurrentProgram;import oracle.apps.fnd.cp.request.LogFile;import oracle.apps.fnd.cp.request.OutFile;import oracle.apps.fnd.cp.request.ReqCompletion;import oracle.apps.fnd.cp.request.ReqDetails;import oracle.apps.fnd.util.NameValueType;import oracle.apps.fnd.util.ParameterList;public class runEmpConcProg implements JavaConcurrentProgram{    private LogFile mLogFile;    private OutFile mOutFile;    // 主程序处理Employee信息    public void processEmpInform(CpContext cpContext) {        String strUserId;        String strLoginId;        String strRespId;        String strRespApplId;        String strOrgId;        String strBeginDate;        String p_employee_id;        String p_country;        ReqCompletion reqc;        ReqDetails reqd;        Hashtable hashtable = new Hashtable();        collectParameters(cpContext, hashtable);        ReqDetails mReqDetails = cpContext.getReqDetails();        int lp_requestID = mReqDetails.getRequestId();        try        {           collectParameters(cpContext, hashtable);          if ((hashtable.get("USERID") != null & ("".equals(hashtable.get("USERID")) ^ true)))            strUserId = (String)hashtable.get("USERID");          else {            strUserId = String.valueOf(cpContext.getUserId());          }          if ((hashtable.get("LOGINID") != null & ("".equals(hashtable.get("LOGINID")) ^ true)))          {            strLoginId = (String)hashtable.get("LOGINID");          }          else strLoginId = String.valueOf(cpContext.getLoginId());          if ((hashtable.get("RESPID") != null & ("".equals(hashtable.get("RESPID")) ^ true)))            strRespId = (String)hashtable.get("RESPID");          else {            strRespId = String.valueOf(cpContext.getRespId());          }          if ((hashtable.get("RESPAPPLID") != null & ("".equals(hashtable.get("RESPAPPLID")) ^ true)))            strRespApplId = (String)hashtable.get("RESPAPPLID");          else {            strRespApplId = String.valueOf(cpContext.getRespApplId());          }          strOrgId = (String)hashtable.get("ORGID");          strBeginDate = (String)hashtable.get("BEGINDATE");          if ((hashtable.get("EMPLOYEE_ID") != null & ("".equals(hashtable.get("EMPLOYEE_ID")) ^ true)))            p_employee_id = (String)hashtable.get("EMPLOYEE_ID");          else {            p_employee_id = null;          }          if ((hashtable.get("COUNTRY") != null & ("".equals(hashtable.get("COUNTRY")) ^ true)))            p_country = (String)hashtable.get("COUNTRY");          else {            p_country = null;          }          System.out.println("Parameters:" + strUserId + "/" + strLoginId + "/"                              + strRespId + "/" + strRespApplId + "/" + strOrgId + "/" + strBeginDate);          System.out.println("p_employee_id=" + p_employee_id );          System.out.println("p_country=" + p_country );          reqc = cpContext.getReqCompletion();          reqd = cpContext.getReqDetails();          cpContext.getReqCompletion().setCompletion(ReqCompletion.NORMAL, "");         }        catch(Exception ex) {          cpContext.getLogFile().writeln("Concurent Program Exception: " + ex.getMessage(), 1);          cpContext.getReqCompletion().setCompletion(ReqCompletion.NORMAL, "");             ex.printStackTrace();        }    }    //获取并发程序参数    private void collectParameters(CpContext cpcontext, Hashtable hashtable)    {      ParameterList parameterlist = cpcontext.getParameterList();      while (parameterlist.hasMoreElements()) {        NameValueType namevaluetype = parameterlist.nextParameter();        String s = namevaluetype.getName();        String s1 = namevaluetype.getValue();        this.mLogFile.writeln(s + ": " + s1, 3);        if ((s1 != null) && (s1.length() > 0))          hashtable.put(s, s1);      }    }    // 并发程式调用该Java包的接入程序RunProgram    public void runProgram(CpContext cpContext) {       mLogFile = cpContext.getLogFile();       mOutFile = cpContext.getOutFile();       mLogFile.writeln("Start runProgram", 0);       processEmpInform(cpContext);       mLogFile.writeln("END runProgram", 0);       mOutFile.writeln("gavin test outfile");    }    public runEmpConcProg() {    }    public static void main(String[] args) {        System.out.println("main(String[] args");        runEmpConcProg runEmpConcProg = new runEmpConcProg();    }}

参考资料：
http://blog.csdn.net/cunxiyuan108/article/details/7677773

http://blog.csdn.net/cunxiyuan108/article/details/7677758

http://www.cnblogs.com/echochen/archive/2011/11/17/2253148.html

http://www.lai18.com/content/5773188.html?from=cancel