API to update supplier payment method in r12

API to update supplier payment method in r12

Hi friends, we are going to discuss about the api to update supplier payment method in r12. We will share the detail plsql script to update the supplier payment methods in oracle r12. We have the standard api in oracle apps r12 to maintain and update the supplier payment method details. We are using this api in our plsql script to update the supplier payment method in oracle r12. This is one of the most useful script while working on oracle r12 projects. We need to use this api script to update supplier details in r12. Please find below the complete detail about the API to update supplier payment method in r12.

API to update supplier payment method in r12

Important API to update supplier payment method in r12

iby_disbursement_setup_pub.update_external_payee

API to update supplier payment method in r12

Detail PLSQL API to update supplier payment method in r12

Here below is the complete script using the api to update the payment method of suppliers in oracle apps r12. You just need to use this , to make the changes in the supplier payment method.

API to update supplier payment method in r12

DECLARE

   x_return_status             VARCHAR2 (200) := NULL;

   x_msg_count                 NUMBER :=0;

   x_msg_data                  VARCHAR2 (200) := NULL;

   l_payee_upd_status          iby_disbursement_setup_pub.ext_payee_update_tab_type;

   p_external_payee_tab_type   iby_disbursement_setup_pub.external_payee_tab_type;

   p_ext_payee_id_tab_type     iby_disbursement_setup_pub.ext_payee_id_tab_type;

   p_ext_payee_id_rec          iby_disbursement_setup_pub.Ext_Payee_ID_Rec_Type;

   l_ext_payee_rec             IBY_DISBURSEMENT_SETUP_PUB.External_Payee_Rec_Type;

   i                           NUMBER := 0;

   g_org_id                    NUMBER := 85;

   g_user_id                   NUMBER := 3675;

   g_resp_id                   NUMBER := 20639;

   g_resp_appl_id              NUMBER := 200;

BEGIN

      fnd_global.apps_initialize (user_id        => g_user_id,

                                  resp_id        => g_resp_id,

                                  resp_appl_id   => g_resp_appl_id);

     mo_global.set_policy_context ('S',115);

     

FOR I IN C LOOP

      p_external_payee_tab_type (1).default_pmt_method := 'CHECK';

      p_external_payee_tab_type (1).payment_function := 'PAYABLES_DISB';

      p_external_payee_tab_type (1).exclusive_pay_flag := 'N';

      p_external_payee_tab_type (1).payee_party_id :=12234;

      p_external_payee_tab_type (1).Delivery_Channel:='CRDB';

      p_external_payee_tab_type (1).payer_org_id := 115;

      p_external_payee_tab_type (1).payer_org_type := 'OPERATING_UNIT';

      p_external_payee_tab_type (1).supplier_site_id :=33444;

      p_external_payee_tab_type (1).Payee_Party_Site_Id :=45555;

      p_ext_payee_id_tab_type (1).ext_payee_id :=3456;

      

      iby_disbursement_setup_pub.update_external_payee (

         p_api_version            => 1.0,

         p_init_msg_list          => 'T',

         p_ext_payee_tab          => p_external_payee_tab_type,

         p_ext_payee_id_tab       => p_ext_payee_id_tab_type,

         x_return_status          => x_return_status,

         x_msg_count              => x_msg_count,

         x_msg_data               => x_msg_data,

         x_ext_payee_status_tab   => l_payee_upd_status

      );

      COMMIT;

    --  DBMS_OUTPUT.PUT_LINE ('External Payee Update :' || j.ext_payee_id);

      DBMS_OUTPUT.PUT_LINE ('x_return_status: ' || x_return_status);

      IF x_return_status = 'E'

      THEN

         FOR k IN l_payee_upd_status.FIRST .. l_payee_upd_status.LAST

         LOOP

            DBMS_OUTPUT.put_line('Error Message from table type : '

                                 || l_payee_upd_status (k).Payee_update_Msg);

         END LOOP;

      END IF;

      COMMIT;

     END LOOP;

EXCEPTION

   WHEN OTHERS

   THEN

      DBMS_OUTPUT.PUT_LINE ('Error ' || SQLERRM);

END;

API to update supplier payment method in r12