Bank Assignments for Customer

Hi Gurus,

I am using APIs to assign bank account number to customers,But API is neither returning any error message not its generating assignment id.

Please find sample code below used by me in my customer interface.Please help on this.

Please share sample code if any one has used it in his/her project.That will be a great help.

PROCEDURE assign_bank_acct (
      p_cust_rec        IN       cust_main%ROWTYPE,
      p_bank_acct_id    IN       NUMBER,
      p_party_id        IN       NUMBER,
      p_party_site_id   IN       NUMBER,
      p_cust_site_id    IN       NUMBER,
      x_assg_id         OUT      NUMBER,