DBA Data[Home] [Help]

APPS.IBY_EXT_BANKACCT_VALIDATIONS dependencies on FND_MSG_PUB

Line 1893: FND_MSG_PUB.initialize;

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
1897: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1901: FND_MSG_PUB.initialize;

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
1905: check_mandatory('IBY_ACCT_NUM_FIELD', p_ext_bank_acct_rec.bank_account_num);

Line 1918: fnd_msg_pub.add;

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;
1922: x_valid := FALSE;

Line 1968: fnd_msg_pub.add;

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;
1972: x_valid := FALSE;

Line 1987: fnd_msg_pub.add;

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

Line 1998: fnd_msg_pub.add;

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:
2002: /* if bank information provided, we need validate bank info.*/

Line 2122: fnd_msg_pub.add;

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

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 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 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 2473: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

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

Line 2474: -- fnd_msg_pub.add;

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

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 2509: fnd_msg_pub.add;

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;
2513: RAISE fnd_api.g_exc_error;

Line 2526: fnd_msg_pub.add;

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:
2530: END IF;