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