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 dependencies on FND_MESSAGE

Line 44: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

40: procedure GENERIC_ERROR(routine in varchar2,
41: errcode in number,
42: errmsg in varchar2) is
43: begin
44: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
45: fnd_message.set_token('ROUTINE', routine);
46: fnd_message.set_token('ERRNO', errcode);
47: fnd_message.set_token('REASON', errmsg);
48: app_exception.raise_exception;

Line 45: fnd_message.set_token('ROUTINE', routine);

41: errcode in number,
42: errmsg in varchar2) is
43: begin
44: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
45: fnd_message.set_token('ROUTINE', routine);
46: fnd_message.set_token('ERRNO', errcode);
47: fnd_message.set_token('REASON', errmsg);
48: app_exception.raise_exception;
49: end;

Line 46: fnd_message.set_token('ERRNO', errcode);

42: errmsg in varchar2) is
43: begin
44: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
45: fnd_message.set_token('ROUTINE', routine);
46: fnd_message.set_token('ERRNO', errcode);
47: fnd_message.set_token('REASON', errmsg);
48: app_exception.raise_exception;
49: end;
50:

Line 47: fnd_message.set_token('REASON', errmsg);

43: begin
44: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
45: fnd_message.set_token('ROUTINE', routine);
46: fnd_message.set_token('ERRNO', errcode);
47: fnd_message.set_token('REASON', errmsg);
48: app_exception.raise_exception;
49: end;
50:
51:

Line 280: msg_buf := FND_MESSAGE.GET_ENCODED(AUTO_LOG);

276: return l_sequence;
277: end if;
278:
279: if FND_LOG_REPOSITORY.CHECK_ACCESS_INTERNAL (MODULE, LOG_LEVEL) then
280: msg_buf := FND_MESSAGE.GET_ENCODED(AUTO_LOG);
281: l_sequence := STR_UNCHKED_INT_WITH_CONTEXT(
282: LOG_LEVEL => LOG_LEVEL,
283: MODULE => MODULE,
284: MESSAGE_TEXT => msg_buf,

Line 290: FND_MESSAGE.SET_ENCODED(msg_buf);

286:
287: /* No change in Message Stack if this PROCEDURE is called for Auto-Log = 'Y' */
288: if( (AUTO_LOG <> 'Y') and
289: ((pop_message = FALSE) OR (pop_message is NULL)) )then
290: FND_MESSAGE.SET_ENCODED(msg_buf);
291: end if;
292: end if;
293:
294: return l_sequence;

Line 305: ** FND_MESSAGE.SET_NAME, SET_TOKEN, etc.

301:
302: /*
303: ** Writes a message to the log file if this level and module is enabled
304: ** This requires that the message was set previously with
305: ** FND_MESSAGE.SET_NAME, SET_TOKEN, etc.
306: ** The message is popped off the message dictionary stack, if POP_MESSAGE
307: ** is TRUE. Pass FALSE for POP_MESSAGE if the message will also be
308: ** displayed to the user later. If POP_MESSAGE isn't passed, the
309: ** message will not be popped off the stack, so it must be displayed

Line 333: ** The message gets set previously with FND_MESSAGE.SET_NAME,

329: end;
330:
331: /*
332: ** Writes a message to the log file if this level and module is enabled
333: ** The message gets set previously with FND_MESSAGE.SET_NAME,
334: ** SET_TOKEN, etc.
335: ** The message is popped off the message dictionary stack, if POP_MESSAGE
336: ** is TRUE. Pass FALSE for POP_MESSAGE if the message will also be
337: ** displayed to the user later.

Line 341: ** FND_MESSAGE.SET_NAME(...); -- Set message

337: ** displayed to the user later.
338: ** Code Sample:
339: ** if( FND_LOG.LEVEL_UNEXPECTED >=
340: ** FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
341: ** FND_MESSAGE.SET_NAME(...); -- Set message
342: ** FND_MESSAGE.SET_TOKEN(...); -- Set token in message
343: ** ATTACHMENT_ID := FND_LOG.MESSAGE_WITH_ATTACHMENT(FND_LOG.LEVEL_UNEXPECTED,...,TRUE);
344: ** if ( ATTACHMENT_ID <> -1 ) then
345: ** -- For ASCII data use WRITE

Line 342: ** FND_MESSAGE.SET_TOKEN(...); -- Set token in message

338: ** Code Sample:
339: ** if( FND_LOG.LEVEL_UNEXPECTED >=
340: ** FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
341: ** FND_MESSAGE.SET_NAME(...); -- Set message
342: ** FND_MESSAGE.SET_TOKEN(...); -- Set token in message
343: ** ATTACHMENT_ID := FND_LOG.MESSAGE_WITH_ATTACHMENT(FND_LOG.LEVEL_UNEXPECTED,...,TRUE);
344: ** if ( ATTACHMENT_ID <> -1 ) then
345: ** -- For ASCII data use WRITE
346: ** FND_LOG_ATTACHMENT.WRITE(ATTACHMENT_ID, ...);

Line 375: ** previously with FND_MESSAGE.SET_NAME, SET_TOKEN, etc.

371:
372: /*
373: ** Writes a message with context to the log file if this level and
374: ** module is enabled. This requires that the message was set
375: ** previously with FND_MESSAGE.SET_NAME, SET_TOKEN, etc.
376: ** The message is popped off the message dictionary stack, if POP_MESSAGE
377: ** is TRUE. Pass FALSE for POP_MESSAGE if the message will also be
378: ** displayed to the user later. If POP_MESSAGE isn't passed, the
379: ** message will not be popped off the stack, so it must be displayed

Line 401: msg_buf := FND_MESSAGE.GET_ENCODED;

397: return;
398: end if;
399:
400: if FND_LOG_REPOSITORY.CHECK_ACCESS_INTERNAL (MODULE, LOG_LEVEL) then
401: msg_buf := FND_MESSAGE.GET_ENCODED;
402:
403: l_seq := STR_UNCHKED_INT_WITH_CONTEXT(
404: LOG_LEVEL => LOG_LEVEL,
405: MODULE => MODULE,

Line 416: FND_MESSAGE.SET_ENCODED(msg_buf);

412: THREAD_ID => THREAD_ID,
413: AUDSID => AUDSID,
414: DB_INSTANCE => DB_INSTANCE);
415: if((pop_message = FALSE) OR (pop_message is NULL))then
416: FND_MESSAGE.SET_ENCODED(msg_buf);
417: end if;
418:
419: end if;
420: end;

Line 557: FND_MESSAGE.SET_NAME ('FND', 'SQL-Generic error');

553: /*--------------------------------------------------------------+
554: | If LANG parameter is bad, set a message then continue in the |
555: | language of the current database session. |
556: +--------------------------------------------------------------*/
557: FND_MESSAGE.SET_NAME ('FND', 'SQL-Generic error');
558: FND_MESSAGE.SET_TOKEN ('ERRNO', sqlcode, FALSE);
559: FND_MESSAGE.SET_TOKEN ('REASON', sqlerrm, FALSE);
560: FND_MESSAGE.SET_TOKEN ('ROUTINE', 'FND_LOG.GET_TEXT', FALSE);
561: end;

Line 558: FND_MESSAGE.SET_TOKEN ('ERRNO', sqlcode, FALSE);

554: | If LANG parameter is bad, set a message then continue in the |
555: | language of the current database session. |
556: +--------------------------------------------------------------*/
557: FND_MESSAGE.SET_NAME ('FND', 'SQL-Generic error');
558: FND_MESSAGE.SET_TOKEN ('ERRNO', sqlcode, FALSE);
559: FND_MESSAGE.SET_TOKEN ('REASON', sqlerrm, FALSE);
560: FND_MESSAGE.SET_TOKEN ('ROUTINE', 'FND_LOG.GET_TEXT', FALSE);
561: end;
562: end if;

Line 559: FND_MESSAGE.SET_TOKEN ('REASON', sqlerrm, FALSE);

555: | language of the current database session. |
556: +--------------------------------------------------------------*/
557: FND_MESSAGE.SET_NAME ('FND', 'SQL-Generic error');
558: FND_MESSAGE.SET_TOKEN ('ERRNO', sqlcode, FALSE);
559: FND_MESSAGE.SET_TOKEN ('REASON', sqlerrm, FALSE);
560: FND_MESSAGE.SET_TOKEN ('ROUTINE', 'FND_LOG.GET_TEXT', FALSE);
561: end;
562: end if;
563:

Line 560: FND_MESSAGE.SET_TOKEN ('ROUTINE', 'FND_LOG.GET_TEXT', FALSE);

556: +--------------------------------------------------------------*/
557: FND_MESSAGE.SET_NAME ('FND', 'SQL-Generic error');
558: FND_MESSAGE.SET_TOKEN ('ERRNO', sqlcode, FALSE);
559: FND_MESSAGE.SET_TOKEN ('REASON', sqlerrm, FALSE);
560: FND_MESSAGE.SET_TOKEN ('ROUTINE', 'FND_LOG.GET_TEXT', FALSE);
561: end;
562: end if;
563:
564: begin

Line 565: FND_MESSAGE.PARSE_ENCODED(msg_text,

561: end;
562: end if;
563:
564: begin
565: FND_MESSAGE.PARSE_ENCODED(msg_text,
566: msg_app_short_name,
567: msg_name);
568: /* GET_STRING with Auto-Log = 'N' */
569: msg := FND_MESSAGE.GET_STRING(msg_app_short_name,

Line 569: msg := FND_MESSAGE.GET_STRING(msg_app_short_name,

565: FND_MESSAGE.PARSE_ENCODED(msg_text,
566: msg_app_short_name,
567: msg_name);
568: /* GET_STRING with Auto-Log = 'N' */
569: msg := FND_MESSAGE.GET_STRING(msg_app_short_name,
570: msg_name, 'N');
571: exception
572: when others then
573: /*--------------------------------------------------------------+

Line 575: | FND_MESSAGE.PARSE_ENCODED may have tried to put entire |

571: exception
572: when others then
573: /*--------------------------------------------------------------+
574: | If it this is not really an encoded message, then |
575: | FND_MESSAGE.PARSE_ENCODED may have tried to put entire |
576: | msg_text in msg_app_short_name. |
577: +--------------------------------------------------------------*/
578: return msg_text;
579: end;

Line 589: /* Start the same routine from FND_MESSAGE.GET */

585: /* Get rid of msg_app_short_name, msg_name */
586: pos := INSTRB(msg_text, chr(0), 1, 2) + 1;
587: msg_text := SUBSTRB(msg_text, pos);
588:
589: /* Start the same routine from FND_MESSAGE.GET */
590: pos := 1;
591: data_size := LENGTH(msg_text);
592: while pos < data_size loop
593: tok_type := SUBSTR(msg_text, pos, 1);

Line 610: tok_val := FND_MESSAGE.GET_STRING(msg_app_short_name, tok_val, 'N');

606: pos := nextpos + 1;
607:
608: if (tok_type = 'Y') then /* translated token */
609: /* GET_STRING with Auto-Log = 'N' */
610: tok_val := FND_MESSAGE.GET_STRING(msg_app_short_name, tok_val, 'N');
611: elsif (tok_type = 'S') then /* SQL query token */
612: tok_val := FND_MESSAGE.FETCH_SQL_TOKEN(tok_val);
613: end if;
614: srch := '&' || tok_nam;

Line 612: tok_val := FND_MESSAGE.FETCH_SQL_TOKEN(tok_val);

608: if (tok_type = 'Y') then /* translated token */
609: /* GET_STRING with Auto-Log = 'N' */
610: tok_val := FND_MESSAGE.GET_STRING(msg_app_short_name, tok_val, 'N');
611: elsif (tok_type = 'S') then /* SQL query token */
612: tok_val := FND_MESSAGE.FETCH_SQL_TOKEN(tok_val);
613: end if;
614: srch := '&' || tok_nam;
615: if (INSTR(msg, srch) <> 0) then
616: msg := SUBSTRB(REPLACE(msg, srch, tok_val),1,2000);