API To Update Bank Branch Details

Oracle has provided an API to update the bank branch details:

     IBY_EXT_BANKACCT_PUB.update_ext_bank_branch (
          p_api_version                => 1.0,
          p_init_msg_list              => FND_API.G_TRUE,
          p_ext_bank_branch_rec        => l_bank_branch_rec,
          x_return_status                 => l_chr_return_status,
          x_msg_count                    => l_num_count,
          x_msg_data                     => l_msg_data,
          x_response                      => x_response_rec
                    );

l_bank_branch_rec is BANK BRANCH record type variables. The mandatory parameters to be passed to the API are as below:

bank_party_id => Bank Id
branch_party_id => Branch Id
branch_name => branch_name
branch_number => branch_number
branch_type  => branch_type
alternate_branch_name => alt branch name
bch_object_version_number ,typ_object_version_number ,rfc_object_version_number ,eft_object_version_number => Bank Branch object version number derived from iby_ext_bank_branches_v.

In case of successful Update the API will return 'S'  , In case of errors use the below code snippet to display the error messages:

FOR i IN 1 .. l_num_count
           LOOP
              fnd_msg_pub.get (
                 p_msg_index       => -1,
                 p_encoded         => 'F',
                 p_data            => l_msg_data,
                 p_msg_index_out   => l_msg_index_out);

              fnd_file.put_line(fnd_file.LOG,
                 'Error in Bank Branch Updation  ' || l_msg_data);
              l_chr_val_ret_msg :=
                 l_chr_val_ret_msg || '  ' || l_msg_data;
             
END LOOP;

Thanks