1: PACKAGE BODY CE_BANK_AND_ACCOUNT_VALIDATION AS
2: /*$Header: cebavalb.pls 120.22.12020000.5 2013/03/28 06:20:47 anushven ship $ */
3:
4: l_DEBUG varchar2(1) := NVL(FND_PROFILE.value('CE_DEBUG'), 'N');
5: --l_DEBUG varchar2(1) := 'Y';
6:
7: /*=======================================================================+
8: | PUBLIC FUNCTION ce_check_numeric |
41:
42: /*=======================================================================+
43: | PUBLIC PROCEDURE validate_bank |
44: | This procedure should be registered as the value of the profile |
45: | option 'HZ_BANK_VALIDATION_PROCEDURE' in fnd_profile_option_values |
46: | DESCRIPTION |
47: | Dynamic bound validation routine. This procedure is called by TCA |
48: | create_bank/update_bank API. |
49: | |
202: /*=======================================================================+
203: | PUBLIC PROCEDURE validate_branch |
204: | This procedure should be registered as the value of the profile |
205: | option of 'HZ_BANK_BRANCH_VALIDATION_PROCEDURE' in |
206: | fnd_profile_option_values |
207: | |
208: | DESCRIPTION |
209: | Dynamic bound validation routine. |
210: | The validation 'the combination of country, bank name, and branch |
1384:
1385: BEGIN
1386: IF p_acct_class is not null THEN
1387: IF p_acct_class in ( 'INTERNAL', 'BOTH') THEN
1388: mask_ba_num_option := NVL(FND_PROFILE.value('CE_MASK_INTERNAL_BANK_ACCT_NUM'), 'LAST FOUR VISIBLE');
1389: ELSIF p_acct_class = 'EXTERNAL' THEN
1390: mask_ba_num_option := NVL(FND_PROFILE.value('CE_MASK_EXTERNAL_BANK_ACCT_NUM'), 'LAST FOUR VISIBLE');
1391: END IF;
1392: END IF;
1386: IF p_acct_class is not null THEN
1387: IF p_acct_class in ( 'INTERNAL', 'BOTH') THEN
1388: mask_ba_num_option := NVL(FND_PROFILE.value('CE_MASK_INTERNAL_BANK_ACCT_NUM'), 'LAST FOUR VISIBLE');
1389: ELSIF p_acct_class = 'EXTERNAL' THEN
1390: mask_ba_num_option := NVL(FND_PROFILE.value('CE_MASK_EXTERNAL_BANK_ACCT_NUM'), 'LAST FOUR VISIBLE');
1391: END IF;
1392: END IF;
1393: IF p_bank_account_num is not null THEN
1394: ba_num_length := length(p_bank_account_num);