DBA Data[Home] [Help]

APPS.AHL_PRD_DISPOSITION_PVT dependencies on AHL_PRD_PARTS_CHANGE_PVT

Line 1288: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'About to call AHL_PRD_PARTS_CHANGE_PVT.ReturnTo_Workorder_Locator with ' ||

1284: CLOSE part_change_dtls_csr;
1285: IF (l_removed_instance_id = p_x_disposition_rec.instance_id AND -- Removed instance is the Disposition instance
1286: NVL(l_part_change_type, 'X') IN ('R', 'S')) THEN -- Removal or Swap
1287: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1288: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'About to call AHL_PRD_PARTS_CHANGE_PVT.ReturnTo_Workorder_Locator with ' ||
1289: ' part change id = ' || p_x_disposition_rec.part_change_id ||
1290: ' and disposition_id = ' || p_x_disposition_rec.disposition_id);
1291: END IF;
1292: AHL_PRD_PARTS_CHANGE_PVT.ReturnTo_Workorder_Locator(p_part_change_id => p_x_disposition_rec.part_change_id,

Line 1292: AHL_PRD_PARTS_CHANGE_PVT.ReturnTo_Workorder_Locator(p_part_change_id => p_x_disposition_rec.part_change_id,

1288: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'About to call AHL_PRD_PARTS_CHANGE_PVT.ReturnTo_Workorder_Locator with ' ||
1289: ' part change id = ' || p_x_disposition_rec.part_change_id ||
1290: ' and disposition_id = ' || p_x_disposition_rec.disposition_id);
1291: END IF;
1292: AHL_PRD_PARTS_CHANGE_PVT.ReturnTo_Workorder_Locator(p_part_change_id => p_x_disposition_rec.part_change_id,
1293: p_disposition_id => p_x_disposition_rec.disposition_id,
1294: x_return_status => x_return_status,
1295: x_msg_data => x_msg_data,
1296: x_msg_count => x_msg_count,

Line 1300: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Returned from AHL_PRD_PARTS_CHANGE_PVT.ReturnTo_Workorder_Locator: ' ||

1296: x_msg_count => x_msg_count,
1297: x_ahl_mtltxn_rec => l_ahl_mtltxn_rec);
1298:
1299: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1300: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Returned from AHL_PRD_PARTS_CHANGE_PVT.ReturnTo_Workorder_Locator: ' ||
1301: ' x_return_status = ' || x_return_status);
1302: END IF;
1303: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1304: RAISE FND_API.G_EXC_ERROR;

Line 1459: l_move_item_ins_tbl AHL_PRD_PARTS_CHANGE_PVT.move_item_instance_tbl_type;

1455: l_ahl_mtltxn_rec AHL_PRD_MTLTXN_PVT.Ahl_Mtltxn_Rec_Type;
1456: l_dummy VARCHAR(1);
1457:
1458: -- SATHAPLI::Bug 7111116, 21-May-2008
1459: l_move_item_ins_tbl AHL_PRD_PARTS_CHANGE_PVT.move_item_instance_tbl_type;
1460: l_rel_nm_wo_id NUMBER;
1461: l_primary_sr_created BOOLEAN := FALSE;
1462:
1463: BEGIN

Line 2200: 'About to call the API AHL_PRD_PARTS_CHANGE_PVT.move_instance_location with the parameters:'||

2196: l_move_item_ins_tbl(1).to_workorder_id := l_rel_nm_wo_id;
2197:
2198: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2199: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key,
2200: 'About to call the API AHL_PRD_PARTS_CHANGE_PVT.move_instance_location with the parameters:'||
2201: ' instance_id => '||l_removed_instance_id||
2202: ' ,quantity => '||p_x_disposition_rec.quantity||
2203: ' ,to_workorder_id => '||l_rel_nm_wo_id);
2204: END IF;

Line 2207: AHL_PRD_PARTS_CHANGE_PVT.move_instance_location(

2203: ' ,to_workorder_id => '||l_rel_nm_wo_id);
2204: END IF;
2205:
2206: -- call the required API
2207: AHL_PRD_PARTS_CHANGE_PVT.move_instance_location(
2208: p_api_version => 1.0,
2209: p_init_msg_list => FND_API.G_FALSE,
2210: p_commit => FND_API.G_FALSE,
2211: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 2222: 'Call to the API AHL_PRD_PARTS_CHANGE_PVT.move_instance_location returned with status => '||x_return_status);

2218: );
2219:
2220: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2221: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key,
2222: 'Call to the API AHL_PRD_PARTS_CHANGE_PVT.move_instance_location returned with status => '||x_return_status);
2223: END IF;
2224:
2225: -- check the API call return status
2226: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 2259: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'About to call AHL_PRD_PARTS_CHANGE_PVT.ReturnTo_Workorder_Locator with ' ||

2255: CLOSE part_change_dtls_csr;
2256: IF (l_removed_instance_id = p_x_disposition_rec.instance_id AND -- Removed instance is the Disposition instance
2257: NVL(l_part_change_type, 'X') IN ('R', 'S')) THEN -- Removal or Swap
2258: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2259: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'About to call AHL_PRD_PARTS_CHANGE_PVT.ReturnTo_Workorder_Locator with ' ||
2260: ' part change id = ' || p_x_disposition_rec.part_change_id ||
2261: ' and disposition_id = ' || p_x_disposition_rec.disposition_id);
2262: END IF;
2263: AHL_PRD_PARTS_CHANGE_PVT.ReturnTo_Workorder_Locator(p_part_change_id => p_x_disposition_rec.part_change_id,

Line 2263: AHL_PRD_PARTS_CHANGE_PVT.ReturnTo_Workorder_Locator(p_part_change_id => p_x_disposition_rec.part_change_id,

2259: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'About to call AHL_PRD_PARTS_CHANGE_PVT.ReturnTo_Workorder_Locator with ' ||
2260: ' part change id = ' || p_x_disposition_rec.part_change_id ||
2261: ' and disposition_id = ' || p_x_disposition_rec.disposition_id);
2262: END IF;
2263: AHL_PRD_PARTS_CHANGE_PVT.ReturnTo_Workorder_Locator(p_part_change_id => p_x_disposition_rec.part_change_id,
2264: p_disposition_id => p_x_disposition_rec.disposition_id,
2265: x_return_status => x_return_status,
2266: x_msg_data => x_msg_data,
2267: x_msg_count => x_msg_count,

Line 2270: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Returned from AHL_PRD_PARTS_CHANGE_PVT.ReturnTo_Workorder_Locator: ' ||

2266: x_msg_data => x_msg_data,
2267: x_msg_count => x_msg_count,
2268: x_ahl_mtltxn_rec => l_ahl_mtltxn_rec);
2269: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2270: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Returned from AHL_PRD_PARTS_CHANGE_PVT.ReturnTo_Workorder_Locator: ' ||
2271: ' x_return_status = ' || x_return_status);
2272: END IF;
2273: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2274: RAISE FND_API.G_EXC_ERROR;

Line 3929: AHL_PRD_PARTS_CHANGE_PVT.Get_Unit_Config_Information(p_item_instance_id => NULL,

3925: FETCH instance_in_disp_csr INTO l_exist;
3926: IF instance_in_disp_csr%FOUND THEN
3927: -- Added by jaramana on August 7, 2007 to support IB Trees
3928: -- Allow duplicate instances for IB Trees when created from Part Change
3929: AHL_PRD_PARTS_CHANGE_PVT.Get_Unit_Config_Information(p_item_instance_id => NULL,
3930: p_workorder_id => p_workorder_id,
3931: x_unit_config_id => l_unit_config_id,
3932: x_unit_config_name => l_unit_config_name,
3933: x_return_status => l_return_status);