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.CE_VALIDATE_BANKINFO dependencies on FND_MSG_PUB

Line 52: fnd_msg_pub.add;

48: IF (l_count_int > 0 OR l_count_ext > 0) THEN
49: fnd_message.set_name('CE', 'CE_BRANCH_END_DATE');
50: FND_MESSAGE.set_token('FIELD1', l_count_int, true);
51: FND_MESSAGE.set_token('FIELD2', l_count_ext, true);
52: fnd_msg_pub.add;
53: END IF;
54: cep_standard.debug('< 55: END;
56:

Line 106: FND_MSG_PUB.initialize;

102: BEGIN
103: cep_standard.debug('>>CE_VALIDATE_BANKINFO.ce_validate_bic');
104: -- Initialize message list if p_init_msg_list is set to TRUE.
105: IF FND_API.to_Boolean(p_init_msg_list) THEN
106: FND_MSG_PUB.initialize;
107: END IF;
108: -- initialize API return status to success.
109: x_return_status := fnd_api.g_ret_sts_success;
110:

Line 119: fnd_msg_pub.add;

115: l_string := nvl(length(ltrim(rtrim(replace(l_string, '0', ' ')))),'0') ;
116:
117: IF TO_NUMBER(l_string) > 0 THEN
118: fnd_message.set_name('CE', 'CE_INVALID_BIC_CODE');
119: fnd_msg_pub.add;
120: x_return_status := fnd_api.g_ret_sts_error;
121: END IF ;
122: ELSE
123: fnd_message.set_name('CE', 'CE_INVALID_BIC_LENGTH');

Line 124: fnd_msg_pub.add;

120: x_return_status := fnd_api.g_ret_sts_error;
121: END IF ;
122: ELSE
123: fnd_message.set_name('CE', 'CE_INVALID_BIC_LENGTH');
124: fnd_msg_pub.add;
125: x_return_status := fnd_api.g_ret_sts_error;
126: END IF ;
127:
128: FND_MSG_PUB.Count_And_Get(

Line 128: FND_MSG_PUB.Count_And_Get(

124: fnd_msg_pub.add;
125: x_return_status := fnd_api.g_ret_sts_error;
126: END IF ;
127:
128: FND_MSG_PUB.Count_And_Get(
129: p_encoded => FND_API.G_FALSE,
130: p_count => x_msg_count,
131: p_data => x_msg_data);
132:

Line 183: fnd_msg_pub.add;

179: cep_standard.debug('COMPARE_BANK_AND_BRANCH_NUM: ' ||
180: 'Bank number and branch number does not match'||
181: 'CE_BANK_BRANCH_NUM_NOT_MATCHED');
182: fnd_message.set_name('CE', 'CE_BANK_BRANCH_NUM_NOT_MATCHED');
183: fnd_msg_pub.add;
184: END IF;
185:
186: ELSE
187: -- Bank ID is being used. Check if Bank exists and fetch Bank Number --

Line 228: fnd_msg_pub.add;

224: cep_standard.debug('COMPARE_BANK_AND_BRANCH_NUM: ' ||
225: 'Bank number and branch number does not match'||
226: 'CE_BANK_BRANCH_NUM_NOT_MATCHED');
227: fnd_message.set_name('CE', 'CE_BANK_BRANCH_NUM_NOT_MATCHED');
228: fnd_msg_pub.add;
229: END IF;
230: END IF;
231: ELSIF (bank_count > 1)
232: THEN

Line 235: fnd_msg_pub.add;

231: ELSIF (bank_count > 1)
232: THEN
233: cep_standard.debug('COMPARE_BANK_AND_BRANCH_NUM: ' ||'EXCEPTION: More than one bank match ');
234: fnd_message.set_name('CE', 'CE_MANY_BANKS');
235: fnd_msg_pub.add;
236:
237: ELSIF (bank_count = 0)
238: THEN
239: cep_standard.debug('COMPARE_BANK_AND_BRANCH_NUM: ' || ' CE_BANK_DOES_NOT_EXISTS');

Line 241: fnd_msg_pub.add;

237: ELSIF (bank_count = 0)
238: THEN
239: cep_standard.debug('COMPARE_BANK_AND_BRANCH_NUM: ' || ' CE_BANK_DOES_NOT_EXISTS');
240: fnd_message.set_name ('CE', 'CE_BANK_DOES_NOT_EXISTS');
241: fnd_msg_pub.add;
242:
243: ELSE
244: cep_standard.debug('COMPARE_BANK_AND_BRANCH_NUM: ' || ' passed_check');
245: END IF;

Line 255: fnd_msg_pub.add;

251: WHEN OTHERS THEN
252: cep_standard.debug('CE_VALIDATE_BANKINFO.COMPARE_BANK_AND_BRANCH_NUM: Exception ' );
253: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
254: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.compare_bank_and_branch_num');
255: fnd_msg_pub.add;
256: RAISE;
257: END COMPARE_BANK_AND_BRANCH_NUM;
258:
259: /* --------------------------------------------------------------------

Line 293: fnd_msg_pub.add;

289: cep_standard.debug('COMPARE_ACCOUNT_NUM_AND_CD: ' || 'CD does not match'||
290: 'CE_ACCT_NUM_AND_CD_NOT_MATCHED');
291:
292: fnd_message.set_name('CE', 'CE_ACCT_NUM_AND_CD_NOT_MATCHED');
293: fnd_msg_pub.add;
294: RETURN FALSE;
295: ELSE
296: cep_standard.debug('COMPARE_ACCOUNT_NUM_AND_CD: ' || 'CD match');
297: RETURN TRUE;

Line 640: fnd_msg_pub.add;

636:
637: IF (nvl(temp_name,0) > 0) THEN
638: cep_standard.debug('CE_UNIQUE_BRANCH_NAME: ' || 'CE_BANK_BRANCH_NAME_EXISTS');
639: fnd_message.set_name('CE', 'CE_BANK_BRANCH_NAME_EXISTS');
640: fnd_msg_pub.add;
641: END IF;
642:
643: cep_standard.debug('< 644:

Line 718: fnd_msg_pub.add;

714:
715: IF (nvl(temp_number,0) > 0) THEN
716: cep_standard.debug('CE_UNIQUE_BRANCH_NAME: ' || 'CE_BANK_BRANCH_NUMBER_EXISTS');
717: fnd_message.set_name('CE', 'CE_BANK_BRANCH_NUMBER_EXISTS');
718: fnd_msg_pub.add;
719: END IF;
720:
721: cep_standard.debug('CE_UNIQUE_BRANCH_NAME: ' || '< 722: END CE_UNIQUE_BRANCH_NUMBER;

Line 792: fnd_msg_pub.add;

788:
789: IF (nvl(temp_name_alt,0) > 0) THEN
790: cep_standard.debug('CE_UNIQUE_BRANCH_NAME: ' || 'CE_BANK_BRANCH_NAME_ALT_EXISTS');
791: fnd_message.set_name('CE', 'CE_BANK_BRANCH_NAME_ALT_EXISTS');
792: fnd_msg_pub.add;
793: END IF;
794:
795: cep_standard.debug('< 796: END CE_UNIQUE_BRANCH_NAME_ALT;

Line 834: fnd_msg_pub.add;

830: cep_standard.debug('CE_UNIQUE_ACCOUNT_NAME: ' || 'temp_name: '||temp_name);
831:
832: IF (nvl(temp_name,0) > 0) THEN
833: fnd_message.set_name('CE', 'CE_BANK_ACCOUNT_NAME_EXISTS');
834: fnd_msg_pub.add;
835: cep_standard.debug('CE_UNIQUE_ACCOUNT_NAME: ' || 'CE_BANK_ACCOUNT_NAME_EXISTS');
836: END IF;
837:
838: cep_standard.debug('<

Line 881: FND_MSG_PUB.initialize;

877:
878: -- Initialize message list if p_init_msg_list is set to TRUE.
879: IF FND_API.to_Boolean(p_init_msg_list) THEN
880: x_init_count := 0;
881: FND_MSG_PUB.initialize;
882: ELSE
883: -- bug 7460921 Capturing the message stack count into the variable x_init_count
884: FND_MSG_PUB.Count_And_Get(
885: p_encoded => FND_API.G_FALSE,

Line 884: FND_MSG_PUB.Count_And_Get(

880: x_init_count := 0;
881: FND_MSG_PUB.initialize;
882: ELSE
883: -- bug 7460921 Capturing the message stack count into the variable x_init_count
884: FND_MSG_PUB.Count_And_Get(
885: p_encoded => FND_API.G_FALSE,
886: p_count => x_init_count,
887: p_data => x_msg_data);
888: END IF;

Line 970: FND_MSG_PUB.Count_And_Get(

966:
967: END IF; */
968: END IF; -- End Bug 6632733
969:
970: FND_MSG_PUB.Count_And_Get(
971: p_encoded => FND_API.G_FALSE,
972: p_count => x_msg_count,
973: p_data => x_msg_data);
974:

Line 989: fnd_msg_pub.add;

985: cep_standard.debug('Exception: CE_VALIDATE_BANKINFO.ce_validate_cd ' ||X_COUNTRY_NAME );
986:
987: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
988: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.cd_validate_cd');
989: fnd_msg_pub.add;
990: RAISE;
991: END CE_VALIDATE_CD;
992:
993:

Line 1046: FND_MSG_PUB.initialize;

1042: cep_standard.debug('l_value_out: '|| l_value_out);
1043:
1044: -- Initialize message list if p_init_msg_list is set to TRUE.
1045: IF FND_API.to_Boolean(p_init_msg_list) THEN
1046: FND_MSG_PUB.initialize;
1047: END IF;
1048:
1049: /* We must validate the Bank Branch Number */
1050: IF X_BRANCH_NUMBER IS NULL THEN

Line 1181: l_count_before_custom := Nvl(FND_MSG_PUB.count_msg,0);

1177: -- bug 14610187: Unique validation check have been moved after the
1178: -- custom validations as they might modify the branch number.
1179:
1180: -- 9250566 ADDED 1/6 START -------------------------
1181: l_count_before_custom := Nvl(FND_MSG_PUB.count_msg,0);
1182: l_usr_valid := fnd_api.g_ret_sts_success;
1183:
1184: -- Call to custom validation routines
1185: cep_standard.debug('Calling custom validation hooks');

Line 1202: l_count_after_custom := FND_MSG_PUB.count_msg;

1198: Xo_BRANCH_NUM_OUT => l_value_out_custom,
1199: Xo_RETURN_STATUS => l_usr_valid
1200: );
1201:
1202: l_count_after_custom := FND_MSG_PUB.count_msg;
1203: cep_standard.debug('l_count_before=' ||l_count_before_custom);
1204:
1205: cep_standard.debug('l_value_out_custom='||l_value_out_custom);
1206: X_VALUE_OUT := NVL(l_value_out_custom,l_value_out);

Line 1248: FND_MSG_PUB.delete_msg(l_count_after_custom);

1244: cep_standard.debug('Custom validations done - success');
1245: -- remove any unnecessary messages
1246: WHILE l_count_after_custom > l_count_before_custom
1247: LOOP
1248: FND_MSG_PUB.delete_msg(l_count_after_custom);
1249: l_count_after_custom := l_count_after_custom - 1;
1250: cep_standard.debug(l_count_after_custom);
1251: END LOOP;
1252: cep_standard.debug('After cleanup, count='||FND_MSG_PUB.count_msg);

Line 1252: cep_standard.debug('After cleanup, count='||FND_MSG_PUB.count_msg);

1248: FND_MSG_PUB.delete_msg(l_count_after_custom);
1249: l_count_after_custom := l_count_after_custom - 1;
1250: cep_standard.debug(l_count_after_custom);
1251: END LOOP;
1252: cep_standard.debug('After cleanup, count='||FND_MSG_PUB.count_msg);
1253:
1254: END IF;
1255: -- 9250566 ADDED 1/6 END --------------------------
1256:

Line 1257: FND_MSG_PUB.Count_And_Get(

1253:
1254: END IF;
1255: -- 9250566 ADDED 1/6 END --------------------------
1256:
1257: FND_MSG_PUB.Count_And_Get(
1258: p_encoded => FND_API.G_FALSE,
1259: p_count => x_msg_count,
1260: p_data => x_msg_data);
1261:

Line 1276: fnd_msg_pub.add;

1272: WHEN OTHERS THEN
1273: cep_standard.debug('EXCEPTION: ce_validate_branch ' ||X_COUNTRY_NAME );
1274: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
1275: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.cd_validate_branch');
1276: fnd_msg_pub.add;
1277: RAISE;
1278: END CE_VALIDATE_BRANCH;
1279:
1280: /* ----------------------------------------------------------------------- */

Line 1450: FND_MSG_PUB.initialize;

1446: cep_standard.debug('Validations are Disabled.No formatting done.');
1447: ELSE
1448: -- Initialize message list if p_init_msg_list is set to TRUE.
1449: IF FND_API.to_Boolean(p_init_msg_list) THEN
1450: FND_MSG_PUB.initialize;
1451: END IF;
1452: IF (COUNTRY_NAME = 'BE') THEN
1453: CE_VALIDATE_BANKINFO.CE_FORMAT_ELECTRONIC_NUM_BE(
1454: X_ACCOUNT_NUMBER ,

Line 1484: FND_MSG_PUB.Count_And_Get(

1480: X_ACCOUNT_CLASSIFICATION,
1481: X_ELECTRONIC_ACCT_NUM);
1482:
1483: END IF;
1484: FND_MSG_PUB.Count_And_Get(
1485: p_encoded => FND_API.G_FALSE,
1486: p_count => x_msg_count,
1487: p_data => x_msg_data);
1488: END IF;--Bug number 13096191 added

Line 1500: fnd_msg_pub.add;

1496: WHEN OTHERS THEN
1497: cep_standard.debug('EXCEPTION: CE_FORMAT_ELECTRONIC_NUM ' ||X_COUNTRY_NAME );
1498: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
1499: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.CE_FORMAT_ELECTRONIC_NUM');
1500: fnd_msg_pub.add;
1501: RAISE;
1502: END CE_FORMAT_ELECTRONIC_NUM;
1503:
1504: /* --------------------------------------------------------------------

Line 1560: FND_MSG_PUB.initialize;

1556: cep_standard.debug('COUNTRY_NAME: '|| COUNTRY_NAME||', l_value_out: '|| l_value_out);
1557:
1558: -- Initialize message list if p_init_msg_list is set to TRUE.
1559: IF FND_API.to_Boolean(p_init_msg_list) THEN
1560: FND_MSG_PUB.initialize;
1561: END IF;
1562:
1563: /* We must validate the Bank Account Number */
1564: IF X_ACCOUNT_NUMBER is null THEN

Line 1749: l_count_before_custom := Nvl(FND_MSG_PUB.count_msg,0);

1745:
1746: cep_standard.debug('CE_VALIDATE_ACCOUNT: X_ELECTRONIC_ACCT_NUM: '|| X_ELECTRONIC_ACCT_NUM);
1747:
1748: -- 9250566 ADDED 2/6 START -------------------------
1749: l_count_before_custom := Nvl(FND_MSG_PUB.count_msg,0);
1750: l_usr_valid := fnd_api.g_ret_sts_success;
1751:
1752: -- Call to custom validation routines
1753: cep_standard.debug('Calling custom validation hooks');

Line 1775: l_count_after_custom := FND_MSG_PUB.count_msg;

1771: Xo_ACCOUNT_NUM_OUT => l_value_out_custom,
1772: Xo_RETURN_STATUS => l_usr_valid
1773: );
1774:
1775: l_count_after_custom := FND_MSG_PUB.count_msg;
1776: cep_standard.debug('l_count_before='||l_count_before_custom);
1777:
1778: cep_standard.debug('l_value_out_custom='||l_value_out_custom);
1779: X_VALUE_OUT := NVL(l_value_out_custom,l_value_out);

Line 1793: FND_MSG_PUB.delete_msg(l_count_after_custom);

1789: cep_standard.debug('Custom validations done - success');
1790: -- remove any unnecessary messages
1791: WHILE l_count_after_custom > l_count_before_custom
1792: LOOP
1793: FND_MSG_PUB.delete_msg(l_count_after_custom);
1794: l_count_after_custom := l_count_after_custom - 1;
1795: cep_standard.debug(l_count_after_custom);
1796: END LOOP;
1797: cep_standard.debug('After cleanup, count='||FND_MSG_PUB.count_msg);

Line 1797: cep_standard.debug('After cleanup, count='||FND_MSG_PUB.count_msg);

1793: FND_MSG_PUB.delete_msg(l_count_after_custom);
1794: l_count_after_custom := l_count_after_custom - 1;
1795: cep_standard.debug(l_count_after_custom);
1796: END LOOP;
1797: cep_standard.debug('After cleanup, count='||FND_MSG_PUB.count_msg);
1798:
1799: END IF;
1800: -- 9250566 2/6 ADDED END --------------------------
1801:

Line 1802: FND_MSG_PUB.Count_And_Get(

1798:
1799: END IF;
1800: -- 9250566 2/6 ADDED END --------------------------
1801:
1802: FND_MSG_PUB.Count_And_Get(
1803: p_encoded => FND_API.G_FALSE,
1804: p_count => x_msg_count,
1805: p_data => x_msg_data);
1806:

Line 1819: fnd_msg_pub.add;

1815: WHEN OTHERS THEN
1816: cep_standard.debug('EXCEPTION: ce_validate_account ' ||X_COUNTRY_NAME );
1817: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
1818: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.ce_validate_account');
1819: fnd_msg_pub.add;
1820: RAISE;
1821: END CE_VALIDATE_ACCOUNT;
1822:
1823: /* --------------------------------------------------------------------

Line 1870: FND_MSG_PUB.initialize;

1866: ', l_value_out: '|| l_value_out);
1867:
1868: -- Initialize message list if p_init_msg_list is set to TRUE.
1869: IF FND_API.to_Boolean(p_init_msg_list) THEN
1870: FND_MSG_PUB.initialize;
1871: END IF;
1872:
1873: /* We must validate the Bank Number */
1874: IF X_BANK_NUMBER is null THEN

Line 1990: l_count_before_custom := Nvl(FND_MSG_PUB.count_msg,0);

1986:
1987: END IF; /* country unique check for bank */
1988:
1989: -- 9250566 ADDED 3/6 START -------------------------
1990: l_count_before_custom := Nvl(FND_MSG_PUB.count_msg,0);
1991: l_usr_valid := fnd_api.g_ret_sts_success;
1992:
1993: -- Call to custom validation routines
1994: cep_standard.debug('Calling custom validation hooks');

Line 2007: l_count_after_custom := FND_MSG_PUB.count_msg;

2003: Xi_BANK_ID => X_BANK_ID,
2004: Xo_BANK_NUM_OUT => l_value_out_custom,
2005: Xo_RETURN_STATUS => l_usr_valid);
2006:
2007: l_count_after_custom := FND_MSG_PUB.count_msg;
2008: cep_standard.debug('l_count_before='||l_count_before_custom);
2009:
2010: cep_standard.debug('l_value_out_custom='||l_value_out_custom);
2011: X_VALUE_OUT := NVL(l_value_out_custom,l_value_out);

Line 2024: FND_MSG_PUB.delete_msg(l_count_after_custom);

2020: cep_standard.debug('Custom validations done - success');
2021: -- remove any unnecessary messages
2022: WHILE l_count_after_custom > l_count_before_custom
2023: LOOP
2024: FND_MSG_PUB.delete_msg(l_count_after_custom);
2025: l_count_after_custom := l_count_after_custom - 1;
2026: cep_standard.debug(l_count_after_custom);
2027: END LOOP;
2028: cep_standard.debug('After cleanup, count='||FND_MSG_PUB.count_msg);

Line 2028: cep_standard.debug('After cleanup, count='||FND_MSG_PUB.count_msg);

2024: FND_MSG_PUB.delete_msg(l_count_after_custom);
2025: l_count_after_custom := l_count_after_custom - 1;
2026: cep_standard.debug(l_count_after_custom);
2027: END LOOP;
2028: cep_standard.debug('After cleanup, count='||FND_MSG_PUB.count_msg);
2029:
2030: END IF;
2031: -- 9250566 ADDED 3/6 END --------------------------
2032:

Line 2033: FND_MSG_PUB.Count_And_Get(

2029:
2030: END IF;
2031: -- 9250566 ADDED 3/6 END --------------------------
2032:
2033: FND_MSG_PUB.Count_And_Get(
2034: p_encoded => FND_API.G_FALSE,
2035: p_count => x_msg_count,
2036: p_data => x_msg_data);
2037:

Line 2051: fnd_msg_pub.add;

2047: WHEN OTHERS THEN
2048: cep_standard.debug('CE_VALIDATE_BANKINFO.ce_validate_bank ' ||X_COUNTRY_NAME );
2049: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
2050: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.cd_validate_bank');
2051: fnd_msg_pub.add;
2052: RAISE;
2053: END CE_VALIDATE_BANK;
2054:
2055:

Line 2134: -- set the value for the tokens and add message to FND_MSG_PUB --

2130: ELSIF p_Error = 'INVALID_RTN' THEN mesg_name := 'CE_FIELD_INVALID_RTN';
2131: END IF;
2132:
2133: cep_standard.debug('mesg_name = '||mesg_name);
2134: -- set the value for the tokens and add message to FND_MSG_PUB --
2135: FND_MESSAGE.set_name('CE', mesg_name);
2136: FND_MESSAGE.set_token('FIELD', field_name, true);
2137:
2138: -- For length related errors, need to populate the VALUE token --

Line 2157: FND_MSG_PUB.add;

2153: FND_MESSAGE.set_token('VALUE', length_val, true);
2154: END IF;
2155:
2156: -- populate the message queue
2157: FND_MSG_PUB.add;
2158:
2159: cep_standard.debug('< 2160: END CE_FAILED_CHECK;
2161:

Line 2198: FND_MSG_PUB.add;

2194:
2195: cep_standard.debug('mesg_name = '||mesg_name);
2196:
2197: FND_MESSAGE.set_name('CE', mesg_name);
2198: FND_MSG_PUB.add;
2199:
2200: cep_standard.debug('< 2201: END CE_FAILED_MANDATORY;
2202:

Line 6038: fnd_msg_pub.add;

6034:
6035: IF (l_supp = 'bk3' OR l_cust= 'bk2' OR l_comp = 'bk1')
6036: THEN
6037: FND_MESSAGE.SET_NAME('CE','CE_TAXID_EXIST');
6038: fnd_msg_pub.add;
6039: END IF;
6040: IF (l_supp = 'bk5')
6041: THEN
6042: FND_MESSAGE.SET_NAME('CE','CE_TAXID_BANK_EXIST_AS_SUPP');

Line 6043: fnd_msg_pub.add;

6039: END IF;
6040: IF (l_supp = 'bk5')
6041: THEN
6042: FND_MESSAGE.SET_NAME('CE','CE_TAXID_BANK_EXIST_AS_SUPP');
6043: fnd_msg_pub.add;
6044: END IF;
6045: IF (l_cust = 'bk4')
6046: THEN
6047: FND_MESSAGE.SET_NAME('CE','CE_TAXID_BANK_EXIST_AS_CUST');

Line 6048: fnd_msg_pub.add;

6044: END IF;
6045: IF (l_cust = 'bk4')
6046: THEN
6047: FND_MESSAGE.SET_NAME('CE','CE_TAXID_BANK_EXIST_AS_CUST');
6048: fnd_msg_pub.add;
6049: END IF;
6050: IF (l_comp = 'bk6') THEN
6051: FND_MESSAGE.SET_NAME('CE','CE_TAXID_BANK_EXIST_AS_COMP');
6052: fnd_msg_pub.add;

Line 6052: fnd_msg_pub.add;

6048: fnd_msg_pub.add;
6049: END IF;
6050: IF (l_comp = 'bk6') THEN
6051: FND_MESSAGE.SET_NAME('CE','CE_TAXID_BANK_EXIST_AS_COMP');
6052: fnd_msg_pub.add;
6053: END IF;
6054: IF ce_tax_id_check_algorithm(TAX_ID,Xi_COUNTRY_NAME,TAX_ID_CD) = 'FALSE'
6055: THEN
6056: ce_failed_check('TAX_PAYER_ID','CD_FAILED');

Line 6060: fnd_msg_pub.add;

6056: ce_failed_check('TAX_PAYER_ID','CD_FAILED');
6057: END IF; /* end of check digit validation */
6058: ELSE
6059: fnd_message.set_name ('CE', 'CE_TAX_PAYER_ID_NOT_UNIQUE');
6060: fnd_msg_pub.add;
6061: END IF; /* end of unique check */
6062: ELSE
6063: ce_failed_check('TAX_PAYER_ID','NUMERIC');
6064: END IF; /* end of numeric check */

Line 6372: fnd_msg_pub.add;

6368:
6369: IF (nvl(temp_number,0) > 0) THEN
6370: cep_standard.debug('CE_VALIDATE_UNIQUE_ACCOUNT: ' || 'CE_BANK_ACCOUNT_NUM_EXISTS');
6371: fnd_message.set_name('CE', 'CE_BANK_ACCOUNT_NUM_EXISTS');
6372: fnd_msg_pub.add;
6373: END IF;
6374:
6375: -- unique combination -> bank_branch_id, bank account name
6376: -- Bug 7836516 removed this check

Line 6410: fnd_msg_pub.add;

6406: cep_standard.debug('CE_VALIDATE_UNIQUE_ACCOUNT: ' || 'temp_number: '||temp_number);
6407:
6408: IF (nvl(temp_number,0) > 0) THEN
6409: fnd_message.set_name('CE', 'CE_BANK_ACCOUNT_NUM_EXISTS');
6410: fnd_msg_pub.add;
6411: cep_standard.debug('CE_VALIDATE_UNIQUE_ACCOUNT: ' || 'CE_BANK_ACCOUNT_NUM_EXISTS');
6412: END IF;
6413:
6414: -- unique combination -> bank_branch_id, bank account name

Line 6452: fnd_msg_pub.add;

6448:
6449: IF (nvl(temp_number,0) > 0) THEN
6450: cep_standard.debug('CE_VALIDATE_UNIQUE_ACCOUNT: ' || 'CE_BANK_ACCOUNT_NUM_EXISTS');
6451: fnd_message.set_name('CE', 'CE_BANK_ACCOUNT_NUM_EXISTS');
6452: fnd_msg_pub.add;
6453: END IF;
6454:
6455: -- unique combination -> bank_branch_id, bank account name
6456: -- Bug 7836516 removed this check

Line 6533: fnd_msg_pub.add;

6529:
6530: IF (nvl(l_temp_number,0) > 0) THEN
6531: cep_standard.debug('Branch already exists');
6532: fnd_message.set_name('CE', 'CE_BANK_BRANCH_EXISTS');
6533: fnd_msg_pub.add;
6534: END IF;
6535:
6536:
6537: cep_standard.debug('<

Line 6630: fnd_msg_pub.add;

6626:
6627: IF (nvl(temp_name_alt,0) > 0) THEN
6628: cep_standard.debug('CE_VALIDATE_UNIQUE_BANK_JP: ' || 'CE_BANK_NAME_ALT_EXISTS');
6629: fnd_message.set_name('CE', 'CE_BANK_NAME_ALT_EXISTS');
6630: fnd_msg_pub.add;
6631: END IF;
6632:
6633: cep_standard.debug('< 6634: END CE_VALIDATE_UNIQUE_BANK_JP;

Line 6656: fnd_msg_pub.add;

6652:
6653: procedure fail_mandatory is
6654: begin
6655: fnd_message.set_name ('CE', 'CE_ENTER_EFT_NUMBER');
6656: fnd_msg_pub.add;
6657: cep_standard.debug('CE_VALIDATE_MISC_EFT_NUM: ' || 'CE_ENTER_EFT_NUMBER');
6658: end fail_mandatory;
6659:
6660: procedure fail_check is

Line 6663: fnd_msg_pub.add;

6659:
6660: procedure fail_check is
6661: begin
6662: fnd_message.set_name ('CE', 'CE_INVALID_EFT_NUMBER');
6663: fnd_msg_pub.add;
6664: cep_standard.debug('CE_VALIDATE_MISC_EFT_NUM: ' || 'CE_INVALID_EFT_NUMBER');
6665: end fail_check;
6666:
6667: procedure pass_check is

Line 6682: FND_MSG_PUB.initialize;

6678: cep_standard.debug('CE_VALIDATE_MISC_EFT_NUM - COUNTRY_NAME: '|| COUNTRY_NAME);
6679:
6680: -- Initialize message list if p_init_msg_list is set to TRUE.
6681: IF FND_API.to_Boolean(p_init_msg_list) THEN
6682: FND_MSG_PUB.initialize;
6683: END IF;
6684:
6685: EFT_NUM_VALUE := upper(replace(X_EFT_NUMBER,' ',''));
6686: EFT_NUM_VALUE := replace(EFT_NUM_VALUE,'-','');

Line 6708: FND_MSG_PUB.Count_And_Get(

6704: ELSE -- other countries pass_check
6705: pass_check;
6706: END IF; -- end of country_name
6707:
6708: FND_MSG_PUB.Count_And_Get(
6709: p_encoded => FND_API.G_FALSE,
6710: p_count => x_msg_count,
6711: p_data => x_msg_data);
6712:

Line 6725: fnd_msg_pub.add;

6721: WHEN OTHERS THEN
6722: cep_standard.debug('CE_VALIDATE_BANKINFO.CE_VALIDATE_MISC_EFT_NUM ' ||X_COUNTRY_NAME );
6723: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
6724: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.cd_validate_misc_eft_num');
6725: fnd_msg_pub.add;
6726: RAISE;
6727: END CE_VALIDATE_MISC_EFT_NUM;
6728:
6729: /* -------------------------------------------------------------------- */

Line 6747: fnd_msg_pub.add;

6743:
6744: procedure fail_mandatory is
6745: begin
6746: fnd_message.set_name ('CE', 'CE_ENTER_ACCOUNT_HOLDER_ALT');
6747: fnd_msg_pub.add;
6748: cep_standard.debug('CE_VALIDATE_MISC_ACCT_HLDR_ALT: ' || 'CE_ENTER_ACCOUNT_HOLDER_ALT');
6749: end fail_mandatory;
6750:
6751: procedure pass_check is

Line 6767: FND_MSG_PUB.initialize;

6763: cep_standard.debug('CE_VALIDATE_MISC_ACCT_HLDR_ALT - COUNTRY_NAME: '|| COUNTRY_NAME);
6764:
6765: -- Initialize message list if p_init_msg_list is set to TRUE.
6766: IF FND_API.to_Boolean(p_init_msg_list) THEN
6767: FND_MSG_PUB.initialize;
6768: END IF;
6769:
6770: ACCOUNT_HOLDER_ALT := X_ACCOUNT_HOLDER_ALT;
6771: IF (COUNTRY_NAME = 'JP') THEN

Line 6781: FND_MSG_PUB.Count_And_Get(

6777: ELSE -- other countries pass_check
6778: pass_check;
6779: END IF; -- end of country_name
6780:
6781: FND_MSG_PUB.Count_And_Get(
6782: p_encoded => FND_API.G_FALSE,
6783: p_count => x_msg_count,
6784: p_data => x_msg_data);
6785:

Line 6797: fnd_msg_pub.add;

6793: WHEN OTHERS THEN
6794: cep_standard.debug('CE_VALIDATE_BANKINFO.CE_VALIDATE_MISC_ACCT_HLDR_ALT ' ||X_COUNTRY_NAME );
6795: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
6796: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.cd_validate_misc_acct_hldr_alt');
6797: fnd_msg_pub.add;
6798: RAISE;
6799: END CE_VALIDATE_MISC_ACCT_HLDR_ALT;
6800:
6801: -- added 12/18/06

Line 6870: fnd_msg_pub.add;

6866:
6867: procedure fail_mandatory is
6868: begin
6869: fnd_message.set_name ('CE', 'CE_ENTER_BRANCH_NUM');
6870: fnd_msg_pub.add;
6871: cep_standard.debug('GET_BRANCH_NUM_FORMAT: ' || 'CE_ENTER_BRANCH_NUM');
6872: end fail_mandatory;
6873:
6874: BEGIN

Line 6887: FND_MSG_PUB.initialize;

6883: cep_standard.debug('X_VALUE_OUT: '|| X_VALUE_OUT);
6884:
6885: -- Initialize message list if p_init_msg_list is set to TRUE.
6886: IF FND_API.to_Boolean(p_init_msg_list) THEN
6887: FND_MSG_PUB.initialize;
6888: END IF;
6889:
6890: /* We must validate the Bank Branch Number */
6891: IF X_BRANCH_NUMBER is null THEN

Line 6939: FND_MSG_PUB.Count_And_Get(

6935: ELSE
6936: fail_mandatory;
6937: END IF;
6938:
6939: FND_MSG_PUB.Count_And_Get(
6940: p_encoded => FND_API.G_FALSE,
6941: p_count => x_msg_count,
6942: p_data => x_msg_data);
6943:

Line 6957: fnd_msg_pub.add;

6953: WHEN OTHERS THEN
6954: cep_standard.debug('CE_VALIDATE_BANKINFO.GET_BRANCH_NUM_FORMAT ' ||X_COUNTRY_NAME );
6955: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
6956: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.GET_BRANCH_NUM_FORMAT');
6957: fnd_msg_pub.add;
6958: RAISE;
6959: END GET_BRANCH_NUM_FORMAT;
6960:
6961: -- bug 6856840 : Added procedure

Line 7099: FND_MSG_PUB.initialize;

7095: ', X_VALUE_OUT: '|| X_VALUE_OUT);
7096:
7097: -- Initialize message list if p_init_msg_list is set to TRUE.
7098: IF FND_API.to_Boolean(p_init_msg_list) THEN
7099: FND_MSG_PUB.initialize;
7100: END IF;
7101:
7102: cep_standard.debug('P_INIT_MSG_LIST: '|| P_INIT_MSG_LIST);
7103:

Line 7120: FND_MSG_PUB.Count_And_Get(

7116:
7117: END IF; /* country unique check for bank */
7118: cep_standard.debug('CE_VALIDATE_CD: ' || 'UNIQUE VALIDATION CHECK for bank end' );
7119:
7120: FND_MSG_PUB.Count_And_Get(
7121: p_encoded => FND_API.G_FALSE,
7122: p_count => x_msg_count,
7123: p_data => x_msg_data);
7124:

Line 7137: fnd_msg_pub.add;

7133: WHEN OTHERS THEN
7134: cep_standard.debug('CE_VALIDATE_BANKINFO.upd_bank_unique ' ||X_COUNTRY_NAME );
7135: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
7136: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.upd_bank_unique');
7137: fnd_msg_pub.add;
7138: RAISE;
7139: END UPD_BANK_UNIQUE;
7140:
7141: /* -------------------------------------------------------------------

Line 7186: FND_MSG_PUB.initialize;

7182: ', l_value_out: '|| l_value_out);
7183:
7184: -- Initialize message list if p_init_msg_list is set to TRUE.
7185: IF FND_API.to_Boolean(p_init_msg_list) THEN
7186: FND_MSG_PUB.initialize;
7187: END IF;
7188:
7189: cep_standard.debug('CE_VALIDATE_BANKINFO.upd_bank_validate - P_INIT_MSG_LIST: '|| P_INIT_MSG_LIST);
7190:

Line 7295: l_count_before_custom := Nvl(FND_MSG_PUB.count_msg,0);

7291:
7292: END IF; /* country check for bank */
7293:
7294: -- 9250566 ADDED 4/6 START -------------------------
7295: l_count_before_custom := Nvl(FND_MSG_PUB.count_msg,0);
7296: l_usr_valid := fnd_api.g_ret_sts_success;
7297:
7298: -- Call to custom validation routines
7299: cep_standard.debug('Calling custom validation hooks');

Line 7312: l_count_after_custom := FND_MSG_PUB.count_msg;

7308: Xi_BANK_ID => X_BANK_ID,
7309: Xo_BANK_NUM_OUT => l_value_out_custom,
7310: Xo_RETURN_STATUS => l_usr_valid
7311: );
7312: l_count_after_custom := FND_MSG_PUB.count_msg;
7313: cep_standard.debug('l_count_before='||l_count_before_custom);
7314:
7315: cep_standard.debug('l_value_out_custom='||l_value_out_custom);
7316: X_VALUE_OUT := NVL(l_value_out_custom,l_value_out);

Line 7330: FND_MSG_PUB.delete_msg(l_count_after_custom);

7326: cep_standard.debug('Custom validations done - success');
7327: -- remove any unnecessary messages
7328: WHILE l_count_after_custom > l_count_before_custom
7329: LOOP
7330: FND_MSG_PUB.delete_msg(l_count_after_custom);
7331: l_count_after_custom := l_count_after_custom - 1;
7332: cep_standard.debug(l_count_after_custom);
7333: END LOOP;
7334: cep_standard.debug('After cleanup, count='||FND_MSG_PUB.count_msg);

Line 7334: cep_standard.debug('After cleanup, count='||FND_MSG_PUB.count_msg);

7330: FND_MSG_PUB.delete_msg(l_count_after_custom);
7331: l_count_after_custom := l_count_after_custom - 1;
7332: cep_standard.debug(l_count_after_custom);
7333: END LOOP;
7334: cep_standard.debug('After cleanup, count='||FND_MSG_PUB.count_msg);
7335:
7336: END IF;
7337: -- 9250566 ADDED 4/6 END --------------------------
7338:

Line 7340: FND_MSG_PUB.Count_And_Get(

7336: END IF;
7337: -- 9250566 ADDED 4/6 END --------------------------
7338:
7339:
7340: FND_MSG_PUB.Count_And_Get(
7341: p_encoded => FND_API.G_FALSE,
7342: p_count => x_msg_count,
7343: p_data => x_msg_data);
7344:

Line 7357: fnd_msg_pub.add;

7353: WHEN OTHERS THEN
7354: cep_standard.debug('EXCEPTION: upd_bank_validate' ||X_COUNTRY_NAME );
7355: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
7356: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.upd_bank_validate');
7357: fnd_msg_pub.add;
7358: RAISE;
7359: END UPD_BANK_VALIDATE;
7360:
7361: /* -------------------------------------------------------------------

Line 7403: FND_MSG_PUB.initialize;

7399: ', X_VALUE_OUT: '|| X_VALUE_OUT);
7400:
7401: -- Initialize message list if p_init_msg_list is set to TRUE.
7402: IF FND_API.to_Boolean(p_init_msg_list) THEN
7403: FND_MSG_PUB.initialize;
7404: END IF;
7405:
7406: /* UNIQUE VALIDATION CHECK for branch */
7407: cep_standard.debug('UNIQUE VALIDATION CHECK for branch' );

Line 7445: FND_MSG_PUB.Count_And_Get(

7441: X_BRANCH_ID);
7442: END IF;
7443: /* end country unique check for branch */
7444:
7445: FND_MSG_PUB.Count_And_Get(
7446: p_encoded => FND_API.G_FALSE,
7447: p_count => x_msg_count,
7448: p_data => x_msg_data);
7449:

Line 7463: fnd_msg_pub.add;

7459: WHEN OTHERS THEN
7460: cep_standard.debug('EXCEPTION: upd_branch_unique ' ||X_COUNTRY_NAME );
7461: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
7462: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.upd_branch_unique');
7463: fnd_msg_pub.add;
7464: RAISE;
7465: END UPD_BRANCH_UNIQUE;
7466:
7467:

Line 7518: FND_MSG_PUB.initialize;

7514: cep_standard.debug('l_value_out: '|| l_value_out);
7515:
7516: -- Initialize message list if p_init_msg_list is set to TRUE.
7517: IF FND_API.to_Boolean(p_init_msg_list) THEN
7518: FND_MSG_PUB.initialize;
7519: END IF;
7520:
7521: /* We must validate the Bank Branch Number */
7522: IF X_BRANCH_NUMBER IS NULL THEN

Line 7641: l_count_before_custom := Nvl(FND_MSG_PUB.count_msg,0);

7637:
7638: END IF;
7639:
7640: -- 9250566 ADDED 5/6 START -------------------------
7641: l_count_before_custom := Nvl(FND_MSG_PUB.count_msg,0);
7642: l_usr_valid := fnd_api.g_ret_sts_success;
7643:
7644: -- Call to custom validation routines
7645: cep_standard.debug('Calling custom validation hooks');

Line 7662: l_count_after_custom := FND_MSG_PUB.count_msg;

7658: Xo_BRANCH_NUM_OUT => l_value_out_custom,
7659: Xo_RETURN_STATUS => l_usr_valid
7660: );
7661:
7662: l_count_after_custom := FND_MSG_PUB.count_msg;
7663: cep_standard.debug('l_count_before='||l_count_before_custom);
7664:
7665: cep_standard.debug('l_value_out_custom='||l_value_out_custom);
7666: X_VALUE_OUT := l_value_out_custom;

Line 7680: FND_MSG_PUB.delete_msg(l_count_after_custom);

7676: cep_standard.debug('Custom validations done - success');
7677: -- remove any unnecessary messages
7678: WHILE l_count_after_custom > l_count_before_custom
7679: LOOP
7680: FND_MSG_PUB.delete_msg(l_count_after_custom);
7681: l_count_after_custom := l_count_after_custom - 1;
7682: cep_standard.debug(l_count_after_custom);
7683: END LOOP;
7684: cep_standard.debug('After cleanup, count='||FND_MSG_PUB.count_msg);

Line 7684: cep_standard.debug('After cleanup, count='||FND_MSG_PUB.count_msg);

7680: FND_MSG_PUB.delete_msg(l_count_after_custom);
7681: l_count_after_custom := l_count_after_custom - 1;
7682: cep_standard.debug(l_count_after_custom);
7683: END LOOP;
7684: cep_standard.debug('After cleanup, count='||FND_MSG_PUB.count_msg);
7685:
7686: END IF;
7687: -- 9250566 5/6 ADDED END --------------------------
7688:

Line 7689: FND_MSG_PUB.Count_And_Get(

7685:
7686: END IF;
7687: -- 9250566 5/6 ADDED END --------------------------
7688:
7689: FND_MSG_PUB.Count_And_Get(
7690: p_encoded => FND_API.G_FALSE,
7691: p_count => x_msg_count,
7692: p_data => x_msg_data);
7693:

Line 7707: fnd_msg_pub.add;

7703: WHEN OTHERS THEN
7704: cep_standard.debug('EXCEPTION: upd_branch_validate ' ||X_COUNTRY_NAME );
7705: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
7706: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.upd_branch_validate');
7707: fnd_msg_pub.add;
7708: RAISE;
7709: END UPD_BRANCH_VALIDATE;
7710:
7711: /* -------------------------------------------------------------------

Line 7754: FND_MSG_PUB.initialize;

7750: ', X_VALUE_OUT: '|| X_VALUE_OUT);
7751:
7752: -- Initialize message list if p_init_msg_list is set to TRUE.
7753: IF FND_API.to_Boolean(p_init_msg_list) THEN
7754: FND_MSG_PUB.initialize;
7755: END IF;
7756:
7757: /* UNIQUE VALIDATION CHECK for account */
7758: cep_standard.debug('UNIQUE_VALIDATION CHECK for account');

Line 7787: FND_MSG_PUB.Count_And_Get(

7783: X_ACCOUNT_ID);
7784: END IF;
7785: cep_standard.debug(' UNIQUE_VALIDATION CHECK for account end ');
7786:
7787: FND_MSG_PUB.Count_And_Get(
7788: p_encoded => FND_API.G_FALSE,
7789: p_count => x_msg_count,
7790: p_data => x_msg_data);
7791:

Line 7804: fnd_msg_pub.add;

7800: WHEN OTHERS THEN
7801: cep_standard.debug('CE_VALIDATE_BANKINFO.upd_account_unique ' ||X_COUNTRY_NAME );
7802: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
7803: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.upd_account_unique');
7804: fnd_msg_pub.add;
7805: RAISE;
7806: END UPD_ACCOUNT_UNIQUE;
7807:
7808: /* -------------------------------------------------------------------

Line 7862: FND_MSG_PUB.initialize;

7858: ', l_value_out: '|| l_value_out);
7859:
7860: -- Initialize message list if p_init_msg_list is set to TRUE.
7861: --IF FND_API.to_Boolean(p_init_msg_list) THEN
7862: FND_MSG_PUB.initialize;
7863: --END IF;
7864:
7865: /* We must validate the Bank Account Number */
7866: IF X_ACCOUNT_NUMBER is null THEN

Line 8017: l_count_before_custom := Nvl(FND_MSG_PUB.count_msg,0);

8013: x_msg_data ,
8014: x_return_status );
8015:
8016: -- 9250566 ADDED 6/6 START -------------------------
8017: l_count_before_custom := Nvl(FND_MSG_PUB.count_msg,0);
8018: l_usr_valid := fnd_api.g_ret_sts_success;
8019:
8020: -- Call to custom validation routines
8021: cep_standard.debug('Calling custom validation hooks');

Line 8043: l_count_after_custom := FND_MSG_PUB.count_msg;

8039: Xo_ACCOUNT_NUM_OUT => l_value_out_custom,
8040: Xo_RETURN_STATUS => l_usr_valid
8041: );
8042:
8043: l_count_after_custom := FND_MSG_PUB.count_msg;
8044: cep_standard.debug('l_count_after=' ||l_count_after_custom);
8045:
8046: cep_standard.debug('l_value_out_custom='||l_value_out_custom);
8047: X_VALUE_OUT := NVL(l_value_out_custom,l_value_out);

Line 8061: FND_MSG_PUB.delete_msg(l_count_after_custom);

8057: cep_standard.debug('Custom validations done - success');
8058: -- remove any unnecessary messages
8059: WHILE l_count_after_custom > l_count_before_custom
8060: LOOP
8061: FND_MSG_PUB.delete_msg(l_count_after_custom);
8062: l_count_after_custom := l_count_after_custom - 1;
8063: cep_standard.debug(l_count_after_custom);
8064: END LOOP;
8065: cep_standard.debug('After cleanup, count='||FND_MSG_PUB.count_msg);

Line 8065: cep_standard.debug('After cleanup, count='||FND_MSG_PUB.count_msg);

8061: FND_MSG_PUB.delete_msg(l_count_after_custom);
8062: l_count_after_custom := l_count_after_custom - 1;
8063: cep_standard.debug(l_count_after_custom);
8064: END LOOP;
8065: cep_standard.debug('After cleanup, count='||FND_MSG_PUB.count_msg);
8066:
8067: END IF;
8068: -- 9250566 6/6 ADDED END --------------------------
8069:

Line 8070: FND_MSG_PUB.Count_And_Get(

8066:
8067: END IF;
8068: -- 9250566 6/6 ADDED END --------------------------
8069:
8070: FND_MSG_PUB.Count_And_Get(
8071: p_encoded => FND_API.G_FALSE,
8072: p_count => x_msg_count,
8073: p_data => x_msg_data);
8074:

Line 8087: fnd_msg_pub.add;

8083: WHEN OTHERS THEN
8084: cep_standard.debug('EXCEPTION: upd_account_validate ' ||X_COUNTRY_NAME );
8085: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
8086: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.upd_account_validate');
8087: fnd_msg_pub.add;
8088: RAISE;
8089: END UPD_ACCOUNT_VALIDATE;
8090:
8091: /* 10172325 - Validation wrapper functions added for Fusion Migration */