DBA Data[Home] [Help]

APPS.IBY_EXT_BANKACCT_VALIDATIONS dependencies on FND_MESSAGE

Line 1917: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT_NAME');

1913: FROM IBY_EXT_BANK_ACCOUNTS_V
1914: WHERE BANK_ACCOUNT_NAME =p_ext_bank_acct_rec.bank_account_name;
1915:
1916: IF (l_count > 0) THEN
1917: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT_NAME');
1918: fnd_msg_pub.add;
1919: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1920: print_debuginfo('Bank Account Name failed unique check');
1921: END IF;

Line 1967: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT');

1963: FETCH uniq_check into l_count;
1964: END IF;
1965:
1966: IF (l_count > 0) THEN
1967: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT');
1968: fnd_msg_pub.add;
1969: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1970: print_debuginfo('Bank Account Number failed unique check');
1971: END IF;

Line 1986: fnd_message.set_name('IBY', 'IBY_API_NO_BANK');

1982: (p_ext_bank_rec.bank_name is NULL)) THEN
1983: l_foreign_pmt_flag := TRUE;
1984: -- Bank Name is mandatory
1985: --check_mandatory('IBY_BANK_NAME_FIELD',p_ext_bank_rec.bank_name);
1986: fnd_message.set_name('IBY', 'IBY_API_NO_BANK');
1987: fnd_msg_pub.add;
1988: RAISE fnd_api.g_exc_error;
1989: END IF;
1990:

Line 1997: fnd_message.set_name('IBY', 'IBY_API_NO_BRANCH');

1993: (p_ext_bank_branch_rec.branch_name IS NULL)) THEN
1994: l_foreign_pmt_flag := TRUE;
1995: -- Bank Branch Name is mandatory
1996: --check_mandatory('IBY_BRANCH_NAME_FIELD',p_ext_bank_branch_rec.branch_name);
1997: fnd_message.set_name('IBY', 'IBY_API_NO_BRANCH');
1998: fnd_msg_pub.add;
1999: RAISE fnd_api.g_exc_error;
2000: END IF;
2001:

Line 2121: fnd_message.set_name('CE', 'CE_API_NO_BANK');

2117: -- get bank information
2118: OPEN c_bank;
2119: FETCH c_bank INTO l_bank_name, l_bank_number, l_country;
2120: IF c_bank%NOTFOUND THEN
2121: fnd_message.set_name('CE', 'CE_API_NO_BANK');
2122: fnd_msg_pub.add;
2123: x_return_status := fnd_api.g_ret_sts_error;
2124: RAISE fnd_api.g_exc_error;
2125: END IF;

Line 2471: -- fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');

2467: x_return_status := fnd_api.g_ret_sts_unexp_error;
2468: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2469: print_debuginfo('Exception : ' || SQLERRM);
2470: END IF;
2471: -- fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');
2472: -- fnd_message.set_token('ERROR',SQLERRM);
2473: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
2474: -- fnd_msg_pub.add;
2475: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 2472: -- fnd_message.set_token('ERROR',SQLERRM);

2468: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2469: print_debuginfo('Exception : ' || SQLERRM);
2470: END IF;
2471: -- fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');
2472: -- fnd_message.set_token('ERROR',SQLERRM);
2473: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
2474: -- fnd_msg_pub.add;
2475: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2476: p_count => x_msg_count,

Line 2507: fnd_message.set_name('IBY', 'IBY_MISSING_MANDATORY_PARAM');

2503:
2504: BEGIN
2505:
2506: if (p_value is NULL) THEN
2507: fnd_message.set_name('IBY', 'IBY_MISSING_MANDATORY_PARAM');
2508: fnd_message.set_token('PARAM', fnd_message.get_string('IBY', p_field));
2509: fnd_msg_pub.add;
2510: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2511: print_debuginfo(p_field || ' is a required parameter.');

Line 2508: fnd_message.set_token('PARAM', fnd_message.get_string('IBY', p_field));

2504: BEGIN
2505:
2506: if (p_value is NULL) THEN
2507: fnd_message.set_name('IBY', 'IBY_MISSING_MANDATORY_PARAM');
2508: fnd_message.set_token('PARAM', fnd_message.get_string('IBY', p_field));
2509: fnd_msg_pub.add;
2510: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2511: print_debuginfo(p_field || ' is a required parameter.');
2512: END IF;

Line 2524: fnd_message.set_name('IBY', 'IBY_INVALID_CURRENCY');

2520: FETCH c_validate_currency INTO l_temp;
2521: CLOSE c_validate_currency;
2522:
2523: IF (l_temp IS NULL) THEN
2524: fnd_message.set_name('IBY', 'IBY_INVALID_CURRENCY');
2525: fnd_message.set_token('CURRENCY_CODE', p_field);
2526: fnd_msg_pub.add;
2527: RAISE fnd_api.g_exc_error;
2528: END IF;

Line 2525: fnd_message.set_token('CURRENCY_CODE', p_field);

2521: CLOSE c_validate_currency;
2522:
2523: IF (l_temp IS NULL) THEN
2524: fnd_message.set_name('IBY', 'IBY_INVALID_CURRENCY');
2525: fnd_message.set_token('CURRENCY_CODE', p_field);
2526: fnd_msg_pub.add;
2527: RAISE fnd_api.g_exc_error;
2528: END IF;
2529: