DBA Data[Home] [Help]

APPS.CE_BANK_AND_ACCOUNT_VALIDATION dependencies on FND_MESSAGE

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

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

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

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

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

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

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

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

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

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

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

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

Line 245: fnd_message.set_name('CE', 'CE_DUP_BANK_NAME');

241: CLOSE c_bank_name_number_uk;
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;

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

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

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

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

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

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

Line 313: fnd_message.set_name('CE', 'CE_DUP_BANK_NAME');

309: CLOSE c_bank_number_uk;
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

Line 318: fnd_message.set_name('CE', 'CE_DUP_SHORT_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');
319: fnd_msg_pub.add;
320: end if;
321:
322: if l_bank_number_exist = 'Y' then

Line 323: fnd_message.set_name('CE', 'CE_DUP_BANK_NUM');

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');
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

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

333: */
334: /********** Bug 6742860/6642215: code commented ends **************/
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;

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

334: /********** Bug 6742860/6642215: code commented ends **************/
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:

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

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

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

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

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

431: END IF;
432:
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;

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

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

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

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

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

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

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

528: CLOSE c_acct_name;
529:
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;

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

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

Line 589: fnd_message.set_name('CE', 'CE_INVALID_IBAN');

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

Line 606: fnd_message.set_name('CE', 'CE_INVALID_IBAN');

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

Line 613: fnd_message.set_name('CE', 'CE_INVALID_IBAN');

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

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

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

Line 649: fnd_message.set_name('CE', 'CE_INVALID_IBAN');

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

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

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

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

710:
711:
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;

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

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

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

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

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

749:
750:
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;

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

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

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

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

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

787:
788:
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:

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

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

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

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

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

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

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

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

Line 1076: fnd_message.set_name('CE', 'CE_BGOU_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');
1077: fnd_msg_pub.add;
1078: x_return_status := fnd_api.g_ret_sts_error;
1079: END IF;
1080:

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

1079: END IF;
1080:
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;

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

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

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

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

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

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');
1143: fnd_msg_pub.add;
1144: x_return_status := fnd_api.g_ret_sts_error;
1145: END IF;
1146:

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

1153:
1154: EXCEPTION
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:

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

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

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

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

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

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

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

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

Line 1301: FND_MESSAGE.set_name('CE','CE_XTR_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');
1302: fnd_msg_pub.add;
1303: END IF;
1304: --END IF; --p_bank_acct_use_id
1305: ELSE

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

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');
1307: fnd_msg_pub.add;
1308: END IF;
1309:
1310: ELSE

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

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

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

1329:
1330: EXCEPTION
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:

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

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

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

1388:
1389: RETURN(masked_account_num);
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;

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

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

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

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

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

1445: CLOSE c_acct_access;
1446:
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;

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

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

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

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

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

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