SUPPLIER API FOR CONTACT

AP_PO_VENDORS_APIS_PKG.INSERT_NEW_VENDOR_CONTACT

Parameter for this API as given below:
P_VENDOR_SITE_ID             NUMBER                  IN     DEFAULT
P_FIRST_NAME                   VARCHAR2                IN     DEFAULT
P_LAST_NAME                    VARCHAR2                IN     DEFAULT
P_MIDDLE_NAME                VARCHAR2                IN     DEFAULT
P_PREFIX                            VARCHAR2                IN     DEFAULT
P_TITLE                              VARCHAR2                IN     DEFAULT
P_MAIL_STOP                     VARCHAR2                IN     DEFAULT
P_AREA_CODE                    VARCHAR2                IN     DEFAULT
P_PHONE                             VARCHAR2                IN     DEFAULT
P_ALT_AREA_CODE                VARCHAR2                IN     DEFAULT
P_ALT_PHONE                         VARCHAR2                IN     DEFAULT
P_FAX_AREA_CODE                VARCHAR2                IN     DEFAULT
P_FAX                                     VARCHAR2                IN     DEFAULT
P_EMAIL_ADDRESS                VARCHAR2                IN     DEFAULT
P_URL                                      VARCHAR2                IN     DEFAULT
X_VENDOR_CONTACT_ID        NUMBER                  OUT
X_STATUS                               VARCHAR2                OUT
X_EXCEPTION_MSG                VARCHAR2                OUT
P_SOURCE                               VARCHAR2                IN     DEFAULT
P_WHAT_TO_IMPORT             VARCHAR2                IN     DEFAULT
P_COMMIT_SIZE                      NUMBER                  IN     DEFAULT

SUPPLIER API FOR VENDOR SITE

AP_PO_VENDORS_APIS_PKG.INSERT_NEW_VENDOR_SITE

 Parameter for this API as given below:

P_VENDOR_SITE_CODE                VARCHAR2                IN

P_VENDOR_ID                                 NUMBER                     IN

P_ORG_ID                                          VARCHAR2                IN

P_ADDRESS_LINE1                          VARCHAR2                IN

P_ADDRESS_LINE2                          VARCHAR2                IN

P_ADDRESS_LINE3                          VARCHAR2                IN

P_ADDRESS_LINE4                          VARCHAR2                IN

P_CITY                                                VARCHAR2                IN

P_STATE                                             VARCHAR2                IN

P_ZIP                                                   VARCHAR2                IN

P_PROVINCE                                     VARCHAR2                IN

P_COUNTY                                        VARCHAR2                IN

P_COUNTRY                                     VARCHAR2                IN

P_AREA_CODE                                 VARCHAR2                IN

P_PHONE                                            VARCHAR2                IN

P_FAX_AREA_CODE                        VARCHAR2                IN

P_FAX                                                  VARCHAR2                IN

P_EMAIL_ADDRESS                          VARCHAR2                IN

P_PURCHASING_SITE_FLAG           VARCHAR2                IN     DEFAULT

P_PAY_SITE_FLAG                             VARCHAR2                IN     DEFAULT

P_RFQ_ONLY_SITE_FLAG                VARCHAR2                IN     DEFAULT

X_VENDOR_SITE_ID                          NUMBER                   OUT

X_STATUS                                            VARCHAR2               OUT

X_EXCEPTION_MSG                          VARCHAR2                OUT

P_SOURCE                                            VARCHAR2                IN     DEFAULT

P_WHAT_TO_IMPORT                       VARCHAR2                IN     DEFAULT

P_COMMIT_SIZE                                 NUMBER                    IN     DEFAULT

P_HOLD_UNVALIDATED_INV_FLAG VARCHAR2           IN     DEFAULT

P_HOLD_ALL_PAYMENTS_FLAG   VARCHAR2                IN     DEFAULT

P_DUNS_NUMBER                              VARCHAR2                IN     DEFAULT

SUPPLIER API

Procedure : AP_PO_VENDORS_APIS_PKG.INSERT_NEW_VENDOR

Parameter for this API  as given below
P_VENDOR_NAME                                     VARCHAR2                IN
P_VENDOR_TYPE_LOOKUP_CODE         VARCHAR2                IN
P_TAXPAYER_ID                                         VARCHAR2                IN                        
P_TAX_REGISTRATION_ID                       VARCHAR2                IN     
P_WOMEN_OWNED_FLAG                        VARCHAR2                IN    
P_SMALL_BUSINESS_FLAG                       VARCHAR2                IN   
P_MINORITY_GROUP_LOOKUP_CODE   VARCHAR2                IN
P_SUPPLIER_NUMBER                              NUMBER                    OUT      
X_VENDOR_ID                                           VARCHAR2                OUT            
X_STATUS                                                   VARCHAR2                OUT
X_EXCEPTION_MSG                                  VARCHAR2                IN
P_SOURCE                                                     VARCHAR2                IN
P_WHAT_TO_IMPORT                                VARCHAR2                IN
P_COMMIT_SIZE                                          VARCHAR2                IN

CUSTOMER API FOR Create a Customer A/C Site Use Code

Create a Customer A/C Site Use Code

====================================================================
DECLARE
p_cust_site_use_rec HZ_CUST_ACCOUNT_SITE_V2PUB.
CUST_SITE_USE_REC_TYPE;
p_customer_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.
CUSTOMER_PROFILE
_REC_TYPE;
x_site_use_id NUMBER;
x_return_status VARCHAR2(2000);
x_msg_count NUMBER;
x_msg_data VARCHAR2(2000);
BEGIN
p_cust_site_use_rec.cust_acct_site_id := 3580;
p_cust_site_use_rec.site_use_code := ’INV’;
p_cust_site_use_rec.location := ’TCA’;
p_cust_site_use_rec.created_by_module := ’TCA_EXAMPLE’;
hz_cust_account_site_v2pub.create_cust_site_use(
’T’,
p_cust_site_use_rec,
p_customer_profile_rec,
’’,
’’,
x_site_use_id,
x_return_status,
x_msg_count,
x_msg_data);
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;

=========================================================================

CUSTOMER API FOR Create a Cust Account Site using an Existing Party Site

Create a Cust Account Site using an Existing Party Site

=================================================

DECLARE
p_cust_acct_site_rec hz_cust_account_site_v2pub.cust_acct_site_rec_type;
x_return_status VARCHAR2(2000);
x_msg_count NUMBER;
x_msg_data VARCHAR2(2000);
x_cust_acct_site_id NUMBER;
BEGIN
p_cust_acct_site_rec.cust_account_id := 3472;
p_cust_acct_site_rec.party_site_id := 1024;
p_cust_acct_site_rec.language := ’US’;
p_cust_acct_site_rec.created_by_module := ’TCA-EXAMPLE’;
hz_cust_account_site_v2pub.create_cust_acct_site(
’T’,
p_cust_acct_site_rec,
x_cust_acct_site_id,
x_return_status,
x_msg_count,
x_msg_data);
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;

==========================================================

CUSTOMER API FOR CREATE CUSTOMER ACCOUNT

CUSTOMER API FOR CREATE CUSTOMER ACCOUNT

=======================================================================

DECLARE
p_cust_account_rec HZ_CUST_ACCOUNT_V2PUB.CUST_ACCOUNT_REC_TYPE;
p_person_rec HZ_PARTY_V2PUB.PERSON_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
p_cust_account_rec.account_name := ’John’’s A/c’;
p_cust_account_rec.created_by_module := ’TCA_EXAMPLE’;
p_person_rec.person_first_name := ’John’;
p_person_rec.person_last_name := ’Smith’;
hz_cust_account_v2pub.create_cust_account( ’T’, p_cust_account_rec, p_person_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);
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;

================================================================================= 

CUTOMER API FOR CREATE ORG CONTACT

The Below API creates a record in hz_org_contacts table and one record in hz_relationships table. When a contact is created, a record in hz_parties table gets created with party_type as 'PARTY_RELATIONSHIP'.
=============================================================

DECLARE
p_org_contact_rec HZ_PARTY_CONTACT_V2PUB.ORG_CONTACT_REC_TYPE;
x_org_contact_id NUMBER;
x_party_rel_id NUMBER;
x_party_id NUMBER;
x_party_number VARCHAR2(2000);
x_return_status VARCHAR2(2000);
x_msg_count NUMBER;
x_msg_data VARCHAR2(2000);
BEGIN
p_org_contact_rec.department_code := ’ACCOUNTING’;
p_org_contact_rec.job_title := ’ACCOUNTS OFFICER’;
p_org_contact_rec.decision_maker_flag := ’Y’;
p_org_contact_rec.job_title_code := ’APC’;
p_org_contact_rec.created_by_module := ’TCA_EXAMPLE’;
p_org_contact_rec.party_rel_rec.subject_id := 16077;
p_org_contact_rec.party_rel_rec.subject_type := ’PERSON’;
p_org_contact_rec.party_rel_rec.subject_table_name := ’HZ_PARTIES’;
p_org_contact_rec.party_rel_rec.object_id := 1272023;
p_org_contact_rec.party_rel_rec.object_type := ’ORGANIZATION’;
p_org_contact_rec.party_rel_rec.object_table_name := ’HZ_PARTIES’;
p_org_contact_rec.party_rel_rec.relationship_code := ’CONTACT_OF’;
p_org_contact_rec.party_rel_rec.relationship_type := ’CONTACT’;
p_org_contact_rec.party_rel_rec.start_date := SYSDATE;
hz_party_contact_v2pub.create_org_contact(’T’, p_org_contact_rec, x_org_contact_id,
x_party_rel_id, x_party_id, x_party_number, x_return_status, x_msg_count,
x_msg_data);
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

==========================================================

CUSTOMER API FOR CREATE CONTACT POINT

Create a Contact Point ( of type Phone)

=======================================================================

DECLARE
p_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
p_edi_rec HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;
p_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
p_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
p_telex_rec HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;
p_web_rec HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE;
x_return_status VARCHAR2(2000);
x_msg_coun t NUMBER;
x_msg_data VARCHAR2(2000);
x_contact_point_id NUMBER;
BEGIN
p_contact_point_rec.contact_point_type := ’PHONE’;
p_contact_point_rec.owner_table_name := ’HZ_PARTIES’;
p_contact_point_rec.owner_table_id := ’1272023’;
p_contact_point_rec.primary_flag := ’Y’;
p_contact_point_rec.contact_point_purpose := ’BUSINESS’;
p_phone_rec.phone_area_code := ’650’;
p_phone_rec.phone_country_code := ’1’;
p_phone_rec.phone_number := ’506-7000’;
p_phone_rec.phone_line_type := ’GEN’;
p_contact_point_rec.created_by_module := ’TCA_EXAMPLE’;
hz_contact_point_v2pub.create_contact_point( ’T’, p_contact_point_rec,
p_edi_rec, p_email_rec,
p_phone_rec,
p_telex_rec,
p_web_rec,
x_contact_point_id,
x_return_status,
x_msg_count,
x_msg_data);
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;

==================================================================================

CUSTOMER API FOR CREATE PARTY SITE USE

CUSTOMER API FOR CREATE PARTY SITE USE

======================================================================
DECLARE
p_party_site_use_rec HZ_PARTY_SITE_V2PUB.PARTY_SITE_USE_RE
C_TYPE;
x_party_site_use_id NUMBER;
x_return_status VARCHAR2(2000);
x_msg_count NUMBER;
x_msg_data VARCHAR2(2000);
BEGIN
p_party_site_use_rec.site_use_type := ’SHIP_TO’;
p_party_site_use_rec.party_site_id := 349327;
p_party_site_use_rec.created_by_module := ’TCA_EXAMPLE’;
hz_party_site_v2pub.create_party_site_use(
’T’,
p_party_site_use_rec,
x_party_site_use_id,
x_return_status,
x_msg_count,
x_msg_data);
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;

 ================================================================================

CUSTOMER API FOR CREATE PARTY SITE

Create a Party site

Use the organization_id and location_id created above and create a party site.
====================================================================
DECLARE
p_party_site_rec HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE;
x_party_site_id NUMBER;
x_party_site_number VARCHAR2(2000);
x_return_status VARCHAR2(2000);
x_msg_count NUMBER;
x_msg_data VARCHAR2(2000);
BEGIN
p_party_site_rec.party_id := 1272023;
p_party_site_rec.location_id := 359086;
p_party_site_rec.identifying_address_flag := ’Y’;
p_party_site_rec.created_by_module := ’TCA_EXAMPLE’;
hz_party_site_v2pub.create_party_site(
’T’,
p_party_site_rec,
x_party_site_id,
x_party_site_number,
x_return_status,
x_msg_count,
x_msg_data);
dbms_output.put_line('party site id '||x_party_site_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;

================================================================================ 

The above API creates a record in hz_party_sites table.

CUSTOMER API FOR CREATE LOCATION

Create a Location

=======================================================================

DECLARE
p_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE;
x_location_id NUMBER;
x_return_status VARCHAR2(2000);
x_msg_count NUMBER;
x_msg_data VARCHAR2(2000);
BEGIN
p_location_rec.country := ’US’;
p_location_rec.address1 := ’300 Oracle Parkway’;
p_location_rec.address2 := ’13th Floor’;
p_location_rec.city := ’Redwood Shores’;
p_location_rec.postal_code := ’94065’;
p_location_rec.state := ’CA’;
p_location_rec.created_by_module := ’TCA_EXAMPLE’;
hz_location_v2pub.create_location(
’T’,
p_location_rec,
x_location_id,
x_return_status,
x_msg_count,
x_msg_data);
dbms_output.put_line('location id '||x_location_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

============================================================================================

The above API shall create an address record in hz_locations table

CUSTOMER API FOR CREATE ORGANIZATION

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 := 'TCA_ORG_TEST';  
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;

Customer API

Customer related APIs

1) Org Contact Role
 Hz_party_contact_v2pub.Create_Org_Contact_Role

2) Relationships HZ_CUST_ACCOUNT_V2PUB.CREATE_CUST_ACCT_RELATE

3) Customer Profile
 HZ_CUSTOMER_PROFILE_V2PUB. create_customer_profile

4) Customer Profile Amount HZ_CUSTOMER_PROFILE_V2PUB. create_cust_profile_amt

5) Customer Credit Rating
 HZ_PARTY_INFO_V2PUB.create_credit_rating

6) Sales Person JTF_RS_SALESREPS_PUB.CREATE_SALESREP

7) Sales reps Territories
 JTF_RS_SRP_TERRITORIES_PUB.CREATE_RS_SRP_TERRITORIES

8) Customer contacts HZ_CUST_ACCOUNT_ROLE_V2PUB.CREATE_CUST_ACCOUNT_ROLE

9) Customer Contact Role
 HZ_CUST_ACCOUNT_ROLE_V2PUB.create_role_responsibility