APPS.CE_BANK_PUB dependencies on CE_BANK_AND_ACCOUNT_VALIDATION

Line 1970: CE_BANK_AND_ACCOUNT_VALIDATION.validate_currency(p_acct_rec.currency, x_return_status);

1966: END IF;
1967:
1968: -- validate currency
1969: IF p_acct_rec.currency IS NOT NULL THEN
1970: CE_BANK_AND_ACCOUNT_VALIDATION.validate_currency(p_acct_rec.currency, x_return_status);
1971:
1972: -- raise an exception if the validation is unsuccessful
1973: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1974: RAISE fnd_api.g_exc_error;

Line 1979: CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_name(p_acct_rec.branch_id, p_acct_rec.bank_account_name,

1975: END IF;
1976: END IF;
1977:
1978: -- validate account name
1979: CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_name(p_acct_rec.branch_id, p_acct_rec.bank_account_name,
1980: null, x_return_status);
1981:
1982: -- raise an exception if the validation is unsuccessful
1983: IF x_return_status <> fnd_api.g_ret_sts_success THEN

Line 1990: CE_BANK_AND_ACCOUNT_VALIDATION.validate_IBAN(p_acct_rec.iban, l_iban, x_return_status);

1986:
1987:
1988: -- validate iban
1989: IF p_acct_rec.iban IS NOT NULL THEN
1990: CE_BANK_AND_ACCOUNT_VALIDATION.validate_IBAN(p_acct_rec.iban, l_iban, x_return_status);
1991:
1992: -- raise an exception if the validation is unsuccessful
1993: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1994: RAISE fnd_api.g_exc_error;

Line 2000: CE_BANK_AND_ACCOUNT_VALIDATION.validate_alc(p_acct_rec.agency_location_code,

1996: END IF;
1997:
1998: -- validate agency_location_code
1999: IF p_acct_rec.agency_location_code IS NOT NULL THEN
2000: CE_BANK_AND_ACCOUNT_VALIDATION.validate_alc(p_acct_rec.agency_location_code,
2001: FND_API.G_FALSE,
2002: x_msg_count,
2003: x_msg_data,
2004: l_alc,

Line 2404: CE_BANK_AND_ACCOUNT_VALIDATION.validate_currency(p_acct_rec.currency, x_return_status);

2400: END IF;
2401:
2402: -- validate currency
2403: IF p_acct_rec.currency IS NOT NULL THEN
2404: CE_BANK_AND_ACCOUNT_VALIDATION.validate_currency(p_acct_rec.currency, x_return_status);
2405:
2406: -- raise an exception if the validation is unsuccessful
2407: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2408: RAISE fnd_api.g_exc_error;

Line 2424: CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_name(l_branch_id, p_acct_rec.bank_account_name,

2420: RAISE fnd_api.g_exc_error;
2421: END IF;
2422: CLOSE c_branch_id;
2423:
2424: CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_name(l_branch_id, p_acct_rec.bank_account_name,
2425: p_acct_rec.bank_account_id, x_return_status);
2426:
2427: -- raise an exception if the validation is unsuccessful
2428: IF x_return_status <> fnd_api.g_ret_sts_success THEN

Line 2434: CE_BANK_AND_ACCOUNT_VALIDATION.validate_IBAN(p_acct_rec.iban, l_iban, x_return_status);

2430: END IF;
2431:
2432: -- validate iban
2433: IF p_acct_rec.iban IS NOT NULL THEN
2434: CE_BANK_AND_ACCOUNT_VALIDATION.validate_IBAN(p_acct_rec.iban, l_iban, x_return_status);
2435:
2436: -- raise an exception if the validation is unsuccessful
2437: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2438: RAISE fnd_api.g_exc_error;

Line 2444: CE_BANK_AND_ACCOUNT_VALIDATION.validate_alc(p_acct_rec.agency_location_code,

2440: END IF;
2441:
2442: -- validate agency_location_code
2443: IF p_acct_rec.agency_location_code IS NOT NULL THEN
2444: CE_BANK_AND_ACCOUNT_VALIDATION.validate_alc(p_acct_rec.agency_location_code,
2445: FND_API.G_FALSE,
2446: x_msg_count,
2447: x_msg_data,
2448: l_alc,

Line 2739: CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_use

2735: RAISE fnd_api.g_exc_error;
2736: END IF;
2737:
2738: -- validate account use
2739: CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_use
2740: (p_acct_use_rec.ap_use_enable_flag,
2741: p_acct_use_rec.ar_use_enable_flag,
2742: p_acct_use_rec.pay_use_enable_flag,
2743: p_acct_use_rec.xtr_use_enable_flag,

Line 2758: CE_BANK_AND_ACCOUNT_VALIDATION.validate_unique_org_access

2754: ELSE
2755: l_org_le_id := p_acct_use_rec.org_id;
2756: END IF;
2757:
2758: CE_BANK_AND_ACCOUNT_VALIDATION.validate_unique_org_access
2759: (l_org_le_id,
2760: p_acct_use_rec.bank_account_id,
2761: null,
2762: x_return_status);

Line 2769: CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_access_org

2765: RAISE fnd_api.g_exc_error;
2766: END IF;
2767:
2768: -- validate the org type matches with the account use
2769: CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_access_org
2770: (p_acct_use_rec.ap_use_enable_flag,
2771: p_acct_use_rec.ar_use_enable_flag,
2772: p_acct_use_rec.pay_use_enable_flag,
2773: p_acct_use_rec.xtr_use_enable_flag,

Line 2783: CE_BANK_AND_ACCOUNT_VALIDATION.validate_def_settlement

2779: RAISE fnd_api.g_exc_error;
2780: END IF;
2781:
2782: -- validate default settlement
2783: CE_BANK_AND_ACCOUNT_VALIDATION.validate_def_settlement
2784: (p_acct_use_rec.bank_account_id,
2785: null,
2786: l_org_le_id,
2787: p_acct_use_rec.xtr_default_settlement_flag,

Line 3117: CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_use

3113: RAISE fnd_api.g_exc_error;
3114: END IF;
3115:
3116: -- validate account use
3117: CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_use
3118: (p_acct_use_rec.ap_use_enable_flag,
3119: p_acct_use_rec.ar_use_enable_flag,
3120: p_acct_use_rec.pay_use_enable_flag,
3121: p_acct_use_rec.xtr_use_enable_flag,

Line 3130: CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_access_org

3126: RAISE fnd_api.g_exc_error;
3127: END IF;
3128:
3129: -- validate the org type matches with the account use
3130: CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_access_org
3131: (p_acct_use_rec.ap_use_enable_flag,
3132: p_acct_use_rec.ar_use_enable_flag,
3133: p_acct_use_rec.pay_use_enable_flag,
3134: p_acct_use_rec.xtr_use_enable_flag,

Line 3144: CE_BANK_AND_ACCOUNT_VALIDATION.validate_def_settlement

3140: RAISE fnd_api.g_exc_error;
3141: END IF;
3142:
3143: -- validate default settlement
3144: CE_BANK_AND_ACCOUNT_VALIDATION.validate_def_settlement
3145: (l_acct_id,
3146: p_acct_use_rec.bank_acct_use_id,
3147: l_org_le_id,
3148: p_acct_use_rec.xtr_default_settlement_flag,