97: l_base_meter_id NUMBER;
98: l_api_name CONSTANT VARCHAR2(30) := 'convert_work_orders2';
99:
100: l_module varchar2(200) ;
101: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
102: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level ;
103: l_sLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_statement >= l_log_level;
104:
105:
98: l_api_name CONSTANT VARCHAR2(30) := 'convert_work_orders2';
99:
100: l_module varchar2(200) ;
101: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
102: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level ;
103: l_sLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_statement >= l_log_level;
104:
105:
106: -- This cursor returns all necessary fields to call the WO API.modified for ib
99:
100: l_module varchar2(200) ;
101: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
102: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level ;
103: l_sLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_statement >= l_log_level;
104:
105:
106: -- This cursor returns all necessary fields to call the WO API.modified for ib
107: --modified for performance issues
384:
385: EAM_ERROR_MESSAGE_PVT.Get_Message(l_message_text, l_entity_index, l_entity_id, l_message_type);
386:
387: IF( l_slog ) THEN
388: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'Return status:' || p_return_status);
389: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'Error message:' || SUBSTRB(l_message_text,1,200));
390: END IF;
391: END convert_work_orders2;
392: procedure convert_work_orders3(p_pm_group_id number,
385: EAM_ERROR_MESSAGE_PVT.Get_Message(l_message_text, l_entity_index, l_entity_id, l_message_type);
386:
387: IF( l_slog ) THEN
388: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'Return status:' || p_return_status);
389: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'Error message:' || SUBSTRB(l_message_text,1,200));
390: END IF;
391: END convert_work_orders2;
392: procedure convert_work_orders3(p_pm_group_id number,
393: p_project_id IN NUMBER DEFAULT NULL,
449: l_org_id number;
450: l_api_name CONSTANT VARCHAR2(30) := 'convert_work_orders2';
451:
452: l_module varchar2(200) ;
453: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
454: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level ;
455: l_sLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_statement >= l_log_level;
456:
457:
450: l_api_name CONSTANT VARCHAR2(30) := 'convert_work_orders2';
451:
452: l_module varchar2(200) ;
453: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
454: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level ;
455: l_sLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_statement >= l_log_level;
456:
457:
458: -- This cursor returns all necessary fields to call the WO API.modified for ib
451:
452: l_module varchar2(200) ;
453: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
454: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level ;
455: l_sLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_statement >= l_log_level;
456:
457:
458: -- This cursor returns all necessary fields to call the WO API.modified for ib
459: --modified for performance issues
658:
659: EAM_ERROR_MESSAGE_PVT.Get_Message(l_message_text, l_entity_index, l_entity_id, l_message_type);
660:
661: IF( l_slog ) THEN
662: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'Return status:' || p_return_status);
663: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'Error message:' || SUBSTRB(l_message_text,1,200));
664: END IF;
665: END convert_work_orders3;
666:
659: EAM_ERROR_MESSAGE_PVT.Get_Message(l_message_text, l_entity_index, l_entity_id, l_message_type);
660:
661: IF( l_slog ) THEN
662: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'Return status:' || p_return_status);
663: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'Error message:' || SUBSTRB(l_message_text,1,200));
664: END IF;
665: END convert_work_orders3;
666:
667: