eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_LOG_REPOSITORY dependencies on FND_LOG_MESSAGES

Line 66: G_PRX_SESSION_ID fnd_log_messages.session_id%TYPE;

62: index by binary_integer;
63:
64: /* For Proxy Alerting */
65: G_PRX_CHILD_TRANS_CONTEXT_ID NUMBER;
66: G_PRX_SESSION_ID fnd_log_messages.session_id%TYPE;
67: G_PRX_USER_ID fnd_log_messages.user_id%TYPE;
68: G_PRX_SESSION_MODULE fnd_log_exceptions.session_module%TYPE;
69: G_PRX_SESSION_ACTION fnd_log_exceptions.session_action%TYPE;
70: G_PRX_MODULE fnd_log_messages.module%TYPE;

Line 67: G_PRX_USER_ID fnd_log_messages.user_id%TYPE;

63:
64: /* For Proxy Alerting */
65: G_PRX_CHILD_TRANS_CONTEXT_ID NUMBER;
66: G_PRX_SESSION_ID fnd_log_messages.session_id%TYPE;
67: G_PRX_USER_ID fnd_log_messages.user_id%TYPE;
68: G_PRX_SESSION_MODULE fnd_log_exceptions.session_module%TYPE;
69: G_PRX_SESSION_ACTION fnd_log_exceptions.session_action%TYPE;
70: G_PRX_MODULE fnd_log_messages.module%TYPE;
71: G_PRX_NODE fnd_log_messages.node%TYPE;

Line 70: G_PRX_MODULE fnd_log_messages.module%TYPE;

66: G_PRX_SESSION_ID fnd_log_messages.session_id%TYPE;
67: G_PRX_USER_ID fnd_log_messages.user_id%TYPE;
68: G_PRX_SESSION_MODULE fnd_log_exceptions.session_module%TYPE;
69: G_PRX_SESSION_ACTION fnd_log_exceptions.session_action%TYPE;
70: G_PRX_MODULE fnd_log_messages.module%TYPE;
71: G_PRX_NODE fnd_log_messages.node%TYPE;
72: G_PRX_NODE_IP_ADDRESS fnd_log_messages.node_ip_address%TYPE;
73: G_PRX_PROCESS_ID fnd_log_messages.process_id%TYPE;
74: G_PRX_JVM_ID fnd_log_messages.jvm_id%TYPE;

Line 71: G_PRX_NODE fnd_log_messages.node%TYPE;

67: G_PRX_USER_ID fnd_log_messages.user_id%TYPE;
68: G_PRX_SESSION_MODULE fnd_log_exceptions.session_module%TYPE;
69: G_PRX_SESSION_ACTION fnd_log_exceptions.session_action%TYPE;
70: G_PRX_MODULE fnd_log_messages.module%TYPE;
71: G_PRX_NODE fnd_log_messages.node%TYPE;
72: G_PRX_NODE_IP_ADDRESS fnd_log_messages.node_ip_address%TYPE;
73: G_PRX_PROCESS_ID fnd_log_messages.process_id%TYPE;
74: G_PRX_JVM_ID fnd_log_messages.jvm_id%TYPE;
75: G_PRX_THREAD_ID fnd_log_messages.thread_id%TYPE;

Line 72: G_PRX_NODE_IP_ADDRESS fnd_log_messages.node_ip_address%TYPE;

68: G_PRX_SESSION_MODULE fnd_log_exceptions.session_module%TYPE;
69: G_PRX_SESSION_ACTION fnd_log_exceptions.session_action%TYPE;
70: G_PRX_MODULE fnd_log_messages.module%TYPE;
71: G_PRX_NODE fnd_log_messages.node%TYPE;
72: G_PRX_NODE_IP_ADDRESS fnd_log_messages.node_ip_address%TYPE;
73: G_PRX_PROCESS_ID fnd_log_messages.process_id%TYPE;
74: G_PRX_JVM_ID fnd_log_messages.jvm_id%TYPE;
75: G_PRX_THREAD_ID fnd_log_messages.thread_id%TYPE;
76: G_PRX_AUDSID fnd_log_messages.audsid%TYPE;

Line 73: G_PRX_PROCESS_ID fnd_log_messages.process_id%TYPE;

69: G_PRX_SESSION_ACTION fnd_log_exceptions.session_action%TYPE;
70: G_PRX_MODULE fnd_log_messages.module%TYPE;
71: G_PRX_NODE fnd_log_messages.node%TYPE;
72: G_PRX_NODE_IP_ADDRESS fnd_log_messages.node_ip_address%TYPE;
73: G_PRX_PROCESS_ID fnd_log_messages.process_id%TYPE;
74: G_PRX_JVM_ID fnd_log_messages.jvm_id%TYPE;
75: G_PRX_THREAD_ID fnd_log_messages.thread_id%TYPE;
76: G_PRX_AUDSID fnd_log_messages.audsid%TYPE;
77: G_PRX_DB_INSTANCE fnd_log_messages.db_instance%TYPE;

Line 74: G_PRX_JVM_ID fnd_log_messages.jvm_id%TYPE;

70: G_PRX_MODULE fnd_log_messages.module%TYPE;
71: G_PRX_NODE fnd_log_messages.node%TYPE;
72: G_PRX_NODE_IP_ADDRESS fnd_log_messages.node_ip_address%TYPE;
73: G_PRX_PROCESS_ID fnd_log_messages.process_id%TYPE;
74: G_PRX_JVM_ID fnd_log_messages.jvm_id%TYPE;
75: G_PRX_THREAD_ID fnd_log_messages.thread_id%TYPE;
76: G_PRX_AUDSID fnd_log_messages.audsid%TYPE;
77: G_PRX_DB_INSTANCE fnd_log_messages.db_instance%TYPE;
78:

Line 75: G_PRX_THREAD_ID fnd_log_messages.thread_id%TYPE;

71: G_PRX_NODE fnd_log_messages.node%TYPE;
72: G_PRX_NODE_IP_ADDRESS fnd_log_messages.node_ip_address%TYPE;
73: G_PRX_PROCESS_ID fnd_log_messages.process_id%TYPE;
74: G_PRX_JVM_ID fnd_log_messages.jvm_id%TYPE;
75: G_PRX_THREAD_ID fnd_log_messages.thread_id%TYPE;
76: G_PRX_AUDSID fnd_log_messages.audsid%TYPE;
77: G_PRX_DB_INSTANCE fnd_log_messages.db_instance%TYPE;
78:
79: /*

Line 76: G_PRX_AUDSID fnd_log_messages.audsid%TYPE;

72: G_PRX_NODE_IP_ADDRESS fnd_log_messages.node_ip_address%TYPE;
73: G_PRX_PROCESS_ID fnd_log_messages.process_id%TYPE;
74: G_PRX_JVM_ID fnd_log_messages.jvm_id%TYPE;
75: G_PRX_THREAD_ID fnd_log_messages.thread_id%TYPE;
76: G_PRX_AUDSID fnd_log_messages.audsid%TYPE;
77: G_PRX_DB_INSTANCE fnd_log_messages.db_instance%TYPE;
78:
79: /*
80: * For Proxy Alerting: Index values to use within CONTEXT_ARRAY.

Line 77: G_PRX_DB_INSTANCE fnd_log_messages.db_instance%TYPE;

73: G_PRX_PROCESS_ID fnd_log_messages.process_id%TYPE;
74: G_PRX_JVM_ID fnd_log_messages.jvm_id%TYPE;
75: G_PRX_THREAD_ID fnd_log_messages.thread_id%TYPE;
76: G_PRX_AUDSID fnd_log_messages.audsid%TYPE;
77: G_PRX_DB_INSTANCE fnd_log_messages.db_instance%TYPE;
78:
79: /*
80: * For Proxy Alerting: Index values to use within CONTEXT_ARRAY.
81: * This is mostly for code readability in order to avoid passing

Line 531: ** FND_LOG_MESSAGES.Log_Sequence

527: **
528: ** Arguments:
529: ** Module - Module name (See FND_LOG standards)
530: ** Message_Id - The unique identifier of the message from
531: ** FND_LOG_MESSAGES.Log_Sequence
532: */
533: FUNCTION POST_EXCEPTION ( P_MODULE IN VARCHAR2,
534: P_LOG_SEQUENCE IN NUMBER,
535: P_MESSAGE_APP IN VARCHAR2 DEFAULT NULL,

Line 563: from FND_LOG_MESSAGES

559: begin
560:
561: select MESSAGE_TEXT, TRANSACTION_CONTEXT_ID
562: into l_enc_msg, l_txn_id
563: from FND_LOG_MESSAGES
564: where LOG_SEQUENCE = P_LOG_SEQUENCE;
565:
566:
567:

Line 821: INSERT INTO FND_LOG_MESSAGES (

817: /* log to table */
818: end if;
819:
820:
821: INSERT INTO FND_LOG_MESSAGES (
822: ECID_ID,
823: ECID_SEQ,
824: CALLSTACK,
825: ERRORSTACK,

Line 845: FND_LOG_MESSAGES_S.NEXTVAL

841: SUBSTRB(MESSAGE_TEXT, 1, 4000),
842: SESSION_ID_Z,
843: USER_ID_Z,
844: SYSDATE,
845: FND_LOG_MESSAGES_S.NEXTVAL
846: );
847:
848: commit;
849: end;

Line 1007: select FND_LOG_MESSAGES_S.NEXTVAL

1003:
1004: /* This is the default Sequenced mode for AFLOG_BUFFER_MODE */
1005: /* if ( AFLOG_BUFFER_MODE_X = 2 ) then */
1006: -- Better to always do this so log_level>=4 messages are in sequence
1007: select FND_LOG_MESSAGES_S.NEXTVAL
1008: into LOG_SEQUENCE_TABLE(G_BUFFER_POS)
1009: from dual;
1010: /* end if; */
1011:

Line 1048: INSERT INTO FND_LOG_MESSAGES (

1044: end if;
1045: else
1046:
1047:
1048: INSERT INTO FND_LOG_MESSAGES (
1049: ECID_ID,
1050: ECID_SEQ,
1051: CALLSTACK,
1052: ERRORSTACK,

Line 1081: FND_LOG_MESSAGES_S.NEXTVAL,

1077: SUBSTRB(MESSAGE_TEXT, 1, 4000),
1078: SESSION_ID,
1079: nvl(USER_ID, -1),
1080: SYSDATE,
1081: FND_LOG_MESSAGES_S.NEXTVAL,
1082: ENCODED,
1083: substrb(NODE,1,60),
1084: substrb(NODE_IP_ADDRESS,1,30),
1085: substrb(PROCESS_ID,1,120),

Line 1343: from fnd_log_messages flm

1339: WHEN NO_DATA_FOUND THEN
1340: begin
1341: select flm.log_sequence
1342: into l_log_sequence
1343: from fnd_log_messages flm
1344: where flm.log_sequence = P_LOG_SEQUENCE;
1345:
1346: -- If log_sequence does not exist in fnd_log_messages
1347: -- its an invalid log_sequence, return NULL

Line 1346: -- If log_sequence does not exist in fnd_log_messages

1342: into l_log_sequence
1343: from fnd_log_messages flm
1344: where flm.log_sequence = P_LOG_SEQUENCE;
1345:
1346: -- If log_sequence does not exist in fnd_log_messages
1347: -- its an invalid log_sequence, return NULL
1348: EXCEPTION
1349: WHEN NO_DATA_FOUND THEN
1350: LOG_BLOB := NULL;

Line 2074: select FND_LOG_MESSAGES_S.NEXTVAL

2070: GET_CONTEXT(CONTEXT_OUT => l_context);
2071: end if;
2072: end if;
2073:
2074: select FND_LOG_MESSAGES_S.NEXTVAL
2075: into LOG_SEQUENCE_OUT
2076: from dual;
2077:
2078: TIMESTAMP_OUT := sysdate;

Line 2124: INSERT INTO FND_LOG_MESSAGES (

2120: l_process_id := substrb(nvl(PROCESS_ID_IN, TXN_PROCESS),1,120);
2121: l_jvm_id := substrb(JVM_ID_IN,1,120);
2122:
2123: FORALL i IN 1..SIZE_IN
2124: INSERT INTO FND_LOG_MESSAGES (
2125: MODULE,
2126: LOG_LEVEL,
2127: MESSAGE_TEXT,
2128: SESSION_ID,

Line 2149: nvl(LOG_SEQUENCE_IN(i), FND_LOG_MESSAGES_S.NEXTVAL),

2145: MESSAGE_TEXT_IN(i),
2146: SESSION_ID_IN(i),
2147: nvl(USER_ID_IN(i), -1),
2148: nvl(TIMESTAMP_IN(i), sysdate),
2149: nvl(LOG_SEQUENCE_IN(i), FND_LOG_MESSAGES_S.NEXTVAL),
2150: ENCODED_IN(i),
2151: l_node,
2152: l_node_ip_address,
2153: l_process_id,