Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

UTL_FILE.FOPEN ERROR FOR HTML FILE ENDING WITH ORA-29284 FILE READ ERROR

841964Jan 4 2012 — edited Jan 4 2012
Hi,

I've one requirement where in I need to fetch output file from Oracle applications APPLCSF/APPLOUT folder. This file needs to be placed one folder where directory and grants have been provided.

This output needs to be send to multiple people with their email ids. Currently this is single output file for that I have written some piece of code where in it has read to html file. But every time it is failing with this error ora-29824 file read error. Please help me to begug this issue.
DECLARE

filename varchar2(25) := 'o'||to_char(P_CONC_REQUEST_ID)||'.out';
fp UTL_FILE.FILE_TYPE;


ofilename varchar2(100);
ofp UTL_FILE.FILE_TYPE;

l_process_count number := 0;
l_success_count number := 0;
l_error_count   number := 0;
wait_time       number := 0;
file_cnt        number := 100;
first_invoice   varchar2(1)  := 'Y';
write_flag      varchar2(1)  := 'Y';

rec_line        varchar2(8000);
X_LONG_TEXT     VARCHAR2(5000);
X_DOC_TYPE      VARCHAR2(50);
X_EMAIL         VARCHAR2(240);
X_GET_EMAIL_ID  VARCHAR2(100);

x_msg_from      VARCHAR2(240);
x_msg_to        VARCHAR2(240);
x_msg_subject   VARCHAR2(240);
x_msg_body      VARCHAR2(5000);
x_msg_body_type VARCHAR2(50);
x_msg_filename  varchar2(100);
file_path       VARCHAR2(100):= 'UTL_DIR';--'/usr/tmp/SPT';

BEGIN

fnd_file.put_line (fnd_file.LOG, 'starting of genmail ');
	LOOP  /* Set Delay for previous to complete */
	if wait_time > 1000000
	then
	    exit;
	end if;
	wait_time := wait_time  + 1;
	END LOOP ;


