Update Customer Credit Card API in Oracle Apps R12

DECLARE

   x_return_status     VARCHAR2 (1000);

   x_msg_count         NUMBER;

   x_msg_data          VARCHAR2 (4000);

   x_card_id           NUMBER;

   x_msg_data_out      VARCHAR2 (240);

   x_mesg              VARCHAR2 (240);

   x_count             NUMBER;

   x_response          iby_fndcpt_common_pub.result_rec_type;

   l_card_instrument   iby_fndcpt_setup_pub.creditcard_rec_type;

   v_context           VARCHAR2 (10);

   p_init_msg_list     varchar2(50);

   p_commit            varchar2(50);

   l_msg_index_out          NUMBER;

   l_error_message          VARCHAR2 (100);

BEGIN

     l_card_instrument.card_id          :='&card_id';                           

     l_card_instrument.expiration_date :=to_date('12/23/2018','mm/dd/yyyy');   

                   

     

     IBY_FNDCPT_SETUP_PUB.UPDATE_CARD

                       (p_api_version          => 1.0,

                        x_return_status        => x_return_status,

                        x_msg_count            => x_msg_count,

                        x_msg_data             => x_msg_data,

                        p_card_instrument      => l_card_instrument,

                        x_response             => x_response,

                        p_init_msg_list        => fnd_api.g_false,

                        p_commit               => fnd_api.g_true

                        );

        DBMS_OUTPUT.put_line ('output information');

        DBMS_OUTPUT.put_line ('x_msg_count = ' || x_msg_count);

        DBMS_OUTPUT.put_line ('x_return_status = ' || x_return_status);

     IF x_msg_count > 0 THEN

         FOR i IN 1 .. x_msg_count

         LOOP

            apps.fnd_msg_pub.get (p_msg_index          => i,

                                  p_encoded            => fnd_api.g_false,

                                  p_data               => x_msg_data,

                                  p_msg_index_out      => l_msg_index_out

                                 );

         END LOOP;

         IF l_error_message IS NULL

         THEN

            l_error_message := SUBSTR (x_msg_data, 1, 250);

         ELSE

            l_error_message :=

                       l_error_message || ' /' || SUBSTR (x_msg_data, 1, 250);

         END IF;

         DBMS_OUTPUT.put_line ('*****************************************');

         DBMS_OUTPUT.put_line ('API Error : ' || l_error_message);

         DBMS_OUTPUT.put_line ('*****************************************');

      END IF;

END;

Programmatically Close Purchase Order using PO_ACTIONS API

DECLARE
   x_action         CONSTANT VARCHAR2 (20)  := 'FINALLY CLOSE';
   -- Change this parameter as per the requirement
   x_calling_mode   CONSTANT VARCHAR2 (2)   := 'PO';
   x_conc_flag      CONSTANT VARCHAR2 (1)   := 'N';
   x_return_code_h           VARCHAR2 (100);
   x_auto_close     CONSTANT VARCHAR2 (1)   := 'N';
   x_origin_doc_id           NUMBER;
   x_returned                BOOLEAN        := NULL;

BEGIN
 
   apps.mo_global.set_policy_context ('S', 204);
   fnd_global.apps_initialize (1015932, 50578, 201);
   DBMS_OUTPUT.put_line
             ('Calling PO_Actions.close_po for Closing/Finally Closing PO =>');
   x_returned :=
      po_actions.close_po (p_docid              => 131583,
                           p_doctyp             => 'PO',
                           p_docsubtyp          => 'STANDARD',
                           p_lineid             => NULL,
                           p_shipid             => NULL,
                           p_action             => x_action,
                           p_reason             => NULL,
                           p_calling_mode       => x_calling_mode,
                           p_conc_flag          => x_conc_flag,
                           p_return_code        => x_return_code_h,
                           p_auto_close         => x_auto_close,
                           p_action_date        => SYSDATE,
                           p_origin_doc_id      => NULL
                          );
   COMMIT;

   IF x_returned = TRUE
   THEN
      DBMS_OUTPUT.put_line
                   ('Purchase Order which just got Closed to Finally Closed. ');
      DBMS_OUTPUT.put_line (x_return_code_h);

   ELSE
      DBMS_OUTPUT.put_line
                      ('API Failed to Close/Finally Close the Purchase Order');
   END IF;

