531: || ', p_entry_id = ' || p_entry_id);
532: END IF;
533:
534: -- first get the translated messages for the three statuses
535: l_msg_read := fnd_message.get_string('PON', 'PON_TD_READ');
536: l_msg_unread := fnd_message.get_string('PON', 'PON_TD_UNREAD');
537: l_msg_replied := fnd_message.get_string('PON', 'PON_TD_REPLIED');
538:
539: -- then we see if this is a sender or recipient with a record
532: END IF;
533:
534: -- first get the translated messages for the three statuses
535: l_msg_read := fnd_message.get_string('PON', 'PON_TD_READ');
536: l_msg_unread := fnd_message.get_string('PON', 'PON_TD_UNREAD');
537: l_msg_replied := fnd_message.get_string('PON', 'PON_TD_REPLIED');
538:
539: -- then we see if this is a sender or recipient with a record
540: SELECT decode(replied_flag, 'Y', l_msg_replied, decode(read_flag, 'Y', l_msg_read, l_msg_unread))
533:
534: -- first get the translated messages for the three statuses
535: l_msg_read := fnd_message.get_string('PON', 'PON_TD_READ');
536: l_msg_unread := fnd_message.get_string('PON', 'PON_TD_UNREAD');
537: l_msg_replied := fnd_message.get_string('PON', 'PON_TD_REPLIED');
538:
539: -- then we see if this is a sender or recipient with a record
540: SELECT decode(replied_flag, 'Y', l_msg_replied, decode(read_flag, 'Y', l_msg_read, l_msg_unread))
541: INTO l_message_status