fnd_file.put_line (fnd_file.LOG, 'starting of genmail '||filename);

	--fp := utl_file.fopen('/var/tmp',filename,'r',32767);

	fp := utl_file.fopen(file_path,filename,'r');


	write_flag := 'Y';


	LOOP	      -- Outer loop for file

	FILE_CNT := FILE_CNT + 1;	      -- counter used to name the split files

	ofilename := to_char(P_CONC_REQUEST_ID)||'-'||lpad(FILE_CNT,4,0)||'.htm';

	ofp := utl_file.fopen('UTL_DIR',ofilename,'w',32767);

	x_msg_from     := '';
	x_msg_to       := '';
	x_msg_subject  := '';
	x_msg_body     := '';
	x_msg_filename := '';

	IF FIRST_INVOICE = 'N'
	then
	 utl_file.put_line(ofp,'<html>');
	 utl_file.put_line(ofp,'<body dir=LTR bgcolor="#ffffff">');
		END IF;


		LOOP	--- Loop to read and write lines for each mail file

		begin
		    utl_file.get_line(fp, rec_line);
		exception
				  when others then
		     FND_FILE.put_line(FND_FILE.log,' OTHER ERROR (in getline from output file ) : '||sqlerrm);
		     exit;  --null;
		end;


		if    (INSTR(rec_line,'AR Invoice Note 1',1) > 0 )
		then
		    X_DOC_TYPE      := 'AR Invoice Note 1';
		    x_msg_body_type := 'Email AR Invoice';
		    x_msg_subject   := 'Invoice';
		    X_GET_EMAIL_ID  := 'RP AR FROM EMAIL ID';
				end if;


		IF (INSTR(rec_line,X_DOC_TYPE,1) > 0 )THEN
			 -- Notes used at the end of invoice/ statement
			BEGIN
			SELECT LONG_TEXT
			INTO X_LONG_TEXT
			FROM FND_DOCUMENTS_VL TT, FND_DOCUMENTS_LONG_TEXT LT
			where TT.DOCUMENT_ID  in ( select D.DOCUMENT_ID
			FROM FND_DOCUMENT_CATEGORIES_TL CL,
			     FND_DOCUMENT_CATEGORIES C,
			     FND_DOCUMENT_DATATYPES DD,
			     FND_LOOKUP_VALUES L,
			     FND_DOCUMENTS D
			WHERE D.DATATYPE_ID = DD.DATATYPE_ID
			  AND D.CATEGORY_ID = C.CATEGORY_ID
			  AND C.CATEGORY_ID = CL.CATEGORY_ID
			  AND D.USAGE_TYPE = L.LOOKUP_CODE
			  AND L.LOOKUP_TYPE = 'ATCHMT_DOCUMENT_TYPE'
			AND CL.USER_NAME = 'Miscellaneous'
			AND L.MEANING = 'Standard' )
			AND TT.MEDIA_ID = LT.MEDIA_ID
			and substr(TT.DESCRIPTION,1,50) = X_DOC_TYPE;
			EXCEPTION
			   When others then
				FND_FILE.put_line(FND_FILE.log,'---------------------------------------') ;
				FND_FILE.put_line(FND_FILE.log,'No notes with name <' || x_msg_body_type || '> defined for the notes in invoice/statement body ' ) ;
				FND_FILE.put_line(FND_FILE.log,'Error message is '||substr(sqlerrm,1,80));
				FND_FILE.put_line(FND_FILE.log,'---------------------------------------') ;

			END ;

			-- Insert the notes inbetween the table tags
			rec_line := '</table>
			<table>
			<pre>'||X_LONG_TEXT||'</pre></table>';
	    	END IF;

		--When the string 'Customer Email ID :' is found, close the body of the
		--file (signifies the end of invoice/statement for that person) and send
		--out the email. In the report the email id is printed as a last statement
		--for every invoice to signify end of invoice/statement contents
		if (INSTR(rec_line,'Customer Email ID:',1) > 0 )
		then

		begin
			select
			SUBSTR(rec_line,
				(INSTR(rec_line,'Customer Email ID:',1)+LENGTH('Customer Email ID:')),
				(INSTR(rec_line,'END',1) - (INSTR(rec_line,'Customer Email ID:',1)+ LENGTH('Customer Email ID:')) ))
			INTO X_EMAIL from dual;

			FND_FILE.put_line(FND_FILE.output,ofilename||'   '||X_EMAIL);
			FND_FILE.put_line(FND_FILE.log,ofilename||'   '||X_EMAIL);

			exception when others then
			X_EMAIL := 'None';
			end;

			/* Insert into rp_email_map(file_name, Email_text)
					  values(ofilename, nvl(replace(X_EMAIL,' ',''),P_EMAIL_ID)); */

			utl_file.put_line(ofp,'</body></html>');
			FIRST_INVOICE := 'N';
			write_flag  := 'N';
			exit;
		end if;


		   if (rec_line = '</table>') AND (write_flag = 'N')
		   then
		       write_flag := 'Y';
		   else
		       if write_flag = 'Y'
		       then
			   begin
			   utl_file.put_line(ofp,rec_line);
			   exception
								  when others then
				     FND_FILE.put_line(FND_FILE.log,'2 - Other ERROR ( in putline while slicing/writing into file ) : '||sqlerrm);
				     exit;  --null;
				end;
		       end if;
		   end if;

		end loop;	 --- Loop to read and write lines for each mail file
	utl_file.fflush(ofp);
	utl_file.fclose(ofp);

	/* Start Send-Email */
	-- Get the email body portion notes
	begin
		SELECT LONG_TEXT INTO x_msg_body FROM FND_DOCUMENTS_VL TT, FND_DOCUMENTS_LONG_TEXT LT
		where TT.DOCUMENT_ID  in ( select D.DOCUMENT_ID
		FROM FND_DOCUMENT_CATEGORIES_TL CL,
		     FND_DOCUMENT_CATEGORIES C,
		     FND_DOCUMENT_DATATYPES DD,
		     FND_LOOKUP_VALUES L,
		     FND_DOCUMENTS D
		WHERE D.DATATYPE_ID = DD.DATATYPE_ID
		  AND D.CATEGORY_ID = C.CATEGORY_ID
		  AND C.CATEGORY_ID = CL.CATEGORY_ID
		  AND D.USAGE_TYPE = L.LOOKUP_CODE
		  AND L.LOOKUP_TYPE = 'ATCHMT_DOCUMENT_TYPE'
		AND CL.USER_NAME = 'Miscellaneous'
		AND L.MEANING = 'Standard' )
		AND TT.MEDIA_ID = LT.MEDIA_ID
		and substr(TT.DESCRIPTION,1,50) = x_msg_body_type;
	exception
	when others then
		FND_FILE.put_line(FND_FILE.log,'---------------------------------------') ;
		FND_FILE.put_line(FND_FILE.log,'No notes with name <' || x_msg_body_type || '> defined for the body of this  email ' ) ;
		FND_FILE.put_line(FND_FILE.log,'Error message is '||substr(sqlerrm,1,80));
		FND_FILE.put_line(FND_FILE.log,'---------------------------------------') ;
	end;

	-- The value stored in this profile will be displayed as the from adress for the
	-- sent mails

	fnd_profile.GET(X_GET_EMAIL_ID,x_msg_from);
	x_msg_body     :=  '<table><pre>'||x_msg_body||'</pre></table>';
	x_msg_to       :=  nvl(replace(X_EMAIL,' ',''),x_msg_from);
	x_msg_filename :=  ofilename;

	if rec_line = '</body></html>'	then
	   exit;
	end if;

	send_mail (
	  x_msg_from       ,
	  x_msg_to         ,
	  x_msg_subject    ,
	  x_msg_body       ,
	  x_msg_filename
	   );

	/* End Send-Email */


