DBA Data[Home] [Help]

APPS.HZ_TRANS_PKG dependencies on FND_MSG_PUB

Line 363: FND_MSG_PUB.ADD;

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:

Line 364: FND_MSG_PUB.ADD;

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

Line 549: FND_MSG_PUB.ADD;

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:

Line 550: FND_MSG_PUB.ADD;

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

Line 771: FND_MSG_PUB.ADD;

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:

Line 772: FND_MSG_PUB.ADD;

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:

Line 824: FND_MSG_PUB.ADD;

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:

Line 825: FND_MSG_PUB.ADD;

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:

Line 869: FND_MSG_PUB.ADD;

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:

Line 870: FND_MSG_PUB.ADD;

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

Line 894: FND_MSG_PUB.ADD;

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:

Line 895: FND_MSG_PUB.ADD;

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:

Line 924: FND_MSG_PUB.ADD;

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:

Line 925: FND_MSG_PUB.ADD;

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:

Line 978: FND_MSG_PUB.ADD;

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 (

Line 1050: FND_MSG_PUB.ADD;

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(

Line 1133: FND_MSG_PUB.ADD;

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 (

Line 1167: FND_MSG_PUB.ADD;

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

Line 1229: FND_MSG_PUB.ADD;

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:

Line 1262: FND_MSG_PUB.ADD;

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 (

Line 1306: FND_MSG_PUB.ADD;

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 (

Line 1330: FND_MSG_PUB.ADD;

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 (

Line 1354: FND_MSG_PUB.ADD;

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:

Line 1412: FND_MSG_PUB.ADD;

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 (

Line 1454: FND_MSG_PUB.ADD;

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,

Line 2379: FND_MSG_PUB.ADD;

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 (

Line 2407: FND_MSG_PUB.ADD;

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 (