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