DBA Data[Home] [Help]

APPS.IBY_EXT_BANKACCT_VALIDATIONS dependencies on FND_MESSAGE

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

1744: FROM IBY_EXT_BANK_ACCOUNTS_V
1745: WHERE BANK_ACCOUNT_NAME =p_ext_bank_acct_rec.bank_account_name;
1746:
1747: IF (l_count > 0) THEN
1748: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT_NAME');
1749: fnd_msg_pub.add;
1750: print_debuginfo('Bank Account Name failed unique check');
1751: x_valid := FALSE;
1752: END IF;

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

1761: p_ext_bank_acct_rec.bank_account_id);
1762: FETCH uniq_check into l_count;
1763:
1764: IF (l_count > 0) THEN
1765: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT');
1766: fnd_msg_pub.add;
1767: print_debuginfo('Bank Account Name failed unique check');
1768: x_valid := FALSE;
1769: END IF;

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

1902: -- get bank information
1903: OPEN c_bank;
1904: FETCH c_bank INTO l_bank_name, l_bank_number, l_country;
1905: IF c_bank%NOTFOUND THEN
1906: fnd_message.set_name('CE', 'CE_API_NO_BANK');
1907: fnd_msg_pub.add;
1908: x_return_status := fnd_api.g_ret_sts_error;
1909: RAISE fnd_api.g_exc_error;
1910: END IF;

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

2232:
2233: WHEN OTHERS THEN
2234: x_return_status := fnd_api.g_ret_sts_unexp_error;
2235: print_debuginfo('Exception : ' || SQLERRM);
2236: -- fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');
2237: -- fnd_message.set_token('ERROR',SQLERRM);
2238: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
2239: -- fnd_msg_pub.add;
2240: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

2233: WHEN OTHERS THEN
2234: x_return_status := fnd_api.g_ret_sts_unexp_error;
2235: print_debuginfo('Exception : ' || SQLERRM);
2236: -- fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');
2237: -- fnd_message.set_token('ERROR',SQLERRM);
2238: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
2239: -- fnd_msg_pub.add;
2240: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2241: p_count => x_msg_count,

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

2268:
2269: BEGIN
2270:
2271: if (p_value is NULL) THEN
2272: fnd_message.set_name('IBY', 'IBY_MISSING_MANDATORY_PARAM');
2273: fnd_message.set_token('PARAM', p_field);
2274: fnd_msg_pub.add;
2275: print_debuginfo(p_field || ' is a required parameter.');
2276: RAISE fnd_api.g_exc_error;

Line 2273: fnd_message.set_token('PARAM', p_field);

2269: BEGIN
2270:
2271: if (p_value is NULL) THEN
2272: fnd_message.set_name('IBY', 'IBY_MISSING_MANDATORY_PARAM');
2273: fnd_message.set_token('PARAM', p_field);
2274: fnd_msg_pub.add;
2275: print_debuginfo(p_field || ' is a required parameter.');
2276: RAISE fnd_api.g_exc_error;
2277: END IF;

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

2283: FETCH c_validate_currency INTO l_temp;
2284: CLOSE c_validate_currency;
2285:
2286: IF (l_temp IS NULL) THEN
2287: fnd_message.set_name('IBY', 'IBY_INVALID_CURRENCY');
2288: fnd_message.set_token('CURRENCY_CODE', p_field);
2289: fnd_msg_pub.add;
2290: RAISE fnd_api.g_exc_error;
2291: END IF;

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

2284: CLOSE c_validate_currency;
2285:
2286: IF (l_temp IS NULL) THEN
2287: fnd_message.set_name('IBY', 'IBY_INVALID_CURRENCY');
2288: fnd_message.set_token('CURRENCY_CODE', p_field);
2289: fnd_msg_pub.add;
2290: RAISE fnd_api.g_exc_error;
2291: END IF;
2292: