Script to create AR Credit Memo using API

Credit Memo Creation API::

To create a credit memo directly, without sending a request through the workflow approval process, set the p_skip_workflow_flag parameter to Y.  you might also have to set values for its associated parameters: p_credit_method_installments,  p_credit_method_rules, and p_batch_source_name.
You cannot use the Credit Memo Approval and Creation API to generate on-account credit memos. You must specify an existing transaction to credit.
You must define three HTML pages that Before using the create API.
AR_CREDIT_MEMO_API_PUB.Create_Request

Objective:
To create a credit memo request.
Parameters entered:
customer_trx_id = 99999
line_credit_flag = N
line_amount = -100
cm_reason_code = RETURN


Call to the API:
AR_CREDIT_MEMO_API_PUB.Create_Request(
x_return_status => p_return_status,
x_msg_count => p_msg_count,
x_msg_data => p_msg_data ,
CREDIT MEMO REQUEST PARAMETERS:
p_customer_trx_id => 99999,
p_line_credit_flag => 'N',
p_line_amount => -100,
p_cm_reason_code => 'RETURN',
p_request_url =>
'arw_single_trx.single_trx_page?p1=19769&p2=1&wf=Y',
p_transaction_url =>
'arw_single_trx.single_trx_page?p1=19769&p2=1&wf=Y'
p_trans_act_url =>
'arw_single_trx.single_act_page?p1=19769&p2=1&wf=Y'
x_request_id => p_request_id  );

AR_CREDIT_MEMO_API_PUB.Get_Request_Status
To get the status of the credit memo request.
Parameters entered:
request_id = 122
Call to the API:
AR_CREDIT_MEMO_API_PUB.Get_Request_Status(
p_api_version => 1.0,
x_msg_count => msg_count ,
x_msg_data => msg_data,
x_return_status => return_status,
p_request_id => request_id,
x_status_meaning => status_meaning,
x_reason_meaning => reason_meaning,
x_customer_trx_id => customer_trx_id,
x_cm_customer_trx_id => cm_customer_trx_id,
x_line_amount => line_amount,
x_tax_amount => tax_amount,
x_freight_amount => freight_amount,
x_line_credits_flag => line_credits_flag,
x_created_by => created_by,
x_creation_date => creation_date,
x_cm_line_tbl => cm_line_tbl,
x_cm_activity_tbl => cm_activity_tbl,
x_cm_notes_tbl => cm_notes_tbl);

Credit Memo Application API ::
 
The Credit Memo Application API enables the following business actions:
• Application of an on-account memo to the Electronic Refund activity, resulting in subsequent refund of the credit memo to the customer.
To apply or unapply an on-account credit memo to an activity, call the following APIs:
• ar_cm_application_pub.activity_application   Applies an on-account credit memo to an activity.
• ar_cm_application_pub.activity_unapplication,  Unapplies an on-account credit memo from an activity.
ar_cm_application_pub.activity_application
Use this routine to apply an on-account credit memo to an activity, such as Electronic Refund. The API returns the receivable_application_id of the receivable_application created.

Ar_cm_application_pub.activity_application(
p_api_version => 1.0,
p_init_msg_list => FND_API.G_TRUE,
p_customer_trx_id => 1001,
p_amount_applied => 100,
p_applied_payment_schedule_id => 1071,
p_receivables_trx_id => 1089,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_application_ref_type => l_application_ref_type,
p_application_ref_id => l_application_ref_id,
p_application_ref_num => l_application_ref_num);

ar_cm_application_pub.activity_unapplication
Call this routine to reverse an activity application on an on-account credit memo. Such applications currently include only Electronic Refunds.