Home » SQL & PL/SQL » SQL & PL/SQL » Error(80,12): PLS-00306: wrong number or types of arguments in call to 'PUT_LINE'
Error(80,12): PLS-00306: wrong number or types of arguments in call to 'PUT_LINE' [message #259371] Wed, 15 August 2007 05:40 Go to next message
aryanna
Messages: 44
Registered: July 2007
Member

please verify my package..

CREATE OR REPLACE
PACKAGE BODY "XXX" AS


PROCEDURE extract_file
(
ERRBUF OUT NOCOPY VARCHAR2,
RETCODE OUT NOCOPY VARCHAR2,
p_file_name IN VARCHAR2

)IS

ctOut_File_Supp UTL_FILE.FILE_TYPE;

Cursor cur_supplier IS
SELECT
pv.segment1 supplier_code,
pv.vendor_name,
pv.vendor_type_lookup_code,
LC_TYPE.DISPLAYED_FIELD Supplier_Type,
pvs.vendor_site_code,
hr.ORGANIZATION_ID,
pvs.ADDRESS_LINE1,
pvs.ADDRESS_LINE2,
pvs.ADDRESS_LINE3,
pvs.ADDRESS_LINE4,
pvs.CITY,
pvs.STATE,
pvs.ZIP,
pvc.LAST_NAME,
pvc.FIRST_NAME,
apt.NAME,
aplc.DISPLAYED_FIELD Payment_Method
from
po_vendors pv,
po_vendor_sites pvs,
HR_ORGANIZATION_UNITS hr,
PO_LOOKUP_CODES LC_TYPE,
PO_VENDOR_CONTACTS pvc,
AP_TERMS_TL apt,
AP_LOOKUP_CODES aplc
where
pv.VENDOR_ID=pvs.VENDOR_ID
and pvs.ORG_ID=hr.ORGANIZATION_ID
and pv.vendor_type_lookup_code=LC_TYPE.LOOKUP_CODE
and LC_TYPE.LOOKUP_TYPE='VENDOR TYPE'
and pvs.VENDOR_SITE_ID=pvc.VENDOR_SITE_ID
and pv.TERMS_ID=apt.TERM_ID
and aplc.LOOKUP_TYPE= 'PAYMENT METHOD'
and pvs.PAYMENT_METHOD_LOOKUP_CODE=aplc.LOOKUP_CODE;


Begin
ctOut_File_Supp := UTL_FILE.FOPEN('UTL_FILE_DIR_AP_EX', p_file_name, 'W');
IF UTL_FILE.IS_OPEN(ctOut_File_Supp) THEN

FOR cur_supp IN cur_supplier
LOOP
Fnd_File.PUT_LINE(cur_supp.supplier_code||','||
cur_supp.vendor_name||','||
cur_supp.vendor_type_lookup_code||','||
cur_supp.Supplier_Type||','||
cur_supp.vendor_site_code ||','||
cur_supp.ORGANIZATION_ID ||','||
cur_supp.ADDRESS_LINE1 ||','||
cur_supp.ADDRESS_LINE2 ||','||
cur_supp.ADDRESS_LINE3 ||','||
cur_supp.ADDRESS_LINE4 ||','||
cur_supp.CITY ||','||
cur_supp.STATE ||','||
cur_supp.ZIP ||','||
cur_supp.LAST_NAME ||','||
cur_supp.FIRST_NAME ||','||
cur_supp.NAME ||','||
cur_supp.Payment_Method);
END LOOP;

IF SQL%ROWCOUNT > 0 THEN
COMMIT;
END IF;


IF UTL_FILE.IS_OPEN(ctOut_File_Supp) THEN
FND_FILE.PUT_LINE(FND_FILE.LOG,' Creating File '|| p_file_name);
END IF;

UTL_FILE.FCLOSE(ctOut_File_Supp);
end if;

END extract_file;

END XXX;



please help me with this error..

regards
Re: Error(80,12): PLS-00306: wrong number or types of arguments in call to 'PUT_LINE' [message #259375 is a reply to message #259371] Wed, 15 August 2007 05:52 Go to previous messageGo to next message
Cthulhu
Messages: 381
Registered: September 2006
Location: UK
Senior Member
What is the definition of Fnd_File.PUT_LINE ?
Re: Error(80,12): PLS-00306: wrong number or types of arguments in call to 'PUT_LINE' [message #259377 is a reply to message #259371] Wed, 15 August 2007 06:18 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In addition,
Please read and follow How to format your posts and How to get a quick answer to your question: TIPS AND TRICKS
Make sure that lines of code do not exceed 80 or 100 characters when you format.
Please always post your Oracle version (4 decimals).

Regards
Michel
Previous Topic: Critical Query
Next Topic: Create table as select....
Goto Forum:
  


Current Time: Sun Dec 11 00:23:02 CST 2016

Total time taken to generate the page: 0.11725 seconds