517: --6434437, the tok_val variable was too small
518: --I also went ahead and modified msg_text and msg just in case
519: --the underlying columns are changed in the future.
520:
521: msg_text fnd_log_messages.message_text%type;
522: msg fnd_new_messages.message_text%type;
523: tok_val fnd_log_messages.message_text%type;
524:
525:
519: --the underlying columns are changed in the future.
520:
521: msg_text fnd_log_messages.message_text%type;
522: msg fnd_new_messages.message_text%type;
523: tok_val fnd_log_messages.message_text%type;
524:
525:
526: encoded varchar2(1);
527: msg_app_short_name varchar2(50);
538:
539: begin
540: select MESSAGE_TEXT, DECODE(ENCODED, 'Y', 'Y', 'N')
541: into msg_text, encoded
542: from FND_LOG_MESSAGES
543: where LOG_SEQUENCE = LOG_SEQUENCE_ID;
544:
545: if (encoded = 'N') then
546: return msg_text;