APPS.WSH_EXTREPS_MLS_LANG dependencies on FND_LANGUAGES

Line 53: SELECT language_code INTO l_base_lang FROM fnd_languages

49: END IF;
50: --
51:
52: -- Get base language
53: SELECT language_code INTO l_base_lang FROM fnd_languages
54: WHERE installed_flag = 'B';
55:
56: -- 4497301 : creating the v_FROM depending on whether a Trip is there or not
57: -- 4248303 : Making use of hz_locations for language field.

Line 519: /* if program is nls_compliant then use the default territory from fnd_languages,

515: end if;
516:
517: /* get nls_language and nls_territory for each language_code */
518: for i in 1..p_lcount loop
519: /* if program is nls_compliant then use the default territory from fnd_languages,
520: otherwise use user environment */
521: if ( p_nls_comp = 'Y' ) then
522: begin
523: select nls_language, nls_territory

Line 525: from fnd_languages

521: if ( p_nls_comp = 'Y' ) then
522: begin
523: select nls_language, nls_territory
524: into x_nls_lang(i).nls_language, x_nls_lang(i).nls_territory
525: from fnd_languages
526: where language_code = x_nls_lang(i).lang_code;
527: exception
528: when no_data_found then
529: IF l_debug_on THEN

Line 530: WSH_DEBUG_SV.logmsg(l_module_name,'No data found in fnd_languages for :'|| x_nls_lang(i).lang_code);

526: where language_code = x_nls_lang(i).lang_code;
527: exception
528: when no_data_found then
529: IF l_debug_on THEN
530: WSH_DEBUG_SV.logmsg(l_module_name,'No data found in fnd_languages for :'|| x_nls_lang(i).lang_code);
531: END IF;
532: raise ;
533: end;
534: else

Line 539: from fnd_languages

535: /* use territory from the user environment which is parent_id's nls_territory */
536: begin
537: select nls_language
538: into x_nls_lang(i).nls_language
539: from fnd_languages
540: where language_code = x_nls_lang(i).lang_code;
541: exception
542: when no_data_found then
543: IF l_debug_on THEN

Line 544: WSH_DEBUG_SV.logmsg(l_module_name,'No data found in fnd_languages for :'|| x_nls_lang(i).lang_code);

540: where language_code = x_nls_lang(i).lang_code;
541: exception
542: when no_data_found then
543: IF l_debug_on THEN
544: WSH_DEBUG_SV.logmsg(l_module_name,'No data found in fnd_languages for :'|| x_nls_lang(i).lang_code);
545: END IF;
546: raise ;
547: end;
548: