DBA Data[Home] [Help]

APPS.PON_AUCTION_PKG dependencies on DBMS_SESSION

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

6480:
6481: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6482: FND_LOG.string(log_level => FND_LOG.level_statement,
6483: module => g_module_prefix || 'SET_SESSION_LANGUAGE',
6484: message => 'p_language is not NULL so calling the dbms_session.set_nls with p_language : '|| p_language);
6485: END IF; --}
6486:
6487: dbms_session.set_nls('NLS_LANGUAGE', p_language);
6488: else

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

6483: module => g_module_prefix || 'SET_SESSION_LANGUAGE',
6484: message => 'p_language is not NULL so calling the dbms_session.set_nls with p_language : '|| p_language);
6485: END IF; --}
6486:
6487: dbms_session.set_nls('NLS_LANGUAGE', p_language);
6488: else
6489:
6490: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6491: FND_LOG.string(log_level => FND_LOG.level_statement,

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

6497: into x_language
6498: from fnd_languages
6499: where language_code = x_language_code;
6500:
6501: dbms_session.set_nls('NLS_LANGUAGE', x_language);
6502:
6503: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6504: FND_LOG.string(log_level => FND_LOG.level_statement,
6505: module => g_module_prefix || 'SET_SESSION_LANGUAGE',

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

6502:
6503: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6504: FND_LOG.string(log_level => FND_LOG.level_statement,
6505: module => g_module_prefix || 'SET_SESSION_LANGUAGE',
6506: message => 'x_language : ' || x_language ||'; calling dbms_session.set_nls with x_language : '|| x_language);
6507: END IF; --}
6508:
6509: end if;
6510: exception

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

6545: message => 'Entered the procedure; g_original_language : ' || g_original_language);
6546: END IF; --}
6547:
6548: begin
6549: --dbms_session.set_nls('NLS_LANGUAGE', 'AMERICAN');
6550: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6551: FND_LOG.string(log_level => FND_LOG.level_statement,
6552: module => g_module_prefix || 'UNSET_SESSION_LANGUAGE',
6553: message => 'calling dbms_session.set_nls with g_original_language : ' || g_original_language);

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

6549: --dbms_session.set_nls('NLS_LANGUAGE', 'AMERICAN');
6550: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6551: FND_LOG.string(log_level => FND_LOG.level_statement,
6552: module => g_module_prefix || 'UNSET_SESSION_LANGUAGE',
6553: message => 'calling dbms_session.set_nls with g_original_language : ' || g_original_language);
6554: END IF; --}
6555:
6556: dbms_session.set_nls('NLS_LANGUAGE', g_original_language);
6557: exception

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

6552: module => g_module_prefix || 'UNSET_SESSION_LANGUAGE',
6553: message => 'calling dbms_session.set_nls with g_original_language : ' || g_original_language);
6554: END IF; --}
6555:
6556: dbms_session.set_nls('NLS_LANGUAGE', g_original_language);
6557: exception
6558: when others then
6559: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6560: FND_LOG.string(log_level => FND_LOG.level_statement,