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.

[Home] [Help]

APPS.IBY_EXT_BANKACCT_VALIDATIONS dependencies on FND_API

Line 1723: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

1719: --
1720:
1721: PROCEDURE iby_validate_account(
1722: p_api_version IN NUMBER,
1723: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
1724: p_ext_bank_rec IN OUT NOCOPY IBY_EXT_BANKACCT_PUB.ExtBank_rec_type,
1725: p_ext_bank_branch_rec IN OUT NOCOPY IBY_EXT_BANKACCT_PUB.ExtBankBranch_rec_type,
1726: p_ext_bank_acct_rec IN OUT NOCOPY IBY_EXT_BANKACCT_PUB.ExtBankAcct_rec_type,
1727: x_return_status OUT NOCOPY VARCHAR2,

Line 1739: p_create_flag => FND_API.G_TRUE,

1735:
1736: iby_validate_account(
1737: p_api_version => p_api_version,
1738: p_init_msg_list => p_init_msg_list,
1739: p_create_flag => FND_API.G_TRUE,
1740: p_ext_bank_rec => p_ext_bank_rec,
1741: p_ext_bank_branch_rec => p_ext_bank_branch_rec,
1742: p_ext_bank_acct_rec => p_ext_bank_acct_rec,
1743: x_return_status => x_return_status,

Line 1767: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

1763: --
1764:
1765: PROCEDURE iby_validate_account(
1766: p_api_version IN NUMBER,
1767: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
1768: p_create_flag IN VARCHAR2 default FND_API.G_TRUE,
1769: p_ext_bank_rec IN OUT NOCOPY IBY_EXT_BANKACCT_PUB.ExtBank_rec_type,
1770: p_ext_bank_branch_rec IN OUT NOCOPY IBY_EXT_BANKACCT_PUB.ExtBankBranch_rec_type,
1771: p_ext_bank_acct_rec IN OUT NOCOPY IBY_EXT_BANKACCT_PUB.ExtBankAcct_rec_type,

Line 1768: p_create_flag IN VARCHAR2 default FND_API.G_TRUE,

1764:
1765: PROCEDURE iby_validate_account(
1766: p_api_version IN NUMBER,
1767: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
1768: p_create_flag IN VARCHAR2 default FND_API.G_TRUE,
1769: p_ext_bank_rec IN OUT NOCOPY IBY_EXT_BANKACCT_PUB.ExtBank_rec_type,
1770: p_ext_bank_branch_rec IN OUT NOCOPY IBY_EXT_BANKACCT_PUB.ExtBankBranch_rec_type,
1771: p_ext_bank_acct_rec IN OUT NOCOPY IBY_EXT_BANKACCT_PUB.ExtBankAcct_rec_type,
1772: x_return_status OUT NOCOPY VARCHAR2,

Line 1884: IF NOT FND_API.Compatible_API_Call(l_api_version,

1880: print_debuginfo('ENTER ' || l_module_name);
1881:
1882: END IF;
1883: -- Standard call to check for call compatibility.
1884: IF NOT FND_API.Compatible_API_Call(l_api_version,
1885: p_api_version,
1886: l_api_name,
1887: G_PKG_NAME) THEN
1888: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1888: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1884: IF NOT FND_API.Compatible_API_Call(l_api_version,
1885: p_api_version,
1886: l_api_name,
1887: G_PKG_NAME) THEN
1888: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1889: END IF;
1890:
1891: -- Initialize message list if p_init_msg_list is set to TRUE.
1892: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1892: IF FND_API.to_Boolean(p_init_msg_list) THEN

1888: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1889: END IF;
1890:
1891: -- Initialize message list if p_init_msg_list is set to TRUE.
1892: IF FND_API.to_Boolean(p_init_msg_list) THEN
1893: FND_MSG_PUB.initialize;
1894: END IF;
1895:
1896: -- Initialize API return status to success

Line 1897: x_return_status := FND_API.G_RET_STS_SUCCESS;

1893: FND_MSG_PUB.initialize;
1894: END IF;
1895:
1896: -- Initialize API return status to success
1897: x_return_status := FND_API.G_RET_STS_SUCCESS;
1898:
1899: -- Initialize message list if p_init_msg_list is set to TRUE.
1900: IF FND_API.to_Boolean(p_init_msg_list) THEN
1901: FND_MSG_PUB.initialize;

Line 1900: IF FND_API.to_Boolean(p_init_msg_list) THEN

1896: -- Initialize API return status to success
1897: x_return_status := FND_API.G_RET_STS_SUCCESS;
1898:
1899: -- Initialize message list if p_init_msg_list is set to TRUE.
1900: IF FND_API.to_Boolean(p_init_msg_list) THEN
1901: FND_MSG_PUB.initialize;
1902: END IF;
1903:
1904: -- Account Number is mandatory

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

1903:
1904: -- Account Number is mandatory
1905: check_mandatory('IBY_ACCT_NUM_FIELD', p_ext_bank_acct_rec.bank_account_num);
1906:
1907: IF (p_create_flag = FND_API.G_TRUE) THEN
1908:
1909: -- Account Name if specfied should be unique
1910: IF (p_ext_bank_acct_rec.bank_account_name <> NULL) THEN
1911: SELECT COUNT(EXT_BANK_ACCOUNT_ID)

Line 1988: RAISE fnd_api.g_exc_error;

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:
1991: IF ((p_ext_bank_acct_rec.foreign_payment_use_flag = 'Y') AND
1992: (p_ext_bank_acct_rec.branch_id is NULL) AND

Line 1999: RAISE fnd_api.g_exc_error;

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:
2002: /* if bank information provided, we need validate bank info.*/
2003: if((NOT p_ext_bank_rec.bank_name is NULL) AND

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

2013: p_ext_bank_rec.bank_name,
2014: p_ext_bank_rec.bank_alt_name,
2015: p_ext_bank_rec.tax_payer_id,
2016: null, -- bank_id
2017: FND_API.G_FALSE, -- do not re-initialize msg stack
2018: x_msg_count,
2019: x_msg_data,
2020: l_bank_number, -- reformated bank number
2021: x_return_status);

Line 2028: x_return_status <> fnd_api.g_ret_sts_success) THEN

2024: print_debuginfo('After return from CE country specific validation: '|| x_return_status);
2025: END IF;
2026: -- raise an exception if country specific validations fail
2027: IF (x_return_status IS NULL OR
2028: x_return_status <> fnd_api.g_ret_sts_success) THEN
2029: RAISE fnd_api.g_exc_error;
2030: END IF;
2031:
2032: -- call HZ bank validation API to validate bank record

Line 2029: RAISE fnd_api.g_exc_error;

2025: END IF;
2026: -- raise an exception if country specific validations fail
2027: IF (x_return_status IS NULL OR
2028: x_return_status <> fnd_api.g_ret_sts_success) THEN
2029: RAISE fnd_api.g_exc_error;
2030: END IF;
2031:
2032: -- call HZ bank validation API to validate bank record
2033: l_party_rec.attribute_category := p_ext_bank_rec.attribute_category;

Line 2085: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2081: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2082: print_debuginfo('After return from HZ bank validation: '|| x_return_status);
2083: END IF;
2084: -- raise an exception if the validation routine is unsuccessful
2085: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2086: RAISE fnd_api.g_exc_error;
2087: END IF;
2088: end if;
2089:

Line 2086: RAISE fnd_api.g_exc_error;

2082: print_debuginfo('After return from HZ bank validation: '|| x_return_status);
2083: END IF;
2084: -- raise an exception if the validation routine is unsuccessful
2085: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2086: RAISE fnd_api.g_exc_error;
2087: END IF;
2088: end if;
2089:
2090: /* Bug 6043905: The branch number is not mandatory for all countries.

Line 2123: x_return_status := fnd_api.g_ret_sts_error;

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;
2126: CLOSE c_bank;
2127:

Line 2124: RAISE fnd_api.g_exc_error;

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;
2126: CLOSE c_bank;
2127:
2128: -- country specific validation API call here

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

2133: p_ext_bank_branch_rec.branch_name,
2134: p_ext_bank_branch_rec.alternate_branch_name,
2135: p_ext_bank_acct_rec.bank_id,
2136: null, -- branch_id
2137: FND_API.G_FALSE, -- do not re-initialize msg stack
2138: x_msg_count,
2139: x_msg_data,
2140: l_branch_number, -- reformatted branch number
2141: x_return_status);

Line 2145: x_return_status <> fnd_api.g_ret_sts_success) THEN

2141: x_return_status);
2142:
2143: -- raise an exception if country specific validations fail
2144: IF (x_return_status IS NULL OR
2145: x_return_status <> fnd_api.g_ret_sts_success) THEN
2146: RAISE fnd_api.g_exc_error;
2147: END IF;
2148: -- check HZ validate branch API
2149: l_party_rec.attribute_category := p_ext_bank_branch_rec.attribute_category;

Line 2146: RAISE fnd_api.g_exc_error;

2142:
2143: -- raise an exception if country specific validations fail
2144: IF (x_return_status IS NULL OR
2145: x_return_status <> fnd_api.g_ret_sts_success) THEN
2146: RAISE fnd_api.g_exc_error;
2147: END IF;
2148: -- check HZ validate branch API
2149: l_party_rec.attribute_category := p_ext_bank_branch_rec.attribute_category;
2150: l_party_rec.attribute1 := p_ext_bank_branch_rec.attribute1;

Line 2201: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2197: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2198: print_debuginfo('After return from HZ branch validation: '|| x_return_status);
2199: END IF;
2200: -- raise an exception if the validation routine is unsuccessful
2201: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2202: RAISE fnd_api.g_exc_error;
2203: END IF;
2204:
2205: end if;

Line 2202: RAISE fnd_api.g_exc_error;

2198: print_debuginfo('After return from HZ branch validation: '|| x_return_status);
2199: END IF;
2200: -- raise an exception if the validation routine is unsuccessful
2201: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2202: RAISE fnd_api.g_exc_error;
2203: END IF;
2204:
2205: end if;
2206:

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

2213: END IF;
2214: CE_BANK_AND_ACCOUNT_VALIDATION.validate_country(
2215: p_country_code => p_ext_bank_acct_rec.country_code,
2216: x_return_status => l_return_status);
2217: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
2218: RAISE fnd_api.g_exc_error;
2219: END IF;
2220:
2221: -- Validate IBAN Number

Line 2218: RAISE fnd_api.g_exc_error;

2214: CE_BANK_AND_ACCOUNT_VALIDATION.validate_country(
2215: p_country_code => p_ext_bank_acct_rec.country_code,
2216: x_return_status => l_return_status);
2217: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
2218: RAISE fnd_api.g_exc_error;
2219: END IF;
2220:
2221: -- Validate IBAN Number
2222: IF (p_ext_bank_acct_rec.iban IS NOT NULL) THEN

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

2224: p_IBAN => p_ext_bank_acct_rec.iban,
2225: p_IBAN_OUT => l_iban,
2226: x_return_status => l_return_status);
2227: END IF;
2228: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
2229: RAISE fnd_api.g_exc_error;
2230: END IF;
2231:
2232: -- invoke Country specific validation procedures

Line 2229: RAISE fnd_api.g_exc_error;

2225: p_IBAN_OUT => l_iban,
2226: x_return_status => l_return_status);
2227: END IF;
2228: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
2229: RAISE fnd_api.g_exc_error;
2230: END IF;
2231:
2232: -- invoke Country specific validation procedures
2233: CASE COUNTRY

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

2422: END CASE;
2423:
2424:
2425: -- get message count and if count is 1, get message info.
2426: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2427: p_count => x_msg_count,
2428: p_data => x_msg_data);
2429:
2430:

Line 2432: x_return_status := fnd_api.g_ret_sts_error;

2428: p_data => x_msg_data);
2429:
2430:
2431: IF x_msg_count > 0 THEN
2432: x_return_status := fnd_api.g_ret_sts_error;
2433: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2434: print_debuginfo('Account Validations Failed ');
2435: END IF;
2436: ELSE

Line 2447: WHEN fnd_api.g_exc_error THEN

2443: print_debuginfo('RETURN ' || l_module_name);
2444:
2445: END IF;
2446: EXCEPTION
2447: WHEN fnd_api.g_exc_error THEN
2448: x_return_status := fnd_api.g_ret_sts_error;
2449: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2450: print_debuginfo('IN Exception fnd_api.g_exc_error');
2451: END IF;

Line 2448: x_return_status := fnd_api.g_ret_sts_error;

2444:
2445: END IF;
2446: EXCEPTION
2447: WHEN fnd_api.g_exc_error THEN
2448: x_return_status := fnd_api.g_ret_sts_error;
2449: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2450: print_debuginfo('IN Exception fnd_api.g_exc_error');
2451: END IF;
2452: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

2446: EXCEPTION
2447: WHEN fnd_api.g_exc_error THEN
2448: x_return_status := fnd_api.g_ret_sts_error;
2449: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2450: print_debuginfo('IN Exception fnd_api.g_exc_error');
2451: END IF;
2452: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2453: p_count => x_msg_count,
2454: p_data => x_msg_data);

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

2448: x_return_status := fnd_api.g_ret_sts_error;
2449: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2450: print_debuginfo('IN Exception fnd_api.g_exc_error');
2451: END IF;
2452: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2453: p_count => x_msg_count,
2454: p_data => x_msg_data);
2455:
2456: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2456: WHEN fnd_api.g_exc_unexpected_error THEN

2452: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2453: p_count => x_msg_count,
2454: p_data => x_msg_data);
2455:
2456: WHEN fnd_api.g_exc_unexpected_error THEN
2457: x_return_status := fnd_api.g_ret_sts_unexp_error;
2458: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2459: print_debuginfo('IN Exception fnd_api.g_ret_sts_unexp_error');
2460: END IF;

Line 2457: x_return_status := fnd_api.g_ret_sts_unexp_error;

2453: p_count => x_msg_count,
2454: p_data => x_msg_data);
2455:
2456: WHEN fnd_api.g_exc_unexpected_error THEN
2457: x_return_status := fnd_api.g_ret_sts_unexp_error;
2458: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2459: print_debuginfo('IN Exception fnd_api.g_ret_sts_unexp_error');
2460: END IF;
2461: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

2455:
2456: WHEN fnd_api.g_exc_unexpected_error THEN
2457: x_return_status := fnd_api.g_ret_sts_unexp_error;
2458: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2459: print_debuginfo('IN Exception fnd_api.g_ret_sts_unexp_error');
2460: END IF;
2461: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2462: p_count => x_msg_count,
2463: p_data => x_msg_data);

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

2457: x_return_status := fnd_api.g_ret_sts_unexp_error;
2458: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2459: print_debuginfo('IN Exception fnd_api.g_ret_sts_unexp_error');
2460: END IF;
2461: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2462: p_count => x_msg_count,
2463: p_data => x_msg_data);
2464:
2465:

Line 2467: x_return_status := fnd_api.g_ret_sts_unexp_error;

2463: p_data => x_msg_data);
2464:
2465:
2466: WHEN OTHERS THEN
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');

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

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,
2477: p_data => x_msg_data);
2478:
2479: END iby_validate_account;

Line 2513: RAISE fnd_api.g_exc_error;

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;
2513: RAISE fnd_api.g_exc_error;
2514: END IF;
2515:
2516:
2517: --Validate Currency

Line 2527: RAISE fnd_api.g_exc_error;

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:
2530: END IF;
2531: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN