DBA Data[Home] [Help]

APPS.PJI_UTILS dependencies on PJI_SYSTEM_DEBUG_MSG

Line 268: insert into PJI_SYSTEM_DEBUG_MSG

264: if (l_output_dest is null or l_output_dest = 'TABLE') then
265:
266: if (p_debug_level >= g_debug_level) then
267:
268: insert into PJI_SYSTEM_DEBUG_MSG
269: (
270: MESSAGE_ID,
271: MESSAGE_LEVEL,
272: MESSAGE_CONTEXT,

Line 281: PJI_SYSTEM_DEBUG_MSG_S.NEXTVAL,

277: CREATION_DATE
278: )
279: values
280: (
281: PJI_SYSTEM_DEBUG_MSG_S.NEXTVAL,
282: p_debug_level,
283: nvl(g_debug_context, g_session_osuser || '$' || g_session_sid),
284: p_msg || l_timestamp,
285: 'LOG',

Line 310: -- In PJI_SYSTEM_DEBUG_MSG, output file lines have MESSAGE_LEVEL = 6 to

306:
307: -- ------------------------------------------------------
308: -- procedure WRITE2OUT
309: --
310: -- In PJI_SYSTEM_DEBUG_MSG, output file lines have MESSAGE_LEVEL = 6 to
311: -- distiguish from debugging messages.
312: --
313: -- ------------------------------------------------------
314: procedure WRITE2OUT (p_msg in varchar2) is

Line 325: insert into PJI_SYSTEM_DEBUG_MSG

321: g_output_dest);
322:
323: if (l_output_dest = 'TABLE') then
324:
325: insert into PJI_SYSTEM_DEBUG_MSG
326: (
327: MESSAGE_ID,
328: MESSAGE_LEVEL,
329: MESSAGE_CONTEXT,

Line 338: PJI_SYSTEM_DEBUG_MSG_S.NEXTVAL,

334: CREATION_DATE
335: )
336: values
337: (
338: PJI_SYSTEM_DEBUG_MSG_S.NEXTVAL,
339: 6,
340: nvl(g_debug_context, g_session_osuser || '$' || g_session_sid),
341: p_msg,
342: 'OUT',

Line 409: insert into PJI_SYSTEM_DEBUG_MSG

405: end if;
406:
407: if g_pa_debug_mode = 'Y' then
408:
409: insert into PJI_SYSTEM_DEBUG_MSG
410: (
411: MESSAGE_ID
412: , MESSAGE_LEVEL
413: , MESSAGE_CONTEXT

Line 422: PJI_SYSTEM_DEBUG_MSG_S.NEXTVAL

418: , CREATION_DATE
419: )
420: values
421: (
422: PJI_SYSTEM_DEBUG_MSG_S.NEXTVAL
423: , p_debug_level
424: , fnd_global.user_id || '$' || g_session_sid
425: , p_msg
426: , 'SSWA'