DBA Data[Home] [Help]

APPS.AZW_HIER dependencies on FND_LANGUAGES

Line 48: v_language_code fnd_languages.language_code%TYPE DEFAULT NULL;

44:
45: g_current_mode az_processes.process_type%TYPE ;
46:
47: msg_delimiter VARCHAR2(1) := '^';
48: v_language_code fnd_languages.language_code%TYPE DEFAULT NULL;
49: v_language fnd_languages.nls_language%TYPE DEFAULT NULL;
50: v_days varchar2(8) DEFAULT NULL;
51: v_skip varchar2(8) DEFAULT NULL;
52: v_done varchar2(8) DEFAULT NULL;

Line 49: v_language fnd_languages.nls_language%TYPE DEFAULT NULL;

45: g_current_mode az_processes.process_type%TYPE ;
46:
47: msg_delimiter VARCHAR2(1) := '^';
48: v_language_code fnd_languages.language_code%TYPE DEFAULT NULL;
49: v_language fnd_languages.nls_language%TYPE DEFAULT NULL;
50: v_days varchar2(8) DEFAULT NULL;
51: v_skip varchar2(8) DEFAULT NULL;
52: v_done varchar2(8) DEFAULT NULL;
53: v_priority_display varchar2(16) DEFAULT NULL;

Line 770: from fnd_languages

766: IF (v_language_code is null) THEN
767: BEGIN
768: select distinct language_code, nls_language
769: into v_language_code, v_language
770: from fnd_languages
771: where NLS_LANGUAGE =
772: SUBSTR(USERENV('LANGUAGE'), 1, INSTR(USERENV('LANGUAGE'), '_')-1);
773: EXCEPTION
774: WHEN app_exception.application_exception THEN

Line 781: fnd_message.set_token('AZW_ERROR_STMT','select language_code ... from fnd_languages');

777: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
778: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
779: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
780: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_hierarchy');
781: fnd_message.set_token('AZW_ERROR_STMT','select language_code ... from fnd_languages');
782: APP_EXCEPTION.RAISE_EXCEPTION;
783: END;
784: END IF;
785:

Line 1533: from fnd_languages

1529: -- get the current session language
1530: BEGIN
1531: select distinct language_code, nls_language
1532: into v_language_code, v_language
1533: from fnd_languages
1534: where NLS_LANGUAGE =
1535: SUBSTR(USERENV('LANGUAGE'), 1, INSTR(USERENV('LANGUAGE'), '_')-1);
1536:
1537: EXCEPTION

Line 1545: fnd_message.set_token('AZW_ERROR_STMT','select language_code .. from fnd_languages');

1541: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1542: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1543: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1544: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_hierarchy');
1545: fnd_message.set_token('AZW_ERROR_STMT','select language_code .. from fnd_languages');
1546: APP_EXCEPTION.RAISE_EXCEPTION;
1547: END;
1548:
1549: -- initialize the language specific display labels for task's label