Skip to content
Welcome to World of ORACLE

Welcome to World of ORACLE

Learn Oracle World with me

  • Home
  • EBS Blogs
    • ADF Developer Guide
    • ORACLE OAF Guide
    • EBS HRMS API
    • EBS FND User API
    • EBS Payables API
    • Oracle Knowledge
    • Solution Corner
  • FUSION Blogs
    • Oracle JET
    • Audit
    • Fast Formulas
    • HDL Templates
    • Reports/ Analytics
    • Solution Corner
  • About
  • Contact
You Are Here
  • Home
  • EBS Payable Supplier API
  • Create Bank Account using API in Oracle Apps R12

Create Bank Account using API in Oracle Apps R12

DECLARE
p_count               NUMBER;
p_init_msg_list   VARCHAR2(200);
p_acct_rec           apps.ce_bank_pub.bankacct_rec_type;
x_acct_id             NUMBER;
x_msg_count      NUMBER;
x_msg_data        VARCHAR2(200);
x_return_status VARCHAR2(200);

BEGIN
p_init_msg_list := NULL;

— HZ_PARTIES.PARTY_ID BANK BRANCH
p_acct_rec.branch_id := 8056;

— HZ_PARTIES.PARTY_ID BANK
p_acct_rec.bank_id := 8042;

— HZ_PARTIES.PARTY_ID ORGANIZATION
p_acct_rec.account_owner_org_id := 23273;

— HZ_PARTIES.PARTY_ID Person related to ABOVE ORGANIZATION
p_acct_rec.account_owner_party_id := 2041;
p_acct_rec.account_classification      := ‘INTERNAL’;
p_acct_rec.bank_account_name         := ‘Test Bank Accunt’;
p_acct_rec.bank_account_num           := 14256789;
p_acct_rec.currency                                := ‘USD’;
p_acct_rec.start_date                             := SYSDATE;
p_acct_rec.end_date                              := NULL;

CE_BANK_PUB.CREATE_BANK_ACCT
( p_init_msg_list  => p_init_msg_list,
p_acct_rec            => p_acct_rec,
x_acct_id              => x_acct_id,
x_return_status  => x_return_status,
x_msg_count      => x_msg_count,
x_msg_data         => x_msg_data
);

dbms_output.put_line (‘X_ACCT_ID = ‘ || x_acct_id);

IF (x_msg_count = 1)
THEN
dbms_output.put_line (‘x_msg_data ‘ || x_msg_data);

ELSIF (x_msg_count > 1)
THEN
LOOP
p_count := p_count + 1;
x_msg_data := fnd_msg_pub.get (fnd_msg_pub.g_next,fnd_api.g_false);

IF (x_msg_data IS NULL)
THEN
EXIT;
END IF;

dbms_output.put_line (‘Message’ || p_count || ‘ —‘ || x_msg_data);
END LOOP;
END IF;

COMMIT;
EXCEPTION
WHEN OTHERS THEN
ROLLBACK;
dbms_output.put_line(SQLERRM);
END;
/

SHOW ERR;

Share this post: on Twitter on Facebook on LinkedIn

Post navigation

Create Bank Account in IBY using API in Oracle Apps R12
API to Create Party Site for Bank Branch with Location in Oracle Apps R12

Related Posts

  • Account Payable (AP) Important Tables

  • Rarely Used Account Payables APIs

  • API to Create Party Site for Bank Branch with Location in Oracle Apps R12

About Me

PRajkumar

Hi, I’m Puneet Rajkumar, an aspiring blogger with an obsession of Oracle Apps. This site is devoted to assist people to be told Oracle World.

View all posts

Follow Me

Be at liberty to hitch me on my social networks

  • facebook
  • linkedin

Visitor Count

0064985
Total Visit : 64985
Total Hits : 139944
  • Privacy Policy
  • Disclaimer
All Right Reserved 2019
Proudly powered by WordPress | Theme: Blog Cycle by Candid Themes.