201: -- This function is a wrapper on FND APIs for OA Common Error
202: -- logging framework
203: --
204: -- p_log_level = Severity; valid values are -
205: -- 1. Statement Level (FND_LOG.LEVEL_STATEMENT)
206: -- 2. Procedure Level (FND_LOG.LEVEL_PROCEDURE)
207: -- 3. Event Level (FND_LOG.LEVEL_EVENT)
208: -- 4. Exception Level (FND_LOG.LEVEL_EXCEPTION)
209: -- 5. Error Level (FND_LOG.LEVEL_ERROR)
202: -- logging framework
203: --
204: -- p_log_level = Severity; valid values are -
205: -- 1. Statement Level (FND_LOG.LEVEL_STATEMENT)
206: -- 2. Procedure Level (FND_LOG.LEVEL_PROCEDURE)
207: -- 3. Event Level (FND_LOG.LEVEL_EVENT)
208: -- 4. Exception Level (FND_LOG.LEVEL_EXCEPTION)
209: -- 5. Error Level (FND_LOG.LEVEL_ERROR)
210: -- 6. Unexpected Level (FND_LOG.LEVEL_UNEXPECTED)
203: --
204: -- p_log_level = Severity; valid values are -
205: -- 1. Statement Level (FND_LOG.LEVEL_STATEMENT)
206: -- 2. Procedure Level (FND_LOG.LEVEL_PROCEDURE)
207: -- 3. Event Level (FND_LOG.LEVEL_EVENT)
208: -- 4. Exception Level (FND_LOG.LEVEL_EXCEPTION)
209: -- 5. Error Level (FND_LOG.LEVEL_ERROR)
210: -- 6. Unexpected Level (FND_LOG.LEVEL_UNEXPECTED)
211: --
204: -- p_log_level = Severity; valid values are -
205: -- 1. Statement Level (FND_LOG.LEVEL_STATEMENT)
206: -- 2. Procedure Level (FND_LOG.LEVEL_PROCEDURE)
207: -- 3. Event Level (FND_LOG.LEVEL_EVENT)
208: -- 4. Exception Level (FND_LOG.LEVEL_EXCEPTION)
209: -- 5. Error Level (FND_LOG.LEVEL_ERROR)
210: -- 6. Unexpected Level (FND_LOG.LEVEL_UNEXPECTED)
211: --
212: -- Output values:-
205: -- 1. Statement Level (FND_LOG.LEVEL_STATEMENT)
206: -- 2. Procedure Level (FND_LOG.LEVEL_PROCEDURE)
207: -- 3. Event Level (FND_LOG.LEVEL_EVENT)
208: -- 4. Exception Level (FND_LOG.LEVEL_EXCEPTION)
209: -- 5. Error Level (FND_LOG.LEVEL_ERROR)
210: -- 6. Unexpected Level (FND_LOG.LEVEL_UNEXPECTED)
211: --
212: -- Output values:-
213: -- = TRUE if FND Log is Enabled or BIS Log is Enabled
206: -- 2. Procedure Level (FND_LOG.LEVEL_PROCEDURE)
207: -- 3. Event Level (FND_LOG.LEVEL_EVENT)
208: -- 4. Exception Level (FND_LOG.LEVEL_EXCEPTION)
209: -- 5. Error Level (FND_LOG.LEVEL_ERROR)
210: -- 6. Unexpected Level (FND_LOG.LEVEL_UNEXPECTED)
211: --
212: -- Output values:-
213: -- = TRUE if FND Log is Enabled or BIS Log is Enabled
214: -- = FALSE if both are DISABLED
209: -- 5. Error Level (FND_LOG.LEVEL_ERROR)
210: -- 6. Unexpected Level (FND_LOG.LEVEL_UNEXPECTED)
211: --
212: -- Output values:-
213: -- = TRUE if FND Log is Enabled or BIS Log is Enabled
214: -- = FALSE if both are DISABLED
215: --
216: --
217: -- **********************************************************************
218:
219: FUNCTION chkLogLevel (p_log_level IN NUMBER) RETURN BOOLEAN IS
220: BEGIN
221: g_debug := NVL(BIS_COLLECTION_UTILITIES.g_debug,FALSE);
222: IF (p_log_level >= fnd_log.G_CURRENT_RUNTIME_LEVEL) -- FND log is enabled
223: OR NVL(BIS_COLLECTION_UTILITIES.g_debug,FALSE) -- BIS Log is enabled
224: THEN
225: RETURN TRUE;
226: END IF;
243: -- , Event(3), Expected (4) and Error (5)
244: --
245: -- Input Variables :-
246: -- p_log_level = Severity; valid values are -
247: -- 1. Statement Level (FND_LOG.LEVEL_STATEMENT)
248: -- 2. Procedure Level (FND_LOG.LEVEL_PROCEDURE)
249: -- 3. Event Level (FND_LOG.LEVEL_EVENT)
250: -- 4. Exception Level (FND_LOG.LEVEL_EXCEPTION)
251: -- 5. Error Level (FND_LOG.LEVEL_ERROR)
244: --
245: -- Input Variables :-
246: -- p_log_level = Severity; valid values are -
247: -- 1. Statement Level (FND_LOG.LEVEL_STATEMENT)
248: -- 2. Procedure Level (FND_LOG.LEVEL_PROCEDURE)
249: -- 3. Event Level (FND_LOG.LEVEL_EVENT)
250: -- 4. Exception Level (FND_LOG.LEVEL_EXCEPTION)
251: -- 5. Error Level (FND_LOG.LEVEL_ERROR)
252: -- 6. Unexpected Level (FND_LOG.LEVEL_UNEXPECTED)
245: -- Input Variables :-
246: -- p_log_level = Severity; valid values are -
247: -- 1. Statement Level (FND_LOG.LEVEL_STATEMENT)
248: -- 2. Procedure Level (FND_LOG.LEVEL_PROCEDURE)
249: -- 3. Event Level (FND_LOG.LEVEL_EVENT)
250: -- 4. Exception Level (FND_LOG.LEVEL_EXCEPTION)
251: -- 5. Error Level (FND_LOG.LEVEL_ERROR)
252: -- 6. Unexpected Level (FND_LOG.LEVEL_UNEXPECTED)
253: -- p_module = Module Source Details
246: -- p_log_level = Severity; valid values are -
247: -- 1. Statement Level (FND_LOG.LEVEL_STATEMENT)
248: -- 2. Procedure Level (FND_LOG.LEVEL_PROCEDURE)
249: -- 3. Event Level (FND_LOG.LEVEL_EVENT)
250: -- 4. Exception Level (FND_LOG.LEVEL_EXCEPTION)
251: -- 5. Error Level (FND_LOG.LEVEL_ERROR)
252: -- 6. Unexpected Level (FND_LOG.LEVEL_UNEXPECTED)
253: -- p_module = Module Source Details
254: -- p_msg = Message String
247: -- 1. Statement Level (FND_LOG.LEVEL_STATEMENT)
248: -- 2. Procedure Level (FND_LOG.LEVEL_PROCEDURE)
249: -- 3. Event Level (FND_LOG.LEVEL_EVENT)
250: -- 4. Exception Level (FND_LOG.LEVEL_EXCEPTION)
251: -- 5. Error Level (FND_LOG.LEVEL_ERROR)
252: -- 6. Unexpected Level (FND_LOG.LEVEL_UNEXPECTED)
253: -- p_module = Module Source Details
254: -- p_msg = Message String
255: -- p_force_log = Force message in log file. Default False.
248: -- 2. Procedure Level (FND_LOG.LEVEL_PROCEDURE)
249: -- 3. Event Level (FND_LOG.LEVEL_EVENT)
250: -- 4. Exception Level (FND_LOG.LEVEL_EXCEPTION)
251: -- 5. Error Level (FND_LOG.LEVEL_ERROR)
252: -- 6. Unexpected Level (FND_LOG.LEVEL_UNEXPECTED)
253: -- p_module = Module Source Details
254: -- p_msg = Message String
255: -- p_force_log = Force message in log file. Default False.
256: --
275: TB checked up with weijun if this is the intended func.
276: */
277:
278: l_msg := TO_CHAR(SYSDATE,'YYYY/MM/DD HH24:MI:SS');
279: IF (p_log_level IN (fnd_log.LEVEL_ERROR, fnd_log.LEVEL_UNEXPECTED)) THEN
280: BIS_COLLECTION_UTILITIES.put_line_out(p_msg);
281:
282: --this line will put the gist of the error message in the log file
283: BIS_COLLECTION_UTILITIES.put_line(l_msg || ' : ' || p_module || ' : ' || p_msg,p_log_level);