DBA Data[Home] [Help]

APPS.FND_LOG_ATTACHMENT dependencies on FND_LOG

Line 1: package body FND_LOG_ATTACHMENT as

1: package body FND_LOG_ATTACHMENT as
2: /* $Header: AFUTLGTB.pls 115.3 2004/05/05 02:06:53 kkapur noship $ */
3:
4: TYPE AttachmentsCache IS TABLE of LONG RAW
5: INDEX BY BINARY_INTEGER;

Line 18: FND_LOG_REPOSITORY.GET_BLOB_INTERNAL(PATTACHMENT_ID, myblob);

14: mylen number;
15: myblob BLOB;
16: begin
17: if (mCache.exists(PATTACHMENT_ID)) then
18: FND_LOG_REPOSITORY.GET_BLOB_INTERNAL(PATTACHMENT_ID, myblob);
19: myvar := mCache(PATTACHMENT_ID);
20: mylen := UTL_RAW.length(myvar);
21: if ( mylen > 0 ) then
22: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 22: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

18: FND_LOG_REPOSITORY.GET_BLOB_INTERNAL(PATTACHMENT_ID, myblob);
19: myvar := mCache(PATTACHMENT_ID);
20: mylen := UTL_RAW.length(myvar);
21: if ( mylen > 0 ) then
22: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
23: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'fnd.plsql.fnd_log_attachment.flush',
24: 'log_sequence=' || PATTACHMENT_ID || '; Message len=' || mylen);
25: end if;
26: DBMS_LOB.WRITEAPPEND(myblob, mylen, myvar);

Line 23: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'fnd.plsql.fnd_log_attachment.flush',

19: myvar := mCache(PATTACHMENT_ID);
20: mylen := UTL_RAW.length(myvar);
21: if ( mylen > 0 ) then
22: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
23: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'fnd.plsql.fnd_log_attachment.flush',
24: 'log_sequence=' || PATTACHMENT_ID || '; Message len=' || mylen);
25: end if;
26: DBMS_LOB.WRITEAPPEND(myblob, mylen, myvar);
27: commit;

Line 127: FND_LOG_REPOSITORY.GET_BLOB_INTERNAL(PATTACHMENT_ID, myblob, PCHARSET,

123: begin
124: if ( PATTACHMENT_ID > 0 ) then
125: flush(PATTACHMENT_ID);
126: table_len := PMESSAGE.COUNT;
127: FND_LOG_REPOSITORY.GET_BLOB_INTERNAL(PATTACHMENT_ID, myblob, PCHARSET,
128: PMIMETYPE, PENCODING, PLANG, PFILE_EXTN, PDESC);
129: if ( myblob is not NULL ) then
130: FOR i IN 1..table_len LOOP
131: msg_len := UTL_RAW.LENGTH(PMESSAGE(i));

Line 132: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

128: PMIMETYPE, PENCODING, PLANG, PFILE_EXTN, PDESC);
129: if ( myblob is not NULL ) then
130: FOR i IN 1..table_len LOOP
131: msg_len := UTL_RAW.LENGTH(PMESSAGE(i));
132: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
133: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'fnd.plsql.fnd_log_attachment.write',
134: 'log_sequence=' || PATTACHMENT_ID || '; LoopCtr=' || i ||
135: '; Message len=' || msg_len);
136: end if;

Line 133: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'fnd.plsql.fnd_log_attachment.write',

129: if ( myblob is not NULL ) then
130: FOR i IN 1..table_len LOOP
131: msg_len := UTL_RAW.LENGTH(PMESSAGE(i));
132: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
133: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'fnd.plsql.fnd_log_attachment.write',
134: 'log_sequence=' || PATTACHMENT_ID || '; LoopCtr=' || i ||
135: '; Message len=' || msg_len);
136: end if;
137: if ( msg_len > 0 ) then

Line 155: end FND_LOG_ATTACHMENT;

151: flush(PATTACHMENT_ID);
152: mCache.delete(PATTACHMENT_ID);
153: end CLOSE;
154:
155: end FND_LOG_ATTACHMENT;