Script to Create AR Invoice using API

Validations in AR Invoice:

AR Transaction Type Validation :                                                                                  
Check if the Transaction type provided in data file is defined in AR transaction types(RA_CUST_TRX_TYPES_ALL)

Transaction Batch Source Validation:                                                                         
Check if the source provided in data file is defined in AR transaction Batch source (RA_BATCH_SOURCES_ALL).

Invoice Currency Validation:                                                                                         
Check if the currency provided in data file is defined in AR Currency (FND_CURRENCIES).

Customer Validation:                                                                                                   
Check if the Bill to Customer Number Ship to Customer Number Bill to Custom Location Ship to Customer Location provided in the data file is defined in AR Customer(ra_customers).

Primary Sales Representative Validation:                                                                   
Sales representative number to be hardcode to -3 for No Sales Credit.

Term Name :                                                                                                                    
 Check if the Term name provided in the data file is defined in Payment terms (RA_TERMS)

Validate Sales Credit Type :                                                                                            
Sales Credit to hardcode to Quota Sales Credit

Inventory Item Validation:                                                                                              
 Check if the Item provided in data file is defined in Inventory Items (MTL_SYSTEM_ITEMS).

Unit of Measurement validation:                                                                                 
 Check if the UOM provided is defined in MTL_UNITS_OF_MEASURE Table

Invoice Tax Code Validation :                                                                                     
 Check if the Tax Code provided in data file is defined in AR_VAT_TAX_ALL_B Table.

Invoice GL Date Validation :                                                                                            
Check if the GL Data of provided invoices is in open period.Used ARP_UTIL.IS_GL_DATE_VALID API to validate.

Example Program:
CREATE OR REPLACE procedure APPS.xx_ar_invoice_api

is

        l_return_status         varchar2(1);

        l_msg_count             number;

        l_msg_data              varchar2(2000);

l_batch_source_rec     ar_invoice_api_pub.batch_source_rec_type;

l_trx_header_tbl        ar_invoice_api_pub.trx_header_tbl_type;

l_trx_lines_tbl         ar_invoice_api_pub.trx_line_tbl_type;

l_trx_dist_tbl          ar_invoice_api_pub.trx_dist_tbl_type;

l_trx_salescredits_tbl                                             ar_invoice_api_pub.trx_salescredits_tbl_type;

l_cust_trx_id           number;

BEGIN

       

 begin

  MO_GLOBAL.SET_POLICY_CONTEXT('S',82);

end;

       

  fnd_global.apps_initialize(1090,20678,222);

  l_batch_source_rec.batch_source_id :=  1001;

  l_trx_header_tbl(1).trx_header_id  :=  9898;

  l_trx_header_tbl(1).trx_date       :=  sysdate;

  l_trx_header_tbl(1).trx_currency   :=  'AED';

  l_trx_header_tbl(1).cust_trx_type_id :=  1000;

  l_trx_header_tbl(1).bill_to_customer_id :=  1139;

  l_trx_header_tbl(1).term_id    :=  1000;

  l_trx_header_tbl(1).finance_charges  :=  'N';

  l_trx_header_tbl(1).status_trx   :=  'OP';

  l_trx_header_tbl(1).printing_option :=  'NOT';

  --l_trx_header_tbl(1).reference_number :=  '1111';

  l_trx_lines_tbl(1).trx_header_id :=  9898;

  l_trx_lines_tbl(1).trx_line_id   :=  101;

  l_trx_lines_tbl(1).line_number   :=  1;

  l_trx_lines_tbl(1).inventory_item_id  :=  1185;

  -- l_trx_lines_tbl(1).description :=  'CAST IRON 
                                             GRILL-325*485MM';

 l_trx_lines_tbl(1).quantity_invoiced   :=  3;

 l_trx_lines_tbl(1).unit_selling_price :=  525;   --Price

 l_trx_lines_tbl(1).uom_code    :=  'EAC';

 l_trx_lines_tbl(1).line_type   :=  'LINE';

 l_trx_dist_tbl(1).trx_dist_id  :=  101;

 l_trx_dist_tbl(1).trx_line_id  :=  101;

 l_trx_dist_tbl(1).ACCOUNT_CLASS := 'REV';

 l_trx_dist_tbl(1).percent     := 100;

 l_trx_dist_tbl(1).CODE_COMBINATION_ID := 1012;

       

--Here we call the API to create Invoice with the stored values

    AR_INVOICE_API_PUB.create_invoice

    (p_api_version          => 1.0

    --,p_commit               => 'T'

    ,p_batch_source_rec     => l_batch_source_rec

    ,p_trx_header_tbl       => l_trx_header_tbl

    ,p_trx_lines_tbl        => l_trx_lines_tbl

    ,p_trx_dist_tbl         => l_trx_dist_tbl

    ,p_trx_salescredits_tbl => l_trx_salescredits_tbl

    ,x_return_status        => l_return_status

    ,x_msg_count            => l_msg_count

    ,x_msg_data             => l_msg_data

    );

   

    dbms_output.put_line('Created:'||l_msg_data||l_return_status);

    IF l_return_status = fnd_api.g_ret_sts_error OR

       l_return_status = fnd_api.g_ret_sts_unexp_error THEN

        dbms_output.put_line(l_return_status||':'||sqlerrm);

    Else

        dbms_output.put_line(l_return_status||':'||sqlerrm);

        If (ar_invoice_api_pub.g_api_outputs.batch_id IS NOT NULL) Then

            Dbms_output.put_line('Invoice(s) suceessfully created!') ;

            Dbms_output.put_line('Batch ID: ' || ar_invoice_api_pub.g_api_outputs.batch_id);

            Dbms_output.put_line('customer_trx_id: ' || l_cust_trx_id);

        Else

            Dbms_output.put_line(sqlerrm);

        End If;

    end if;

    commit;

End;