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_PUB dependencies on FND_MESSAGE

Line 817: fnd_message.set_name('IBY', 'IBY_DATA_VERSION_ERROR');

813: IF (l_rfc_identifier_ovn IS NOT NULL) THEN
814: print_debuginfo('Current RFC Identifier OVN ' || l_rfc_identifier_ovn);
815: IF (l_rfc_identifier_ovn <> p_ext_bank_branch_rec.rfc_object_version_number) THEN
816:
817: fnd_message.set_name('IBY', 'IBY_DATA_VERSION_ERROR');
818:
819: fnd_msg_pub.add;
820: print_debuginfo('Object Version Number mismatch');
821: END IF;

Line 832: fnd_message.set_name('IBY', 'IBY_DATA_VERSION_ERROR');

828: print_debuginfo('Input RFC Identifier OVN ' || p_ext_bank_branch_rec.eft_object_version_number);
829: IF (l_eft_record_ovn IS NOT NULL) THEN
830: print_debuginfo('Current RFC Identifier OVN ' || l_eft_record_ovn);
831: IF (l_eft_record_ovn <> p_ext_bank_branch_rec.eft_object_version_number) THEN
832: fnd_message.set_name('IBY', 'IBY_DATA_VERSION_ERROR');
833: fnd_msg_pub.add;
834: print_debuginfo('Object Version Number mismatch');
835: END IF;
836: ELSE

Line 1290: fnd_message.set_name('IBY', 'IBY_API_NO_BRANCH');

1286: -- find branch number
1287: OPEN c_branch(p_ext_bank_acct_rec.branch_id);
1288: FETCH c_branch INTO l_branch_number;
1289: IF c_branch%NOTFOUND THEN
1290: fnd_message.set_name('IBY', 'IBY_API_NO_BRANCH');
1291: fnd_msg_pub.add;
1292: x_return_status := fnd_api.g_ret_sts_error;
1293: RAISE fnd_api.g_exc_error;
1294: ELSE

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

1319: print_debuginfo('Return status from check exist:'||x_return_status);
1320: print_debuginfo('Duplicate account id:'||l_dup_acct_id);
1321: IF ((not x_return_status = fnd_api.g_ret_sts_success) OR
1322: (not l_dup_acct_id is null)) THEN
1323: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT');
1324: fnd_msg_pub.add;
1325: OPEN c_supplier(l_dup_acct_id);
1326: FETCH c_supplier INTO l_party_id;
1327: IF l_party_id IS NOT NULL THEN

Line 1329: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT_SUPPLIER');

1325: OPEN c_supplier(l_dup_acct_id);
1326: FETCH c_supplier INTO l_party_id;
1327: IF l_party_id IS NOT NULL THEN
1328: SELECT vendor_name, segment1 INTO l_supplier_name, l_supplier_number FROM ap_suppliers WHERE party_id = l_party_id;
1329: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT_SUPPLIER');
1330: fnd_message.set_Token('SUPPLIER',l_supplier_name);
1331: fnd_message.set_Token('SUPPLIERNUMBER',l_supplier_number);
1332: fnd_msg_pub.add;
1333: END IF;

Line 1330: fnd_message.set_Token('SUPPLIER',l_supplier_name);

1326: FETCH c_supplier INTO l_party_id;
1327: IF l_party_id IS NOT NULL THEN
1328: SELECT vendor_name, segment1 INTO l_supplier_name, l_supplier_number FROM ap_suppliers WHERE party_id = l_party_id;
1329: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT_SUPPLIER');
1330: fnd_message.set_Token('SUPPLIER',l_supplier_name);
1331: fnd_message.set_Token('SUPPLIERNUMBER',l_supplier_number);
1332: fnd_msg_pub.add;
1333: END IF;
1334: CLOSE c_supplier;

Line 1331: fnd_message.set_Token('SUPPLIERNUMBER',l_supplier_number);

1327: IF l_party_id IS NOT NULL THEN
1328: SELECT vendor_name, segment1 INTO l_supplier_name, l_supplier_number FROM ap_suppliers WHERE party_id = l_party_id;
1329: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT_SUPPLIER');
1330: fnd_message.set_Token('SUPPLIER',l_supplier_name);
1331: fnd_message.set_Token('SUPPLIERNUMBER',l_supplier_number);
1332: fnd_msg_pub.add;
1333: END IF;
1334: CLOSE c_supplier;
1335: x_return_status := fnd_api.g_ret_sts_error;

Line 2047: fnd_message.set_name('IBY', 'IBY_API_NO_EXT_BANK_ACCT');

2043: l_encrypted,
2044: l_old_iban,
2045: l_old_masked_iban;
2046: IF c_ovn%NOTFOUND THEN
2047: fnd_message.set_name('IBY', 'IBY_API_NO_EXT_BANK_ACCT');
2048: fnd_msg_pub.add;
2049: x_return_status := fnd_api.g_ret_sts_error;
2050: CLOSE c_ovn;
2051: RAISE fnd_api.g_exc_error;

Line 2057: fnd_message.set_name('IBY', 'IBY_DATA_VERSION_ERROR');

2053: CLOSE c_ovn;
2054: print_debuginfo('Current object_version_number Version Number ' || l_old_ovn);
2055:
2056: IF l_old_ovn <> p_ext_bank_acct_rec.object_version_number THEN
2057: fnd_message.set_name('IBY', 'IBY_DATA_VERSION_ERROR');
2058: fnd_msg_pub.add;
2059: x_return_status := fnd_api.g_ret_sts_error;
2060: print_debuginfo('Error: Object Version Number Mismatch');
2061: RAISE fnd_api.g_exc_error;

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

2071: p_ext_bank_acct_rec.branch_id,
2072: p_ext_bank_acct_rec.bank_account_id);
2073: FETCH uniq_check into l_count;
2074: IF (l_count > 1) THEN
2075: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT');
2076: fnd_msg_pub.add;
2077: x_return_status := fnd_api.g_ret_sts_error;
2078: RAISE fnd_api.g_exc_error;
2079: END IF;

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

2084: print_debuginfo('Return status from check exist:'||x_return_status);
2085: print_debuginfo('Duplicate account id:'||l_dup_acct_id);
2086: IF ((not x_return_status = fnd_api.g_ret_sts_success) OR
2087: (not l_dup_acct_id is null)) THEN
2088: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT');
2089: fnd_msg_pub.add;
2090: x_return_status := fnd_api.g_ret_sts_error;
2091: print_debuginfo('Error : Duplicate Bank Account');
2092: RAISE fnd_api.g_exc_error;

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

2267: print_debuginfo('Return status from check exist:'||x_return_status);
2268: print_debuginfo('Duplicate account id:'||l_dup_acct_id);
2269: IF ((not x_return_status = fnd_api.g_ret_sts_success) OR
2270: (not l_dup_acct_id is null)) THEN
2271: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT');
2272: fnd_msg_pub.add;
2273: OPEN c_supplier(l_dup_acct_id);
2274: FETCH c_supplier INTO l_party_id;
2275: IF l_party_id IS NOT NULL THEN

Line 2277: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT_SUPPLIER');

2273: OPEN c_supplier(l_dup_acct_id);
2274: FETCH c_supplier INTO l_party_id;
2275: IF l_party_id IS NOT NULL THEN
2276: SELECT vendor_name, segment1 INTO l_supplier_name, l_supplier_number FROM ap_suppliers WHERE party_id = l_party_id;
2277: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT_SUPPLIER');
2278: fnd_message.set_Token('SUPPLIER',l_supplier_name);
2279: fnd_message.set_Token('SUPPLIERNUMBER',l_supplier_number);
2280: fnd_msg_pub.add;
2281: END IF;

Line 2278: fnd_message.set_Token('SUPPLIER',l_supplier_name);

2274: FETCH c_supplier INTO l_party_id;
2275: IF l_party_id IS NOT NULL THEN
2276: SELECT vendor_name, segment1 INTO l_supplier_name, l_supplier_number FROM ap_suppliers WHERE party_id = l_party_id;
2277: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT_SUPPLIER');
2278: fnd_message.set_Token('SUPPLIER',l_supplier_name);
2279: fnd_message.set_Token('SUPPLIERNUMBER',l_supplier_number);
2280: fnd_msg_pub.add;
2281: END IF;
2282: CLOSE c_supplier;

Line 2279: fnd_message.set_Token('SUPPLIERNUMBER',l_supplier_number);

2275: IF l_party_id IS NOT NULL THEN
2276: SELECT vendor_name, segment1 INTO l_supplier_name, l_supplier_number FROM ap_suppliers WHERE party_id = l_party_id;
2277: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT_SUPPLIER');
2278: fnd_message.set_Token('SUPPLIER',l_supplier_name);
2279: fnd_message.set_Token('SUPPLIERNUMBER',l_supplier_number);
2280: fnd_msg_pub.add;
2281: END IF;
2282: CLOSE c_supplier;
2283: x_return_status := fnd_api.g_ret_sts_error;

Line 2850: fnd_message.set_name('IBY', 'IBY_START_END_DATE_BAD');

2846:
2847: IF (p_end_date IS NOT NULL AND p_start_date > p_end_date) THEN
2848: -- throw exception if start date
2849: -- exceeds end_date
2850: fnd_message.set_name('IBY', 'IBY_START_END_DATE_BAD');
2851: fnd_msg_pub.add;
2852: RAISE fnd_api.g_exc_error;
2853: END IF;
2854:

Line 3087: -- fnd_message.set_name('IBY', 'IBY_EXT_ACCT_NOT_EXIST');

3083: CLOSE uniq_check_generic;
3084: END IF;
3085:
3086: IF (SQL%NOTFOUND) THEN
3087: -- fnd_message.set_name('IBY', 'IBY_EXT_ACCT_NOT_EXIST');
3088: -- fnd_msg_pub.add;
3089: print_debuginfo('External Account does not exist ');
3090: END IF;
3091:

Line 3396: fnd_message.set_name('IBY', 'IBY_API_NO_INTERMEDIARY_ACCT');

3392: -- check object version number to make sure the record has not been updated
3393: OPEN c_ovn;
3394: FETCH c_ovn INTO l_old_ovn;
3395: IF c_ovn%NOTFOUND THEN
3396: fnd_message.set_name('IBY', 'IBY_API_NO_INTERMEDIARY_ACCT');
3397: fnd_msg_pub.add;
3398: x_return_status := fnd_api.g_ret_sts_error;
3399: CLOSE c_ovn;
3400: RAISE fnd_api.g_exc_error;

Line 3405: fnd_message.set_name('IBY', 'IBY_DATA_VERSION_ERROR');

3401: END IF;
3402: CLOSE c_ovn;
3403:
3404: IF l_old_ovn > p_intermed_acct_rec.object_version_number THEN
3405: fnd_message.set_name('IBY', 'IBY_DATA_VERSION_ERROR');
3406: fnd_msg_pub.add;
3407: x_return_status := fnd_api.g_ret_sts_error;
3408: RAISE fnd_api.g_exc_error;
3409: END IF;

Line 3431: fnd_message.set_name('IBY', 'IBY_API_NO_INTERMEDIARY_ACCT');

3427: WHERE intermediary_acct_id = p_intermed_acct_rec.intermediary_acct_id
3428: RETURNING object_version_number INTO p_intermed_acct_rec.object_version_number;
3429:
3430: IF (SQL%NOTFOUND) THEN
3431: fnd_message.set_name('IBY', 'IBY_API_NO_INTERMEDIARY_ACCT');
3432: fnd_msg_pub.add;
3433: x_return_status := fnd_api.g_ret_sts_error;
3434: RAISE fnd_api.g_exc_error;
3435: END IF;

Line 3544: fnd_message.set_name('IBY', 'IBY_ACCT_OWNER_EXISTS');

3540: FETCH uniq_check INTO l_count;
3541: CLOSE uniq_check;
3542:
3543: IF (l_count > 0) THEN
3544: fnd_message.set_name('IBY', 'IBY_ACCT_OWNER_EXISTS');
3545: fnd_msg_pub.add;
3546: RETURN;
3547: END IF;
3548:

Line 3881: fnd_message.set_name('IBY', 'IBY_API_NO_BANK');

3877:
3878: OPEN c_country;
3879: FETCH c_country INTO l_country;
3880: IF c_country%NOTFOUND THEN
3881: fnd_message.set_name('IBY', 'IBY_API_NO_BANK');
3882: fnd_msg_pub.add;
3883: x_return_status := fnd_api.g_ret_sts_error;
3884: END IF;
3885: CLOSE c_country;

Line 3967: fnd_message.set_name('IBY', 'IBY_API_NO_BANK');

3963:
3964: OPEN c_bank;
3965: FETCH c_bank INTO x_bank_id, x_country_code, x_bank_name, x_bank_number;
3966: IF c_bank%NOTFOUND THEN
3967: fnd_message.set_name('IBY', 'IBY_API_NO_BANK');
3968: fnd_msg_pub.add;
3969: x_return_status := fnd_api.g_ret_sts_error;
3970: END IF;
3971: CLOSE c_bank;

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

4000:
4001: BEGIN
4002:
4003: if (p_value is NULL) THEN
4004: fnd_message.set_name('IBY', 'IBY_MISSING_MANDATORY_PARAM');
4005: fnd_message.set_token('PARAM', p_field);
4006: fnd_msg_pub.add;
4007: print_debuginfo(p_field || ' is a required parameter.');
4008: RAISE fnd_api.g_exc_error;

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

4001: BEGIN
4002:
4003: if (p_value is NULL) THEN
4004: fnd_message.set_name('IBY', 'IBY_MISSING_MANDATORY_PARAM');
4005: fnd_message.set_token('PARAM', p_field);
4006: fnd_msg_pub.add;
4007: print_debuginfo(p_field || ' is a required parameter.');
4008: RAISE fnd_api.g_exc_error;
4009: END IF;

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

4015: FETCH c_validate_currency INTO l_temp;
4016: CLOSE c_validate_currency;
4017:
4018: IF (l_temp IS NULL) THEN
4019: fnd_message.set_name('IBY', 'IBY_INVALID_CURRENCY');
4020: fnd_message.set_token('CURRENCY_CODE', p_field);
4021: fnd_msg_pub.add;
4022: RAISE fnd_api.g_exc_error;
4023: END IF;

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

4016: CLOSE c_validate_currency;
4017:
4018: IF (l_temp IS NULL) THEN
4019: fnd_message.set_name('IBY', 'IBY_INVALID_CURRENCY');
4020: fnd_message.set_token('CURRENCY_CODE', p_field);
4021: fnd_msg_pub.add;
4022: RAISE fnd_api.g_exc_error;
4023: END IF;
4024: