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 288: msg_buf := FND_MESSAGE.GET_ENCODED(AUTO_LOG);

284: return l_sequence;
285: end if;
286:
287: if FND_LOG_REPOSITORY.CHECK_ACCESS_INTERNAL (MODULE, LOG_LEVEL) then
288: msg_buf := FND_MESSAGE.GET_ENCODED(AUTO_LOG);
289: l_sequence := STR_UNCHKED_INT_WITH_CONTEXT(
290: LOG_LEVEL => LOG_LEVEL,
291: MODULE => MODULE,
292: MESSAGE_TEXT => msg_buf,

Line 298: FND_MESSAGE.SET_ENCODED(msg_buf);

294:
295: /* No change in Message Stack if this PROCEDURE is called for Auto-Log = 'Y' */
296: if( (AUTO_LOG <> 'Y') and
297: ((pop_message = FALSE) OR (pop_message is NULL)) )then
298: FND_MESSAGE.SET_ENCODED(msg_buf);
299: end if;
300: end if;
301:
302: return l_sequence;

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

309:
310: /*
311: ** Writes a message to the log file if this level and module is enabled
312: ** This requires that the message was set previously with
313: ** FND_MESSAGE.SET_NAME, SET_TOKEN, etc.
314: ** The message is popped off the message dictionary stack, if POP_MESSAGE
315: ** is TRUE. Pass FALSE for POP_MESSAGE if the message will also be
316: ** displayed to the user later. If POP_MESSAGE isn't passed, the
317: ** message will not be popped off the stack, so it must be displayed

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

337: end;
338:
339: /*
340: ** Writes a message to the log file if this level and module is enabled
341: ** The message gets set previously with FND_MESSAGE.SET_NAME,
342: ** SET_TOKEN, etc.
343: ** The message is popped off the message dictionary stack, if POP_MESSAGE
344: ** is TRUE. Pass FALSE for POP_MESSAGE if the message will also be
345: ** displayed to the user later.

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

345: ** displayed to the user later.
346: ** Code Sample:
347: ** if( FND_LOG.LEVEL_UNEXPECTED >=
348: ** FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
349: ** FND_MESSAGE.SET_NAME(...); -- Set message
350: ** FND_MESSAGE.SET_TOKEN(...); -- Set token in message
351: ** ATTACHMENT_ID := FND_LOG.MESSAGE_WITH_ATTACHMENT(FND_LOG.LEVEL_UNEXPECTED,...,TRUE);
352: ** if ( ATTACHMENT_ID <> -1 ) then
353: ** -- For ASCII data use WRITE

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

346: ** Code Sample:
347: ** if( FND_LOG.LEVEL_UNEXPECTED >=
348: ** FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
349: ** FND_MESSAGE.SET_NAME(...); -- Set message
350: ** FND_MESSAGE.SET_TOKEN(...); -- Set token in message
351: ** ATTACHMENT_ID := FND_LOG.MESSAGE_WITH_ATTACHMENT(FND_LOG.LEVEL_UNEXPECTED,...,TRUE);
352: ** if ( ATTACHMENT_ID <> -1 ) then
353: ** -- For ASCII data use WRITE
354: ** FND_LOG_ATTACHMENT.WRITE(ATTACHMENT_ID, ...);

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

379:
380: /*
381: ** Writes a message with context to the log file if this level and
382: ** module is enabled. This requires that the message was set
383: ** previously with FND_MESSAGE.SET_NAME, SET_TOKEN, etc.
384: ** The message is popped off the message dictionary stack, if POP_MESSAGE
385: ** is TRUE. Pass FALSE for POP_MESSAGE if the message will also be
386: ** displayed to the user later. If POP_MESSAGE isn't passed, the
387: ** message will not be popped off the stack, so it must be displayed

Line 409: msg_buf := FND_MESSAGE.GET_ENCODED;

405: return;
406: end if;
407:
408: if FND_LOG_REPOSITORY.CHECK_ACCESS_INTERNAL (MODULE, LOG_LEVEL) then
409: msg_buf := FND_MESSAGE.GET_ENCODED;
410:
411: l_seq := STR_UNCHKED_INT_WITH_CONTEXT(
412: LOG_LEVEL => LOG_LEVEL,
413: MODULE => MODULE,

Line 424: FND_MESSAGE.SET_ENCODED(msg_buf);

420: THREAD_ID => THREAD_ID,
421: AUDSID => AUDSID,
422: DB_INSTANCE => DB_INSTANCE);
423: if((pop_message = FALSE) OR (pop_message is NULL))then
424: FND_MESSAGE.SET_ENCODED(msg_buf);
425: end if;
426:
427: end if;
428: end;

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

561: /*--------------------------------------------------------------+
562: | If LANG parameter is bad, set a message then continue in the |
563: | language of the current database session. |
564: +--------------------------------------------------------------*/
565: FND_MESSAGE.SET_NAME ('FND', 'SQL-Generic error');
566: FND_MESSAGE.SET_TOKEN ('ERRNO', sqlcode, FALSE);
567: FND_MESSAGE.SET_TOKEN ('REASON', sqlerrm, FALSE);
568: FND_MESSAGE.SET_TOKEN ('ROUTINE', 'FND_LOG.GET_TEXT', FALSE);
569: end;

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

562: | If LANG parameter is bad, set a message then continue in the |
563: | language of the current database session. |
564: +--------------------------------------------------------------*/
565: FND_MESSAGE.SET_NAME ('FND', 'SQL-Generic error');
566: FND_MESSAGE.SET_TOKEN ('ERRNO', sqlcode, FALSE);
567: FND_MESSAGE.SET_TOKEN ('REASON', sqlerrm, FALSE);
568: FND_MESSAGE.SET_TOKEN ('ROUTINE', 'FND_LOG.GET_TEXT', FALSE);
569: end;
570: end if;

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

563: | language of the current database session. |
564: +--------------------------------------------------------------*/
565: FND_MESSAGE.SET_NAME ('FND', 'SQL-Generic error');
566: FND_MESSAGE.SET_TOKEN ('ERRNO', sqlcode, FALSE);
567: FND_MESSAGE.SET_TOKEN ('REASON', sqlerrm, FALSE);
568: FND_MESSAGE.SET_TOKEN ('ROUTINE', 'FND_LOG.GET_TEXT', FALSE);
569: end;
570: end if;
571:

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

564: +--------------------------------------------------------------*/
565: FND_MESSAGE.SET_NAME ('FND', 'SQL-Generic error');
566: FND_MESSAGE.SET_TOKEN ('ERRNO', sqlcode, FALSE);
567: FND_MESSAGE.SET_TOKEN ('REASON', sqlerrm, FALSE);
568: FND_MESSAGE.SET_TOKEN ('ROUTINE', 'FND_LOG.GET_TEXT', FALSE);
569: end;
570: end if;
571:
572: begin

Line 573: FND_MESSAGE.PARSE_ENCODED(msg_text,

569: end;
570: end if;
571:
572: begin
573: FND_MESSAGE.PARSE_ENCODED(msg_text,
574: msg_app_short_name,
575: msg_name);
576: /* GET_STRING with Auto-Log = 'N' */
577: msg := FND_MESSAGE.GET_STRING(msg_app_short_name,

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

573: FND_MESSAGE.PARSE_ENCODED(msg_text,
574: msg_app_short_name,
575: msg_name);
576: /* GET_STRING with Auto-Log = 'N' */
577: msg := FND_MESSAGE.GET_STRING(msg_app_short_name,
578: msg_name, 'N');
579: exception
580: when others then
581: /*--------------------------------------------------------------+

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

579: exception
580: when others then
581: /*--------------------------------------------------------------+
582: | If it this is not really an encoded message, then |
583: | FND_MESSAGE.PARSE_ENCODED may have tried to put entire |
584: | msg_text in msg_app_short_name. |
585: +--------------------------------------------------------------*/
586: return msg_text;
587: end;

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

593: /* Get rid of msg_app_short_name, msg_name */
594: pos := INSTRB(msg_text, chr(0), 1, 2) + 1;
595: msg_text := SUBSTRB(msg_text, pos);
596:
597: /* Start the same routine from FND_MESSAGE.GET */
598: pos := 1;
599: data_size := LENGTH(msg_text);
600: while pos < data_size loop
601: tok_type := SUBSTR(msg_text, pos, 1);

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

614: pos := nextpos + 1;
615:
616: if (tok_type = 'Y') then /* translated token */
617: /* GET_STRING with Auto-Log = 'N' */
618: tok_val := FND_MESSAGE.GET_STRING(msg_app_short_name, tok_val, 'N');
619: elsif (tok_type = 'S') then /* SQL query token */
620: tok_val := FND_MESSAGE.FETCH_SQL_TOKEN(tok_val);
621: end if;
622: srch := '&' || tok_nam;

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

616: if (tok_type = 'Y') then /* translated token */
617: /* GET_STRING with Auto-Log = 'N' */
618: tok_val := FND_MESSAGE.GET_STRING(msg_app_short_name, tok_val, 'N');
619: elsif (tok_type = 'S') then /* SQL query token */
620: tok_val := FND_MESSAGE.FETCH_SQL_TOKEN(tok_val);
621: end if;
622: srch := '&' || tok_nam;
623: if (INSTR(msg, srch) <> 0) then
624: msg := SUBSTRB(REPLACE(msg, srch, tok_val),1,2000);