BLANKET SALES AGREEMENT IN ORACLE APPS API

Create or Replace procedure mutl_blanket_update
is
 
  -- Input variables

   l_hdr_rec             OE_Blanket_PUB.header_rec_type;
   l_hdr_val_rec         OE_Blanket_PUB.Header_Val_Rec_Type;
   l_line_tbl               OE_Blanket_PUB.line_tbl_Type;
   l_line_val_tbl           OE_Blanket_PUB.line_Val_tbl_Type;
   l_line_rec               OE_Blanket_PUB.line_rec_Type;
   l_line_val_rec           OE_Blanket_PUB.line_val_rec_Type;
   l_control_rec            OE_Blanket_PUB.Control_rec_type;
 
 -- Output Variables

   x_header_rec             OE_Blanket_PUB.header_rec_type;
   x_line_tbl                OE_Blanket_PUB.line_tbl_Type;
   x_return_status          VARCHAR2(1000);
   x_msg_count              NUMBER;
   x_msg_data               VARCHAR2(4000);
 
   l_msg_index_out      NUMBER;
   l_error_message      VARCHAR2 (100);

begin
   
    l_line_rec.order_number:='351015';
    l_line_rec.header_id :=5903558;
    l_line_rec.attribute9:='TEST';
 
    OE_Blanket_PUB.Process_Blanket(

p_org_id             => 1

,p_operating_unit     => NULL

,p_api_version_number => 1.0

,x_return_status      => x_return_status

,x_msg_count          => x_msg_count

,x_msg_data           => x_msg_data

,p_header_rec         => l_hdr_rec

,p_header_val_rec     => l_hdr_val_rec

,p_line_tbl           => l_line_tbl

,p_line_val_tbl       => l_line_val_tbl

,p_control_rec        => l_control_rec

,x_header_rec         => x_header_rec

,x_line_tbl           => x_line_tbl
);

IF x_return_status = fnd_api.g_ret_sts_success
   THEN
      DBMS_OUTPUT.put_line ('success');
      DBMS_OUTPUT.put_line ('x_msg_count = ' || x_msg_count);
      DBMS_OUTPUT.put_line ('x_return_status = ' || x_return_status);
   ELSE
    IF x_msg_count > 0
      THEN
         FOR i IN 1 .. x_msg_count
         LOOP
            apps.fnd_msg_pub.get (p_msg_index          => i,
                                  p_encoded            => fnd_api.g_false,
                                  p_data               => x_msg_data,
                                  p_msg_index_out      => l_msg_index_out
                                 );
         END LOOP;

         IF l_error_message IS NULL
         THEN
            l_error_message := SUBSTR (x_msg_data, 1, 250);
         ELSE
            l_error_message :=
                       l_error_message || ' /' || SUBSTR (x_msg_data, 1, 250);
         END IF;

         DBMS_OUTPUT.put_line ('*****************************************');
         DBMS_OUTPUT.put_line ('API Error: ' || l_error_message);
         DBMS_OUTPUT.put_line ('*****************************************');
      END IF;
   END IF;
END;

SUPPLIER API TO UPDATE PAYMENT PRIORITY

