Posts by Brahmaiah kolla

How to Convert to Base64formate

package XXBlob.oracle.apps.pos.xxit.webui; import java.io.File; import java.io.FileOutputStream; import java.io.InputStream; import oracle.apps.fnd.common.VersionInfo; import oracle.apps.fnd.framework.OAException; import oracle.apps.fnd.framework.webui.OAControllerImpl; import oracle.apps.fnd.framework.webui.OAPageContext; import oracle.apps.fnd.framework.webui.beans.OAWebBean; import oracle.cabo.ui.data.DataObject; import oracle.jbo.domain.BlobDomain; import java.sql.PreparedStatement; import java.sql.Connection; import javax.xml.bind.DatatypeConverter; /** *…

Read More

How to Call Prepared Statement in OAF

import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; try { Connection conn = pageContext.getApplicationModule(webBean).getOADBTransaction().getJdbcConnection(); String Query = “SELECT count(*) count from RCV_HEADERS_INTERFACE where INTERFACE_HEADER_ID=:1 and ASN_TYPE=’DARFT_ASN'”; PreparedStatement stmt = conn.prepareStatement(Query); stmt.setString(1, project_id);…

Read More

How to call external URL from OAF

public void processRequest(OAPageContext pageContext, OAWebBean webBean) { super.processRequest(pageContext, webBean); String ExternalUrl = pageContext.getParameter(“ExternalUrl”); if ((ExternalUrl != null) || (!””.equals(ExternalUrl))) { String extrnlurl = “function externalurlfunc(){document.location='”+ExternalUrl+”‘;}”; OABodyBean bodyBean = (OABodyBean)pageContext.getRootWebBean(); pageContext.putJavaScriptFunction(“externalurlfunc”,…

Read More

How to assign Database sequence to VO

Assign DB sequence value to VO OAViewObject ASNvo = (OAViewObject)findViewObject(“XXASNDetailsVO”); OARow row = (OARow)ASNvo.first(); row.setAttribute(“ASNId”, getOADBTransaction().getSequenceValue(“XXASN_HEADER_SEQ”).toString());

Read More

VO Row Iterator in OAF

OAApplicationModule am = oapagecontext.getApplicationModule(oawebbean); OADBTransaction oadbtransaction = am.getOADBTransaction(); OAViewObject XXDraftASNLineEOVO = (OAViewObject)am.findViewObject(“XXDraftASNLineEOVO1”); if (XXDraftASNLineEOVO!= null) XXDraftASNLineEOVO.reset(); while (XXDraftASNLineEOVO.hasNext()) { OARow XXDraftASNLineEOVORow = (OARow)XXDraftASNLineEOVO. next (); XXDraftASNLineEOVORow.setAttributes String XXAsn=(String)XXDraftASNLineEOVORow.getAttribute(“XXASN”); XXDraftASNLineEOVORow.setAttribute(“XXASN”,”ASN”); }

Read More

Customall.jar file for OAF

After deploy the code to server we need to generate “customall.jar” file from $JAVA_TOP by using “adcgnjar customall.jar” from the R12.2

Read More

Adding new row at bottom of the where have clicked Through OAF

public void processFormRequest(OAPageContext pageContext, OAWebBean webBean) { super.processFormRequest(pageContext, webBean); OAApplicationModule am=(OAApplicationModule)pageContext.getApplicationModule(webBean); OAViewObject vo = (OAViewObject)am.findViewObject(“XXAddRowVO1″); String refpono=””; if(“AddRowEvent”.equals(pageContext.getParameter(“event”))) { int rs=0; String rowRef1 = pageContext.getParameter(“evtSrcRowRef”); OARow Porowref = (OARow)am.findRowByRef(rowRef1); refpono=Porowref.getAttribute(“Segment1”).toString();…

Read More

Deleting Lines based on conditions through OAF

if (“DeleteEvent”.equals(oapagecontext.getParameter(“event”))) { String rowReference = oapagecontext.getParameter(EVENT_SOURCE_ROW_REFERENCE); OARow currRow = (OARow)oaapplicationmodule.findRowByRef(rowReference); String QuantityShipped =(new StringBuilder()).append(currRow.getAttribute(“QuantityShipped”)).append(“”).toString(); System.out.println(“QuantityShipped in DeleteEvent”+QuantityShipped); if(QuantityShipped.equals(“null”)) { currRow.remove(); oadbtransaction.commit(); throw new OAException(“Record Sucessfully Deleted”, OAException.CONFIRMATION); } else…

Read More

Calling Concurrent Program in OAF

public void submitRequestPKS(OAPageContext oapagecontext, OAWebBean oawebbean, String s, String s1) { OAApplicationModule oaapplicationmodule = oapagecontext.getApplicationModule(oawebbean); OAException oaexception; try { OADBTransaction oadbtransaction = oaapplicationmodule.getOADBTransaction(); Connection connection = oadbtransaction.getJdbcConnection(); ConcurrentRequest concurrentrequest =…

Read More

Invoice Details by using Netting tables

SELECT AI .INVOICE_ID, AI.INVOICE_NUM, TO_CHAR ( AI.INVOICE_AMOUNT + (SELECT NVL (SUM (amount), 0) FROM ap_invoice_lines_All WHERE invoice_id = AI.INVOICE_ID AND LINE_TYPE_LOOKUP_CODE = ‘AWT’), FND_CURRENCY_CACHE.GET_FORMAT_MASK (AI.INVOICE_CURRENCY_CODE, 30) ) invoice_amount, AI.INVOICE_DATE, TO_CHAR…

Read More