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_API

Line 355: WHEN FND_API.G_EXC_ERROR THEN

351: --dbms_output.put_line( 'in_str is' || in_str);
352: --dbms_output.put_line( 'remainder_str is' || remainder_str);
353: --dbms_output.put_line( 'repl_token is' || repl_token);
354: EXCEPTION
355: WHEN FND_API.G_EXC_ERROR THEN
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

Line 356: RAISE FND_API.G_EXC_ERROR;

352: --dbms_output.put_line( 'remainder_str is' || remainder_str);
353: --dbms_output.put_line( 'repl_token is' || repl_token);
354: EXCEPTION
355: WHEN FND_API.G_EXC_ERROR THEN
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');

Line 357: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

353: --dbms_output.put_line( 'repl_token is' || repl_token);
354: EXCEPTION
355: WHEN FND_API.G_EXC_ERROR THEN
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');

Line 358: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

354: EXCEPTION
355: WHEN FND_API.G_EXC_ERROR THEN
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);

Line 365: RAISE FND_API.G_EXC_UNEXPECTED_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
369: FUNCTION word_replace_delimited (

Line 541: WHEN FND_API.G_EXC_ERROR THEN

537: --dbms_output.put_line('Returned String is' || l_repl_str );
538:
539: RETURN l_repl_str;
540: EXCEPTION
541: WHEN FND_API.G_EXC_ERROR THEN
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

Line 542: RAISE FND_API.G_EXC_ERROR;

538:
539: RETURN l_repl_str;
540: EXCEPTION
541: WHEN FND_API.G_EXC_ERROR THEN
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');

Line 543: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

539: RETURN l_repl_str;
540: EXCEPTION
541: WHEN FND_API.G_EXC_ERROR THEN
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');

Line 544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

540: EXCEPTION
541: WHEN FND_API.G_EXC_ERROR THEN
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);

Line 551: RAISE FND_API.G_EXC_UNEXPECTED_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
555: FUNCTION word_replace_non_delimited (

Line 763: WHEN FND_API.G_EXC_ERROR THEN

759: --dbms_output.put_line('Returned String is' || l_repl_str );
760:
761: RETURN l_repl_str;
762: EXCEPTION
763: WHEN FND_API.G_EXC_ERROR THEN
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

Line 764: RAISE FND_API.G_EXC_ERROR;

760:
761: RETURN l_repl_str;
762: EXCEPTION
763: WHEN FND_API.G_EXC_ERROR THEN
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');

Line 765: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

761: RETURN l_repl_str;
762: EXCEPTION
763: WHEN FND_API.G_EXC_ERROR THEN
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');

Line 766: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

762: EXCEPTION
763: WHEN FND_API.G_EXC_ERROR THEN
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);

Line 773: RAISE FND_API.G_EXC_UNEXPECTED_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:
777: FUNCTION word_replace_private (

Line 816: WHEN FND_API.G_EXC_ERROR THEN

812: END IF ;
813:
814:
815: EXCEPTION
816: WHEN FND_API.G_EXC_ERROR THEN
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

Line 817: RAISE FND_API.G_EXC_ERROR;

813:
814:
815: EXCEPTION
816: WHEN FND_API.G_EXC_ERROR THEN
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');

Line 818: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

814:
815: EXCEPTION
816: WHEN FND_API.G_EXC_ERROR THEN
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');

Line 819: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

815: EXCEPTION
816: WHEN FND_API.G_EXC_ERROR THEN
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);

Line 826: RAISE FND_API.G_EXC_UNEXPECTED_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:
830:

Line 861: WHEN FND_API.G_EXC_ERROR THEN

857:
858: CLOSE c_wl_id;
859:
860: EXCEPTION
861: WHEN FND_API.G_EXC_ERROR THEN
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

Line 862: RAISE FND_API.G_EXC_ERROR;

858: CLOSE c_wl_id;
859:
860: EXCEPTION
861: WHEN FND_API.G_EXC_ERROR THEN
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');

Line 863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

859:
860: EXCEPTION
861: WHEN FND_API.G_EXC_ERROR THEN
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');

Line 864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

860: EXCEPTION
861: WHEN FND_API.G_EXC_ERROR THEN
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);

Line 871: RAISE FND_API.G_EXC_UNEXPECTED_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
875: FUNCTION word_replace (

Line 886: WHEN FND_API.G_EXC_ERROR THEN

882:
883: RETURN word_replace_private( p_input_str, p_word_list_id, p_language) ;
884:
885: EXCEPTION
886: WHEN FND_API.G_EXC_ERROR THEN
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

Line 887: RAISE FND_API.G_EXC_ERROR;

883: RETURN word_replace_private( p_input_str, p_word_list_id, p_language) ;
884:
885: EXCEPTION
886: WHEN FND_API.G_EXC_ERROR THEN
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');

Line 888: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

884:
885: EXCEPTION
886: WHEN FND_API.G_EXC_ERROR THEN
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');

Line 889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

885: EXCEPTION
886: WHEN FND_API.G_EXC_ERROR THEN
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);

Line 896: RAISE FND_API.G_EXC_UNEXPECTED_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:
900: -- VJN Introduced change for Bug 3829926

Line 916: WHEN FND_API.G_EXC_ERROR THEN

912: --dbms_output.put_line(' calling word_replace with noise words flag as Y');
913: RETURN word_replace_private( p_input_str, p_word_list_id, p_language, p_has_spc, 'Y');
914:
915: EXCEPTION
916: WHEN FND_API.G_EXC_ERROR THEN
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

Line 917: RAISE FND_API.G_EXC_ERROR;

913: RETURN word_replace_private( p_input_str, p_word_list_id, p_language, p_has_spc, 'Y');
914:
915: EXCEPTION
916: WHEN FND_API.G_EXC_ERROR THEN
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');

Line 918: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

914:
915: EXCEPTION
916: WHEN FND_API.G_EXC_ERROR THEN
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');

Line 919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

915: EXCEPTION
916: WHEN FND_API.G_EXC_ERROR THEN
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);

Line 926: RAISE FND_API.G_EXC_UNEXPECTED_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:
930:

Line 970: WHEN FND_API.G_EXC_ERROR THEN

966: END IF;
967:
968: RETURN retstr;
969: EXCEPTION
970: WHEN FND_API.G_EXC_ERROR THEN
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

Line 971: RAISE FND_API.G_EXC_ERROR;

967:
968: RETURN retstr;
969: EXCEPTION
970: WHEN FND_API.G_EXC_ERROR THEN
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');

Line 972: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

968: RETURN retstr;
969: EXCEPTION
970: WHEN FND_API.G_EXC_ERROR THEN
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');

Line 973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

969: EXCEPTION
970: WHEN FND_API.G_EXC_ERROR THEN
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);

Line 979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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 (
983: p_original_value IN VARCHAR2,

Line 1042: WHEN FND_API.G_EXC_ERROR THEN

1038: END IF;
1039: RETURN retstr;
1040:
1041: EXCEPTION
1042: WHEN FND_API.G_EXC_ERROR THEN
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

Line 1043: RAISE FND_API.G_EXC_ERROR;

1039: RETURN retstr;
1040:
1041: EXCEPTION
1042: WHEN FND_API.G_EXC_ERROR THEN
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');

Line 1044: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1040:
1041: EXCEPTION
1042: WHEN FND_API.G_EXC_ERROR THEN
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');

Line 1045: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1041: EXCEPTION
1042: WHEN FND_API.G_EXC_ERROR THEN
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);

Line 1051: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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(
1055: p_original_value IN VARCHAR2,

Line 1124: WHEN FND_API.G_EXC_ERROR THEN

1120:
1121: BEGIN
1122: RETURN upper(p_original_value);
1123: EXCEPTION
1124: WHEN FND_API.G_EXC_ERROR THEN
1125: RAISE FND_API.G_EXC_ERROR;
1126: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1128:

Line 1125: RAISE FND_API.G_EXC_ERROR;

1121: BEGIN
1122: RETURN upper(p_original_value);
1123: EXCEPTION
1124: WHEN FND_API.G_EXC_ERROR THEN
1125: RAISE FND_API.G_EXC_ERROR;
1126: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1128:
1129: WHEN OTHERS THEN

Line 1126: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1122: RETURN upper(p_original_value);
1123: EXCEPTION
1124: WHEN FND_API.G_EXC_ERROR THEN
1125: RAISE FND_API.G_EXC_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');

Line 1127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1123: EXCEPTION
1124: WHEN FND_API.G_EXC_ERROR THEN
1125: RAISE FND_API.G_EXC_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');

Line 1134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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 (
1138: p_original_value IN VARCHAR2,

Line 1159: WHEN FND_API.G_EXC_ERROR THEN

1155: END IF;
1156: --bug 5128213 end
1157:
1158: EXCEPTION
1159: WHEN FND_API.G_EXC_ERROR THEN
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

Line 1160: RAISE FND_API.G_EXC_ERROR;

1156: --bug 5128213 end
1157:
1158: EXCEPTION
1159: WHEN FND_API.G_EXC_ERROR THEN
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');

Line 1161: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1157:
1158: EXCEPTION
1159: WHEN FND_API.G_EXC_ERROR THEN
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');

Line 1162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1158: EXCEPTION
1159: WHEN FND_API.G_EXC_ERROR THEN
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);

Line 1168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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
1172: FUNCTION RM_SPLCHAR_PRIVATE (

Line 1221: WHEN FND_API.G_EXC_ERROR THEN

1217: retstr:=REPLACE(retstr,'.',' ');
1218:
1219: RETURN retstr;
1220: EXCEPTION
1221: WHEN FND_API.G_EXC_ERROR THEN
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

Line 1222: RAISE FND_API.G_EXC_ERROR;

1218:
1219: RETURN retstr;
1220: EXCEPTION
1221: WHEN FND_API.G_EXC_ERROR THEN
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');

Line 1223: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1219: RETURN retstr;
1220: EXCEPTION
1221: WHEN FND_API.G_EXC_ERROR THEN
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');

Line 1224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1220: EXCEPTION
1221: WHEN FND_API.G_EXC_ERROR THEN
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);

Line 1230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
1234: FUNCTION RM_BLANKS (

Line 1254: WHEN FND_API.G_EXC_ERROR THEN

1250: '%0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZ'||g_latin_to)));
1251:
1252: RETURN retstr;
1253: EXCEPTION
1254: WHEN FND_API.G_EXC_ERROR THEN
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

Line 1255: RAISE FND_API.G_EXC_ERROR;

1251:
1252: RETURN retstr;
1253: EXCEPTION
1254: WHEN FND_API.G_EXC_ERROR THEN
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');

Line 1256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1252: RETURN retstr;
1253: EXCEPTION
1254: WHEN FND_API.G_EXC_ERROR THEN
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');

Line 1257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1253: EXCEPTION
1254: WHEN FND_API.G_EXC_ERROR THEN
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);

Line 1263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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 (
1267: p_original_value IN VARCHAR2,

Line 1297: WHEN FND_API.G_EXC_ERROR THEN

1293: ELSE
1294: RETURN retstr;
1295: END IF;
1296: EXCEPTION
1297: WHEN FND_API.G_EXC_ERROR THEN
1298: RAISE FND_API.G_EXC_ERROR;
1299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1301:

Line 1298: RAISE FND_API.G_EXC_ERROR;

1294: RETURN retstr;
1295: END IF;
1296: EXCEPTION
1297: WHEN FND_API.G_EXC_ERROR THEN
1298: RAISE FND_API.G_EXC_ERROR;
1299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1301:
1302: WHEN OTHERS THEN

Line 1299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1295: END IF;
1296: EXCEPTION
1297: WHEN FND_API.G_EXC_ERROR THEN
1298: RAISE FND_API.G_EXC_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');

Line 1300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1296: EXCEPTION
1297: WHEN FND_API.G_EXC_ERROR THEN
1298: RAISE FND_API.G_EXC_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');

Line 1307: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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 (
1311: p_original_value VARCHAR2,

Line 1321: WHEN FND_API.G_EXC_ERROR THEN

1317:
1318: RETURN soundex(EXACT(p_original_value,p_language,p_attribute_name,p_entity_name));
1319:
1320: EXCEPTION
1321: WHEN FND_API.G_EXC_ERROR THEN
1322: RAISE FND_API.G_EXC_ERROR;
1323: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1325:

Line 1322: RAISE FND_API.G_EXC_ERROR;

1318: RETURN soundex(EXACT(p_original_value,p_language,p_attribute_name,p_entity_name));
1319:
1320: EXCEPTION
1321: WHEN FND_API.G_EXC_ERROR THEN
1322: RAISE FND_API.G_EXC_ERROR;
1323: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1325:
1326: WHEN OTHERS THEN

Line 1323: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1319:
1320: EXCEPTION
1321: WHEN FND_API.G_EXC_ERROR THEN
1322: RAISE FND_API.G_EXC_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');

Line 1324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1320: EXCEPTION
1321: WHEN FND_API.G_EXC_ERROR THEN
1322: RAISE FND_API.G_EXC_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');

Line 1331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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 (
1335: p_original_value IN VARCHAR2,

Line 1345: WHEN FND_API.G_EXC_ERROR THEN

1341: BEGIN
1342: return '#' || EXACT(p_original_value,p_language,p_attribute_name,p_entity_name) || '#'
1343: ;
1344: EXCEPTION
1345: WHEN FND_API.G_EXC_ERROR THEN
1346: RAISE FND_API.G_EXC_ERROR;
1347: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1348: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1349:

Line 1346: RAISE FND_API.G_EXC_ERROR;

1342: return '#' || EXACT(p_original_value,p_language,p_attribute_name,p_entity_name) || '#'
1343: ;
1344: EXCEPTION
1345: WHEN FND_API.G_EXC_ERROR THEN
1346: RAISE FND_API.G_EXC_ERROR;
1347: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1348: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1349:
1350: WHEN OTHERS THEN

Line 1347: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1343: ;
1344: EXCEPTION
1345: WHEN FND_API.G_EXC_ERROR THEN
1346: RAISE FND_API.G_EXC_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');

Line 1348: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1344: EXCEPTION
1345: WHEN FND_API.G_EXC_ERROR THEN
1346: RAISE FND_API.G_EXC_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');

Line 1355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
1359:

Line 1403: WHEN FND_API.G_EXC_ERROR THEN

1399: RETURN CLEANSED(word_replace(retstr, 5, p_language));
1400: END IF;
1401:
1402: EXCEPTION
1403: WHEN FND_API.G_EXC_ERROR THEN
1404: RAISE FND_API.G_EXC_ERROR;
1405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1407:

Line 1404: RAISE FND_API.G_EXC_ERROR;

1400: END IF;
1401:
1402: EXCEPTION
1403: WHEN FND_API.G_EXC_ERROR THEN
1404: RAISE FND_API.G_EXC_ERROR;
1405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1407:
1408: WHEN OTHERS THEN

Line 1405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1401:
1402: EXCEPTION
1403: WHEN FND_API.G_EXC_ERROR THEN
1404: RAISE FND_API.G_EXC_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');

Line 1406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1402: EXCEPTION
1403: WHEN FND_API.G_EXC_ERROR THEN
1404: RAISE FND_API.G_EXC_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');

Line 1413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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 (
1417: p_original_value IN VARCHAR2,

Line 1445: WHEN FND_API.G_EXC_ERROR THEN

1441: ELSE
1442: RETURN LTRIM(RTRIM(CLEANSED(word_replace(retstr, 5, p_language))));
1443: END IF;
1444: EXCEPTION
1445: WHEN FND_API.G_EXC_ERROR THEN
1446: RAISE FND_API.G_EXC_ERROR;
1447: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1449:

Line 1446: RAISE FND_API.G_EXC_ERROR;

1442: RETURN LTRIM(RTRIM(CLEANSED(word_replace(retstr, 5, p_language))));
1443: END IF;
1444: EXCEPTION
1445: WHEN FND_API.G_EXC_ERROR THEN
1446: RAISE FND_API.G_EXC_ERROR;
1447: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1449:
1450: WHEN OTHERS THEN

Line 1447: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1443: END IF;
1444: EXCEPTION
1445: WHEN FND_API.G_EXC_ERROR THEN
1446: RAISE FND_API.G_EXC_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');

Line 1448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1444: EXCEPTION
1445: WHEN FND_API.G_EXC_ERROR THEN
1446: RAISE FND_API.G_EXC_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');

Line 1455: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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,
1459: p_language IN VARCHAR2,

Line 2370: WHEN FND_API.G_EXC_ERROR THEN

2366:
2367: RETURN l_retstr;
2368:
2369: EXCEPTION
2370: WHEN FND_API.G_EXC_ERROR THEN
2371: RAISE FND_API.G_EXC_ERROR;
2372: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2374:

Line 2371: RAISE FND_API.G_EXC_ERROR;

2367: RETURN l_retstr;
2368:
2369: EXCEPTION
2370: WHEN FND_API.G_EXC_ERROR THEN
2371: RAISE FND_API.G_EXC_ERROR;
2372: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2374:
2375: WHEN OTHERS THEN

Line 2372: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2368:
2369: EXCEPTION
2370: WHEN FND_API.G_EXC_ERROR THEN
2371: RAISE FND_API.G_EXC_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');

Line 2373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2369: EXCEPTION
2370: WHEN FND_API.G_EXC_ERROR THEN
2371: RAISE FND_API.G_EXC_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');

Line 2380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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 (
2384: p_original_value VARCHAR2,

Line 2398: WHEN FND_API.G_EXC_ERROR THEN

2394: 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz ',
2395: 'ABCDEFGHIJKLMNOPQRSTUVWXYZ');
2396:
2397: EXCEPTION
2398: WHEN FND_API.G_EXC_ERROR THEN
2399: RAISE FND_API.G_EXC_ERROR;
2400: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2402:

Line 2399: RAISE FND_API.G_EXC_ERROR;

2395: 'ABCDEFGHIJKLMNOPQRSTUVWXYZ');
2396:
2397: EXCEPTION
2398: WHEN FND_API.G_EXC_ERROR THEN
2399: RAISE FND_API.G_EXC_ERROR;
2400: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2402:
2403: WHEN OTHERS THEN

Line 2400: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2396:
2397: EXCEPTION
2398: WHEN FND_API.G_EXC_ERROR THEN
2399: RAISE FND_API.G_EXC_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');

Line 2401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2397: EXCEPTION
2398: WHEN FND_API.G_EXC_ERROR THEN
2399: RAISE FND_API.G_EXC_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');

Line 2408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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 (
2412: p_original_value IN VARCHAR2,