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;
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;
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:
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),
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;
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,