962: p_data => l_msg_data
963: );
964:
965: if l_msg_count > 0 then
966: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
967: FND_MESSAGE.Set_Name('OTA', 'OTA_OM_ERROR_MSG');
968: FND_MSG_PUB.ADD;
969: END IF;
970: end if;
964:
965: if l_msg_count > 0 then
966: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
967: FND_MESSAGE.Set_Name('OTA', 'OTA_OM_ERROR_MSG');
968: FND_MSG_PUB.ADD;
969: END IF;
970: end if;
971:
972: for k in 1 ..l_msg_count loop
973: x_msg_data := oe_msg_pub.get( p_msg_index => k,
974: p_encoded => 'F'
975: );
976:
977: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
978: FND_MESSAGE.Set_Name('OTA', 'OTA_OM_ERROR');
979: FND_MESSAGE.Set_Token('MSG_TXT', x_msg_data, FALSE);
980: FND_MSG_PUB.ADD;
981:
976:
977: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
978: FND_MESSAGE.Set_Name('OTA', 'OTA_OM_ERROR');
979: FND_MESSAGE.Set_Token('MSG_TXT', x_msg_data, FALSE);
980: FND_MSG_PUB.ADD;
981:
982: p_msg_data := x_msg_data;
983: END IF;
984: --dbms_output.put_line('Error msg: '||substr(x_msg_data,1,200));