OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » Ar_Transaction_Pub.Update

Home » Applications » Oracle Fusion Apps & E-Business Suite » Ar_Transaction_Pub.Update_Transaction (11.5.10.2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Ar_Transaction_Pub.Update_Transaction [message #327996]

Wed, 18 June 2008 10:07

mchittib
Messages: 87
Registered: September 2005

Member

Hi ,

I am trying to use Ar_Transaction_Pub.Update_Transaction to update the Invoice in AR and I am getting a message Wrong number or types of arguementsin call to 'UPDATE_TRANSACTION'. If anyone has tried this can you please help what should I do to make it work. I know api is not a public api and is intended for internal use only.

Thanks.

Please find the attached code I am using.

Quote:

DECLARE
l_msg_count NUMBER;
l_msg_data VARCHAR2(2000);
l_return_status VARCHAR2(10);
v_batch_rec ra_batches_all%ROWTYPE;
v_header_rec ra_customer_trx_all%ROWTYPE;
v_errors arp_trx_validate.Message_Tbl_Type;
v_lines_tbl ar_transaction_pub.Line_Tbl_Type;
v_tax_lines_tbl ar_transaction_pub.Line_Tbl_Type;
v_freight_lines_tbl ar_transaction_pub.Line_Tbl_Type;
v_salescredit_lines_tbl ar_transaction_pub.Salescredit_Tbl_Type;
v_dist_tbl ar_transaction_pub.Dist_Tbl_Type;
v_commitment_rec arp_process_commitment.commitment_rec_type;

BEGIN

BEGIN
Fnd_Global.apps_initialize(-1,20678,222);
END;
v_header_rec.customer_trx_id := 17291;
v_header_rec.customer_bank_account_id := NULL;
Ar_Transaction_Pub.Update_Transaction(
p_api_name => 'AR_TRANSACTION_PUB',
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,
p_batch_rec => v_batch_rec,
p_header_rec => v_header_rec,
p_receivable_gl_date => trunc(SYSDATE),
p_commitment_rec => v_commitment_rec,
p_lines_tbl => v_lines_tbl,
p_tax_lines_tbl => v_tax_lines_tbl,
p_freight_lines_tbl => v_freight_lines_tbl,
p_salescredit_lines_tbl => v_salescredit_lines_tbl,
p_dist_tbl => v_dist_tbl,
p_return_status => l_return_status ,
p_msg_count => l_msg_count,
p_msg_data => l_msg_data,
p_errors => v_errors,
p_recalc_tax_flag => FND_API.G_TRUE,
p_rerun_autoacc_flag => FND_API.G_TRUE,
p_backout_sc_flag => FND_API.G_TRUE,
p_backout_dist_flag => FND_API.G_TRUE
);

END;

Report message to a moderator

Re: Ar_Transaction_Pub.Update_Transaction [message #434410 is a reply to message #327996]

Wed, 09 December 2009 03:15

dasppartha
Messages: 1
Registered: December 2009
Location: Hyderabad

Junior Member

Make the below modifications and it will run.
Replace the declaration
v_header_rec ra_customer_trx_all%ROWTYPE;
with
v_header_rec ra_customer_trx%ROWTYPE;

Regards
Partha

Report message to a moderator

Previous Topic:	How to restrict access to sub-inventories by Responsibilities?
Next Topic:	Strange happens with notifications

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 09 22:28:25 CDT 2024