359: WHEN OTHERS THEN
360: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_TRANSFORMATION_ERROR');
361: FND_MESSAGE.SET_TOKEN('PROC','HZ_TRANS_PKG.replace_maximal_substr');
362: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
363: FND_MSG_PUB.ADD;
364: FND_MSG_PUB.ADD;
365: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
366: END get_repl_token ;
367:
360: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_TRANSFORMATION_ERROR');
361: FND_MESSAGE.SET_TOKEN('PROC','HZ_TRANS_PKG.replace_maximal_substr');
362: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
363: FND_MSG_PUB.ADD;
364: FND_MSG_PUB.ADD;
365: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
366: END get_repl_token ;
367:
368: -- word replace delimited word replacements
545: WHEN OTHERS THEN
546: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_TRANSFORMATION_ERROR');
547: FND_MESSAGE.SET_TOKEN('PROC','HZ_TRANS_PKG.word_replace_delimited');
548: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
549: FND_MSG_PUB.ADD;
550: FND_MSG_PUB.ADD;
551: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
552: END word_replace_delimited ;
553:
546: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_TRANSFORMATION_ERROR');
547: FND_MESSAGE.SET_TOKEN('PROC','HZ_TRANS_PKG.word_replace_delimited');
548: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
549: FND_MSG_PUB.ADD;
550: FND_MSG_PUB.ADD;
551: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
552: END word_replace_delimited ;
553:
554: -- word replace non_delimited word replacements
767: WHEN OTHERS THEN
768: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_TRANSFORMATION_ERROR');
769: FND_MESSAGE.SET_TOKEN('PROC','HZ_TRANS_PKG.word_replace_non_delimited');
770: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
771: FND_MSG_PUB.ADD;
772: FND_MSG_PUB.ADD;
773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
774: END word_replace_non_delimited ;
775:
768: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_TRANSFORMATION_ERROR');
769: FND_MESSAGE.SET_TOKEN('PROC','HZ_TRANS_PKG.word_replace_non_delimited');
770: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
771: FND_MSG_PUB.ADD;
772: FND_MSG_PUB.ADD;
773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
774: END word_replace_non_delimited ;
775:
776:
820: WHEN OTHERS THEN
821: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_TRANSFORMATION_ERROR');
822: FND_MESSAGE.SET_TOKEN('PROC','HZ_TRANS_PKG.word_replace_private');
823: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
824: FND_MSG_PUB.ADD;
825: FND_MSG_PUB.ADD;
826: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
827: END word_replace_private ;
828:
821: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_TRANSFORMATION_ERROR');
822: FND_MESSAGE.SET_TOKEN('PROC','HZ_TRANS_PKG.word_replace_private');
823: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
824: FND_MSG_PUB.ADD;
825: FND_MSG_PUB.ADD;
826: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
827: END word_replace_private ;
828:
829:
865: WHEN OTHERS THEN
866: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_TRANSFORMATION_ERROR');
867: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_TRANS_PKG.word_replace');
868: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
869: FND_MSG_PUB.ADD;
870: FND_MSG_PUB.ADD;
871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
872: END word_replace;
873:
866: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_TRANSFORMATION_ERROR');
867: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_TRANS_PKG.word_replace');
868: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
869: FND_MSG_PUB.ADD;
870: FND_MSG_PUB.ADD;
871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
872: END word_replace;
873:
874: -- Version of word_replace that gets called with word list id
890: WHEN OTHERS THEN
891: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_TRANSFORMATION_ERROR');
892: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_TRANS_PKG.word_replace');
893: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
894: FND_MSG_PUB.ADD;
895: FND_MSG_PUB.ADD;
896: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
897: END word_replace;
898:
891: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_TRANSFORMATION_ERROR');
892: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_TRANS_PKG.word_replace');
893: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
894: FND_MSG_PUB.ADD;
895: FND_MSG_PUB.ADD;
896: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
897: END word_replace;
898:
899:
920: WHEN OTHERS THEN
921: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_TRANSFORMATION_ERROR');
922: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_TRANS_PKG.word_replace_noise_words_only');
923: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
924: FND_MSG_PUB.ADD;
925: FND_MSG_PUB.ADD;
926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
927: END word_replace_noise_words_only ;
928:
921: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_TRANSFORMATION_ERROR');
922: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_TRANS_PKG.word_replace_noise_words_only');
923: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
924: FND_MSG_PUB.ADD;
925: FND_MSG_PUB.ADD;
926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
927: END word_replace_noise_words_only ;
928:
929:
974: WHEN OTHERS THEN
975: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_TRANSFORMATION_ERROR');
976: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_TRANS_PKG.exact');
977: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
978: FND_MSG_PUB.ADD;
979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
980: END EXACT;
981:
982: FUNCTION CLEANSE (
1046: WHEN OTHERS THEN
1047: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_TRANSFORMATION_ERROR');
1048: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_TRANS_PKG.exact');
1049: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1050: FND_MSG_PUB.ADD;
1051: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1052: END CLEANSE;
1053:
1054: FUNCTION Reverse_Phone_number(
1129: WHEN OTHERS THEN
1130: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_TRANSFORMATION_ERROR');
1131: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_TRANS_PKG.EXACT_EMAIL');
1132: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1133: FND_MSG_PUB.ADD;
1134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1135: END EXACT_EMAIL;
1136:
1137: FUNCTION RM_SPLCHAR (
1163: WHEN OTHERS THEN
1164: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_TRANSFORMATION_ERROR');
1165: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_TRANS_PKG.exact');
1166: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1167: FND_MSG_PUB.ADD;
1168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1169: END RM_SPLCHAR;
1170:
1171: --bug 5128213 start
1225: WHEN OTHERS THEN
1226: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_TRANSFORMATION_ERROR');
1227: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_TRANS_PKG.exact');
1228: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1229: FND_MSG_PUB.ADD;
1230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1231: END RM_SPLCHAR_PRIVATE;
1232: --bug 5128213 end
1233:
1258: WHEN OTHERS THEN
1259: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_TRANSFORMATION_ERROR');
1260: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_TRANS_PKG.exact');
1261: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1262: FND_MSG_PUB.ADD;
1263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1264: END RM_BLANKS;
1265:
1266: FUNCTION EXACT_URL (
1302: WHEN OTHERS THEN
1303: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_TRANSFORMATION_ERROR');
1304: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_TRANS_PKG.CLEANSED_URL');
1305: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1306: FND_MSG_PUB.ADD;
1307: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1308: END EXACT_URL;
1309:
1310: FUNCTION SOUNDX (
1326: WHEN OTHERS THEN
1327: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_TRANSFORMATION_ERROR');
1328: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_TRANS_PKG.SOUNDX');
1329: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1330: FND_MSG_PUB.ADD;
1331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1332: END SOUNDX;
1333:
1334: FUNCTION EXACT_PADDED (
1350: WHEN OTHERS THEN
1351: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_TRANSFORMATION_ERROR');
1352: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_TRANS_PKG.exact_padded');
1353: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1354: FND_MSG_PUB.ADD;
1355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1356: END EXACT_PADDED;
1357:
1358:
1408: WHEN OTHERS THEN
1409: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_TRANSFORMATION_ERROR');
1410: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_TRANS_PKG.CLEANSED_EMAIL');
1411: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1412: FND_MSG_PUB.ADD;
1413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1414: END CLEANSED_EMAIL;
1415:
1416: FUNCTION CLEANSED_URL (
1450: WHEN OTHERS THEN
1451: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_TRANSFORMATION_ERROR');
1452: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_TRANS_PKG.CLEANSED_URL');
1453: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1454: FND_MSG_PUB.ADD;
1455: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1456: END CLEANSED_URL;
1457: FUNCTION person_exact_old_private(
1458: p_original_value IN VARCHAR2,
2375: WHEN OTHERS THEN
2376: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_TRANSFORMATION_ERROR');
2377: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_TRANS_PKG.clusterw');
2378: FND_MESSAGE.SET_TOKEN('ERROR ' ,'val ' || p_original_value || ' ' || SQLERRM);
2379: FND_MSG_PUB.ADD;
2380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2381: END CLUSTER_WORD;
2382:
2383: FUNCTION ACRONYM (
2403: WHEN OTHERS THEN
2404: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_TRANSFORMATION_ERROR');
2405: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_TRANS_PKG.abbrev');
2406: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2407: FND_MSG_PUB.ADD;
2408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2409: END ACRONYM;
2410:
2411: FUNCTION REVERSE_NAME (