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_MESSAGE

Line 140: fnd_message.set_name('CE', 'CE_TEMP_NOT_FOUND');

136: -- Close the cursor and raise an error if the country could not be
137: -- found in the temp table HZ_BANK_VAL_GT.
138: CLOSE c_country;
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;

Line 141: fnd_message.set_token('COLUMN', 'Country');

137: -- found in the temp table HZ_BANK_VAL_GT.
138: CLOSE c_country;
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;

Line 142: fnd_message.set_token('TABLE', 'HZ_BANK_VAL_GT');

138: CLOSE c_country;
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;

Line 156: fnd_message.set_name('CE', 'CE_TEMP_NOT_FOUND');

152: -- Close the cursor and raise an error if the org_name could not be
153: -- found in the temp table hz_org_profile_val_gt.
154: CLOSE c_bank_name;
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;

Line 157: fnd_message.set_token('COLUMN', 'Organization_name');

153: -- found in the temp table hz_org_profile_val_gt.
154: CLOSE c_bank_name;
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;

Line 158: fnd_message.set_token('TABLE', 'HZ_ORG_PROFILE_VAL_GT');

154: CLOSE c_bank_name;
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;

Line 187: fnd_message.set_name('CE', 'CE_BANK_EXISTS');

183:
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;

Line 195: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');

191: x_return_status := fnd_api.G_RET_STS_SUCCESS;
192: end if;
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;

Line 196: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_bank');

192: end if;
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:

Line 262: fnd_message.set_name('CE', 'CE_NO_ORG_FOR_MO_SP');

258: l_found := 'N';
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:

Line 285: fnd_message.set_name('CE', 'CE_INVALID_ORG_NAME');

281: --l_sub := substr(l_sub, l_pos, l_len - l_pos);
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

Line 291: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');

287: END IF;
288:
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;

Line 292: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_org');

288:
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: */

Line 326: fnd_message.set_name('CE', 'CE_BA_INVALID_CURRENCY');

322:
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;

Line 380: fnd_message.set_name('CE', 'CE_DUP_ACCT_NAME');

376: */
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;

Line 388: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');

384: CLOSE c_acct_name;
385:
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;

Line 389: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_name');

385:
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:

Line 525: fnd_message.set_name('CE', 'CE_INVALID_IBAN_LEN_EU');

521: EXCEPTION
522: WHEN no_data_found THEN
523: l_country_name := Xi_country_code;
524: END;
525: fnd_message.set_name('CE', 'CE_INVALID_IBAN_LEN_EU');
526: fnd_message.set_token('LENGTH', l_iban_len);
527: fnd_message.set_token('COUNTRY_NAME', l_country_name);
528: cep_standard.debug('validate_IBAN: CE_INVALID_IBAN_LEN_EU');
529: ELSE

Line 526: fnd_message.set_token('LENGTH', l_iban_len);

522: WHEN no_data_found THEN
523: l_country_name := Xi_country_code;
524: END;
525: fnd_message.set_name('CE', 'CE_INVALID_IBAN_LEN_EU');
526: fnd_message.set_token('LENGTH', l_iban_len);
527: fnd_message.set_token('COUNTRY_NAME', l_country_name);
528: cep_standard.debug('validate_IBAN: CE_INVALID_IBAN_LEN_EU');
529: ELSE
530: fnd_message.set_name('CE', 'CE_INVALID_IBAN_LEN'); -- Bug 8946879

Line 527: fnd_message.set_token('COUNTRY_NAME', l_country_name);

523: l_country_name := Xi_country_code;
524: END;
525: fnd_message.set_name('CE', 'CE_INVALID_IBAN_LEN_EU');
526: fnd_message.set_token('LENGTH', l_iban_len);
527: fnd_message.set_token('COUNTRY_NAME', l_country_name);
528: cep_standard.debug('validate_IBAN: CE_INVALID_IBAN_LEN_EU');
529: ELSE
530: fnd_message.set_name('CE', 'CE_INVALID_IBAN_LEN'); -- Bug 8946879
531: cep_standard.debug('validate_IBAN: CE_INVALID_IBAN_LEN');

Line 530: fnd_message.set_name('CE', 'CE_INVALID_IBAN_LEN'); -- Bug 8946879

526: fnd_message.set_token('LENGTH', l_iban_len);
527: fnd_message.set_token('COUNTRY_NAME', l_country_name);
528: cep_standard.debug('validate_IBAN: CE_INVALID_IBAN_LEN_EU');
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;

Line 601: fnd_message.set_name('CE', 'CE_IBAN_FIRST_2_CHAR'); -- Bug 8946879

597: cep_standard.debug('l_str1_2='||l_str1_2);
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;

Line 608: fnd_message.set_name('CE', 'CE_IBAN_FIRST_34_CHAR'); -- Bug 8946879

604: cep_standard.debug('validate_IBAN: CE_IBAN_FIRST_2_CHAR l_str1_2= '||l_str1_2); -- Bug 8946879
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;

Line 627: fnd_message.set_name('CE', 'CE_INVALID_IBAN_FORMAT');

623: IF (x_return_status = fnd_api.g_ret_sts_success) then
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

Line 666: fnd_message.set_name('CE', 'CE_INVALID_IBAN_CHKSUM'); -- Bug 8946879

662: -- Bug 10363417
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

Line 721: fnd_message.set_name('CE', 'CE_NO_ACCOUNT_USE');

717: IF (p_ap IS NULL OR p_ap = 'N') AND
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:

Line 729: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');

725:
726:
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;

Line 730: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_use');

726:
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:

Line 760: fnd_message.set_name('CE', 'CE_SHORT_ACCOUNT_NAME_REQUIRED');

756: cep_standard.debug('p_xtr='||p_xtr);
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:

Line 768: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');

764:
765:
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;

Line 769: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_short_account_name');

765:
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:

Line 797: fnd_message.set_name('CE', 'CE_EARLY_END_DATE');

793:
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;

Line 806: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');

802:
803:
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:

Line 807: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_end_date');

803:
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;

Line 1073: fnd_message.set_name('CE', 'CE_LE_ACCESS_ORG');

1069: IF (p_org_type = 'LE') AND
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

Line 1080: fnd_message.set_name('CE', 'CE_BG_ACCESS_ORG');

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
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

Line 1086: fnd_message.set_name('CE', 'CE_OU_ACCESS_ORG');

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
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

Line 1091: fnd_message.set_name('CE', 'CE_BGOU_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');
1092: fnd_msg_pub.add;
1093: x_return_status := fnd_api.g_ret_sts_error;
1094: END IF;
1095:

Line 1098: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');

1094: END IF;
1095:
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;

Line 1099: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_access_org');

1095:
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:

Line 1152: FND_MESSAGE.set_name('CE','CE_ALC_VALUE_TOO_LONG');

1148: If (alc_value_len <> 8) then
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

Line 1157: FND_MESSAGE.set_name('CE','CE_ALC_NUMERIC_VALUE_ONLY');

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');
1158: fnd_msg_pub.add;
1159: x_return_status := fnd_api.g_ret_sts_error;
1160: END IF;
1161:

Line 1172: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');

1168:
1169: EXCEPTION
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:

Line 1173: fnd_message.set_token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_alc');

1169: EXCEPTION
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;

Line 1214: fnd_message.set_name('CE', 'CE_API_INVALID_COUNTRY');

1210:
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;

Line 1287: -- FND_MESSAGE.set_name('CE','CE_BANK_ACCT_USE_ID_REQUIRED');

1283: from ce_bank_accounts
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

Line 1311: FND_MESSAGE.set_name('CE','CE_AP_SETTLEMENT_EXIST_ORG');

1307: and bau.bank_acct_use_id <> nvl(p_bank_acct_use_id, bau.bank_acct_use_id) ;
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

Line 1316: FND_MESSAGE.set_name('CE','CE_XTR_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');
1317: fnd_msg_pub.add;
1318: END IF;
1319: --END IF; --p_bank_acct_use_id
1320: ELSE

Line 1321: FND_MESSAGE.set_name('CE','CE_BANK_ACCOUNT_ID_INVALID');

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');
1322: fnd_msg_pub.add;
1323: END IF;
1324:
1325: ELSE

Line 1326: FND_MESSAGE.set_name('CE','CE_BANK_ACCOUNT_ID_REQUIRED');

1322: 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(

Line 1348: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');

1344:
1345: EXCEPTION
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:

Line 1349: fnd_message.set_token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_def_settlement');

1345: EXCEPTION
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;

Line 1407: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');

1403:
1404: RETURN(masked_account_num);
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;

Line 1408: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.get_masked_account_num');

1404: RETURN(masked_account_num);
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: */

Line 1456: fnd_message.set_name('CE', 'CE_DUP_ACCT_ORG_ACCESS');

1452:
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;

Line 1464: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');

1460: CLOSE c_acct_access;
1461:
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;

Line 1465: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_unique_org_access');

1461:
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:

Line 1572: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');

1568: WHEN TOO_MANY_ROWS THEN
1569: cep_standard.debug('too_many_rows');
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;

Line 1573: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.get_pay_doc_cat');

1569: cep_standard.debug('too_many_rows');
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: