http: // {host name or IP}: {port number} / em
public void processFormRequest(OAPageContext pageContext,
OAWebBean webBean) {
super.processFormRequest(pageContext, webBean);
if (pageContext.getParameter("Print") != null) {
System.out.println("Print Button clicked");
printReport(pageContext, webBean, "pdf");
}
public void printReport(OAPageContext pageContext, OAWebBean webBean,
String outputType) {
OAApplicationModule lo_am = pageContext.getApplicationModule(webBean);
String ls_extensionType = "pdf"; //Setting the output extension type
byte l_outputType = 0;
l_outputType = TemplateHelper.OUTPUT_TYPE_PDF;
DataObject lo_sessionDictionary =
pageContext.getNamedDataObject("_SessionParameters");
HttpServletResponse lo_response =
(HttpServletResponse)lo_sessionDictionary.selectValue(null,
"HttpServletResponse");
try {
ServletOutputStream lo_outputStream =
lo_response.getOutputStream();
// setting the report name & output type
String lo_contentDisposition =
"attachment;filename=OrderDetails." + ls_extensionType;
lo_response.setHeader("Content-Disposition",
lo_contentDisposition);
lo_response.setContentType("application/pdf");
System.out.println("Calling XML generation method");
XMLNode xmlNode =
(XMLNode)lo_am.invokeMethod("getOrderReportDetailsXML");
// Calling getOrderReportDetailsXML method to get the XML for the VO query
ByteArrayOutputStream outputStream = new ByteArrayOutputStream();
xmlNode.print(outputStream);
System.out.println("After calling XML generation method" +
outputStream.toString());
//Above sop will return the XML output which will help you in designing the template.
ByteArrayInputStream lo_inputStream =
new ByteArrayInputStream(outputStream.toByteArray());
ByteArrayOutputStream lo_outputFile = new ByteArrayOutputStream();
// Pass the Template code and Application short name
try {
TemplateHelper.processTemplate(((OADBTransactionImpl)pageContext.getApplicationModule(webBean).getOADBTransaction()).getAppsContext(),
"PA", "XX_ORDER_DT",
((OADBTransactionImpl)pageContext.getApplicationModule(webBean).getOADBTransaction()).getUserLocale().getLanguage(),
((OADBTransactionImpl)pageContext.getApplicationModule(webBean).getOADBTransaction()).getUserLocale().getCountry(),
lo_inputStream, l_outputType,
null, lo_outputFile);
} catch (XDOException xe) {
throw new OAException("Exception:" + xe.getMessage());
}
byte[] l_bytes = lo_outputFile.toByteArray();
lo_response.setContentLength(l_bytes.length);
lo_outputStream.write(l_bytes, 0, l_bytes.length);
lo_outputStream.flush();
lo_outputStream.close();
} catch (Exception e) {
lo_response.setContentType("text/html");
throw new OAException(e.getMessage(), OAException.ERROR);
}
pageContext.setDocumentRendered(false);
}
Application Module Code public XMLNode getOrderReportDetailsXML() {
//XMLNode lo_xmlNode;
System.out.println("Inside the AM Method");
OrderReportDetailsVOImpl vo = getOrderReportDetailsVO1();
vo.executeQuery();
XMLNode lo_xmlNode = (XMLNode)vo.writeXML(-1, 0L);
//OL Stands for XMLInterface.XML_OPT_ALL_ROWS which means to includes all rows in the view object's row set in the XML.
return lo_xmlNode;
}
package xx.oracle.apps.ont.order.webui;
import oracle.apps.fnd.common.VersionInfo;
import oracle.apps.fnd.framework.webui.OAControllerImpl;
import oracle.apps.fnd.framework.webui.OAPageContext;
import oracle.apps.fnd.framework.webui.beans.OAWebBean;
/**
* Controller for ...
*/
public class OrderCO extends OAControllerImpl
{
public static final String RCS_ID="$Header$";
public static final boolean RCS_ID_RECORDED =
VersionInfo.recordClassVersion(RCS_ID, "%packagename%");
/**
* Layout and page setup logic for a region.
* @param pageContext the current OA page context
* @param webBean the web bean corresponding to the region
*/
public void processRequest(OAPageContext pageContext, OAWebBean webBean)
{
super.processRequest(pageContext, webBean);
//init method to initialize the VO & to create 5 rows in it.
pageContext.getApplicationModule(webBean).invokeMethod("init");
}
/**
* Procedure to handle form submissions for form elements in
* a region.
* @param pageContext the current OA page context
* @param webBean the web bean corresponding to the region
*/
public void processFormRequest(OAPageContext pageContext, OAWebBean webBean)
{
super.processFormRequest(pageContext, webBean);
// AM method to handle the save button logic
pageContext.getApplicationModule(webBean).invokeMethod("saveOrderData");
package xx.oracle.apps.ont.order.server; import java.math.BigDecimal; import java.sql.SQLException; import java.sql.Timestamp; import java.sql.Types; import oracle.apps.fnd.framework.OAException; import oracle.apps.fnd.framework.server.OAApplicationModuleImpl; import oracle.apps.fnd.framework.server.OADBTransaction; import oracle.apps.fnd.framework.server.OAExceptionUtils; import oracle.jbo.Row; import oracle.jbo.domain.Number; import oracle.jdbc.OracleCallableStatement; import oracle.jdbc.OracleTypes; import xx.oracle.apps.ont.order.server.OrderVOImpl;
/*
* Method to initialize the VO & to create blank rows in VO */
public void init() {
OrderVOImpl vo = getOrderVO1();
if (!vo.isPreparedForExecution()) {
vo.executeQuery();
Row row = null;
for (int i = 0; i <= 5; i++) {
row = vo.createRow();
vo.insertRow(row);
}
row.setNewRowState(Row.STATUS_INITIALIZED);
}
/* Wrapper to save the Order Entry Data. getOrderRecord() method will return the table type. We are getting this data from Order VO and then passing it to the object type.
Further callOmOrderApi is getting called in this method which takes orderRec as a input parameter and calls the Pl/SQL to insert the data into the custom table. */
public void saveOrderData() {
XxOmOrderTblType orderRec = getOrderRecord();
callOmOrderApi(orderRec);
}
public XxOmOrderTblType getOrderRecord() {
OrderVOImpl vo = getOrderVO1();
XxOmOrderRecType[] orderRec = null;
boolean l_error = false;
if (vo != null) {
System.out.println("VO is not null");
Row[] vorow = vo.getAllRowsInRange();
orderRec = new XxOmOrderRecType[vorow.length];
for (int i = 0; i < vorow.length; i++)
try {
XxOmOrderRecType recType = new XxOmOrderRecType();
OrderVORowImpl row = (OrderVORowImpl)vorow[i];
BigDecimal bg = new BigDecimal(row.getOrderNumber());
recType.setOrderId(bg);
recType.setOrderType(row.getOrderType());
recType.setDescription(row.getOrderDescription());
oracle.jbo.domain.Date d = row.getOrderDate();
java.sql.Date jd = d.dateValue();
System.out.println("Conv Date" + jd);
java.sql.Timestamp t = new Timestamp(jd.getTime());
System.out.println("Conv Date 1 " + t);
recType.setOrderDate(t);
orderRec[i] = recType;
} catch (Exception e) {
throw new OAException("Error " + e.getMessage());
}
}
XxOmOrderTblType table_row = new XxOmOrderTblType(orderRec);
return table_row;
}
/* This method accept table type parameter and calls PL/SQL procedure to write data to DB.
*
public void callOmOrderApi(XxOmOrderTblType issueTable) {
Number lo_count = null;
String lo_status = null;
String ls_msgData = null;
OracleCallableStatement lo_oraclecallablestatement;
OADBTransaction lo_dbtransaction = getOADBTransaction();
System.out.println("Above the callable statement");
lo_oraclecallablestatement = null;
try {
lo_oraclecallablestatement =
(OracleCallableStatement)lo_dbtransaction.createCallableStatement("begin xx_create_order_prc(:1, :2); end;",
1);
lo_oraclecallablestatement.setObject(1, issueTable,
OracleTypes.ARRAY);
lo_oraclecallablestatement.registerOutParameter(2, Types.VARCHAR);
lo_oraclecallablestatement.execute();
lo_status = lo_oraclecallablestatement.getString(2);
if ("S".equalsIgnoreCase(lo_status)) {
lo_dbtransaction.commit();
lo_dbtransaction.putDialogMessage(new OAException("Order Created",
OAException.CONFIRMATION));
} else {
lo_dbtransaction.rollback();
OAExceptionUtils.checkErrors(getOADBTransaction());
}
if (lo_oraclecallablestatement != null)
lo_oraclecallablestatement.close();
} catch (SQLException sqlexception) {
throw new OAException(sqlexception.getMessage());
}
}
PL/SQL Code public void checkDuplicateRow() {
XxTestToolsVOImpl lo_tools = getXxTestToolsVO(); //Table View Object
XxTestToolsVOImpl clonevo =
(XxTestToolsVOImpl)this.findViewObject("XxTestToolsVO2"); //Dummy VO for check duplicity
if (clonevo == null) {
//Create Dummy VO
clonevo =
(XxTestToolsVOImpl)this.createViewObject("XxTestToolsVO2",
"xxadat.oracle.apps.ahl.tools.server.XxAdatToolsVO");
}
clonevo.clearCache();
Row[] sourceVORows =
lo_tools.getFilteredRows("SelectFlag", "Y"); //Picking only those row where the Checkbox is checked
if (!(clonevo.isPreparedForExecution())) {
clonevo.executeQuery();
}
//Create ClonveVO with SourceVO rows
for (Row row: sourceVORows) {
Row cloneRow = clonevo.createRow();
cloneRow = row;
clonevo.insertRowAtRangeIndex(clonevo.getRangeIndexOf(clonevo.last()) +
1, cloneRow);//Inserting row one after another
}
int i = 0;
int j;
{
for (Row row: sourceVORows) {
j = 0;
for (clonevo.first(); j < clonevo.getFetchedRowCount();
clonevo.next()) {
if (i == j) {
j++;
continue; //Ignore the row where index is same.
}
// This loop compare 1st row with all the rows except 1st then second row will all the rows except 2nd and so on.
if ((row.getAttribute("SerialNumber") +"").equals((clonevo.getCurrentRow().getAttribute("SerialNumber"))+"") && (row.getAttribute("InventoryItemId") + "").equals((clonevo.getCurrentRow().getAttribute("InventoryItemId"))+"") && (row.getAttribute("LotNumber") + "").equals((clonevo.getCurrentRow().getAttribute("LotNumber")) + "") && (row.getAttribute("SubinventoryCode") + "").equals((clonevo.getCurrentRow().getAttribute("SubinventoryCode")) + "") && (row.getAttribute("Locator") + "").equals((clonevo.getCurrentRow().getAttribute("Locator")) + ""))
{
clonevo.remove(); //If the row is duplicate remove the dummy VO
throw new OAException("Row Number " + (i + 1) + " and " + (j + 1) + " is duplicate." + " Please select only unique Tools to issue");
}
j++;
}
i++;
}
lo_tools.first();
clonevo.remove();
}
}
Thanks,
--Anil public void SettingWhoColumns(String CStringDate) {
java.sql.Date ConvStringDate = null;
try {
Connection conn = getOADBTransaction().getJdbcConnection();
String Query =
"insert into XX_INSERT_WHO_COLUMNS CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN values (:1, :2, :3, :4 ,:5)";
PreparedStatement stmt = conn.prepareStatement(Query);
//Creation Date
stmt.setTimestamp(1, new Timestamp(System.currentTimeMillis()));
stmt.setInt(2, getOADBTransaction().getUserId()); // Created by
//Last update date
stmt.setTimestamp(3, new Timestamp(System.currentTimeMillis()));
stmt.setInt(4, getOADBTransaction().getUserId()); // Last updated by
stmt.setInt(5,getOADBTransaction().getLoginId()); // Last updated login
//Who columns setting end here.....
// Getting Date as a String, Converting it to Date format and setting it
if (CStringDate != null & !("".equalsIgnoreCase(CStringDate))) {
SimpleDateFormat dtformatter =
new SimpleDateFormat("dd-MMM-yyyy");
ConvStringDate =
new java.sql.Date(dtformatter.parse(CStringDate).getTime());
dtformatter.format(ConvStringDate);
}
stmt.setDate(6, ConvStringDate);
} catch (Exception e) {
throw new OAException("Exception" + e);
}
}
Thanks,--Anil
import com.oaframework.toolkit.util.WebBeanUtil;
public void processRequest(OAPageContext pageContext, OAWebBean webBean) {
super.processRequest(pageContext, webBean);
{
// this class loops all the webbean hierarchy and make read only each and even bean and also sets the CSS accordingly.
WebBeanUtil.setViewOnlyRecursive(pageContext, webBean);
}
In case of you are not able to get the WebBeanUtil file then please mail me I will provide you.
public void processRequest(OAPageContext pageContext, OAWebBean webBean) {
super.processRequest(pageContext, webBean);
OAApplicationModule oaapplicationmodule =
pageContext.getApplicationModule(webBean);
// Executing KFF VO query
oaapplicationmodule.invokeMethod("executeQuery");
//Getting the KFF Bean
OAKeyFlexBean kffId =
(OAKeyFlexBean)webBean.findChildRecursive("kffFlex");
kffId = (OAKeyFlexBean)webBean.findChildRecursive("kffFlex");
kffId.setStructureCode("JOB_FLEXFIELD");
kffId.setCCIDAttributeName("IdFlexNum");
//kffId.setDynamicInsertion(true);
kffId.useCodeCombinationLOV(false);
kffId.processFlex(pageContext);
System.out.println("kff " +
kffId.getIndexedChildCount(pageContext.getRenderingContext()));
int i = kffId.getIndexedChildCount(pageContext.getRenderingContext());
for (int j = 0; j < i; j++) {
System.out.println("Inside the for loop");
oracle.cabo.ui.UINode uinode =
kffId.getIndexedChild(pageContext.getRenderingContext(), j);
if (uinode instanceof OAMessageTextInputBean) {
System.out.println("Inside the MTI");
// ((OAMessageTextInputBean)uinode).setText("message");
// ((OAMessageTextInputBean)uinode).setCSSClass("OraErrorText");
//Setting value in selected KFF Bean (It start from 0, thats why for our case it is kffFlex0)
if ("kffFlex0".equalsIgnoreCase(uinode.getID()))
((OAMessageTextInputBean)uinode).setText("HYLEX");
System.out.println(uinode.getID());
}
}
}
public void processRequest(OAPageContext pageContext, OAWebBean webBean) {
super.processRequest(pageContext, webBean);
oracle.cabo.ui.action.FireAction FireActionA = new oracle.cabo.ui.action.FireAction();
FireActionA.setEvent("RevenueEvent"); //Event Name
FireActionA.setUnvalidated(true);
revenuechk.setPrimaryClientAction(FireActionA); //revenuechk is the Id of the field
public void processFormRequest(OAPageContext pageContext, OAWebBean webBean){
super.processFormRequest(pageContext, webBean);
if("RevenueEvent".equals(pageContext.getParameter(SOURCE_PARAM)))
{
//Event handling here
}
Thanks,