add

About Me

My photo
Oracle Apps - Techno Functional consultant

Thursday, August 11

Create an Organization in oracle Customers

The below API creates a record in hz_parties table and one record in hz_organization_profiles table. Similarly you can call hz_party_v2pub.create_person to create a record in the HZ_PARTIES and one record in HZ_PERSON_PROFILES tables.



DECLARE

p_organization_rec HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE;

x_return_status VARCHAR2(2000);

x_msg_count NUMBER;

x_msg_data VARCHAR2(2000);

x_party_id NUMBER;

x_party_number VARCHAR2(2000);

x_profile_id NUMBER;

BEGIN

p_organization_rec.organization_name := ’ABC Corporation’;

p_organization_rec.created_by_module := ’TCA_EXAMPLE’;

hz_party_v2pub.create_organization (

’T’,

p_organization_rec,

x_return_status,

x_msg_count,

x_msg_data,

x_party_id,

x_party_number,

x_profile_id);

dbms_output.put_line('party id '||x_party_id);

dbms_output.put_line(SubStr(’x_return_status = ’||x_return_status,1,255));

dbms_output.put_line(’x_msg_count = ’||TO_CHAR(x_msg_count));

dbms_output.put_line(SubStr(’x_msg_data = ’||x_msg_data,1,255));

IF x_msg_count >1 THEN

FOR I IN 1..x_msg_count

LOOP

dbms_output.put_line(I||’. ’||SubStr(FND_MSG_PUB.Get(p_encoded =>FND_API.G_FALSE ), 1, 255));

END LOOP;

END IF;

END;

No comments: