Party Site Use API

TCA Create Party Site Use API

Name of the API : CREATE PARTY SITE USE
Base Tables Affected : HZ_PARTY_SITE_USES
PL/SQL Procedure used : CREATE_PARTY_SITE_USE
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_use_rec IN PARTY_SITE_USE_REC_TYPE
x_party_site_use_id OUT NUMBER
x_return_status OUT VARCHAR2
x_msg_count OUT NUMBER

Procedure:

 General Tips for Running the Create Party Site Use API:
a) Save the API in a script file and then run the script from the SQL Prompt
(Example : RUN createpsiteuse.sql)
b) Enter the values for the Parameters Party Site Use and Party Site Id from 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 Use is created.
c) The Parameter Party Site Use can be entered in either lower case or upper
case as the system will take care of changing the case to upper. That is The Site
use can be entered as bill_to or BILL_TO or Bill_To.
d) Enter the value for Party Site Id as a valid value from HZ_PARTY_SITES table.
SELECT party_site_id FROM hz_party_sites;
e)  Set the organization id before running the script as :
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 Use API:

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

 

Leave a Reply