OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » Customer API error

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

Customer API error [message #301004]

Mon, 18 February 2008 23:56

suraj_an
Messages: 15
Registered: February 2008

Junior Member

Hi

I am using hz_cust_account_v2pub.create_cust_account to create a new customer of type organization... The anonymous block compiles but does not create an account (the api description says if party does not exist, the api will create a party record in addition to the customer account record). What s the problem?

DECLARE
lr_cust_acc_rec HZ_CUST_ACCOUNT_V2PUB.CUST_ACCOUNT_REC_TYPE;
lr_org_rec HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE;
p_customer_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;
x_cust_account_id NUMBER;
x_account_number VARCHAR2(2000);
x_party_id NUMBER;
x_party_number VARCHAR2(2000);
x_profile_id NUMBER;
x_return_status VARCHAR2(2000);
x_msg_count NUMBER;
x_msg_data VARCHAR2(2000);

BEGIN

hz_cust_account_v2pub.create_cust_account( 'T', lr_cust_acc_rec, lr_org_rec,
p_customer_profile_rec, 'F', x_cust_account_id, x_account_number, x_party_id,
x_party_number,
x_profile_id,
x_return_status,
x_msg_count,
x_msg_data);

end;

Report message to a moderator