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

195:
196: fnd_message.set_name('CE', 'CE_TEMP_NOT_FOUND');
197: fnd_message.set_token('COLUMN', 'Country');
198: fnd_message.set_token('TABLE', 'HZ_BANK_VAL_GT');
199: fnd_msg_pub.add;
200: RAISE NO_DATA_FOUND;
201: END IF;
202: CLOSE c_country;
203:

Line 218: fnd_msg_pub.add;

214:
215: fnd_message.set_name('CE', 'CE_TEMP_NOT_FOUND');
216: fnd_message.set_token('COLUMN', 'Organization_name');
217: fnd_message.set_token('TABLE', 'HZ_ORG_PROFILE_VAL_GT');
218: fnd_msg_pub.add;
219: RAISE NO_DATA_FOUND;
220: END IF;
221: CLOSE c_bank_name;
222:

Line 246: fnd_msg_pub.add;

242:
243: -- If bank exists add message to error queue
244: if l_bank_exist = 'Y' then
245: fnd_message.set_name('CE', 'CE_DUP_BANK_NAME');
246: fnd_msg_pub.add;
247: x_return_status := fnd_api.G_RET_STS_ERROR;
248: else
249: x_return_status := fnd_api.G_RET_STS_SUCCESS;
250: end if;

Line 269: fnd_msg_pub.add;

265:
266: fnd_message.set_name('CE', 'CE_TEMP_NOT_FOUND');
267: fnd_message.set_token('COLUMN', 'Organization_name');
268: fnd_message.set_token('TABLE', 'HZ_ORG_PROFILE_VAL_GT');
269: fnd_msg_pub.add;
270: RAISE NO_DATA_FOUND;
271: END IF;
272: CLOSE c_bank_name;
273:

Line 314: fnd_msg_pub.add;

310: END IF;
311:
312: IF l_bank_name_exist = 'Y' THEN
313: fnd_message.set_name('CE', 'CE_DUP_BANK_NAME');
314: fnd_msg_pub.add;
315: END IF;
316:
317: if l_short_name_exist = 'Y' then
318: fnd_message.set_name('CE', 'CE_DUP_SHORT_BANK_NAME');

Line 319: fnd_msg_pub.add;

315: END IF;
316:
317: if l_short_name_exist = 'Y' then
318: fnd_message.set_name('CE', 'CE_DUP_SHORT_BANK_NAME');
319: fnd_msg_pub.add;
320: end if;
321:
322: if l_bank_number_exist = 'Y' then
323: fnd_message.set_name('CE', 'CE_DUP_BANK_NUM');

Line 324: fnd_msg_pub.add;

320: end if;
321:
322: if l_bank_number_exist = 'Y' then
323: fnd_message.set_name('CE', 'CE_DUP_BANK_NUM');
324: fnd_msg_pub.add;
325: end if;
326:
327: if l_bank_name_exist = 'Y' OR l_short_name_exist = 'Y' OR l_bank_number_exist='Y' then
328: --RAISE fnd_api.g_exc_error;

Line 339: fnd_msg_pub.add;

335: EXCEPTION
336: WHEN OTHERS THEN
337: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
338: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_bank');
339: fnd_msg_pub.add;
340: RAISE;
341: END validate_bank;
342:
343:

Line 407: fnd_msg_pub.add;

403:
404: l_org_list := MO_UTILS.get_org_list(p_security_profile_id, p_org_classification);
405: IF l_org_list = '' THEN
406: fnd_message.set_name('CE', 'CE_NO_ORG_FOR_MO_SP');
407: fnd_msg_pub.add;
408: return;
409: END IF;
410:
411: l_sub := l_org_list;

Line 430: fnd_msg_pub.add;

426: END LOOP;
427:
428: IF l_found = 'N' THEN
429: fnd_message.set_name('CE', 'CE_INVALID_ORG_NAME');
430: fnd_msg_pub.add;
431: END IF;
432:
433: EXCEPTION
434: WHEN OTHERS THEN

