[Home] [Help]
1720: END IF;
1721:
1722: -- Initialize message list if p_init_msg_list is set to TRUE.
1723: IF FND_API.to_Boolean(p_init_msg_list) THEN
1724: FND_MSG_PUB.initialize;
1725: END IF;
1726:
1727: -- Initialize API return status to success
1728: x_return_status := FND_API.G_RET_STS_SUCCESS;
1728: x_return_status := FND_API.G_RET_STS_SUCCESS;
1729:
1730: -- Initialize message list if p_init_msg_list is set to TRUE.
1731: IF FND_API.to_Boolean(p_init_msg_list) THEN
1732: FND_MSG_PUB.initialize;
1733: END IF;
1734:
1735: -- Account Number is mandatory
1736: check_mandatory('Account Number', p_ext_bank_acct_rec.bank_account_num);
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;
1753: END IF;
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;
1770:
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;
1911: CLOSE c_bank;
2199: END CASE;
2200:
2201:
2202: -- get message count and if count is 1, get message info.
2203: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2204: p_count => x_msg_count,
2205: p_data => x_msg_data);
2206:
2207:
2217: EXCEPTION
2218: WHEN fnd_api.g_exc_error THEN
2219: x_return_status := fnd_api.g_ret_sts_error;
2220: print_debuginfo('IN Exception fnd_api.g_exc_error');
2221: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2222: p_count => x_msg_count,
2223: p_data => x_msg_data);
2224:
2225: WHEN fnd_api.g_exc_unexpected_error THEN
2224:
2225: WHEN fnd_api.g_exc_unexpected_error THEN
2226: x_return_status := fnd_api.g_ret_sts_unexp_error;
2227: print_debuginfo('IN Exception fnd_api.g_ret_sts_unexp_error');
2228: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2229: p_count => x_msg_count,
2230: p_data => x_msg_data);
2231:
2232:
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,
2242: p_data => x_msg_data);
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,
2242: p_data => x_msg_data);
2243:
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,
2242: p_data => x_msg_data);
2243:
2244: END iby_validate_account;
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;
2278:
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:
2293: END IF;