[Home] [Help]
6657: -- Procedure get_instances_for_req
6658: -- This API is used to get all the instances for a given Position Based Material Requirement.
6659: -- It is similar to get_available_instances, but differs in the following ways:
6660: -- 1. It gets instances in Inventory also
6661: -- 2. It populates the global temp table AHL_APPLICABLE_INSTANCES instead of returing a table of instances.
6662: -- (POSITION_ID is set to p_relationship_id and not to the path position id)
6663: -- 3. It validates the item against the SB rules to return only instances that conform to SB rules if applicable.
6664: --
6665: -- Procedure name : get_instances_for_req
7023: 'After position validation. x_item_assoc_id = ' || l_item_assoc_id);
7024: END IF;
7025:
7026: IF (fnd_msg_pub.count_msg = 0) THEN
7027: INSERT INTO AHL_APPLICABLE_INSTANCES(CSI_ITEM_INSTANCE_ID, POSITION_ID)
7028: VALUES (l_instance_id, l_asm_details_rec.relationship_id);
7029: END IF; -- Message Count is zero
7030: fnd_msg_pub.initialize;
7031: ELSE
7041: CLOSE get_instance;
7042: END IF;
7043:
7044: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7045: select count(*) into iIndex from AHL_APPLICABLE_INSTANCES;
7046: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
7047: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
7048: 'Total number of records in AHL_APPLICABLE_INSTANCES: ' || iIndex);
7049: END IF;
7044: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7045: select count(*) into iIndex from AHL_APPLICABLE_INSTANCES;
7046: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
7047: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
7048: 'Total number of records in AHL_APPLICABLE_INSTANCES: ' || iIndex);
7049: END IF;
7050:
7051: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7052: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,