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: if ((P_MESSAGE_APP IS NOT NULL) and
567: (P_MESSAGE_NAME IS NOT NULL)) then

Line 799: INSERT INTO FND_LOG_MESSAGES (

795: /* log to table */
796: end if;
797:
798:
799: INSERT INTO FND_LOG_MESSAGES (
800: ECID_ID,
801: ECID_SEQ,
802: CALLSTACK,
803: ERRORSTACK,

Line 823: FND_LOG_MESSAGES_S.NEXTVAL

819: SUBSTRB(MESSAGE_TEXT, 1, 4000),
820: SESSION_ID_Z,
821: USER_ID_Z,
822: SYSDATE,
823: FND_LOG_MESSAGES_S.NEXTVAL
824: );
825:
826: commit;
827: end;

Line 985: select FND_LOG_MESSAGES_S.NEXTVAL

981:
982: /* This is the default Sequenced mode for AFLOG_BUFFER_MODE */
983: /* if ( AFLOG_BUFFER_MODE_X = 2 ) then */
984: -- Better to always do this so log_level>=4 messages are in sequence
985: select FND_LOG_MESSAGES_S.NEXTVAL
986: into LOG_SEQUENCE_TABLE(G_BUFFER_POS)
987: from dual;
988: /* end if; */
989:

Line 1026: INSERT INTO FND_LOG_MESSAGES (

1022: end if;
1023: else
1024:
1025:
1026: INSERT INTO FND_LOG_MESSAGES (
1027: ECID_ID,
1028: ECID_SEQ,
1029: CALLSTACK,
1030: ERRORSTACK,

Line 1059: FND_LOG_MESSAGES_S.NEXTVAL,

1055: SUBSTRB(MESSAGE_TEXT, 1, 4000),
1056: SESSION_ID,
1057: nvl(USER_ID, -1),
1058: SYSDATE,
1059: FND_LOG_MESSAGES_S.NEXTVAL,
1060: ENCODED,
1061: substrb(NODE,1,60),
1062: substrb(NODE_IP_ADDRESS,1,30),
1063: substrb(PROCESS_ID,1,120),

Line 1321: from fnd_log_messages flm

1317: WHEN NO_DATA_FOUND THEN
1318: begin
1319: select flm.log_sequence
1320: into l_log_sequence
1321: from fnd_log_messages flm
1322: where flm.log_sequence = P_LOG_SEQUENCE;
1323:
1324: -- If log_sequence does not exist in fnd_log_messages
1325: -- its an invalid log_sequence, return NULL

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

1320: into l_log_sequence
1321: from fnd_log_messages flm
1322: where flm.log_sequence = P_LOG_SEQUENCE;
1323:
1324: -- If log_sequence does not exist in fnd_log_messages
1325: -- its an invalid log_sequence, return NULL
1326: EXCEPTION
1327: WHEN NO_DATA_FOUND THEN
1328: LOG_BLOB := NULL;

Line 2025: select FND_LOG_MESSAGES_S.NEXTVAL

2021: GET_CONTEXT(CONTEXT_OUT => l_context);
2022: end if;
2023: end if;
2024:
2025: select FND_LOG_MESSAGES_S.NEXTVAL
2026: into LOG_SEQUENCE_OUT
2027: from dual;
2028:
2029: TIMESTAMP_OUT := sysdate;

Line 2075: INSERT INTO FND_LOG_MESSAGES (

2071: l_process_id := substrb(nvl(PROCESS_ID_IN, TXN_PROCESS),1,120);
2072: l_jvm_id := substrb(JVM_ID_IN,1,120);
2073:
2074: FORALL i IN 1..SIZE_IN
2075: INSERT INTO FND_LOG_MESSAGES (
2076: MODULE,
2077: LOG_LEVEL,
2078: MESSAGE_TEXT,
2079: SESSION_ID,

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

2096: MESSAGE_TEXT_IN(i),
2097: SESSION_ID_IN(i),
2098: nvl(USER_ID_IN(i), -1),
2099: nvl(TIMESTAMP_IN(i), sysdate),
2100: nvl(LOG_SEQUENCE_IN(i), FND_LOG_MESSAGES_S.NEXTVAL),
2101: ENCODED_IN(i),
2102: l_node,
2103: l_node_ip_address,
2104: l_process_id,