201:
202: BEGIN
203: SELECT segment1
204: INTO l_item_code
205: FROM mtl_item_flexfields
206: WHERE inventory_item_id=p_mtl_movement_transaction.inventory_item_id
207: AND organization_id=p_mtl_movement_transaction.organization_id;
208:
209:
213: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
214: THEN
215: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
216: , G_MODULE_NAME || l_procedure_name
217: , 'There is no data in segment1 in mtl_item_flexfields for
218: item_id='||TO_CHAR(p_mtl_movement_transaction.inventory_item_id)
219: );
220: END IF;
221:
400:
401: BEGIN
402: SELECT segment1
403: INTO l_item_code
404: FROM mtl_item_flexfields
405: WHERE inventory_item_id=p_mtl_movement_transaction.inventory_item_id
406: AND organization_id=p_mtl_movement_transaction.organization_id;
407:
408:
412: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
413: THEN
414: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
415: , G_MODULE_NAME || l_procedure_name
416: , 'There is no data in segment1 in mtl_item_flexfields for
417: item_id='||TO_CHAR(p_mtl_movement_transaction.inventory_item_id)
418: );
419: END IF;
420: