234: LOOP
235: fnd_msg_pub.get
236: (p_data => l_msg_text,
237: p_msg_index_out => p_msg_count,
238: p_encoded => fnd_api.g_false,
239: p_msg_index => fnd_msg_pub.g_next
240: );
241: IF i = 1 THEN
242: p_msg_text := l_msg_text;
261: LOOP
262: fnd_msg_pub.get
263: (p_data => p_all_message(i),
264: p_msg_index_out => l_msg_count,
265: p_encoded => fnd_api.g_false,
266: p_msg_index => fnd_msg_pub.g_next
267: );
268: END LOOP;
269: EXCEPTION
290: IF i = 1 THEN
291: fnd_msg_pub.get
292: (p_data => l_msg_text,
293: p_msg_index_out => l_msg_index_out,
294: p_encoded => fnd_api.g_false,
295: p_msg_index => fnd_msg_pub.g_first
296: );
297: ELSE
298: fnd_msg_pub.get
297: ELSE
298: fnd_msg_pub.get
299: (p_data => l_msg_text,
300: p_msg_index_out => l_msg_index_out,
301: p_encoded => fnd_api.g_false,
302: p_msg_index => fnd_msg_pub.g_next
303: );
304: END IF;
305: IF l_msg_text IS NOT NULL THEN