50: END;
51:
52:
53: /* logs messages using the JTT framework */
54: /* log_level: fnd_log.statement, fnd_log.procedure, fnd_log.event, fnd_log.exception, fnd_log.error */
55: PROCEDURE LOG(message IN VARCHAR2,
56: module IN VARCHAR2 DEFAULT 'CSM',
57: log_level IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT)
58: IS
53: /* logs messages using the JTT framework */
54: /* log_level: fnd_log.statement, fnd_log.procedure, fnd_log.event, fnd_log.exception, fnd_log.error */
55: PROCEDURE LOG(message IN VARCHAR2,
56: module IN VARCHAR2 DEFAULT 'CSM',
57: log_level IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT)
58: IS
59: l_message VARCHAR2(4000);
60: BEGIN
61: -- csm_saj_log_pkg.log(module,message);
60: BEGIN
61: -- csm_saj_log_pkg.log(module,message);
62: l_message := message;
63: IF g_initialize_log = TRUE THEN
64: IF (log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
65: FND_LOG.STRING(log_level, module, l_message);
66: END IF;
67: ELSE
68: fnd_log_repository.init();
61: -- csm_saj_log_pkg.log(module,message);
62: l_message := message;
63: IF g_initialize_log = TRUE THEN
64: IF (log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
65: FND_LOG.STRING(log_level, module, l_message);
66: END IF;
67: ELSE
68: fnd_log_repository.init();
69: g_initialize_log := TRUE;
64: IF (log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
65: FND_LOG.STRING(log_level, module, l_message);
66: END IF;
67: ELSE
68: fnd_log_repository.init();
69: g_initialize_log := TRUE;
70: IF (log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
71: fnd_log.string(log_level, module, l_message);
72: END IF;
66: END IF;
67: ELSE
68: fnd_log_repository.init();
69: g_initialize_log := TRUE;
70: IF (log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
71: fnd_log.string(log_level, module, l_message);
72: END IF;
73: END IF;
74: END LOG;
67: ELSE
68: fnd_log_repository.init();
69: g_initialize_log := TRUE;
70: IF (log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
71: fnd_log.string(log_level, module, l_message);
72: END IF;
73: END IF;
74: END LOG;
75:
1840:
1841: EXCEPTION
1842: WHEN OTHERS THEN
1843: l_err_msg := 'Failed csm_util_pkg.is_flow_history : ' || p_flowtype;
1844: CSM_UTIL_PKG.LOG(l_err_msg, 'CSM_UTIL_PKG.IS_FLOW_HISTORY', FND_LOG.LEVEL_ERROR);
1845: RETURN FALSE;
1846: END is_flow_history;
1847:
1848: FUNCTION get_debrief_header_id(p_debrief_header_id in CSF_DEBRIEF_HEADERS.DEBRIEF_HEADER_ID%TYPE)