93: dbms_output.put_line(substr(l_msg_data,1,250));
94: dbms_output.put_line(substr(l_msg_data,250,250));
95: */
96: p_error := null;
97: IF (FND_MSG_PUB.Count_Msg > 1) THEN
98: --Display all the error messages
99: FOR j in 1..FND_MSG_PUB.Count_Msg LOOP
100: FND_MSG_PUB.Get(p_msg_index=>j,
101: p_encoded=>'F',
95: */
96: p_error := null;
97: IF (FND_MSG_PUB.Count_Msg > 1) THEN
98: --Display all the error messages
99: FOR j in 1..FND_MSG_PUB.Count_Msg LOOP
100: FND_MSG_PUB.Get(p_msg_index=>j,
101: p_encoded=>'F',
102: p_data=>l_msg_data,
103: p_msg_index_out=>l_msg_index_out);
96: p_error := null;
97: IF (FND_MSG_PUB.Count_Msg > 1) THEN
98: --Display all the error messages
99: FOR j in 1..FND_MSG_PUB.Count_Msg LOOP
100: FND_MSG_PUB.Get(p_msg_index=>j,
101: p_encoded=>'F',
102: p_data=>l_msg_data,
103: p_msg_index_out=>l_msg_index_out);
104: -- DBMS_OUTPUT.PUT_LINE(l_msg_data);
105: p_error := p_error || ' ' || l_msg_data;
106: END LOOP;
107: ELSE
108: --Only one error
109: FND_MSG_PUB.Get(p_msg_index=>1,
110: p_encoded=>'F',
111: p_data=>l_msg_data,
112: p_msg_index_out=>l_msg_index_out);
113: --DBMS_OUTPUT.PUT_LINE(l_msg_data);