DBA Data[Home] [Help]

APPS.CE_BANK_AND_ACCOUNT_VALIDATION dependencies on FND_PROFILE

Line 4: l_DEBUG varchar2(1) := NVL(FND_PROFILE.value('CE_DEBUG'), 'N');

1: PACKAGE BODY CE_BANK_AND_ACCOUNT_VALIDATION AS
2: /*$Header: cebavalb.pls 120.18.12010000.2 2009/02/06 06:33:06 talapati 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 |

Line 45: | option 'HZ_BANK_VALIDATION_PROCEDURE' in fnd_profile_option_values |

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: | |

Line 349: | fnd_profile_option_values |

345: /*=======================================================================+
346: | PUBLIC PROCEDURE validate_branch |
347: | This procedure should be registered as the value of the profile |
348: | option of 'HZ_BANK_BRANCH_VALIDATION_PROCEDURE' in |
349: | fnd_profile_option_values |
350: | |
351: | DESCRIPTION |
352: | Dynamic bound validation routine. |
353: | The validation 'the combination of country, bank name, and branch |

Line 1373: mask_ba_num_option := NVL(FND_PROFILE.value('CE_MASK_INTERNAL_BANK_ACCT_NUM'), 'LAST FOUR VISIBLE');

1369:
1370: BEGIN
1371: IF p_acct_class is not null THEN
1372: IF p_acct_class in ( 'INTERNAL', 'BOTH') THEN
1373: mask_ba_num_option := NVL(FND_PROFILE.value('CE_MASK_INTERNAL_BANK_ACCT_NUM'), 'LAST FOUR VISIBLE');
1374: ELSIF p_acct_class = 'EXTERNAL' THEN
1375: mask_ba_num_option := NVL(FND_PROFILE.value('CE_MASK_EXTERNAL_BANK_ACCT_NUM'), 'LAST FOUR VISIBLE');
1376: END IF;
1377: END IF;

Line 1375: mask_ba_num_option := NVL(FND_PROFILE.value('CE_MASK_EXTERNAL_BANK_ACCT_NUM'), 'LAST FOUR VISIBLE');

1371: IF p_acct_class is not null THEN
1372: IF p_acct_class in ( 'INTERNAL', 'BOTH') THEN
1373: mask_ba_num_option := NVL(FND_PROFILE.value('CE_MASK_INTERNAL_BANK_ACCT_NUM'), 'LAST FOUR VISIBLE');
1374: ELSIF p_acct_class = 'EXTERNAL' THEN
1375: mask_ba_num_option := NVL(FND_PROFILE.value('CE_MASK_EXTERNAL_BANK_ACCT_NUM'), 'LAST FOUR VISIBLE');
1376: END IF;
1377: END IF;
1378: IF p_bank_account_num is not null THEN
1379: ba_num_length := length(p_bank_account_num);