PROCEDURE mutl_supplier_updation
   IS
      l_vendor_rec         ap_vendor_pub_pkg.r_vendor_rec_type;
      l_return_status      VARCHAR2 (10);
      l_msg_count          NUMBER;
      l_msg_data           VARCHAR2 (1000);
      l_vendor_id          NUMBER;
      l_party_id           NUMBER;
      l_payment_priority   NUMBER;
      l_supplier_name      VARCHAR2 (255);
      l_error_message      VARCHAR2 (100);
      l_msg_index_out      NUMBER;
      err_code             NUMBER;
      err_msg              VARCHAR2 (1000);

      CURSOR cur_payment
      IS
         SELECT supplier_name, vendor_id, payment_priority
           FROM xx_supplier1 where status is null;
   BEGIN
      FOR supplier_rec IN cur_payment
      LOOP
         l_supplier_name := supplier_rec.supplier_name;
         l_vendor_id := supplier_rec.vendor_id;
         l_payment_priority := supplier_rec.payment_priority;
         DBMS_OUTPUT.put_line ('supplier_name' || l_supplier_name);
         DBMS_OUTPUT.put_line ('vendor_id' || l_vendor_id);
         DBMS_OUTPUT.put_line ('payment_priority' || l_payment_priority);
         --update vendor payment priority value
         l_vendor_rec.vendor_id := l_vendor_id;
         l_vendor_rec.payment_priority := l_payment_priority;
         ap_vendor_pub_pkg.update_vendor_public
                                       (p_api_version        => 1,
                                        x_return_status      => l_return_status,
                                        x_msg_count          => l_msg_count,
                                        x_msg_data           => l_msg_data,
                                        p_vendor_rec         => l_vendor_rec,
                                        p_vendor_id          => l_vendor_rec.vendor_id
                                       );
         DBMS_OUTPUT.put_line ('return_status: ' || l_return_status);
         DBMS_OUTPUT.put_line ('msg_data: ' || l_msg_data);
     --program successful then update the status 'S'
         IF l_return_status = fnd_api.g_ret_sts_success
         THEN
            UPDATE xx_supplier1
               SET status = 'S'
             WHERE vendor_id = l_vendor_id;

            DBMS_OUTPUT.put_line ('success');
         ELSE
            IF l_msg_count > 0
            THEN
               FOR i IN 1 .. l_msg_count
               LOOP
                  apps.fnd_msg_pub.get (p_msg_index          => i,
                                        p_encoded            => fnd_api.g_false,
                                        p_data               => l_msg_data,
                                        p_msg_index_out      => l_msg_index_out
                                       );

                  ---Find Error Message
                  IF l_error_message IS NULL
                  THEN
                     l_error_message := SUBSTR (l_msg_data, 1, 250);
                  ELSE
                     l_error_message :=
                        l_error_message || ' /'
                        || SUBSTR (l_msg_data, 1, 250);
                  END IF;

                  DBMS_OUTPUT.put_line
                                  ('*****************************************');
                  DBMS_OUTPUT.put_line ('API Error: ' || l_error_message);
                  DBMS_OUTPUT.put_line
                                  ('*****************************************');
               END LOOP;

               ---update status and error message
           
                  UPDATE xx_supplier1
                     SET error_message = l_error_message,
                         status = l_return_status
                   WHERE vendor_id = l_vendor_id;
           
            END IF;
         END IF;
      END LOOP;
      ---Find the error message and error code
   EXCEPTION
      WHEN OTHERS
      THEN
         err_code := SQLCODE;
         err_msg := SUBSTR (SQLERRM, 1, 200);
         DBMS_OUTPUT.put_line (   'Error code'
                               || err_code
                               || ':'
                               || 'Error message'
                               || err_msg
                              );
   END mutl_supplier_updation;

Complete Set of Essential Oracle APIs for Developers

https://drive.google.com/open?id=1tcGq5a5GXJonsIN8r9NRLcfU3F1YjiHl

How to Use Oracle APIs Effectively: A Beginner’s Guide

https://drive.google.com/open?id=1Aot6lm7DUCRtz_FNI3H8aqft0FbSd_j1

Complete Guide to Oracle EBS APIs and Their Practical Uses

·         API To Find Sales Order's Subtotal, discount, charges and Tax (OE_OE_TOTALS_SUMMARY.ORDER_TOTALS)

·         API for Cancelling the Purchase Order (PO) Document (PO_DOCUMENT_CONTROL_PUB.CONTROL_DOCUMENT)

·         API for Deleting the category assignment to an item (INV_ITEM_CATEGORY_PUB.DELETE_CATEGORY_ASSIGNMENT)

·         API for Updating Category Assignment of an item (INV_ITEM_CATEGORY_PUB.UPDATE_CATEGORY_ASSIGNMENT)

·         API to Book a sales order (OE_ORDER_PUB.PROCESS_ORDER )

·         API to Cancel a Sales Order (OE_ORDER_PUB.PROCESS_ORDER)

·         API to Cancel an Order Line (OE_ORDER_PUB.PROCESS_ORDER)

·         API to Check Existence of an Internal Bank R12 (CE_BANK_PUB.CHECK_BANK_EXIST)

·         API to Create Item Specific UOM Conversion (INV_CONVERT.CREATE_UOM_CONVERSION)

·         API to Create a Customer Account for an existing Party TCA R12 (HZ_CUST_ACCOUNT_V2PUB.CREATE_CUST_ACCOUNT)

·         API to Create a Customer Profile TCA R12 (HZ_CUSTOMER_PROFILE_V2PUB.CREATE_CUSTOMER_PROFILE)

·         API to Create a Customer Site TCA R12 (HZ_CUST_ACCOUNT_SITE_V2PUB.CREATE_CUST_ACCT_SITE)

·         API to Create a Customer Site Use TCA R12 (HZ_CUST_ACCOUNT_SITE_V2PUB.CREATE_CUST_SITE_USE)

·         API to Create a Party Site TCA R12 (HZ_PARTY_SITE_V2PUB.CREATE_PARTY_SITE)

·         API to Create a Party Site Use TCA R12 (HZ_PARTY_SITE_V2PUB.CREATE_PARTY_SITE_USE)

·         API to Create a Phone Number (Contacts) TCA R12 (HZ_CONTACT_POINT_V2PUB.CREATE_CONTACT_POINT)

·         API to Create an Internal Bank Account in R12 CE_BANK_PUB.CREATE_BANK_ACCT

·         API to Create an Internal Bank Branch R12 (CE_BANK_PUB.CREATE_BANK_BRANCH)

·         API to Delete a Sales Order (OE_ORDER_PUB.PROCESS_ORDER )

·         API to Delete an Order Line (OE_ORDER_PUB.PROCESS_ORDER)

·         API to End Date an Internal Bank Branch in R12 - CE_BANK_PUB.SET_BANK_BRANCH_END_DATE

·         API to End Date an Internal Bank in R12 - CE_BANK_PUB.SET_BANK_END_DATE

·         API to Update Customer Address in Oracle TCA R12 (HZ_LOCATION_V2PUB.UPDATE_LOCATION)

·         API to Update Oracle Applications Password (fnd_user_pkg.updateuser)

·         API to Update Purchase Order Document (PO) (PO_CHANGE_API1_S.UPDATE_PO)

·         API to Update a Customer Account TCA R12 (HZ_CUST_ACCOUNT_V2PUB.UPDATE_CUST_ACCOUNT)

·         API to Update an Internal Bank Branch R12 (CE_BANK_PUB.UPDATE_BANK_BRANCH)

·         API to Update an Internal Bank in R12 (CE_BANK_PUB.UPDATE_BANK)

·         API to apply hold on AP invoice in R12 (AP_HOLDS_PKG.INSERT_SINGLE_HOLD)

·         API to cancel single AP invoice (AP_CANCEL_PKG.AP_CANCEL_SINGLE_INVOICE)

·         API to confirm on Order Header Status (OE_HEADER_STATUS_PUB)

·         API to confirm on Order Line Status (OE_LINE_STATUS_PUB)

·         API to create Group in TCA R12 (HZ_PARTY_V2PUB.CREATE_GROUP)

·         API to create Party and Customer Account in R12 (HZ_CUST_ACCOUNT_V2PUB.CREATE_CUST_ACCOUNT)

·         API to create a Person Type Party and Customer Account TCA R12 (HZ_CUST_ACCOUNT_V2PUB.CREATE_CUST_ACCOUNT)

·         API to create customer Addresses in TCA R12 (HZ_LOCATION_V2PUB.CREATE_LOCATION)

·         API to find AP INVOICE Status (AP_INVOICES_PKG.GET_APPROVAL_STATUS)

·         API to get combination id based on segment info (FND_FLEX_EXT.GET_COMBINATION_ID)

·         API to get open sales order quantity in oracle apps (OE_LINE_UTIL.GET_OPEN_QUANTITY)

·         API to get the concatenated segment values for a code combination id (FND_FLEX_EXT.GET_SEGS)

