AP invoice payment api in r12

AP invoice payment api in r12

In this post , We will be discuss about the AP invoice payment api in r12. This API will be create the AP Payments in oracle apps r12. One thing i will clear from the beginning , this is not an Standard Oracle provided AP Invoice payment api but this api is created by our side. This is an custom payment api in r12 m which helps to make the payment in oracle r12. To create the AP invoice payment api , we have took an example of Standard Invoice creation api. We have used the complete Standard Invoice creation api to create this custom Payment api but we did some changes in this api for ap invoice payments creation. Here below , i will try to share the complete working of AP invoice payment api in r12.

How to Developed the  AP invoice payment api in r12

Step 1 :- You have to open the Standard API ap_pay_single_invoice_pkg.ap_pay_invoice_in_full .

Step 2:- Copy the code from this standard Package ap_pay_single_invoice_pkg.ap_pay_invoice_in_full .

Step3:- After Copying , we need to create new custom Package with our custom name.

xx_Payment_creation_api.ap_pay_invoice_in_full

We need to do one small change in this custom api as below.

if l_next_check_number is null and l_seq_num_profile in ('P') and p_doc_category_code is null then

      l_next_check_number := -1;

end if;

Actual working of AP invoice payment api in r12

xx_Payment_creation_api.ap_pay_invoice_in_full (

            p_api_version           => 1.0,

            p_init_msg_list         => fnd_api.g_true,

            p_invoice_id            => l_invoice_id,

            p_payment_type_flag     => 'A',

            p_internal_bank_acct_id => l_bank_account_id,

            p_payment_method_code   => l_payment_method_code,

            p_payment_profile_id    => l_payment_profile_id,

            p_payment_document_id   => null,

            p_take_discount         => 'N',

            p_check_date            => trunc(sysdate),

            p_doc_category_code     => null,

            p_exchange_rate_type    => null,

            p_exchange_rate         => null,

            p_exchange_date         => null,

            x_return_status         => l_return_status,

            x_msg_count             => l_msg_count,

            x_msg_data              => l_msg_data,

            x_errorids              => l_error_ids

        );