Thursday 22 August 2013

Customer Credit Limits API in Oracle Apps

DECLARE
l_cust_prof_amt_rec    hz_customer_profile_v2pub.cust_profile_amt_rec_type;
l_version_num          number;
BEGIN        
l_cust_prof_amt_rec.cust_acct_profile_amt_id :=hz_cust_profile_amts.cust_acct_profile_amt_id;
l_cust_prof_amt_rec.trx_credit_limit := 0;                                                
l_cust_prof_amt_rec.overall_credit_limit :=1000;
l_version_num := l_cbd_rec (l_cbd).object_version_number;                      
                      hz_customer_profile_v2pub.update_cust_profile_amt
                                                      ('T',
                                                       l_cust_prof_amt_rec,
                                                       l_version_num,
                                                       l_return_status,
                                                       l_msg_count,
                                                       l_msg_data
                                                       );
END;   
Posted by at

7 comments:

  1. Unknown30 January 2014 at 01:52

    Hi Anil,

    I am using the above API to update the customers credit limit , initially i updated both trx_credit_limit and overall_credit_limit to a certain value, now my functional guy want me to replace the overall_credit_limit value to NULL thru the API, but wen i am passing NULL its not getting updated.

    Can you please suggest me on this.

    Thanks
    Deepthi ( GE Oil& Gas Company)

    ReplyDelete
    Replies
    1. Unknown23 March 2017 at 03:06

      Use FND_API.G_MISS_NUM instead of null. It worked for me.

      Delete
  2. Anil M30 January 2014 at 01:58

    Deepthi ,

    I think API won't update with null.Can you try with 0 instead of null.

    Anil

    ReplyDelete
  3. Unknown1 October 2014 at 06:34

    super...i liked that...thank you so much..


    FCA regulation

    ReplyDelete
  4. Prad18 November 2014 at 06:46

    Hi Anil,

    I have requirement to delete the trx credit limit and overall credit limit amounts, also I need to create script for creation and updation of these amounts.

    Could you please suggest if the deletion is possible with above API or through any other way?

    Regards,
    Pradeep

    ReplyDelete
  5. sreenivas20 January 2015 at 23:48

    I Got same issue from my User, how to make all the customers total credit and availabe credit limit to ZERO for particular organization ex 108. Please can some one send me step by step process to my mail vaasu.it@gmail.com

    ReplyDelete
  6. Best4 February 2022 at 03:59

    Since there are already better alternative to merchant account providers, business proprietors must now be responsible enough when managing their finances. North American Bancard Sales Partner

    ReplyDelete

Subscribe to: Post Comments (Atom)