94: WHEN no_data_found THEN
95: IF (l_debug = 1) THEN
96: mydebug('No WDT line for that MMTT/MCCE');
97: END IF;
98: RAISE FND_API.g_exc_error;
99: END;
100: l_progress := '30';
101: IF (l_debug = 1) THEN
102: mydebug('WMSSKIPB: value of l_inventory_item_id ' || l_inventory_item_id);
189: mydebug('After Deleting from wms_dispatched_task');
190: END IF;
191: l_progress := '60';
192:
193: x_return_status:=FND_API.g_ret_sts_success;
194:
195: COMMIT;
196: IF (l_debug = 1) THEN
197: mydebug(x_return_status);
198: END IF;
199:
200: EXCEPTION
201:
202: WHEN FND_API.G_EXC_ERROR THEN
203: ROLLBACK TO sp_skip_task_adjustments;
204: x_return_status:=FND_API.G_RET_STS_ERROR;
205: fnd_msg_pub.count_and_get
206: ( p_count => x_msg_count
200: EXCEPTION
201:
202: WHEN FND_API.G_EXC_ERROR THEN
203: ROLLBACK TO sp_skip_task_adjustments;
204: x_return_status:=FND_API.G_RET_STS_ERROR;
205: fnd_msg_pub.count_and_get
206: ( p_count => x_msg_count
207: , p_data => x_msg_data
208: );
208: );
209:
210: WHEN OTHERS THEN
211: ROLLBACK TO sp_skip_task_adjustments;
212: x_return_status:=FND_API.g_ret_sts_unexp_error;
213: fnd_msg_pub.count_and_get
214: ( p_count => x_msg_count,
215: p_data => x_msg_data
216: );