DBA Data[Home] [Help]

APPS.PON_AUCTION_PKG dependencies on DBMS_SESSION

Line 5888: message => 'p_language is not NULL so calling the dbms_session.set_nls with p_language : '|| p_language);

5884:
5885: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
5886: FND_LOG.string(log_level => FND_LOG.level_statement,
5887: module => g_module_prefix || 'SET_SESSION_LANGUAGE',
5888: message => 'p_language is not NULL so calling the dbms_session.set_nls with p_language : '|| p_language);
5889: END IF; --}
5890:
5891: dbms_session.set_nls('NLS_LANGUAGE', p_language);
5892: else

Line 5891: dbms_session.set_nls('NLS_LANGUAGE', p_language);

5887: module => g_module_prefix || 'SET_SESSION_LANGUAGE',
5888: message => 'p_language is not NULL so calling the dbms_session.set_nls with p_language : '|| p_language);
5889: END IF; --}
5890:
5891: dbms_session.set_nls('NLS_LANGUAGE', p_language);
5892: else
5893:
5894: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
5895: FND_LOG.string(log_level => FND_LOG.level_statement,

Line 5905: dbms_session.set_nls('NLS_LANGUAGE', x_language);

5901: into x_language
5902: from fnd_languages
5903: where language_code = x_language_code;
5904:
5905: dbms_session.set_nls('NLS_LANGUAGE', x_language);
5906:
5907: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
5908: FND_LOG.string(log_level => FND_LOG.level_statement,
5909: module => g_module_prefix || 'SET_SESSION_LANGUAGE',

Line 5910: message => 'x_language : ' || x_language ||'; calling dbms_session.set_nls with x_language : '|| x_language);

5906:
5907: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
5908: FND_LOG.string(log_level => FND_LOG.level_statement,
5909: module => g_module_prefix || 'SET_SESSION_LANGUAGE',
5910: message => 'x_language : ' || x_language ||'; calling dbms_session.set_nls with x_language : '|| x_language);
5911: END IF; --}
5912:
5913: end if;
5914: exception

Line 5953: --dbms_session.set_nls('NLS_LANGUAGE', 'AMERICAN');

5949: message => 'Entered the procedure; g_original_language : ' || g_original_language);
5950: END IF; --}
5951:
5952: begin
5953: --dbms_session.set_nls('NLS_LANGUAGE', 'AMERICAN');
5954: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
5955: FND_LOG.string(log_level => FND_LOG.level_statement,
5956: module => g_module_prefix || 'UNSET_SESSION_LANGUAGE',
5957: message => 'calling dbms_session.set_nls with g_original_language : ' || g_original_language);

Line 5957: message => 'calling dbms_session.set_nls with g_original_language : ' || g_original_language);

5953: --dbms_session.set_nls('NLS_LANGUAGE', 'AMERICAN');
5954: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
5955: FND_LOG.string(log_level => FND_LOG.level_statement,
5956: module => g_module_prefix || 'UNSET_SESSION_LANGUAGE',
5957: message => 'calling dbms_session.set_nls with g_original_language : ' || g_original_language);
5958: END IF; --}
5959:
5960: dbms_session.set_nls('NLS_LANGUAGE', g_original_language);
5961: exception

Line 5960: dbms_session.set_nls('NLS_LANGUAGE', g_original_language);

5956: module => g_module_prefix || 'UNSET_SESSION_LANGUAGE',
5957: message => 'calling dbms_session.set_nls with g_original_language : ' || g_original_language);
5958: END IF; --}
5959:
5960: dbms_session.set_nls('NLS_LANGUAGE', g_original_language);
5961: exception
5962: when others then
5963: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
5964: FND_LOG.string(log_level => FND_LOG.level_statement,