eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_EXT_BANKACCT_VALIDATIONS dependencies on FND_API

Line 1604: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

1600: --
1601:
1602: PROCEDURE iby_validate_account(
1603: p_api_version IN NUMBER,
1604: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
1605: p_ext_bank_rec IN OUT NOCOPY IBY_EXT_BANKACCT_PUB.ExtBank_rec_type,
1606: p_ext_bank_branch_rec IN OUT NOCOPY IBY_EXT_BANKACCT_PUB.ExtBankBranch_rec_type,
1607: p_ext_bank_acct_rec IN OUT NOCOPY IBY_EXT_BANKACCT_PUB.ExtBankAcct_rec_type,
1608: x_return_status OUT NOCOPY VARCHAR2,

Line 1620: p_create_flag => FND_API.G_TRUE,

1616:
1617: iby_validate_account(
1618: p_api_version => p_api_version,
1619: p_init_msg_list => p_init_msg_list,
1620: p_create_flag => FND_API.G_TRUE,
1621: p_ext_bank_rec => p_ext_bank_rec,
1622: p_ext_bank_branch_rec => p_ext_bank_branch_rec,
1623: p_ext_bank_acct_rec => p_ext_bank_acct_rec,
1624: x_return_status => x_return_status,

Line 1648: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

1644: --
1645:
1646: PROCEDURE iby_validate_account(
1647: p_api_version IN NUMBER,
1648: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
1649: p_create_flag IN VARCHAR2 default FND_API.G_TRUE,
1650: p_ext_bank_rec IN OUT NOCOPY IBY_EXT_BANKACCT_PUB.ExtBank_rec_type,
1651: p_ext_bank_branch_rec IN OUT NOCOPY IBY_EXT_BANKACCT_PUB.ExtBankBranch_rec_type,
1652: p_ext_bank_acct_rec IN OUT NOCOPY IBY_EXT_BANKACCT_PUB.ExtBankAcct_rec_type,

Line 1649: p_create_flag IN VARCHAR2 default FND_API.G_TRUE,

1645:
1646: PROCEDURE iby_validate_account(
1647: p_api_version IN NUMBER,
1648: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
1649: p_create_flag IN VARCHAR2 default FND_API.G_TRUE,
1650: p_ext_bank_rec IN OUT NOCOPY IBY_EXT_BANKACCT_PUB.ExtBank_rec_type,
1651: p_ext_bank_branch_rec IN OUT NOCOPY IBY_EXT_BANKACCT_PUB.ExtBankBranch_rec_type,
1652: p_ext_bank_acct_rec IN OUT NOCOPY IBY_EXT_BANKACCT_PUB.ExtBankAcct_rec_type,
1653: x_return_status OUT NOCOPY VARCHAR2,

Line 1715: IF NOT FND_API.Compatible_API_Call(l_api_version,

1711:
1712: print_debuginfo('ENTER ' || l_module_name);
1713:
1714: -- Standard call to check for call compatibility.
1715: IF NOT FND_API.Compatible_API_Call(l_api_version,
1716: p_api_version,
1717: l_api_name,
1718: G_PKG_NAME) THEN
1719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1715: IF NOT FND_API.Compatible_API_Call(l_api_version,
1716: p_api_version,
1717: l_api_name,
1718: G_PKG_NAME) THEN
1719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 1723: IF FND_API.to_Boolean(p_init_msg_list) THEN

1719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 1728: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
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;

Line 1731: IF FND_API.to_Boolean(p_init_msg_list) THEN

1727: -- Initialize API return status to 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

Line 1738: IF (p_create_flag = FND_API.G_TRUE) THEN

1734:
1735: -- Account Number is mandatory
1736: check_mandatory('Account Number', p_ext_bank_acct_rec.bank_account_num);
1737:
1738: IF (p_create_flag = FND_API.G_TRUE) THEN
1739:
1740: -- Account Name if specfied should be unique
1741: IF (p_ext_bank_acct_rec.bank_account_name <> NULL) THEN
1742: SELECT COUNT(EXT_BANK_ACCOUNT_ID)

Line 1806: FND_API.G_FALSE, -- do not re-initialize msg stack

1802: p_ext_bank_rec.bank_name,
1803: p_ext_bank_rec.bank_alt_name,
1804: p_ext_bank_rec.tax_payer_id,
1805: null, -- bank_id
1806: FND_API.G_FALSE, -- do not re-initialize msg stack
1807: x_msg_count,
1808: x_msg_data,
1809: l_bank_number, -- reformated bank number
1810: x_return_status);

Line 1815: x_return_status <> fnd_api.g_ret_sts_success) THEN

1811:
1812: print_debuginfo('After return from CE country specific validation: '|| x_return_status);
1813: -- raise an exception if country specific validations fail
1814: IF (x_return_status IS NULL OR
1815: x_return_status <> fnd_api.g_ret_sts_success) THEN
1816: RAISE fnd_api.g_exc_error;
1817: END IF;
1818:
1819: -- call HZ bank validation API to validate bank record

Line 1816: RAISE fnd_api.g_exc_error;

1812: print_debuginfo('After return from CE country specific validation: '|| x_return_status);
1813: -- raise an exception if country specific validations fail
1814: IF (x_return_status IS NULL OR
1815: x_return_status <> fnd_api.g_ret_sts_success) THEN
1816: RAISE fnd_api.g_exc_error;
1817: END IF;
1818:
1819: -- call HZ bank validation API to validate bank record
1820: l_party_rec.attribute_category := p_ext_bank_rec.attribute_category;

Line 1870: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1866: x_msg_count,
1867: x_msg_data);
1868: print_debuginfo('After return from HZ bank validation: '|| x_return_status);
1869: -- raise an exception if the validation routine is unsuccessful
1870: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1871: RAISE fnd_api.g_exc_error;
1872: END IF;
1873: end if;
1874:

Line 1871: RAISE fnd_api.g_exc_error;

1867: x_msg_data);
1868: print_debuginfo('After return from HZ bank validation: '|| x_return_status);
1869: -- raise an exception if the validation routine is unsuccessful
1870: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1871: RAISE fnd_api.g_exc_error;
1872: END IF;
1873: end if;
1874:
1875: /* Bug 6043905: The branch number is not mandatory for all countries.

Line 1908: x_return_status := fnd_api.g_ret_sts_error;

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;
1912:

Line 1909: RAISE fnd_api.g_exc_error;

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;
1912:
1913: -- country specific validation API call here

Line 1922: FND_API.G_FALSE, -- do not re-initialize msg stack

1918: p_ext_bank_branch_rec.branch_name,
1919: p_ext_bank_branch_rec.alternate_branch_name,
1920: p_ext_bank_acct_rec.bank_id,
1921: null, -- branch_id
1922: FND_API.G_FALSE, -- do not re-initialize msg stack
1923: x_msg_count,
1924: x_msg_data,
1925: l_branch_number, -- reformatted branch number
1926: x_return_status);

Line 1930: x_return_status <> fnd_api.g_ret_sts_success) THEN

1926: x_return_status);
1927:
1928: -- raise an exception if country specific validations fail
1929: IF (x_return_status IS NULL OR
1930: x_return_status <> fnd_api.g_ret_sts_success) THEN
1931: RAISE fnd_api.g_exc_error;
1932: END IF;
1933: -- check HZ validate branch API
1934: l_party_rec.attribute_category := p_ext_bank_branch_rec.attribute_category;

Line 1931: RAISE fnd_api.g_exc_error;

1927:
1928: -- raise an exception if country specific validations fail
1929: IF (x_return_status IS NULL OR
1930: x_return_status <> fnd_api.g_ret_sts_success) THEN
1931: RAISE fnd_api.g_exc_error;
1932: END IF;
1933: -- check HZ validate branch API
1934: l_party_rec.attribute_category := p_ext_bank_branch_rec.attribute_category;
1935: l_party_rec.attribute1 := p_ext_bank_branch_rec.attribute1;

Line 1984: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1980: x_msg_count,
1981: x_msg_data);
1982: print_debuginfo('After return from HZ branch validation: '|| x_return_status);
1983: -- raise an exception if the validation routine is unsuccessful
1984: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1985: RAISE fnd_api.g_exc_error;
1986: END IF;
1987:
1988: end if;

Line 1985: RAISE fnd_api.g_exc_error;

1981: x_msg_data);
1982: print_debuginfo('After return from HZ branch validation: '|| x_return_status);
1983: -- raise an exception if the validation routine is unsuccessful
1984: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1985: RAISE fnd_api.g_exc_error;
1986: END IF;
1987:
1988: end if;
1989:

Line 1998: IF (l_return_status = fnd_api.g_ret_sts_error) THEN

1994: print_debuginfo('Country Code: '||COUNTRY);
1995: CE_BANK_AND_ACCOUNT_VALIDATION.validate_country(
1996: p_country_code => p_ext_bank_acct_rec.country_code,
1997: x_return_status => l_return_status);
1998: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
1999: RAISE fnd_api.g_exc_error;
2000: END IF;
2001:
2002: -- Validate IBAN Number

Line 1999: RAISE fnd_api.g_exc_error;

1995: CE_BANK_AND_ACCOUNT_VALIDATION.validate_country(
1996: p_country_code => p_ext_bank_acct_rec.country_code,
1997: x_return_status => l_return_status);
1998: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
1999: RAISE fnd_api.g_exc_error;
2000: END IF;
2001:
2002: -- Validate IBAN Number
2003: CE_BANK_AND_ACCOUNT_VALIDATION.validate_IBAN (

Line 2007: IF (l_return_status = fnd_api.g_ret_sts_error) THEN

2003: CE_BANK_AND_ACCOUNT_VALIDATION.validate_IBAN (
2004: p_IBAN => p_ext_bank_acct_rec.iban,
2005: p_IBAN_OUT => l_iban,
2006: x_return_status => l_return_status);
2007: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
2008: RAISE fnd_api.g_exc_error;
2009: END IF;
2010:
2011: -- invoke Country specific validation procedures

Line 2008: RAISE fnd_api.g_exc_error;

2004: p_IBAN => p_ext_bank_acct_rec.iban,
2005: p_IBAN_OUT => l_iban,
2006: x_return_status => l_return_status);
2007: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
2008: RAISE fnd_api.g_exc_error;
2009: END IF;
2010:
2011: -- invoke Country specific validation procedures
2012: CASE COUNTRY

Line 2203: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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:

Line 2209: x_return_status := fnd_api.g_ret_sts_error;

2205: p_data => x_msg_data);
2206:
2207:
2208: IF x_msg_count > 0 THEN
2209: x_return_status := fnd_api.g_ret_sts_error;
2210: print_debuginfo('Account Validations Failed ');
2211: ELSE
2212: print_debuginfo('Account Validations Successful');
2213: END IF;

Line 2218: WHEN fnd_api.g_exc_error THEN

2214:
2215: print_debuginfo('RETURN ' || l_module_name);
2216:
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,

Line 2219: x_return_status := fnd_api.g_ret_sts_error;

2215: print_debuginfo('RETURN ' || l_module_name);
2216:
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);

Line 2220: print_debuginfo('IN Exception fnd_api.g_exc_error');

2216:
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:

Line 2221: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

Line 2225: WHEN fnd_api.g_exc_unexpected_error THEN

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
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,

Line 2226: x_return_status := fnd_api.g_ret_sts_unexp_error;

2222: p_count => x_msg_count,
2223: p_data => x_msg_data);
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);

Line 2227: print_debuginfo('IN Exception fnd_api.g_ret_sts_unexp_error');

2223: p_data => x_msg_data);
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:

Line 2228: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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:

Line 2234: x_return_status := fnd_api.g_ret_sts_unexp_error;

2230: p_data => x_msg_data);
2231:
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);

Line 2240: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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;

Line 2276: RAISE fnd_api.g_exc_error;

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:
2279:
2280: --Validate Currency

Line 2290: RAISE fnd_api.g_exc_error;

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;
2294: print_debuginfo('Checked mandatory field : ' || p_field || ' : ' || p_value);