DBA Data[Home] [Help]

APPS.CE_VALIDATE_BANKINFO dependencies on FND_PROFILE

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

2: /* $Header: cevlbnkb.pls 120.34.12010000.5 2008/11/21 10:50:22 vnetan ship $ */
3:
4:
5: -- bug 3855002
6: --l_DEBUG varchar2(1) := NVL(FND_PROFILE.value('CE_DEBUG'), 'N');
7: --l_DEBUG varchar2(1) := 'Y';
8: --confirmed sql 6/25/02
9:
10: -- bug 6856840

Line 64: l_DEBUG := NVL(FND_PROFILE.value('CE_DEBUG'), 'N');

60: l_bic varchar2(30) ;
61: l_string varchar2(30) ;
62:
63: BEGIN
64: l_DEBUG := NVL(FND_PROFILE.value('CE_DEBUG'), 'N');
65:
66: IF l_DEBUG in ('Y', 'C') THEN
67: cep_standard.debug('>>CE_VALIDATE_BANKINFO.ce_validate_bic');
68: END IF;

Line 997: l_DEBUG := NVL(FND_PROFILE.value('CE_DEBUG'), 'N');

993: X_PASS_MAND_CHECK VARCHAR2(1);
994:
995:
996: BEGIN
997: l_DEBUG := NVL(FND_PROFILE.value('CE_DEBUG'), 'N');
998: --l_DEBUG := 'Y';
999:
1000: IF l_DEBUG in ('Y', 'C') THEN
1001: cep_standard.debug('>>CE_VALIDATE_BANKINFO.ce_validate_cd');

Line 1194: l_DEBUG := NVL(FND_PROFILE.value('CE_DEBUG'), 'N');

1190:
1191: X_PASS_MAND_CHECK VARCHAR2(1);
1192:
1193: BEGIN
1194: l_DEBUG := NVL(FND_PROFILE.value('CE_DEBUG'), 'N');
1195: --l_DEBUG := 'Y';
1196:
1197: IF l_DEBUG in ('Y', 'C') THEN
1198: cep_standard.debug('>>CE_VALIDATE_BANKINFO.ce_validate_branch');

Line 1464: l_DEBUG := NVL(FND_PROFILE.value('CE_DEBUG'), 'N');

1460:
1461: X_PASS_MAND_CHECK VARCHAR2(1);
1462:
1463: BEGIN
1464: l_DEBUG := NVL(FND_PROFILE.value('CE_DEBUG'), 'N');
1465: --l_DEBUG := 'Y';
1466:
1467: IF l_DEBUG in ('Y', 'C') THEN
1468: cep_standard.debug('>>CE_VALIDATE_BANKINFO.upd_branch_unique');

Line 1602: l_DEBUG := NVL(FND_PROFILE.value('CE_DEBUG'), 'N');

1598:
1599: X_PASS_MAND_CHECK VARCHAR2(1);
1600:
1601: BEGIN
1602: l_DEBUG := NVL(FND_PROFILE.value('CE_DEBUG'), 'N');
1603: --l_DEBUG := 'Y';
1604:
1605: IF l_DEBUG in ('Y', 'C') THEN
1606: cep_standard.debug('>>CE_VALIDATE_BANKINFO.upd_branch_validate');

Line 1986: --l_DEBUG := NVL(FND_PROFILE.value('CE_DEBUG'), 'N');

1982: ) AS
1983: COUNTRY_NAME VARCHAR2(2);
1984:
1985: BEGIN
1986: --l_DEBUG := NVL(FND_PROFILE.value('CE_DEBUG'), 'N');
1987: --l_DEBUG := 'Y';
1988:
1989: IF l_DEBUG in ('Y', 'C') THEN
1990: cep_standard.debug('>>CE_VALIDATE_BANKINFO.CE_FORMAT_ELECTRONIC_NUM');

Line 2114: l_DEBUG := NVL(FND_PROFILE.value('CE_DEBUG'), 'N');

2110: NEW_ACCOUNT_NUM VARCHAR2(100);
2111: X_PASS_MAND_CHECK VARCHAR2(1);
2112:
2113: BEGIN
2114: l_DEBUG := NVL(FND_PROFILE.value('CE_DEBUG'), 'N');
2115: --l_DEBUG := 'Y';
2116:
2117: IF l_DEBUG in ('Y', 'C') THEN
2118: cep_standard.debug('>>CE_VALIDATE_BANKINFO.ce_validate_account');

Line 2437: l_DEBUG := NVL(FND_PROFILE.value('CE_DEBUG'), 'N');

2433:
2434: X_PASS_MAND_CHECK VARCHAR2(1);
2435:
2436: BEGIN
2437: l_DEBUG := NVL(FND_PROFILE.value('CE_DEBUG'), 'N');
2438: --l_DEBUG := 'Y';
2439:
2440: IF l_DEBUG in ('Y', 'C') THEN
2441: cep_standard.debug('>>CE_VALIDATE_BANKINFO.upd_account_unique');

Line 2567: l_DEBUG := NVL(FND_PROFILE.value('CE_DEBUG'), 'N');

2563: X_PASS_MAND_CHECK VARCHAR2(1);
2564: NEW_ACCOUNT_NUM VARCHAR2(100);
2565:
2566: BEGIN
2567: l_DEBUG := NVL(FND_PROFILE.value('CE_DEBUG'), 'N');
2568: --l_DEBUG := 'Y';
2569:
2570: IF l_DEBUG in ('Y', 'C') THEN
2571: cep_standard.debug('>>CE_VALIDATE_BANKINFO.upd_account_validate');

Line 2840: l_DEBUG := NVL(FND_PROFILE.value('CE_DEBUG'), 'N');

2836:
2837: X_PASS_MAND_CHECK VARCHAR2(1);
2838:
2839: BEGIN
2840: l_DEBUG := NVL(FND_PROFILE.value('CE_DEBUG'), 'N');
2841: --l_DEBUG := 'Y';
2842:
2843: IF l_DEBUG in ('Y', 'C') THEN
2844: cep_standard.debug('>>CE_VALIDATE_BANKINFO.ce_validate_bank');

Line 3056: l_DEBUG := NVL(FND_PROFILE.value('CE_DEBUG'), 'N');

3052:
3053: X_PASS_MAND_CHECK VARCHAR2(1);
3054:
3055: BEGIN
3056: l_DEBUG := NVL(FND_PROFILE.value('CE_DEBUG'), 'N');
3057: --l_DEBUG := 'Y';
3058:
3059: IF l_DEBUG in ('Y', 'C') THEN
3060: cep_standard.debug('>>CE_VALIDATE_BANKINFO.upd_bank_unique');

Line 3163: l_DEBUG := NVL(FND_PROFILE.value('CE_DEBUG'), 'N');

3159:
3160: X_PASS_MAND_CHECK VARCHAR2(1);
3161:
3162: BEGIN
3163: l_DEBUG := NVL(FND_PROFILE.value('CE_DEBUG'), 'N');
3164: --l_DEBUG := 'Y';
3165:
3166: IF l_DEBUG in ('Y', 'C') THEN
3167: cep_standard.debug('>>CE_VALIDATE_BANKINFO.ce_validate_bank');

Line 7662: l_DEBUG := NVL(FND_PROFILE.value('CE_DEBUG'), 'N');

7658: end pass_check;
7659:
7660:
7661: BEGIN
7662: l_DEBUG := NVL(FND_PROFILE.value('CE_DEBUG'), 'N');
7663: --l_DEBUG := 'Y';
7664: IF l_DEBUG in ('Y', 'C') THEN
7665: cep_standard.debug('>>CE_VALIDATE_BANKINFO.CE_VALIDATE_MISC_EFT_NUM');
7666: END IF;

Line 7780: l_DEBUG := NVL(FND_PROFILE.value('CE_DEBUG'), 'N');

7776: END IF;
7777: end pass_check;
7778:
7779: BEGIN
7780: l_DEBUG := NVL(FND_PROFILE.value('CE_DEBUG'), 'N');
7781: --l_DEBUG := 'Y';
7782:
7783: IF l_DEBUG in ('Y', 'C') THEN
7784: cep_standard.debug('>>CE_VALIDATE_BANKINFO.CE_VALIDATE_MISC_ACCT_HLDR_ALT');

Line 7928: l_DEBUG := NVL(FND_PROFILE.value('CE_DEBUG'), 'N');

7924: END IF;
7925: end fail_mandatory;
7926:
7927: BEGIN
7928: l_DEBUG := NVL(FND_PROFILE.value('CE_DEBUG'), 'N');
7929: --l_DEBUG := 'Y';
7930:
7931: IF l_DEBUG in ('Y', 'C') THEN
7932: cep_standard.debug('>>CE_VALIDATE_BANKINFO.GET_BRANCH_NUM_FORMAT');