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.HZ_TRANS_PKG dependencies on HZ_TRANS_PKG

Line 1: PACKAGE BODY HZ_TRANS_PKG AS

1: PACKAGE BODY HZ_TRANS_PKG AS
2: /*$Header: ARHDQTRB.pls 120.32.12010000.2 2008/10/06 10:41:49 amstephe ship $ */
3:
4: /*************** Globals *****************************/
5: g_threshold_length NUMBER := 6;

Line 361: FND_MESSAGE.SET_TOKEN('PROC','HZ_TRANS_PKG.replace_maximal_substr');

357: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
358: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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;

Line 547: FND_MESSAGE.SET_TOKEN('PROC','HZ_TRANS_PKG.word_replace_delimited');

543: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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;

Line 769: FND_MESSAGE.SET_TOKEN('PROC','HZ_TRANS_PKG.word_replace_non_delimited');

765: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
766: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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;

Line 822: FND_MESSAGE.SET_TOKEN('PROC','HZ_TRANS_PKG.word_replace_private');

818: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
819: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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;

Line 867: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_TRANS_PKG.word_replace');

863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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;

Line 892: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_TRANS_PKG.word_replace');

888: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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;

Line 922: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_TRANS_PKG.word_replace_noise_words_only');

918: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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;

Line 976: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_TRANS_PKG.exact');

972: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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;

Line 1048: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_TRANS_PKG.exact');

1044: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1045: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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;

Line 1131: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_TRANS_PKG.EXACT_EMAIL');

1127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1128:
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;

Line 1165: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_TRANS_PKG.exact');

1161: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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;

Line 1227: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_TRANS_PKG.exact');

1223: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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;

Line 1260: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_TRANS_PKG.exact');

1256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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;

Line 1304: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_TRANS_PKG.CLEANSED_URL');

1300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1301:
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;

Line 1328: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_TRANS_PKG.SOUNDX');

1324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1325:
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;

Line 1352: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_TRANS_PKG.exact_padded');

1348: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1349:
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;

Line 1410: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_TRANS_PKG.CLEANSED_EMAIL');

1406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1407:
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;

Line 1452: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_TRANS_PKG.CLEANSED_URL');

1448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1449:
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;

Line 2377: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_TRANS_PKG.clusterw');

2373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2374:
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;

Line 2405: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_TRANS_PKG.abbrev');

2401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2402:
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;