API To Upload Value Set Values

DECLARE

   v_enabled_flag        VARCHAR2 (2)                  := 'Y';

   v_summary_flag        VARCHAR2 (2)                  := 'Y';

   v_start_date_active   DATE                          := SYSDATE;

   v_error_msg           VARCHAR2 (1000)               := NULL;

   v_who_type            fnd_flex_loader_apis.who_type;

Create Person using the TCA API - HZ_PARTY_V2PUB

Running the Create Person API

Name of the API: CREATE PERSON API

Base Tables Affected: HZ_PARTIES

HZ_PERSON_PROFILES

PL/SQL Procedure used: CREATE_PERSON

Package Used: HZ_PARTY_V2PUB

HZ_CUST_ACCOUNT_V2PUB

How to identify the package name and version of an API

To identify the package name of an API as compiled into the Oracle database, in SQL*Plus enter the following select statement (logged in as APPS)

SQL> SELECT text FROM all_source

WHERE name like '%user_api_name%'

  AND text like '%Header%';

(eg:HZ_CUSTOMER_ACCOUNT_PUB API)

How to Debug TCA APIs

Debug Messages (PL/SQL API)

Use the extensive debug messages to troubleshoot in case of unexpected problems. These debugging messages are useful because an API would be difficult to debug otherwise. User can turn on debug messages with a certain profile option. These messages can be written to a log file as well.

Introduction to Trading Community Architecture (TCA) APIs

The TCA API is an integrated set of code designed in a highly modular fashion, resulting in codes that are easy to understand, maintain and extend.

The modular approach defaults and validates users who enter information; default information not provided by the user and calls the appropriate entity handler to perform the business related tasks.

Oracle Apps Change PO API Training

Following are the steps required in order to use the Change PO API to update a Standard Purchase order?

Login to the application

Navigate to the Purchase Order form and create a PO with a single line with quantity = 10, price = 1 and promised date = 31-MAR-2012 (use any date in the future as long as it is in an open period).