710: temp varchar2(500);
711: BEGIN
712: mesg := '';
713:
714: l_msg_count := fnd_msg_pub.count_msg;
715: IF(l_msg_count>0) THEN
716:
717: msg_index := l_msg_count;
718:
716:
717: msg_index := l_msg_count;
718:
719: for i in 1..l_msg_count loop
720: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_NEXT,
721: p_encoded => 'F',
722: p_data => temp,
723: p_msg_index_out => msg_index);
724: msg_index := msg_index-1;