Line 437: fnd_msg_pub.add;

433: EXCEPTION
434: WHEN OTHERS THEN
435: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
436: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_org');
437: fnd_msg_pub.add;
438: RAISE;
439: END validate_org;
440: */
441:

Line 471: fnd_msg_pub.add;

467: OPEN c_currency;
468: FETCH c_currency INTO l_dummy;
469: IF c_currency%NOTFOUND THEN
470: fnd_message.set_name('CE', 'CE_BA_INVALID_CURRENCY');
471: fnd_msg_pub.add;
472: x_return_status := fnd_api.g_ret_sts_error;
473: END IF;
474: CLOSE c_currency;
475: END validate_currency;

Line 525: fnd_msg_pub.add;

521: OPEN c_acct_name;
522: FETCH c_acct_name INTO l_dummy;
523: IF l_dummy = 'X' THEN
524: fnd_message.set_name('CE', 'CE_DUP_ACCT_NAME');
525: fnd_msg_pub.add;
526: x_return_status := fnd_api.g_ret_sts_error;
527: END IF;
528: CLOSE c_acct_name;
529:

Line 534: fnd_msg_pub.add;

530: EXCEPTION
531: WHEN OTHERS THEN
532: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
533: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_name');
534: fnd_msg_pub.add;
535:
536: END validate_account_name;
537:
538:

Line 590: fnd_msg_pub.add;

586: -- step 2: length <= 34
587: --
588: IF l_len > 34 THEN
589: fnd_message.set_name('CE', 'CE_INVALID_IBAN');
590: fnd_msg_pub.add;
591: x_return_status := fnd_api.g_ret_sts_error;
592: cep_standard.debug('validate_IBAN: CE_INVALID_IBAN');
593: END IF;
594:

Line 607: fnd_msg_pub.add;

603: cep_standard.debug('l_str3_4='||l_str3_4);
604:
605: IF (TRANSLATE(l_str1_2, 'ABCDEFGHIJKLMNOPQRSTUVWXYZ', '99999999999999999999999999') <> '99') THEN
606: fnd_message.set_name('CE', 'CE_INVALID_IBAN');
607: fnd_msg_pub.add;
608: x_return_status := fnd_api.g_ret_sts_error;
609: cep_standard.debug('validate_IBAN: CE_INVALID_IBAN l_str1_2= '||l_str1_2);
610: END IF;
611:

Line 614: fnd_msg_pub.add;

610: END IF;
611:
612: IF (TRANSLATE(l_str3_4, '0123456789', '9999999999') <> '99') THEN
613: fnd_message.set_name('CE', 'CE_INVALID_IBAN');
614: fnd_msg_pub.add;
615: x_return_status := fnd_api.g_ret_sts_error;
616: cep_standard.debug('validate_IBAN: CE_INVALID_IBAN l_str3_4= '||l_str3_4);
617: END IF;
618:

Line 624: fnd_msg_pub.add;

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

Line 650: fnd_msg_pub.add;

646: l_mod := MOD(l_num, 97);
647: --
648: IF l_mod <> 1 THEN
649: fnd_message.set_name('CE', 'CE_INVALID_IBAN');
650: fnd_msg_pub.add;
651: x_return_status := fnd_api.g_ret_sts_error;
652: cep_standard.debug('validate_IBAN: CE_INVALID_IBAN');
653: ELSE
654: -- IF (new_IBAN <> p_IBAN) then Bug 6658562

Line 707: fnd_msg_pub.add;

703: (p_ar IS NULL OR p_ar = 'N') AND
704: (p_pay IS NULL OR p_pay = 'N') AND
705: (p_xtr IS NULL OR p_xtr = 'N') THEN
706: fnd_message.set_name('CE', 'CE_NO_ACCOUNT_USE');
707: fnd_msg_pub.add;
708: x_return_status := fnd_api.g_ret_sts_error;
709: END IF;
710:
711:

Line 716: fnd_msg_pub.add;

712: EXCEPTION
713: WHEN OTHERS THEN
714: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
715: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_use');
716: fnd_msg_pub.add;
717:
718: END validate_account_use;
719:
720: /*=======================================================================+

Line 746: fnd_msg_pub.add;

742:
743:
744: IF (p_short_account_name IS NULL) AND (p_xtr IS NOT NULL) AND (p_xtr <> 'N') THEN
745: fnd_message.set_name('CE', 'CE_SHORT_ACCOUNT_NAME_REQUIRED');
746: fnd_msg_pub.add;
747: x_return_status := fnd_api.g_ret_sts_error;
748: END IF;
749:
750:

Line 755: fnd_msg_pub.add;

751: EXCEPTION
752: WHEN OTHERS THEN
753: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
754: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_short_account_name');
755: fnd_msg_pub.add;
756:
757: END validate_short_account_name;
758:
759: /*=======================================================================+

Line 783: fnd_msg_pub.add;

779:
780: IF (p_start_date is not NULL) AND (p_end_date is not NULL) THEN
781: IF p_start_date > p_end_date THEN
782: fnd_message.set_name('CE', 'CE_EARLY_END_DATE');
783: fnd_msg_pub.add;
784: x_return_status := fnd_api.g_ret_sts_error;
785: END IF;
786: END IF;
787:

Line 793: fnd_msg_pub.add;

789: EXCEPTION
790: WHEN OTHERS THEN
791: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
792: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_end_date');
793: fnd_msg_pub.add;
794: x_return_status := fnd_api.g_ret_sts_error;
795:
796: END validate_end_date;
797:

Line 1059: fnd_msg_pub.add;

1055: (((p_ap IS not NULL) and (p_ap <>'N')) or
1056: ((p_ar IS not NULL) and (p_ar <>'N')) or
1057: ((p_pay IS not NULL) and (p_pay <>'N'))) THEN
1058: fnd_message.set_name('CE', 'CE_LE_ACCESS_ORG');
1059: fnd_msg_pub.add;
1060: x_return_status := fnd_api.g_ret_sts_error;
1061: ELSIF (p_org_type = 'BG') AND
1062: (((p_ap IS not NULL) and (p_ap <>'N')) or
1063: ((p_ar IS not NULL) and (p_ar <>'N')) or

Line 1066: fnd_msg_pub.add;

1062: (((p_ap IS not NULL) and (p_ap <>'N')) or
1063: ((p_ar IS not NULL) and (p_ar <>'N')) or
1064: ((p_xtr IS not NULL) and (p_xtr <>'N'))) THEN
1065: fnd_message.set_name('CE', 'CE_BG_ACCESS_ORG');
1066: fnd_msg_pub.add;
1067: x_return_status := fnd_api.g_ret_sts_error;
1068: ELSIF (p_org_type = 'OU') AND
1069: (((p_xtr IS not NULL) and (p_xtr <>'N')) or
1070: ((p_pay IS not NULL) and (p_pay <>'N'))) THEN

Line 1072: fnd_msg_pub.add;

1068: ELSIF (p_org_type = 'OU') AND
1069: (((p_xtr IS not NULL) and (p_xtr <>'N')) or
1070: ((p_pay IS not NULL) and (p_pay <>'N'))) THEN
1071: fnd_message.set_name('CE', 'CE_OU_ACCESS_ORG');
1072: fnd_msg_pub.add;
1073: x_return_status := fnd_api.g_ret_sts_error;
1074: ELSIF (p_org_type = 'BGOU') AND
1075: ((p_xtr IS not NULL) and (p_xtr <>'N')) THEN
1076: fnd_message.set_name('CE', 'CE_BGOU_ACCESS_ORG');

Line 1077: fnd_msg_pub.add;

1073: x_return_status := fnd_api.g_ret_sts_error;
1074: ELSIF (p_org_type = 'BGOU') AND
1075: ((p_xtr IS not NULL) and (p_xtr <>'N')) THEN
1076: fnd_message.set_name('CE', 'CE_BGOU_ACCESS_ORG');
1077: fnd_msg_pub.add;
1078: x_return_status := fnd_api.g_ret_sts_error;
1079: END IF;
1080:
1081: EXCEPTION

Line 1085: fnd_msg_pub.add;

1081: EXCEPTION
1082: WHEN OTHERS THEN
1083: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
1084: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_access_org');
1085: fnd_msg_pub.add;
1086:
1087: END validate_account_access_org;
1088:
1089: /*=======================================================================+

Line 1119: FND_MSG_PUB.initialize;

1115: BEGIN
1116:
1117: -- Initialize message list if p_init_msg_list is set to TRUE.
1118: IF FND_API.to_Boolean(p_init_msg_list) THEN
1119: FND_MSG_PUB.initialize;
1120: END IF;
1121: -- initialize API return status to success.
1122: x_return_status := fnd_api.g_ret_sts_success;
1123:

Line 1138: fnd_msg_pub.add;

1134: x_value_out := lpad(new_alc_value,8,0);
1135: end if;
1136: else
1137: FND_MESSAGE.set_name('CE','CE_ALC_VALUE_TOO_LONG');
1138: fnd_msg_pub.add;
1139: x_return_status := fnd_api.g_ret_sts_error;
1140: END if;
1141: ELSE
1142: FND_MESSAGE.set_name('CE','CE_ALC_NUMERIC_VALUE_ONLY');

Line 1143: fnd_msg_pub.add;

1139: x_return_status := fnd_api.g_ret_sts_error;
1140: END if;
1141: ELSE
1142: FND_MESSAGE.set_name('CE','CE_ALC_NUMERIC_VALUE_ONLY');
1143: fnd_msg_pub.add;
1144: x_return_status := fnd_api.g_ret_sts_error;
1145: END IF;
1146:
1147: END IF;

Line 1149: FND_MSG_PUB.Count_And_Get(

1145: END IF;
1146:
1147: END IF;
1148:
1149: FND_MSG_PUB.Count_And_Get(
1150: p_encoded => FND_API.G_FALSE,
1151: p_count => x_msg_count,
1152: p_data => x_msg_data);
1153:

Line 1159: fnd_msg_pub.add;

1155: WHEN OTHERS THEN
1156:
1157: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
1158: fnd_message.set_token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_alc');
1159: fnd_msg_pub.add;
1160: RAISE;
1161:
1162: END VALIDATE_ALC;
1163:

Line 1200: fnd_msg_pub.add;

1196: OPEN c_country;
1197: FETCH c_country INTO l_dummy;
1198: IF c_country%NOTFOUND THEN
1199: fnd_message.set_name('CE', 'CE_API_INVALID_COUNTRY');
1200: fnd_msg_pub.add;
1201: x_return_status := fnd_api.g_ret_sts_error;
1202: END IF;
1203: CLOSE c_country;
1204:

Line 1260: FND_MSG_PUB.initialize;

1256: x_return_status := fnd_api.g_ret_sts_success;
1257:
1258: -- Initialize message list if p_init_msg_list is set to TRUE.
1259: IF FND_API.to_Boolean(p_init_msg_list) THEN
1260: FND_MSG_PUB.initialize;
1261: END IF;
1262: IF l_DEBUG in ('Y', 'C') THEN
1263: cep_standard.debug(' P_INIT_MSG_LIST: '|| P_INIT_MSG_LIST);
1264: END IF;

Line 1273: -- fnd_msg_pub.add;

1269: where bank_account_id = p_bank_account_id;
1270: IF (P_CUR IS not NULL) THEN
1271: --IF (p_bank_acct_use_id is null) then
1272: -- FND_MESSAGE.set_name('CE','CE_BANK_ACCT_USE_ID_REQUIRED');
1273: -- fnd_msg_pub.add;
1274: --ELSE
1275:
1276: IF (p_ap_def_settlement = 'Y') THEN
1277: select count(*) into p_ap_def

Line 1297: fnd_msg_pub.add;

1293: END IF;
1294:
1295: IF (p_ap_def > 0) THEN
1296: FND_MESSAGE.set_name('CE','CE_AP_SETTLEMENT_EXIST_ORG');
1297: fnd_msg_pub.add;
1298: END IF;
1299:
1300: IF (p_xtr_def > 0) THEN
1301: FND_MESSAGE.set_name('CE','CE_XTR_SETTLEMENT_EXIST_ORG');

Line 1302: fnd_msg_pub.add;

1298: END IF;
1299:
1300: IF (p_xtr_def > 0) THEN
1301: FND_MESSAGE.set_name('CE','CE_XTR_SETTLEMENT_EXIST_ORG');
1302: fnd_msg_pub.add;
1303: END IF;
1304: --END IF; --p_bank_acct_use_id
1305: ELSE
1306: FND_MESSAGE.set_name('CE','CE_BANK_ACCOUNT_ID_INVALID');

Line 1307: fnd_msg_pub.add;

1303: END IF;
1304: --END IF; --p_bank_acct_use_id
1305: ELSE
1306: FND_MESSAGE.set_name('CE','CE_BANK_ACCOUNT_ID_INVALID');
1307: fnd_msg_pub.add;
1308: END IF;
1309:
1310: ELSE
1311: FND_MESSAGE.set_name('CE','CE_BANK_ACCOUNT_ID_REQUIRED');

Line 1312: fnd_msg_pub.add;

1308: END IF;
1309:
1310: ELSE
1311: FND_MESSAGE.set_name('CE','CE_BANK_ACCOUNT_ID_REQUIRED');
1312: fnd_msg_pub.add;
1313: END IF;
1314:
1315: FND_MSG_PUB.Count_And_Get(
1316: p_encoded => FND_API.G_FALSE,

Line 1315: FND_MSG_PUB.Count_And_Get(

1311: FND_MESSAGE.set_name('CE','CE_BANK_ACCOUNT_ID_REQUIRED');
1312: fnd_msg_pub.add;
1313: END IF;
1314:
1315: FND_MSG_PUB.Count_And_Get(
1316: p_encoded => FND_API.G_FALSE,
1317: p_count => x_msg_count,
1318: p_data => x_msg_data);
1319:

Line 1335: fnd_msg_pub.add;

1331: WHEN OTHERS THEN
1332:
1333: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
1334: fnd_message.set_token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_def_settlement');
1335: fnd_msg_pub.add;
1336: RAISE;
1337:
1338: END validate_def_settlement;
1339:

Line 1394: fnd_msg_pub.add;

1390: EXCEPTION
1391: WHEN OTHERS THEN
1392: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
1393: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.get_masked_account_num');
1394: fnd_msg_pub.add;
1395: RAISE;
1396: END get_masked_account_num;
1397: */
1398:

Line 1442: fnd_msg_pub.add;

1438: OPEN c_acct_access;
1439: FETCH c_acct_access INTO l_dummy;
1440: IF l_dummy = 'X' THEN
1441: fnd_message.set_name('CE', 'CE_DUP_ACCT_ORG_ACCESS');
1442: fnd_msg_pub.add;
1443: x_return_status := fnd_api.g_ret_sts_error;
1444: END IF;
1445: CLOSE c_acct_access;
1446:

Line 1451: fnd_msg_pub.add;

1447: EXCEPTION
1448: WHEN OTHERS THEN
1449: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
1450: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_unique_org_access');
1451: fnd_msg_pub.add;
1452:
1453: END validate_unique_org_access;
1454:
1455:

Line 1559: fnd_msg_pub.add;

1555: P_PAYMENT_DOC_CATEGORY_CODE := '-1';
1556: WHEN OTHERS THEN
1557: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
1558: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.get_pay_doc_cat');
1559: fnd_msg_pub.add;
1560:
1561: END get_pay_doc_cat;
1562:
1563: /*=======================================================================+