DBA Data[Home] [Help]

APPS.CE_BANK_PUB dependencies on CE_BANK_AND_ACCOUNT_VALIDATION

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

2113: check_mandatory_param('p_acct_rec.account_classification',p_acct_rec.account_classification);
2114:
2115: -- validate currency
2116: IF p_acct_rec.currency IS NOT NULL THEN
2117: CE_BANK_AND_ACCOUNT_VALIDATION.validate_currency(p_acct_rec.currency, x_return_status);
2118:
2119: -- raise an exception if the validation is unsuccessful
2120: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2121: RAISE fnd_api.g_exc_error;

Line 2127: /* CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_name(p_acct_rec.branch_id, p_acct_rec.bank_account_name,

2123: END IF;
2124:
2125: -- Bug 10183698
2126: -- validate account name
2127: /* CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_name(p_acct_rec.branch_id, p_acct_rec.bank_account_name,
2128: null, x_return_status);
2129:
2130: -- raise an exception if the validation is unsuccessful
2131: IF x_return_status <> fnd_api.g_ret_sts_success THEN

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

2134:
2135:
2136: -- validate iban
2137: IF p_acct_rec.iban IS NOT NULL THEN
2138: CE_BANK_AND_ACCOUNT_VALIDATION.validate_IBAN(p_acct_rec.iban, l_iban, x_return_status);
2139:
2140: -- raise an exception if the validation is unsuccessful
2141: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2142: RAISE fnd_api.g_exc_error;

Line 2148: CE_BANK_AND_ACCOUNT_VALIDATION.validate_alc(p_acct_rec.agency_location_code,

2144: END IF;
2145:
2146: -- validate agency_location_code
2147: IF p_acct_rec.agency_location_code IS NOT NULL THEN
2148: CE_BANK_AND_ACCOUNT_VALIDATION.validate_alc(p_acct_rec.agency_location_code,
2149: FND_API.G_FALSE,
2150: x_msg_count,
2151: x_msg_data,
2152: l_alc,

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

2760: -- validate currency
2761: --Bug 8407297 - Call to the Currency Validation not required as the Currency field is protected against update
2762: /*
2763: IF p_acct_rec.currency IS NOT NULL THEN
2764: CE_BANK_AND_ACCOUNT_VALIDATION.validate_currency(p_acct_rec.currency, x_return_status);
2765:
2766: -- raise an exception if the validation is unsuccessful
2767: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2768: RAISE fnd_api.g_exc_error;

Line 2784: /* CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_name(l_branch_id, p_acct_rec.bank_account_name,

2780: RAISE fnd_api.g_exc_error;
2781: END IF;
2782: CLOSE c_branch_id;
2783: -- Bug 10261393
2784: /* CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_name(l_branch_id, p_acct_rec.bank_account_name,
2785: p_acct_rec.bank_account_id, x_return_status);
2786:
2787: -- raise an exception if the validation is unsuccessful
2788: IF x_return_status <> fnd_api.g_ret_sts_success THEN

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

2790: END IF; */
2791:
2792: -- validate iban
2793: IF p_acct_rec.iban IS NOT NULL THEN
2794: CE_BANK_AND_ACCOUNT_VALIDATION.validate_IBAN(p_acct_rec.iban, l_iban, x_return_status);
2795:
2796: -- raise an exception if the validation is unsuccessful
2797: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2798: RAISE fnd_api.g_exc_error;

Line 2804: CE_BANK_AND_ACCOUNT_VALIDATION.validate_alc(p_acct_rec.agency_location_code,

2800: END IF;
2801:
2802: -- validate agency_location_code
2803: IF p_acct_rec.agency_location_code IS NOT NULL THEN
2804: CE_BANK_AND_ACCOUNT_VALIDATION.validate_alc(p_acct_rec.agency_location_code,
2805: FND_API.G_FALSE,
2806: x_msg_count,
2807: x_msg_data,
2808: l_alc,

Line 3105: CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_use

3101: RAISE fnd_api.g_exc_error;
3102: END IF;
3103:
3104: -- validate account use
3105: CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_use
3106: (p_acct_use_rec.ap_use_enable_flag,
3107: p_acct_use_rec.ar_use_enable_flag,
3108: p_acct_use_rec.pay_use_enable_flag,
3109: p_acct_use_rec.xtr_use_enable_flag,

Line 3124: CE_BANK_AND_ACCOUNT_VALIDATION.validate_unique_org_access

3120: ELSE
3121: l_org_le_id := p_acct_use_rec.org_id;
3122: END IF;
3123:
3124: CE_BANK_AND_ACCOUNT_VALIDATION.validate_unique_org_access
3125: (l_org_le_id,
3126: p_acct_use_rec.bank_account_id,
3127: null,
3128: x_return_status);

Line 3135: CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_access_org

3131: RAISE fnd_api.g_exc_error;
3132: END IF;
3133:
3134: -- validate the org type matches with the account use
3135: CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_access_org
3136: (p_acct_use_rec.ap_use_enable_flag,
3137: p_acct_use_rec.ar_use_enable_flag,
3138: p_acct_use_rec.pay_use_enable_flag,
3139: p_acct_use_rec.xtr_use_enable_flag,

Line 3149: CE_BANK_AND_ACCOUNT_VALIDATION.validate_def_settlement

3145: RAISE fnd_api.g_exc_error;
3146: END IF;
3147:
3148: -- validate default settlement
3149: CE_BANK_AND_ACCOUNT_VALIDATION.validate_def_settlement
3150: (p_acct_use_rec.bank_account_id,
3151: null,
3152: l_org_le_id,
3153: p_acct_use_rec.xtr_default_settlement_flag,

Line 3479: CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_use

3475: RAISE fnd_api.g_exc_error;
3476: END IF;
3477:
3478: -- validate account use
3479: CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_use
3480: (p_acct_use_rec.ap_use_enable_flag,
3481: p_acct_use_rec.ar_use_enable_flag,
3482: p_acct_use_rec.pay_use_enable_flag,
3483: p_acct_use_rec.xtr_use_enable_flag,

Line 3492: CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_access_org

3488: RAISE fnd_api.g_exc_error;
3489: END IF;
3490:
3491: -- validate the org type matches with the account use
3492: CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_access_org
3493: (p_acct_use_rec.ap_use_enable_flag,
3494: p_acct_use_rec.ar_use_enable_flag,
3495: p_acct_use_rec.pay_use_enable_flag,
3496: p_acct_use_rec.xtr_use_enable_flag,

Line 3506: CE_BANK_AND_ACCOUNT_VALIDATION.validate_def_settlement

3502: RAISE fnd_api.g_exc_error;
3503: END IF;
3504:
3505: -- validate default settlement
3506: CE_BANK_AND_ACCOUNT_VALIDATION.validate_def_settlement
3507: (l_acct_id,
3508: p_acct_use_rec.bank_acct_use_id,
3509: l_org_le_id,
3510: p_acct_use_rec.xtr_default_settlement_flag,