<?xml version="1.0" encoding="UTF-8"?>
<xapi:requestset xmlns:xapi="http://xmlns.oracle.com/oxp/xapi" type="bursting">
<xapi:request select="/XXES_GST_AR_INVOICE_PDF/LIST_G_CUSTOMER_NUMBER/G_CUSTOMER_NUMBER">
<xapi:delivery>
<xapi:email id="123" server="150.100.1.85" port="25" from="no.reply@escorts.co.in" reply-to="no.reply@escorts.co.in">
<xapi:message id="123" to="" cc="" attachment="true" content-type="text/html" subject="GST Invoice No.- ${STA_NO} Dated- ${STA_DATE}">
<![CDATA[
<html>
<body>
Dear Sir,
<br/><br/>
Find attached PDF copy of Invoice ${STA_NO}-${DESCRIPTION}.
<br/><br/>
Please call to respective buyer for clarification, If require.
<br/>
<br/>
<i>*************This is a system generated email, do not reply to this email id.Req. ID-${CF_REQ_ID}*************</i>
<br/>
<br/>
Regards,
<br/>
Purchase Department
</body></html>]]>
</xapi:message>
</xapi:email>
</xapi:delivery>
<xapi:document delivery="123" output-type="pdf" output="Invoice_${ORDER_NUMBER}.pdf" >
<xapi:template type="rtf" location="/usr/tmp/XXES_GST_AR_INVOICE_PDF.rtf">
</xapi:template>
</xapi:document>
</xapi:request>
</xapi:requestset>
--------------------------------------------------------------------------------------------------------------------------
Need To Write It In Trigeer-----
function BeforeReport return boolean is
begin
SRW.USER_EXIT('FND SRWINIT');
return (TRUE);
end;
--------------------------------------------------------------------------------------------------------------------------
function AfterReport return boolean is
l_req_id NUMBER;
begin
IF :P_EMAIL ='Y' AND :P_SERVICE_INV_NO = 'Y' then
srw.message(1, 'enter');
l_req_id := fnd_request.submit_request (
application => 'XDO' ,
program => 'XDOBURSTREP'
,description => 'Bursting output'
,start_time => ''
,sub_request => FALSE
,argument1 => 'Y'
,argument2 => fnd_global.conc_request_id
,argument3 => 'Y');
END IF;
SRW.USER_EXIT('FND SRWEXIT');
return (TRUE);
end;
<xapi:requestset xmlns:xapi="http://xmlns.oracle.com/oxp/xapi" type="bursting">
<xapi:request select="/XXES_GST_AR_INVOICE_PDF/LIST_G_CUSTOMER_NUMBER/G_CUSTOMER_NUMBER">
<xapi:delivery>
<xapi:email id="123" server="150.100.1.85" port="25" from="no.reply@escorts.co.in" reply-to="no.reply@escorts.co.in">
<xapi:message id="123" to="" cc="" attachment="true" content-type="text/html" subject="GST Invoice No.- ${STA_NO} Dated- ${STA_DATE}">
<![CDATA[
<html>
<body>
Dear Sir,
<br/><br/>
Find attached PDF copy of Invoice ${STA_NO}-${DESCRIPTION}.
<br/><br/>
Please call to respective buyer for clarification, If require.
<br/>
<br/>
<i>*************This is a system generated email, do not reply to this email id.Req. ID-${CF_REQ_ID}*************</i>
<br/>
<br/>
Regards,
<br/>
Purchase Department
</body></html>]]>
</xapi:message>
</xapi:email>
</xapi:delivery>
<xapi:document delivery="123" output-type="pdf" output="Invoice_${ORDER_NUMBER}.pdf" >
<xapi:template type="rtf" location="/usr/tmp/XXES_GST_AR_INVOICE_PDF.rtf">
</xapi:template>
</xapi:document>
</xapi:request>
</xapi:requestset>
--------------------------------------------------------------------------------------------------------------------------
Need To Write It In Trigeer-----
function BeforeReport return boolean is
begin
SRW.USER_EXIT('FND SRWINIT');
return (TRUE);
end;
--------------------------------------------------------------------------------------------------------------------------
function AfterReport return boolean is
l_req_id NUMBER;
begin
IF :P_EMAIL ='Y' AND :P_SERVICE_INV_NO = 'Y' then
srw.message(1, 'enter');
l_req_id := fnd_request.submit_request (
application => 'XDO' ,
program => 'XDOBURSTREP'
,description => 'Bursting output'
,start_time => ''
,sub_request => FALSE
,argument1 => 'Y'
,argument2 => fnd_global.conc_request_id
,argument3 => 'Y');
END IF;
SRW.USER_EXIT('FND SRWEXIT');
return (TRUE);
end;
No comments:
Post a Comment