| Ar_Receipt_Api_Pub.Create_cash Error [message #180890] |
Wed, 05 July 2006 14:05  |
mchittib
Messages: 87
Registered: September 2005
|
Member |
|
|
Hi there,
I am trying to populate the DFF(just attribute6,7,8) using receipt api.
I am getting the following error.
Ar_Receipt_Api_Pub.Create_cash
*
ERROR at line 24:
ORA-06550: line 24, column 1:
PLS-00306: wrong number or types of arguments in call to 'CREATE_CASH'
ORA-06550: line 24, column 1:
PL/SQL: Statement ignored
Can someone tell me what am i doing wrong.
Declare
.....
l_attrib Ar_Receipt_Api_Pub.attribute_rec_type;
.......
Begin
.....
l_attrib.attribute6 :='Test6';
l_attrib.attribute7 :='Test7';
l_attrib.attribute8 :='Test8';
.....
Ar_Receipt_Api_Pub.Create_cash(
p_api_version => 1.0,
p_init_msg_list => Fnd_Api.g_true,
p_commit => Fnd_Api.g_true,
p_validation_level => Fnd_Api.g_valid_level_full,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_currency_code => 'USD',
p_amount => 69.16,
p_receipt_number => '1188',
p_receipt_date => SYSDATE,
p_gl_date => SYSDATE,
p_customer_number => 1248,
p_deposit_date => SYSDATE,
p_receipt_method_id => 1001,
p_cr_id => l_cash_receipt_id,
p_attribute_record => l_attrib,
p_comments => 'Test'
);
........
End;
Do i need to populate attribute1 through attribute5 with nulls?
Anyhelp or comments is greatly appreciated.
Thanks,
mchittib.
[Updated on: Wed, 05 July 2006 14:09] Report message to a moderator |
|
|
|
| Re: Ar_Receipt_Api_Pub.Create_cash Error [message #180919 is a reply to message #180890] |
Wed, 05 July 2006 16:37  |
Art Metzer
Messages: 2480
Registered: December 2002
|
Senior Member |
|
|
It's probably because the parameter is named instead of A lesser infraction: p_customer_number is a VARCHAR2 (not a NUMBER), so technically, you should probably have:p_customer_number => '1248', l_return_status VARCHAR2(1);
l_msg_count NUMBER;
l_msg_data VARCHAR2(2000); |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
