Script for to create an Internal Bank Account in Oracle Apps R12.1.1
API: CE_BANK_PUB.CREATE_BANK_ACCT
This API is used to create a bank account for the branch party id passed
as an input parameter. The API uses the BANKACCT_REC_TYPE record to pass the input
values. On successful creation of bank account, the API returns the bank account
id along with the information /error messages. The API returns a null bank account
id if the bank branch is not created.
TABLE
INVOLVED: CE_BANK_ACCOUNTS
SET SERVEROUTPUT ON;
DECLARE
p_init_msg_list VARCHAR2 (200);
p_acct_rec apps.ce_bank_pub.bankacct_rec_type;
x_acct_id NUMBER;
x_return_status VARCHAR2 (200);
x_msg_count NUMBER;
x_msg_data VARCHAR2 (200);
p_count NUMBER;
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);
DBMS_OUTPUT.put_line ('X_RETURN_STATUS
= ' || x_return_status);
DBMS_OUTPUT.put_line ('X_MSG_COUNT
= ' || x_msg_count);
DBMS_OUTPUT.put_line ('X_MSG_DATA
= ' || x_msg_data);
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;
END;
/
No comments:
Post a Comment