·         API to get the formatted contact details of a Party in oracle apps R12 (HZ_FORMAT_PHONE_V2PUB.PHONE_DISPLAY)

·         API to get the segment delimiter for the specified key flex field structure (FND_FLEX_EXT.GET_DELIMITER)

·         API to populate loc_id HZ_LOCATIONS R12 (HZ_TAX_ASSIGNMENT_V2PUB. CREATE_LOC_ASSIGNMENT )

·         API to populate the Descriptive element Value of an item ( inv_item_catalog_elem_pub.process_item_descr_elements)

·         API to release hold on AP invoice in R12 (AP_HOLDS_PKG.RELEASE_SINGLE_HOLD)

·         API to update AR Invoice Printing Details in R12 AR_INVOICE_SQL_FUNC_PUB

·         API to update AR Receipt in oracle apps R12 - AR_RECEIPT_UPDATE_API_PUB (UNIDENTIFIED to UNAPPLIED)

·         API to update a Customer Account Relationship TCA R12 (HZ_CUST_ACCOUNT_V2PUB.UPDATE_CUST_ACCT_RELATE)

·         API to update a Customer Profile TCA R12 (HZ_CUSTOMER_PROFILE_V2PUB.UPDATE_CUSTOMER_PROFILE)

·         API to update an Internal Bank Account in Oracle Apps R12 (CE_BANK_PUB.UPDATE_BANK_ACCT)

·         AR: Reversal of Receipt through API (ar_receipt_api_pub.REVERSE)

·         AR: Unapplication of a Credit Memo through API (ar_cm_api_pub.unapply_on_account)

·         AR_INVOICE_API_PUB.create_single_invoice

·         AR_RECEIPT_API_PUB - Script to Create and Apply on account a AR Receipt

·         AR_RECEIPT_API_PUB.Apply_on_account ( Script to apply a receipt on account )

·         AR_RECEIPT_API_PUB.CREATE_MISC - R12 - Create Miscellaneous Cash Receipt in Oracle Apps

·         AR_RECEIPT_API_PUB.Unapply_on_account ( Script to unapply on account a Receipt in R12)

·         Add New Line to Existing Order Using the API (OE_ORDER_PUB.PROCESS_ORDER)

·         Ar_receipt_api_pub.Apply

·         Ar_receipt_api_pub.Create_and_apply

·         Ar_receipt_api_pub.Create_cash

·         Ar_receipt_api_pub.Unapply

·         Assign Delivery Details to a Delivery through API ( WSH_DELIVERY_DETAILS_PUB.DETAIL_TO_DELIVERY )

·         Assigning Category set to Category via API in Oracle Apps (INV_ITEM_CATEGORY_PUB.CREATE_VALID_CATEGORY)

·         Assigning category to an Item using API (INV_ITEM_CATEGORY_PUB.CREATE_CATEGORY_ASSIGNMENT)

·         Autocreate Deliveries Through API WSH_DELIVERY_DETAILS_PUB.AUTOCREATE_DELIVERIES

·         CASH MANAGEMENT API'S (CE_BANK_PUB) IN ORACLE APPS R12

·         CE_BANK_PUB.CHECK_BRANCH_EXISTS - API to check existence of an Internal Bank Branch in R12

·         CE_BANK_PUB.CREATE_BANK API to Create an Internal Bank in R12

·         CE_BANK_PUB.UPDATE_BANK_BRANCH API to Update an Internal Bank Branch R12

·         Create Credit Card in Oracle Payments using API (IBY_FNDCPT_SETUP_PUB.CREATE_CARD)

·         Create Party of type Organization in Oracle TCA using API hz_party_v2pub.create_organization

·         Create a Customer Account Relationship API HZ_CUST_ACCOUNT_V2PUB.CREATE_CUST_ACCT_RELATE

·         Create and Release Pciking Batch via API (wsh_picking_batches_pub.create_batch and wsh_picking_batches_pub.Release_batch)

·         Credit Memo Creation via API ( ar_credit_memo_api_pub.create_request )

·         FND_PROGRAM : Add Concurrent Program to Request Group via API

