Create Party Site API TCA

Create Party Site API

Name of the API : CREATE PARTY SITE
Base Tables Affected : HZ_PARTY_SITES
PL/SQL Procedure used : CREATE_PARTY_SITE
Package Used : HZ_PARTY_SITE_V2PUB

Mandatory Parameters :
Parameter Name Parameter Type Data Type
p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE
p_party_site_rec IN PARTY_SITE_REC_TYPE
x_party_site_id OUT NUMBER
x_party_site_number OUT VARCHAR2
x_return_status OUT VARCHAR2
x_msg_count OUT NUMBER
x_msg_data OUT VARCHAR2

Procedure:

 General Tips for Running the Create Party Site API:

a) Save the API in a script file and then run the script from the SQL Prompt
(Example : RUN createpsite.sql)
b) Enter the values for the Parameters Party Id and Location Id from the SQL
prompt itself as hard coding these two parameters means the script has
to be changed for the value of these two parameters each time a new
Party Site is created.
c) Enter the values for Party Id and Location Id as valid values from
HZ_PARTIES and HZ_LOCATIONS respectively.
SELECT party_id FROM hz_parties;
SELECT location_id FROM hz_locations;
EXEC fnd_client_info.set_org_context(‘<orgid>’); for 11i
OR For R12
EXEC mo_global.init (‘AR’);
EXEC mo_global.set_org_context(<org_id>, NULL, ‘AR’);
EXEC fnd_global.set_nls_context(‘AMERICAN’);
EXEC mo_global.set_policy_context(‘S’, <org_id>);

Example For Running a Create Party Site API:

 Sample Output of the Create Party Site Script:

x_return_status = S
x_msg_count = 0
Party Site Id = 328654
Party Site Number = 26474
x_msg_data =

Script To Verify whether the Create Party Site API is successful:

 

 

Related posts:

Leave a Reply