APPS.PJI_UTILS dependencies on PJI_SYSTEM_DEBUG_MSG

Line 288: insert into PJI_SYSTEM_DEBUG_MSG

284: if (l_output_dest is null or l_output_dest = 'TABLE') then
285:
286: if (p_debug_level >= g_debug_level) then
287:
288: insert into PJI_SYSTEM_DEBUG_MSG
289: (
290: MESSAGE_ID,
291: MESSAGE_LEVEL,
292: MESSAGE_CONTEXT,

Line 301: PJI_SYSTEM_DEBUG_MSG_S.NEXTVAL,

297: CREATION_DATE
298: )
299: values
300: (
301: PJI_SYSTEM_DEBUG_MSG_S.NEXTVAL,
302: p_debug_level,
303: nvl(g_debug_context, g_session_osuser || '$' || g_session_sid),
304: p_msg || l_timestamp,
305: 'LOG',

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

326:
327: -- ------------------------------------------------------
328: -- procedure WRITE2OUT
329: --
330: -- In PJI_SYSTEM_DEBUG_MSG, output file lines have MESSAGE_LEVEL = 6 to
331: -- distiguish from debugging messages.
332: --
333: -- ------------------------------------------------------
334: procedure WRITE2OUT (p_msg in varchar2) is

Line 345: insert into PJI_SYSTEM_DEBUG_MSG

341: g_output_dest);
342:
343: if (l_output_dest = 'TABLE') then
344:
345: insert into PJI_SYSTEM_DEBUG_MSG
346: (
347: MESSAGE_ID,
348: MESSAGE_LEVEL,
349: MESSAGE_CONTEXT,

Line 358: PJI_SYSTEM_DEBUG_MSG_S.NEXTVAL,

354: CREATION_DATE
355: )
356: values
357: (
358: PJI_SYSTEM_DEBUG_MSG_S.NEXTVAL,
359: 6,
360: nvl(g_debug_context, g_session_osuser || '$' || g_session_sid),
361: p_msg,
362: 'OUT',

Line 429: insert into PJI_SYSTEM_DEBUG_MSG

425: end if;
426:
427: if g_pa_debug_mode = 'Y' then
428:
429: insert into PJI_SYSTEM_DEBUG_MSG
430: (
431: MESSAGE_ID
432: , MESSAGE_LEVEL
433: , MESSAGE_CONTEXT

Line 442: PJI_SYSTEM_DEBUG_MSG_S.NEXTVAL

438: , CREATION_DATE
439: )
440: values
441: (
442: PJI_SYSTEM_DEBUG_MSG_S.NEXTVAL
443: , p_debug_level
444: , fnd_global.user_id || '$' || g_session_sid
445: , p_msg
446: , 'SSWA'