end loop;    --- Outer loop for output file reading

utl_file.fflush(fp);
utl_file.fclose(fp);
commit;

exception
  when utl_file.INVALID_PATH then
    FND_FILE.put_line(FND_FILE.log,'ERROR: Invalid Path ==>'||substr(sqlerrm,1,80));
    utl_file.fclose(fp);
  when others then
    --utl_file.fflush(ofp);
    DBMS_OUTPUT.put_line('ERROR: '||substr(sqlerrm,1,80));
    FND_FILE.put_line(FND_FILE.log,'Other Error ( Final EOF Marker - No harm) : '||substr(sqlerrm,1,80));
    null;
end;
File output below which I am trying to read
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type"  content="text/html; charset=UTF-8">
<title></title>
</head>
<body dir="LTR" bgcolor="#ffffff">
<!-- Created by Oracle Reports 16:21 Wed Jan 04 04:21:15 PM, 2012 -->

<table border=0 cellspacing=0 cellpadding=0 width=816>
<tr><td width=25></td><td width=1></td><td width=3></td><td width=3></td><td width=1></td><td width=1></td><td width=13></td><td width=12></td><td width=1></td><td width=4></td><td width=1></td><td width=9></td><td width=2></td><td width=35></td><td width=29></td><td width=7></td><td width=11></td><td width=9></td><td width=36></td><td width=2></td><td width=8></td><td width=11></td><td width=84></td><td width=11></td><td width=15></td><td width=7></td><td width=12></td><td width=12></td><td width=29></td><td width=4></td><td width=1></td><td width=23></td><td width=23></td><td width=33></td><td width=1></td><td width=64></td><td width=16></td><td width=23></td><td width=2></td><td width=1></td><td width=1></td><td width=6></td><td width=1></td><td width=2></td><td width=3></td><td width=5></td><td width=14></td><td width=4></td><td width=21></td><td width=1></td><td width=3></td><td width=81></td><td width=1></td><td width=1></td><td width=10></td><td width=3></td><td width=1></td><td width=1></td><td width=1></td><td width=71></td></tr>
<tr><td colspan=60 height=67></td></tr>
<tr valign=top>
  <td height=9></td>
  <td colspan=18 rowspan=7><img src=o4538983fbBdJ470.jpg ALT="" width=179 height=69 border=0></td>
  <td colspan=2></td>
  <td width=330 colspan=15 rowspan=2><font size=2 face="courier"><tt>Woodlands&nbsp;Campus</tt></font></td>
  <td colspan=12></td>
  <td width=123 colspan=10 rowspan=2 align=right><font face="courier"><b><tt>TAX&nbsp;INVOICE</tt></b></font></td>
  <td colspan=2></td>
</tr>
<tr valign=top>
  <td height=9></td>
  <td colspan=2></td>
  <td colspan=12></td>
  <td colspan=2></td>
</tr>
<tr valign=top>
  <td height=9></td>
  <td colspan=4></td>
  <td width=11 rowspan=2><font size=2 face="courier"><tt>&nbsp;&nbsp;</tt></font></td>
  <td colspan=5></td>
  <td width=5 colspan=2 rowspan=2><font size=2 face="courier"><tt>&nbsp;</tt></font></td>
  <td colspan=6></td>
  <td width=83 colspan=12 rowspan=2 align=right><font size=2 face="courier"><tt>GST&nbsp;REG&nbsp;NO.:</tt></font></td>
  <td></td>
  <td width=101 colspan=8 rowspan=2 align=right><font size=2 face="courier"><tt>M9-0007282-L</tt></font></td>
  <td colspan=2></td>
</tr>
<tr valign=top>
  <td height=9></td>
  <td colspan=4></td>
  <td colspan=5></td>
  <td colspan=6></td>
  <td></td>
  <td colspan=2></td>
</tr>
<tr valign=top>
  <td height=9></td>
  <td colspan=2></td>
  <td width=330 colspan=15 rowspan=2><font size=2 face="courier"><tt>Tel:&nbsp;(65)&nbsp;6510&nbsp;3000&nbsp;&nbsp;Fax:&nbsp;(65)&nbsp;6415&nbsp;1310</tt></font></td>
  <td colspan=24></td>
</tr>
<tr valign=top>
  <td height=9></td>
  <td colspan=2></td>
  <td></td>
  <td width=84 colspan=13 rowspan=2 align=right><font size=2 face="courier"><tt>UEN&nbsp;NO.:</tt></font></td>
  <td></td>
  <td width=97 colspan=6 rowspan=2 align=right><font size=2 face="courier"><tt>T08GB0046G</tt></font></td>
  <td colspan=3></td>
</tr>
<tr valign=top>
  <td height=9></td>
  <td colspan=2></td>
  <td width=330 colspan=15 rowspan=2><font size=2 face="courier"><tt>Website:&nbsp;http://www.rp.edu.sg</tt></font></td>
  <td></td>
  <td></td>
  <td colspan=3></td>
</tr>
<tr valign=top>
  <td height=9 colspan=21></td>
  <td colspan=24></td>
</tr>
<tr><td colspan=60 height=19></td></tr>
<tr valign=top>
  <td height=9 colspan=5></td>
  <td width=172 colspan=15 rowspan=2><font size=2 face="courier"><tt>Ang&nbsp;Mo&nbsp;Kio&nbsp;Secondary&nbsp;School</tt></font></td>
  <td colspan=40></td>
</tr>
<tr valign=top>
  <td height=9 colspan=5></td>
  <td colspan=14></td>
  <td width=114 colspan=8 rowspan=2><font size=2 face="courier"><tt>Reference&nbsp;No.</tt></font></td>
  <td colspan=4></td>
  <td width=126 colspan=8 rowspan=2><font size=2 face="courier"><tt>1481</tt></font></td>
  <td colspan=6></td>
</tr>
<tr valign=top>
  <td height=9 colspan=5></td>
  <td width=114 colspan=11 rowspan=2><font size=2 face="courier"><tt>51&nbsp;Sembawang&nbsp;Drive</tt></font></td>
  <td colspan=18></td>
  <td colspan=4></td>
  <td colspan=6></td>
</tr>
<tr valign=top>
  <td height=9 colspan=5></td>
  <td colspan=18></td>
  <td width=114 colspan=8 rowspan=2><font size=2 face="courier"><tt>Invoice&nbsp;No.</tt></font></td>
  <td colspan=4></td>
  <td width=125 colspan=7 rowspan=2><font size=2 face="courier"><tt>1000001</tt></font></td>
  <td colspan=7></td>
</tr>
<tr valign=top>
  <td height=9 colspan=34></td>
  <td colspan=4></td>
  <td colspan=7></td>
</tr>
<tr valign=top>
  <td height=9 colspan=4></td>
  <td rowspan=2><font size=2 face="courier"><tt>&nbsp;</tt></font></td>
  <td colspan=30></td>
  <td width=114 colspan=8 rowspan=2><font size=2 face="courier"><tt>Invoice&nbsp;Date</tt></font></td>
  <td colspan=4></td>
  <td width=125 colspan=7 rowspan=2><font size=2 face="courier"><tt>20-OCT-11</tt></font></td>
  <td colspan=7></td>
</tr>
<tr valign=top>
  <td height=9 colspan=4></td>
  <td colspan=30></td>
  <td colspan=4></td>
  <td colspan=7></td>
</tr>
<tr valign=top>
  <td height=9 colspan=4></td>
  <td width=390 colspan=28 rowspan=2><font size=2 face="courier"><tt>&nbsp;</tt></font></td>
  <td colspan=3></td>
  <td width=114 colspan=8 rowspan=2><font size=2 face="courier"><tt>Due&nbsp;Date&nbsp;</tt></font></td>
  <td colspan=3></td>
  <td width=124 colspan=6 rowspan=2><font size=2 face="courier"><tt>19-NOV-11</tt></font></td>
  <td colspan=8></td>
</tr>
<tr valign=top>
  <td height=9 colspan=4></td>
  <td colspan=3></td>
  <td colspan=3></td>
  <td colspan=8></td>
</tr>
<tr valign=top>
  <td height=9 colspan=4></td>
  <td width=108 colspan=11 rowspan=2><font size=2 face="courier"><tt>Singapore&nbsp;&nbsp;757699</tt></font></td>
  <td></td>
  <td width=11 rowspan=2><font size=2 face="courier"><tt>&nbsp;&nbsp;</tt></font></td>
  <td></td>
  <td width=57 colspan=4 rowspan=2><font size=2 face="courier"><tt>Singapore</tt></font></td>
  <td colspan=38></td>
</tr>
<tr valign=top>
  <td height=9 colspan=4></td>
  <td></td>
  <td></td>
  <td colspan=38></td>
</tr>
<tr><td colspan=60 height=9></td></tr>
<tr valign=top>
  <td height=9 colspan=6></td>
  <td width=30 colspan=4 rowspan=2><font size=2 face="courier"><tt>Attn:</tt></font></td>
  <td colspan=2></td>
  <td width=260 colspan=13 rowspan=2><font size=2 face="courier"><tt>&nbsp;</tt></font></td>
  <td colspan=35></td>
</tr>
<tr valign=top>
  <td height=9 colspan=6></td>
  <td colspan=2></td>
  <td colspan=35></td>
</tr>
<tr valign=top>
  <td height=9 colspan=12></td>
  <td width=291 colspan=16 rowspan=2><font size=2 face="courier"><tt>&nbsp;</tt></font></td>
  <td colspan=32></td>
</tr>
<tr valign=top>
  <td height=9 colspan=12></td>
  <td colspan=32></td>
</tr>
<tr><td colspan=60 height=28></td></tr>
<tr valign=top>
  <td height=9></td>
  <td width=720 colspan=58 align=right><font size=2 face="courier"><tt>-----------------------------------------------------------------------------------------------------------------</tt></font></td>
  <td></td>
</tr>
<tr valign=top>
  <td height=9 colspan=2></td>
  <td width=33 colspan=6 rowspan=2><font size=2 face="courier"><tt>S/No.</tt></font></td>
  <td colspan=3></td>
  <td width=276 colspan=15 rowspan=2><font size=2 face="courier"><tt>Description</tt></font></td>
  <td colspan=12></td>
  <td width=163 colspan=21 rowspan=2 align=right><font size=2 face="courier"><tt>Amount(SGD)</tt></font></td>
  <td></td>
</tr>
<tr valign=top>
  <td height=9 colspan=2></td>
  <td colspan=3></td>
  <td colspan=12></td>
  <td></td>
</tr>
<tr valign=top>
  <td height=9 colspan=2></td>
  <td width=719 colspan=57 align=right><font size=2 face="courier"><tt>-----------------------------------------------------------------------------------------------------------------</tt></font></td>
  <td></td>
</tr>
<tr><td colspan=60 height=28></td></tr>
<tr valign=top>
  <td height=9 colspan=3></td>
  <td width=18 colspan=4 rowspan=2 align=right><font size=2 face="courier"><tt>1</tt></font></td>
  <td colspan=6></td>
  <td width=277 colspan=14 rowspan=2><font size=2 face="courier"><tt>Rental&nbsp;of&nbsp;OES&nbsp;furniture&nbsp;and&nbsp;equipment</tt></font></td>
  <td colspan=20></td>
  <td width=125 colspan=9 rowspan=2 align=right><font size=2 face="courier"><tt>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;100.00</tt></font></td>
  <td colspan=4></td>
</tr>
<tr valign=top>
  <td height=9 colspan=3></td>
  <td colspan=6></td>
  <td colspan=20></td>
  <td colspan=4></td>
</tr>
<tr><td colspan=60 height=19></td></tr>
<tr valign=top>
  <td height=9 colspan=30></td>
  <td width=344 colspan=26 align=right><font size=2 face="courier"><tt>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</tt></font></td>
  <td colspan=4></td>
</tr>
<tr valign=top>
  <td height=9 colspan=39></td>
  <td width=158 colspan=17 align=right><font size=2 face="courier"><tt>-------------------------</tt></font></td>
  <td colspan=4></td>
</tr>
<tr><td colspan=60 height=9></td></tr>
<tr valign=top>
  <td height=9 colspan=33></td>
  <td width=139 colspan=6 rowspan=2><font size=2 face="courier"><tt>Amount&nbsp;Before&nbsp;GST</tt></font></td>
  <td colspan=5></td>
  <td width=144 colspan=11 rowspan=2 align=right><font size=2 face="courier"><tt>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;100.00</tt></font></td>
  <td colspan=5></td>
</tr>
<tr valign=top>
  <td height=9 colspan=33></td>
  <td colspan=5></td>
  <td colspan=5></td>
</tr>
<tr valign=top>
  <td height=9 colspan=33></td>
  <td width=139 colspan=6 rowspan=2><font size=2 face="courier"><tt>Add&nbsp;GST</tt></font></td>
  <td colspan=5></td>
  <td width=144 colspan=11 rowspan=2 align=right><font size=2 face="courier"><tt>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;7.00</tt></font></td>
  <td colspan=5></td>
</tr>
<tr valign=top>
  <td height=9 colspan=33></td>
  <td colspan=5></td>
  <td colspan=5></td>
</tr>
<tr valign=top>
  <td height=9 colspan=40></td>
  <td width=157 colspan=16 rowspan=2 align=right><font size=2 face="courier"><tt>-------------------------</tt></font></td>
  <td colspan=4></td>
</tr>
<tr valign=top>
  <td height=9 colspan=40></td>
  <td colspan=4></td>
</tr>
<tr><td colspan=60 height=9></td></tr>
<tr valign=top>
  <td height=9 colspan=33></td>
  <td width=139 colspan=6 rowspan=2><font size=2 face="courier"><tt>AMOUNT&nbsp;PAYABLE</tt></font></td>
  <td colspan=6></td>
  <td width=141 colspan=10 rowspan=2 align=right><font size=2 face="courier"><tt>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;107.00</tt></font></td>
  <td colspan=5></td>
</tr>
<tr valign=top>
  <td height=9 colspan=33></td>
  <td colspan=6></td>
  <td colspan=5></td>
</tr>
<tr valign=top>
  <td height=9 colspan=41></td>
  <td width=157 colspan=16 align=right><font size=2 face="courier"><tt>=========================</tt></font></td>
  <td colspan=3></td>
</tr>
<tr><td colspan=60 height=9></td></tr>
<tr valign=top>
  <td height=9 colspan=9></td>
  <td width=51 colspan=5 align=right><font size=2 face="courier"><tt>&nbsp;&nbsp;&nbsp;&nbsp;</tt></font></td>
  <td colspan=46></td>
</tr>
<tr valign=top>
  <td height=9 colspan=9></td>
  <td width=684 colspan=49 rowspan=27> <font size=2 face="courier"><tt>Note:</tt></font><br><font size=2 face="courier"><tt>1)&nbsp;Please&nbsp;credit&nbsp;payment&nbsp;directly&nbsp;to&nbsp;our&nbsp;bank&nbsp;account:</tt></font><br><font size=2 face="courier"><tt>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Account&nbsp;Name:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Republic&nbsp;Polytechnic&nbsp;-&nbsp;Operating</tt></font><br><font size=2 face="courier"><tt>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Bank&nbsp;Name:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;OCBC&nbsp;Bank</tt></font><br><font size=2 face="courier"><tt>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Bank-Branch&nbsp;Code:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;7339-501</tt></font><br><font size=2 face="courier"><tt>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Account&nbsp;Number:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;576789001</tt></font><br><font size=2 face="courier"><tt>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Swift&nbsp;Code:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;OCBCSGSG&nbsp;</tt></font><br><font size=2 face="courier"><tt>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Bank&nbsp;Address:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;65&nbsp;Chulia&nbsp;Street&nbsp;#01-00&nbsp;OCBC&nbsp;Centre&nbsp;Singapore&nbsp;049513</tt></font><br><font size=2 face="courier"><tt>2)&nbsp;Please&nbsp;quote&nbsp;our&nbsp;invoice&nbsp;number&nbsp;as&nbsp;reference&nbsp;when&nbsp;making&nbsp;payment</tt></font><br><font size=2 face="courier"><tt>3)&nbsp;For&nbsp;cheque&nbsp;payment,&nbsp;the&nbsp;cheques&nbsp;should&nbsp;be&nbsp;crossed&nbsp;and&nbsp;made&nbsp;payable&nbsp;to&nbsp;&quot;Republic&nbsp;Polytechnic&quot;.</tt></font><br><font size=2 face="courier"><tt>4)&nbsp;Please&nbsp;do&nbsp;not&nbsp;issue&nbsp;&quot;Cash&quot;&nbsp;cheque.&nbsp;No&nbsp;receipt&nbsp;will&nbsp;be&nbsp;issued&nbsp;for&nbsp;TT/IBG/cheque&nbsp;payment</tt></font><br><font size=2 face="courier"><tt>5)&nbsp;Please&nbsp;contact&nbsp;Ms&nbsp;Shane&nbsp;Siau&nbsp;at&nbsp;31001978&nbsp;or&nbsp;email&nbsp;shane_siau@rp.sg&nbsp;or&nbsp;help-finance@rp.edu.sg&nbsp;if&nbsp;you&nbsp;need any&nbsp;clarification.</tt></font><br><font size=2 face="courier"><tt>6)&nbsp;The&nbsp;GST&nbsp;on&nbsp;the&nbsp;invoice&nbsp;refers&nbsp;to&nbsp;Goods&nbsp;and&nbsp;Services&nbsp;Tax&nbsp;for&nbsp;7%&nbsp;unless&nbsp;otherwise&nbsp;stated&nbsp;on&nbsp;the&nbsp;invoice&nbsp; line(s).</tt></font><br><font size=2 face="courier"><tt>7)&nbsp;This&nbsp;is&nbsp;a&nbsp;computer&nbsp;generated&nbsp;invoice,&nbsp;no&nbsp;signature&nbsp;is&nbsp;required.&nbsp;Please&nbsp;note&nbsp;that&nbsp;this&nbsp;invoice&nbsp;is&nbsp; &quot;ORIGINAL&quot;,&nbsp;no&nbsp;hardcopy&nbsp;will&nbsp;be&nbsp;issued.</tt></font><br><font size=2 face="courier"><tt>E.&nbsp;&amp;&nbsp;O.E</tt></font><br></td>
  <td colspan=2></td>
</tr>
<tr valign=top>
  <td height=9 colspan=9></td>
  <td colspan=2></td>
</tr>
<tr valign=top>
  <td height=9 colspan=9></td>
  <td colspan=2></td>
</tr>
<tr valign=top>
  <td height=9 colspan=9></td>
  <td colspan=2></td>
</tr>
<tr valign=top>
  <td height=9 colspan=9></td>
  <td colspan=2></td>
</tr>
<tr valign=top>
  <td height=9 colspan=9></td>
  <td colspan=2></td>
</tr>
<tr valign=top>
  <td height=9 colspan=9></td>
  <td colspan=2></td>
</tr>
<tr valign=top>
  <td height=9 colspan=9></td>
  <td colspan=2></td>
</tr>
<tr valign=top>
  <td height=9 colspan=9></td>
  <td colspan=2></td>
</tr>
<tr valign=top>
  <td height=9 colspan=9></td>
  <td colspan=2></td>
</tr>
<tr valign=top>
  <td height=9 colspan=9></td>
  <td colspan=2></td>
</tr>
<tr valign=top>
  <td height=9 colspan=9></td>
  <td colspan=2></td>
</tr>
<tr valign=top>
  <td height=9 colspan=9></td>
  <td colspan=2></td>
</tr>
<tr valign=top>
  <td height=9 colspan=9></td>
  <td colspan=2></td>
</tr>
<tr valign=top>
  <td height=9 colspan=9></td>
  <td colspan=2></td>
</tr>
<tr valign=top>
  <td height=9 colspan=9></td>
  <td colspan=2></td>
</tr>
<tr valign=top>
  <td height=9 colspan=9></td>
  <td colspan=2></td>
</tr>
<tr valign=top>
  <td height=9 colspan=9></td>
  <td colspan=2></td>
</tr>
<tr valign=top>
  <td height=9 colspan=9></td>
  <td colspan=2></td>
</tr>
<tr valign=top>
  <td height=9 colspan=9></td>
  <td colspan=2></td>
</tr>
<tr valign=top>
  <td height=9 colspan=9></td>
  <td colspan=2></td>
</tr>
<tr valign=top>
  <td height=9 colspan=9></td>
  <td colspan=2></td>
</tr>
<tr valign=top>
  <td height=9 colspan=9></td>
  <td colspan=2></td>
</tr>
<tr valign=top>
  <td height=9 colspan=9></td>
  <td colspan=2></td>
</tr>
<tr valign=top>
  <td height=9 colspan=9></td>
  <td colspan=2></td>
</tr>
<tr valign=top>
  <td height=9 colspan=9></td>
  <td colspan=2></td>
</tr>
<tr valign=top>
  <td height=9 colspan=9></td>
  <td colspan=2></td>
</tr>
</table>
<hr size=5 noshade>
Rgds,
Nagendra 
Edited by: 838961 on Jan 4, 2012 12:53 AM

Edited by: 838961 on Jan 4, 2012 12:54 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 1 2012
Added on Jan 4 2012
#11g, #pl-sql, #sql
2 comments
676 views