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 FND_MESSAGE

Line 360: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_TRANSFORMATION_ERROR');

356: RAISE FND_API.G_EXC_ERROR;
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;

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 362: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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;
366: END get_repl_token ;

Line 546: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_TRANSFORMATION_ERROR');

542: RAISE FND_API.G_EXC_ERROR;
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;

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 548: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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;
552: END word_replace_delimited ;

Line 768: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_TRANSFORMATION_ERROR');

764: RAISE FND_API.G_EXC_ERROR;
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;

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 770: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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;
774: END word_replace_non_delimited ;

Line 821: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_TRANSFORMATION_ERROR');

817: RAISE FND_API.G_EXC_ERROR;
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;

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 823: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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;
827: END word_replace_private ;

Line 866: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_TRANSFORMATION_ERROR');

862: RAISE FND_API.G_EXC_ERROR;
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;

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 868: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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;
872: END word_replace;

Line 891: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_TRANSFORMATION_ERROR');

887: RAISE FND_API.G_EXC_ERROR;
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;

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 893: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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;
897: END word_replace;

Line 921: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_TRANSFORMATION_ERROR');

917: RAISE FND_API.G_EXC_ERROR;
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;

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 923: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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;
927: END word_replace_noise_words_only ;

Line 975: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_TRANSFORMATION_ERROR');

971: RAISE FND_API.G_EXC_ERROR;
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;

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 977: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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

Line 1047: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_TRANSFORMATION_ERROR');

1043: RAISE FND_API.G_EXC_ERROR;
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;

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 1049: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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

Line 1130: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_TRANSFORMATION_ERROR');

1126: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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;

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 1132: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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

Line 1164: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_TRANSFORMATION_ERROR');

1160: RAISE FND_API.G_EXC_ERROR;
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;

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 1166: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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

Line 1226: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_TRANSFORMATION_ERROR');

1222: RAISE FND_API.G_EXC_ERROR;
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;

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 1228: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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;
1232: --bug 5128213 end

Line 1259: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_TRANSFORMATION_ERROR');

1255: RAISE FND_API.G_EXC_ERROR;
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;

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 1261: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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

Line 1303: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_TRANSFORMATION_ERROR');

1299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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;

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 1305: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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

Line 1327: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_TRANSFORMATION_ERROR');

1323: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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;

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 1329: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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

Line 1351: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_TRANSFORMATION_ERROR');

1347: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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;

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 1353: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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

Line 1409: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_TRANSFORMATION_ERROR');

1405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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;

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 1411: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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

Line 1451: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_TRANSFORMATION_ERROR');

1447: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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;

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 1453: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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;
1457: FUNCTION person_exact_old_private(

Line 2376: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_TRANSFORMATION_ERROR');

2372: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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;

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 2378: FND_MESSAGE.SET_TOKEN('ERROR ' ,'val ' || p_original_value || ' ' || SQLERRM);

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

Line 2404: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_TRANSFORMATION_ERROR');

2400: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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;

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;

Line 2406: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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