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 897: fnd_message.set_name('IBY', 'IBY_DATA_VERSION_ERROR');

893: print_debuginfo('Current RFC Identifier OVN ' || l_rfc_identifier_ovn);
894: END IF;
895: IF (l_rfc_identifier_ovn <> p_ext_bank_branch_rec.rfc_object_version_number) THEN
896:
897: fnd_message.set_name('IBY', 'IBY_DATA_VERSION_ERROR');
898:
899: fnd_msg_pub.add;
900: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
901: print_debuginfo('Object Version Number mismatch');

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

916: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
917: print_debuginfo('Current RFC Identifier OVN ' || l_eft_record_ovn);
918: END IF;
919: IF (l_eft_record_ovn <> p_ext_bank_branch_rec.eft_object_version_number) THEN
920: fnd_message.set_name('IBY', 'IBY_DATA_VERSION_ERROR');
921: fnd_msg_pub.add;
922: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
923: print_debuginfo('Object Version Number mismatch');
924: END IF;

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

1440: -- find branch number
1441: OPEN c_branch(p_ext_bank_acct_rec.branch_id);
1442: FETCH c_branch INTO l_branch_number;
1443: IF c_branch%NOTFOUND THEN
1444: fnd_message.set_name('IBY', 'IBY_API_NO_BRANCH');
1445: fnd_msg_pub.add;
1446: x_return_status := fnd_api.g_ret_sts_error;
1447: RAISE fnd_api.g_exc_error;
1448: ELSE

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

1477: print_debuginfo('Duplicate account id:'||l_dup_acct_id);
1478: END IF;
1479: IF ((not x_return_status = fnd_api.g_ret_sts_success) OR
1480: (not l_dup_acct_id is null)) THEN
1481: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT');
1482: fnd_msg_pub.add;
1483: /*OPEN c_supplier(l_dup_acct_id);
1484: FETCH c_supplier INTO l_party_id;
1485: IF l_party_id IS NOT NULL THEN

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

1483: /*OPEN c_supplier(l_dup_acct_id);
1484: FETCH c_supplier INTO l_party_id;
1485: IF l_party_id IS NOT NULL THEN
1486: SELECT vendor_name, segment1 INTO l_supplier_name, l_supplier_number FROM ap_suppliers WHERE party_id = l_party_id;
1487: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT_SUPPLIER');
1488: fnd_message.set_Token('SUPPLIER',l_supplier_name);
1489: fnd_message.set_Token('SUPPLIERNUMBER',l_supplier_number);
1490: fnd_msg_pub.add;
1491: END IF;

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

1484: FETCH c_supplier INTO l_party_id;
1485: IF l_party_id IS NOT NULL THEN
1486: SELECT vendor_name, segment1 INTO l_supplier_name, l_supplier_number FROM ap_suppliers WHERE party_id = l_party_id;
1487: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT_SUPPLIER');
1488: fnd_message.set_Token('SUPPLIER',l_supplier_name);
1489: fnd_message.set_Token('SUPPLIERNUMBER',l_supplier_number);
1490: fnd_msg_pub.add;
1491: END IF;
1492: CLOSE c_supplier;*/

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

1485: IF l_party_id IS NOT NULL THEN
1486: SELECT vendor_name, segment1 INTO l_supplier_name, l_supplier_number FROM ap_suppliers WHERE party_id = l_party_id;
1487: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT_SUPPLIER');
1488: fnd_message.set_Token('SUPPLIER',l_supplier_name);
1489: fnd_message.set_Token('SUPPLIERNUMBER',l_supplier_number);
1490: fnd_msg_pub.add;
1491: END IF;
1492: CLOSE c_supplier;*/
1493: l_org_id := find_assignment_OU(l_dup_acct_id);

Line 1499: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT_OU');

1495: print_debuginfo('l_org_id'||l_org_id);
1496: END IF;
1497: IF l_org_id <> -1 THEN
1498: select name into l_org_name from hr_operating_units where organization_id = l_org_id;
1499: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT_OU');
1500: fnd_message.set_Token('OU', l_org_name);
1501: fnd_msg_pub.add;
1502: END IF;
1503: x_return_status := fnd_api.g_ret_sts_error;

Line 1500: fnd_message.set_Token('OU', l_org_name);

1496: END IF;
1497: IF l_org_id <> -1 THEN
1498: select name into l_org_name from hr_operating_units where organization_id = l_org_id;
1499: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT_OU');
1500: fnd_message.set_Token('OU', l_org_name);
1501: fnd_msg_pub.add;
1502: END IF;
1503: x_return_status := fnd_api.g_ret_sts_error;
1504: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1636: fnd_message.set_name('IBY', 'IBY_CUST_BANK_ACCT_VAL');

1632: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1633: print_debuginfo('Custom Validation Failed..');
1634: END IF;
1635: x_return_status := fnd_api.g_ret_sts_error;
1636: fnd_message.set_name('IBY', 'IBY_CUST_BANK_ACCT_VAL');
1637: fnd_message.set_Token('ERROR_MESSAGE',l_error_msg);
1638: fnd_msg_pub.add;
1639: RETURN;
1640: END IF;

Line 1637: fnd_message.set_Token('ERROR_MESSAGE',l_error_msg);

1633: print_debuginfo('Custom Validation Failed..');
1634: END IF;
1635: x_return_status := fnd_api.g_ret_sts_error;
1636: fnd_message.set_name('IBY', 'IBY_CUST_BANK_ACCT_VAL');
1637: fnd_message.set_Token('ERROR_MESSAGE',l_error_msg);
1638: fnd_msg_pub.add;
1639: RETURN;
1640: END IF;
1641:

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

1984: -- find branch number
1985: OPEN c_branch(p_ext_bank_acct_rec.branch_id);
1986: FETCH c_branch INTO l_branch_number;
1987: IF c_branch%NOTFOUND THEN
1988: fnd_message.set_name('IBY', 'IBY_API_NO_BRANCH');
1989: fnd_msg_pub.add;
1990: x_return_status := fnd_api.g_ret_sts_error;
1991: RAISE fnd_api.g_exc_error;
1992: ELSE

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

2391: l_old_iban,
2392: l_old_masked_iban,
2393: l_ba_elec_segment_id;
2394: IF c_ovn%NOTFOUND THEN
2395: fnd_message.set_name('IBY', 'IBY_API_NO_EXT_BANK_ACCT');
2396: fnd_msg_pub.add;
2397: x_return_status := fnd_api.g_ret_sts_error;
2398: CLOSE c_ovn;
2399: RAISE fnd_api.g_exc_error;

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

2403: print_debuginfo('Current object_version_number Version Number ' || l_old_ovn);
2404:
2405: END IF;
2406: IF l_old_ovn <> p_ext_bank_acct_rec.object_version_number THEN
2407: fnd_message.set_name('IBY', 'IBY_DATA_VERSION_ERROR');
2408: fnd_msg_pub.add;
2409: x_return_status := fnd_api.g_ret_sts_error;
2410: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2411: print_debuginfo('Error: Object Version Number Mismatch');

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

2423: p_ext_bank_acct_rec.branch_id,
2424: p_ext_bank_acct_rec.bank_account_id);
2425: FETCH uniq_check into l_count;
2426: IF (l_count > 1) THEN
2427: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT');
2428: fnd_msg_pub.add;
2429: x_return_status := fnd_api.g_ret_sts_error;
2430: RAISE fnd_api.g_exc_error;
2431: END IF;

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

2438: print_debuginfo('Duplicate account id:'||l_dup_acct_id);
2439: END IF;
2440: IF ((not x_return_status = fnd_api.g_ret_sts_success) OR
2441: (not l_dup_acct_id is null)) THEN
2442: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT');
2443: fnd_msg_pub.add;
2444: x_return_status := fnd_api.g_ret_sts_error;
2445: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2446: print_debuginfo('Error : Duplicate Bank Account');

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

2675: print_debuginfo('Duplicate account id:'||l_dup_acct_id);
2676: END IF;
2677: IF ((not x_return_status = fnd_api.g_ret_sts_success) OR
2678: (not l_dup_acct_id is null)) THEN
2679: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT');
2680: fnd_msg_pub.add;
2681: /*OPEN c_supplier(l_dup_acct_id);
2682: FETCH c_supplier INTO l_party_id;
2683: IF l_party_id IS NOT NULL THEN

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

2681: /*OPEN c_supplier(l_dup_acct_id);
2682: FETCH c_supplier INTO l_party_id;
2683: IF l_party_id IS NOT NULL THEN
2684: SELECT vendor_name, segment1 INTO l_supplier_name, l_supplier_number FROM ap_suppliers WHERE party_id = l_party_id;
2685: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT_SUPPLIER');
2686: fnd_message.set_Token('SUPPLIER',l_supplier_name);
2687: fnd_message.set_Token('SUPPLIERNUMBER',l_supplier_number);
2688: fnd_msg_pub.add;
2689: END IF;

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

2682: FETCH c_supplier INTO l_party_id;
2683: IF l_party_id IS NOT NULL THEN
2684: SELECT vendor_name, segment1 INTO l_supplier_name, l_supplier_number FROM ap_suppliers WHERE party_id = l_party_id;
2685: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT_SUPPLIER');
2686: fnd_message.set_Token('SUPPLIER',l_supplier_name);
2687: fnd_message.set_Token('SUPPLIERNUMBER',l_supplier_number);
2688: fnd_msg_pub.add;
2689: END IF;
2690: CLOSE c_supplier;*/

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

