DBA Data[Home] [Help]

APPS.JTF_DEBUG_PUB dependencies on FND_LOG

Line 132: if FND_LOG.TEST (p_log_level, p_module) then

128: l_icx_session_id := p_icx_session_id;
129: end if;
130: */
131: /* Bug #3468334 */
132: if FND_LOG.TEST (p_log_level, p_module) then
133: if (p_icx_session_id is NULL) then
134: l_icx_session_id := -1;
135: else
136: l_icx_session_id := p_icx_session_id;

Line 139: if (p_log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

135: else
136: l_icx_session_id := p_icx_session_id;
137: end if;
138:
139: if (p_log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
140: FND_LOG.STRING(p_log_level, p_module, p_message);
141: COMMIT;
142: end if;
143: end if;

Line 140: FND_LOG.STRING(p_log_level, p_module, p_message);

136: l_icx_session_id := p_icx_session_id;
137: end if;
138:
139: if (p_log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
140: FND_LOG.STRING(p_log_level, p_module, p_message);
141: COMMIT;
142: end if;
143: end if;
144: end LOG_DEBUG;

Line 170: if FND_LOG.TEST (FND_LOG.LEVEL_PROCEDURE, p_module) then

166: begin
167:
168: -- Invoking the actual method with global parameter
169: /* Bug #3468334 */
170: if FND_LOG.TEST (FND_LOG.LEVEL_PROCEDURE, p_module) then
171:
172: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
173: LOG_DEBUG( FND_LOG.LEVEL_PROCEDURE, p_module, 'Entered procedure : ' || p_message || ' at ' || SUBSTR(TO_CHAR(9999999999+DBMS_UTILITY.GET_TIME),5) , G_ICX_SESSION_ID );
174: end if;

Line 172: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

168: -- Invoking the actual method with global parameter
169: /* Bug #3468334 */
170: if FND_LOG.TEST (FND_LOG.LEVEL_PROCEDURE, p_module) then
171:
172: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
173: LOG_DEBUG( FND_LOG.LEVEL_PROCEDURE, p_module, 'Entered procedure : ' || p_message || ' at ' || SUBSTR(TO_CHAR(9999999999+DBMS_UTILITY.GET_TIME),5) , G_ICX_SESSION_ID );
174: end if;
175: end if;
176: end LOG_ENTERING_METHOD;

Line 173: LOG_DEBUG( FND_LOG.LEVEL_PROCEDURE, p_module, 'Entered procedure : ' || p_message || ' at ' || SUBSTR(TO_CHAR(9999999999+DBMS_UTILITY.GET_TIME),5) , G_ICX_SESSION_ID );

169: /* Bug #3468334 */
170: if FND_LOG.TEST (FND_LOG.LEVEL_PROCEDURE, p_module) then
171:
172: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
173: LOG_DEBUG( FND_LOG.LEVEL_PROCEDURE, p_module, 'Entered procedure : ' || p_message || ' at ' || SUBSTR(TO_CHAR(9999999999+DBMS_UTILITY.GET_TIME),5) , G_ICX_SESSION_ID );
174: end if;
175: end if;
176: end LOG_ENTERING_METHOD;
177:

Line 186: if FND_LOG.TEST (FND_LOG.LEVEL_PROCEDURE, p_module) then

182: p_message IN VARCHAR2) is
183: begin
184:
185: -- Invoking the actual method with global parameter
186: if FND_LOG.TEST (FND_LOG.LEVEL_PROCEDURE, p_module) then
187:
188: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
189: LOG_DEBUG( FND_LOG.LEVEL_PROCEDURE, p_module, 'Exiting procedure : ' || p_message || ' at ' || SUBSTR(TO_CHAR(9999999999+DBMS_UTILITY.GET_TIME),5) , G_ICX_SESSION_ID );
190: end if;

Line 188: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

184:
185: -- Invoking the actual method with global parameter
186: if FND_LOG.TEST (FND_LOG.LEVEL_PROCEDURE, p_module) then
187:
188: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
189: LOG_DEBUG( FND_LOG.LEVEL_PROCEDURE, p_module, 'Exiting procedure : ' || p_message || ' at ' || SUBSTR(TO_CHAR(9999999999+DBMS_UTILITY.GET_TIME),5) , G_ICX_SESSION_ID );
190: end if;
191:
192: end if;

Line 189: LOG_DEBUG( FND_LOG.LEVEL_PROCEDURE, p_module, 'Exiting procedure : ' || p_message || ' at ' || SUBSTR(TO_CHAR(9999999999+DBMS_UTILITY.GET_TIME),5) , G_ICX_SESSION_ID );

185: -- Invoking the actual method with global parameter
186: if FND_LOG.TEST (FND_LOG.LEVEL_PROCEDURE, p_module) then
187:
188: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
189: LOG_DEBUG( FND_LOG.LEVEL_PROCEDURE, p_module, 'Exiting procedure : ' || p_message || ' at ' || SUBSTR(TO_CHAR(9999999999+DBMS_UTILITY.GET_TIME),5) , G_ICX_SESSION_ID );
190: end if;
191:
192: end if;
193: end LOG_EXITING_METHOD;

Line 203: LOG_DEBUG( FND_LOG.LEVEL_UNEXPECTED, p_module, p_message, G_ICX_SESSION_ID );

199: p_message IN VARCHAR2) is
200: begin
201:
202: -- Invoking the actual method with global parameter
203: LOG_DEBUG( FND_LOG.LEVEL_UNEXPECTED, p_module, p_message, G_ICX_SESSION_ID );
204: end LOG_UNEXPECTED_ERROR;
205:
206: /*
207: ** Utility method to write specific kind of logging messages

Line 214: LOG_DEBUG( FND_LOG.LEVEL_PROCEDURE, p_module, p_message, G_ICX_SESSION_ID );

210: p_message IN VARCHAR2) is
211: begin
212:
213: -- Invoking the actual method with global parameter
214: LOG_DEBUG( FND_LOG.LEVEL_PROCEDURE, p_module, p_message, G_ICX_SESSION_ID );
215: end LOG_PARAMETERS;
216:
217: /*
218: * A method to find out, if logging is on at the level of

Line 226: IF FND_LOG.TEST (FND_LOG.LEVEL_PROCEDURE, p_module) THEN

222: FUNCTION IS_LOG_PARAMETERS_ON( p_module IN VARCHAR2) RETURN BOOLEAN IS
223:
224: BEGIN
225:
226: IF FND_LOG.TEST (FND_LOG.LEVEL_PROCEDURE, p_module) THEN
227: RETURN TRUE;
228: ELSE
229: RETURN FALSE;
230: END IF;

Line 241: LOG_DEBUG( FND_LOG.LEVEL_EXCEPTION, p_module, p_message, G_ICX_SESSION_ID );

237: p_message IN VARCHAR2) is
238: begin
239:
240: -- Invoking the actual method with global parameter
241: LOG_DEBUG( FND_LOG.LEVEL_EXCEPTION, p_module, p_message, G_ICX_SESSION_ID );
242: end LOG_EXCEPTION;
243:
244: /*
245: ** Utility method to write specific kind of logging messages

Line 252: LOG_DEBUG( FND_LOG.LEVEL_EVENT, p_module, p_message, G_ICX_SESSION_ID );

248: p_message IN VARCHAR2) is
249: begin
250:
251: -- Invoking the actual method with global parameter
252: LOG_DEBUG( FND_LOG.LEVEL_EVENT, p_module, p_message, G_ICX_SESSION_ID );
253: end LOG_EVENT;
254:
255: /*
256: ** Utility method to write specific kind of logging messages

Line 263: LOG_DEBUG( FND_LOG.LEVEL_STATEMENT, p_module, p_message, G_ICX_SESSION_ID );

259: p_message IN VARCHAR2) is
260: begin
261:
262: -- Invoking the actual method with global parameter
263: LOG_DEBUG( FND_LOG.LEVEL_STATEMENT, p_module, p_message, G_ICX_SESSION_ID );
264: end LOG_STATEMENT;
265: ----------------------------------------------------------------------------
266: /** returns filename if alteast one message has been written to it.
267: otherwise returns NULL */

Line 282: FROM fnd_log_messages

278: ) IS
279:
280: CURSOR C_log_message(p_session_id NUMBER, p_user_id NUMBER, p_module VARCHAR2, p_timestamp VARCHAR2) IS
281: SELECT message_text
282: FROM fnd_log_messages
283: WHERE module like p_module
284: AND session_id = p_session_id
285: AND user_id = p_user_id
286: AND timestamp >= to_date(p_timestamp, 'DD-MM-YYYY HH24:MI:SS')

Line 312: if((FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then

308: FETCH C_current_time into l_timestamp;
309: CLOSE C_current_time;
310:
311:
312: if((FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
313:
314: FOR i in 1..p_debug_tbl.count LOOP
315:
316: fnd_log.String(FND_LOG.LEVEL_EVENT, p_debug_tbl(i).module_name,

Line 316: fnd_log.String(FND_LOG.LEVEL_EVENT, p_debug_tbl(i).module_name,

312: if((FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
313:
314: FOR i in 1..p_debug_tbl.count LOOP
315:
316: fnd_log.String(FND_LOG.LEVEL_EVENT, p_debug_tbl(i).module_name,
317: p_debug_tbl(i).debug_message);
318: END LOOP;
319: end if;
320: