eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_UC_INSTANCE_PVT dependencies on AHL_LTP_MTL_REQ_PVT

Line 6716: l_alt_items_tbl AHL_LTP_MTL_REQ_PVT.Alt_Items_Tbl_Type;

6712: l_dummy_char VARCHAR2(1);
6713: l_ignore_quant_vald VARCHAR2(1) := 'Y';
6714: l_wip_job_id NUMBER;
6715:
6716: l_alt_items_tbl AHL_LTP_MTL_REQ_PVT.Alt_Items_Tbl_Type;
6717: TYPE Ref_Tbl_Type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
6718: l_id_ref_map_Tbl Ref_Tbl_Type;
6719:
6720: -- Validate the p_inventory_item_id parameter

Line 6951: AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items(p_api_version => 1.0,

6947: END IF;
6948: END IF;
6949:
6950: -- Get the valid alternate items for this requirement after evaluating the SB rules
6951: AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items(p_api_version => 1.0,
6952: p_init_msg_list => FND_API.G_FALSE,
6953: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
6954: p_schedule_material_id => p_schedule_material_id,
6955: p_curr_item_flag => FND_API.G_TRUE,

Line 6964: 'AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items returned ' || l_return_status);

6960:
6961: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6962: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
6963: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
6964: 'AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items returned ' || l_return_status);
6965: END IF;
6966: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
6967: RAISE FND_API.G_EXC_ERROR;
6968: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 6976: 'Number of items returned by AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items ' || l_alt_items_tbl.COUNT);

6972: IF (l_alt_items_tbl IS NOT NULL AND l_alt_items_tbl.COUNT > 0) THEN
6973: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6974: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
6975: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
6976: 'Number of items returned by AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items ' || l_alt_items_tbl.COUNT);
6977: END IF;
6978: -- Copy into an associative array for quick lookup
6979: iIndex := l_alt_items_tbl.FIRST;
6980: LOOP

Line 7208: l_alt_items_tbl AHL_LTP_MTL_REQ_PVT.Alt_Items_Tbl_Type;

7204: l_ret_val VARCHAR2(1) := FND_API.G_FALSE;
7205: l_relationship_id NUMBER;
7206: l_mc_header_id NUMBER;
7207: l_inventory_item_id NUMBER;
7208: l_alt_items_tbl AHL_LTP_MTL_REQ_PVT.Alt_Items_Tbl_Type;
7209: l_api_version CONSTANT NUMBER := 1.0;
7210: l_return_status VARCHAR2(1);
7211: l_msg_count NUMBER;
7212: l_msg_data VARCHAR2(2000);

Line 7257: AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items(p_api_version => 1.0,

7253: CLOSE is_instance_valid;
7254: -- Validate against SB Rules if p_schedule_material_id is passed
7255: IF (p_schedule_material_id IS NOT NULL) THEN
7256: -- Get the valid alternate items for this requirement after evaluating the SB rules
7257: AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items(p_api_version => 1.0,
7258: p_init_msg_list => FND_API.G_FALSE,
7259: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
7260: p_schedule_material_id => p_schedule_material_id,
7261: p_curr_item_flag => FND_API.G_TRUE,

Line 7270: 'AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items returned ' || l_return_status);

7266:
7267: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7268: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
7269: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
7270: 'AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items returned ' || l_return_status);
7271: END IF;
7272: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
7273: -- Process the returned rows since AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items returned success
7274: IF (l_alt_items_tbl IS NOT NULL AND l_alt_items_tbl.COUNT > 0) THEN

Line 7273: -- Process the returned rows since AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items returned success

7269: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
7270: 'AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items returned ' || l_return_status);
7271: END IF;
7272: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
7273: -- Process the returned rows since AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items returned success
7274: IF (l_alt_items_tbl IS NOT NULL AND l_alt_items_tbl.COUNT > 0) THEN
7275: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7276: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
7277: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,

Line 7278: 'Number of items returned by AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items ' || l_alt_items_tbl.COUNT);

7274: IF (l_alt_items_tbl IS NOT NULL AND l_alt_items_tbl.COUNT > 0) THEN
7275: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7276: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
7277: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
7278: 'Number of items returned by AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items ' || l_alt_items_tbl.COUNT);
7279: END IF;
7280: -- Check in the result table if the instance's item is present
7281: iIndex := l_alt_items_tbl.FIRST;
7282: LOOP

Line 7299: 'Number of items returned by AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items is null or zero. Returning False.');

7295: ELSE
7296: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7297: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
7298: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
7299: 'Number of items returned by AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items is null or zero. Returning False.');
7300: END IF;
7301: END IF; -- l_alt_items_tbl.COUNT > 0
7302: ELSE
7303: -- AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items returned error status

Line 7303: -- AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items returned error status

7299: 'Number of items returned by AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items is null or zero. Returning False.');
7300: END IF;
7301: END IF; -- l_alt_items_tbl.COUNT > 0
7302: ELSE
7303: -- AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items returned error status
7304: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7305: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
7306: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
7307: 'Since AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items returned error, returning False.');

Line 7307: 'Since AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items returned error, returning False.');

7303: -- AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items returned error status
7304: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7305: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
7306: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
7307: 'Since AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items returned error, returning False.');
7308: END IF;
7309: END IF; -- l_return_status = FND_API.G_RET_STS_SUCCESS or not
7310: ELSE
7311: -- p_schedule_material_id is not passed: No need to validate against SB Rules: Return True