2683: IF l_party_id IS NOT NULL THEN
2684: SELECT vendor_name, segment1 INTO l_supplier_name, l_supplier_number FROM ap_suppliers WHERE party_id = l_party_id;
2685: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT_SUPPLIER');
2686: fnd_message.set_Token('SUPPLIER',l_supplier_name);
2687: fnd_message.set_Token('SUPPLIERNUMBER',l_supplier_number);
2688: fnd_msg_pub.add;
2689: END IF;
2690: CLOSE c_supplier;*/
2691: l_org_id := find_assignment_OU(l_dup_acct_id);

Line 2697: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT_OU');

2693: print_debuginfo('l_org_id::'||l_org_id);
2694: END IF;
2695: IF l_org_id <> -1 THEN
2696: select name into l_org_name from hr_operating_units where organization_id = l_org_id;
2697: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT_OU');
2698: fnd_message.set_Token('OU',l_org_name);
2699: fnd_msg_pub.add;
2700: END IF;
2701: x_return_status := fnd_api.g_ret_sts_error;

Line 2698: fnd_message.set_Token('OU',l_org_name);

2694: END IF;
2695: IF l_org_id <> -1 THEN
2696: select name into l_org_name from hr_operating_units where organization_id = l_org_id;
2697: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT_OU');
2698: fnd_message.set_Token('OU',l_org_name);
2699: fnd_msg_pub.add;
2700: END IF;
2701: x_return_status := fnd_api.g_ret_sts_error;
2702: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 2913: fnd_message.set_name('IBY', 'IBY_CUST_BANK_ACCT_VAL');

2909: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2910: print_debuginfo('Custom Validation Failed..');
2911: END IF;
2912: x_return_status := fnd_api.g_ret_sts_error;
2913: fnd_message.set_name('IBY', 'IBY_CUST_BANK_ACCT_VAL');
2914: fnd_message.set_Token('ERROR_MESSAGE',l_error_msg);
2915: fnd_msg_pub.add;
2916: RETURN;
2917: END IF;

Line 2914: fnd_message.set_Token('ERROR_MESSAGE',l_error_msg);

2910: print_debuginfo('Custom Validation Failed..');
2911: END IF;
2912: x_return_status := fnd_api.g_ret_sts_error;
2913: fnd_message.set_name('IBY', 'IBY_CUST_BANK_ACCT_VAL');
2914: fnd_message.set_Token('ERROR_MESSAGE',l_error_msg);
2915: fnd_msg_pub.add;
2916: RETURN;
2917: END IF;
2918:

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

3435:
3436: IF (p_end_date IS NOT NULL AND p_start_date > p_end_date) THEN
3437: -- throw exception if start date
3438: -- exceeds end_date
3439: fnd_message.set_name('IBY', 'IBY_START_END_DATE_BAD');
3440: fnd_msg_pub.add;
3441: RAISE fnd_api.g_exc_error;
3442: END IF;
3443:

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

3698: CLOSE uniq_check_generic;
3699: END IF;
3700:
3701: IF (SQL%NOTFOUND) THEN
3702: -- fnd_message.set_name('IBY', 'IBY_EXT_ACCT_NOT_EXIST');
3703: -- fnd_msg_pub.add;
3704: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3705: print_debuginfo('External Account does not exist ');
3706: END IF;

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

4039: -- check object version number to make sure the record has not been updated
4040: OPEN c_ovn;
4041: FETCH c_ovn INTO l_old_ovn;
4042: IF c_ovn%NOTFOUND THEN
4043: fnd_message.set_name('IBY', 'IBY_API_NO_INTERMEDIARY_ACCT');
4044: fnd_msg_pub.add;
4045: x_return_status := fnd_api.g_ret_sts_error;
4046: CLOSE c_ovn;
4047: RAISE fnd_api.g_exc_error;

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

4048: END IF;
4049: CLOSE c_ovn;
4050:
4051: IF l_old_ovn > p_intermed_acct_rec.object_version_number THEN
4052: fnd_message.set_name('IBY', 'IBY_DATA_VERSION_ERROR');
4053: fnd_msg_pub.add;
4054: x_return_status := fnd_api.g_ret_sts_error;
4055: RAISE fnd_api.g_exc_error;
4056: END IF;

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

4074: WHERE intermediary_acct_id = p_intermed_acct_rec.intermediary_acct_id
4075: RETURNING object_version_number INTO p_intermed_acct_rec.object_version_number;
4076:
4077: IF (SQL%NOTFOUND) THEN
4078: fnd_message.set_name('IBY', 'IBY_API_NO_INTERMEDIARY_ACCT');
4079: fnd_msg_pub.add;
4080: x_return_status := fnd_api.g_ret_sts_error;
4081: RAISE fnd_api.g_exc_error;
4082: END IF;

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

4200: FETCH uniq_check INTO l_count;
4201: CLOSE uniq_check;
4202:
4203: IF (l_count > 0) THEN
4204: fnd_message.set_name('IBY', 'IBY_ACCT_OWNER_EXISTS');
4205: fnd_msg_pub.add;
4206: x_return_status := fnd_api.g_ret_sts_error;
4207: RETURN;
4208: END IF;

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

4699:
4700: OPEN c_country;
4701: FETCH c_country INTO l_country;
4702: IF c_country%NOTFOUND THEN
4703: fnd_message.set_name('IBY', 'IBY_API_NO_BANK');
4704: fnd_msg_pub.add;
4705: x_return_status := fnd_api.g_ret_sts_error;
4706: END IF;
4707: CLOSE c_country;

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

4787:
4788: OPEN c_bank;
4789: FETCH c_bank INTO x_bank_id, x_country_code, x_bank_name, x_bank_number;
4790: IF c_bank%NOTFOUND THEN
4791: fnd_message.set_name('IBY', 'IBY_API_NO_BANK');
4792: fnd_msg_pub.add;
4793: x_return_status := fnd_api.g_ret_sts_error;
4794: END IF;
4795: CLOSE c_bank;

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

4826:
4827: BEGIN
4828:
4829: if (p_value is NULL) THEN
4830: fnd_message.set_name('IBY', 'IBY_MISSING_MANDATORY_PARAM');
4831: fnd_message.set_token('PARAM', fnd_message.get_string('IBY',p_field));
4832: fnd_msg_pub.add;
4833: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4834: print_debuginfo(fnd_message.get_string('IBY',p_field)|| ' is a required parameter.');

Line 4831: fnd_message.set_token('PARAM', fnd_message.get_string('IBY',p_field));

4827: BEGIN
4828:
4829: if (p_value is NULL) THEN
4830: fnd_message.set_name('IBY', 'IBY_MISSING_MANDATORY_PARAM');
4831: fnd_message.set_token('PARAM', fnd_message.get_string('IBY',p_field));
4832: fnd_msg_pub.add;
4833: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4834: print_debuginfo(fnd_message.get_string('IBY',p_field)|| ' is a required parameter.');
4835: END IF;

Line 4834: print_debuginfo(fnd_message.get_string('IBY',p_field)|| ' is a required parameter.');

4830: fnd_message.set_name('IBY', 'IBY_MISSING_MANDATORY_PARAM');
4831: fnd_message.set_token('PARAM', fnd_message.get_string('IBY',p_field));
4832: fnd_msg_pub.add;
4833: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4834: print_debuginfo(fnd_message.get_string('IBY',p_field)|| ' is a required parameter.');
4835: END IF;
4836: RAISE fnd_api.g_exc_error;
4837: END IF;
4838:

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

4843: FETCH c_validate_currency INTO l_temp;
4844: CLOSE c_validate_currency;
4845:
4846: IF (l_temp IS NULL) THEN
4847: fnd_message.set_name('IBY', 'IBY_INVALID_CURRENCY');
4848: fnd_message.set_token('CURRENCY_CODE', p_field);
4849: fnd_msg_pub.add;
4850: RAISE fnd_api.g_exc_error;
4851: END IF;

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

4844: CLOSE c_validate_currency;
4845:
4846: IF (l_temp IS NULL) THEN
4847: fnd_message.set_name('IBY', 'IBY_INVALID_CURRENCY');
4848: fnd_message.set_token('CURRENCY_CODE', p_field);
4849: fnd_msg_pub.add;
4850: RAISE fnd_api.g_exc_error;
4851: END IF;
4852:

Line 5667: fnd_message.set_name('IBY', l_err_code);

5663: IF (l_err_code IS NOT NULL) THEN
5664: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5665: print_debuginfo(l_module_name||': Sys key Validation Failed');
5666: END IF;
5667: fnd_message.set_name('IBY', l_err_code);
5668: fnd_msg_pub.add;
5669: return null;
5670: END IF;
5671: