658: into l_cur_sort
659: from v$nls_parameters
660: where parameter = 'NLS_SORT';
661:
662: dbms_session.set_nls('NLS_LANGUAGE', 'AMERICAN');
663:
664: fnd_message.set_encoded(l_enc_msg);
665:
666: l_msg_text := fnd_message.get;
664: fnd_message.set_encoded(l_enc_msg);
665:
666: l_msg_text := fnd_message.get;
667:
668: dbms_session.set_nls('NLS_LANGUAGE', '"' || l_cur_lang || '"');
669: dbms_session.set_nls('NLS_DATE_LANGUAGE', '"' || l_cur_date_lang || '"');
670: dbms_session.set_nls('NLS_SORT', '"' || l_cur_sort || '"');
671:
672:
665:
666: l_msg_text := fnd_message.get;
667:
668: dbms_session.set_nls('NLS_LANGUAGE', '"' || l_cur_lang || '"');
669: dbms_session.set_nls('NLS_DATE_LANGUAGE', '"' || l_cur_date_lang || '"');
670: dbms_session.set_nls('NLS_SORT', '"' || l_cur_sort || '"');
671:
672:
673: /* Unique exception enhancement: Check fnd_log_unique_exceptions table for a row */
666: l_msg_text := fnd_message.get;
667:
668: dbms_session.set_nls('NLS_LANGUAGE', '"' || l_cur_lang || '"');
669: dbms_session.set_nls('NLS_DATE_LANGUAGE', '"' || l_cur_date_lang || '"');
670: dbms_session.set_nls('NLS_SORT', '"' || l_cur_sort || '"');
671:
672:
673: /* Unique exception enhancement: Check fnd_log_unique_exceptions table for a row */
674: /* with this same message. If one exists already, increment the exception count */