103: x_ais_items_tbl(l_index).return_status := l_line_tbl(l_index).return_status;
104: l_index := l_line_tbl.next(l_index);
105: END LOOP;
106:
107: oe_msg_pub.count_and_get
108: ( p_count => x_msg_count
109: , p_data => x_msg_data );
110:
111: x_return_status := l_return_status;
122: EXCEPTION
123:
124: WHEN FND_API.G_EXC_ERROR THEN
125: x_return_status := FND_API.G_RET_STS_ERROR;
126: oe_msg_pub.count_and_get
127: ( p_count => x_msg_count
128: , p_data => x_msg_data);
129:
130: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
128: , p_data => x_msg_data);
129:
130: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
132: oe_msg_pub.count_and_get
133: ( p_count => x_msg_count
134: , p_data => x_msg_data);
135:
136: WHEN OTHERS THEN
134: , p_data => x_msg_data);
135:
136: WHEN OTHERS THEN
137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
138: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
139: oe_msg_pub.Add_Exc_Msg
140: ( G_PKG_NAME
141: , 'Create_Items_Selected' );
142: END IF;
135:
136: WHEN OTHERS THEN
137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
138: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
139: oe_msg_pub.Add_Exc_Msg
140: ( G_PKG_NAME
141: , 'Create_Items_Selected' );
142: END IF;
143: oe_msg_pub.count_and_get
139: oe_msg_pub.Add_Exc_Msg
140: ( G_PKG_NAME
141: , 'Create_Items_Selected' );
142: END IF;
143: oe_msg_pub.count_and_get
144: ( p_count => x_msg_count
145: , p_data => x_msg_data);
146:
147: END create_items_selected;