DBA Data[Home] [Help]

APPS.FND_LOG_REPOSITORY dependencies on FND_LOG_MESSAGES_S

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 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 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 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 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,