·         FND_PROGRAM : Delete Concurrent Program Definition via API

·         FND_PROGRAM : Delete Concurrent Program Executable via API

·         FND_PROGRAM : Delete Concurrent Program Parameter via API

·         FND_PROGRAM : Register Concurrent Program parameters via API

·         FND_PROGRAM : Register Concurrent Program via API

·         FND_PROGRAM : Remove Concurrent Program from Request Group via API

·         FND_PROGRAM : Create Concurrent Executable via API

·         FND_REQUEST.SUBMIT_REQUEST in R12

·         FND_USER_PKG.CREATEUSER ( Create Applications User via PLSQL)

·         GET ONHAND QUANTITIES THROUGH API in Oracle Apps R12 (INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES)

·         Generation of a LOT number for an Inventory item via API in R12

·         How to apply invoice in detail against the receipt through api (AR_RECEIPT_API_PUB.Apply_In_Detail)

·         How to attach documents from backend? ( fnd_webattch.add_attachment )

·         How to delete a attachment from backend (fnd_attached_documents2_pkg.delete_attachments)

·         How to do UOM Conversions through api? ( inv_convert.inv_um_convert_new )

·         How to get the Description of the Item based on Item catalog group using API (invicgds.inv_get_icg_desc)

·         How to get timezone based on ZIP code? (HZ_TIMEZONE_PUB.GET_TIMEZONE_ID)

·         How to set context and profile values from backend in R12 Oracle apps

·         IBY_EXT_BANKACCT_PUB.CREATE_EXT_BANK – R12 – API to Create External Bank

·         IBY_EXT_BANKACCT_PUB.CREATE_EXT_BANK_ACCT – R12 – API to Create External Bank Account

·         IBY_EXT_BANKACCT_PUB.CREATE_EXT_BANK_BRANCH – R12 – API to Create External Bank Branch

·         IMPORT EXTERNAL BANK ACCOUNTS R12 ORACLE APPS

·         Item Categories Deletion through API in Oracle Apps (INV_ITEM_CATEGORY_PUB.DELETE_CATEGORY)

·         Item Categories Updation through API in Oracle Apps (INV_ITEM_CATEGORY_PUB.UPDATE_CATEGORY)

·         Item categories creation through API in Oracle Apps (INV_ITEM_CATEGORY_PUB.CREATE_CATEGORY)

·         Item categories in oracle apps R12

·         Item import based on Item template in R12 (insert script)

·         OE_HOLDS_PUB.APPLY_HOLDS -- Apply Hold Script

·         OE_HOLDS_PUB.RELEASE_HOLDS -- Release Holds Script

·         OE_ORDER_PUB.GET_ORDER -- API to collect existing sales order data in R12

·         OE_ORDER_PUB.PROCESS_ORDER ( Sample Script for R12)

·         OE_ORDER_PUB.PROCESS_ORDER in Oracle Apps R12

·         OE_ORDER_PUB.PROCESS_ORDER to Apply hold on a sales order

·         OE_ORDER_PUB.PROCESS_ORDER to Release a hold on sales order in R12

·         ORA-01403: no data found in Package AR_RECEIPT_API_PUB Procedure Apply

·         Picking Batch Creation Through API ( wsh_picking_batches_pub.create_batch)

·         Price List Import via API (QP_PRICE_LIST_PUB.PROCESS_PRICE_LIST) in R12

·         Script to Submit Item Import (INCOIN) using FND_REQUEST in Oracle Apps R12

·         Script to get the Quantity reserved against an sales order line in oracle apps R12 (INV_RESERVATION_PUB.QUERY_RESERVATION_OM_HDR_LINE)

·         TRADING COMMUNITY ARCHITECTURE (TCA) API’S IN R12 ORACLE APPS

·         Unassign Delivery Details from Delivery through API ( WSH_DELIVERY_DETAILS_PUB.DETAIL_TO_DELIVERY )

·         Update Order Header Details Using the API (OE_ORDER_PUB.PROCESS_ORDER)

·         hz_party_contact_v2pub.create_org_contact - API to create a Contact person for an organization in Oracle TCA.