173:
174: EXCEPTION
175: WHEN no_data_found THEN
176:
177: fnd_message.set_name('CSI','CSI_INT_OE_LINE_ID_INVALID');
178: fnd_message.set_token('OE_LINE_ID', p_order_line_id);
179: fnd_msg_pub.add;
180: raise fnd_api.g_exc_error;
181: END;
174: EXCEPTION
175: WHEN no_data_found THEN
176:
177: fnd_message.set_name('CSI','CSI_INT_OE_LINE_ID_INVALID');
178: fnd_message.set_token('OE_LINE_ID', p_order_line_id);
179: fnd_msg_pub.add;
180: raise fnd_api.g_exc_error;
181: END;
182:
253: WHERE inventory_item_id = l_inventory_item_id
254: AND organization_id = l_vld_organization_id;
255: EXCEPTION
256: WHEN no_data_found THEN
257: fnd_message.set_name('CSI','CSI_INT_ITEM_ID_INVALID');
258: fnd_message.set_token('ITEM_ID', l_inventory_item_id);
259: fnd_message.set_token('ORGANIZATION_ID',l_vld_organization_id);
260: fnd_msg_pub.add;
261: raise fnd_api.g_exc_error;
254: AND organization_id = l_vld_organization_id;
255: EXCEPTION
256: WHEN no_data_found THEN
257: fnd_message.set_name('CSI','CSI_INT_ITEM_ID_INVALID');
258: fnd_message.set_token('ITEM_ID', l_inventory_item_id);
259: fnd_message.set_token('ORGANIZATION_ID',l_vld_organization_id);
260: fnd_msg_pub.add;
261: raise fnd_api.g_exc_error;
262: END;
255: EXCEPTION
256: WHEN no_data_found THEN
257: fnd_message.set_name('CSI','CSI_INT_ITEM_ID_INVALID');
258: fnd_message.set_token('ITEM_ID', l_inventory_item_id);
259: fnd_message.set_token('ORGANIZATION_ID',l_vld_organization_id);
260: fnd_msg_pub.add;
261: raise fnd_api.g_exc_error;
262: END;
263: --Code end for bug 6140021--
273: WHERE inventory_item_id = l_inventory_item_id
274: AND organization_id = l_vld_organization_id;
275: EXCEPTION
276: WHEN no_data_found THEN
277: fnd_message.set_name('CSI','CSI_INT_ITEM_ID_INVALID');
278: fnd_message.set_token('ITEM_ID', l_inventory_item_id);
279: fnd_message.set_token('ORGANIZATION_ID',l_vld_organization_id);
280: fnd_msg_pub.add;
281: raise fnd_api.g_exc_error;
274: AND organization_id = l_vld_organization_id;
275: EXCEPTION
276: WHEN no_data_found THEN
277: fnd_message.set_name('CSI','CSI_INT_ITEM_ID_INVALID');
278: fnd_message.set_token('ITEM_ID', l_inventory_item_id);
279: fnd_message.set_token('ORGANIZATION_ID',l_vld_organization_id);
280: fnd_msg_pub.add;
281: raise fnd_api.g_exc_error;
282: END;
275: EXCEPTION
276: WHEN no_data_found THEN
277: fnd_message.set_name('CSI','CSI_INT_ITEM_ID_INVALID');
278: fnd_message.set_token('ITEM_ID', l_inventory_item_id);
279: fnd_message.set_token('ORGANIZATION_ID',l_vld_organization_id);
280: fnd_msg_pub.add;
281: raise fnd_api.g_exc_error;
282: END;
283: END IF;
378: IF (l_num_threads <> 1) OR
379: (l_max_processes <> 1) THEN
380:
381: debug('SFM Manager Processes or Threads are not 1 so raising exception and logging error..');
382: fnd_message.set_name('CSI','CSI_SFM_THREAD_MP_ERROR');
383: l_error_rec.error_text := fnd_message.get;
384: RAISE publish_error;
385: END IF;
386: */
379: (l_max_processes <> 1) THEN
380:
381: debug('SFM Manager Processes or Threads are not 1 so raising exception and logging error..');
382: fnd_message.set_name('CSI','CSI_SFM_THREAD_MP_ERROR');
383: l_error_rec.error_text := fnd_message.get;
384: RAISE publish_error;
385: END IF;
386: */
387: