DBA Data[Home] [Help]

APPS.EAM_FORECAST_PVT dependencies on FND_LOG

Line 4: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1: PACKAGE BODY "EAM_FORECAST_PVT" AS
2: /* $Header: EAMVFORB.pls 120.24.12020000.8 2012/12/07 10:14:38 srkotika ship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'EAM_FOREACST_PVT';
4: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: G_FILE_NAME CONSTANT VARCHAR2(30) := 'EAMVFORB.pls';
6: -- TODO: Propagate OA required parameters back to the top level
7: -- extract_forecast ....eg api_version, status...is this required?
8:

Line 455: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;

451: /* This is a private PROCEDURE that extracts a historical forecast */
452:
453: PROCEDURE debug(l_msg IN VARCHAR2, l_level IN NUMBER := 1)IS
454: l_n NUMBER;
455: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
456: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level ;
457: l_sLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_statement >= l_log_level;
458:
459: BEGIN

Line 456: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level ;

452:
453: PROCEDURE debug(l_msg IN VARCHAR2, l_level IN NUMBER := 1)IS
454: l_n NUMBER;
455: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
456: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level ;
457: l_sLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_statement >= l_log_level;
458:
459: BEGIN
460: IF(l_level >= 1)

Line 457: l_sLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_statement >= l_log_level;

453: PROCEDURE debug(l_msg IN VARCHAR2, l_level IN NUMBER := 1)IS
454: l_n NUMBER;
455: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
456: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level ;
457: l_sLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_statement >= l_log_level;
458:
459: BEGIN
460: IF(l_level >= 1)
461: THEN

Line 463: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

459: BEGIN
460: IF(l_level >= 1)
461: THEN
462: IF( l_sLog ) THEN
463: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
464: 'eam.plsql.EAM_FORECAST_PVT.extract_forecast',l_msg);
465: -- dbms_OUTPUT.put_line('DEBUG:: ' || l_msg);
466: l_n := 1;
467: END IF;

Line 3181: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;

3177:
3178: l_api_name CONSTANT VARCHAR2(30) := 'convert_work_orders';
3179:
3180: l_module varchar2(200) ;
3181: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
3182: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level ;
3183: l_sLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_statement >= l_log_level;
3184:
3185: -- This cursor returns all necessary fields to call the WO API.modified for ib

Line 3182: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level ;

3178: l_api_name CONSTANT VARCHAR2(30) := 'convert_work_orders';
3179:
3180: l_module varchar2(200) ;
3181: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
3182: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level ;
3183: l_sLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_statement >= l_log_level;
3184:
3185: -- This cursor returns all necessary fields to call the WO API.modified for ib
3186: -- Query changed for performance reasons.

Line 3183: l_sLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_statement >= l_log_level;

3179:
3180: l_module varchar2(200) ;
3181: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
3182: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level ;
3183: l_sLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_statement >= l_log_level;
3184:
3185: -- This cursor returns all necessary fields to call the WO API.modified for ib
3186: -- Query changed for performance reasons.
3187: CURSOR c1 IS

Line 3376: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'Return status:' || p_return_status);

3372: EAM_ERROR_MESSAGE_PVT.Get_Message(l_message_text, l_entity_index, l_entity_id, l_message_type);
3373: debug('Return status:' || p_return_status);
3374: debug('Error message:' || SUBSTRB(l_message_text,1,200));
3375: IF( l_slog ) THEN
3376: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'Return status:' || p_return_status);
3377: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'Error message:' || SUBSTRB(l_message_text,1,200));
3378: END IF;
3379: END convert_work_orders;
3380:

Line 3377: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'Error message:' || SUBSTRB(l_message_text,1,200));

3373: debug('Return status:' || p_return_status);
3374: debug('Error message:' || SUBSTRB(l_message_text,1,200));
3375: IF( l_slog ) THEN
3376: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'Return status:' || p_return_status);
3377: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'Error message:' || SUBSTRB(l_message_text,1,200));
3378: END IF;
3379: END convert_work_orders;
3380:
3381: