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_BANK_AND_ACCOUNT_VALIDATION dependencies on FND_MSG_PUB

Line 143: fnd_msg_pub.add;

139:
140: fnd_message.set_name('CE', 'CE_TEMP_NOT_FOUND');
141: fnd_message.set_token('COLUMN', 'Country');
142: fnd_message.set_token('TABLE', 'HZ_BANK_VAL_GT');
143: fnd_msg_pub.add;
144: RAISE NO_DATA_FOUND;
145: END IF;
146: CLOSE c_country;
147:

Line 159: fnd_msg_pub.add;

155:
156: fnd_message.set_name('CE', 'CE_TEMP_NOT_FOUND');
157: fnd_message.set_token('COLUMN', 'Organization_name');
158: fnd_message.set_token('TABLE', 'HZ_ORG_PROFILE_VAL_GT');
159: fnd_msg_pub.add;
160: RAISE NO_DATA_FOUND;
161: END IF;
162: CLOSE c_bank_name;
163:

Line 188: fnd_msg_pub.add;

184: -- If bank exists add message to error queue
185: -- 14242293: Modified error message
186: if l_bank_exist = 'Y' then
187: fnd_message.set_name('CE', 'CE_BANK_EXISTS');
188: fnd_msg_pub.add;
189: x_return_status := fnd_api.G_RET_STS_ERROR;
190: else
191: x_return_status := fnd_api.G_RET_STS_SUCCESS;
192: end if;

Line 197: fnd_msg_pub.add;

193: EXCEPTION
194: WHEN OTHERS THEN
195: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
196: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_bank');
197: fnd_msg_pub.add;
198: RAISE;
199: END validate_bank;
200:
201:

Line 263: fnd_msg_pub.add;

259:
260: l_org_list := MO_UTILS.get_org_list(p_security_profile_id, p_org_classification);
261: IF l_org_list = '' THEN
262: fnd_message.set_name('CE', 'CE_NO_ORG_FOR_MO_SP');
263: fnd_msg_pub.add;
264: return;
265: END IF;
266:
267: l_sub := l_org_list;

Line 286: fnd_msg_pub.add;

282: END LOOP;
283:
284: IF l_found = 'N' THEN
285: fnd_message.set_name('CE', 'CE_INVALID_ORG_NAME');
286: fnd_msg_pub.add;
287: END IF;
288:
289: EXCEPTION
290: WHEN OTHERS THEN

Line 293: fnd_msg_pub.add;

289: EXCEPTION
290: WHEN OTHERS THEN
291: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
292: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_org');
293: fnd_msg_pub.add;
294: RAISE;
295: END validate_org;
296: */
297:

Line 327: fnd_msg_pub.add;

323: OPEN c_currency;
324: FETCH c_currency INTO l_dummy;
325: IF c_currency%NOTFOUND THEN
326: fnd_message.set_name('CE', 'CE_BA_INVALID_CURRENCY');
327: fnd_msg_pub.add;
328: x_return_status := fnd_api.g_ret_sts_error;
329: END IF;
330: CLOSE c_currency;
331: END validate_currency;

Line 381: fnd_msg_pub.add;

377: OPEN c_acct_name;
378: FETCH c_acct_name INTO l_dummy;
379: IF l_dummy = 'X' THEN
380: fnd_message.set_name('CE', 'CE_DUP_ACCT_NAME');
381: fnd_msg_pub.add;
382: x_return_status := fnd_api.g_ret_sts_error;
383: END IF;
384: CLOSE c_acct_name;
385:

Line 390: fnd_msg_pub.add;

386: EXCEPTION
387: WHEN OTHERS THEN
388: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
389: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_name');
390: fnd_msg_pub.add;
391:
392: END validate_account_name;
393:
394: /*Bug 16507244 code change 1/2 start*/

Line 533: fnd_msg_pub.add;

529: ELSE
530: fnd_message.set_name('CE', 'CE_INVALID_IBAN_LEN'); -- Bug 8946879
531: cep_standard.debug('validate_IBAN: CE_INVALID_IBAN_LEN');
532: END IF;
533: fnd_msg_pub.add;
534: END IF;
535: cep_standard.debug('xo_return_status - '||xo_return_status);
536: cep_standard.debug('< 537: END validate_iban_length;

Line 602: fnd_msg_pub.add;

598: cep_standard.debug('l_str3_4='||l_str3_4);
599:
600: IF (TRANSLATE(l_str1_2, 'ABCDEFGHIJKLMNOPQRSTUVWXYZ', '99999999999999999999999999') <> '99') THEN
601: fnd_message.set_name('CE', 'CE_IBAN_FIRST_2_CHAR'); -- Bug 8946879
602: fnd_msg_pub.add;
603: x_return_status := fnd_api.g_ret_sts_error;
604: cep_standard.debug('validate_IBAN: CE_IBAN_FIRST_2_CHAR l_str1_2= '||l_str1_2); -- Bug 8946879
605: END IF;
606:

Line 609: fnd_msg_pub.add;

605: END IF;
606:
607: IF (TRANSLATE(l_str3_4, '0123456789', '9999999999') <> '99') THEN
608: fnd_message.set_name('CE', 'CE_IBAN_FIRST_34_CHAR'); -- Bug 8946879
609: fnd_msg_pub.add;
610: x_return_status := fnd_api.g_ret_sts_error;
611: cep_standard.debug('validate_IBAN: CE_IBAN_FIRST_34_CHAR l_str3_4= '||l_str3_4); -- Bug 8946879
612: END IF;
613: /*Bug 16507244 code change 2/2*/

Line 628: fnd_msg_pub.add;

624: IF TRANSLATE(new_IBAN, 'ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789',
625: '999999999999999999999999999999999999')
626: <> RPAD(l_var, l_len, '9') THEN
627: fnd_message.set_name('CE', 'CE_INVALID_IBAN_FORMAT');
628: fnd_msg_pub.add;
629: x_return_status := fnd_api.g_ret_sts_error;
630: cep_standard.debug('validate_IBAN: CE_INVALID_IBAN_FORMAT');
631: ELSE
632: --

Line 667: fnd_msg_pub.add;

663: l_mod := MOD(l_checkSum, 97);
664: --
665: IF l_mod <> 1 THEN
666: fnd_message.set_name('CE', 'CE_INVALID_IBAN_CHKSUM'); -- Bug 8946879
667: fnd_msg_pub.add;
668: x_return_status := fnd_api.g_ret_sts_error;
669: cep_standard.debug('validate_IBAN: CE_INVALID_IBAN_CHKSUM'); -- Bug 8946879
670: ELSE
671: -- IF (new_IBAN <> p_IBAN) then Bug 6658562

Line 722: fnd_msg_pub.add;

718: (p_ar IS NULL OR p_ar = 'N') AND
719: (p_pay IS NULL OR p_pay = 'N') AND
720: (p_xtr IS NULL OR p_xtr = 'N') THEN
721: fnd_message.set_name('CE', 'CE_NO_ACCOUNT_USE');
722: fnd_msg_pub.add;
723: x_return_status := fnd_api.g_ret_sts_error;
724: END IF;
725:
726:

Line 731: fnd_msg_pub.add;

727: EXCEPTION
728: WHEN OTHERS THEN
729: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
730: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_use');
731: fnd_msg_pub.add;
732:
733: END validate_account_use;
734:
735: /*=======================================================================+

Line 761: fnd_msg_pub.add;

757:
758:
759: IF (p_short_account_name IS NULL) AND (p_xtr IS NOT NULL) AND (p_xtr <> 'N') THEN
760: fnd_message.set_name('CE', 'CE_SHORT_ACCOUNT_NAME_REQUIRED');
761: fnd_msg_pub.add;
762: x_return_status := fnd_api.g_ret_sts_error;
763: END IF;
764:
765:

Line 770: fnd_msg_pub.add;

766: EXCEPTION
767: WHEN OTHERS THEN
768: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
769: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_short_account_name');
770: fnd_msg_pub.add;
771:
772: END validate_short_account_name;
773:
774: /*=======================================================================+

Line 798: fnd_msg_pub.add;

794:
795: IF (p_start_date is not NULL) AND (p_end_date is not NULL) THEN
796: IF p_start_date > p_end_date THEN
797: fnd_message.set_name('CE', 'CE_EARLY_END_DATE');
798: fnd_msg_pub.add;
799: x_return_status := fnd_api.g_ret_sts_error;
800: END IF;
801: END IF;
802:

Line 808: fnd_msg_pub.add;

804: EXCEPTION
805: WHEN OTHERS THEN
806: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
807: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_end_date');
808: fnd_msg_pub.add;
809: x_return_status := fnd_api.g_ret_sts_error;
810:
811: END validate_end_date;
812:

Line 1074: fnd_msg_pub.add;

1070: (((p_ap IS not NULL) and (p_ap <>'N')) or
1071: ((p_ar IS not NULL) and (p_ar <>'N')) or
1072: ((p_pay IS not NULL) and (p_pay <>'N'))) THEN
1073: fnd_message.set_name('CE', 'CE_LE_ACCESS_ORG');
1074: fnd_msg_pub.add;
1075: x_return_status := fnd_api.g_ret_sts_error;
1076: ELSIF (p_org_type = 'BG') AND
1077: (((p_ap IS not NULL) and (p_ap <>'N')) or
1078: ((p_ar IS not NULL) and (p_ar <>'N')) or

Line 1081: fnd_msg_pub.add;

1077: (((p_ap IS not NULL) and (p_ap <>'N')) or
1078: ((p_ar IS not NULL) and (p_ar <>'N')) or
1079: ((p_xtr IS not NULL) and (p_xtr <>'N'))) THEN
1080: fnd_message.set_name('CE', 'CE_BG_ACCESS_ORG');
1081: fnd_msg_pub.add;
1082: x_return_status := fnd_api.g_ret_sts_error;
1083: ELSIF (p_org_type = 'OU') AND
1084: (((p_xtr IS not NULL) and (p_xtr <>'N')) or
1085: ((p_pay IS not NULL) and (p_pay <>'N'))) THEN

Line 1087: fnd_msg_pub.add;

1083: ELSIF (p_org_type = 'OU') AND
1084: (((p_xtr IS not NULL) and (p_xtr <>'N')) or
1085: ((p_pay IS not NULL) and (p_pay <>'N'))) THEN
1086: fnd_message.set_name('CE', 'CE_OU_ACCESS_ORG');
1087: fnd_msg_pub.add;
1088: x_return_status := fnd_api.g_ret_sts_error;
1089: ELSIF (p_org_type = 'BGOU') AND
1090: ((p_xtr IS not NULL) and (p_xtr <>'N')) THEN
1091: fnd_message.set_name('CE', 'CE_BGOU_ACCESS_ORG');

Line 1092: fnd_msg_pub.add;

1088: x_return_status := fnd_api.g_ret_sts_error;
1089: ELSIF (p_org_type = 'BGOU') AND
1090: ((p_xtr IS not NULL) and (p_xtr <>'N')) THEN
1091: fnd_message.set_name('CE', 'CE_BGOU_ACCESS_ORG');
1092: fnd_msg_pub.add;
1093: x_return_status := fnd_api.g_ret_sts_error;
1094: END IF;
1095:
1096: EXCEPTION

Line 1100: fnd_msg_pub.add;

1096: EXCEPTION
1097: WHEN OTHERS THEN
1098: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
1099: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_access_org');
1100: fnd_msg_pub.add;
1101:
1102: END validate_account_access_org;
1103:
1104: /*=======================================================================+

Line 1134: FND_MSG_PUB.initialize;

1130: BEGIN
1131:
1132: -- Initialize message list if p_init_msg_list is set to TRUE.
1133: IF FND_API.to_Boolean(p_init_msg_list) THEN
1134: FND_MSG_PUB.initialize;
1135: END IF;
1136: -- initialize API return status to success.
1137: x_return_status := fnd_api.g_ret_sts_success;
1138:

Line 1153: fnd_msg_pub.add;

1149: x_value_out := lpad(new_alc_value,8,0);
1150: end if;
1151: else
1152: FND_MESSAGE.set_name('CE','CE_ALC_VALUE_TOO_LONG');
1153: fnd_msg_pub.add;
1154: x_return_status := fnd_api.g_ret_sts_error;
1155: END if;
1156: ELSE
1157: FND_MESSAGE.set_name('CE','CE_ALC_NUMERIC_VALUE_ONLY');

Line 1158: fnd_msg_pub.add;

1154: x_return_status := fnd_api.g_ret_sts_error;
1155: END if;
1156: ELSE
1157: FND_MESSAGE.set_name('CE','CE_ALC_NUMERIC_VALUE_ONLY');
1158: fnd_msg_pub.add;
1159: x_return_status := fnd_api.g_ret_sts_error;
1160: END IF;
1161:
1162: END IF;

Line 1164: FND_MSG_PUB.Count_And_Get(

1160: END IF;
1161:
1162: END IF;
1163:
1164: FND_MSG_PUB.Count_And_Get(
1165: p_encoded => FND_API.G_FALSE,
1166: p_count => x_msg_count,
1167: p_data => x_msg_data);
1168:

Line 1174: fnd_msg_pub.add;

1170: WHEN OTHERS THEN
1171:
1172: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
1173: fnd_message.set_token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_alc');
1174: fnd_msg_pub.add;
1175: RAISE;
1176:
1177: END VALIDATE_ALC;
1178:

Line 1215: fnd_msg_pub.add;

1211: OPEN c_country;
1212: FETCH c_country INTO l_dummy;
1213: IF c_country%NOTFOUND THEN
1214: fnd_message.set_name('CE', 'CE_API_INVALID_COUNTRY');
1215: fnd_msg_pub.add;
1216: x_return_status := fnd_api.g_ret_sts_error;
1217: END IF;
1218: CLOSE c_country;
1219:

Line 1275: FND_MSG_PUB.initialize;

1271: x_return_status := fnd_api.g_ret_sts_success;
1272:
1273: -- Initialize message list if p_init_msg_list is set to TRUE.
1274: IF FND_API.to_Boolean(p_init_msg_list) THEN
1275: FND_MSG_PUB.initialize;
1276: END IF;
1277: IF l_DEBUG in ('Y', 'C') THEN
1278: cep_standard.debug(' P_INIT_MSG_LIST: '|| P_INIT_MSG_LIST);
1279: END IF;

Line 1288: -- fnd_msg_pub.add;

1284: where bank_account_id = p_bank_account_id;
1285: IF (P_CUR IS not NULL) THEN
1286: --IF (p_bank_acct_use_id is null) then
1287: -- FND_MESSAGE.set_name('CE','CE_BANK_ACCT_USE_ID_REQUIRED');
1288: -- fnd_msg_pub.add;
1289: --ELSE
1290:
1291: IF (p_ap_def_settlement = 'Y') THEN
1292: select count(*) into p_ap_def

Line 1312: fnd_msg_pub.add;

1308: END IF;
1309:
1310: IF (p_ap_def > 0) THEN
1311: FND_MESSAGE.set_name('CE','CE_AP_SETTLEMENT_EXIST_ORG');
1312: fnd_msg_pub.add;
1313: END IF;
1314:
1315: IF (p_xtr_def > 0) THEN
1316: FND_MESSAGE.set_name('CE','CE_XTR_SETTLEMENT_EXIST_ORG');

Line 1317: fnd_msg_pub.add;

1313: END IF;
1314:
1315: IF (p_xtr_def > 0) THEN
1316: FND_MESSAGE.set_name('CE','CE_XTR_SETTLEMENT_EXIST_ORG');
1317: fnd_msg_pub.add;
1318: END IF;
1319: --END IF; --p_bank_acct_use_id
1320: ELSE
1321: FND_MESSAGE.set_name('CE','CE_BANK_ACCOUNT_ID_INVALID');

Line 1322: fnd_msg_pub.add;

1318: END IF;
1319: --END IF; --p_bank_acct_use_id
1320: ELSE
1321: FND_MESSAGE.set_name('CE','CE_BANK_ACCOUNT_ID_INVALID');
1322: fnd_msg_pub.add;
1323: END IF;
1324:
1325: ELSE
1326: FND_MESSAGE.set_name('CE','CE_BANK_ACCOUNT_ID_REQUIRED');

Line 1327: fnd_msg_pub.add;

1323: END IF;
1324:
1325: ELSE
1326: FND_MESSAGE.set_name('CE','CE_BANK_ACCOUNT_ID_REQUIRED');
1327: fnd_msg_pub.add;
1328: END IF;
1329:
1330: FND_MSG_PUB.Count_And_Get(
1331: p_encoded => FND_API.G_FALSE,

Line 1330: FND_MSG_PUB.Count_And_Get(

1326: FND_MESSAGE.set_name('CE','CE_BANK_ACCOUNT_ID_REQUIRED');
1327: fnd_msg_pub.add;
1328: END IF;
1329:
1330: FND_MSG_PUB.Count_And_Get(
1331: p_encoded => FND_API.G_FALSE,
1332: p_count => x_msg_count,
1333: p_data => x_msg_data);
1334:

Line 1350: fnd_msg_pub.add;

1346: WHEN OTHERS THEN
1347:
1348: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
1349: fnd_message.set_token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_def_settlement');
1350: fnd_msg_pub.add;
1351: RAISE;
1352:
1353: END validate_def_settlement;
1354:

Line 1409: fnd_msg_pub.add;

1405: EXCEPTION
1406: WHEN OTHERS THEN
1407: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
1408: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.get_masked_account_num');
1409: fnd_msg_pub.add;
1410: RAISE;
1411: END get_masked_account_num;
1412: */
1413:

Line 1457: fnd_msg_pub.add;

1453: OPEN c_acct_access;
1454: FETCH c_acct_access INTO l_dummy;
1455: IF l_dummy = 'X' THEN
1456: fnd_message.set_name('CE', 'CE_DUP_ACCT_ORG_ACCESS');
1457: fnd_msg_pub.add;
1458: x_return_status := fnd_api.g_ret_sts_error;
1459: END IF;
1460: CLOSE c_acct_access;
1461:

Line 1466: fnd_msg_pub.add;

1462: EXCEPTION
1463: WHEN OTHERS THEN
1464: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
1465: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_unique_org_access');
1466: fnd_msg_pub.add;
1467:
1468: END validate_unique_org_access;
1469:
1470:

Line 1574: fnd_msg_pub.add;

1570: P_PAYMENT_DOC_CATEGORY_CODE := '-1';
1571: WHEN OTHERS THEN
1572: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
1573: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.get_pay_doc_cat');
1574: fnd_msg_pub.add;
1575:
1576: END get_pay_doc_cat;
1577:
1578: /*=======================================================================+