Sunday, December 29, 2013
API to validate a IBAN in Oracle Apps R12 - CE_BANK_AND_ACCOUNT_VALIDATION
In this post, I tried to give a sample execution script for the private API CE_BANK_AND_ACCOUNT_VALIDATION.VALIDATE_IBAN
It can be used to validate whether the given
bank account number is an IBAN number or not. It was very helpful for us in the
current project. Hence, thought to share.
SCRIPT:
SET SERVEROUTPUT ON:
DECLARE
lv_iban_out VARCHAR2 (200);
lv_return_status VARCHAR2 (200);
p_account_no VARCHAR2 (35) DEFAULT 'FI1234567890123';
BEGIN
ce_bank_and_account_validation.validate_iban
(p_iban => p_account_no,
p_iban_out => lv_iban_out,
x_return_status => lv_return_status
);
IF
lv_return_status = 'S'
THEN
DBMS_OUTPUT.put_line ('Bank
Account Type : IBAN');
ELSE
DBMS_OUTPUT.put_line ('Bank
Account is not a IBAN number');
END IF;
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.put_line ('Error
: ' || SQLERRM);
END;
Do you think this Article is useful?
Subscribe to:
Post Comments (Atom)
0 Responses to “API to validate a IBAN in Oracle Apps R12 - CE_BANK_AND_ACCOUNT_VALIDATION”
Post a Comment